public string UpdatePolicyType(PolicyType polType)
{
try
{
SqlCommand cmd = new SqlCommand("sp_UpdatePolicyType");
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@PolicyType", polType.PolicyTypeName));
cmd.Parameters.Add(new SqlParameter("@PolicyTypeDesc", polType.PolicyTypeDesc));
cmd.Parameters.Add(new SqlParameter("@PolicyTypeID", polType.PolicyTypeID));
return ExecuteNonQuery(cmd);
}
catch (Exception ex)
{
return "Sorry, the system is down right now. Please contact your system administrator.";
}
}
public string AddPolicyType(PolicyType policyType)
{
string result = "";
try
{
SqlCommand cmd = new SqlCommand("sp_AddPolicyType");
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@PolicyType", policyType.PolicyTypeName));
cmd.Parameters.Add(new SqlParameter("@PolicyTypeDesc", policyType.PolicyTypeDesc));
result = ExecuteNonQuery(cmd);
}
catch (Exception ex)
{
result = "Sorry, the system is down right now. Please try again later.";
}
return result;
}