protected void lstLeaveType_SelectedIndexChanged(object sender, EventArgs e)
{
List <ATTLeaveType> LeaveTypeList = (List <ATTLeaveType>)Session["LeaveType"];
ATTLeaveType Att = LeaveTypeList[lstLeaveType.SelectedIndex];
try
{
txtLeveType_Rqd.Text = Att.LeaveTypeName.ToString();
if (Att.Gender != "A")
{
this.ddlGender.SelectedValue = Att.Gender;
}
else
{
this.ddlGender.SelectedIndex = 0;
}
if (Att.Active == "Y")
{
chkLeaveType.Checked = true;
}
else
{
chkLeaveType.Checked = false;
}
}
catch (Exception ex)
{
this.lblStatusMessage.Text = ex.Message;
this.programmaticModalPopup.Show();
return;
}
}
public static bool SaveLeaveType(ATTLeaveType ObjAtt)
{
try
{
return(DLLLeaveType.SaveLeaveType(ObjAtt));
}
catch (Exception ex)
{
throw ex;
}
}
public static ObjectValidation Validate(ATTLeaveType ObjAtt)
{
ObjectValidation OV = new ObjectValidation();
if (ObjAtt.LeaveTypeName == "")
{
OV.IsValid = false;
OV.ErrorMessage = "Leave Type Name cannot be Blank.";
return(OV);
}
return(OV);
}
public static bool SaveLeaveType(ATTLeaveType ObjAtt)
{
GetConnection Conn = new GetConnection();
OracleConnection DBConn;
OracleTransaction Tran;
string InsertUpdateLeaveType = "";
try
{
DBConn = Conn.GetDbConn(Module.PMS);
Tran = DBConn.BeginTransaction();
if (ObjAtt.LeaveTypeID == 0)
{
InsertUpdateLeaveType = "SP_ADD_LEAVE_TYPES";
}
else
{
InsertUpdateLeaveType = "SP_EDIT_LEAVE_TYPES";
}
OracleParameter[] ParamArray = new OracleParameter[4];
ParamArray[0] = Utilities.GetOraParam(":p_LEAVE_TYPE_ID", ObjAtt.LeaveTypeID, OracleDbType.Int64, ParameterDirection.InputOutput);
ParamArray[1] = Utilities.GetOraParam(":p_LEAVE_TYPE_NAME", ObjAtt.LeaveTypeName, OracleDbType.Varchar2, ParameterDirection.Input);
ParamArray[2] = Utilities.GetOraParam(":p_GENDER", ObjAtt.Gender, OracleDbType.Varchar2, ParameterDirection.Input);
ParamArray[3] = Utilities.GetOraParam(":p_ACTIVE", ObjAtt.Active, OracleDbType.Varchar2, ParameterDirection.Input);
SqlHelper.ExecuteNonQuery(Tran, CommandType.StoredProcedure, InsertUpdateLeaveType, ParamArray);
int LeaveTypeID = int.Parse(ParamArray[0].Value.ToString());
ObjAtt.LeaveTypeID = LeaveTypeID;
Tran.Commit();
return(true);
}
catch (Exception ex)
{
throw ex;
}
finally
{
Conn.CloseDbConn();
}
}
public static List <ATTLeaveType> GetLeaveType(int?LeaveTypeId, string active)
{
List <ATTLeaveType> lstLeaveType = new List <ATTLeaveType>();
try
{
foreach (DataRow row in DLLLeaveType.GetLeaveType(LeaveTypeId, active).Rows)
{
ATTLeaveType ObjAtt = new ATTLeaveType
(
int.Parse(row["LEAVE_TYPE_ID"].ToString()),
row["LEAVE_TYPE_NAME"].ToString(),
(string)row["GENDER"],
(row["ACTIVE"] == System.DBNull.Value) ? "" : (string)row["ACTIVE"]
);
lstLeaveType.Add(ObjAtt);
}
return(lstLeaveType);
}
catch (Exception ex)
{
throw ex;
}
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
List <ATTLeaveType> LeaveTypeList = (List <ATTLeaveType>)Session["LeaveType"];
int LeaveTypeID;
if (lstLeaveType.SelectedIndex == -1)
{
LeaveTypeID = 0;
}
else
{
LeaveTypeID = LeaveTypeList[lstLeaveType.SelectedIndex].LeaveTypeID;
}
try
{
ATTLeaveType ObjAtt = new ATTLeaveType
(
LeaveTypeID,
txtLeveType_Rqd.Text.Trim(),
(this.ddlGender.SelectedIndex > 0) ? this.ddlGender.SelectedValue.Trim() : "A",
(this.chkLeaveType.Checked == true ? "Y" : "N")
);
ObjectValidation OV = BLLLeaveType.Validate(ObjAtt);
if (OV.IsValid == false)
{
lblStatusMessage.Text = OV.ErrorMessage;
this.programmaticModalPopup.Show();
return;
}
for (int i = 0; i < lstLeaveType.Items.Count; i++)
{
if (lstLeaveType.SelectedIndex != i)
{
if (LeaveTypeList[i].LeaveTypeName.ToLower() == txtLeveType_Rqd.Text.Trim().ToLower())
{
this.lblStatusMessage.Text = "Leave Type Name Already Exists";
this.programmaticModalPopup.Show();
return;
}
}
}
BLLLeaveType.SaveLeaveType(ObjAtt);
if (lstLeaveType.SelectedIndex > -1)
{
LeaveTypeList[lstLeaveType.SelectedIndex].LeaveTypeID = ObjAtt.LeaveTypeID;
LeaveTypeList[lstLeaveType.SelectedIndex].LeaveTypeName = ObjAtt.LeaveTypeName;
LeaveTypeList[lstLeaveType.SelectedIndex].Gender = ObjAtt.Gender;
LeaveTypeList[lstLeaveType.SelectedIndex].Active = ObjAtt.Active;
}
else
{
LeaveTypeList.Add(ObjAtt);
}
lstLeaveType.DataSource = LeaveTypeList;
lstLeaveType.DataTextField = "LeaveTypeName";
lstLeaveType.DataValueField = "LeaveTypeID";
lstLeaveType.DataBind();
ClearControl();
}
catch (Exception ex)
{
this.lblStatusMessage.Text = ex.Message;
this.programmaticModalPopup.Show();
return;
}
}
protected void grdEmployee_SelectedIndexChanged(object sender, EventArgs e)
{
this.CollapsiblePanelExtender1.Collapsed = true;
//System.Threading.Thread.Sleep(1000);
this.CollapsiblePanelExtender1.ClientState = "true";
this.CollapsiblePanelExtender1.Collapsed = true;
string Name = Server.HtmlDecode(grdEmployee.Rows[grdEmployee.SelectedIndex].Cells[5].Text).ToString();
int id = 0;
List <ATTEmployeeLeave> lstEmployeeLeave = new List <ATTEmployeeLeave>();
if (tabContainerEmpLeave.ActiveTabIndex == 0)
{
id = int.Parse(grdEmployee.Rows[grdEmployee.SelectedIndex].Cells[0].Text);
txtEmpName.Text = Name;
txtEmpName.Attributes.Add("ID", grdEmployee.Rows[grdEmployee.SelectedIndex].Cells[0].Text);
lstEmployeeLeave = BLLEmployeeLeave.GetEmployeeLeave(id, "REQ");
//grdEmployee.SelectedIndex = -1;
Session["EmployeeLeave"] = lstEmployeeLeave;
grdLeaveApplications.DataSource = lstEmployeeLeave;
grdLeaveApplications.DataBind();
}
else if (tabContainerEmpLeave.ActiveTabIndex == 1)
{
id = int.Parse(grdEmployee.Rows[grdEmployee.SelectedIndex].Cells[0].Text);
txtRecName.Text = Name;
txtRecName.Attributes.Add("ID", grdEmployee.Rows[grdEmployee.SelectedIndex].Cells[0].Text);
}
//Loading Leave Type Drop Down List
if (tabContainerEmpLeave.ActiveTabIndex == 0)
{
int eid = int.Parse(txtEmpName.Attributes["ID"].ToString());
List <ATTEmployeeLeave> LSTEmpDesLeave = BLLEmployeeLeave.GetEmpDesLeave(eid);
//LSTEmpDesLeave.Insert(0, new ATTEmployeeLeave(0, 0, "-बिदाको किसिम छान्नुहोस्-"));
ddlAppType.DataSource = LSTEmpDesLeave;
ddlAppType.DataTextField = "LeaveType";
ddlAppType.DataValueField = "LeaveTypeID";
ddlAppType.DataBind();
List <ATTLeaveTypeEmployee> LSTLeaveTypeEmp = BLLLeaveTypeEmployee.GetLeaveTypeEmployee(null, eid);
List <ATTLeaveTypeDesignation> LSTLeaveTypeDes = new List <ATTLeaveTypeDesignation>();
int desID = 0;
List <ATTEmployeePosting> LSTEmpPosting = BLLEmployeePosting.GetEmpPosting(double.Parse(eid.ToString()));
if (LSTEmpPosting.Count > 0)
{
desID = LSTEmpPosting[0].DesID;
}
if (desID > 0)
{
LSTLeaveTypeDes = BLLLeaveTypeDesignation.GetLeaveTypeDesignation(null, desID);
LSTLeaveTypeDes.Insert(0, new ATTLeaveTypeDesignation(0, "-बिदाको किसिम छान्नुहोस्-", 0, 0, "", 0, false, 0, false, "", "", ""));
}
//int? accrDays;
if (LSTLeaveTypeEmp.Count < 1)
{
ddlAppType.DataSource = LSTLeaveTypeDes;
ddlAppType.DataTextField = "LeaveType";
ddlAppType.DataValueField = "LeaveTypeID";
ddlAppType.DataBind();
}
else
{
List <ATTLeaveType> lstLeavetype = new List <ATTLeaveType>();
foreach (ATTLeaveTypeEmployee var in LSTLeaveTypeEmp)
{
ATTLeaveType attlv = new ATTLeaveType(var.LeaveTypeID, var.LeaveType, "");
lstLeavetype.Add(attlv);
}
if (desID > 0)
{
foreach (ATTLeaveTypeEmployee var in LSTLeaveTypeEmp)
{
int i = LSTLeaveTypeDes.FindIndex(delegate(ATTLeaveTypeDesignation obj)
{
return(obj.LeaveTypeID != var.LeaveTypeID);
});
if (i > 0)
{
ATTLeaveType attlv = new ATTLeaveType(LSTLeaveTypeDes[i].LeaveTypeID, LSTLeaveTypeDes[i].LeaveType, "");
lstLeavetype.Add(attlv);
}
}
}
lstLeavetype.Insert(0, new ATTLeaveType(0, "-बिदाको किसिम छान्नुहोस्-", ""));
ddlAppType.DataSource = lstLeavetype;
ddlAppType.DataTextField = "LeaveTypeName";
ddlAppType.DataValueField = "LeaveTypeID";
ddlAppType.DataBind();
}
List <ATTEmployeeLeave> LSTEmpLeave = BLLEmployeeLeave.GetEmployeeLeave(eid, "REQ");
Session["EmployeeLeave"] = LSTEmpLeave;
if (BLLEmployeeLeave.GetEmployeeLeave(eid, "REQ").Count > 0)
{
PanelSearch.Enabled = true;
}
grdLeaveApplications.DataSource = LSTEmpLeave;
grdLeaveApplications.DataBind();
}
}
