public void addCustomer(General.Customer customer)
{
SqlConnection con;
con = new SqlConnection(connectionString);
con.Open();
SqlCommand cmd1 = new SqlCommand("insert into customer(fullName, email, maxQuota, currentQuota, serviceClass, photo) values(@fn, @e, @maxQ, @cQ, @sc, @p);", con);
cmd1.Parameters.Add("@fn", customer.fullName);
cmd1.Parameters.Add("@e", customer.email);
cmd1.Parameters.Add("@maxQ", customer.maxQuota);
cmd1.Parameters.Add("@cQ", customer.currentQuota);
cmd1.Parameters.Add("@sc", customer.serviceClass);
cmd1.Parameters.Add("@p", customer.photo);
cmd1.ExecuteNonQuery();
con.Close();
}
public void updateCustomer(General.Customer customer)
{
SqlConnection con;
con = new SqlConnection(connectionString);
con.Open();
SqlCommand cmd1 = new SqlCommand("update customer set fullName=@fn, email=@e, maxQuota=@maxQ, currentQuota=@cQ, serviceClass=@sc, photo=@p where id=@id;", con);
cmd1.Parameters.Add("@fn", customer.fullName);
cmd1.Parameters.Add("@e", customer.email);
cmd1.Parameters.Add("@maxQ", customer.maxQuota);
cmd1.Parameters.Add("@cQ", customer.currentQuota);
cmd1.Parameters.Add("@sc", customer.serviceClass);
cmd1.Parameters.Add("@p", customer.photo);
cmd1.Parameters.Add("@id", customer.id);
cmd1.ExecuteNonQuery();
con.Close();
}
