<vct:Grid Width="100%" ID="grdSubjects" runat="server" DataKeyNames="SUBJECT_ID"
                                                    Style="background-color: #c6def7;" ShowFooter="true" OnSorting="grdSubjects_Sorting"
                                                    OnRowDataBound="grdSubjects_RowDataBound">
                                                    <Columns>

</Columns>
                                                </vct:Grid>

protected void grdSubjects_RowDataBound(object sender, GridViewRowEventArgs e)
{
    switch (e.Row.RowType)
    {
        case DataControlRowType.DataRow:
            var cells = e.Row.Cells;
            var subject = e.Row.DataItem as VCT_SUBJECT;

            cells[9].Text = string.Format("<a href='subjectverify{1}.aspx?id={0}'>Verify</a>", subject.SUBJECT_ID, subject.ISMINOR ? "minor" : null);

            VCT_SUBJECT_VERIFICATION verify = subject.VCT_SUBJECT_VERIFICATIONs.FirstOrDefault();
            if (verify != null)
            {
                cells[2].Text = verify.UIC;
                cells[6].Text = verify.VERIFICATION_DATE.VCTDate();
                if(verify.SUBJECT_ID==subject.SUBJECT_ID)
                {
                    cells[12].Text = string.Format("<a href='subjecthistory.aspx?id={0}'>View</a>", verify.SUBJECT_ID);
                }
                if (verify.VERIFIED_BY_LOGIN_TYPE == "AD")
                {
                    var adminUser = Db.VCT_ADM_USERs.FirstOrDefault(x => x.USER_ID == verify.VERIFIED_BY_ID);
                    if (adminUser != null)
                        e.Row.Cells[13].Text = adminUser.FIRST_NAME + " " + adminUser.MIDDLE_NAME + " " + adminUser.LAST_NAME;
                }

                var status = verify.VCT_SUBJECT_STATUS.OrderByDescending(x => x.SUB_STATUS_ID).FirstOrDefault();
                if (status != null)
                {
                    cells[7].Text = status.STATUS.Replace(" ", "&nbsp;");
                    cells[8].Text = status.ACTUAL_DATE_OF_STATUS.VCTDate();
                    if (!string.IsNullOrEmpty(status.STATUS))
                        cells[9].Text = null;
                    if (string.Compare(status.STATUS, "Screen Failure") == 0 || string.Compare(status.STATUS, "Early Termination") == 0 || string.Compare(status.STATUS, "Completed") == 0 || string.Compare(status.STATUS, "Verification Failure") == 0)
                    {
                        var dt = status.ACTUAL_DATE_OF_STATUS.VCTDate();
                        var d = Convert.ToDateTime(dt);
                        var span = DateTime.Now.Subtract(d);
                        var days = span.Days;
                        if(days>=30)
                          cells[9].Text=  string.Format("<a href='subjectverify.aspx?id={0}'>Verify</a>",subject.SUBJECT_ID);
                    }

                    if (!string.IsNullOrEmpty(status.STATUS) && (string.Compare(status.STATUS, "Verification Failure", true) != 0 || string.Compare(status.STATUS, "In Screening", true) != 0 || string.Compare(status.STATUS, "Randomized", true) != 0))
                        cells[10].Text = string.Format("<a href='updatesubjectstatus.aspx?id={0}'>Update</a>", verify.SUB_VERIFICATION_ID);
                    if (!string.IsNullOrEmpty(status.STATUS) && (string.Compare(status.STATUS, "In Screening", true) == 0 || string.Compare(status.STATUS, "Randomized", true) == 0))
                        cells[11].Text = string.Format("<a href='subjectvisitschedule.aspx?id={0}'>Click Here</a>", verify.SUBJECT_ID);
                }

                var protocol = Db.VCT_SPONSOR_PROTOCOLs.FirstOrDefault(x => x.PROTOCOL_ID == verify.PROTOCOL_ID);
                if (protocol != null)
                {
                    cells[5].Text = protocol.PROTOCOL_NUMBER;
                }
            }
            else
                cells[5].Text = cells[6].Text = cells[7].Text = cells[8].Text = "- NOT ENROLLED -";
            break;
    }
}