public void FormView3_InsertItem(PhysicalRecord physrecord) { if (ModelState.IsValid) { try { physrecord.RecordID = Id; var pricevalue = ((TextBox)FormView3.FindControl("PriceTextBox")).Text; //TODO fixa så det funkar utan InvariantCulture var Price = decimal.Parse(pricevalue, CultureInfo.InvariantCulture); physrecord.PriceAtPurchase = Price; Service.SavePhysicalRecord(physrecord); //RecordTypeID 3 är 'multi', både som fysisk och digital Record.RecordTypeID = 3; Service.SaveRecord(Record); Response.RedirectToRoute("RecordDetails", new { id = physrecord.RecordID }); } catch { ModelState.AddModelError(String.Empty, "Ett fel inträffade när skivan skulle läggas in"); } } }
public void InsertPhysicalRecord(PhysicalRecord physrecord) { using (var conn = CreateConnection()) { try { SqlCommand cmd = new SqlCommand("appschema.usp_InsertPhysical", conn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@Priceatpurchase", SqlDbType.Decimal).Value = physrecord.PriceAtPurchase; cmd.Parameters.Add("@Dateofpurchase", SqlDbType.Date).Value = physrecord.DateofPurchase; cmd.Parameters.Add("@RecordID", SqlDbType.Int).Value = physrecord.RecordID; conn.Open(); cmd.ExecuteNonQuery(); } catch { throw new ApplicationException("An error occured while getting customers from the database."); } } }
public void FormView1_InsertItem(Record record) { if (ModelState.IsValid) { try { record.RecordTypeID = 1; Service.SaveRecord(record); var pricevalue = ((TextBox)FormView1.FindControl("PriceTextBox")).Text; //TODO fixa så det funkar utan InvariantCulture //CultureInfo.InvariantCulture var Price = decimal.Parse(pricevalue); var Purchasedate = DateTime.Parse(((TextBox)FormView1.FindControl("PurchaseDateTextBox")).Text); var physrecord = new PhysicalRecord { RecordID = record.RecordID, PriceAtPurchase = Price, DateofPurchase = Purchasedate }; Service.SavePhysicalRecord(physrecord); RecordID = record.RecordID; Response.RedirectToRoute("RecordDetails", new { id = physrecord.RecordID }); Context.ApplicationInstance.CompleteRequest(); } catch (Exception) { ModelState.AddModelError(String.Empty, "Ett fel inträffade då skivan skulle sparas"); } } }
public void SavePhysicalRecord(PhysicalRecord physrecord) { ICollection<ValidationResult> validationResults; if(!physrecord.Validate(out validationResults)){ var ex = new ValidationException("Objektet klarade inte valideringen."); ex.Data.Add("ValidationResults", validationResults); throw ex; } PhysicalRecordDAL.InsertPhysicalRecord(physrecord); }
public void UpdatePhysicalRecord(PhysicalRecord physrecord) { /*ICollection<ValidationResult> validationResults; * if(!customer.Validate(out validationResults){ * * var ex = new ValidationException("Objektet klarade inte valideringen."); * ex.Data.Add("ValidationResults", validationResults); * throw ex; * } */ PhysicalRecordDAL.UpdatePhysicalRecord(physrecord); }
/// <summary> /// SavePhysicalRecord /// Sparar en skiva m. hjälp av en referens till ett PhysicalRecord-obj. /// </summary> /// <param name="record"></param> #region SavePhysicalRecord public void SavePhysicalRecord(PhysicalRecord physrecord) { ICollection <ValidationResult> validationResults; if (!physrecord.Validate(out validationResults)) { var ex = new ValidationException("Objektet klarade inte valideringen."); ex.Data.Add("ValidationResults", validationResults); throw ex; } PhysicalRecordDAL.InsertPhysicalRecord(physrecord); }
/// <summary> /// UpdatePhysicalRecord /// Uppdaterar info om en skiva i tabellen Fysisk Skiva, m. hjälp av /// informationen i referensen till ett PhysicalRecord-obj. /// </summary> /// <param name="physrecord"></param> #region UpdatePhysicalRecord public void UpdatePhysicalRecord(PhysicalRecord physrecord) { using (var conn = CreateConnection()) { try { SqlCommand cmd = new SqlCommand("appschema.usp_UpdatePhysicalRecord", conn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@Priceatpurchase", SqlDbType.Decimal).Value = physrecord.PriceAtPurchase; cmd.Parameters.Add("@Dateofpurchase", SqlDbType.Date).Value = physrecord.DateofPurchase; cmd.Parameters.Add("@RecordID", SqlDbType.Int).Value = physrecord.RecordID; conn.Open(); cmd.ExecuteNonQuery(); } catch { throw new ApplicationException("An error occured while getting records from the database."); } } }
public void UpdatePhysicalRecord(PhysicalRecord physrecord) { /*ICollection<ValidationResult> validationResults; if(!customer.Validate(out validationResults){ var ex = new ValidationException("Objektet klarade inte valideringen."); ex.Data.Add("ValidationResults", validationResults); throw ex; } */ PhysicalRecordDAL.UpdatePhysicalRecord(physrecord); }