public static bool SaveDesignationLevel(ATTDesignationLevel att_des_obj)
{
try
{
return(DLLDesignationLevel.SaveDesignationLevel(att_des_obj));
}
catch (Exception ex)
{
throw ex;
}
}
public static ObjectValidation Validate(ATTDesignationLevel att_des_obj)
{
ObjectValidation OV = new ObjectValidation();
if (att_des_obj.LevelName == "")
{
OV.IsValid = false;
OV.ErrorMessage = "Level Name Cannot be Empty";
return(OV);
}
return(OV);
}
protected void btnSave_Click(object sender, EventArgs e)
{
string strUser = Session["UserName"].ToString();
int intDesID = 0;
List <ATTDesignationLevel> desLevel = (List <ATTDesignationLevel>)Session["DesignationLevel"];
if (this.lstDesignationLevel.SelectedIndex > -1)
{
intDesID = desLevel[this.lstDesignationLevel.SelectedIndex].LevelID;
}
ATTDesignationLevel att_des_level = new ATTDesignationLevel(
intDesID,
this.txtLevel.Text,
strUser);
ObjectValidation OV = BLLDesignationLevel.Validate(att_des_level);
if (OV.IsValid == false)
{
this.lblStatusMessage.Text = OV.ErrorMessage;
this.programmaticModalPopup.Show();
return;
}
try
{
BLLDesignationLevel.SaveDesignationLevel(att_des_level);
if (this.lstDesignationLevel.SelectedIndex > -1)
{
desLevel[this.lstDesignationLevel.SelectedIndex].LevelID = att_des_level.LevelID;
desLevel[this.lstDesignationLevel.SelectedIndex].LevelName = att_des_level.LevelName;
}
else
{
desLevel.Add(att_des_level);
}
this.lstDesignationLevel.DataSource = desLevel;
this.lstDesignationLevel.DataBind();
this.ClearControl();
this.lblStatusMessage.Text = "Designation Level Successfully Saved.";
this.programmaticModalPopup.Show();
}
catch (Exception ex)
{
this.lblStatusMessage.Text = ex.Message;
this.programmaticModalPopup.Show();
}
}
public static List <ATTDesignationLevel> GetDesignationLevelList()
{
List <ATTDesignationLevel> lstdl = new List <ATTDesignationLevel>();
try
{
foreach (DataRow row in DLLDesignationLevel.GetDesignationLevelTable().Rows)
{
ATTDesignationLevel att_desl_obj = new ATTDesignationLevel(
int.Parse(row["Level_ID"].ToString()),
row["Level_Name"].ToString()
);
lstdl.Add(att_desl_obj);
}
return(lstdl);
}
catch (Exception ex)
{
throw ex;
}
}
public static bool SaveDesignationLevel(ATTDesignationLevel att_obj)
{
string InsertUpdateDL;
InsertUpdateDL = "";
if (att_obj.LevelID > 0)
{
InsertUpdateDL = "SP_EDIT_LEVEL";
}
else if (att_obj.LevelID == 0)
{
InsertUpdateDL = "SP_ADD_LEVEL";
}
OracleParameter[] paramArray = new OracleParameter[3];
paramArray[0] = Utilities.GetOraParam(":Level_ID", att_obj.LevelID, OracleDbType.Int64, ParameterDirection.InputOutput);
paramArray[1] = Utilities.GetOraParam(":Level_Name", att_obj.LevelName, OracleDbType.Varchar2, ParameterDirection.Input);
paramArray[2] = Utilities.GetOraParam(":Entry_By", att_obj.EntryBy, OracleDbType.Varchar2, ParameterDirection.Input);
GetConnection conn = new GetConnection();
try
{
OracleConnection DBconn = conn.GetDbConn(Module.PMS);
SqlHelper.ExecuteNonQuery(DBconn, CommandType.StoredProcedure, InsertUpdateDL, paramArray);
att_obj.LevelID = int.Parse(paramArray[0].Value.ToString());
return(true);
}
catch (Exception ex)
{
throw ex;
}
finally
{
conn.CloseDbConn();
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
if (this.txtLevel.Text == "")
{
this.lblStatusMessage.Text = "**र्कपया श्रेणीको प्रकार भर्नुहोस्";
this.programmaticModalPopup.Show();
this.txtLevel.Focus();
return;
}
string strUser = Session["UserName"].ToString();
int intDesID = 0;
List <ATTDesignationLevel> desLevel = (List <ATTDesignationLevel>)Session["DesignationLevel"];
if (this.lstDesignationLevel.SelectedIndex > -1)
{
intDesID = desLevel[this.lstDesignationLevel.SelectedIndex].LevelID;
}
ATTDesignationLevel att_des_level = new ATTDesignationLevel(
intDesID,
this.txtLevel.Text,
strUser
);
ObjectValidation OV = BLLDesignationLevel.Validate(att_des_level);
if (OV.IsValid == false)
{
this.lblStatusMessage.Text = OV.ErrorMessage;
this.programmaticModalPopup.Show();
return;
}
bool exists = desLevel.Exists(delegate(ATTDesignationLevel obj)
{
return(obj.LevelName == att_des_level.LevelName);
}
);
if (exists)
{
this.lblStatusMessage.Text = "**सोहि नामको श्रेणी पहिले नै उपलब्द छ";
this.programmaticModalPopup.Show();
this.txtLevel.Text = "";
this.txtLevel.Focus();
this.lstDesignationLevel.SelectedIndex = -1;
return;
}
try
{
BLLDesignationLevel.SaveDesignationLevel(att_des_level);
if (this.lstDesignationLevel.SelectedIndex > -1)
{
desLevel[this.lstDesignationLevel.SelectedIndex].LevelID = att_des_level.LevelID;
desLevel[this.lstDesignationLevel.SelectedIndex].LevelName = att_des_level.LevelName;
}
else
{
desLevel.Add(att_des_level);
}
this.lstDesignationLevel.DataSource = desLevel;
this.lstDesignationLevel.DataBind();
this.ClearControl();
if (this.lstDesignationLevel.SelectedIndex == -1)
{
this.lblStatusMessage.Text = "Designation Level Saved Successfully.";
this.programmaticModalPopup.Show();
}
else
{
this.lblStatusMessage.Text = "Designation Level Updated Successfully.";
this.programmaticModalPopup.Show();
}
this.txtLevel.Focus();
}
catch (Exception ex)
{
this.lblStatusMessage.Text = ex.Message;
this.programmaticModalPopup.Show();
}
}
protected void lstDesignationLevel_SelectedIndexChanged(object sender, EventArgs e)
{
ATTDesignationLevel obj = ((List <ATTDesignationLevel>)Session["DesignationLevel"])[this.lstDesignationLevel.SelectedIndex];
this.txtLevel.Text = obj.LevelName;
}
