protected void btnAddUpaSamuha_Click(object sender, EventArgs e) { if (this.grdSamuha.SelectedIndex <= -1) { return; } if (this.txtUpaSamuha.Text == "") { return; } ATTSewa sewa = (ATTSewa)Session["sewa"]; ATTSamuha samuha = sewa.LstSamuha[this.grdSamuha.SelectedIndex]; if (this.grdUpaSamuha.SelectedRow == null) { samuha.LstUpaSamuha.Add(new ATTUpaSamuha(0, 0, 0, this.txtUpaSamuha.Text, "suraj", DateTime.Now, "A")); } else { ATTUpaSamuha ExUpaSamuha = samuha.LstUpaSamuha[this.grdUpaSamuha.SelectedIndex]; ExUpaSamuha.UpaSamuhaName = this.txtUpaSamuha.Text; } this.grdUpaSamuha.DataSource = samuha.LstUpaSamuha; this.grdUpaSamuha.DataBind(); this.txtUpaSamuha.Text = ""; this.grdUpaSamuha.SelectedIndex = -1; }
public static List <ATTSewa> GetSewaList(int?sewaID) { List <ATTSewa> lstSewa = new List <ATTSewa>(); try { List <ATTSamuha> lstSamuha = BLLSamuha.GetSamuhaList(null, null); foreach (DataRow row in DLLSewa.GetSewaTable(sewaID).Rows) { ATTSewa sewa = new ATTSewa(); sewa.SewaID = int.Parse(row["sewa_id"].ToString()); sewa.SewaName = row["sewa_name"].ToString(); sewa.EntryBy = row["entry_by"].ToString(); sewa.EntryOn = DateTime.Parse(row["entry_on"].ToString()); sewa.Action = "M"; sewa.LstSamuha = lstSamuha.FindAll ( delegate(ATTSamuha smu) { return(smu.SewaID == sewa.SewaID); } ); lstSewa.Add(sewa); } return(lstSewa); } catch (Exception ex) { throw ex; } }
public static bool AddSewa(ATTSewa sewa) { try { return(DLLSewa.AddSewa(sewa)); } catch (Exception ex) { throw ex; } }
protected void lstSewa_SelectedIndexChanged(object sender, EventArgs e) { this.ClearThisObject(); ATTSewa sewa = ((List <ATTSewa>)Session["sewa_list"])[this.lstSewa.SelectedIndex].CreateDeepCopy(); this.SetSewaSession(); Session["Sewa"] = sewa; this.txtSewaName.Text = sewa.SewaName; this.grdSamuha.DataSource = sewa.LstSamuha; this.grdSamuha.DataBind(); }
protected void grdSamuha_SelectedIndexChanged(object sender, EventArgs e) { ATTSewa sewa = (ATTSewa)Session["Sewa"]; ATTSamuha samuha = sewa.LstSamuha[this.grdSamuha.SelectedIndex]; List <ATTUpaSamuha> lstUpaSamuha = samuha.LstUpaSamuha; this.txtSamuha.Text = samuha.SamuhaName; this.txtUpaSamuha.Text = ""; this.grdUpaSamuha.DataSource = lstUpaSamuha; this.grdUpaSamuha.DataBind(); this.grdUpaSamuha.SelectedIndex = -1; }
public static bool AddSewa(ATTSewa sewa) { string InsertSP; if (sewa.Action == "A") { InsertSP = "SP_ADD_SEWA"; } else { InsertSP = "SP_EDIT_SEWA"; } List <OracleParameter> paramArray = new List <OracleParameter>(); paramArray.Add(Utilities.GetOraParam(":p_sewa_id", sewa.SewaID, OracleDbType.Int64, System.Data.ParameterDirection.InputOutput)); paramArray.Add(Utilities.GetOraParam(":p_sewa_name", sewa.SewaName, OracleDbType.Varchar2, System.Data.ParameterDirection.Input)); paramArray.Add(Utilities.GetOraParam(":p_entry_by", sewa.EntryBy, OracleDbType.Varchar2, System.Data.ParameterDirection.Input)); paramArray.Add(Utilities.GetOraParam(":p_entry_on", sewa.EntryOn, OracleDbType.Date, System.Data.ParameterDirection.Input)); GetConnection GetConn = new GetConnection(); OracleTransaction Tran = GetConn.GetDbConn(Module.PMS).BeginTransaction(); try { SqlHelper.ExecuteNonQuery(Tran, System.Data.CommandType.StoredProcedure, InsertSP, paramArray.ToArray()); sewa.SewaID = int.Parse(paramArray[0].Value.ToString()); sewa.Action = "M"; DLLSamuha.AddSamuha(sewa.LstSamuha, sewa.SewaID, Tran); Tran.Commit(); return(true); } catch (Exception ex) { Tran.Rollback(); throw ex; } finally { GetConn.CloseDbConn(); } }
protected void btnAddUpaSamuha_Click(object sender, EventArgs e) { if (this.grdSamuha.SelectedIndex <= -1) { this.lblStatusMessage.Text = "समुह छान्नुहोस्"; this.programmaticModalPopup.Show(); return; } if (this.txtUpaSamuha.Text == "") { this.lblStatusMessage.Text = "उप-समुह छान्नुहोस्"; this.programmaticModalPopup.Show(); return; } ATTSewa sewa = (ATTSewa)Session["Sewa"]; List <ATTSamuha> LSTSamuha = sewa.LstSamuha; List <ATTUpaSamuha> LSTUpaSamuha = LSTSamuha[grdSamuha.SelectedIndex].LstUpaSamuha; if (grdUpaSamuha.SelectedIndex < 0) { LSTUpaSamuha.Add(new ATTUpaSamuha(0, 0, 0, this.txtUpaSamuha.Text.ToString(), Session["UserName"].ToString(), DateTime.Now, "A")); } else { ATTUpaSamuha objUpaSamuha = LSTUpaSamuha[grdUpaSamuha.SelectedIndex]; objUpaSamuha.SewaID = 0; objUpaSamuha.SamuhaID = 0; objUpaSamuha.UpaSamuhaID = 0; objUpaSamuha.UpaSamuhaName = this.txtUpaSamuha.Text.ToString().Trim(); objUpaSamuha.EntryBy = Session["UserName"].ToString(); objUpaSamuha.Action = "M"; } this.grdUpaSamuha.DataSource = LSTUpaSamuha; this.grdUpaSamuha.DataBind(); this.txtUpaSamuha.Text = ""; this.grdUpaSamuha.SelectedIndex = -1; }
protected void btnAddSamuha_Click(object sender, EventArgs e) { if (this.txtSamuha.Text == "") { this.lblStatusMessage.Text = "समुह छान्नुहोस्"; this.programmaticModalPopup.Show(); return; } List <ATTSewa> LSTSewa = (List <ATTSewa>)Session["sewa_list"]; ATTSewa sewa = (ATTSewa)Session["Sewa"]; if (this.lstSewa.SelectedIndex < 0) { sewa.SewaName = txtSewaName.Text.Trim(); sewa.EntryBy = Session["UserName"].ToString(); sewa.Action = "A"; List <ATTSewa> LST = LSTSewa.FindAll( delegate(ATTSewa obj) { return(txtSewaName.Text.Trim() == obj.SewaName.Trim().ToString()); } ); if (LST.Count > 0) { this.lblStatusMessage.Text = "सेवा पहिले नै उपलब्द छ"; this.programmaticModalPopup.Show(); return; } else { //if (string.IsNullOrEmpty(sewa.SewaName)) //{ //sewa.SewaName = txtSewaName.Text.Trim(); //} sewa.LstSamuha.Add(new ATTSamuha(0, 0, this.txtSamuha.Text, Session["UserName"].ToString(), DateTime.Now, "A")); //LSTSewa.Add(sewa); } } else { if (this.grdSamuha.SelectedRow == null) { sewa.LstSamuha.Add(new ATTSamuha(0, 0, this.txtSamuha.Text, Session["UserName"].ToString(), DateTime.Now, "A")); LSTSewa.Add(sewa); } else { ATTSamuha ExSamuha = sewa.LstSamuha[this.grdSamuha.SelectedIndex]; ExSamuha.SamuhaName = this.txtSamuha.Text; ExSamuha.Action = "M"; } } this.grdSamuha.DataSource = sewa.LstSamuha; this.grdSamuha.DataBind(); Session["Samuha"] = sewa.LstSamuha; this.txtSamuha.Text = ""; this.grdUpaSamuha.DataSource = ""; this.grdUpaSamuha.DataBind(); this.grdUpaSamuha.SelectedIndex = -1; this.grdSamuha.SelectedIndex = -1; }
void SetSewaSession() { Session["Sewa"] = new ATTSewa(); }
protected void btnSubmit_Click(object sender, EventArgs e) { if (this.txtSewaName.Text == "") { this.lblStatusMessage.Text = "**सेवाको नाम राख्न्नुहोस्"; this.programmaticModalPopup.Show(); return; } if (this.txtSamuha.Text == "" && this.txtUpaSamuha.Text != "") { this.lblStatusMessage.Text = "**समुहको नाम राख्नुहोस्"; this.programmaticModalPopup.Show(); this.txtUpaSamuha.Text = ""; return; } ATTSewa sewa = (ATTSewa)Session["Sewa"]; if (sewa == null) { this.lblStatusMessage.Text = "**र्कपया सेवा राख्नुहोस्"; this.programmaticModalPopup.Show(); return; } else { sewa.SewaName = txtSewaName.Text; foreach (ATTSamuha VAR in sewa.LstSamuha) { if (VAR.LstUpaSamuha.Count < 1) { ATTUpaSamuha obj = new ATTUpaSamuha(); obj.UpaSamuhaName = VAR.SamuhaName; obj.Action = "A"; obj.EntryBy = ((ATTUserLogin)Session["Login_User_Detail"]).UserName; VAR.LstUpaSamuha.Add(obj); } } try { if (BLLSewa.AddSewa(sewa)) { //if (sewa.Action == "A") //{ this.lblStatusMessage.Text = "Sewa Saved Successfully."; this.programmaticModalPopup.Show(); //} //else //{ // this.lblStatusMessage.Text = "Sewa Edited Successfully"; // this.programmaticModalPopup.Show(); //} } if (this.lstSewa.SelectedIndex == -1) { ((List <ATTSewa>)Session["sewa_list"]).Add(sewa); } else { ((List <ATTSewa>)Session["sewa_list"])[this.lstSewa.SelectedIndex] = sewa; } this.lstSewa.DataSource = Session["sewa_list"]; this.lstSewa.DataTextField = "SewaName"; this.lstSewa.DataValueField = "SewaID"; this.lstSewa.DataBind(); this.ClearThisObject(); this.lstSewa.SelectedIndex = -1; this.txtSewaName.Focus(); } catch (Exception ex) { this.lblStatusMessage.Text = ex.ToString(); this.programmaticModalPopup.Show(); return; } } }