public static DataTable ClaimApprovalDetails_GetAll(Entity.ClaimManagement.ClaimApprovalConfiguration ClaimApprovalConfiguration)
{
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_ClaimApprovalConfig_GetAll";
if (ClaimApprovalConfiguration.ClaimApprovalConfigurationId == 0)
{
cmd.Parameters.AddWithValue("@ClaimApprovalConfigId", DBNull.Value);
}
else
{
cmd.Parameters.AddWithValue("@ClaimApprovalConfigId", ClaimApprovalConfiguration.ClaimApprovalConfigurationId);
}
using (SqlDataAdapter da = new SqlDataAdapter(cmd))
{
da.Fill(dt);
}
con.Close();
}
}
return(dt);
}
}
public static int ClaimEmployeeWiseApprovalConfiguration_Save(Entity.ClaimManagement.ClaimApprovalConfiguration ClaimApprovalConfiguration)
{
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_ClaimEmployeeWiseApprovalConfiguration_Save";
cmd.Parameters.AddWithValue("@ClaimEmployeeWiseApprovalConfigId", ClaimApprovalConfiguration.ClaimEmployeeWiseApprovalConfigurationId);
cmd.Parameters.AddWithValue("@EmployeeId", ClaimApprovalConfiguration.EmployeeId);
cmd.Parameters.AddWithValue("@ApproverId", ClaimApprovalConfiguration.ApproverId);
cmd.Parameters.AddWithValue("@ApproverLevel", ClaimApprovalConfiguration.ApprovalLevel);
cmd.Parameters.AddWithValue("@CreatedBy", ClaimApprovalConfiguration.CreatedBy);
if (con.State == ConnectionState.Closed)
{
con.Open();
}
retValue = cmd.ExecuteNonQuery();
con.Close();
}
}
return(retValue);
}
protected void btnSave_Click(object sender, EventArgs e)
{
try
{
Business.ClaimManagement.ClaimApprovalConfiguration objClaimApprovalConfiguration = new Business.ClaimManagement.ClaimApprovalConfiguration();
Entity.ClaimManagement.ClaimApprovalConfiguration ClaimApprovalConfiguration = new Entity.ClaimManagement.ClaimApprovalConfiguration();
ClaimApprovalConfiguration.ClaimApprovalConfigurationId = ClaimApprovalConfigurationId;
ClaimApprovalConfiguration.ApproverDesignationId = Convert.ToInt32(ddlApproverDesignation.SelectedValue);
ClaimApprovalConfiguration.ClaimDesignationConfigurationId = Convert.ToInt32(ddlRequestorDesignation.SelectedValue);
ClaimApprovalConfiguration.ApprovalLevel = Convert.ToInt32(ddlApprovalLevel.SelectedValue);
int response = objClaimApprovalConfiguration.ClaimApprovalConfig_Save(ClaimApprovalConfiguration);
if (response > 0)
{
Clear();
ClaimApprovalConfig_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 DataTable ClaimEmployeeWiseApprovalConfiguration_GetAll(Entity.ClaimManagement.ClaimApprovalConfiguration ClaimApprovalConfiguration)
{
return(DataAccess.ClaimManagement.ClaimApprovalConfiguration.ClaimEmployeeWiseApprovalConfiguration_GetAll(ClaimApprovalConfiguration));
}
public int ClaimEmployeeWiseApprovalConfiguration_Save(Entity.ClaimManagement.ClaimApprovalConfiguration ClaimApprovalConfiguration)
{
return(DataAccess.ClaimManagement.ClaimApprovalConfiguration.ClaimEmployeeWiseApprovalConfiguration_Save(ClaimApprovalConfiguration));
}
