//-------Insert------------------------------------
public int InsertLeaveType(HRM_LEAVE_TYPE objLev)
{
try
{
_context.HRM_LEAVE_TYPE.AddObject(objLev);
_context.SaveChanges();
return(1);
}
catch (Exception ex)
{
throw new Exception(ex.Message.ToString());
}
}
//-------Update------------------------------------
public int UpdateLeaveType(HRM_LEAVE_TYPE objLev, int leaveID)
{
try
{
HRM_LEAVE_TYPE obj = _context.HRM_LEAVE_TYPE.First(x => x.LEV_ID == leaveID);
obj.LEV_TYPE = objLev.LEV_TYPE;
obj.LEV_DAYS = objLev.LEV_DAYS;
obj.EDIT_USER = objLev.EDIT_USER;
obj.EDIT_DATE = DateTime.Now;
obj.OCODE = objLev.OCODE;
_context.SaveChanges();
return(1);
}
catch (Exception ex)
{
throw ex;
}
}
private bool IsExist(HRM_LEAVE_TYPE _LeaveType)
{
try
{
ERPSSLHBEntities _context = new ERPSSLHBEntities();
bool status = false;
int count = (from rgn in _context.HRM_LEAVE_TYPE
where rgn.LEV_TYPE == _LeaveType.LEV_TYPE && rgn.LEV_DAYS == _LeaveType.LEV_DAYS
select rgn.LEV_TYPE).Count();
if (count == 0)
{
status = true;
}
return(status);
}
catch (Exception)
{
throw;
}
}
//-------Update------------------------------------
public int UpdateLeaveType(HRM_LEAVE_TYPE objLev, int gradeId)
{
return(objCtx_DAL.UpdateLeaveType(objLev, gradeId));
}
//-------Insert------------------------------------
public int InsertLeaveType(HRM_LEAVE_TYPE objLev)
{
return(objCtx_DAL.InsertLeaveType(objLev));
}
protected void btnLeaveTypeSubmit_Click(object sender, EventArgs e)
{
try
{
if (txtbxLeaveType.Text == "")
{
// lblMessage.Text = "";
// lblMessage.ForeColor = System.Drawing.Color.Red;
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func(Please Select Leave Type!'')", true);
}
else if (txtbxLeaveDays.Text == "")
{
// lblMessage.Text = "";
// lblMessage.ForeColor = System.Drawing.Color.Red;
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('Please Input Leave Days!')", true);
}
else
{
HRM_LEAVE_TYPE objLev = new HRM_LEAVE_TYPE();
objLev.LEV_TYPE = txtbxLeaveType.Text;
objLev.LEV_DAYS = Convert.ToInt32(txtbxLeaveDays.Text);
objLev.EDIT_USER = ((SessionUser)Session["SessionUser"]).UserId;
objLev.EDIT_DATE = DateTime.Now;
objLev.OCODE = ((SessionUser)Session["SessionUser"]).OCode;
if (btnLeaveTypeSubmit.Text == "Submit")
{
if (IsExist(objLev))
{
int result = objLeave_BLL.InsertLeaveType(objLev);
if (result == 1)
{
// lblMessage.Text = "Data Save successfully!";
// lblMessage.ForeColor = System.Drawing.Color.Green;
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('Data Save Successfully')", true);
}
}
else
{
// lblMessage.Text = "";
// lblMessage.ForeColor = System.Drawing.Color.Red;
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('Data Already Exists!')", true);
}
}
else
{
int leaveTypeId = Convert.ToInt32(hidLeaveId.Value);
int result = objLeave_BLL.UpdateLeaveType(objLev, leaveTypeId);
if (result == 1)
{
// lblMessage.Text = "Data Update successfully!";
// lblMessage.ForeColor = System.Drawing.Color.Green;
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('Data Update Successfully')", true);
}
}
getLeaveTypes();
ClearAllTextbox();
}
}
catch (Exception ex)
{
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('" + ex.Message + "')", true);
}
}
