public static List <ATTPesiType> GetPesiType(int?PesiTypeID, string active, int defaultFlag)
{
List <ATTPesiType> PesiTypeLST = new List <ATTPesiType>();
try
{
foreach (DataRow row in DLLPesiType.GetPesiType(PesiTypeID, active).Rows)
{
ATTPesiType objPesiType = new ATTPesiType();
objPesiType.PesiTypeID = int.Parse(row["PESI_TYPE_ID"].ToString());
objPesiType.PesiTypeName = row["PESI_TYPE_NAME"].ToString();
objPesiType.Active = row["ACTIVE"].ToString();
PesiTypeLST.Add(objPesiType);
}
if (defaultFlag > 0)
{
ATTPesiType obj = new ATTPesiType();
obj.PesiTypeID = 0;
obj.PesiTypeName = "छान्नुहोस";
PesiTypeLST.Insert(0, obj);
}
return(PesiTypeLST);
}
catch (Exception ex)
{
throw ex;
}
}
public static bool SavePesiType(ATTPesiType objPesiType)
{
try
{
return(DLLPesiType.SavePesiType(objPesiType));
}
catch (Exception ex)
{
throw ex;
}
}
public static bool SavePesiType(ATTPesiType objPesiType)
{
string InsertUpdateSQL = "";
List <OracleParameter> paramArray = new List <OracleParameter>();
GetConnection GetConn = new GetConnection();
OracleTransaction Tran = GetConn.GetDbConn(Module.CMS).BeginTransaction();
try
{
paramArray.Add(Utilities.GetOraParam(":P_PESI_TYPE_ID", objPesiType.PesiTypeID, OracleDbType.Int64, ParameterDirection.InputOutput));
paramArray.Add(Utilities.GetOraParam(":P_PESI_TYPE_NAME", objPesiType.PesiTypeName, OracleDbType.Varchar2, ParameterDirection.Input));
paramArray.Add(Utilities.GetOraParam(":P_ACTIVE", objPesiType.Active, OracleDbType.Varchar2, ParameterDirection.Input));
paramArray.Add(Utilities.GetOraParam(":P_ENTRY_BY", objPesiType.EntryBy, OracleDbType.Varchar2, ParameterDirection.Input));
if (objPesiType.Action == "A")
{
InsertUpdateSQL = "SP_ADD_BENCH_TYPE";
}
else if (objPesiType.Action == "E")
{
InsertUpdateSQL = "SP_EDIT_BENCH_TYPE";
}
SqlHelper.ExecuteNonQuery(Tran, System.Data.CommandType.StoredProcedure, InsertUpdateSQL, paramArray.ToArray());
objPesiType.PesiTypeID = int.Parse(paramArray[0].Value.ToString());
objPesiType.Action = "";
Tran.Commit();
return(true);
}
catch (OracleException oex)
{
PCS.COREDL.OracleError oe = new PCS.COREDL.OracleError();
throw new ArgumentException(oe.GetOraError(oex.Number, oex.Message));
}
catch (Exception ex)
{
Tran.Rollback();
throw ex;
}
finally
{
GetConn.CloseDbConn();
}
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
if (this.txtPesiType.Text == "")
{
this.lblStatusMessage.Text = "Pesi Type Can't Be Left Blank";
this.programmaticModalPopup.Show();
return;
}
ATTUserLogin user = ((ATTUserLogin)Session["Login_User_Detail"]);
List <ATTPesiType> PesiTypeLST = (List <ATTPesiType>)Session["PesiType"];
int i = -1;
if (this.lstPesiType.SelectedIndex > -1)
{
i = PesiTypeLST.FindIndex(delegate(ATTPesiType obj)
{
return(this.txtPesiType.Text == obj.PesiTypeName && this.lstPesiType.SelectedItem.Text != this.txtPesiType.Text);
});
}
else
{
i = PesiTypeLST.FindIndex(delegate(ATTPesiType obj)
{
return(this.txtPesiType.Text == obj.PesiTypeName);
});
}
if (i > -1)
{
this.lblStatusMessage.Text = "Pesi Type Name Already Exists";
this.programmaticModalPopup.Show();
return;
}
ATTPesiType objPesiType = new ATTPesiType();
objPesiType.PesiTypeID = (this.lstPesiType.SelectedIndex == -1) ? 0 : int.Parse(this.lstPesiType.SelectedValue);
objPesiType.PesiTypeName = this.txtPesiType.Text;
objPesiType.Active = (chkPesiTypeActive.Checked == true) ? "Y" : "N";
objPesiType.EntryBy = user.UserName;
objPesiType.Action = (this.lstPesiType.SelectedIndex == -1) ? "A" : "E";
try
{
if (BLLPesiType.SavePesiType(objPesiType) == true)
{
if (this.lstPesiType.SelectedIndex == -1)
{
PesiTypeLST.Add(objPesiType);
}
else
{
PesiTypeLST.RemoveAt(this.lstPesiType.SelectedIndex);
PesiTypeLST.Add(objPesiType);
}
lstPesiType.DataSource = PesiTypeLST;
lstPesiType.DataValueField = "PesiTypeID";
lstPesiType.DataTextField = "PesiTypeName";
lstPesiType.DataBind();
clearAll();
}
}
catch (Exception ex)
{
this.lblStatusMessage.Text = "Pesi Type Couldn't Be Saved<BR>" + ex.Message;
this.programmaticModalPopup.Show();
}
}
