protected void btnSaveClass_OnClick(object sender, EventArgs e)
{
try
{
LeaveBo objLeaveBO = new LeaveBo();
LeaveBl objLeaveBL = new LeaveBl();
ApplicationResult objResult = new ApplicationResult();
DataTable dtResult = new DataTable();
int intLeaveID = 0;
objLeaveBO.TrustMID = Convert.ToInt32(Session[ApplicationSession.TRUSTID]);
objLeaveBO.SchoolMID = Convert.ToInt32(Session[ApplicationSession.SCHOOLID]);
objLeaveBO.LeaveName = txtLeaveName.Text.Trim();
objLeaveBO.LeaveCode = txtLeaveCode.Text.Trim();
objLeaveBO.Year = ddlAcademicYear.Text;
objLeaveBO.IsDeduction = Convert.ToInt32(cbDeduction.Checked);
objLeaveBO.IsCarryForward = Convert.ToInt32(cbCarryForward.Checked);
objLeaveBO.LeaveDescription = txtDescription.Text.Trim();
objLeaveBO.LastModifiedUserID = Convert.ToInt32(Session[ApplicationSession.USERID]);
objLeaveBO.LastModifiedDate = DateTime.UtcNow.AddHours(5.5).ToString();
//Code For Validate Leave Name
if (ViewState["Mode"].ToString() == "Save")
{
intLeaveID = -1;
}
else if (ViewState["Mode"].ToString() == "Edit")
{
intLeaveID = Convert.ToInt32(ViewState["LeaveID"].ToString());
}
objResult = objLeaveBL.Leave_ValidateName(Convert.ToInt32(Session[ApplicationSession.TRUSTID]), Convert.ToInt32(Session[ApplicationSession.SCHOOLID]), intLeaveID, objLeaveBO.LeaveName, ddlAcademicYear.Text);
if (objResult != null)
{
dtResult = objResult.resultDT;
if (dtResult.Rows.Count > 0)
{
ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script>alert('Leave name already exist.');</script>");
}
else
{
if (ViewState["Deduction"].ToString() == "0")
{
if (ViewState["Mode"].ToString() == "Save")
{
objLeaveBO.CreatedUserID = Convert.ToInt32(Session[ApplicationSession.USERID]);
objLeaveBO.CreatedDate = DateTime.UtcNow.AddHours(5.5).ToString();
objResult = objLeaveBL.Leave_Insert(objLeaveBO);
if (objResult.status == ApplicationResult.CommonStatusType.SUCCESS)
{
ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp",
"<script>alert('Record saved successfully.');</script>");
}
else
{
ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp",
"<script>alert('LeaveName already exist.');</script>");
}
}
else if (ViewState["Mode"].ToString() == "Edit")
{
objLeaveBO.LeaveID = Convert.ToInt32(ViewState["LeaveID"].ToString());
objResult = objLeaveBL.Leave_Update(objLeaveBO);
if (objResult.status == ApplicationResult.CommonStatusType.SUCCESS)
{
ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script>alert('Record updated successfully.');</script>");
}
else
{
ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script>alert('You can no delete this leave, Because its used in Leave Template.');</script>");
}
}
ClearAll();
BindLeave();
PanelVisibility(1);
}
else
{
ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp",
"<script>alert('There is already assign deduction leave. Only one Leave can be deduct.');</script>");
}
}
}
}
catch (Exception ex)
{
logger.Error("Error", ex);
ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script>alert('Oops! There is some technical issue. Please Contact to your administrator.');</script>");
}
}
/// <summary>
/// To Update details of Leave in tbl_Leave_M table
/// Created By : Nirmal, 08-02-2016
/// Modified By :
/// </summary>
public ApplicationResult Leave_Update(LeaveBo objLeaveBo)
{
try
{
pSqlParameter = new SqlParameter[9];
pSqlParameter[0] = new SqlParameter("@LeaveID", SqlDbType.Int);
pSqlParameter[0].Direction = ParameterDirection.Input;
pSqlParameter[0].Value = objLeaveBo.LeaveID;
pSqlParameter[1] = new SqlParameter("@LeaveCode", SqlDbType.VarChar);
pSqlParameter[1].Direction = ParameterDirection.Input;
pSqlParameter[1].Value = objLeaveBo.LeaveCode;
pSqlParameter[2] = new SqlParameter("@LeaveName", SqlDbType.VarChar);
pSqlParameter[2].Direction = ParameterDirection.Input;
pSqlParameter[2].Value = objLeaveBo.LeaveName;
pSqlParameter[3] = new SqlParameter("@LeaveDescription", SqlDbType.VarChar);
pSqlParameter[3].Direction = ParameterDirection.Input;
pSqlParameter[3].Value = objLeaveBo.LeaveDescription;
pSqlParameter[4] = new SqlParameter("@IsDeduction", SqlDbType.Int);
pSqlParameter[4].Direction = ParameterDirection.Input;
pSqlParameter[4].Value = objLeaveBo.IsDeduction;
pSqlParameter[5] = new SqlParameter("@IsCarryForward", SqlDbType.Int);
pSqlParameter[5].Direction = ParameterDirection.Input;
pSqlParameter[5].Value = objLeaveBo.IsCarryForward;
pSqlParameter[6] = new SqlParameter("@Year", SqlDbType.VarChar);
pSqlParameter[6].Direction = ParameterDirection.Input;
pSqlParameter[6].Value = objLeaveBo.Year;
pSqlParameter[7] = new SqlParameter("@LastModifiedUserID", SqlDbType.Int);
pSqlParameter[7].Direction = ParameterDirection.Input;
pSqlParameter[7].Value = objLeaveBo.LastModifiedUserID;
pSqlParameter[8] = new SqlParameter("@LastModifiedDate", SqlDbType.VarChar);
pSqlParameter[8].Direction = ParameterDirection.Input;
pSqlParameter[8].Value = objLeaveBo.LastModifiedDate;
sSql = "usp_tbl_Leave_M_Update";
int iResult = Database.ExecuteNonQuery(CommandType.StoredProcedure, sSql, pSqlParameter);
if (iResult > 0)
{
ApplicationResult objResults = new ApplicationResult();
objResults.status = ApplicationResult.CommonStatusType.SUCCESS;
return(objResults);
}
else
{
ApplicationResult objResults = new ApplicationResult();
objResults.status = ApplicationResult.CommonStatusType.FAILURE;
return(objResults);
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
objLeaveBo = null;
}
}
