public string AddCompany(Company company) { string result = string.Empty; try { SqlCommand cmd = new SqlCommand("sp_AddCompany"); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add(new SqlParameter("@Company", company.CompanyName)); cmd.Parameters.Add(new SqlParameter("@ContactNum", company.CompanyContactNumber)); result = ExecuteNonQuery(cmd); } catch (Exception ex) { result = "Sorry, the system is unable to add a company right now. Please try again later."; } return result; }
public string UpdateCompany(Company company) { try { SqlCommand cmd = new SqlCommand("sp_UpdateCompany"); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add(new SqlParameter("@Company", company.CompanyName)); cmd.Parameters.Add(new SqlParameter("@ContactNum", company.CompanyContactNumber)); cmd.Parameters.Add(new SqlParameter("@CompanyID", company.CompanyID)); return ExecuteNonQuery(cmd); } catch (Exception ex) { return "Sorry, the system is down right now. Please contact your system administrator."; } }