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 Get Major shock /// </summary> /// <param name="householdID"></param> /// <returns></returns> public major_shockList GetMshock(int householdID) { OracleConnection cnn = new OracleConnection(AppConfiguration.ConnectionString); OracleCommand cmd; string proc = "USP_TRN_SEL_SHOCK"; 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); MajorshockBO Majorshockobj = null; major_shockList major_shockListobj = new major_shockList(); while (dr.Read()) { Majorshockobj = new MajorshockBO(); Majorshockobj.PAP_SHOCKID1 = Convert.ToInt32(dr.GetValue(dr.GetOrdinal("PAP_SHOCKID"))); Majorshockobj.SHOCKEXPERIENCED1 = dr.GetString(dr.GetOrdinal("shockexperienced")); Majorshockobj.SUPPORTEDBY1 = dr.GetString(dr.GetOrdinal("supportedby")); Majorshockobj.COP_MECHANISM1 = dr.GetString(dr.GetOrdinal("cop_mechanism")); Majorshockobj.ISDELETED1 = dr.GetString(dr.GetOrdinal("ISDELETED")); major_shockListobj.Add(Majorshockobj); } dr.Close(); return(major_shockListobj); }
/// <summary> /// To Get Pap ShocK Id /// </summary> /// <param name="PAP_SHOCKID1"></param> /// <returns></returns> public MajorshockBO GetPapShochId(int PAP_SHOCKID1) { OracleConnection cnn = new OracleConnection(AppConfiguration.ConnectionString); OracleCommand cmd; string proc = "USP_TRN_GET_SHOCK"; cmd = new OracleCommand(proc, cnn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("S_PAP_SHOCKID", PAP_SHOCKID1); cmd.Parameters.Add("Sp_recordset", OracleDbType.RefCursor).Direction = ParameterDirection.Output; cmd.Connection.Open(); OracleDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection); MajorshockBO Majorshockobj = null; major_shockList major_shockListobj = new major_shockList(); Majorshockobj = new MajorshockBO(); while (dr.Read()) { if (ColumnExists(dr, "pap_shockid") && !dr.IsDBNull(dr.GetOrdinal("pap_shockid"))) { Majorshockobj.PAP_SHOCKID1 = Convert.ToInt32(dr.GetValue(dr.GetOrdinal("pap_shockid"))); } if (ColumnExists(dr, "shockid") && !dr.IsDBNull(dr.GetOrdinal("shockid"))) { Majorshockobj.SHOCKID1 = dr.GetInt32(dr.GetOrdinal("shockid")); } if (ColumnExists(dr, "cop_mechanismid") && !dr.IsDBNull(dr.GetOrdinal("cop_mechanismid"))) { Majorshockobj.COP_MECHANISMID1 = dr.GetInt32(dr.GetOrdinal("cop_mechanismid")); } if (ColumnExists(dr, "supportid") && !dr.IsDBNull(dr.GetOrdinal("supportid"))) { Majorshockobj.SUPPORTID1 = dr.GetInt32(dr.GetOrdinal("supportid")); } } dr.Close(); return(Majorshockobj); }
/// <summary> /// To Insert into DB /// </summary> /// <param name="Majorshockobj"></param> /// <returns></returns> public string Insert(MajorshockBO Majorshockobj) { string resultMessage = string.Empty; OracleConnection cnn = new OracleConnection(AppConfiguration.ConnectionString); cnn.Open(); OracleCommand dcmd = new OracleCommand("USP_TRN_INS_M_SHOCK", cnn); dcmd.CommandType = CommandType.StoredProcedure; int count = Convert.ToInt32(dcmd.CommandType); try { dcmd.Parameters.Add("HHID_", Majorshockobj.HHID1); dcmd.Parameters.Add("SHOCKID_", Majorshockobj.SHOCKID1); dcmd.Parameters.Add("COP_MECHANISMID_", Majorshockobj.COP_MECHANISMID1); dcmd.Parameters.Add("SUPPORTID_", Majorshockobj.SUPPORTID1); dcmd.Parameters.Add("CREATEDBY_", Majorshockobj.CREATEDBY1); dcmd.Parameters.Add("errorMessage_", OracleDbType.Varchar2, 500).Direction = ParameterDirection.Output; dcmd.ExecuteNonQuery(); if (dcmd.Parameters["errorMessage_"].Value != null) { resultMessage = dcmd.Parameters["errorMessage_"].Value.ToString(); } } catch { throw; } finally { dcmd.Dispose(); cnn.Close(); cnn.Dispose(); } return(resultMessage); }
/// <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 }
/// <summary> /// To Insert into Database /// </summary> /// <param name="Majorshockobj"></param> /// <returns></returns> public string Insert(MajorshockBO Majorshockobj) { MajorshockDAL MajorshockDALobj = new MajorshockDAL(); //Data pass -to Database Layer return(MajorshockDALobj.Insert(Majorshockobj)); }
/// <summary> /// To EDIT Major shock /// </summary> /// <param name="Majorshockobj"></param> /// <returns></returns> public string EDITMshock(MajorshockBO Majorshockobj) { MajorshockDAL MajorshockDALobj = new MajorshockDAL(); //Data pass -to Database Layer return(MajorshockDALobj.EDITMshock(Majorshockobj)); }