protected void gvClaimDetails_RowCommand(object sender, GridViewCommandEventArgs e)
{
try
{
if (e.CommandName == "U")
{
GridViewRow gridViewRow = (GridViewRow)(((LinkButton)e.CommandSource).NamingContainer);
HiddenField hdnChecked = (HiddenField)gridViewRow.FindControl("hdnChecked");
TextBox txtApprovedAmount = (TextBox)gridViewRow.FindControl("txtApprovedAmount");
TextBox txtApprovedRemarks = (TextBox)gridViewRow.FindControl("txtApprovedRemarks");
//DropDownList ddlLineItemStatus = (DropDownList)gridViewRow.FindControl("ddlLineItemStatus");
hdnChecked.Value = "Checked";
gridViewRow.Font.Italic = true;
gridViewRow.Attributes.CssStyle.Add("color", "#038a10");
Business.ClaimManagement.ClaimApplication objClaimApplication = new Business.ClaimManagement.ClaimApplication();
Entity.ClaimManagement.ClaimApplicationDetails claimApplicationDetails = new Entity.ClaimManagement.ClaimApplicationDetails()
{
ClaimApplicationDetailId = int.Parse(e.CommandArgument.ToString()),
ApprovedAmount = (string.IsNullOrEmpty(txtApprovedAmount.Text.Trim())) ? 0 : Convert.ToDecimal(txtApprovedAmount.Text.Trim()),
ApproverRemarks = txtApprovedRemarks.Text.Trim(),
Status = (int)ClaimStatusEnum.Approved
};
objClaimApplication.ClaimApplicationDetails_Save(claimApplicationDetails);
ComputeTotalApprovedAmount();
}
else if (e.CommandName == "A")
{
string claimAttachmentName = e.CommandArgument.ToString();
DownloadAttachment(claimAttachmentName);
}
}
catch (Exception ex)
{
ex.WriteException();
Message.IsSuccess = false;
Message.Text = ex.Message;
Message.Show = true;
}
finally
{
ModalPopupExtender1.Show();
}
}
private int ClaimApplicationDetails_Save(int claimApplicationId, DateTime expenseDate, string attachment, int categoryId, decimal cost, string description, int status)
{
Entity.ClaimManagement.ClaimApplicationDetails claimApplicationDetails = new Entity.ClaimManagement.ClaimApplicationDetails();
Business.ClaimManagement.ClaimApplication objClaimApplicationMaster = new Business.ClaimManagement.ClaimApplication();
claimApplicationDetails.ClaimApplicationDetailId = 0;
claimApplicationDetails.ClaimApplicationId = claimApplicationId;
claimApplicationDetails.ExpenseDate = expenseDate;
claimApplicationDetails.Attachment = attachment;
claimApplicationDetails.CategoryId = categoryId;
claimApplicationDetails.Cost = cost;
claimApplicationDetails.Description = description;
claimApplicationDetails.Status = status;
int response = objClaimApplicationMaster.ClaimApplicationDetails_Save(claimApplicationDetails);
return(response);
}
public static DataTable ClaimApplicationDetails_GetAll(Entity.ClaimManagement.ClaimApplicationDetails ClaimApplicationDetails)
{
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_GetAll";
if (ClaimApplicationDetails.ClaimApplicationId == 0)
{
cmd.Parameters.AddWithValue("@ClaimApplicationId", DBNull.Value);
}
else
{
cmd.Parameters.AddWithValue("@ClaimApplicationId", ClaimApplicationDetails.ClaimApplicationId);
}
if (ClaimApplicationDetails.ClaimApplicationDetailId == 0)
{
cmd.Parameters.AddWithValue("@ClaimApplicationDetailId", DBNull.Value);
}
else
{
cmd.Parameters.AddWithValue("@ClaimApplicationDetailId", ClaimApplicationDetails.ClaimApplicationDetailId);
}
using (SqlDataAdapter da = new SqlDataAdapter(cmd))
{
da.Fill(dt);
}
con.Close();
}
}
return(dt);
}
}
public DataTable ClaimApplicationDetails_GetAll(Entity.ClaimManagement.ClaimApplicationDetails ClaimApplicationDetails)
{
return(DataAccess.ClaimManagement.ClaimApplication.ClaimApplicationDetails_GetAll(ClaimApplicationDetails));
}
public int ClaimApplicationDetails_Save(Entity.ClaimManagement.ClaimApplicationDetails ClaimApplicationDetails)
{
return(DataAccess.ClaimManagement.ClaimApplication.ClaimApplicationDetails_Save(ClaimApplicationDetails));
}
public static int ClaimApplicationDetails_Save(Entity.ClaimManagement.ClaimApplicationDetails ClaimApplicationDetails)
{
int retValue = 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_ClaimDetails_Save";
cmd.Parameters.AddWithValue("@ClaimDetailsId", ClaimApplicationDetails.ClaimApplicationDetailId);
cmd.Parameters.AddWithValue("@ClaimId", ClaimApplicationDetails.ClaimApplicationId);
cmd.Parameters.AddWithValue("@Cost", ClaimApplicationDetails.Cost);
if (ClaimApplicationDetails.ExpenseDate == DateTime.MinValue)
{
cmd.Parameters.AddWithValue("@ExpenseDate", DBNull.Value);
}
else
{
cmd.Parameters.AddWithValue("@ExpenseDate", ClaimApplicationDetails.ExpenseDate);
}
if (string.IsNullOrEmpty(ClaimApplicationDetails.Attachment))
{
cmd.Parameters.AddWithValue("@Attachment", DBNull.Value);
}
else
{
cmd.Parameters.AddWithValue("@Attachment", ClaimApplicationDetails.Attachment);
}
if (ClaimApplicationDetails.CategoryId == 0)
{
cmd.Parameters.AddWithValue("@CategoryId", DBNull.Value);
}
else
{
cmd.Parameters.AddWithValue("@CategoryId", ClaimApplicationDetails.CategoryId);
}
if (string.IsNullOrEmpty(ClaimApplicationDetails.Description))
{
cmd.Parameters.AddWithValue("@Description", DBNull.Value);
}
else
{
cmd.Parameters.AddWithValue("@Description", ClaimApplicationDetails.Description);
}
if (ClaimApplicationDetails.Status == 0)
{
cmd.Parameters.AddWithValue("@Status", DBNull.Value);
}
else
{
cmd.Parameters.AddWithValue("@Status", ClaimApplicationDetails.Status);
}
if (string.IsNullOrEmpty(ClaimApplicationDetails.ApproverRemarks))
{
cmd.Parameters.AddWithValue("@ApproverRemarks", DBNull.Value);
}
else
{
cmd.Parameters.AddWithValue("@ApproverRemarks", ClaimApplicationDetails.ApproverRemarks);
}
cmd.Parameters.AddWithValue("@ApprovedAmount", ClaimApplicationDetails.ApprovedAmount);
if (con.State == ConnectionState.Closed)
{
con.Open();
}
retValue = cmd.ExecuteNonQuery();
con.Close();
}
}
return(retValue);
}