/// <summary> /// to get the data from the database and bind it to the gridView /// </summary> private void BindGrid() { MajorshockBLL MajorshockBLLobj = new MajorshockBLL(); grdshocks.DataSource = MajorshockBLLobj.GetMshock(Convert.ToInt32(Session["HH_ID"])); grdshocks.DataBind(); }
private void GetShock() { MajorshockBLL MajorshockBLLobj = new MajorshockBLL(); int PAP_SHOCKID1 = 0; if (ViewState["PAP_SHOCKID"] != null) { PAP_SHOCKID1 = Convert.ToInt32(ViewState["PAP_SHOCKID"]); } MajorshockBO Majorshockobj = new MajorshockBO(); Majorshockobj = MajorshockBLLobj.GetPapShochId(PAP_SHOCKID1); pap_shockidTextBox.Text = Majorshockobj.PAP_SHOCKID1.ToString(); typeofshockDropDownList.ClearSelection(); if (typeofshockDropDownList.Items.FindByValue(Majorshockobj.SHOCKID1.ToString()) != null) { typeofshockDropDownList.Items.FindByValue(Majorshockobj.SHOCKID1.ToString()).Selected = true; } helpedDropDownList.ClearSelection(); if (helpedDropDownList.Items.FindByValue(Majorshockobj.SUPPORTID1.ToString()) != null) { helpedDropDownList.Items.FindByValue(Majorshockobj.SUPPORTID1.ToString()).Selected = true; } copingmechDropDownList.ClearSelection(); if (copingmechDropDownList.Items.FindByValue(Majorshockobj.COP_MECHANISMID1.ToString()) != null) { copingmechDropDownList.Items.FindByValue(Majorshockobj.COP_MECHANISMID1.ToString()).Selected = true; } }
/// <summary> /// to Edit and Delete the command /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void grdUsers_RowCommand(object sender, GridViewCommandEventArgs e) { if (e.CommandName == "EditRow") { ViewState["PAP_SHOCKID"] = e.CommandArgument; GetShock(); SetUpdateMode(true); } else if (e.CommandName == "DeleteRow") { ViewState["PAP_SHOCKID"] = e.CommandArgument; int PAP_SHOCKID1 = Convert.ToInt32(ViewState["PAP_SHOCKID"]); MajorshockBLL MajorshockBLLobj = new MajorshockBLL(); MajorshockBLLobj.Delete(PAP_SHOCKID1); BindGrid(); clearfields(); SetUpdateMode(false); ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Added", "alert('Data deleted successfully');", true); } }
/// <summary> /// to save the data to the database /// and clear the data fields by calling clearfields() method /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btnSave_Click(object sender, EventArgs e) { string message = string.Empty; ChangeRequestStatusMajorSchock(); MajorshockBLL MajorshockBLLobj = new MajorshockBLL(); if (pap_shockidTextBox.Text == string.Empty) { try { string uID = Session["USER_ID"].ToString(); string hhid = Session["HH_ID"].ToString(); MajorshockBO Majorshockobj = new MajorshockBO(); Majorshockobj.COP_MECHANISMID1 = Convert.ToInt32(copingmechDropDownList.SelectedValue.ToString()); Majorshockobj.SHOCKID1 = Convert.ToInt32(typeofshockDropDownList.SelectedValue.ToString()); Majorshockobj.SUPPORTID1 = Convert.ToInt32(helpedDropDownList.SelectedValue.ToString()); Majorshockobj.CREATEDBY1 = Convert.ToInt32(Session["USER_ID"]); Majorshockobj.HHID1 = Convert.ToInt32(hhid); MajorshockBLL BLLobj = new MajorshockBLL(); message = BLLobj.Insert(Majorshockobj); if (string.IsNullOrEmpty(message) || message == "" || message == "null") { message = "Data saved successfully"; } //ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Added", "alert('Data saved successfully');", true); BindGrid(); clearfields(); } catch (Exception ex) { throw ex; } finally { MajorshockBLLobj = null; } } //edit the data existing in the Grid else { MajorshockBLL BLLobj = new MajorshockBLL(); try { string uID = Session["USER_ID"].ToString(); MajorshockBO Majorshockobj = new MajorshockBO(); Majorshockobj.PAP_SHOCKID1 = Convert.ToInt32(pap_shockidTextBox.Text); Majorshockobj.SHOCKID1 = Convert.ToInt32(typeofshockDropDownList.SelectedValue); Majorshockobj.COP_MECHANISMID1 = Convert.ToInt32(copingmechDropDownList.SelectedValue); Majorshockobj.SUPPORTID1 = Convert.ToInt32(helpedDropDownList.SelectedValue); Majorshockobj.CREATEDBY1 = Convert.ToInt32(Session["USER_ID"]); message = BLLobj.EDITMshock(Majorshockobj); if (string.IsNullOrEmpty(message) || message == "" || message == "null") { message = "Data updated successfully"; } BindGrid(); clearfields(); SetUpdateMode(false); //ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Added", "alert('Data updated successfully');", true); } catch (Exception ex) { throw ex; } finally { MajorshockBLLobj = null; } } string AlertMessage = "alert('" + message + "');"; ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Added", AlertMessage, true); projectFrozen(); //Added BY Ramu }