public void BindLeave()
{
try
{
LeaveMBo objLeaveMBO = new LeaveMBo();
LeaveMBl objLeaveMBL = new LeaveMBl();
ApplicationResult objResult = new ApplicationResult();
objResult = objLeaveMBL.LeaveM_SelectAll();
if (objResult != null)
{
gvLeaveMaster.DataSource = objResult.resultDT;
gvLeaveMaster.DataBind();
if (gvLeaveMaster.Rows.Count > 0)
{
PanelGrid_VisibilityMode(1);
}
else
{
PanelGrid_VisibilityMode(2);
}
}
}
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>");
}
}
protected void btnSaveFeesGroup_Click(object sender, EventArgs e)
{
;
LeaveMBo objLeaveMBO = new LeaveMBo();
LeaveMBl objLeaveMBL = new LeaveMBl();
ApplicationResult objResults = new ApplicationResult();
Controls objControls = new Controls();
objLeaveMBO.TrustMID = Convert.ToInt32(Session[ApplicationSession.TRUSTID]);
objLeaveMBO.LeaveCode = txtLeaveCode.Text.Trim();
objLeaveMBO.LeaveName = txtLeaveName.Text.Trim();
objLeaveMBO.LeaveDescription = txtLeaveDescription.Text;
objLeaveMBO.LeaveOpening = Convert.ToInt32(txtLOpening.Text);
objLeaveMBO.LeaveCarryForwardLimit = Convert.ToInt32(txtCarryForward.Text);
objLeaveMBO.Year = Convert.ToInt32(ddlYear.SelectedItem.Text);
objLeaveMBO.LastModifiedUserID = Convert.ToInt32(Session[ApplicationSession.USERID]);
objLeaveMBO.LastModifiedDate = DateTime.UtcNow.AddHours(5.5).ToString();
//objLeaveMBO.SchoolMID = Convert.ToInt32(Session[ApplicationSession.SCHOOLID]);
//objLeaveMBO.FeeGroupName = txtFeesGroupName.Text.Trim();
//objLeaveMBO.LedgerID = Convert.ToInt32(ddlLedger.SelectedValue);
if (ViewState["Mode"].ToString() == "Save")
{
objLeaveMBO.CreatedUserID = Convert.ToInt32(Session[ApplicationSession.USERID]);
objLeaveMBO.CreatedDate = DateTime.UtcNow.AddHours(5.5).ToString();
objResults = objLeaveMBL.LeaveM_Insert(objLeaveMBO);
if (objResults.status == ApplicationResult.CommonStatusType.SUCCESS)
{
ClearAll();
ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script language='javascript'>alert('Leave Saved Successfully.');</script>");
BindLeave();
//bindYear();
PanelGrid_VisibilityMode(1);
}
else
{
ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script language='javascript'>alert('Leave Name already Exists.');</script>");
}
}
else
{
objLeaveMBO.LeaveID = Convert.ToInt32(ViewState["LeaveID"].ToString());
objLeaveMBO.LastModifiedUserID = Convert.ToInt32(Session[ApplicationSession.USERID]);
objLeaveMBO.LastModifiedDate = DateTime.UtcNow.AddHours(5.5).ToString();
objLeaveMBO.CreatedUserID = Convert.ToInt32(Session[ApplicationSession.USERID]);
objLeaveMBO.CreatedDate = DateTime.UtcNow.AddHours(5.5).ToString();
objResults = objLeaveMBL.LeaveM_Update(objLeaveMBO);
if (objResults.status == ApplicationResult.CommonStatusType.SUCCESS)
{
ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script language='JavaScript'>alert('Leave updated successfully.');</script>");
//bindYear();
BindLeave();
ClearAll();
ViewState["Mode"] = "Save";
// btnSave.Text = "Save";
}
else
{
ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script language='JavaScript'>alert('Fees Group Name already Exists.');</script>");
}
}
}
/// <summary>
/// To Update details of LeaveM in tbl_Leave_M table
/// Created By : Nafisal, 16-04-2015
/// Modified By :
/// </summary>
/// <param name="objLeaveMBO"></param>
/// <returns></returns>
public ApplicationResult LeaveM_Update(LeaveMBo objLeaveMBO)
{
try
{
pSqlParameter = new SqlParameter[10];
pSqlParameter[0] = new SqlParameter("@LeaveID", SqlDbType.Int);
pSqlParameter[0].Direction = ParameterDirection.Input;
pSqlParameter[0].Value = objLeaveMBO.LeaveID;
pSqlParameter[1] = new SqlParameter("@TrustMID", SqlDbType.Int);
pSqlParameter[1].Direction = ParameterDirection.Input;
pSqlParameter[1].Value = objLeaveMBO.TrustMID;
pSqlParameter[2] = new SqlParameter("@LeaveCode", SqlDbType.VarChar);
pSqlParameter[2].Direction = ParameterDirection.Input;
pSqlParameter[2].Value = objLeaveMBO.LeaveCode;
pSqlParameter[3] = new SqlParameter("@LeaveName", SqlDbType.VarChar);
pSqlParameter[3].Direction = ParameterDirection.Input;
pSqlParameter[3].Value = objLeaveMBO.LeaveName;
pSqlParameter[4] = new SqlParameter("@LeaveDescription", SqlDbType.VarChar);
pSqlParameter[4].Direction = ParameterDirection.Input;
pSqlParameter[4].Value = objLeaveMBO.LeaveDescription;
pSqlParameter[5] = new SqlParameter("@LeaveOpening", SqlDbType.Int);
pSqlParameter[5].Direction = ParameterDirection.Input;
pSqlParameter[5].Value = objLeaveMBO.LeaveOpening;
pSqlParameter[6] = new SqlParameter("@LeaveCarryForwardLimit", SqlDbType.Int);
pSqlParameter[6].Direction = ParameterDirection.Input;
pSqlParameter[6].Value = objLeaveMBO.LeaveCarryForwardLimit;
pSqlParameter[7] = new SqlParameter("@Year", SqlDbType.Int);
pSqlParameter[7].Direction = ParameterDirection.Input;
pSqlParameter[7].Value = objLeaveMBO.Year;
pSqlParameter[8] = new SqlParameter("@LastModifiedUserID", SqlDbType.Int);
pSqlParameter[8].Direction = ParameterDirection.Input;
pSqlParameter[8].Value = objLeaveMBO.LastModifiedUserID;
pSqlParameter[9] = new SqlParameter("@LastModifiedDate", SqlDbType.VarChar);
pSqlParameter[9].Direction = ParameterDirection.Input;
pSqlParameter[9].Value = objLeaveMBO.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
{
objLeaveMBO = null;
}
}
