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;
}
}
}
