private async System.Threading.Tasks.Task AddAllSheetAsync() { foreach (var item in EmpRecord) { await AddAttendenceAsync(xS.GetWS("Att_" + item.StaffName), item.NewId); await AddSalaryPaymentAsync(xS.GetWS("Sal_" + item.StaffName), item.NewId, item.PartyId); } }
private async Task <SortedList <int, int> > SaleDetailsAsync() { var ws = xS.GetWS("DailySales"); var nonEmptyDataRows = ws.RowsUsed(); int Row = 6;//Title SortedDictionary <int, string> SaleList = new SortedDictionary <int, string>(); foreach (var dR in nonEmptyDataRows) { if (dR.RowNumber() > Row) { SaleList.Add(dR.Cell(1).GetValue <int>(), dR.Cell(3).GetValue <string>()); } } ws = xS.GetWS("DueLists"); nonEmptyDataRows = ws.RowsUsed(); SortedList <int, int> IDList = new SortedList <int, int>(); foreach (var dR in nonEmptyDataRows) { if (dR.RowNumber() > Row) { IDList.Add(dR.Cell(1).GetValue <int>(), await GetDueIdAsync(GetSaleId(SaleList.GetValueOrDefault(dR.Cell(5).GetValue <int>())))); } } return(IDList); }
public DataTable TestImportExcel(eStoreDbContext db, string fileName) { Console.WriteLine(fileName); XSReader xS = new XSReader(fileName); var ws = xS.GetWS("Employees"); var dt = XSReader.ReadSheetToDt(ws, 6); int c = dt.Columns.IndexOf("UserName"); dt.Columns[c].ColumnName = "UserId"; dt.Columns.Add("EntryStatus"); dt.Columns.Add("IsReadOnly"); int c1 = 101; for (int i = 0; i < dt.Rows.Count; i++) { dt.Rows[i]["EntryStatus"] = EntryStatus.Added; dt.Rows[i]["IsReadOnly"] = true; dt.Rows[i][0] = ((i + 1 * 201) * c1 / 3) * i; c1 = c1 + new Random(c1).Next(); } dt.AcceptChanges(); //JsonConvert.SerializeObject(dt); // var lst = CommonMethod.ConvertToList <Employee>(dt); //var lst = DAL.CreateListFromTable<Employee>(dt); db.Employees.AddRange(lst); Console.WriteLine(JsonConvert.SerializeObject(dt)); Console.WriteLine("Save: " + db.SaveChanges()); return(dt); }
public async System.Threading.Tasks.Task ReadPayRollAsync(string fileName) { xS = new XSReader(fileName); if (xS.WorkBookName == "PayRoll") { db.Attendances.RemoveRange(db.Attendances); db.SalaryPayments.RemoveRange(db.SalaryPayments); db.Salesmen.RemoveRange(db.Salesmen); db.Employees.RemoveRange(db.Employees); db.SaveChanges(); await AddEmployeesAsync(xS.GetWS("Employees")); // await AddAllSheetAsync(); // await AddCurrentSalarAsync(xS.GetWS("CurrentSalaries")); } else { throw new Exception(); } }