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