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