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