public MachineMaster Add(MachineMaster MA, string userid) { var sqlQuery = @"INSERT INTO MACHINE (IDMACHINE, MACHINENAME, STATION, OWNERSHIP, FIXEDASSET, PURCHASEDATE, PURCHASECOST, ISACTIVE, ISACTIVEDATE, COMPANYSITE, INPUTBY, INPUTDATE, UPDATEBY, UPDATEDATE) VALUES ('" + MA.IDMACHINE + @"', '" + MA.MACHINENAME + "', '" + MA.STATION + "', '" + MA.OWNERSHIP + "', '" + MA.FIXEDASSET + "', '" + MA.PURCHASEDATE + "', '" + MA.PURCHASECOST + "', '" + MA.ISACTIVE + "', '" + MA.ISACTIVEDATE + "', '" + MA.COMPANYSITE + "', " + Convert.ToInt32(userid) + ", '" + DateTime.Now + @"', " + Convert.ToInt32(userid) + ", '" + DateTime.Now + @"'); " + "SELECT CAST(SCOPE_IDENTITY() as int)"; var SID = _db.Query <int>(sqlQuery, MA).Single(); MA.SID = SID; return(MA); }
/// <summary> /// Updates the MachineInfo /// </summary> /// <param name="MachineInfo">MachineInfo</param> public void UpdateMachineInfo(MachineMaster machineMaster) { if (machineMaster == null) { throw new ArgumentNullException(nameof(machineMaster)); } _machineRepository.Update(machineMaster); }
public MachineMaster Update(MachineMaster MA, string userid) { var sqlQuery = string.Format(@"UPDATE MACHINE SET IDMACHINE = '{0}', MACHINENAME = '{1}', STATION = '{2}', OWNERSHIP = '{3}', FIXEDASSET = '{4}', PURCHASEDATE = '{5}', PURCHASECOST = '{6}', ISACTIVE = '{7}', ISACTIVEDATE = '{8}', COMPANYSITE = '{9}', UPDATEBY = {10}, UPDATEDATE = '{11}' WHERE SID = {12}", MA.IDMACHINE, MA.MACHINENAME, MA.STATION, MA.OWNERSHIP, MA.FIXEDASSET, MA.PURCHASEDATE, MA.PURCHASECOST, MA.ISACTIVE, MA.ISACTIVEDATE, MA.COMPANYSITE, Convert.ToInt32(userid), DateTime.Now, MA.SID); this._db.Execute(sqlQuery, MA); return(MA); }
// // GET: /Machine/Create public ActionResult Create() { var model = new MachineMaster(); model.ISACTIVE = true; model.GetSelectListStation = GetSelectListStation(); model.GetSelectListFixedAsset = GetSelectListFixedAsset(); model.GetSelectListOwnership = GetSelectListOwnership(); return(View(model)); }
public void EditMachineMaster_Data(MachineMaster machineMaster, string username, string password) { MachineMaster macn_Mstr = context.MachineMaster.FirstOrDefault(a => a.MachineCode == machineMaster.MachineCode); macn_Mstr.MachineName = machineMaster.MachineName; macn_Mstr.MachineMake = machineMaster.MachineMake; macn_Mstr.MachineHourRate = machineMaster.MachineHourRate; macn_Mstr.DateOfPurchased = machineMaster.DateOfPurchased; macn_Mstr.ModifiedBy = username; macn_Mstr.ModifiedDate = DateTime.Now; context.SaveChanges(); }
public ActionResult Edit(MachineMaster Machine) { if (ModelState.IsValid) { Machine.COMPANYSITE = int.Parse(Session["companysite"].ToString()); Machine.ISACTIVEDATE = DateTime.Now; Machine.UPDATEDATE = DateTime.Now; VM.Update(Machine, Session["userid"].ToString()); TempData["successmessage"] = "Saved successfully"; return(RedirectToAction("Index")); } else { Machine.GetSelectListStation = GetSelectListStation(); Machine.GetSelectListFixedAsset = GetSelectListFixedAsset(); Machine.GetSelectListOwnership = GetSelectListOwnership(); return(View(Machine)); } }
public MachineMaster GetMachineDescriptionById(MachineTypes machineTypes) { try { MachineMaster machineMaster = new MachineMaster() { MachineSliderImages = unitOfWork.MachineSliderImages.Find(ms => ms.MachineId == machineTypes.MachineId).ToList(), MachineRating = unitOfWork.MachineDescription.GetMachineRating(machineTypes.MachineId), MachineSpecifications = unitOfWork.MachineDescription.Find(md => md.MachineId == machineTypes.MachineId).SingleOrDefault(), RelatedVideos = unitOfWork.MachineVideos.Find(mv => mv.MachineId == machineTypes.MachineId).ToList() }; return(machineMaster); } catch (Exception ex) { return(null); } finally { unitOfWork.Dispose(); } }
public void EditMachineMaster_Data(MachineMaster machineMaster, string username, string password) { masterReports.EditMachineMaster_Data(machineMaster, username, password); }
public static MachineModel ToModel(this MachineMaster entity) { return(entity.MapTo <MachineMaster, MachineModel>()); }
public ActionResult Create(MachineModel model) { ResultModel resultModel = new ResultModel(); try { if (model.Id == 0) { var machineData = new MachineMaster(); machineData.EquipmentId = model.EquipmentId; machineData.EquipSerial = model.EquipSerial; machineData.KitTypeId = model.KitTypeId; machineData.KitTypeSerial = model.KitTypeSerial; machineData.PMDate = model.PMDate; machineData.ExpDate = model.ExpDate; machineData.SafetyChkDate = model.SafetyChkDate; machineData.MachineClean = model.MachineClean; machineData.TreatmentRecordMasterId = model.TreatmentRecordMasterId; machineData.AlarmCheck = model.AlarmCheck; machineData.CorrectiveAction = model.CorrectiveAction; machineData.PrimeSuccess = model.PrimeSuccess; machineData.CleanedTrackDoors = model.CleanedTrackDoors; machineData.CleanedSensors = model.CleanedSensors; machineData.CleanedPressurePODSSeals = model.CleanedPressurePODSSeals; machineData.CleanedFrontDoorSensors = model.CleanedFrontDoorSensors; machineData.CreatedOn = DateTime.UtcNow; machineData.LastUpdated = DateTime.UtcNow; machineData.Deleted = false; //Mark Complete machineData.MarkComplete = model.MarkComplete; _treatmentRecordsServices.InsertMachineInfo(machineData); //Bhawana(09/10/2019) //Change treatment Record Status _reportService.UpdateTreatmentStatusID((int)machineData.TreatmentRecordMasterId); //12/10/19 aakansha //model response model.Id = machineData.Id; model.TreatmentRecordMasterId = machineData.TreatmentRecordMasterId; resultModel.Message = ValidationMessages.Success; resultModel.Status = 1; resultModel.Response = model; return(Ok(resultModel)); } else { var machineData = _treatmentRecordsServices.GetMachineInfoById(model.Id); machineData.Id = model.Id; machineData.EquipmentId = model.EquipmentId; machineData.EquipSerial = model.EquipSerial; machineData.KitTypeId = model.KitTypeId; machineData.TreatmentRecordMasterId = model.TreatmentRecordMasterId; machineData.KitTypeSerial = model.KitTypeSerial; machineData.PMDate = model.PMDate; machineData.ExpDate = model.ExpDate; machineData.SafetyChkDate = model.SafetyChkDate; machineData.MachineClean = model.MachineClean; machineData.AlarmCheck = model.AlarmCheck; machineData.CorrectiveAction = model.CorrectiveAction; machineData.PrimeSuccess = model.PrimeSuccess; machineData.CleanedTrackDoors = model.CleanedTrackDoors; machineData.CleanedSensors = model.CleanedSensors; machineData.CleanedPressurePODSSeals = model.CleanedPressurePODSSeals; machineData.CleanedFrontDoorSensors = model.CleanedFrontDoorSensors; machineData.MarkComplete = model.MarkComplete; machineData.LastUpdated = DateTime.UtcNow; _treatmentRecordsServices.UpdateMachineInfo(machineData); //Bhawana(09/10/2019) //Change treatment Record Status _reportService.UpdateTreatmentStatusID((int)machineData.TreatmentRecordMasterId); //12/10/19 aakansha //model response model.Id = machineData.Id; model.TreatmentRecordMasterId = machineData.TreatmentRecordMasterId; resultModel.Message = ValidationMessages.Success; resultModel.Status = 1; resultModel.Response = model; return(Ok(resultModel)); } } catch (Exception e) { resultModel.Message = ValidationMessages.Failure; resultModel.Status = 0; resultModel.Response = null; return(Ok(resultModel)); } }