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