/// <summary> /// to fetch all details /// </summary> /// <returns></returns> public GrievanceList Getcategory() { OracleConnection con = new OracleConnection(AppConfiguration.ConnectionString); OracleCommand cmd; string proc = "USP_TRN_GET_GRIEV_CATEGORY"; cmd = new OracleCommand(proc, con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("Sp_recordset", OracleDbType.RefCursor).Direction = ParameterDirection.Output; cmd.Connection.Open(); OracleDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection); GrievancesBO BOobj = null; GrievanceList Listobj = new GrievanceList(); while (dr.Read()) { BOobj = new GrievancesBO(); BOobj.GrievCategoryID = (Convert.ToInt32(dr.GetValue(dr.GetOrdinal("GRIEVANCECATEGID")))); BOobj.GrievCategory = dr.GetValue(dr.GetOrdinal("GRIEVANCECATEGORY")).ToString(); Listobj.Add(BOobj); } dr.Close(); return(Listobj); }
/// <summary> /// to fetch all details /// </summary> /// <param name="householdID"></param> /// <returns></returns> public GrievanceList Getgrievancedata(int householdID) { OracleConnection cnn = new OracleConnection(AppConfiguration.ConnectionString); OracleCommand cmd; string proc = "USP_TRN_SEL_GRIEVANCE"; cmd = new OracleCommand(proc, cnn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("HHID_", householdID); cmd.Parameters.Add("Sp_recordset", Oracle.DataAccess.Client.OracleDbType.RefCursor).Direction = ParameterDirection.Output; cmd.Connection.Open(); OracleDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection); GrievancesBO GrievancesBOObj = null; GrievanceList GrievanceListObj = new GrievanceList(); while (dr.Read()) { GrievancesBOObj = new GrievancesBO(); if (!dr.IsDBNull(dr.GetOrdinal("GRIEVANCEID"))) { GrievancesBOObj.GrievanceID = Convert.ToInt32(dr.GetValue(dr.GetOrdinal("GRIEVANCEID"))); } if (!dr.IsDBNull(dr.GetOrdinal("PAPNAME"))) { GrievancesBOObj.PapName = dr.GetString(dr.GetOrdinal("PAPNAME")); } if (!dr.IsDBNull(dr.GetOrdinal("GRIEVANCECATEGORY"))) { GrievancesBOObj.GrievCategory = dr.GetString(dr.GetOrdinal("GRIEVANCECATEGORY")); } if (!dr.IsDBNull(dr.GetOrdinal("CREATEDDATE"))) { GrievancesBOObj.CreatedDate = dr.GetDateTime(dr.GetOrdinal("CREATEDDATE")); } if (!dr.IsDBNull(dr.GetOrdinal("GREVDESCRIPTION"))) { GrievancesBOObj.Description = dr.GetString(dr.GetOrdinal("GREVDESCRIPTION")); } if (!dr.IsDBNull(dr.GetOrdinal("ISDELETED"))) { GrievancesBOObj.IsDeleted = dr.GetString(dr.GetOrdinal("ISDELETED")); } if (!dr.IsDBNull(dr.GetOrdinal("RESOLUTIONSTATUS"))) { GrievancesBOObj.ResolutionStatus = dr.GetString(dr.GetOrdinal("RESOLUTIONSTATUS")); } GrievanceListObj.Add(GrievancesBOObj); } dr.Close(); return(GrievanceListObj); }
/// <summary> /// to assign the data from database to the textbox's districtTextBox, countyTextBox /// subcountyTextBox,parishTextBox,villageTextBox /// </summary> /// <param name="hhid"></param> private void screenIntialization(int hhid) { GrievancesBLL objGrievancesBLL = new GrievancesBLL(); GrievancesBO GrievancesBOobj = new GrievancesBO(); GrievancesBOobj = objGrievancesBLL.getscreenIntialization(hhid); districtTextBox.Text = GrievancesBOobj.District; countyTextBox.Text = GrievancesBOobj.County; subcountyTextBox.Text = GrievancesBOobj.SubCounty; parishTextBox.Text = GrievancesBOobj.Parish; villageTextBox.Text = GrievancesBOobj.Village; }
/// <summary> /// To Insert into Database /// </summary> /// <param name="GrievancesBOobj"></param> /// <returns></returns> public int Insert(GrievancesBO GrievancesBOobj) { GrievancesDAL GrievancesDALobj = new GrievancesDAL(); //Data pass -to Database Layer try { return(GrievancesDALobj.Insert(GrievancesBOobj)); } catch { throw; } finally { GrievancesDALobj = null; } }
/// <summary> /// get Grievance data from database /// </summary> public void getGrievance() { GrievancesBLL objGrievancesBLL = new GrievancesBLL(); GrievancesBO GrievancesBOobj = new GrievancesBO(); //GrievancesBO GrievancesBOobj = (new GrievancesBLL()).getGrievance(Convert.ToInt32(ViewState["GrievanceID"])); //if (GrievancesBOobj != null) // lblCategoryAssign.Text = GrievancesBOobj.GrievCategory; //lblCreatedDateAssign.Text = GrievancesBOobj.CreatedDate.ToString(); //descriptionTextBox.Text = GrievancesBOobj.Description; int GrievanceID = Convert.ToInt32(ViewState["GrievanceID"]); GrievancesBOobj = objGrievancesBLL.GetGrievanceClosure(GrievanceID); if (GrievancesBOobj != null) { lblCategoryAssign.Text = GrievancesBOobj.GrievCategory; lblCreatedDateAssign.Text = GrievancesBOobj.CreatedDate.ToString(UtilBO.DateFormatFull); txtClosureComments.Text = GrievancesBOobj.ClosureComments; } }
/// <summary> /// update Grievance status to close /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btnClose_Click(object sender, EventArgs e) { string updateStatus = "C"; GrievancesBO objGrievance = new GrievancesBO(); objGrievance.Hhid = Convert.ToInt32(Session["HH_ID"]); objGrievance.GrievanceID = Convert.ToInt32(ViewState["GrievanceID"]); if (txtClosureComments.Text.Length > 499) { objGrievance.ClosureComments = txtClosureComments.Text.Trim().Substring(0, 499); } else { objGrievance.ClosureComments = txtClosureComments.Text.Trim(); } objGrievance.UpdatedBy = Convert.ToInt32(Session["USER_ID"]); objGrievance.ResolutionStatus = updateStatus; MyTasks_ApprovalBLL objMytaskApprovalBLL = new MyTasks_ApprovalBLL(); objMytaskApprovalBLL.UPdateGrievance(objGrievance); ClientScript.RegisterStartupScript(this.GetType(), "GrivanceClosure", "GrivanceClosure();", true); }
/// <summary> /// to update data /// </summary> /// <param name="GrievancesBOobj"></param> /// <returns></returns> public int EditGRIEVANCE(GrievancesBO GrievancesBOobj) { OracleConnection cnn = new OracleConnection(AppConfiguration.ConnectionString); cnn.Open(); OracleCommand dcmd = new OracleCommand("USP_TRN_UPD_GRIEVANCE", cnn); dcmd.CommandType = CommandType.StoredProcedure; int count = Convert.ToInt32(dcmd.CommandType); try { dcmd.Parameters.Add("R_GRIEVANCEID", GrievancesBOobj.GrievanceID); dcmd.Parameters.Add("R_GRIEVANCECATEGID", GrievancesBOobj.GrievCategoryID); dcmd.Parameters.Add("R_GREVDESCRIPTION", GrievancesBOobj.Description); dcmd.Parameters.Add("R_ACTIONTAKEN", GrievancesBOobj.ActionTaken); if (GrievancesBOobj.ActionTakenDate != DateTime.MinValue) { dcmd.Parameters.Add("R_ACTIONTAKENDATE", GrievancesBOobj.ActionTakenDate); } else { dcmd.Parameters.Add("R_ACTIONTAKENDATE", DBNull.Value); } if (GrievancesBOobj.ActionTakenBy > 0) { dcmd.Parameters.Add("ACTIONTAKENBY", GrievancesBOobj.ActionTakenBy); } else { dcmd.Parameters.Add("ACTIONTAKENBY", DBNull.Value); } dcmd.Parameters.Add("R_BASICFACTS", GrievancesBOobj.BasicFacts); dcmd.Parameters.Add("R_RESOLUTION", GrievancesBOobj.Resolution); if (GrievancesBOobj.ResolutionDate != DateTime.MinValue) { dcmd.Parameters.Add("R_RESOLUTIONDATE", GrievancesBOobj.ResolutionDate); } else { dcmd.Parameters.Add("R_RESOLUTIONDATE", DBNull.Value); } if (GrievancesBOobj.ResolvedBy > 0) { dcmd.Parameters.Add("R_RESOLVEDBY", GrievancesBOobj.ResolvedBy); } else { dcmd.Parameters.Add("R_RESOLVEDBY", DBNull.Value); } dcmd.Parameters.Add("R_UPDATEDBY", GrievancesBOobj.CreatedBy); dcmd.Parameters.Add("ResolutionStatus_", GrievancesBOobj.ResolutionStatus); return(dcmd.ExecuteNonQuery()); } catch { throw; } finally { dcmd.Dispose(); cnn.Close(); cnn.Dispose(); } }
/// <summary> /// to fetch all details /// </summary> /// <param name="GrievanceID"></param> /// <returns></returns> public GrievancesBO GetGrievancedatarow(int GrievanceID) { OracleConnection cnn = new OracleConnection(AppConfiguration.ConnectionString); OracleCommand cmd; string proc = "USP_TRN_GET_GRIEVANCE"; cmd = new OracleCommand(proc, cnn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("R_GRIEVANCEID", GrievanceID); cmd.Parameters.Add("Sp_recordset", OracleDbType.RefCursor).Direction = ParameterDirection.Output; cmd.Connection.Open(); OracleDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection); GrievancesBO GrievancesBOObj = null; GrievanceList GrievanceListObj = new GrievanceList(); GrievancesBOObj = new GrievancesBO(); while (dr.Read()) { if (!dr.IsDBNull(dr.GetOrdinal("grievanceid"))) { GrievancesBOObj.GrievanceID = Convert.ToInt32(dr.GetValue(dr.GetOrdinal("grievanceid"))); } if (!dr.IsDBNull(dr.GetOrdinal("grievancecategid"))) { GrievancesBOObj.GrievCategoryID = Convert.ToInt32(dr.GetValue(dr.GetOrdinal("grievancecategid"))); } if (!dr.IsDBNull(dr.GetOrdinal("grevdescription"))) { GrievancesBOObj.Description = Convert.ToString(dr.GetValue(dr.GetOrdinal("grevdescription"))); } if (!dr.IsDBNull(dr.GetOrdinal("actiontaken"))) { GrievancesBOObj.ActionTaken = Convert.ToString(dr.GetValue(dr.GetOrdinal("actiontaken"))); } if (!dr.IsDBNull(dr.GetOrdinal("actiontakendate"))) { GrievancesBOObj.ActionTakenDate = Convert.ToDateTime(dr.GetValue(dr.GetOrdinal("actiontakendate"))); } if (!dr.IsDBNull(dr.GetOrdinal("actiontakenby"))) { GrievancesBOObj.ActionTakenBy = Convert.ToInt32(dr.GetValue(dr.GetOrdinal("actiontakenby"))); } if (!dr.IsDBNull(dr.GetOrdinal("basicfacts"))) { GrievancesBOObj.BasicFacts = Convert.ToString(dr.GetValue(dr.GetOrdinal("basicfacts"))); } if (!dr.IsDBNull(dr.GetOrdinal("resolution"))) { GrievancesBOObj.Resolution = Convert.ToString(dr.GetValue(dr.GetOrdinal("resolution"))); } if (!dr.IsDBNull(dr.GetOrdinal("resolutiondate"))) { GrievancesBOObj.ResolutionDate = Convert.ToDateTime(dr.GetValue(dr.GetOrdinal("resolutiondate"))); } if (!dr.IsDBNull(dr.GetOrdinal("resolvedby"))) { GrievancesBOObj.ResolvedBy = Convert.ToInt32(dr.GetValue(dr.GetOrdinal("resolvedby"))); } } dr.Close(); return(GrievancesBOObj); }
/// <summary> /// to fetch all details /// </summary> /// <param name="hhid"></param> /// <returns></returns> public GrievancesBO getscreenIntialization(int hhid) { OracleConnection cnn = new OracleConnection(AppConfiguration.ConnectionString); OracleCommand cmd; string proc = "USP_MST_GET_GRIEVANCEIDDATA"; cmd = new OracleCommand(proc, cnn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("hhid_", hhid); cmd.Parameters.Add("Sp_recordset", OracleDbType.RefCursor).Direction = ParameterDirection.Output; cmd.Connection.Open(); OracleDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection); GrievancesBO GrievancesBOObj = null; GrievanceList GrievanceListObj = new GrievanceList(); GrievancesBOObj = new GrievancesBO(); while (dr.Read()) { if (ColumnExists(dr, "HHID") && !dr.IsDBNull(dr.GetOrdinal("HHID"))) { GrievancesBOObj.Hhid = Convert.ToInt32(dr.GetValue(dr.GetOrdinal("HHID"))); } if (ColumnExists(dr, "PAPNAME") && !dr.IsDBNull(dr.GetOrdinal("PAPNAME"))) { GrievancesBOObj.PapName = dr.GetString(dr.GetOrdinal("PAPNAME")); } if (ColumnExists(dr, "PLOTREFERENCE") && !dr.IsDBNull(dr.GetOrdinal("PLOTREFERENCE"))) { GrievancesBOObj.PlotReference = dr.GetString(dr.GetOrdinal("PLOTREFERENCE")); } if (ColumnExists(dr, "DISTRICT") && !dr.IsDBNull(dr.GetOrdinal("DISTRICT"))) { GrievancesBOObj.District = dr.GetString(dr.GetOrdinal("DISTRICT")); } if (ColumnExists(dr, "COUNTY") && !dr.IsDBNull(dr.GetOrdinal("COUNTY"))) { GrievancesBOObj.County = dr.GetString(dr.GetOrdinal("COUNTY")); } if (ColumnExists(dr, "SUBCOUNTY") && !dr.IsDBNull(dr.GetOrdinal("SUBCOUNTY"))) { GrievancesBOObj.SubCounty = dr.GetString(dr.GetOrdinal("SUBCOUNTY")); } if (ColumnExists(dr, "PARISH") && !dr.IsDBNull(dr.GetOrdinal("PARISH"))) { GrievancesBOObj.Parish = dr.GetString(dr.GetOrdinal("PARISH")); } if (ColumnExists(dr, "VILLAGE") && !dr.IsDBNull(dr.GetOrdinal("VILLAGE"))) { GrievancesBOObj.Village = dr.GetString(dr.GetOrdinal("VILLAGE")); } } dr.Close(); return(GrievancesBOObj); }
/// <summary> /// To UPdate Grievance /// </summary> /// <param name="objGrievance"></param> /// public void UPdateGrievance(GrievancesBO objGrievance) { MyTasks_ApprovalDAL objMyTaskApprovalDAL = new MyTasks_ApprovalDAL(); objMyTaskApprovalDAL.UPdateGrievance(objGrievance); }
/// <summary> /// to Save the data to the database /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btnSave_Click(object sender, EventArgs e) { int count = 0; string descriptionText = ""; string message = ""; GrievancesBLL objGrievancesBLL = new GrievancesBLL(); GrievancesBO GrievancesBOobj = null; if (Convert.ToInt32(ViewState["GRIEVANCEID"]) > 0) { try { string hhid = Session["HH_ID"].ToString(); GrievancesBOobj = new GrievancesBO(); GrievancesBOobj.GrievanceID = Convert.ToInt32(ViewState["GRIEVANCEID"]); GrievancesBOobj.GrievCategoryID = Convert.ToInt32(categoryDropDownList.SelectedValue); descriptionText = descriptionTextBox.Text.Trim(); if (descriptionText.Length >= 1000) { descriptionText = descriptionText.Substring(0, 1000); } GrievancesBOobj.Description = descriptionText; descriptionText = actionTextBox.Text.Trim(); if (descriptionText.Length >= 500) { descriptionText = descriptionText.Substring(0, 500); } GrievancesBOobj.ActionTaken = descriptionText; if (actionDatePicker.Text.Trim() != "") { GrievancesBOobj.ActionTakenDate = Convert.ToDateTime(actionDatePicker.Text.ToString()); } GrievancesBOobj.ActionTakenBy = Convert.ToInt32(actionDropDownList.SelectedValue.ToString().Trim()); descriptionText = basicTextBox.Text.Trim(); if (descriptionText.Length >= 500) { descriptionText = descriptionText.Substring(0, 500); } GrievancesBOobj.BasicFacts = descriptionText; descriptionText = resolutionTextBox.Text.Trim(); if (descriptionText.Length >= 500) { descriptionText = descriptionText.Substring(0, 500); } GrievancesBOobj.Resolution = descriptionText; if (resolutionDatePicker.Text.Trim() != "") { GrievancesBOobj.ResolutionDate = Convert.ToDateTime(resolutionDatePicker.Text.ToString()); } GrievancesBOobj.ResolvedBy = Convert.ToInt32(resolDropDownList.SelectedValue.ToString().Trim()); GrievancesBOobj.CreatedBy = Convert.ToInt32(Session["USER_ID"]); GrievancesBLL objGrievancBLL = new GrievancesBLL(); if ((resolDropDownList.SelectedItem.Value.ToString()) == "0") { GrievancesBOobj.ResolutionStatus = "P"; count = objGrievancBLL.EditGRIEVANCE(GrievancesBOobj); message = "Data updated successfully"; ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Updated", "ShowUpdateMessage('" + message + "');", true); } else { bool approverExists = CheckApprover(); //Send email for Approval if Approver Exists if (approverExists) { GrievancesBOobj.ResolutionStatus = "S"; count = objGrievancBLL.EditGRIEVANCE(GrievancesBOobj); message = "Data updated successfully"; ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Updated", "ShowUpdateMessage('" + message + "');", true); string scriptContent = string.Format("SendApprovalEmail('{0}',{1},{2},{3},'{4}',{5});", UtilBO.WorkflowGrievances, Convert.ToInt32(Session["PROJECT_ID"]), Convert.ToInt32(Session["USER_ID"]), Convert.ToInt32(Session["HH_ID"]), UtilBO.WorkflowGrievances, Convert.ToInt32(ViewState["GRIEVANCEID"]) ); ScriptManager.RegisterStartupScript(this, this.GetType(), "Updated2", scriptContent, true); } else { message = "You are trying to resolve the status, but the Approver for Grievance Resolution is not defined."; } } ClearDetails(); SetUpdateMode(false); BindGrid(); ResolutionStatusChange.Visible = false; } catch (Exception ex) { throw ex; } finally { objGrievancesBLL = null; } } else { // insert try { string hhid = Session["HH_ID"].ToString(); GrievancesBOobj = new GrievancesBO(); GrievancesBOobj.GrievanceID = Convert.ToInt32(ViewState["GRIEVANCEID"]); GrievancesBOobj.GrievCategoryID = Convert.ToInt32(categoryDropDownList.SelectedValue); descriptionText = descriptionTextBox.Text.Trim(); if (descriptionText.Length >= 1000) { descriptionText = descriptionText.Substring(0, 1000); } GrievancesBOobj.Description = descriptionText; GrievancesBOobj.ActionTaken = actionTextBox.Text.ToString().Trim(); if (actionDatePicker.Text.Trim() != "") { GrievancesBOobj.ActionTakenDate = Convert.ToDateTime(actionDatePicker.Text.ToString()); } GrievancesBOobj.ActionTakenBy = Convert.ToInt32(actionDropDownList.SelectedValue.ToString().Trim()); descriptionText = basicTextBox.Text.Trim(); if (descriptionText.Length >= 500) { descriptionText = descriptionText.Substring(0, 500); } GrievancesBOobj.BasicFacts = descriptionText; descriptionText = resolutionTextBox.Text.Trim(); if (descriptionText.Length >= 500) { descriptionText = descriptionText.Substring(0, 500); } GrievancesBOobj.Resolution = descriptionText; if (resolutionDatePicker.Text.Trim() != "") { GrievancesBOobj.ResolutionDate = Convert.ToDateTime(resolutionDatePicker.Text.ToString()); } GrievancesBOobj.ResolvedBy = Convert.ToInt32(resolDropDownList.SelectedValue.ToString().Trim()); if ((resolDropDownList.SelectedItem.Value.ToString()) == "0") { GrievancesBOobj.ResolutionStatus = "P"; } else { GrievancesBOobj.ResolutionStatus = "P"; } GrievancesBOobj.CreatedBy = Convert.ToInt32(Session["USER_ID"]); GrievancesBOobj.Hhid = Convert.ToInt32(hhid); GrievancesBLL GrievancesBLL = new GrievancesBLL(); count = GrievancesBLL.Insert(GrievancesBOobj); ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Added", "ShowSaveMessage('');", true); ClearDetails(); SetUpdateMode(false); BindGrid(); } catch (Exception ex) { throw ex; } finally { objGrievancesBLL = null; } } //projectFrozen(); //ChangeRequestStatusGrievances(); }
/// <summary> /// to get the grievance data row by row /// </summary> private void GetGrievancedatarow() { GrievancesBLL objGrievancesBLL = new GrievancesBLL(); int GrievanceID = 0; if (ViewState["GRIEVANCEID"] != null) { GrievanceID = Convert.ToInt32(ViewState["GRIEVANCEID"]); } //For Upload Documents Added by Anjankumar lnkUploadDoc.Attributes.Clear(); lnkViewUploadDoc.Attributes.Clear(); int hhid = Convert.ToInt32(Session["HH_ID"]); int userID = Convert.ToInt32(Session["USER_ID"]); string paramUploadDoc = string.Format("OpenUploadDocumnet({0},{1},{2},'{3}','{4}','{5}');", Convert.ToInt32(Session["PROJECT_ID"]), hhid, userID, Session["PROJECT_CODE"].ToString(), "GRV", GrievanceID); string paramViewDocs = string.Format("OpenUploadDocumnetlist({0},{1},{2},'{3}','{4}','{5}');", Convert.ToInt32(Session["PROJECT_ID"]), hhid, userID, Session["PROJECT_CODE"].ToString(), "GRV", GrievanceID); lnkUploadDoc.Attributes.Add("onclick", paramUploadDoc); lnkViewUploadDoc.Attributes.Add("onclick", paramViewDocs); // End Documnts GrievancesBO GrievancesBOobj = new GrievancesBO(); GrievancesBOobj = objGrievancesBLL.GetGrievancedatarow(GrievanceID); categoryDropDownList.ClearSelection(); if (categoryDropDownList.Items.FindByValue(GrievancesBOobj.GrievCategoryID.ToString()) != null) { categoryDropDownList.Items.FindByValue(GrievancesBOobj.GrievCategoryID.ToString()).Selected = true; } //Getactionby(); actionDropDownList.ClearSelection(); if (actionDropDownList.Items.FindByValue(GrievancesBOobj.ActionTakenBy.ToString()) != null) { actionDropDownList.Items.FindByValue(GrievancesBOobj.ActionTakenBy.ToString()).Selected = true; } //Getresolby(); resolDropDownList.ClearSelection(); if (resolDropDownList.Items.FindByValue(GrievancesBOobj.ResolvedBy.ToString()) != null) { resolDropDownList.Items.FindByValue(GrievancesBOobj.ResolvedBy.ToString()).Selected = true; } descriptionTextBox.Text = GrievancesBOobj.Description.ToString(); actionTextBox.Text = GrievancesBOobj.ActionTaken.ToString(); if (GrievancesBOobj.ActionTakenDate != DateTime.MinValue) { actionDatePicker.Text = GrievancesBOobj.ActionTakenDate.ToString(UtilBO.DateFormat); } basicTextBox.Text = GrievancesBOobj.BasicFacts.ToString(); resolutionTextBox.Text = GrievancesBOobj.Resolution.ToString(); if (GrievancesBOobj.ResolutionDate != DateTime.MinValue) { resolutionDatePicker.Text = GrievancesBOobj.ResolutionDate.ToString(UtilBO.DateFormat); } }