public static int Claim_AdjustAmount_Update(Entity.ClaimManagement.ClaimApplicationMaster claimApplicationMaster)
{
int rowsAffacted = 0;
using (SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["constr"].ToString()))
{
using (SqlCommand cmd = new SqlCommand())
{
cmd.Connection = con;
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "usp_HR_Claim_AdjustAmount_Update";
cmd.Parameters.AddWithValue("@ClaimId", claimApplicationMaster.ClaimApplicationId);
cmd.Parameters.AddWithValue("@AdjustRequestAmount", claimApplicationMaster.AdjustRequestAmount);
if (con.State == ConnectionState.Closed)
{
con.Open();
}
rowsAffacted = cmd.ExecuteNonQuery();
con.Close();
}
}
return(rowsAffacted);
}
protected void btnSave_Click(object sender, EventArgs e)
{
try
{
if (ClaimApplyValidation())
{
Entity.ClaimManagement.ClaimApplicationMaster claimApplicationMaster = ClaimApplicationMaster_Save();
foreach (DataRow drClaimDetail in _ClaimDetails.Rows)
{
ClaimApplicationDetails_Save(claimApplicationMaster.ClaimApplicationId,
Convert.ToDateTime(drClaimDetail["ExpenseDate"].ToString()),
drClaimDetail["Attachment"].ToString(),
Convert.ToInt32(Enum.Parse(typeof(ClaimCategoryEnum), drClaimDetail["CategoryId"].ToString())),
Convert.ToDecimal(drClaimDetail["Cost"].ToString()),
drClaimDetail["Description"].ToString(),
Convert.ToInt32(Enum.Parse(typeof(ClaimStatusEnum), drClaimDetail["Status"].ToString())));
}
int approvalResponse = ClaimApprovalDetails_Save(claimApplicationMaster.ClaimApplicationId);
if (approvalResponse > 0)
{
ClearAllControl();
_ClaimDetails.Clear();
Message.IsSuccess = true;
Message.Text = string.Format("Claim applied successfully. Your claim no. {0}", claimApplicationMaster.ClaimApplicationNumber);
Message.Show = true;
}
else
{
Message.IsSuccess = false;
Message.Text = "Claim approval send failed! Please contact system administrator.";
Message.Show = true;
}
}
else
{
Message.IsSuccess = false;
Message.Text = "Claim apply failed! Please contact system administrator.";
Message.Show = true;
}
}
catch (Exception ex)
{
ex.WriteException();
Message.IsSuccess = false;
Message.Text = ex.Message;
Message.Show = true;
}
}
private void ClaimApplication_GetAll()
{
Entity.ClaimManagement.ClaimApplicationMaster ClaimApplicationMaster = new Entity.ClaimManagement.ClaimApplicationMaster();
ClaimApplicationMaster.EmployeeId = Convert.ToInt32(ddlEmployee.SelectedValue);
ClaimApplicationMaster.PeriodFrom = (string.IsNullOrEmpty(txtFromDate.Text.Trim())) ? DateTime.MinValue : Convert.ToDateTime(txtFromDate.Text.Trim());
ClaimApplicationMaster.PeriodTo = (string.IsNullOrEmpty(txtToDate.Text.Trim())) ? DateTime.MinValue : Convert.ToDateTime(txtToDate.Text.Trim());
ClaimApplicationMaster.Status = Convert.ToInt32(ddlStatus.SelectedValue);
Business.ClaimManagement.ClaimApplication objClaimApplication = new Business.ClaimManagement.ClaimApplication();
DataTable dtClaimApplication = objClaimApplication.ClaimApplication_GetAll(ClaimApplicationMaster);
if (dtClaimApplication != null)
{
gvClaimReport.DataSource = dtClaimApplication;
gvClaimReport.DataBind();
}
}
public static DataTable ClaimApplicationDetails_GetByDate(Entity.ClaimManagement.ClaimApplicationMaster ClaimApplicationMaster)
{
using (DataTable dt = new DataTable())
{
using (SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["constr"].ToString()))
{
using (SqlCommand cmd = new SqlCommand())
{
cmd.Connection = con;
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "usp_HR_ClaimApplicationDetails_GetByDate";
if (ClaimApplicationMaster.ClaimApplicationId == 0)
{
cmd.Parameters.AddWithValue("@ClaimApplicationId", DBNull.Value);
}
else
{
cmd.Parameters.AddWithValue("@ClaimApplicationId", ClaimApplicationMaster.ClaimApplicationId);
}
//if (ClaimApplicationMaster.RequestorId == 0)
// cmd.Parameters.AddWithValue("@RequestorId", DBNull.Value);
//else
// cmd.Parameters.AddWithValue("@RequestorId", ClaimApplicationMaster.RequestorId);
//if (string.IsNullOrEmpty(ClaimApplicationMaster.ClaimStatuses))
// cmd.Parameters.AddWithValue("@ClaimStatuses", DBNull.Value);
//else
// cmd.Parameters.AddWithValue("@ClaimStatuses", ClaimApplicationMaster.ClaimStatuses);
//if (ClaimApplicationMaster.FromClaimDate == DateTime.MinValue)
// cmd.Parameters.AddWithValue("@FromClaimDate", DBNull.Value);
//else
// cmd.Parameters.AddWithValue("@FromClaimDate", ClaimApplicationMaster.FromClaimDate);
//if (ClaimApplicationMaster.ToClaimDate == DateTime.MinValue)
// cmd.Parameters.AddWithValue("@ToClaimDate", DBNull.Value);
//else
// cmd.Parameters.AddWithValue("@ToClaimDate", ClaimApplicationMaster.ToClaimDate);
using (SqlDataAdapter da = new SqlDataAdapter(cmd))
{
da.Fill(dt);
}
con.Close();
}
}
return(dt);
}
}
private Entity.ClaimManagement.ClaimApplicationMaster ClaimApplicationMaster_Save()
{
Entity.ClaimManagement.ClaimApplicationMaster claimApplicationMaster = new Entity.ClaimManagement.ClaimApplicationMaster();
Business.ClaimManagement.ClaimApplication objClaimApplicationMaster = new Business.ClaimManagement.ClaimApplication();
claimApplicationMaster.ClaimDateTime = DateTime.Now;
claimApplicationMaster.ClaimHeading = txtClaimHeader.Text.Trim();
claimApplicationMaster.PeriodFrom = Convert.ToDateTime(txtPeriodFrom.Text);
claimApplicationMaster.PeriodTo = Convert.ToDateTime(txtPeriodTo.Text);
claimApplicationMaster.Status = (int)ClaimStatusEnum.Pending;
claimApplicationMaster.EmployeeId = Convert.ToInt32(HttpContext.Current.User.Identity.Name);
claimApplicationMaster.ClaimApplicationNumber = string.Empty;
claimApplicationMaster.TotalAmount = (decimal)_ClaimDetails.Compute("SUM(Cost)", string.Empty);
claimApplicationMaster.CreatedBy = Convert.ToInt32(HttpContext.Current.User.Identity.Name);
claimApplicationMaster.AdjustRequestAmount = Convert.ToDecimal(txtAdjustAdvance.Text.Trim());
claimApplicationMaster = objClaimApplicationMaster.ClaimApplicationMaster_Save(claimApplicationMaster);
return(claimApplicationMaster);
}
protected void btnApprove_Click(object sender, EventArgs e)
{
try
{
if (ClaimApprovalValidation())
{
Entity.ClaimManagement.ClaimApprovalDetails ClaimApprovalDetails = new Entity.ClaimManagement.ClaimApprovalDetails();
ClaimApprovalDetails.ApproverId = Convert.ToInt32(HttpContext.Current.User.Identity.Name);
ClaimApprovalDetails.ClaimApplicationId = Business.Common.Context.ClaimApplicationId;
ClaimApprovalDetails.Status = (int)ClaimStatusEnum.Approved;
ClaimApprovalDetails.Remarks = txtRemarks.Text.Trim();
int response = new Business.ClaimManagement.ClaimApprovalDetails().Claim_Approve(ClaimApprovalDetails);
if (response > 0)
{
//Fetching Requestor Id
Entity.ClaimManagement.ClaimApplicationMaster ClaimApplicationMaster = new Entity.ClaimManagement.ClaimApplicationMaster();
Business.ClaimManagement.ClaimApplication objClaimApplication = new Business.ClaimManagement.ClaimApplication();
ClaimApplicationMaster.ClaimApplicationId = Business.Common.Context.ClaimApplicationId;
DataTable dtClaimApplication = objClaimApplication.ClaimApplication_GetAll(ClaimApplicationMaster);
Business.ClaimManagement.ClaimApprovalConfiguration objClaimApprovalConfiguration = new Business.ClaimManagement.ClaimApprovalConfiguration();
DataTable dtClaimEmployeeWiseApprovalConfiguration = objClaimApprovalConfiguration.ClaimEmployeeWiseApprovalConfiguration_GetAll(
new Entity.ClaimManagement.ClaimApprovalConfiguration()
{
EmployeeId = (dtClaimApplication != null && dtClaimApplication.AsEnumerable().Any()) ? Convert.ToInt32(dtClaimApplication.Rows[0]["EmployeeId"].ToString()) : 0
});
int currentClaimApproverLevel = 0;
if (dtClaimEmployeeWiseApprovalConfiguration != null &&
dtClaimEmployeeWiseApprovalConfiguration.AsEnumerable().Any() &&
dtClaimEmployeeWiseApprovalConfiguration.Select("ApproverId = " + HttpContext.Current.User.Identity.Name).Any())
{
//Fetching the current approver approval level
currentClaimApproverLevel = Convert.ToInt32(dtClaimEmployeeWiseApprovalConfiguration
.Select("ApproverId = " + HttpContext.Current.User.Identity.Name).FirstOrDefault()["ApprovalLevel"].ToString());
currentClaimApproverLevel = currentClaimApproverLevel + 1;
}
if (dtClaimEmployeeWiseApprovalConfiguration != null &&
dtClaimEmployeeWiseApprovalConfiguration.AsEnumerable().Any() &&
dtClaimEmployeeWiseApprovalConfiguration.Select("ApprovalLevel = " + currentClaimApproverLevel).Any())
{
Business.ClaimManagement.ClaimApprovalDetails objClaimApprovalDetails = new Business.ClaimManagement.ClaimApprovalDetails();
ClaimApprovalDetails.ClaimApprovalDetailId = 0;
ClaimApprovalDetails.ClaimApplicationId = Business.Common.Context.ClaimApplicationId;
ClaimApprovalDetails.Status = (int)ClaimStatusEnum.Pending;
ClaimApprovalDetails.ApproverId = Convert.ToInt32(dtClaimEmployeeWiseApprovalConfiguration.Select("ApprovalLevel = " + currentClaimApproverLevel).FirstOrDefault()["ApproverId"].ToString());
//Assigning Claim Request to next approver
int approvalResponse = objClaimApprovalDetails.ClaimApprovalDetails_Save(ClaimApprovalDetails);
if (approvalResponse > 0)
{
GetClaimApplications_ByApproverId(ckShowAll.Checked ? (int)ClaimStatusEnum.None : (int)ClaimStatusEnum.Pending);
MessageSuccess.IsSuccess = true;
MessageSuccess.Text = "Approval moved to next level.";
MessageSuccess.Show = true;
ModalPopupExtender1.Hide();
}
}
else
{
//If final Appoval approved then update status in Master table
new Business.ClaimManagement.ClaimApplication().ClaimApplicationMaster_Save(
new Entity.ClaimManagement.ClaimApplicationMaster()
{
ClaimApplicationId = Business.Common.Context.ClaimApplicationId,
Status = (int)ClaimStatusEnum.Approved,
ApprovedAmount = Convert.ToDecimal(lblTotalApprovedAmount.Text.Trim())
});
GetClaimApplications_ByApproverId(ckShowAll.Checked ? (int)ClaimStatusEnum.None : (int)ClaimStatusEnum.Pending);
MessageSuccess.IsSuccess = true;
MessageSuccess.Text = "Claim approved.";
MessageSuccess.Show = true;
ModalPopupExtender1.Hide();
txtRemarks.Text = string.Empty;
Message.Show = false;
}
Claim_Heading_Update(Business.Common.Context.ClaimApplicationId, txtClaimHeader.Text.Trim());
Claim_Adjust_Update();
}
else
{
Message.IsSuccess = false;
Message.Text = "Response not given.";
Message.Show = true;
TabContainer1.ActiveTab = Approval;
ModalPopupExtender1.Show();
}
}
else
{
TabContainer1.ActiveTab = Approval;
ModalPopupExtender1.Show();
}
}
catch (Exception ex)
{
ex.WriteException();
Message.IsSuccess = false;
Message.Text = ex.Message;
Message.Show = true;
}
}
public int Claim_AdjustAmount_Update(Entity.ClaimManagement.ClaimApplicationMaster claimApplicationMaster)
{
return(DataAccess.ClaimManagement.ClaimApplication.Claim_AdjustAmount_Update(claimApplicationMaster));
}
public int Claim_StatusUpdate(Entity.ClaimManagement.ClaimApplicationMaster claimApplication)
{
return(DataAccess.ClaimManagement.ClaimApplication.Claim_StatusUpdate(claimApplication));
}
public DataTable ClaimApplication_GetAll(Entity.ClaimManagement.ClaimApplicationMaster ClaimApplicationMaster)
{
return(DataAccess.ClaimManagement.ClaimApplication.ClaimApplication_GetAll(ClaimApplicationMaster));
}
public DataTable ClaimApplicationDetails_GetByDate(Entity.ClaimManagement.ClaimApplicationMaster ClaimApplicationMaster)
{
return(DataAccess.ClaimManagement.ClaimApplication.ClaimApplicationDetails_GetByDate(ClaimApplicationMaster));
}
public Entity.ClaimManagement.ClaimApplicationMaster ClaimApplicationMaster_Save(Entity.ClaimManagement.ClaimApplicationMaster objClaimApplicationMaster)
{
return(DataAccess.ClaimManagement.ClaimApplication.ClaimApplicationMaster_Save(objClaimApplicationMaster));
}
public static DataTable ClaimApplication_GetAll(Entity.ClaimManagement.ClaimApplicationMaster ClaimApplicationMaster)
{
using (DataTable ds = new DataTable())
{
using (SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["constr"].ToString()))
{
using (SqlCommand cmd = new SqlCommand())
{
cmd.Connection = con;
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "usp_HR_ClaimApplication_GetAll";
if (ClaimApplicationMaster.ClaimApplicationId == 0)
{
cmd.Parameters.AddWithValue("@ClaimApplicationId", DBNull.Value);
}
else
{
cmd.Parameters.AddWithValue("@ClaimApplicationId", ClaimApplicationMaster.ClaimApplicationId);
}
if (ClaimApplicationMaster.EmployeeId == 0)
{
cmd.Parameters.AddWithValue("@EmployeeId", DBNull.Value);
}
else
{
cmd.Parameters.AddWithValue("@EmployeeId", ClaimApplicationMaster.EmployeeId);
}
if (ClaimApplicationMaster.PeriodFrom == DateTime.MinValue)
{
cmd.Parameters.AddWithValue("@FromDate", DBNull.Value);
}
else
{
cmd.Parameters.AddWithValue("@FromDate", ClaimApplicationMaster.PeriodFrom);
}
if (ClaimApplicationMaster.PeriodTo == DateTime.MinValue)
{
cmd.Parameters.AddWithValue("@ToDate", DBNull.Value);
}
else
{
cmd.Parameters.AddWithValue("@ToDate", ClaimApplicationMaster.PeriodTo);
}
if (ClaimApplicationMaster.Status == 0)
{
cmd.Parameters.AddWithValue("@StatusId", DBNull.Value);
}
else
{
cmd.Parameters.AddWithValue("@StatusId", ClaimApplicationMaster.Status);
}
using (SqlDataAdapter da = new SqlDataAdapter(cmd))
{
da.Fill(ds);
}
con.Close();
}
}
return(ds);
}
}
public static Entity.ClaimManagement.ClaimApplicationMaster ClaimApplicationMaster_Save(Entity.ClaimManagement.ClaimApplicationMaster claimApplicationMaster)
{
using (SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["constr"].ToString()))
{
using (SqlCommand cmd = new SqlCommand())
{
cmd.Connection = con;
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "usp_HR_Claim_Save";
cmd.Parameters.AddWithValue("@ClaimId", claimApplicationMaster.ClaimApplicationId);
if (string.IsNullOrEmpty(claimApplicationMaster.ClaimHeading))
{
cmd.Parameters.AddWithValue("@ClaimHeading", DBNull.Value);
}
else
{
cmd.Parameters.AddWithValue("@ClaimHeading", claimApplicationMaster.ClaimHeading);
}
if (string.IsNullOrEmpty(claimApplicationMaster.ClaimApplicationNumber))
{
cmd.Parameters.AddWithValue("@ClaimNo", DBNull.Value);
}
else
{
cmd.Parameters.AddWithValue("@ClaimNo", claimApplicationMaster.ClaimApplicationNumber);
}
if (claimApplicationMaster.EmployeeId == 0)
{
cmd.Parameters.AddWithValue("@EmployeeId", DBNull.Value);
}
else
{
cmd.Parameters.AddWithValue("@EmployeeId", claimApplicationMaster.EmployeeId);
}
if (claimApplicationMaster.PeriodFrom == DateTime.MinValue)
{
cmd.Parameters.AddWithValue("@PeriodFrom", DBNull.Value);
}
else
{
cmd.Parameters.AddWithValue("@PeriodFrom", claimApplicationMaster.PeriodFrom);
}
if (claimApplicationMaster.PeriodTo == DateTime.MinValue)
{
cmd.Parameters.AddWithValue("@PeriodTo", DBNull.Value);
}
else
{
cmd.Parameters.AddWithValue("@PeriodTo", claimApplicationMaster.PeriodTo);
}
if (claimApplicationMaster.CreatedBy == 0)
{
cmd.Parameters.AddWithValue("@CreatedBy", DBNull.Value);
}
else
{
cmd.Parameters.AddWithValue("@CreatedBy", claimApplicationMaster.CreatedBy);
}
if (claimApplicationMaster.TotalAmount == 0)
{
cmd.Parameters.AddWithValue("@TotalAmount", DBNull.Value);
}
else
{
cmd.Parameters.AddWithValue("@TotalAmount", claimApplicationMaster.TotalAmount);
}
if (claimApplicationMaster.Status == 0)
{
cmd.Parameters.AddWithValue("@Status", DBNull.Value);
}
else
{
cmd.Parameters.AddWithValue("@Status", claimApplicationMaster.Status);
}
if (claimApplicationMaster.ClaimDateTime == DateTime.MinValue)
{
cmd.Parameters.AddWithValue("@ClaimDateTime", DBNull.Value);
}
else
{
cmd.Parameters.AddWithValue("@ClaimDateTime", claimApplicationMaster.ClaimDateTime);
}
cmd.Parameters.AddWithValue("@AdjustRequestAmount", claimApplicationMaster.AdjustRequestAmount);
cmd.Parameters.AddWithValue("@ApprovedAmount", claimApplicationMaster.ApprovedAmount);
if (con.State == ConnectionState.Closed)
{
con.Open();
}
SqlDataReader dr = cmd.ExecuteReader();
if (dr.Read())
{
if (dr.HasRows)
{
claimApplicationMaster.ClaimApplicationId = Convert.ToInt32(dr["ClaimId"].ToString());
claimApplicationMaster.ClaimApplicationNumber = dr["ClaimNo"].ToString();
}
}
con.Close();
}
}
return(claimApplicationMaster);
}
