protected void btnSave_Click(object sender, EventArgs e)
{
if (txTameliStatusName.Text.Trim() == "")
{
lblStatusMessage.Text = "Tameli Status छुट्यो </br>";
this.programmaticModalPopup.Show();
return;
}
try
{
List <ATTTameliStatus> tameliStatusLST = (List <ATTTameliStatus>)Session["TameliStatus"];
ATTTameliStatus tameliStatus = new ATTTameliStatus();
tameliStatus.TameliStatusName = txTameliStatusName.Text.Trim();
tameliStatus.Active = (chkTameliStatus.Checked) ? "Y" : "N";
tameliStatus.EntryBy = entryBy;
if (lstTameliStatus.SelectedIndex >= 0)
{
tameliStatus.Action = "E";
tameliStatus.TameliStatusID = tameliStatusLST[lstTameliStatus.SelectedIndex].TameliStatusID;
}
else
{
tameliStatus.Action = "A";
}
if (BLLTameliStatus.AddEditDeleteTameliStatus(tameliStatus))
{
if (lstTameliStatus.SelectedIndex >= 0)
{
tameliStatusLST[lstTameliStatus.SelectedIndex] = tameliStatus;
}
else
{
tameliStatusLST.Add(tameliStatus);
}
lstTameliStatus.DataSource = tameliStatusLST;
lstTameliStatus.DataBind();
lblStatusMessage.Text = "Data Saved Successfully</br>";
this.programmaticModalPopup.Show();
}
else
{
lblStatusMessage.Text = "Problem Occurred while Saving Data </br>";
this.programmaticModalPopup.Show();
}
txTameliStatusName.Text = "";
chkTameliStatus.Checked = true;
lstTameliStatus.SelectedIndex = -1;
}
catch (Exception)
{
lblStatusMessage.Text = "Problem Occurred while Saving Data </br>";
this.programmaticModalPopup.Show();
}
}
public static bool AddEditDeleteTameliStatus(ATTTameliStatus tameliStatus)
{
try
{
return(DLLTameliStatus.AddEditDeleteTameliStatus(tameliStatus));
}
catch (Exception ex)
{
throw ex;
}
}
public static bool AddEditDeleteTameliStatus(ATTTameliStatus tameliStatus)
{
string InsertUpdateDeleteSQL = "";
GetConnection GetConn = new GetConnection();
OracleConnection DBConn = GetConn.GetDbConn(Module.CMS);
try
{
if (tameliStatus.Action == "A")
{
InsertUpdateDeleteSQL = "SP_ADD_TAMELI_STATUS";
}
else if (tameliStatus.Action == "E")
{
InsertUpdateDeleteSQL = "SP_EDIT_TAMELI_STATUS";
}
else if (tameliStatus.Action == "D")
{
InsertUpdateDeleteSQL = "SP_DEL_TAMELI_STATUS";
}
OracleParameter[] ParamArray;
if (tameliStatus.Action == "A" || tameliStatus.Action == "E")
{
ParamArray = new OracleParameter[4];
ParamArray[0] = FRAMEWORK.Utilities.GetOraParam(":P_TAMELI_STATUS_ID", tameliStatus.TameliStatusID, OracleDbType.Int64, ParameterDirection.InputOutput);
ParamArray[1] = FRAMEWORK.Utilities.GetOraParam(":P_TAMELI_STATUS_NAME", tameliStatus.TameliStatusName, OracleDbType.Varchar2, ParameterDirection.Input);
ParamArray[2] = FRAMEWORK.Utilities.GetOraParam(":P_ACTIVE", tameliStatus.Active, OracleDbType.Varchar2, ParameterDirection.Input);
ParamArray[3] = FRAMEWORK.Utilities.GetOraParam(":P_ENTRY_BY", tameliStatus.EntryBy, OracleDbType.Varchar2, ParameterDirection.Input);
SqlHelper.ExecuteNonQuery(DBConn, CommandType.StoredProcedure, InsertUpdateDeleteSQL, ParamArray);
tameliStatus.TameliStatusID = int.Parse(ParamArray[0].Value.ToString());
tameliStatus.Action = "";
}
return(true);
}
catch (Exception ex)
{
throw ex;
}
finally
{
GetConn.CloseDbConn();
}
}
public static List <ATTTameliStatus> GetTameliStatus(int?tameliStatusID, string active)
{
try
{
List <ATTTameliStatus> tameliStatusLIST = new List <ATTTameliStatus>();
foreach (DataRow drow in DLLTameliStatus.GetTameliStatus(tameliStatusID, active).Rows)
{
ATTTameliStatus tameliStatus = new ATTTameliStatus();
tameliStatus.TameliStatusID = int.Parse(drow["TAMELI_STATUS_ID"].ToString());
tameliStatus.TameliStatusName = drow["TAMELI_STATUS_NAME"].ToString();
tameliStatus.Active = drow["ACTIVE"].ToString();
tameliStatus.Action = "";
tameliStatusLIST.Add(tameliStatus);
}
return(tameliStatusLIST);
}
catch (Exception ex)
{
throw ex;
}
}
