public async Task <bool> ChangeRepair(RepairClass mutableRepair) { try { dataContext.Repairs.Update(mutableRepair); #region _ //var tempWork = dataContext.Repairs.Where(x => x.Id == mutableRepair.Id).FirstOrDefault(); //foreach (var t in tempWork.GetType().GetProperties()) //{ // foreach (var m in mutableRepair.GetType().GetProperties()) // { // if (t.Name == m.Name) // { // t.SetValue(tempWork, m.GetValue(mutableRepair)); // continue; // } // } //} #endregion await dataContext.SaveChangesAsync(); return(true); } catch { return(false); } }
public async Task StartChangeRepair(RepairClass mutalbeRepair) { var result = toSql.ChangeRepair(mutalbeRepair); result.Wait(); if (result.Result) { await Clients.All.SendAsync("ChangedRepair", mutalbeRepair); } else { await Clients.Caller.SendAsync("ChangedError", result.Result); } }
public async Task <bool> AddRepair(RepairClass newRepair) { try { dataContext.Repairs.Add(newRepair); await dataContext.SaveChangesAsync(); return(true); } catch { return(false); } }
public RepairCardViewModel(MainObject mainObject, Devices device) { Repair = new RepairClass() { Model = device.DeviceName, ScOks = device.Repairs[0].ScOks, InvNumber = device.InvNumber, DeviceId = device.Id, OsName = device.OsName }; if (device.Repairs.Count != 0) { Repair.SNumber = device.Repairs[0].SNumber; } MainObject = mainObject; }
public RepairCardViewModel(MainObject mainObject) { Repair = new RepairClass(); MainObject = mainObject; }
public async Task RunAddRepair(RepairClass repair) { bool isDevice = false; DataContext dataContext = new DataContext(); foreach (var d in dataContext.Devices) { if (d.InvNumber == repair.InvNumber) { repair.DeviceId = d.Id; var tempBool = toSql.AddRepair(repair).Result; if (tempBool) { isDevice = true; await Clients.All.SendAsync("UpdateRepairs", repair); } else { await Clients.Caller.SendAsync("UpdateRepairFaled", false); } break; } } if (!isDevice) { var device = new Devices() { DeviceName = repair.Model, InvNumber = repair.InvNumber, OsName = repair.OsName }; var tempBool = toSql.AddDevice(device).Result; if (tempBool) { repair.DeviceId = dataContext.Devices.Where(x => x.InvNumber == repair.InvNumber).FirstOrDefault().Id; var tempBoolRepair = toSql.AddRepair(repair).Result; if (tempBoolRepair) { device.Repairs = new ObservableCollection <RepairClass>(dataContext.Repairs.Where(x => x.InvNumber == device.InvNumber).ToList()); await Clients.All.SendAsync("UpdateRepairs", repair); await Clients.All.SendAsync("UpdateDevices", device); } else { await Clients.Caller.SendAsync("UpdateRepairFaled", false); } } else { await Clients.Caller.SendAsync("UpdateDeviceFaled", false); } } }
/// <summary> /// Метод считывает файл Excel и загружает в память для последующей записи данных в БД /// </summary> /// <param name="path"></param> /// <param name="emptyCol"></param> /// <returns></returns> public string LoadExcel(string path, List <RepairClass> emptyCol) { if (!string.IsNullOrEmpty(path)) { using (MemoryStream ms = new MemoryStream(File.ReadAllBytes(path))) { // Создание книги Excel using (var workbook = new XLWorkbook(ms)) { // Создание таблицы var worksheet = workbook.Worksheet(1); try { // Формирование строк таблицы var rows = worksheet.RangeUsed().RowsUsed().Skip(1); // Цикл создания объектов для добавления в коллекцию foreach (var t in rows) { RepairClass repairClass = new RepairClass() { Id = 0, DeviceId = 0, Date = t.Cell(1).Value.GetType() != typeof(DateTime) ? new DateTime?() : Convert.ToDateTime(t.Cell(1).Value), Status = t.Cell(2).Value.ToString(), OsName = t.Cell(3).Value.ToString(), Model = t.Cell(4).Value.ToString(), SNumber = t.Cell(5).Value.ToString(), InvNumber = t.Cell(6).Value.ToString(), ScOks = t.Cell(7).Value.ToString(), DiagNumber = t.Cell(8).Value.ToString(), KaProvider = t.Cell(9).Value.ToString(), KaRepair = t.Cell(10).Value.ToString(), HandedOver = t.Cell(11).Value.ToString(), Defect = t.Cell(12).Value.ToString(), ShipmentDate = t.Cell(13).Value.GetType() != typeof(DateTime) ? new DateTime?() : Convert.ToDateTime(t.Cell(13).Value), DaysOfRepair = 0, ReturnFromRepair = t.Cell(14).Value.GetType() != typeof(DateTime) ? new DateTime?() : Convert.ToDateTime(t.Cell(14).Value), ProviderOrder = t.Cell(15).Value.ToString(), RepairBill = t.Cell(16).Value.ToString(), WarrantyBasis = t.Cell(17).Value.ToString(), StartWarranty = t.Cell(18).Value.GetType() != typeof(DateTime) ? new DateTime?() : Convert.ToDateTime(t.Cell(18).Value), Warranty = t.Cell(19).Value.ToString(), HaveAccumulator = (bool)t.Cell(20).Value, HaveFlashMemory = (bool)t.Cell(21).Value, HaveHandBelt = (bool)t.Cell(22).Value, HaveStylus = (bool)t.Cell(20).Value }; emptyCol.Add(repairClass); } return("Файл считан."); } catch (Exception e) { return(e.Message); } } } } else { return(null); } }