/// <summary> /// Update Database Make data as Obsoluted /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void IsObsolete_CheckedChanged(Object sender, EventArgs e) { string message = string.Empty; try { CheckBox chk = (CheckBox)sender; GridViewRow gr = (GridViewRow)chk.Parent.Parent; string PAPDESIGNATIONID = ((Literal)gr.FindControl("litPAPStatusID")).Text; PstatusBLL PstatusBLLobj = new PstatusBLL(); message = PstatusBLLobj.ObsoletePAPStatus(Convert.ToInt32(PAPDESIGNATIONID), Convert.ToString(chk.Checked), Convert.ToInt32(Session["USER_ID"])); if (string.IsNullOrEmpty(message) || message == "" || message == "null") { message = "Data updated successfully"; } if (message != "") { ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Added", "alert('" + message + "');", true); } BindGrid(false, true); } catch (Exception ex) { throw ex; } }
/// <summary> /// Get Pap data From database and set to Labels /// </summary> private void GetHouseholdDetails() { int householdID = Convert.ToInt32(Session["HH_ID"]); PAP_HouseholdBLL objHouseHoldBLL = new PAP_HouseholdBLL(); PAP_HouseholdBO objHouseHold = objHouseHoldBLL.GetHouseHoldData(householdID); lblDistrict.Text = objHouseHold.District; lblCounty.Text = objHouseHold.County; lblSubCounty.Text = objHouseHold.SubCounty; lblParish.Text = objHouseHold.Parish; lblVillage.Text = objHouseHold.Village; lblStakeholdDesignation.Text = objHouseHold.Designation; ddlLocClassification.ClearSelection(); if (ddlLocClassification.Items.FindByValue(objHouseHold.LocClassification) != null) { ddlLocClassification.Items.FindByValue(objHouseHold.LocClassification).Selected = true; } PstatusBLL objPstatusBLL = new PstatusBLL(); PstatusBO objPstatus = objPstatusBLL.GetPstatusById(objHouseHold.PapstatusId); if (objPstatus != null) { lblStatus.Text = objPstatus.PAPDESIGNATION1; } }
/// <summary> /// to get the data of the PAPStatus from the database /// </summary> private void GetPAPStatus() { PstatusBLL objPStatusBLL = new PstatusBLL(); ddlStatus.DataSource = objPStatusBLL.GetPstatus(); ddlStatus.DataTextField = "PAPDESIGNATION1"; ddlStatus.DataValueField = "PAPDESIGNATIONID1"; ddlStatus.DataBind(); }
private void loadStatusddl() { PstatusBLL objMasterBLL = new PstatusBLL(); OccupationStatus.DataTextField = "PAPDESIGNATION1"; OccupationStatus.DataValueField = "PAPDESIGNATIONID1"; OccupationStatus.DataSource = objMasterBLL.GetPstatus(); OccupationStatus.DataBind(); }
/// <summary> /// To save details to database /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void SaveButton_Click(object sender, EventArgs e) { string message = ""; PstatusBLL BLLobj = null; try { BLLobj = new PstatusBLL(); PstatusBO objPstatus = new PstatusBO(); if (Convert.ToInt32(ViewState["PAPDESIGNATIONID"]) > 0) { objPstatus.PAPDESIGNATION1 = pstatusTextBox.Text.Trim(); objPstatus.PAPDESIGNATIONID1 = Convert.ToInt32(ViewState["PAPDESIGNATIONID"]); message = BLLobj.EDITPstatus(objPstatus); if (string.IsNullOrEmpty(message) || message == "" || message == "null") { message = "Data updated successfully"; } SetUpdateMode(false); } else { objPstatus.PAPDESIGNATION1 = pstatusTextBox.Text.Trim(); objPstatus.CREATEDBY1 = Convert.ToInt32(Session["USER_ID"]); message = BLLobj.insert(objPstatus); if (string.IsNullOrEmpty(message) || message == "" || message == "null") { message = "Data saved successfully"; } } if (message != "") { ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Added", "alert('" + message + "');", true); } clearfields(); BindGrid(true, true); } catch (Exception ex) { throw ex; } finally { BLLobj = null; } }
// <summary> /// get the Grid value into textBox /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void GetPstatusDetails() { PstatusBLL PstatusBLLobj = new PstatusBLL(); int PAPDESIGNATIONID = 0; if (ViewState["PAPDESIGNATIONID"] != null) { PAPDESIGNATIONID = Convert.ToInt32(ViewState["PAPDESIGNATIONID"]); } PstatusBO PstatusObj = new PstatusBO(); PstatusObj = PstatusBLLobj.GetPstatusById(PAPDESIGNATIONID); pstatusTextBox.Text = PstatusObj.PAPDESIGNATION1; }