public static List <ATTDesignation> GetDesignation(int?DesgId, string desType)
{
List <ATTDesignation> LstDesg = new List <ATTDesignation>();
try
{
foreach (DataRow row in DLLDesignation.GetDesignation(DesgId, desType).Rows)
{
ATTDesignation ObjAtt = new ATTDesignation
(
int.Parse(row["DES_ID"].ToString()),
row["DES_NAME"].ToString(),
row["DES_TYPE"].ToString(),
int.Parse(row["SERVICE_PERIOD"].ToString()),
int.Parse(row["AGE_LIMIT"].ToString())
);
LstDesg.Add(ObjAtt);
}
return(LstDesg);
}
catch (Exception ex)
{
throw ex;
}
}
public static ObjectValidation Validate(ATTDesignation ObjAttDL)
{
ObjectValidation OV = new ObjectValidation();
if (ObjAttDL.DesignationName == "")
{
OV.IsValid = false;
OV.ErrorMessage = "कृपया पद राख्नुहोस.";
return(OV);
}
if (ObjAttDL.DesignationType == "")
{
OV.IsValid = false;
OV.ErrorMessage = "कृपया पदको किसिम छान्नुहोस.";
return(OV);
}
if (ObjAttDL.ServicePeriod == 0)
{
OV.IsValid = false;
OV.ErrorMessage = "र्कपया सेवा अवधि भर्नुहोस्";
}
if (ObjAttDL.AgeLimit == 0)
{
OV.IsValid = false;
OV.ErrorMessage = "र्कपया उमेर सिमा भर्नुहोस्";
}
return(OV);
}
public static bool SaveDesignation(ATTDesignation ObjAtt)
{
try
{
return(DLLDesignation.SaveDesignation(ObjAtt));
}
catch (Exception ex)
{
throw ex;
}
}
public static bool SaveDesignation(ATTDesignation ObjAtt)
{
GetConnection Conn = new GetConnection();
OracleConnection DBConn;
OracleTransaction Tran;
string InsertUpdateDesignation = "";
try
{
DBConn = Conn.GetDbConn(Module.PMS);
Tran = DBConn.BeginTransaction();
if (ObjAtt.DesignationID == 0)
{
InsertUpdateDesignation = "SP_ADD_DESIGNATIONS";
}
else
{
InsertUpdateDesignation = "SP_EDIT_DESIGNATIONS";
}
OracleParameter[] ParamArray = new OracleParameter[5];
ParamArray[0] = Utilities.GetOraParam(":p_DES_ID", ObjAtt.DesignationID, OracleDbType.Int64, ParameterDirection.InputOutput);
ParamArray[1] = Utilities.GetOraParam(":p_DESG_NAME", ObjAtt.DesignationName, OracleDbType.Varchar2, ParameterDirection.Input);
ParamArray[2] = Utilities.GetOraParam(":p_DESG_TYPE", ObjAtt.DesignationType, OracleDbType.Varchar2, ParameterDirection.Input);
ParamArray[3] = Utilities.GetOraParam(":p_SERVICE_PERIOD", ObjAtt.ServicePeriod, OracleDbType.Int32, ParameterDirection.Input);
ParamArray[4] = Utilities.GetOraParam(":p_AGE_LIMIT", ObjAtt.AgeLimit, OracleDbType.Int32, ParameterDirection.Input);
SqlHelper.ExecuteNonQuery(Tran, CommandType.StoredProcedure, InsertUpdateDesignation, ParamArray);
int DesgID = int.Parse(ParamArray[0].Value.ToString());
ObjAtt.DesignationID = DesgID;
Tran.Commit();
return(true);
}
catch (Exception ex)
{
throw ex;
}
finally
{
Conn.CloseDbConn();
}
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
List <ATTDesignation> DesignationList = (List <ATTDesignation>)Session["Designation"];
int DesgID;
if (lstDesignation.SelectedIndex == -1)
{
DesgID = 0;
}
else
{
DesgID = DesignationList[lstDesignation.SelectedIndex].DesignationID;
}
string desType = "J";
try
{
ATTDesignation ObjAtt = new ATTDesignation(DesgID, txtDesignation_Rqd.Text.Trim(), desType);
ObjectValidation OV = BLLDesignation.Validate(ObjAtt);
if (OV.IsValid == false)
{
lblStatusMessage.Text = OV.ErrorMessage;
this.programmaticModalPopup.Show();
return;
}
for (int i = 0; i < lstDesignation.Items.Count; i++)
{
if (lstDesignation.SelectedIndex != i)
{
if (DesignationList[i].DesignationName.ToLower() == txtDesignation_Rqd.Text.Trim().ToLower())
{
this.lblStatusMessage.Text = "Designation Name Already Exists";
this.programmaticModalPopup.Show();
return;
}
}
}
BLLDesignation.SaveDesignation(ObjAtt);
if (lstDesignation.SelectedIndex > -1)
{
DesignationList[this.lstDesignation.SelectedIndex].DesignationID = ObjAtt.DesignationID;
DesignationList[this.lstDesignation.SelectedIndex].DesignationName = txtDesignation_Rqd.Text.Trim();
DesignationList[this.lstDesignation.SelectedIndex].DesignationType = desType;
}
else
{
DesignationList.Add(ObjAtt);
}
lstDesignation.DataSource = DesignationList;
lstDesignation.DataTextField = "DesignationName";
lstDesignation.DataValueField = "DesignationID";
lstDesignation.DataBind();
this.lblStatusMessage.Text = "Designation Successfully Saved.";
this.programmaticModalPopup.Show();
ClearControls();
}
catch (Exception ex)
{
this.lblStatusMessage.Text = ex.Message;
this.programmaticModalPopup.Show();
return;
}
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
if (this.txtDesignation_Rqd.Text == "" || this.txtServicePeriod.Text == "" || this.txtAgeLimit.Text == "")
{
this.lblStatusMessage.Text = "**कृपया पद,सेवा,उमेर सिमा भर्नुहोस्";
this.programmaticModalPopup.Show();
return;
}
List <ATTDesignation> DesignationList = (List <ATTDesignation>)Session["Designation"];
int DesgID;
if (lstDesignation.SelectedIndex == -1)
{
DesgID = 0;
}
else
{
DesgID = DesignationList[lstDesignation.SelectedIndex].DesignationID;
}
string desType = "O";
if (Session["ApplicationID"].ToString() == "2")
{
desType = "J";
}
int servicePeriod = 0;
if (this.txtServicePeriod.Text != "")
{
servicePeriod = int.Parse(this.txtServicePeriod.Text);
}
int ageLimit = 0;
if (this.txtAgeLimit.Text != "")
{
ageLimit = int.Parse(this.txtAgeLimit.Text);
}
try
{
ATTDesignation ObjAtt = new ATTDesignation(DesgID, txtDesignation_Rqd.Text.Trim(), desType, servicePeriod, ageLimit);
for (int i = 0; i < lstDesignation.Items.Count; i++)
{
if (lstDesignation.SelectedIndex != i)
{
if (DesignationList[i].DesignationName.ToLower() == txtDesignation_Rqd.Text.Trim().ToLower())
{
this.lblStatusMessage.Text = "Designation Name Already Exists";
this.programmaticModalPopup.Show();
this.txtDesignation_Rqd.Text = "";
this.txtServicePeriod.Text = "";
this.txtAgeLimit.Text = "";
return;
}
}
}
if (BLLDesignation.SaveDesignation(ObjAtt))
{
this.lblStatusMessage.Text = "Designation Successfully Saved";
this.programmaticModalPopup.Show();
}
if (lstDesignation.SelectedIndex > -1)
{
DesignationList[this.lstDesignation.SelectedIndex].DesignationID = ObjAtt.DesignationID;
DesignationList[this.lstDesignation.SelectedIndex].DesignationName = txtDesignation_Rqd.Text.Trim();
DesignationList[this.lstDesignation.SelectedIndex].DesignationType = desType;
DesignationList[this.lstDesignation.SelectedIndex].ServicePeriod = servicePeriod;
DesignationList[this.lstDesignation.SelectedIndex].AgeLimit = ageLimit;
}
else
{
DesignationList.Add(ObjAtt);
}
lstDesignation.DataSource = DesignationList;
lstDesignation.DataTextField = "DesignationName";
lstDesignation.DataValueField = "DesignationID";
lstDesignation.DataBind();
this.lblStatusMessage.Text = "Designation Saved Successfully.";
this.programmaticModalPopup.Show();
ClearControls();
}
catch (Exception ex)
{
this.lblStatusMessage.Text = ex.Message;
this.programmaticModalPopup.Show();
return;
}
}
