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