private List <string> GetFileArray()
{
CMO_Order cMO_Order = db.CMO_Order.Find(idOrder);
var fileList = Directory.GetFiles(cMO_Order.folder).ToList();
return(fileList);
}
private void UpdateOrderBeforeFirtst()
{
CMO_Order cMO_Order = db.CMO_Order.Find(idOrder);
cMO_Order.firstTenderStart = true;
db.Entry(cMO_Order).State = EntityState.Modified;
db.SaveChanges();
}
private void CloseFirstTenderInOrder()
{
CMO_Order cMO_Order = db.CMO_Order.Find(idOrder);
cMO_Order.datetimeFirstTenderFinish = DateTime.Now;
db.Entry(cMO_Order).State = EntityState.Modified;
db.SaveChanges();
}
private void CloseWinnerTenderInOrder()
{
double minData = db.CMO_UploadResult.Where(d => d.CMO_Tender.id_CMO_Order == idOrder & d.CMO_Tender.id_CMO_TypeTask == 2 & d.cost > 0).Min(d => d.cost);
CMO_UploadResult getCMOUploadLead = db.CMO_UploadResult.Where(d => d.CMO_Tender.id_CMO_Order == idOrder & d.CMO_Tender.id_CMO_TypeTask == 2 & d.cost > 0 & d.cost == minData).First();
CMO_Order cMO_Order = db.CMO_Order.Find(idOrder);
cMO_Order.datetimeWinTenderFinish = DateTime.Now;
cMO_Order.companyWin = getCMOUploadLead.id_CMO_Company;
db.Entry(cMO_Order).State = EntityState.Modified;
db.SaveChanges();
}
private void CreateOrder(bool bit, int winCompanyId)
{
CMO_Order cMO_Order = new CMO_Order();
cMO_Order.companyWin = winCompanyId;
cMO_Order.dateCloseOrder = DateTime.Now;
cMO_Order.idTime = 1;
cMO_Order.dateCreate = DateTime.Now;
cMO_Order.userCreate = this.loginIdCreate;
cMO_Order.firstTenderStart = true;
db.CMO_Order.Add(cMO_Order);
db.SaveChanges();
this.idOrder = cMO_Order.id;
}
private void CreateOrder()
{
CMO_Order cMO_Order = new CMO_Order();
try
{
cMO_Order.idTime = 1;
cMO_Order.dateCreate = DateTime.Now;
cMO_Order.userCreate = this.loginIdCreate;
db.CMO_Order.Add(cMO_Order);
db.SaveChanges();
logger.Debug(goodDB + "private void CreateOrder()" + loginIdCreate.ToString());
}
catch (Exception ex)
{
logger.Error(badDB + "private void CreateOrder()" + loginIdCreate.ToString() + ex.Message.ToString());
}
this.idOrder = cMO_Order.id;
}
private void CreateFolderAndFileForOrder()
{
string directory = "\\\\192.168.1.30\\m$\\_ЗАКАЗЫ\\OrderCMO\\" + idOrder.ToString() + "\\";
try
{
Directory.CreateDirectory(directory);
logger.Debug("успешно создана папка с заявкой железа " + "CreateFolderAndFileForOrder() - 1.Directory.CreateDirectory " + loginIdCreate.ToString());
}
catch (Exception ex)
{
logger.Error("ошибка! создания папки с заявкой железа " + "CreateFolderAndFileForOrder() - 1.Directory.CreateDirectory " + loginIdCreate.ToString() + ex.Message.ToString());
}
try
{
SaveFileToServer(directory);
logger.Debug("успешно загружен файл в папку " + "CreateFolderAndFileForOrder() - 1.1.Directory.CreateDirectory " + loginIdCreate.ToString());
}
catch (Exception ex)
{
logger.Error("ошибка! загружен файл в папку " + "CreateFolderAndFileForOrder() - 1.1.Directory.CreateDirectory " + loginIdCreate.ToString() + ex.Message.ToString());
}
CreateCMO_FileOrder();
try
{
CMO_Order cMO_Order = db.CMO_Order.Find(idOrder);
cMO_Order.folder = directory;
db.Entry(cMO_Order).State = EntityState.Modified;
db.SaveChanges();
logger.Debug("успешно создана папка с заявкой железа " + "CreateFolderAndFileForOrder() - 3.db.SaveChanges() " + loginIdCreate.ToString());
}
catch (Exception ex)
{
logger.Error("ошибка! создания папки с заявкой железа " + "CreateFolderAndFileForOrder() - 3.db.SaveChanges() " + loginIdCreate.ToString() + ex.Message.ToString());
}
}
public void GetData()
{
SaveFileToServer(@"\\192.168.1.30\m$\_ЗАКАЗЫ\OrderCMO\");
//re/FacK
int row = 9;
int colCost = 4;
Excel.Worksheet sheet = null;
foreach (Excel.Worksheet data in Workbook.Worksheets)
{
sheet = data;
break;
}
Excel.Range range = sheet.UsedRange;
List <TenderOffer> offerList = new List <TenderOffer>();
int countPosition = 0;
while (row < 1000)
{
TenderOffer offer = new TenderOffer();
offer.Id_CMO_Order = Convert.ToInt32(((Excel.Range)range.Cells[row, 1]).Text);
offer.Id_CMO_Company = 1;
offer.Cost = Convert.ToInt32(((Excel.Range)range.Cells[row, colCost]).Text);
offer.Duration = Convert.ToInt32(((Excel.Range)range.Cells[row, colCost + 1]).Text);
offerList.Add(offer);
offer = new TenderOffer();
offer.Id_CMO_Order = Convert.ToInt32(((Excel.Range)range.Cells[row, 1]).Text);
offer.Id_CMO_Company = 2;
offer.Cost = Convert.ToInt32(((Excel.Range)range.Cells[row, colCost + 2]).Text);
offer.Duration = Convert.ToInt32(((Excel.Range)range.Cells[row, colCost + 3]).Text);
offerList.Add(offer);
offer = new TenderOffer();
offer.Id_CMO_Order = Convert.ToInt32(((Excel.Range)range.Cells[row, 1]).Text);
offer.Id_CMO_Company = 3;
offer.Cost = Convert.ToInt32(((Excel.Range)range.Cells[row, colCost + 4]).Text);
offer.Duration = Convert.ToInt32(((Excel.Range)range.Cells[row, colCost + 5]).Text);
offerList.Add(offer);
row++;
if (((Excel.Range)range.Cells[row, 1]).Text == "")
{
break;
}
}
int orderId = 0;
int tenderId = 0;
foreach (var VARIABLE in offerList)
{
if (orderId != VARIABLE.Id_CMO_Order)
{
CMO_Tender tender = new CMO_Tender();
tender.id_CMO_Order = VARIABLE.Id_CMO_Order;
tender.id_CMO_TypeTask = 1;
tender.finishPlanClose = DateTime.Now;
tender.close = true;
tender.closeDateTime = DateTime.Now;
db.CMO_Tender.Add(tender);
db.SaveChanges();
tenderId = tender.id;
orderId = tender.id_CMO_Order;
CMO_Order order = db.CMO_Order.Find(orderId);
order.firstTenderStart = true;
db.Entry(order).State = EntityState.Modified;
db.SaveChanges();
countPosition++;
}
CMO_UploadResult result = new CMO_UploadResult();
result.id_CMO_Tender = tenderId;
result.dateTimeUpload = DateTime.Now;
result.cost = VARIABLE.Cost;
result.dateComplited = DateTime.Now;
result.id_CMO_Company = VARIABLE.Id_CMO_Company;
result.day = VARIABLE.Duration;
db.CMO_UploadResult.Add(result);
db.SaveChanges();
}
row += 4;
offerList = new List <TenderOffer>();
for (int i = 0; i < countPosition; i++)
{
TenderOffer offer = new TenderOffer();
offer.Id_CMO_Order = Convert.ToInt32(((Excel.Range)range.Cells[row, 1]).Text);
offer.Id_CMO_Company = GetIdCompany(((Excel.Range)range.Cells[row, 4]).Text);
offer.Cost = Convert.ToInt32(((Excel.Range)range.Cells[row, 6]).Text);
offer.Duration = Convert.ToInt32(((Excel.Range)range.Cells[row, 8]).Text);
offerList.Add(offer);
row++;
}
foreach (var VARIABLE in offerList)
{
CMO_Tender tender = new CMO_Tender();
tender.id_CMO_Order = VARIABLE.Id_CMO_Order;
tender.id_CMO_TypeTask = 3;
tender.finishPlanClose = DateTime.Now;
tender.close = true;
tender.closeDateTime = DateTime.Now;
db.CMO_Tender.Add(tender);
db.SaveChanges();
CMO_UploadResult result = new CMO_UploadResult();
result.id_CMO_Tender = tender.id;
result.dateTimeUpload = DateTime.Now;
result.cost = VARIABLE.Cost;
result.dateComplited = DateTime.Now;
result.id_CMO_Company = VARIABLE.Id_CMO_Company;
result.day = VARIABLE.Duration;
db.CMO_UploadResult.Add(result);
db.SaveChanges();
CMO_Order order = db.CMO_Order.Find(tender.id_CMO_Order);
order.companyWin = result.id_CMO_Company;
db.Entry(order).State = EntityState.Modified;
db.SaveChanges();
}
CloseWorkbook();
}
