public static Maintenance FromDataModel(MaintenanceData maintenance)
{
return(new Maintenance()
{
Id = maintenance.Id,
Completed = maintenance.Completed,
CompletedBy = maintenance.CompletedBy,
MaintenanceEnd = maintenance?.MaintEnd,
MaintenanceStart = maintenance?.MaintStart,
VehicleId = maintenance.VehicleId,
MaintenanceId = maintenance.MaintenanceId
});
}
public EditMaintenanceForm(MaintenanceData data,
EquipmentMaintenance equipmentMaintenance,
ObservableCollection <string> availableEquipmentList
)
{
InitializeComponent();
Debug.Write("EditMaintenanceForm");
this._equipmentMaintenance = equipmentMaintenance;
this._availableEquipmentList = availableEquipmentList;
if (data.Id != null)
{
MId.Text = data.Id.ToString();
M_LastMaintenace.SelectedDate = data.LastMaintenance;
M_LastMaintenace.DisplayDateStart = data.LastMaintenance;
M_Task.Text = data.MaintanceItem;
M_Name.SelectedIndex = data.EquipmentID - 1;
M_Frequency.Text = data.Frequency.ToString();
}
M_Name.ItemsSource = _availableEquipmentList;
}
public static Maintenance ToModel(this MaintenanceData node)
{
return(new Maintenance()
{
Id = node.Id,
MaintenanceCategoryId = node.MaintenanceCategoryId,
StateId = node.StateId,
UserId = node.UserId,
BuildingId = node.BuildingId,
ApproverId = node.ApproverId,
OperatorId = node.OperatorId,
Title = node.Title,
Content = node.Content,
PictureId = node.PictureId,
CreateDate = node.CreateDate,
Rating = node.Rating,
MaintenanceTime = node.MaintenanceTime,
PurchasingId = node.PurchasingId,
PictureUrl = node.PictureUrl
});
}
public ActionResult UpdateMaintenanceDataMonitoring(MaintenanceDataMonitoringViewModel model)
{
if (!ModelState.IsValid)
{
model.Users = new BusinessLayer <User>(new CapaNavDocDal()).GetList().Select(u => u.ToUserCallViewModel().UserCall).ToList();
return(PartialView("MaintenanceDataMonitoringView", model));
}
BusinessLayer <MaintenanceData> mdbl = new BusinessLayer <MaintenanceData>(new CapaNavDocDal());
BusinessLayer <User> ubl = new BusinessLayer <User>(new CapaNavDocDal());
MaintenanceData md = mdbl.Get(model.MaintenanceDataId.ToInt32());
UserCallViewModel userCallViewModel = ubl.GetList().Select(u => u.ToUserCallViewModel()).FirstOrDefault(u => u.UserCall == model.SelectedUserCall);
if (userCallViewModel == null)
{
return(Json(new { success = true }));
}
md.MonitoringUserId = userCallViewModel.UserId.ToInt32();
md.MonitoringDate = DateTime.ParseExact(model.Date, "dd-mm-yyyy", CultureInfo.InvariantCulture);
mdbl.Update(md);
return(Json(new { success = true }));
}
public List <MaintenanceData> getMaintenanceData()
{
List <MaintenanceData> maintenanceList = new List <MaintenanceData>();
string query = @"select ID from [Maintenance];";
List <int> maintenanceID = databaseConnection.executeReaderIntList(query);
MaintenanceData tempMaintenance = new MaintenanceData(0, 0, 0, 0, DateTime.Today, DateTime.Today);
foreach (int id in maintenanceID)
{
tempMaintenance.ID = id;
query = @"Select TramID from [Maintenance] where ID = " + id + @";";
tempMaintenance.TramID = (int)databaseConnection.executeReaderInt(query);
query = @"Select UserID from [Maintenance] where ID = " + id + @";";
tempMaintenance.UserID = (int)databaseConnection.executeReaderInt(query);
query = @"Select CleaningListID from [Maintenance] where ID = " + id + @";";
tempMaintenance.CleaningListID = (int)databaseConnection.executeReaderInt(query);
query = @"Select StartDate from [Maintenance] where ID = " + id + @";";
tempMaintenance.StartDate = (DateTime)databaseConnection.executeReaderDateTime(query);
query = @"Select EndDate from [Maintenance] where ID = " + id + @";";
tempMaintenance.EndDate = (DateTime)databaseConnection.executeReaderDateTime(query);
maintenanceList.Add(new MaintenanceData(tempMaintenance.ID, tempMaintenance.TramID, tempMaintenance.UserID, tempMaintenance.CleaningListID, tempMaintenance.StartDate, tempMaintenance.EndDate));
}
return(maintenanceList);
}
private void ButtonOK_Click(object sender, RoutedEventArgs e)
{
Debug.Write("EditMaintenanceForm ButtonOK_Click");
try
{
int?id = null;
if (MId.Text != "")
{
id = Int32.Parse(MId.Text);
}
var maintenanceData = new MaintenanceData(id,
_equipmentMaintenance.EquipmentNameToId((string)M_Name.SelectedValue),
(string)M_Name.SelectedValue,
M_Task.Text,
M_LastMaintenace.SelectedDate.Value.Date,
Int32.Parse(M_Frequency.Text));
maintenanceData.Validate();
if (id == null)
{
_equipmentMaintenance.AddItem(maintenanceData);
}
else
{
_equipmentMaintenance.ModifyItem(maintenanceData);
}
this.Close();
}
catch (Exception)
{
MessageBox.Show("Invalid Input");
}
}
public static MaintenanceDataMonitoringViewModel ToMaintenanceDataMonitoringViewModel(this MaintenanceData md)
{
BusinessLayer <User> bl = new BusinessLayer <User>(new CapaNavDocDal());
return(new MaintenanceDataMonitoringViewModel
{
MaintenanceDataId = md.Id.ToString(),
SelectedUserCall = bl.GetList().FirstOrDefault(u => u.Id == md.MonitoringUserId).ToUserCallViewModel().UserCall,
Date = md.MonitoringDate.ToString("dd-mm-yyyy"),
Users = bl.GetList().Select(u => u.ToUserCallViewModel().UserCall).ToList()
});
}
