public static int ClaimDesignationConfig_Save(Entity.ClaimManagement.ClaimDesignationWiseConfiguration ClaimDesignationWiseConfiguration)
{
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_ClaimDesignationConfig_Save";
cmd.Parameters.AddWithValue("@ClaimDesignationConfigId", ClaimDesignationWiseConfiguration.ClaimDesignationConfigId);
cmd.Parameters.AddWithValue("@ClaimCategoryId", ClaimDesignationWiseConfiguration.ClaimCategoryId);
cmd.Parameters.AddWithValue("@DesignationId", ClaimDesignationWiseConfiguration.DesignationId);
cmd.Parameters.AddWithValue("@Limit", ClaimDesignationWiseConfiguration.Limit);
cmd.Parameters.AddWithValue("@FollowupInterval", ClaimDesignationWiseConfiguration.FollowupInterval);
if (con.State == ConnectionState.Closed)
{
con.Open();
}
retValue = cmd.ExecuteNonQuery();
con.Close();
}
}
return(retValue);
}
private void ClaimDesignationWiseConfiguration_GetAll()
{
Business.ClaimManagement.ClaimDesignationWiseConfiguration objClaimDesignationWiseConfiguration = new Business.ClaimManagement.ClaimDesignationWiseConfiguration();
Entity.ClaimManagement.ClaimDesignationWiseConfiguration ClaimDesignationWiseConfiguration = new Entity.ClaimManagement.ClaimDesignationWiseConfiguration();
DataTable dt = objClaimDesignationWiseConfiguration.ClaimDesignationConfig_GetAll(ClaimDesignationWiseConfiguration);
gvClaimDesignationConfiguration.DataSource = dt;
gvClaimDesignationConfiguration.DataBind();
}
private bool ClaimDesignationConfigValidate()
{
bool retValue = true;
if (ddlClaimCategory.SelectedIndex == 0)
{
Message.IsSuccess = false;
Message.Text = "Please select Claim Type.";
Message.Show = true;
return(false);
}
if (ddlDesignation.SelectedIndex == 0)
{
Message.IsSuccess = false;
Message.Text = "Please select Designation.";
Message.Show = true;
return(false);
}
if (string.IsNullOrEmpty(txtClaimLimit.Text.Trim()))
{
Message.IsSuccess = false;
Message.Text = "Please enter Claim Limit.";
Message.Show = true;
return(false);
}
Business.ClaimManagement.ClaimDesignationWiseConfiguration objClaimDesignationWiseConfiguration = new Business.ClaimManagement.ClaimDesignationWiseConfiguration();
Entity.ClaimManagement.ClaimDesignationWiseConfiguration ClaimDesignationWiseConfiguration = new Entity.ClaimManagement.ClaimDesignationWiseConfiguration();
ClaimDesignationWiseConfiguration.ClaimCategoryId = Convert.ToInt32(ddlClaimCategory.SelectedValue);
ClaimDesignationWiseConfiguration.DesignationId = Convert.ToInt32(ddlDesignation.SelectedValue);
DataTable dt = objClaimDesignationWiseConfiguration.ClaimDesignationConfig_GetAll(ClaimDesignationWiseConfiguration);
if (ClaimDesignationWiseConfigurationId == 0)
{
if (dt != null && dt.AsEnumerable().Any())
{
Message.IsSuccess = false;
Message.Text = "Designation configuration already exists.";
Message.Show = true;
return(false);
}
}
else
{
if (dt == null || !dt.AsEnumerable().Any())
{
Message.IsSuccess = false;
Message.Text = "Designation configuration does not exists.";
Message.Show = true;
return(false);
}
}
return(retValue);
}
protected void btnSave_Click(object sender, EventArgs e)
{
try
{
if (ClaimDesignationConfigValidate())
{
Business.ClaimManagement.ClaimDesignationWiseConfiguration objClaimDesignationWiseConfiguration = new Business.ClaimManagement.ClaimDesignationWiseConfiguration();
Entity.ClaimManagement.ClaimDesignationWiseConfiguration ClaimDesignationWiseConfiguration = new Entity.ClaimManagement.ClaimDesignationWiseConfiguration();
ClaimDesignationWiseConfiguration.ClaimDesignationConfigId = ClaimDesignationWiseConfigurationId;
ClaimDesignationWiseConfiguration.ClaimCategoryId = Convert.ToInt32(ddlClaimCategory.SelectedValue);
ClaimDesignationWiseConfiguration.DesignationId = Convert.ToInt32(ddlDesignation.SelectedValue);
ClaimDesignationWiseConfiguration.Limit = Convert.ToDecimal(txtClaimLimit.Text.Trim());
ClaimDesignationWiseConfiguration.FollowupInterval = Convert.ToInt32(txtFollowupInterval.Text.Trim());
int response = objClaimDesignationWiseConfiguration.ClaimDesignationConfig_Save(ClaimDesignationWiseConfiguration);
if (response > 0)
{
Clear();
GlobalCache.RemoveAll();
ClaimDesignationWiseConfiguration_GetAll();
Message.IsSuccess = true;
Message.Text = "Saved Successfully";
}
else
{
Message.IsSuccess = false;
Message.Text = "Exists";
}
}
Message.Show = true;
}
catch (Exception ex)
{
ex.WriteException();
Message.IsSuccess = false;
Message.Text = ex.Message;
Message.Show = true;
}
}
public static DataTable ClaimDesignationConfig_GetAll(Entity.ClaimManagement.ClaimDesignationWiseConfiguration ClaimDesignationWiseConfiguration)
{
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_ClaimDesignationConfig_GetAll";
if (ClaimDesignationWiseConfiguration.ClaimCategoryId == 0)
{
cmd.Parameters.AddWithValue("@ClaimCategoryId", DBNull.Value);
}
else
{
cmd.Parameters.AddWithValue("@ClaimCategoryId", ClaimDesignationWiseConfiguration.ClaimCategoryId);
}
if (ClaimDesignationWiseConfiguration.DesignationId == 0)
{
cmd.Parameters.AddWithValue("@DesignationId", DBNull.Value);
}
else
{
cmd.Parameters.AddWithValue("@DesignationId", ClaimDesignationWiseConfiguration.DesignationId);
}
using (SqlDataAdapter da = new SqlDataAdapter(cmd))
{
da.Fill(dt);
}
con.Close();
}
}
return(dt);
}
}
public static DataTable ClaimDesignationConfig_GetAllCached(Entity.ClaimManagement.ClaimDesignationWiseConfiguration ClaimDesignationWiseConfiguration)
{
return(DataAccess.ClaimManagement.ClaimDesignationWiseConfiguration.ClaimDesignationConfig_GetAll(ClaimDesignationWiseConfiguration));
}
public int ClaimDesignationConfig_Save(Entity.ClaimManagement.ClaimDesignationWiseConfiguration objClaimDesignation)
{
return(DataAccess.ClaimManagement.ClaimDesignationWiseConfiguration.ClaimDesignationConfig_Save(objClaimDesignation));
}