public static int ClaimStatus_Save(Entity.ClaimManagement.ClaimStatus objClaimStatus)
{
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_ClaimStatus_Save";
cmd.Parameters.AddWithValue("@ClaimStatusId", objClaimStatus.ClaimStatusId);
cmd.Parameters.AddWithValue("@ClaimStatusName", objClaimStatus.ClaimStatusName);
cmd.Parameters.AddWithValue("@ClaimStatusDescription", objClaimStatus.ClaimStatusDescription);
if (con.State == ConnectionState.Closed)
{
con.Open();
}
retValue = cmd.ExecuteNonQuery();
con.Close();
}
}
return(retValue);
}
public int ClaimStatus_Delete(Entity.ClaimManagement.ClaimStatus objClaimStatus)
{
return(DataAccess.ClaimManagement.ClaimStatus.ClaimStatus_Delete(objClaimStatus));
}
public DataTable ClaimStatus_GetAll(Entity.ClaimManagement.ClaimStatus objClaimStatus)
{
return(DataAccess.ClaimManagement.ClaimStatus.ClaimStatus_GetAll());
}
