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