// GET: EquipmentRemoveButtons
public ActionResult Index()
{
var equipment = new Models.Equipment();
equipment.EquipmentID = GlobalEquipmentID;
return(View(equipment));
}
public ActionResult Details(int id)
{
GetDropwnList();
Models.Equipment obj = new Models.Equipment();
obj = equipmentContext.Equipments.Single(objid => objid.Id == id);
return(View(obj));
}
// GET: AddEquipment
public ActionResult Index()
{
var db = new CodeFirst.CodeFirst();
var equipments = new Models.Equipment();
var users = db.Users
.AsEnumerable()
.Select(u => new SelectListItem
{
Value = u.UserID.ToString(),
Text = u.FirstName + " " + u.LastName
}).ToList();
equipments.Users = users;
equipments.EquipmentTypes = db.Equipment_Type.ToList();
return(View(equipments));
/*var equipmentFromType = (Models.Equipment)TempData["EquipmentModel"];
* if (equipmentFromType != null)
* {
* equipmentFromType.EquipmentTypes = db.Equipment_Type.ToList();
* return View(equipmentFromType);
* }
* else
* {
* var equipments = new Models.Equipment();
* equipments.EquipmentTypes = db.Equipment_Type.ToList();
* return View(equipments);
* }*/
}
// GET: EquipmentDetails
public ActionResult Index(string equipmentID)
{
Models.Equipment myModel = new Models.Equipment();
CodeFirst.CodeFirst db = new CodeFirst.CodeFirst();
if (equipmentID != null)
{
var intEquipmentID = Int32.Parse(equipmentID);
var myEquipment = db.Equipments.Where(i => i.EquipmentID == intEquipmentID).FirstOrDefault();
var myUser = db.Users.Where(u => u.UserID == myEquipment.UserID).FirstOrDefault();
var myType = db.Equipment_Type.Where(t => t.TypeID == myEquipment.TypeID).FirstOrDefault();
myModel.EquipmentID = myEquipment.EquipmentID;
myModel.ManufacturerName = myEquipment.ManufacturerName;
myModel.ModelNumber = myEquipment.ModelNumber;
myModel.DatePurchased = myEquipment.DatePurchased;
myModel.ServiceIntervalMonths = myEquipment.ServiceIntervalMonths;
myModel.Status = myEquipment.Status;
myModel.UserID = myEquipment.UserID;
myModel.UserName = myUser != null ? myUser.FirstName + " " + myUser.LastName : "Not Assigned to User";
myModel.TypeID = myEquipment.TypeID;
myModel.TypeName = myType.TypeName;
}
return(View(myModel));
}
public ActionResult Edit(int?id)
{
GetDropwnList();
Models.Equipment obj = new Models.Equipment();
ViewBag.UserObj = obj;
obj = equipmentContext.Equipments.Single(objid => objid.Id == id);
return(View(obj));
}
public ActionResult DownloadoprpdfFile(int id)
{
Models.Equipment obj = equipmentContext.Equipments.SingleOrDefault(x => x.Id == id);
byte[] fileBytes = obj.OperatingInstructionpdf;
string fileName = obj.Asset + "Operationinstruction" + ".pdf";
return(File(fileBytes, "application/pdf", fileName));
}
public ActionResult DownloadcatpdfFile(int id)
{
Models.Equipment obj = equipmentContext.Equipments.SingleOrDefault(x => x.Id == id);
byte[] fileBytes = obj.Cataloguepdf;
string fileName = obj.Asset + "_Catalogue" + ".pdf";
return(File(fileBytes, "application/pdf", fileName));
}
public async Task CreateEquipment(Models.Equipment equipment)
{
using (ApplicationDbContext context = new ApplicationDbContext())
{
equipment.Id = Guid.NewGuid();
context.Equipment.Add(equipment);
await context.SaveChangesAsync();
}
}
public ActionResult RemoveFromCart(int id, string returnUrl)
{
Models.Equipment equipment = repository.GetEquipments().
FirstOrDefault(e => e.id == id);
if (equipment != null)
{
//GetCart().RemoveItem(equipment);
}
return(RedirectToAction("Index", new { returnUrl }));
}
// GET: Equipments
public ActionResult Index()
{
Models.Equipment myModel = new Models.Equipment();
if (TempData["model"] != null)
{
myModel = (Models.Equipment)TempData["model"];
TempData.Remove("model");
}
return(View(myModel));
}
public ActionResult Create([Bind(Prefix = "")] Models.Equipment model)
{
var db = new CodeFirst.CodeFirst();
if (ModelState.IsValid)
{
if (db.Equipments.Count() > 0)
{
var item = db.Equipments.OrderByDescending(a => a.EquipmentID).FirstOrDefault();
db.Equipments.Add(new CodeFirst.Equipment
{
EquipmentID = item.EquipmentID + 1,
ManufacturerName = model.ManufacturerName,
ModelNumber = model.ModelNumber,
DatePurchased = DateTime.ParseExact(model.DatePurchased.ToString("dd-MM-yyyy"), "dd-MM-yyyy", System.Globalization.CultureInfo.InvariantCulture),
ServiceIntervalMonths = model.ServiceIntervalMonths,
Status = model.Status,
UserID = model.UserID,
TypeID = model.TypeID
});
}
else
{
db.Equipments.Add(new CodeFirst.Equipment
{
EquipmentID = 1,
ManufacturerName = model.ManufacturerName,
ModelNumber = model.ModelNumber,
DatePurchased = DateTime.ParseExact(model.DatePurchased.ToString("dd-MM-yyyy"), "dd-MM-yyyy", System.Globalization.CultureInfo.InvariantCulture),
ServiceIntervalMonths = model.ServiceIntervalMonths,
Status = model.Status,
UserID = model.UserID,
TypeID = model.TypeID
});
}
db.SaveChanges();
model.JavaScriptToRun = "mySuccess()";
TempData["model"] = model;
return(RedirectToAction("Index", "Equipments"));
}
var users = db.Users
.AsEnumerable()
.Select(u => new SelectListItem
{
Value = u.UserID.ToString(),
Text = u.FirstName + " " + u.LastName
}).ToList();
model.Users = users;
model.EquipmentTypes = db.Equipment_Type.ToList();
return(View("Index", model));
}
public ActionResult AddToCart(int id, int days, string returnUrl)
{
Models.Equipment equipment = repository.GetEquipments().
FirstOrDefault(e => e.id == id);
if (equipment != null)
{
Cart cart = GetCart().AddItem(equipment, days);
SessionExtensions.Set(HttpContext.Session, "Cart", cart);
}
return(RedirectToAction("Index", "Equipment", new { returnUrl }));
}
public static void DelEq(int Id, int SchoolId)
{
using (EqService es = new EqService()) {
Models.Equipment eq = new Models.Equipment()
{
Id = Id
};
eq.IsDelete = true;
es.Delete(eq);
}
}
private ANDP.Lib.Domain.Models.Equipment CreateInstance(ResolutionContext rc)
{
var dest = new Models.Equipment();
var src = (ANDP.Lib.Data.Repositories.Order.Equipment)rc.SourceValue;
if (!string.IsNullOrEmpty(src.Xml))
{
dest = src.Xml.DeSerializeStringToObject <ANDP.Lib.Domain.Models.Equipment>();
}
dest.Xml = "";
return(dest);
}
public async Task EditEquipment(Models.Equipment equipment)
{
using (ApplicationDbContext context = new ApplicationDbContext())
{
var update = context.Equipment.Find(equipment.Id);
if (update != null)
{
update.EquipmentImage = equipment.EquipmentImage;
update.EquipmentName = equipment.EquipmentName;
update.Model = equipment.Model;
update.Brand = equipment.Brand;
update.RatePerHour = equipment.RatePerHour;
await context.SaveChangesAsync();
}
}
}
static private void CopyToInstance(PerformContext performContext, DbAppContext dbContext, HETSAPI.Import.EquipAttach oldObject, ref Models.EquipmentAttachment instance,
List <Models.Equipment> equips, string systemId)
{
if (oldObject.Equip_Id <= 0)
{
return;
}
//Add the user specified in oldObject.Modified_By and oldObject.Created_By if not there in the database
// Models.User modifiedBy = ImportUtility.AddUserFromString(dbContext, "", systemId, true);
Models.User createdBy = ImportUtility.AddUserFromString(dbContext, oldObject.Created_By, systemId);
if (instance == null)
{
instance = new Models.EquipmentAttachment();
int equipId = oldObject.Equip_Id ?? -1;
Models.Equipment equipment = equips.FirstOrDefault(x => x.Id == equipId);
if (equipment != null)
{
instance.Equipment = equipment;
instance.EquipmentId = equipment.Id;
}
instance.Description = oldObject.Attach_Desc == null ? "" : oldObject.Attach_Desc;
instance.TypeName = (oldObject.Attach_Seq_Num ?? -1).ToString();
if (oldObject.Created_Dt != null && oldObject.Created_Dt.Trim().Length >= 10)
{
instance.CreateTimestamp =
DateTime.ParseExact(oldObject.Created_Dt.Trim().Substring(0, 10), "yyyy-MM-dd", System.Globalization.CultureInfo.InvariantCulture);
}
instance.CreateUserid = createdBy.SmUserId;
dbContext.EquipmentAttachments.Add(instance);
}
else
{
instance = dbContext.EquipmentAttachments
.First(x => x.EquipmentId == oldObject.Equip_Id && x.TypeName == (oldObject.Attach_Seq_Num ?? -2).ToString());
instance.LastUpdateUserid = systemId; // modifiedBy.SmUserId;
instance.LastUpdateTimestamp = DateTime.UtcNow;
dbContext.EquipmentAttachments.Update(instance);
}
}
public ActionResult Create(Models.Equipment equipment)
{
if (ModelState.IsValid)
{
HttpPostedFileBase filephoto = Request.Files[0];
HttpPostedFileBase fileOperatingInstructionpdf = Request.Files[1];
HttpPostedFileBase fileDatasheetpdf = Request.Files[2];
HttpPostedFileBase fileCataloguepdf = Request.Files[3];
if (filephoto != null)
{
Stream fs = filephoto.InputStream;
BinaryReader br = new BinaryReader(fs);
byte[] bytes = br.ReadBytes((Int32)fs.Length);
equipment.Photo = bytes;
}
if (fileOperatingInstructionpdf != null)
{
Stream fs = fileOperatingInstructionpdf.InputStream;
BinaryReader br = new BinaryReader(fs);
byte[] bytes = br.ReadBytes((Int32)fs.Length);
equipment.OperatingInstructionpdf = bytes;
}
if (fileDatasheetpdf != null)
{
Stream fs = fileDatasheetpdf.InputStream;
BinaryReader br = new BinaryReader(fs);
byte[] bytes = br.ReadBytes((Int32)fs.Length);
equipment.Datasheetpdf = bytes;
}
if (fileCataloguepdf != null)
{
Stream fs = fileCataloguepdf.InputStream;
BinaryReader br = new BinaryReader(fs);
byte[] bytes = br.ReadBytes((Int32)fs.Length);
equipment.Cataloguepdf = bytes;
}
equipmentContext.Equipments.Add(equipment);
equipmentContext.SaveChanges();
return(RedirectToAction("Index"));
}
GetDropwnList();
return(View());
}
public ActionResult Index(Models.Equipment model)
{
CodeFirst.CodeFirst db = new CodeFirst.CodeFirst();
if (ModelState.IsValid)
{
Models.Equipment myModel = new Models.Equipment();
var myUser = db.Users.Where(u => u.UserID == model.UserID).FirstOrDefault();
var myType = db.Equipment_Type.Where(t => t.TypeID == model.TypeID).FirstOrDefault();
myModel.EquipmentID = model.EquipmentID;
myModel.ManufacturerName = model.ManufacturerName;
myModel.ModelNumber = model.ModelNumber;
myModel.DatePurchased = model.DatePurchased;
myModel.ServiceIntervalMonths = model.ServiceIntervalMonths;
myModel.Status = model.Status;
myModel.UserID = model.UserID;
myModel.TypeID = model.TypeID;
myModel.Users = db.Users
.AsEnumerable()
.Select(u => new SelectListItem
{
Value = u.UserID.ToString(),
Text = u.FirstName + " " + u.LastName
}).ToList();
myModel.EquipmentTypes = db.Equipment_Type.ToList();
return(View(myModel));
}
model.Users = db.Users
.AsEnumerable()
.Select(u => new SelectListItem
{
Value = u.UserID.ToString(),
Text = u.FirstName + " " + u.LastName
}).ToList();
model.EquipmentTypes = db.Equipment_Type.ToList();
return(View(model));
}
public ActionResult proofword([Bind(Prefix = "")] Models.Equipment model)
{
ReportDocument rd = new ReportDocument();
rd.Load(Path.Combine(Server.MapPath("~/Report/ProofofRemovalEquipment.rpt")));
rd.SetParameterValue("@EquipmentID", GlobalEquipmentID);
Response.Buffer = false;
Response.ClearContent();
Response.ClearHeaders();
try
{
Stream stream = rd.ExportToStream(CrystalDecisions.Shared.ExportFormatType.WordForWindows);
stream.Seek(0, SeekOrigin.Begin);
return(File(stream, "application/doc", "ProofofRemovableEquipment.doc"));
}
catch
{
throw;
}
}
/// <summary>
/// Copy xml item to instance (table entries)
/// </summary>
/// <param name="performContext"></param>
/// <param name="dbContext"></param>
/// <param name="oldObject"></param>
/// <param name="instance"></param>
/// <param name="systemId"></param>
static private void CopyToInstance(PerformContext performContext, DbAppContext dbContext, HETSAPI.Import.Rotation_Doc oldObject, ref Models.Note instance,
List <Models.Equipment> equips, List <Models.Project> projs, string systemId)
{
bool isNew = false;
//Add the user specified in oldObject.Modified_By and oldObject.Created_By if not there in the database
Models.User modifiedBy = ImportUtility.AddUserFromString(dbContext, "", systemId);
Models.User createdBy = ImportUtility.AddUserFromString(dbContext, oldObject.Created_By, systemId);
if (instance == null)
{
isNew = true;
instance = new Models.Note();
Models.Project proj = projs.FirstOrDefault(x => x.Id == oldObject.Project_Id);
Models.Equipment equip = equips.FirstOrDefault(x => x.Id == oldObject.Equip_Id);
if (equip != null)
{
if (equip.Notes == null)
{
equip.Notes = new List <Note>();
}
Models.Note note = new Note();
note.Text = new string(oldObject.Reason.Take(2048).ToArray());
note.IsNoLongerRelevant = true;
if (proj != null)
{ // The current model does not allow Project Id to be added to thge Note. while Note model should have Project ID
// note. = oldObject.Project_Id;
}
equip.Notes.Add(note);
dbContext.Equipments.Update(equip);
}
}
}
public ActionResult Modify([Bind(Prefix = "")] Models.Equipment model)
{
var db = new CodeFirst.CodeFirst();
if (ModelState.IsValid)
{
var equipment = db.Equipments.Where(v => v.EquipmentID == model.EquipmentID).SingleOrDefault();
if (equipment != null)
{
equipment.EquipmentID = model.EquipmentID;
equipment.ManufacturerName = model.ManufacturerName;
equipment.ModelNumber = model.ModelNumber;
equipment.DatePurchased = model.DatePurchased;
equipment.ServiceIntervalMonths = model.ServiceIntervalMonths;
equipment.Status = model.Status;
equipment.UserID = model.UserID;
equipment.TypeID = model.TypeID;
db.SaveChanges();
}
TempData["js"] = "myUpdateSuccess()";
return(RedirectToAction("Index", "Equipments"));
}
model.Users = db.Users
.AsEnumerable()
.Select(u => new SelectListItem
{
Value = u.UserID.ToString(),
Text = u.FirstName + " " + u.LastName
}).ToList();
model.EquipmentTypes = db.Equipment_Type.ToList();
return(View("Index", model));
}
public static double GetCycleTime(Models.Equipment equipment)
{
return((equipment.ProductionRunTime * 3600) / (equipment.ProductionCapacity - (equipment.RunCapacity * equipment.FirstPassYield)));
}
static private void CopyToInstance(PerformContext performContext, DbAppContext dbContext, HETSAPI.Import.Equip oldObject, ref Models.Equipment instance, string systemId)
{
bool isNew = false;
if (oldObject.Equip_Id <= 0)
{
return;
}
//Add the user specified in oldObject.Modified_By and oldObject.Created_By if not there in the database
Models.User modifiedBy = ImportUtility.AddUserFromString(dbContext, oldObject.Modified_By, systemId);
Models.User createdBy = ImportUtility.AddUserFromString(dbContext, oldObject.Created_By, systemId);
if (instance == null)
{
isNew = true;
instance = new Models.Equipment();
instance.Id = oldObject.Equip_Id;
// instance.DumpTruckId = oldObject.Reg_Dump_Trk;
instance.ArchiveCode = oldObject.Archive_Cd == null ? "" : new string(oldObject.Archive_Cd.Take(50).ToArray());
instance.ArchiveReason = oldObject.Archive_Reason == null ? "" : new string(oldObject.Archive_Reason.Take(2048).ToArray());
instance.LicencePlate = oldObject.Licence == null ? "" : new string(oldObject.Licence.Take(20).ToArray());
if (oldObject.Approved_Dt != null)
{
instance.ApprovedDate = DateTime.ParseExact(oldObject.Approved_Dt.Trim().Substring(0, 10), "yyyy-MM-dd", System.Globalization.CultureInfo.InvariantCulture);
}
if (oldObject.Received_Dt != null)
{
instance.ReceivedDate = DateTime.ParseExact(oldObject.Received_Dt.Trim().Substring(0, 10), "yyyy-MM-dd", System.Globalization.CultureInfo.InvariantCulture);
}
if (oldObject.Comment != null)
{
instance.Notes = new List <Note>();
Models.Note note = new Note();
note.Text = new string(oldObject.Comment.Take(2048).ToArray());
note.IsNoLongerRelevant = true;
instance.Notes.Add(note);
}
// instance.ArchiveDate = oldObject.
if (oldObject.Area_Id != null)
{
LocalArea area = dbContext.LocalAreas.FirstOrDefault(x => x.Id == oldObject.Area_Id);
if (area != null)
{
instance.LocalArea = area;
}
}
if (oldObject.Equip_Type_Id != null)
{
//Equipment_TYPE_ID is copied to the table of HET_DISTRICT_DISTRICT_TYPE as key
DistrictEquipmentType equipType = dbContext.DistrictEquipmentTypes.FirstOrDefault(x => x.Id == oldObject.Equip_Type_Id);
if (equipType != null)
{
instance.DistrictEquipmentType = equipType;
instance.DistrictEquipmentTypeId = oldObject.Equip_Type_Id;
}
}
instance.EquipmentCode = oldObject.Equip_Cd == null ? "" : new string(oldObject.Equip_Cd.Take(25).ToArray());
instance.Model = oldObject.Model == null ? "" : new string(oldObject.Model.Take(50).ToArray());
instance.Make = oldObject.Make == null ? "" : new string(oldObject.Make.Take(50).ToArray());
instance.Year = oldObject.Year == null ? "" : new string(oldObject.Year.Take(15).ToArray());
instance.Operator = oldObject.Operator == null ? "" : new string(oldObject.Operator.Take(255).ToArray());
// instance.RefuseRate = oldObject.Refuse_Rate == null ? "" : oldObject.Refuse_Rate;
instance.SerialNumber = oldObject.Serial_Num == null ? "" : new string(oldObject.Serial_Num.Take(100).ToArray());
instance.Status = oldObject.Status_Cd == null ? "" : new string(oldObject.Status_Cd.Take(50).ToArray());
if (oldObject.Pay_Rate != null)
{
try
{
instance.PayRate = float.Parse(oldObject.Pay_Rate.Trim());
}
catch (Exception e)
{
instance.PayRate = (float)0.0;
}
}
if (instance.Seniority != null)
{
try
{
instance.Seniority = float.Parse(oldObject.Seniority.Trim());
}
catch (Exception e)
{
instance.Seniority = (float)0.0;
}
}
// Find the owner which is referenced in the equipment of the xml file entry Through ImportMaps because owner_ID is not prop_ID
ImportMap map = dbContext.ImportMaps.FirstOrDefault(x => x.OldTable == ImportOwner.oldTable && x.OldKey == oldObject.Owner_Popt_Id.ToString());
if (map != null)
{
Models.Owner owner = dbContext.Owners.FirstOrDefault(x => x.Id == map.NewKey);
if (owner != null)
{
instance.Owner = owner;
Models.Contact con = dbContext.Contacts.FirstOrDefault(x => x.Id == owner.PrimaryContactId);
if (con != null) //This is used to update owner contact address
{
try
{
con.Address1 = oldObject.Addr1;
con.Address2 = oldObject.Addr2;
con.City = oldObject.City;
con.PostalCode = oldObject.Postal;
con.Province = "BC";
dbContext.Contacts.Update(con);
}
catch (Exception e)
{
string str = e.ToString();
}
}
}
}
if (oldObject.Seniority != null)
{
try
{
instance.Seniority = float.Parse(oldObject.Seniority.Trim());
}
catch (Exception e)
{
instance.Seniority = (float)0.0;
}
}
if (oldObject.Num_Years != null)
{
try
{
instance.YearsOfService = float.Parse(oldObject.Num_Years.Trim());
}
catch (Exception e)
{
instance.YearsOfService = (float)0.0;
}
}
if (oldObject.Block_Num != null)
{
try
{
instance.BlockNumber = decimal.ToInt32(Decimal.Parse(oldObject.Block_Num, System.Globalization.NumberStyles.Float));
}
catch (Exception e)
{
}
}
if (oldObject.Size != null)
{
try
{
instance.Size = oldObject.Size;
}
catch (Exception e)
{
}
}
if (oldObject.YTD1 != null && oldObject.YTD2 != null && oldObject.YTD3 != null)
{
try
{
instance.ServiceHoursLastYear = (float)Decimal.Parse(oldObject.YTD1, System.Globalization.NumberStyles.Any);
}
catch (Exception e)
{
instance.ServiceHoursLastYear = (float)0.0;
}
try
{
instance.ServiceHoursTwoYearsAgo = (float)Decimal.Parse(oldObject.YTD2, System.Globalization.NumberStyles.Any);
instance.ServiceHoursThreeYearsAgo = (float)Decimal.Parse(oldObject.YTD3, System.Globalization.NumberStyles.Any);
}
catch (Exception e)
{
instance.ServiceHoursTwoYearsAgo = (float)0.0;
instance.ServiceHoursThreeYearsAgo = (float)0.0;
}
}
instance.CreateTimestamp = DateTime.UtcNow;
instance.CreateUserid = createdBy.SmUserId;
dbContext.Equipments.Add(instance);
}
else
{
instance = dbContext.Equipments
.First(x => x.Id == oldObject.Equip_Id);
instance.LastUpdateUserid = modifiedBy.SmUserId;
try
{
instance.LastUpdateUserid = modifiedBy.SmUserId;
instance.LastUpdateTimestamp = DateTime.ParseExact(oldObject.Modified_Dt.Trim().Substring(0, 10), "yyyy-MM-dd", System.Globalization.CultureInfo.InvariantCulture);
}
catch (Exception e)
{
string str = e.ToString();
}
dbContext.Equipments.Update(instance);
}
}
static public void Import(PerformContext performContext, DbAppContext dbContext, string fileLocation, string systemId)
{
// Check the start point. If startPoint == sigId then it is already completed
int startPoint = ImportUtility.CheckInterMapForStartPoint(dbContext, oldTable_Progress, BCBidImport.sigId);
if (startPoint == BCBidImport.sigId) // This means the import job it has done today is complete for all the records in the xml file.
{
performContext.WriteLine("*** Importing " + xmlFileName + " is complete from the former process ***");
return;
}
string rootAttr = "ArrayOf" + oldTable;
//Create Processer progress indicator
performContext.WriteLine("Processing " + oldTable);
var progress = performContext.WriteProgressBar();
progress.SetValue(0);
// create serializer and serialize xml file
XmlSerializer ser = new XmlSerializer(typeof(Equip[]), new XmlRootAttribute(rootAttr));
MemoryStream memoryStream = ImportUtility.memoryStreamGenerator(xmlFileName, oldTable, fileLocation, rootAttr);
HETSAPI.Import.Equip[] legacyItems = (HETSAPI.Import.Equip[])ser.Deserialize(memoryStream);
int ii = startPoint;
if (startPoint > 0) // Skip the portion already processed
{
legacyItems = legacyItems.Skip(ii).ToArray();
}
foreach (var item in legacyItems.WithProgress(progress))
{
// see if we have this one already.
ImportMap importMap = dbContext.ImportMaps.FirstOrDefault(x => x.OldTable == oldTable && x.OldKey == item.Equip_Id.ToString());
if (importMap == null) // new entry
{
if (item.Equip_Id > 0)
{
Models.Equipment instance = null;
CopyToInstance(performContext, dbContext, item, ref instance, systemId);
ImportUtility.AddImportMap(dbContext, oldTable, item.Equip_Id.ToString(), newTable, instance.Id);
}
}
else // update
{
Models.Equipment instance = dbContext.Equipments.FirstOrDefault(x => x.Id == importMap.NewKey);
if (instance == null && item.Equip_Id > 0) // record was deleted
{
CopyToInstance(performContext, dbContext, item, ref instance, systemId);
// update the import map.
importMap.NewKey = instance.Id;
dbContext.ImportMaps.Update(importMap);
}
else // ordinary update.
{
if (item.Equip_Id > 0)
{
CopyToInstance(performContext, dbContext, item, ref instance, systemId);
// touch the import map.
importMap.LastUpdateTimestamp = DateTime.UtcNow;
dbContext.ImportMaps.Update(importMap);
}
}
}
if (ii++ % 1000 == 0) // Save change to database once a while to avoid frequent writing to the database.
{
try
{
ImportUtility.AddImportMap_For_Progress(dbContext, oldTable_Progress, ii.ToString(), BCBidImport.sigId);
int iResult = dbContext.SaveChangesForImport();
}
catch (Exception e)
{
string iStr = e.ToString();
}
}
}
try
{
performContext.WriteLine("*** Importing " + xmlFileName + " is Done ***");
ImportUtility.AddImportMap_For_Progress(dbContext, oldTable_Progress, BCBidImport.sigId.ToString(), BCBidImport.sigId);
int iResult = dbContext.SaveChangesForImport();
}
catch (Exception e)
{
string iStr = e.ToString();
}
}
/// <summary>
/// Copy xml item to instance (table entries)
/// </summary>
/// <param name="performContext"></param>
/// <param name="dbContext"></param>
/// <param name="oldObject"></param>
/// <param name="rentalAgreement"></param>
/// <param name="note"></param>
/// <param name="workedDate"></param>
/// <param name="systemId"></param>
static private void CopyToTimeRecorded(PerformContext performContext, DbAppContext dbContext, HETSAPI.Import.EquipUsage oldObject,
ref Models.RentalAgreement rentalAgreement, string note, string workedDate, List <Models.Equipment> equips, string systemId)
{
bool isNew = false;
//Add the user specified in oldObject.Modified_By and oldObject.Created_By if not there in the database
Models.User modifiedBy = ImportUtility.AddUserFromString(dbContext, "", systemId);
Models.User createdBy = ImportUtility.AddUserFromString(dbContext, oldObject.Created_By, systemId);
if (rentalAgreement == null)
{
isNew = true;
rentalAgreement = new Models.RentalAgreement();
rentalAgreement.RentalAgreementRates = new List <RentalAgreementRate>();
rentalAgreement.TimeRecords = new List <TimeRecord>();
Models.Equipment equip = equips.FirstOrDefault(x => x.Id == oldObject.Equip_Id); //dbContext.Equipments.FirstOrDefault(x => x.Id == oldObject.Equip_Id);
if (equip != null)
{
rentalAgreement.Equipment = equip;
rentalAgreement.EquipmentId = equip.Id;
}
Models.Project proj = dbContext.Projects.FirstOrDefault(x => x.Id == oldObject.Project_Id);
if (proj != null)
{
rentalAgreement.Project = proj;
rentalAgreement.ProjectId = proj.Id;
}
// Adding rental agreement rates and Time_Records: The two are added together becase Time Record reference rental agreement rate.
addingRate_Time_For_RentaAgreement(dbContext, oldObject, ref rentalAgreement, workedDate, systemId);
rentalAgreement.Status = "Imported from BCBid";
rentalAgreement.Note = note;
rentalAgreement.EquipmentRate = (float)Decimal.Parse(oldObject.Rate == null ? "0" : oldObject.Rate, System.Globalization.NumberStyles.Any);
if (oldObject.Entered_Dt != null)
{
rentalAgreement.DatedOn = DateTime.ParseExact(oldObject.Entered_Dt.Trim().Substring(0, 10), "yyyy-MM-dd", System.Globalization.CultureInfo.InvariantCulture);
}
if (oldObject.Created_Dt != null)
{
try
{
rentalAgreement.CreateTimestamp = DateTime.ParseExact(oldObject.Created_Dt.Trim().Substring(0, 10), "yyyy-MM-dd", System.Globalization.CultureInfo.InvariantCulture);
}
catch (Exception e)
{
rentalAgreement.CreateTimestamp = DateTime.UtcNow;
}
}
rentalAgreement.CreateUserid = createdBy.SmUserId;
dbContext.RentalAgreements.Add(rentalAgreement);
}
else
{
rentalAgreement = dbContext.RentalAgreements.First(x => x.Note == note);
if (rentalAgreement.RentalAgreementRates == null)
{
rentalAgreement.RentalAgreementRates = new List <RentalAgreementRate>();
}
if (rentalAgreement.TimeRecords == null)
{
rentalAgreement.TimeRecords = new List <TimeRecord>();
}
addingRate_Time_For_RentaAgreement(dbContext, oldObject, ref rentalAgreement, workedDate, systemId);
rentalAgreement.LastUpdateUserid = modifiedBy.SmUserId;
rentalAgreement.LastUpdateTimestamp = DateTime.UtcNow;
dbContext.RentalAgreements.Update(rentalAgreement);
}
}
public ActionResult Edit(Models.Equipment equipment)
{
if (ModelState.IsValid)
{
//Models.Equipment obj = new Models.Equipment();
//obj = equipmentContext.Equipments.Single(objid => objid.Id == equipment.Id);
HttpPostedFileBase filephoto = Request.Files[0];
HttpPostedFileBase fileOperatingInstructionpdf = Request.Files[1];
HttpPostedFileBase fileDatasheetpdf = Request.Files[2];
HttpPostedFileBase fileCataloguepdf = Request.Files[3];
if (filephoto.FileName != "")
{
byte[] bytes;
using (BinaryReader br = new BinaryReader(filephoto.InputStream))
{
bytes = br.ReadBytes(filephoto.ContentLength);
}
equipment.Photo = bytes;
}
if (fileOperatingInstructionpdf.FileName != "")
{
Stream fs = fileOperatingInstructionpdf.InputStream;
BinaryReader br = new BinaryReader(fs);
byte[] bytes = br.ReadBytes((Int32)fs.Length);
equipment.OperatingInstructionpdf = bytes;
}
if (fileDatasheetpdf.FileName != "")
{
Stream fs = fileDatasheetpdf.InputStream;
BinaryReader br = new BinaryReader(fs);
byte[] bytes = br.ReadBytes((Int32)fs.Length);
equipment.Datasheetpdf = bytes;
}
if (fileCataloguepdf.FileName != "")
{
Stream fs = fileCataloguepdf.InputStream;
BinaryReader br = new BinaryReader(fs);
byte[] bytes = br.ReadBytes((Int32)fs.Length);
equipment.Cataloguepdf = bytes;
}
equipmentContext.Entry(equipment).State = EntityState.Modified;
if (equipment.Photo == null)
{
equipmentContext.Entry(equipment).Property(x => x.Photo).IsModified = false;
}
if (equipment.OperatingInstructionpdf == null)
{
equipmentContext.Entry(equipment).Property(x => x.OperatingInstructionpdf).IsModified = false;
}
if (equipment.Cataloguepdf == null)
{
equipmentContext.Entry(equipment).Property(x => x.Cataloguepdf).IsModified = false;
}
if (equipment.Datasheetpdf == null)
{
equipmentContext.Entry(equipment).Property(x => x.Datasheetpdf).IsModified = false;
}
equipmentContext.SaveChanges();
return(RedirectToAction("Index"));
}
GetDropwnList();
return(View());
}
