public static void Create(DeviceSurvey deviceSurvey)
{
var now = DateTime.UtcNow;
using (var context = new ClipperContext())
{
context.DeviceSurveys.Add(deviceSurvey);
context.Operator = deviceSurvey.Operator;
context.UserName = deviceSurvey.UserName;
context.SaveChanges(); // so we get the primary key of the created record
// IF CREATING ONE AUDITRECORD FOR A NEW RECORD
var auditRecord = new AuditRecord()
{
EntityName = "DeviceSurvey",
PrimaryKeyValue = deviceSurvey.ID.ToString(),
Action = "Created",
PropertyName = string.Empty,
OldValue = null,
NewValue = null,
DateChanged = now,
UserName = deviceSurvey.UserName,
Operator = deviceSurvey.Operator
};
context.AuditRecords.Add(auditRecord);
// IF CREATING AUDITRECORD FOR EACH FIELD OF A NEW RECORD
//foreach (var prop in deviceSurvey.GetType().GetProperties())
//{
// if (prop.Name == "DateCreated" || prop.Name == "LastUpdated")
// {
// continue;
// }
// var currentValue = prop.GetValue(deviceSurvey, null);
// var currentStringValue = currentValue == null ? "" : currentValue.ToString();
// var auditRecord = new AuditRecord()
// {
// EntityName = "DeviceSurvey",
// PrimaryKeyValue = deviceSurvey.ID.ToString(),
// Action = "Created",
// PropertyName = prop.Name,
// OldValue = null,
// NewValue = currentStringValue,
// DateChanged = now,
// UserName = deviceSurvey.UserName,
// Operator = deviceSurvey.Operator
// };
// context.AuditRecords.Add(auditRecord);
//}
context.SaveChanges();
}
}
public static void Update(DeviceSurvey deviceSurvey)
{
using (var context = new ClipperContext())
{
context.Entry(deviceSurvey).State = EntityState.Modified;
context.Operator = deviceSurvey.Operator;
context.UserName = deviceSurvey.UserName;
context.SaveChanges();
}
}
//public ActionResult Edit([Bind(Include = "ID,ReportingPeriod,Operator,UserName,Email,IsExpectingNewVehicles,HasGillig,HasNewFlyer,HasElDorado,HasOther,OtherName,GilligNewVehicles,GilligNewModel,GilligReplacementVehicles,GilligReplacementManufacturingDate,GilligReplacementDeliveryDate,GilligExpansionVehicles,GilligExpansionManufacturingDate,GilligExpansionDeliveryDate,NewFlyerNewVehicles,NewFlyerNewModel,NewFlyerReplacementVehicles,NewFlyerReplacementManufacturingDate,NewFlyerReplacementDeliveryDate,NewFlyerExpansionVehicles,NewFlyerExpansionManufacturingDate,NewFlyerExpansionDeliveryDate,ElDoradoNewVehicles,ElDoradoNewModel,ElDoradoReplacementVehicles,ElDoradoReplacementManufacturingDate,ElDoradoReplacementDeliveryDate,ElDoradoExpansionVehicles,ElDoradoExpansionManufacturingDate,ElDoradoExpansionDeliveryDate,OtherNewVehicles,OtherNewModel,OtherReplacementVehicles,OtherReplacementManufacturingDate,OtherReplacementDeliveryDate,OtherExpansionVehicles,OtherExpansionManufacturingDate,OtherExpansionDeliveryDate,OwnExistingVehicles,ExistingVehicleDetails,ReplacementVehicleDetails,PreWireRequirements,IncludedCosts,LastUpdated,RecordStatus,Notes")] DeviceSurvey deviceSurvey)
public ActionResult Edit(DeviceSurvey deviceSurvey)
{
if (ModelState.IsValid)
{
DeviceSurveyProvider.Update(deviceSurvey);
return(RedirectToAction("Index"));
}
return(View(deviceSurvey));
}
