public void CustomerFormView_InsertItem(Customer customer) { if (ModelState.IsValid) { try { Service.SaveContact(customer); Session["succes"] = "Användaren sparades"; Response.Redirect("/Pages/AddCustomer.aspx"); } catch (Exception) { ModelState.AddModelError(String.Empty, "oväntat fel när kunden skulle Läggas till."); } } }
public void SaveContact(Customer customer) { // Validera affärsreglerna var validationContext = new ValidationContext(customer); var validationResults = new List<ValidationResult>(); if (!Validator.TryValidateObject(customer, validationContext, validationResults, true)) { var ex = new ValidationException("Kunden kunde inte sparas."); ex.Data.Add("ValidationResults", validationResults); throw ex; } if (customer.CustomerID == 0) { CustomerDAL.InsertCustomer(customer); } else { CustomerDAL.UpdateCustomer(customer); } }
// Redigera en kund public void UpdateCustomer(Customer Customer) { using (var conn = CreateConnection()) { try { var cmd = new SqlCommand("dbo.usp_UpdateCustomer", conn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@CustomerID", SqlDbType.Int, 4).Value = Customer.CustomerID; cmd.Parameters.Add("@CustomerNUM", SqlDbType.Int, 4).Value = Customer.CustomerNUM; cmd.Parameters.Add("@Name", SqlDbType.VarChar, 25).Value = Customer.Name; cmd.Parameters.Add("@City", SqlDbType.VarChar, 25).Value = Customer.City; cmd.Parameters.Add("@PostalCode", SqlDbType.VarChar, 6).Value = Customer.PostalCode; cmd.Parameters.Add("@Phone", SqlDbType.VarChar, 15).Value = Customer.Phone; conn.Open(); cmd.ExecuteNonQuery(); } catch { throw new ArgumentException("Fel vid anslutning till databasen"); } } }