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