public void StatusListView_InsertItem(Status status)
{
if (ModelState.IsValid)
{
try
{
Service.UpdateStatus(status);
//Session["Success"] = true;
//Response.RedirectToRoute("Default");
}
catch (Exception)
{
ModelState.AddModelError(String.Empty, "Ett oväntat fel inträffade då status uppgiften skulle läggas till.");
}
}
}
/// <summary>
/// Updates status
/// </summary>
/// <param name="status"></param>
public void UpdateStatus(Status status)
{
using (SqlConnection conn = CreateConnection())
{
try
{
SqlCommand cmd = new SqlCommand("appSchema.uspUpdateStatus", conn);
cmd.CommandType = CommandType.StoredProcedure;
conn.Open();
cmd.Parameters.Add("@StatusID", SqlDbType.Int, 4).Value = status.StatusID;
cmd.Parameters.Add("@StatusType", SqlDbType.NVarChar, 20).Value = status.StatusType;
cmd.ExecuteNonQuery();
}
catch
{
throw new ApplicationException("An error occured in the data access layer.");
}
}
}
public void UpdateStatus(Status status)
{
ICollection<ValidationResult> validationResults;
if (!status.Validate(out validationResults))
{
var ex = new ValidationException("Objektet klarade inte valideringen.");
ex.Data.Add("ValidationResults", validationResults);
throw ex;
}
if (status.StatusID == 0) // New post if ID is 0!
{
StatusDAL.InsertStatus(status);
}
else
{
StatusDAL.UpdateStatus(status);
}
}
