public void ContactListView_InsertItem(Contact contact) { if (ModelState.IsValid) { try { Service.SaveContact(contact); Session["succes"] = "Användaren lades till"; Response.Redirect("/Default.aspx"); } catch (Exception) { ModelState.AddModelError(String.Empty, "oväntat fel när kunden skulle Läggas till."); } } }
public void SaveContact(Contact contact) { // Validera affärsreglerna var validationContext = new ValidationContext(contact); var validationResults = new List<ValidationResult>(); if (!Validator.TryValidateObject(contact, validationContext, validationResults, true)) { var ex = new ValidationException("Kunden kunde inte sparas."); ex.Data.Add("ValidationResults", validationResults); throw ex; } if (contact.ContactID == 0) { ContactDAL.InsertContact(contact); } else { ContactDAL.UpdateContact(contact); } }
public void UpdateContact(Contact contact) { using (var conn = CreateConnection()) { try { var cmd = new SqlCommand("Person.uspUpdateContact", conn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@ContactID", SqlDbType.Int, 4).Value = contact.ContactID; cmd.Parameters.Add("@FirstName", SqlDbType.NVarChar, 50).Value = contact.FirstName; cmd.Parameters.Add("@LastName", SqlDbType.NVarChar, 50).Value = contact.LastName; cmd.Parameters.Add("@EmailAddress", SqlDbType.NVarChar, 50).Value = contact.EmailAdress; conn.Open(); cmd.ExecuteNonQuery(); } catch { throw new ArgumentException("Fel vid anslutning till databasen, InsertContact"); } } }
public void DeleteContact(Contact contact) { ContactDAL.DeleteContact(contact.ContactID); }