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()); }