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