public static bool AddEditDeleteTameliType(ATTTameliType tameliType)
{
try
{
return(DLLTameliType.AddEditDeleteTameliType(tameliType));
}
catch (Exception ex)
{
throw ex;
}
}
public static bool AddEditDeleteTameliType(ATTTameliType tameliType)
{
string InsertUpdateDeleteSQL = "";
GetConnection GetConn = new GetConnection();
OracleConnection DBConn = GetConn.GetDbConn(Module.CMS);
try
{
if (tameliType.Action == "A")
{
InsertUpdateDeleteSQL = "SP_ADD_TAMELI_TYPE";
}
else if (tameliType.Action == "E")
{
InsertUpdateDeleteSQL = "SP_EDIT_TAMELI_TYPE";
}
else if (tameliType.Action == "D")
{
InsertUpdateDeleteSQL = "SP_DEL_TAMELI_TYPE";
}
OracleParameter[] ParamArray;
if (tameliType.Action == "A" || tameliType.Action == "E")
{
ParamArray = new OracleParameter[4];
ParamArray[0] = FRAMEWORK.Utilities.GetOraParam(":P_TAMELI_TYPE_ID", tameliType.TameliTypeID, OracleDbType.Int64, ParameterDirection.InputOutput);
ParamArray[1] = FRAMEWORK.Utilities.GetOraParam(":P_TAMELI_TYPE_NAME", tameliType.TameliTypeName, OracleDbType.Varchar2, ParameterDirection.Input);
ParamArray[2] = FRAMEWORK.Utilities.GetOraParam(":P_ACTIVE", tameliType.Active, OracleDbType.Varchar2, ParameterDirection.Input);
ParamArray[3] = FRAMEWORK.Utilities.GetOraParam(":P_ENTRY_BY", tameliType.EntryBy, OracleDbType.Varchar2, ParameterDirection.Input);
SqlHelper.ExecuteNonQuery(DBConn, CommandType.StoredProcedure, InsertUpdateDeleteSQL, ParamArray);
tameliType.TameliTypeID = int.Parse(ParamArray[0].Value.ToString());
tameliType.Action = "";
}
return(true);
}
catch (Exception ex)
{
throw ex;
}
finally
{
GetConn.CloseDbConn();
}
}
private void LoadTameliType()
{
try
{
List <ATTTameliType> tameliTypeLIST = BLLTameliType.GetTameliType(null, "Y");
ATTTameliType obj = new ATTTameliType();
obj.TameliTypeName = "छान्नुहोस्";
obj.TameliTypeID = 0;
tameliTypeLIST.Insert(0, obj);
ddlTameliType.DataSource = tameliTypeLIST;
ddlTameliType.DataBind();
}
catch (Exception)
{
lblStatusMessage.Text = "तामेलीको प्रकार लोड गर्न सकेन </br>";
this.programmaticModalPopup.Show();
return;
}
}
public static List <ATTTameliType> GetTameliType(int?tameliTypeID, string active)
{
try
{
List <ATTTameliType> tameliTypeLIST = new List <ATTTameliType>();
foreach (DataRow drow in DLLTameliType.GetTameliType(tameliTypeID, active).Rows)
{
ATTTameliType tameliType = new ATTTameliType();
tameliType.TameliTypeID = int.Parse(drow["TAMELI_TYPE_ID"].ToString());
tameliType.TameliTypeName = drow["TAMELI_TYPE_NAME"].ToString();
tameliType.Active = drow["ACTIVE"].ToString();
tameliType.Action = "";
tameliTypeLIST.Add(tameliType);
}
return(tameliTypeLIST);
}
catch (Exception ex)
{
throw ex;
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
if (txTameliTypeName.Text.Trim() == "")
{
lblStatusMessage.Text = "तामेलीको प्रकार छुट्यो </br>";
this.programmaticModalPopup.Show();
return;
}
try
{
List<ATTTameliType> tameliTypeLST = (List<ATTTameliType>)Session["TameliType"];
ATTTameliType tameliType = new ATTTameliType();
tameliType.TameliTypeName = txTameliTypeName.Text.Trim();
tameliType.Active = (chkTameliType.Checked) ? "Y" : "N";
tameliType.EntryBy = entryBy;
if (lstTameliType.SelectedIndex >= 0)
{
tameliType.Action = "E";
tameliType.TameliTypeID = tameliTypeLST[lstTameliType.SelectedIndex].TameliTypeID;
}
else
{
tameliType.Action = "A";
}
if (BLLTameliType.AddEditDeleteTameliType(tameliType))
{
if (lstTameliType.SelectedIndex >= 0)
{
tameliTypeLST[lstTameliType.SelectedIndex] = tameliType;
}
else
{
tameliTypeLST.Add(tameliType);
}
lstTameliType.DataSource = tameliTypeLST;
lstTameliType.DataBind();
lblStatusMessage.Text = "Data Saved Successfully</br>";
this.programmaticModalPopup.Show();
}
else
{
lblStatusMessage.Text = "Problem Occurred while Saving Data </br>";
this.programmaticModalPopup.Show();
}
txTameliTypeName.Text = "";
chkTameliType.Checked = true;
lstTameliType.SelectedIndex = -1;
}
catch (Exception)
{
lblStatusMessage.Text = "Problem Occurred while Saving Data </br>";
this.programmaticModalPopup.Show();
}
}
