public void ImporterElPInvLogic()
{
string DirectoryPath = @"C:\Users\jjfigueroa\OneDrive - kochind.com\Documents\SAP\SAP GUI\";
string FileNames = "ELPInv";
string Extention = ".txt";
string RenameFileDate = DateTime.Now.ToString("MMddyyyyHHmmss");
using (_databaseContext dbContext = new _databaseContext())
{
if (File.Exists(DirectoryPath + FileNames + Extention))
{
var ELPInvTable = dbContext.ELPInvs;
dbContext.ELPInvs.RemoveRange(ELPInvTable);
dbContext.SaveChanges();
string[] ELPInvLines = File.ReadAllLines(DirectoryPath + FileNames + Extention);
foreach (var item in ELPInvLines)
{
int position = Array.LastIndexOf(ELPInvLines, item);
if (position > 2)
{
var ELPInvFile = item.Split('|');
if (ELPInvFile.Length > 1)
{
ELPInv newElpInv = new ELPInv();
newElpInv.Material = ELPInvFile[1];
newElpInv.Plnt = ELPInvFile[2];
newElpInv.Batch = ELPInvFile[3];
newElpInv.MaterialDescription = ELPInvFile[4];
newElpInv.Typ = ELPInvFile[5];
newElpInv.StorageBin = ELPInvFile[6];
newElpInv.S = ELPInvFile[7];
newElpInv.BUn = ELPInvFile[8];
newElpInv.TotalStock = ELPInvFile[9];
newElpInv.GRDate = ELPInvFile[10];
dbContext.ELPInvs.Add(newElpInv);
}
}
}
dbContext.SaveChanges();
File.Move(DirectoryPath + FileNames + Extention, DirectoryPath + FileNames + RenameFileDate + Extention);
}
}
}
public void ImporterJRZInventoryLogic()
{
string DirectoryPath = @"C:\Users\jjfigueroa\OneDrive - kochind.com\Documents\SAP\SAP GUI\";
string FileNames = "JRZInventory";
string Extention = ".txt";
string RenameFileDate = DateTime.Now.ToString("MMddyyyyHHmmss");
using (_databaseContext dbContext = new _databaseContext())
{
if (File.Exists(DirectoryPath + FileNames + Extention))
{
string[] JRZInventoryLines = File.ReadAllLines(DirectoryPath + FileNames + Extention);
foreach (var item in JRZInventoryLines)
{
int position = Array.LastIndexOf(JRZInventoryLines, item);
if (position > 2)
{
// Splitting each line in objects
var JRZInvFile = item.Split('|');
if (JRZInvFile.Length > 1)
{
JRZInventory newJRZInv = new JRZInventory();
newJRZInv.Material = JRZInvFile[1];
newJRZInv.Plnt = JRZInvFile[2];
newJRZInv.Batch = JRZInvFile[3];
newJRZInv.MaterialDescription = JRZInvFile[4];
newJRZInv.Typ = JRZInvFile[5];
newJRZInv.StorageBin = JRZInvFile[6];
newJRZInv.BUn = JRZInvFile[7];
newJRZInv.TotalStock = JRZInvFile[8];
newJRZInv.GRDate = JRZInvFile[9];
// Adding each record to the intance
dbContext.JRZInventories.Add(newJRZInv);
}
}
}
// Transactio to Sql Server
dbContext.SaveChanges();
// Rename the file.
File.Move(DirectoryPath + FileNames + Extention, DirectoryPath + FileNames + RenameFileDate + Extention);
}
}
}
public void ImportWorkOrderLogic()
{
string DirectoryPath = @"C:\Users\jjfigueroa\OneDrive - kochind.com\Documents\SAP\SAP GUI\";
string FileNames = "CooisWorkOrders";
string Extention = ".txt";
string RenameFileDate = DateTime.Now.ToString("MMddyyyyHHmmss");
using (_databaseContext dbContext = new _databaseContext())
{
if (File.Exists(DirectoryPath + FileNames + Extention))
{
// Clean workOrder table.
var WO = dbContext.WorkOrders;
dbContext.WorkOrders.RemoveRange(WO);
dbContext.SaveChanges();
// Starting with new data from file.
string[] CooisLineas = File.ReadAllLines(DirectoryPath + FileNames + Extention);
foreach (var item in CooisLineas)
{
int position = Array.LastIndexOf(CooisLineas, item);
if (position > 2)
{
// Hace la separacion en objetos
var CooisFile = item.Split('|');
if (CooisFile.Length > 1)
{
// Consulta a Base de datos por WorkOrder
string won = CooisFile[1];
var Wos = dbContext.WorkOrders.FirstOrDefault(w => w.WorkOrderNumber == won);
//if (Wos == null) continue;
// Comparar si la Orden Existe...
if (Wos == null)
{
if (CooisFile.Length > 1)
{
WorkOrder newOrder = new WorkOrder();
newOrder.WorkOrderNumber = CooisFile[1];
newOrder.MaterialNumber = CooisFile[2];
newOrder.Seq_no_ = CooisFile[3];
newOrder.Priority = CooisFile[4];
newOrder.MaterialDescription = CooisFile[5];
newOrder.Target_qty = CooisFile[6];
newOrder.Del_qty = CooisFile[7];
newOrder.Bsc_start = CooisFile[8];
newOrder.Release = CooisFile[9];
newOrder.MRP_ctrlr = CooisFile[10];
newOrder.Order_Type = CooisFile[11];
newOrder.System_Status = CooisFile[12];
dbContext.WorkOrders.Add(newOrder);
}
}
}
}
}
// Transaction to Sql Server
dbContext.SaveChanges();
// Rename the file.
File.Move(DirectoryPath + FileNames + Extention, DirectoryPath + FileNames + RenameFileDate + Extention);
}
}
}
