protected void rgAuditList_ItemDataBound(object sender, GridItemEventArgs e) { if (e.Item is GridDataItem) { GridDataItem item = (GridDataItem)e.Item; HiddenField hf; Label lbl; EHSAuditData data = (EHSAuditData)e.Item.DataItem; lbl = (Label)e.Item.FindControl("lblAuditId"); lbl.Text = WebSiteCommon.FormatID(data.Audit.AUDIT_ID, 6); if (data.Audit.DESCRIPTION.Length > 120) { lbl = (Label)e.Item.FindControl("lblDescription"); lbl.Text = data.Audit.DESCRIPTION.Substring(0, 117) + "..."; } //lbl = (Label)e.Item.FindControl("lblDescription"); //lbl.Text = HttpUtility.HtmlEncode(lbl.Text); if (data.Person != null) { lbl = (Label)e.Item.FindControl("lblAuditBy"); lbl.Text = SQMModelMgr.FormatPersonListItem(data.Person); } lbl = (Label)e.Item.FindControl("lblAuditStatus"); if (data.Audit.CURRENT_STATUS == "C") { DateTime clsDate = (DateTime)data.Audit.CLOSE_DATE_DATA_COMPLETE; lbl.Text = WebSiteCommon.GetXlatValue("auditStatus", "C") + " " + SQMBasePage.FormatDate(clsDate, "d", false); } else { if (data.DaysToClose == 0) { DateTime tmp = ((DateTime)data.Audit.AUDIT_DT).AddDays(data.AuditType.DAYS_TO_COMPLETE); lbl.Text = WebSiteCommon.GetXlatValue("auditStatus", "X") + "<br/>(" + SQMBasePage.FormatDate(tmp, "d", false) + ")"; } else if (data.Audit.PERCENT_COMPLETE > 0) { lbl.Text = WebSiteCommon.GetXlatValue("auditStatus", "I") + "<br/>(" + data.DaysToClose + ")"; } else { lbl.Text = WebSiteCommon.GetXlatValue("auditStatus", "A") + "<br/>(" + data.DaysToClose + ")"; } } LinkButton lnk = (LinkButton)e.Item.FindControl("lbAuditId"); if (SessionManager.UserContext.Person.PERSON_ID == data.Person.PERSON_ID) { lnk.CommandArgument = data.Audit.AUDIT_ID.ToString() + "~" + data.Status; } else if (!data.Status.Equals("C")) { lnk.CommandArgument = data.Audit.AUDIT_ID.ToString() + "~D"; } else { lnk.CommandArgument = data.Audit.AUDIT_ID.ToString() + "~C"; } } }
protected void rgAuditList_ItemDataBound(object sender, GridItemEventArgs e) { if (e.Item is GridDataItem) { GridDataItem item = (GridDataItem)e.Item; HiddenField hf; Label lbl; EHSAuditData data = (EHSAuditData)e.Item.DataItem; LinkButton lnk = (LinkButton)e.Item.FindControl("lbAuditId"); lnk.Text = WebSiteCommon.FormatID(data.Audit.AUDIT_ID, 6); /* * if (data.Audit.DESCRIPTION.Length > 120) * { * lbl = (Label)e.Item.FindControl("lblDescription"); * lbl.Text = data.Audit.DESCRIPTION.Substring(0, 117) + "..."; * } */ //lbl = (Label)e.Item.FindControl("lblDescription"); //lbl.Text = HttpUtility.HtmlEncode(lbl.Text); if (data.Person != null) { lbl = (Label)e.Item.FindControl("lblAuditBy"); lbl.Text = SQMModelMgr.FormatPersonListItem(data.Person); } lbl = (Label)e.Item.FindControl("lblAuditStatus"); List <XLAT> TaskXLATList = SQMBasePage.SelectXLATList(new string[1] { "AUDIT_STATUS" }); if (data.Audit.CURRENT_STATUS == "C") { // TODO: This throws a null reference error when the database field is NULL (which is valid) DateTime clsDate = (DateTime)data.Audit.CLOSE_DATE_DATA_COMPLETE; lbl.Text = TaskXLATList.Where(l => l.XLAT_GROUP == "AUDIT_STATUS" && l.XLAT_CODE == "C").FirstOrDefault().DESCRIPTION + " " + SQMBasePage.FormatDate(clsDate, "d", false); // TODO: Possible fix //DateTime? clsDate = data.Audit.CLOSE_DATE; //if (data.Audit.CLOSE_DATE_DATA_COMPLETE.HasValue) //{ // clsDate = data.Audit.CLOSE_DATE_DATA_COMPLETE; //} //if (clsDate.HasValue) //{ // lbl.Text = TaskXLATList.Where(l => l.XLAT_GROUP == "AUDIT_STATUS" && l.XLAT_CODE == "C").FirstOrDefault().DESCRIPTION + " " + SQMBasePage.FormatDate(clsDate.Value, "d", false); //} } else { if (data.DaysToClose == 0) { DateTime tmp = ((DateTime)data.Audit.AUDIT_DT).AddDays(data.AuditType.DAYS_TO_COMPLETE); lbl.Text = TaskXLATList.Where(l => l.XLAT_GROUP == "AUDIT_STATUS" && l.XLAT_CODE == "X").FirstOrDefault().DESCRIPTION + "<br/>(" + SQMBasePage.FormatDate(tmp, "d", false) + ")"; } else if (data.Audit.PERCENT_COMPLETE > 0) { lbl.Text = TaskXLATList.Where(l => l.XLAT_GROUP == "AUDIT_STATUS" && l.XLAT_CODE == "I").FirstOrDefault().DESCRIPTION + "<br/>(" + data.DaysToClose + ")"; } else { lbl.Text = TaskXLATList.Where(l => l.XLAT_GROUP == "AUDIT_STATUS" && l.XLAT_CODE == "A").FirstOrDefault().DESCRIPTION + "<br/>(" + data.DaysToClose + ")"; } } lnk = (LinkButton)e.Item.FindControl("lbAuditId"); LinkButton lnkReAudit = (LinkButton)e.Item.FindControl("lbReAudit"); Label lblAuditingId = (Label)e.Item.FindControl("lblAuditingId"); HiddenField hdnId = (HiddenField)e.Item.FindControl("hdnAuditingId"); if (allowReAudits.ToUpper().Equals("Y")) { if (SessionManager.CheckUserPrivilege(SysPriv.admin, SysScope.audit)) { if (hdnId.Value.ToString().Trim().Equals("0") || hdnId.Value.ToString().Trim().Equals("")) { lblAuditingId.Visible = false; } else { lnkReAudit.Visible = false; lblAuditingId.Text = Resources.LocalizedText.ReAuditing + " " + hdnId.Value.ToString(); } } else { lnkReAudit.Visible = false; lblAuditingId.Visible = false; } } else { lnkReAudit.Visible = false; lblAuditingId.Visible = false; } if (SessionManager.UserContext.Person.PERSON_ID == data.Person.PERSON_ID) { lnk.CommandArgument = data.Audit.AUDIT_ID.ToString() + "~" + data.Status; lnkReAudit.Visible = false; //lblAuditingId.Visible = false; } else if (!data.Status.Equals("C")) { lnk.CommandArgument = data.Audit.AUDIT_ID.ToString() + "~D"; } else { lnk.CommandArgument = data.Audit.AUDIT_ID.ToString() + "~C"; } } }