public string GetCustomer(string firstname, string lastname) { Customer customer1 = customerMethods.GetCustomer("firstname", firstname); Customer customer2 = customerMethods.GetCustomer("lastname", lastname); string jsonCustomer; if (customer1.FirstName != null) { jsonCustomer = JsonConvert.SerializeObject(customer1); } else { jsonCustomer = JsonConvert.SerializeObject(customer2); } return(jsonCustomer); }
public void SaveCustomer(CustomerInfo customer) { string cs = ConfigurationManager.ConnectionStrings["DBCS"].ConnectionString; Customer existingCustumer = customerMethods.GetCustomer("lastname", customer.LastName); if (existingCustumer == null) { using (SqlConnection con = new SqlConnection(cs)) { SqlCommand cmd = new SqlCommand("spAddNewCustomer", con); cmd.CommandType = CommandType.StoredProcedure; SqlParameter parameterFirstname = new SqlParameter { ParameterName = "@FirstName", Value = customer.FirstName }; cmd.Parameters.Add(parameterFirstname); SqlParameter parameterLastname = new SqlParameter { ParameterName = "@LastName", Value = customer.LastName }; cmd.Parameters.Add(parameterLastname); SqlParameter parameterPhone = new SqlParameter { ParameterName = "@Phone", Value = customer.Phone }; cmd.Parameters.Add(parameterPhone); SqlParameter parameterEmail = new SqlParameter { ParameterName = "@Email", Value = customer.Email }; cmd.Parameters.Add(parameterEmail); con.Open(); cmd.ExecuteNonQuery(); } } }
public CustomerDetails getCustomer(int id) { CustomerDetails cd = new CustomerDetails(); CustomerMethods cm = new CustomerMethods(); cd = cm.GetCustomer(id, out string errormsg); return(cd); }
public Customer GetCustomer(string option, string term) { return(customerMethods.GetCustomer(option, term)); }