private List <process> getProcessesBetweenDate(DateTime first, DateTime second, worker w) { second = second.AddDays(1); using (var db = new workshopEntities()) { return(db.process.Where(p => (p.Worker_idWorker == w.idWorker && p.dateTimeStart >= first && p.dateTimeFinish < second)).ToList()); } }
private static string getYearOld(int idCar) { string year = ""; using (var db = new workshopEntities()) { car c = db.car.Find(idCar); year = c.Year.Value.ToString(); } return(year); }
private static string getInfoAboutCar(int idOrder) { string infoAboutCar = ""; using (var db = new workshopEntities()) { car c = db.order.Find(idOrder).car; infoAboutCar = c.modelofcar.markofcar.nameMarkOfCar + " " + c.modelofcar.nameModelOfCar + " " + c.registrNumber; } return(infoAboutCar); }
private void addStatusProcess(int idProcess, int idWorker) { using (var db = new workshopEntities()) { process oneProcess = db.process.Find(idProcess); string message = ""; if (oneProcess.dateTimeStartFact == null) { oneProcess.dateTimeStartFact = DateTime.Now; oneProcess.Worker_idWorker_Fact = idWorker; message = "Старт зафіксовано!"; if (oneProcess.dateTimeStartFact.Value < oneProcess.dateTimeStart.Value) { message += "\nВи працюєте по плану"; } else { message += "\nВи не встигаєте"; } message += "\nПриступайте до роботи!!!"; } else if (oneProcess.dateTimeFinishFact == null) { oneProcess.dateTimeFinishFact = DateTime.Now; message = "Завершення работи зафіксовано!"; if (oneProcess.dateTimeFinishFact.Value < oneProcess.dateTimeFinish.Value) { message += "\nВи встигли"; } else { message += "\nВи не встигли"; } message += "\nДякуємо за виконану роботу!!!"; } else { message = "Це завдання вже завершено!!!"; } db.SaveChanges(); var noComplatedProcesses = db.process.Where(p => (p.Order_idOrder == oneProcess.Order_idOrder && (p.dateTimeFinishFact == null || p.dateTimeStartFact == null))).ToList(); if (noComplatedProcesses.Count == 0) { var order = db.order.Find(oneProcess.Order_idOrder); order.status = true; db.SaveChanges(); } _messageService.ShowAsync(message, "", MessageButton.OK, MessageImage.Information); } OrderList.Clear(); OrderList = getOrderList(); }
private static string getDistance(int idCar) { string distance = ""; using (var db = new workshopEntities()) { car c = db.car.Find(idCar); distance = c.Distance.Value.ToString(); } return(distance); }
protected void Page_Load(object sender, EventArgs e) { if (User.Identity.Name.ToString() == "") { Response.Redirect("/Default.aspx"); } AspNetUser currentUser = new AspNetUser(); car currentCar = new car(); List <car> listAvto = new List <car>(); List <AspNetUser> listUsers = new List <AspNetUser>(); List <order> listOrder = new List <order>(); using (var db = new Entities5()) { listUsers = db.AspNetUsers.ToList(); foreach (AspNetUser m in listUsers) { if (m.UserName == User.Identity.Name.ToString()) { currentUser = m; } } } using (var db = new workshopEntities()) { if (db.cars.Where(m => (m.client.email == currentUser.Email)).Count() > 0) { listAvto = db.cars.Where(m => (m.client.email == currentUser.Email)).ToList(); currentCar = listAvto[0]; listOrder = db.orders.Where(m => (m.Car_idCar == currentCar.idCar)).ToList(); } } DropDownList1.DataSource = listAvto; DropDownList1.DataTextField = "registrNumber"; DropDownList1.DataValueField = "idCar"; DropDownList2.DataSource = listOrder; DropDownList2.DataTextField = "dateTime"; DropDownList2.DataValueField = "idOrder"; if (!IsPostBack) { DropDownList1.DataBind(); DropDownList2.DataBind(); } fillTable(); //fillTable(); }
private static List <WorkClass> getWorksList(int idOrder) { List <WorkClass> worksList = new List <WorkClass>(); int i = 1; using (var db = new workshopEntities()) { foreach (process p in db.process.Where(p => p.Order_idOrder == idOrder).ToList()) { WorkClass wc = new WorkClass(); wc.Id = i; wc.NameOperation = p.operation.nameOperation + "\nДеталі : " + getInfoAboutDetails(p.idProcess).Replace("\n", ", ").Replace(" - ", ""); wc.NameWorker = p.worker.lastName + " " + p.worker.firstName + " " + p.worker.middleName; if (p.dateTimeStart == null) { wc.StartPlan = ""; } else { wc.StartPlan = p.dateTimeStart.ToString(); } if (p.dateTimeStartFact == null) { wc.StartFact = ""; } else { wc.StartFact = p.dateTimeStartFact.ToString(); } if (p.dateTimeFinish == null) { wc.FinishPlan = ""; } else { wc.FinishPlan = p.dateTimeFinish.ToString(); } if (p.dateTimeFinishFact == null) { wc.FinishFact = ""; } else { wc.FinishFact = p.dateTimeFinishFact.ToString(); } worksList.Add(wc); i++; } } return(worksList); }
private List <KeyValuePair <string, int> > getlistProcessForPieChart(int idWorker, DateTime first, DateTime second) { List <KeyValuePair <string, int> > list = new List <KeyValuePair <string, int> >(); using (var db = new workshopEntities()) { int own = db.process.Where(p => p.Worker_idWorker == idWorker && p.Worker_idWorker_Fact == idWorker && p.dateTimeStartFact >= first && p.dateTimeFinishFact <= second).ToList().Count; int notOwn = db.process.Where(p => p.Worker_idWorker != idWorker && p.Worker_idWorker_Fact == idWorker && p.dateTimeStartFact >= first && p.dateTimeFinishFact <= second).ToList().Count; list.Add(new KeyValuePair <string, int>("Свої", own)); list.Add(new KeyValuePair <string, int>("Чужі", notOwn)); } return(list); }
static void Main(string[] args) { var reader = new StreamReader("C:\\Users\\suraj\\Desktop\\100_Records.csv"); var csv = new CsvReader(reader); List <data> datalist = new List <data>(); csv.Read(); csv.ReadHeader(); while (csv.Read()) { var record = new data { emp_id = csv.GetField <int>("Emp_ID"), First_Name = csv.GetField("First_Name"), Last_Name = csv.GetField("Last_Name"), DOB = csv.GetField("Date_of_Birth"), Date_of_joining = csv.GetField("Date_of_Joining"), location = csv.GetField("location") }; datalist.Add(record); } var employeedata = new employee_details(); try { foreach (var employee in datalist) { employeedata.emp_id = employee.emp_id; employeedata.name = employee.First_Name + " " + employee.Last_Name; employeedata.DOB = employee.DOB; employeedata.age = 35; employeedata.date_of_joining = employee.Date_of_joining; employeedata.location = employee.location; using (var dbCtx = new workshopEntities()) { dbCtx.employee_details.Add(employeedata); dbCtx.SaveChanges(); } } displaydata(); Console.ReadKey(); } catch (DbUpdateException e) { displaydata(); } }
private List <order> getOrders(DateTime first, DateTime second, bool allOrders, bool complateOrders, bool noStartOrders, bool doingOrders) { List <order> ordersCollection = new List <order>(); using (var db = new workshopEntities()) { if (complateOrders) { foreach (order i in db.order.Where(o => (o.status == true)).ToList()) { i.Color = "#90EE90"; ordersCollection.Add(i); } } if (noStartOrders) { foreach (order i in db.order.Where(o => (o.status == false)).ToList()) { var processes = db.process.Where(p => (p.Order_idOrder == i.idOrder && p.dateTimeStartFact != null)); if (processes.ToList().Count == 0) { i.Color = "#FFB6C1"; ordersCollection.Add(i); } } } if (doingOrders) { foreach (order i in db.order.Where(o => (o.status == false)).ToList()) { var processes = db.process.Where(p => (p.Order_idOrder == i.idOrder && p.dateTimeStartFact != null)); if (processes.ToList().Count > 0) { i.Color = "#87CEFA"; ordersCollection.Add(i); } } } foreach (order i in ordersCollection) { i.car = db.car.Find(i.Car_idCar); i.car.modelofcar = db.modelofcar.Find(i.car.ModelOfCar_idModelOfCar); i.car.modelofcar.markofcar = db.markofcar.Find(i.car.modelofcar.MarkOfCar_idMarkOfCar); i.car.colorofcar = db.colorofcar.Find(i.car.ColorOfCar_idColorOfCar); } } return(ordersCollection); }
public ChangeWorkerAndDatesViewModel() { using (var db = new workshopEntities()) { WorkersCollection = new ObservableCollection <worker>(); foreach (worker i in db.worker) { WorkersCollection.Add(i); } DateFirst = DateTime.Now.Date.AddDays(-10); DateSecond = DateTime.Now.Date; SelectedWorker = WorkersCollection[0]; } }
private static string listDetailIdForQRCode(int processId) { string detailIds = ""; using (var db = new workshopEntities()) { var _processHasDetailsList = db.process_has_detail.Where(phd => phd.Process_idProcess == processId).Select(phd => phd.Detail_idDetail); foreach (int idDetail in _processHasDetailsList.ToList()) { detailIds += idDetail + " "; } } return(detailIds); }
public static void displaydata() { using (var db = new workshopEntities()) { var query = from employee_data in db.employee_details orderby employee_data.name select employee_data; foreach (var item in query) { Console.WriteLine("Employee ID: " + item.emp_id + "\n" + "Employee Name: " + item.name + "\n" + "Date of Birth: " + item.DOB + "\n" + "Location : " + item.location + "\n" + "Date of Joining: " + item.date_of_joining + "\n"); Console.WriteLine("-----------------------------------------------------------------------------"); } } Console.WriteLine("Press any key to exit..."); Console.ReadKey(); }
public DocumentWindowViewModel(IMessageService messageService) { _messageService = messageService; AllOrders = true; OneTask = true; using (var db = new workshopEntities()) { WorkersCollection = new ObservableCollection <worker>(); foreach (worker i in db.worker) { WorkersCollection.Add(i); } } DateFirst = DateTime.Now; DateSecond = DateTime.Now; }
private List <KeyValuePair <string, int> > getlistMarkForPieChart(int idWorker, DateTime first, DateTime second) { List <KeyValuePair <string, int> > list = new List <KeyValuePair <string, int> >(); using (var db = new workshopEntities()) { int good = db.process.Where(p => p.Worker_idWorker_Fact == idWorker && p.dateTimeStartFact >= first && p.dateTimeFinishFact <= second && p.dateTimeStartFact <= p.dateTimeStart && p.dateTimeFinishFact <= p.dateTimeFinish).ToList().Count; int noStart = db.process.Where(p => p.Worker_idWorker_Fact == idWorker && p.dateTimeStartFact >= first && p.dateTimeFinishFact <= second && p.dateTimeStartFact > p.dateTimeStart && p.dateTimeFinishFact <= p.dateTimeFinish).ToList().Count; int noFinish = db.process.Where(p => p.Worker_idWorker_Fact == idWorker && p.dateTimeStartFact >= first && p.dateTimeFinishFact <= second && p.dateTimeStartFact <= p.dateTimeStart && p.dateTimeFinishFact > p.dateTimeFinish).ToList().Count; int bad = db.process.Where(p => p.Worker_idWorker_Fact == idWorker && p.dateTimeStartFact >= first && p.dateTimeFinishFact <= second && p.dateTimeStartFact > p.dateTimeStart && p.dateTimeFinishFact > p.dateTimeFinish).ToList().Count; list.Add(new KeyValuePair <string, int>("Старт - по плану,\nКінець - не по плану", noFinish)); list.Add(new KeyValuePair <string, int>("Всі не по плану", bad)); list.Add(new KeyValuePair <string, int>("Всі по плану", good)); list.Add(new KeyValuePair <string, int>("Старт - не по плану,\nКінець - по плану", noStart)); } return(list); }
internal static string getInfoAboutWorker(string code) { worker findWorker = new worker(); using (var db = new workshopEntities()) { foreach (worker w in db.worker.ToList()) { if (code == w.getCode) { findWorker = w; break; } } if (findWorker == null) { throw new Exception("not found worker"); } return("Працівник - " + findWorker.lastName + " " + findWorker.firstName + " " + findWorker.middleName + "_" + findWorker.idWorker.ToString()); } }
private List <KeyValuePair <string, double> > getlistHoursForLineChart(int idWorker, DateTime first, DateTime second) { List <KeyValuePair <string, double> > list = new List <KeyValuePair <string, double> >(); using (var db = new workshopEntities()) { for (DateTime i = first; i <= second; i = i.AddDays(1)) { DateTime j = i.AddDays(1); List <process> processList = db.process.Where(p => p.Worker_idWorker_Fact == idWorker && p.dateTimeStartFact.Value >= i && p.dateTimeFinishFact.Value < j).ToList(); double sum = 0; foreach (process pr in processList) { sum += (pr.dateTimeFinishFact.Value - pr.dateTimeStartFact.Value).TotalMinutes; } list.Add(new KeyValuePair <string, double>(i.ToString().Split(' ')[0], sum / 60)); } } return(list); }
private static string getInfoAboutDetails(int idProcess) { string infoAboutCar = ""; using (var db = new workshopEntities()) { var _details = db.process_has_detail.Where(d => d.Process_idProcess == idProcess).Select(d => d.detail); foreach (detail d in _details.ToList()) { infoAboutCar += " - " + d.standartdetail.nameStandartDetail + "\n"; } } if (infoAboutCar.Length != 0) { return(infoAboutCar.Substring(0, infoAboutCar.Length - 1)); } else { return(""); } }
public Manager(string imageFolder = "Images") { if (!Check()) { throw new DomainException(); } ImageFolder = imageFolder; var context = new workshopEntities(); Accessory = new AccessoryManager(context, this); Client = new ClientManager(context, this); Mechanic = new MechanicManager(context, this); ProviderAccessory = new ProviderAccessoryManager(context, this); Provider = new ProviderManager(context, this); RepairAccessory = new RepairAccessoryManager(context, this); Repair = new RepairManager(context, this); Service = new ServiceManager(context, this); User = new UserManager(context, this); Order = new OrderManager(context, this); MechanicOrder = new MechanicOrderManager(context, this); }
private ObservableCollection <process> getProcessList(worker w, DateTime date) { ObservableCollection <process> processList = new ObservableCollection <process>(); using (var db = new workshopEntities()) { var _processList = db.process.Where(p => p.Worker_idWorker == w.idWorker); foreach (process i in _processList.ToList()) { if ((i.dateTimeStart.Value - date).Days == 0) { i.order = db.order.Find(i.Order_idOrder); i.order.car = db.car.Find(i.order.Car_idCar); i.order.car.modelofcar = db.modelofcar.Find(i.order.car.ModelOfCar_idModelOfCar); i.order.car.modelofcar.markofcar = db.markofcar.Find(i.order.car.modelofcar.MarkOfCar_idMarkOfCar); i.operation = db.operation.Find(i.Operation_idOperation); processList.Add(i); } } } return(processList); }
public void DropDownList1_SelectedIndexChanged(object sender, EventArgs e) { List <order> listOrder = new List <order>(); using (var db = new workshopEntities()) { car curCar = new car(); curCar = db.cars.Where(m => (m.idCar.ToString() == DropDownList1.SelectedValue)).First(); listOrder = db.orders.Where(m => (m.Car_idCar == curCar.idCar)).ToList(); } DropDownList2.DataSource = listOrder; DropDownList2.DataTextField = "dateTime"; DropDownList2.DataValueField = "idOrder"; DropDownList2.DataBind(); //StreamWriter wr = new StreamWriter(@"E:\logWebSite5.txt", true); //wr.WriteLine("DropDownList1_SelectedIndexChanged()"); //wr.WriteLine(DropDownList1.SelectedItem.ToString()); //wr.WriteLine(DropDownList2.SelectedItem.ToString()); //wr.Close(); fillTable(); }
private List <DetailItem> getDetailList(int idOrder) { List <DetailItem> diList = new List <DetailItem>(); using (var db = new workshopEntities()) { int idCar = db.order.Find(idOrder).Car_idCar; var _details = db.detail.Where(d => d.Car_idCar == idCar); foreach (detail d in _details.ToList()) { DetailItem di = new DetailItem(); di.NameDetail = d.standartdetail.nameStandartDetail; di.idDetail = d.idDetail; di.DemontazhCondition = getStateAndColorForDetail(d.idDetail, idOrder, 1).Split('|')[0]; di.DemontazhConditionColor = getStateAndColorForDetail(d.idDetail, idOrder, 1).Split('|')[1]; di.RaspacovkaCondition = getStateAndColorForDetail(d.idDetail, idOrder, 2).Split('|')[0]; di.RaspacovkaConditionColor = getStateAndColorForDetail(d.idDetail, idOrder, 2).Split('|')[1]; di.SvarkaConditionColor = getStateAndColorForDetail(d.idDetail, idOrder, 3).Split('|')[1]; di.SvarkaCondition = getStateAndColorForDetail(d.idDetail, idOrder, 3).Split('|')[0]; di.VigotovkaCondition = getStateAndColorForDetail(d.idDetail, idOrder, 4).Split('|')[0]; di.VigotovkaConditionColor = getStateAndColorForDetail(d.idDetail, idOrder, 4).Split('|')[1]; di.PokraskaCondition = getStateAndColorForDetail(d.idDetail, idOrder, 5).Split('|')[0]; di.PokraskaConditionColor = getStateAndColorForDetail(d.idDetail, idOrder, 5).Split('|')[1]; di.PolirovkaCondition = getStateAndColorForDetail(d.idDetail, idOrder, 7).Split('|')[0]; di.PolirovkaConditionColor = getStateAndColorForDetail(d.idDetail, idOrder, 7).Split('|')[1]; di.MontazhCondition = getStateAndColorForDetail(d.idDetail, idOrder, 8).Split('|')[0]; di.MontazhConditionColor = getStateAndColorForDetail(d.idDetail, idOrder, 8).Split('|')[1]; di.SdachaCondition = getStateAndColorForDetail(d.idDetail, idOrder, 9).Split('|')[0]; di.SdachaConditionColor = getStateAndColorForDetail(d.idDetail, idOrder, 9).Split('|')[1]; di.SushkaCondition = getStateAndColorForDetail(d.idDetail, idOrder, 6).Split('|')[0]; di.SushkaConditionColor = getStateAndColorForDetail(d.idDetail, idOrder, 6).Split('|')[1]; diList.Add(di); } } return(diList); }
private string getStateAndColorForDetail(int idDetail, int idOrder, int idOperation) { using (var db = new workshopEntities()) { var processList = db.process_has_detail.Where(p => p.Detail_idDetail == idDetail).Select(p => p.process).Where(p => p.Operation_idOperation == idOperation && p.Order_idOrder == idOrder); if (processList.ToList().Count == 0) { return(" |" + "WhiteSmoke"); } else { process p = processList.ToList()[0]; if (p.dateTimeStartFact == null && p.dateTimeFinishFact == null) { if (p.dateTimeStart > DateTime.Now) { return("не почалось|LightGreen"); } else { if (p.dateTimeFinish > DateTime.Now) { return("не почалось|LightPink"); } else { return("не почалось|Red"); } } } else if (p.dateTimeStartFact != null && p.dateTimeFinishFact == null) { if (p.dateTimeStartFact <= p.dateTimeStart && p.dateTimeFinish > DateTime.Now) { return("розпочато|LightGreen"); } if (p.dateTimeStartFact > p.dateTimeStart && p.dateTimeFinish > DateTime.Now) { return("розпочато|Yellow"); } if (p.dateTimeStartFact > p.dateTimeStart && p.dateTimeFinish < DateTime.Now) { return("розпочато|Red"); } if (p.dateTimeStartFact <= p.dateTimeStart && p.dateTimeFinish < DateTime.Now) { return("розпочато|LightPink"); } return("-----|Blue"); } else { if (p.dateTimeStart >= p.dateTimeStartFact && p.dateTimeFinish >= p.dateTimeFinishFact) { return("ГОТОВО|LightGreen"); } if (p.dateTimeStart < p.dateTimeStartFact && p.dateTimeFinish >= p.dateTimeFinishFact) { return("ГОТОВО|Yellow"); } if (p.dateTimeStart >= p.dateTimeStartFact && p.dateTimeFinish < p.dateTimeFinishFact) { return("ГОТОВО|LightPink"); } if (p.dateTimeStart < p.dateTimeStartFact && p.dateTimeFinish < p.dateTimeFinishFact) { return("ГОТОВО|Red"); } return("-----|Blue"); } } } }
public string fillTable() { Table1.BackColor = Color.WhiteSmoke; if (Table1.Rows != null) { Table1.Rows.Clear(); } TableHeaderRow headerRow = new TableHeaderRow(); headerRow.BackColor = Color.BlanchedAlmond; string[] headerName = { "Назва операції", "Прізвище робітника", "Рівень кваліфікації робітника", "Робота повинна була розпочатись", "Фактично розпочалась", "Робота повинна була завершитись","Фактично закінчилась", "Статус операції" }; int numberOfHeadCell = headerName.Length; TableHeaderCell[] headerTableCells = new TableHeaderCell[numberOfHeadCell]; for (int i = 0; i < numberOfHeadCell; i++) { headerTableCells[i] = new TableHeaderCell(); headerTableCells[i].Text = headerName[i]; } headerRow.Cells.AddRange(headerTableCells); Table1.Rows.AddAt(0, headerRow); string tmp = ""; string tmp2 = ""; if (DropDownList1.SelectedItem != null) { //StreamWriter wr = new StreamWriter(@"E:\logWebSite5.txt", true); //wr.WriteLine("fillTable()"); //wr.WriteLine("fillTable()"+DropDownList1.SelectedItem.ToString()); //wr.WriteLine("fillTable()"+DropDownList2.SelectedValue.ToString()); //wr.Close(); string currentCarRegistrNumber = DropDownList1.SelectedItem.ToString(); string currentOrderId = DropDownList2.SelectedValue.ToString(); car currentCar = new car(); order curOrder = new order(); List <process> listProcess = new List <process>(); //операция и воркер создавать using (var db = new workshopEntities()) { currentCar = db.cars.Where(m => m.registrNumber == currentCarRegistrNumber).First(); curOrder = db.orders.Where(m => m.idOrder.ToString() == currentOrderId).First(); tmp += "carNumber: " + curOrder.car.registrNumber.ToString(); tmp += "\norder id: " + curOrder.idOrder.ToString(); tmp += "\norder status: " + curOrder.status.ToString(); tmp += "\nmanager: " + curOrder.worker.lastName; listProcess = db.processes.Where(m => m.Order_idOrder == curOrder.idOrder).ToList(); List <TableRow> listRows = new List <TableRow>(); foreach (process p in listProcess) { TableRow table1Row = new TableRow(); listRows.Add(table1Row); TableCell[] TableCells = new TableCell[numberOfHeadCell]; for (int i = 0; i < numberOfHeadCell; i++) { TableCells[i] = new TableHeaderCell(); } tmp2 = p.operation.nameOperation.ToString(); TableCells[0].Text = tmp2.Replace("+", " "); TableCells[1].Text = p.worker.lastName.ToString(); if (true == db.workerhasskills.Select(m => ((m.Worker_idWorker == p.Worker_idWorker) && (m.Operation_idOperation == p.Operation_idOperation))).First()) { TableCells[2].Text = db.workerhasskills.Where(m => ((m.Worker_idWorker == p.Worker_idWorker) && (m.Operation_idOperation == p.Operation_idOperation))).First().level.ToString(); } else { TableCells[2].Text = "Не зазначено"; } TableCells[6].Width = " 2016-03-31".Length + 40; TableCells[3].Text = p.dateTimeStart.ToString() ?? "Не зазначено"; TableCells[4].Text = p.dateTimeStartFact.ToString() ?? "Не зазначено"; TableCells[5].Text = p.dateTimeFinish.ToString() ?? "Не зазначено"; TableCells[6].Text = p.dateTimeFinishFact.ToString() ?? "Не зазначено"; if (p.dateTimeFinishFact == null && p.dateTimeFinish < DateTime.Now) { TableCells[7].Text = "Затримка"; TableCells[7].ForeColor = Color.OrangeRed; } else if (p.dateTimeFinish < p.dateTimeFinishFact) { TableCells[7].Text = "Була затримка"; TableCells[7].ForeColor = Color.Gold; } else if (p.dateTimeFinishFact == null && DateTime.Now < p.dateTimeFinishFact) { TableCells[7].Text = "В роботі"; //TableCells[7].ForeColor = Color.Yellow; } else { TableCells[7].Text = "Вчасно"; TableCells[7].ForeColor = Color.DarkSeaGreen; } table1Row.Cells.AddRange(TableCells); Table1.Rows.Add(table1Row); tmp += "\nname operation: " + p.operation.nameOperation.ToString(); tmp += "\nduration operation: " + p.operation.duration.ToString(); tmp += "\nworker: " + p.worker.lastName.ToString(); } } } return(tmp); }
private string getStateAndColorForOrder(int idOrder, int idOperation) { using (var db = new workshopEntities()) { var proccesList = db.process.Where(p => p.Order_idOrder == idOrder && p.Operation_idOperation == idOperation); if (proccesList.ToList().Count == 0) { return(" |" + "WhiteSmoke"); } else { process p = proccesList.ToList().First(); if (p.dateTimeStartFact == null && p.dateTimeFinishFact == null) { if (p.dateTimeStart.Value > DateTime.Now) { return("не почалось|LightGreen"); } else { if (p.dateTimeFinish.Value > DateTime.Now) { return("не почалось|LightPink"); } else { return("не почалось|Red"); } } } else if (p.dateTimeStartFact != null && p.dateTimeFinishFact == null) { if (p.dateTimeStartFact <= p.dateTimeStart.Value && p.dateTimeFinish.Value > DateTime.Now) { return("розпочато|LightGreen"); } if (p.dateTimeStartFact > p.dateTimeStart.Value && p.dateTimeFinish.Value > DateTime.Now) { return("розпочато|Yellow"); } if (p.dateTimeStartFact > p.dateTimeStart.Value && p.dateTimeFinish.Value < DateTime.Now) { return("розпочато|Red"); } if (p.dateTimeStartFact <= p.dateTimeStart.Value && p.dateTimeFinish.Value < DateTime.Now) { return("розпочато|LightPink"); } return("-----|Blue"); } else { if (p.dateTimeStart.Value >= p.dateTimeStartFact && p.dateTimeFinish.Value >= p.dateTimeFinishFact) { return("ГОТОВО|LightGreen"); } if (p.dateTimeStart.Value < p.dateTimeStartFact && p.dateTimeFinish.Value >= p.dateTimeFinishFact) { return("ГОТОВО|Yellow"); } if (p.dateTimeStart.Value >= p.dateTimeStartFact && p.dateTimeFinish.Value < p.dateTimeFinishFact) { return("ГОТОВО|LightPink"); } if (p.dateTimeStart.Value < p.dateTimeStartFact && p.dateTimeFinish.Value < p.dateTimeFinishFact) { return("ГОТОВО|Red"); } return("-----|Blue"); } } } }