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 ActionResult DeleteBillNo(int?id)
{
string errMsg = "Error!";
int ret = 0;
if (id == null)
{
errMsg = "Kindly send Invoice No!";
return(Json(new { Count = ret, Msg = errMsg }));
}
var inv = aprajitaContext.RegularInvoices.Include(c => c.PaymentDetail).Include(c => c.SaleItems).Include(c => c.PaymentDetail.CardDetail).Where(c => c.RegularInvoiceId == id).FirstOrDefault();
if (inv == null)
{
errMsg = "Invoice Number Not found!";
}
else
{
aprajitaContext.RegularInvoices.Remove(inv);
ret = aprajitaContext.SaveChanges();
if (ret > 0)
{
errMsg = "Invoice is Deleted!";
}
else
{
errMsg = "It fails to delete Invoice!";
}
}
return(Json(new { Count = ret, Msg = errMsg }));
}
//StoreBased Action
public void CashInBankCorrectionForMonth(eStoreDbContext db, DateTime forDate, int StoreId)
{
IEnumerable <CashInBank> cashs = db.CashInBanks.Where(c => c.CIBDate.Month == forDate.Month && c.CIBDate.Year == forDate.Year && c.StoreId == StoreId).OrderBy(c => c.CIBDate);
decimal cBal = 0;
if (cashs != null && cashs.Any())
{
cBal = GetClosingBalance(db, cashs.First().CIBDate, StoreId);
if (cBal == 0)
{
cBal = cashs.First().OpenningBalance;
}
foreach (var cash in cashs)
{
cash.OpenningBalance = cBal;
cash.ClosingBalance = cash.OpenningBalance + cash.CashIn - cash.CashOut;
cBal = cash.ClosingBalance;
db.Entry(cash).State = EntityState.Modified;
}
try
{
db.SaveChanges();
}
catch (Exception)
{
// Log.Info("CashInBank Correction failed");
}
}
}
// Correct Cash In Hand In Database
/// <summary>
/// Delete Cash In Hand For Particular Month & Year and Store
/// </summary>
/// <param name="db"></param>
/// <param name="date"></param>
private void DeleteCashInHandForMonth(eStoreDbContext db, DateTime date, int Store)
{
var cih = db.CashInHands.Where(c => c.CIHDate.Month == date.Month && c.CIHDate.Year == date.Year && c.StoreId == Store);
db.CashInHands.RemoveRange(cih);
db.SaveChanges();
}
//StoreBased Action
public void ProcessBankOpenningBalance(eStoreDbContext db, DateTime date, int StoreId, bool saveit = false)
{
CashInBank today;
today = db.CashInBanks.Where(c => c.CIBDate.Date == date.Date && c.StoreId == StoreId).FirstOrDefault();
DateTime yDate = date.AddDays(-1);
CashInBank yesterday = db.CashInBanks.Where(c => c.CIBDate.Date == yDate.Date && c.StoreId == StoreId).FirstOrDefault();
bool isNew = false;
if (today == null)
{
today = new CashInBank()
{
CashIn = 0, CashOut = 0, CIBDate = date, ClosingBalance = 0, OpenningBalance = 0, StoreId = StoreId
};
isNew = true;
}
if (yesterday == null)
{
yesterday = new CashInBank()
{
CashIn = 0, CashOut = 0, CIBDate = yDate, ClosingBalance = 0, OpenningBalance = 0, StoreId = StoreId
};
today.OpenningBalance = 0;
today.ClosingBalance = today.OpenningBalance + today.CashIn - today.CashOut;
db.CashInBanks.Add(yesterday);
}
else
{
yesterday.ClosingBalance = yesterday.OpenningBalance + yesterday.CashIn - yesterday.CashOut;
today.OpenningBalance = yesterday.ClosingBalance;
today.ClosingBalance = today.OpenningBalance + today.CashIn - today.CashOut;
db.Entry(yesterday).State = EntityState.Modified;
}
if (isNew)
{
db.CashInBanks.Add(today);
}
else
{
db.Entry(today).State = EntityState.Modified;
}
if (saveit)
{
db.SaveChanges();
}
}
public static void CreateCashInBank(eStoreDbContext db, DateTime date, decimal inAmt, decimal outAmt, bool saveit = false)
{
//throw new NotImplementedException();
CashInBank today;
DateTime yDate = date.AddDays(-1);
CashInBank yesterday = db.CashInBanks.Where(c => c.CIBDate == yDate).FirstOrDefault();
today = new CashInBank()
{
CashIn = inAmt, CashOut = outAmt, CIBDate = date, ClosingBalance = 0, OpenningBalance = 0
};
if (yesterday != null)
{
yesterday.ClosingBalance = yesterday.OpenningBalance + yesterday.CashIn - yesterday.CashOut;
today.ClosingBalance = today.OpenningBalance = yesterday.ClosingBalance;
db.CashInBanks.Add(today);
if (saveit)
{
db.SaveChanges();
}
}
else
{
//TODO: need to option to create cashinbank entry for all missing entry and correct
//if (db.CashInBanks.Count() > 0)
// throw new Exception();
//else
{
today.ClosingBalance = today.OpenningBalance = 0;
db.CashInBanks.Add(today);
if (saveit)
{
db.SaveChanges();
}
}
}
}
public static int AddExpLedgerType(eStoreDbContext db)
{
string[] lists = { "Electricity", "Postage", "HomeExpenses", "Out of Store", "Assests", "Freight", "Serivces", "Tax & Duties" };
foreach (var item in lists)
{
LedgerType lt = new LedgerType {
LedgerNameType = item, Remark = item, Category = LedgerCategory.Expenses
};
db.LedgerTypes.Add(lt);
}
return(db.SaveChanges());
}
public static int CreateLedgerMaster(eStoreDbContext db, Party party)
{
LedgerMaster master = new LedgerMaster
{
CreatingDate = DateTime.Today,
PartyId = party.PartyId,
LedgerTypeId = party.LedgerTypeId
};
db.Add(master);
return(db.SaveChanges());
}
//Edit Based on Required Below Function
//Create CashInHand/Bank
public static void CreateCashInHand(eStoreDbContext db, DateTime date, decimal inAmt, decimal outAmt, bool saveit = false)
{
// throw new NotImplementedException();
//TODO: make new age function error free
//One Day Back
DateTime yDate = date.AddDays(-1);
CashInHand yesterday = db.CashInHands.Where(c => c.CIHDate == yDate).FirstOrDefault();
CashInHand today = new CashInHand()
{
CashIn = inAmt, CashOut = outAmt, CIHDate = date, ClosingBalance = 0, OpenningBalance = 0
};
if (yesterday != null)
{
yesterday.ClosingBalance = yesterday.OpenningBalance + yesterday.CashIn - yesterday.CashOut;
today.ClosingBalance = today.OpenningBalance = yesterday.ClosingBalance;
db.CashInHands.Add(today);
if (saveit)
{
db.SaveChanges();
}
}
else
{
//if (db.CashInHands.Count() > 0)
// throw new Exception();
//TODO: if yesterday one or day back data not present handel this
//else
{
today.ClosingBalance = today.OpenningBalance = 0;
db.CashInHands.Add(today);
if (saveit)
{
db.SaveChanges();
}
}
}
}
public void AddToDoList(eStoreDbContext db, string title, string msg, DateTime duedate)
{
ToDoMessage todo = new ToDoMessage
{
IsOver = false,
OnDate = DateTime.Now,
Message = msg,
DueDate = duedate,
Status = "Pending",
Title = title
};
db.ToDoMessages.Add(todo);
db.SaveChanges();
}
public static int UpdateLedgerMaster(eStoreDbContext db, Party party)
{
var master = db.LedgerMasters.Where(c => c.PartyId == party.PartyId).FirstOrDefault();
if (master != null)
{
master.LedgerTypeId = party.LedgerTypeId;
db.Update(master);
return(db.SaveChanges());
}
else
{
return(-1);
}
}
public static int AddPartyList(eStoreDbContext db)
{
foreach (var item in Head)
{
Party p = new Party
{
Address = "Dumka",
PartyName = item, OpenningDate = DateTime.Today, OpenningBalance = 0,
LedgerTypeId = 7
};
db.Parties.Add(p);
}
return(db.SaveChanges());
}
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();
}
}
public static void UpdateCashInBank(eStoreDbContext db, DateTime dateTime, decimal Amount, bool saveit = false)
{
//throw new NotImplementedException();
CashInBank cashIn = db.CashInBanks.Where(d => d.CIBDate == dateTime).FirstOrDefault();
if (cashIn != null)
{
cashIn.CashIn += Amount;
db.SaveChanges();
}
else
{
CreateCashInBank(db, dateTime, Amount, 0, saveit);
}
}
//StoreBased Action
public void ProcessBankClosingBalance(eStoreDbContext db, DateTime date, int StoreId, bool saveit = false)
{
CashInBank today;
today = db.CashInBanks.Where(c => c.CIBDate.Date == date.Date && c.StoreId == StoreId).FirstOrDefault();
if (today != null)
{
if (today.ClosingBalance != today.OpenningBalance + today.CashIn - today.CashOut)
{
today.ClosingBalance = today.OpenningBalance + today.CashIn - today.CashOut;
db.Entry(today).State = EntityState.Modified;
if (saveit)
{
db.SaveChanges();
}
}
}
}
//Update CashOutHand/Bank
public static void UpDateCashOutHand(eStoreDbContext db, DateTime dateTime, decimal Amount, bool saveit = false)
{
//throw new NotImplementedException();
CashInHand cashIn = db.CashInHands.Where(d => d.CIHDate == dateTime).FirstOrDefault();
if (cashIn != null)
{
cashIn.CashOut += Amount;
db.Entry(cashIn).State = EntityState.Modified;
if (saveit)
{
db.SaveChanges();
}
}
else
{
CreateCashInHand(db, dateTime, 0, Amount, saveit);
}
}
public InvoiceSaveReturn OnEdit(eStoreDbContext db, EditOrderDTO sales, int StoreId = 1)
{
Customer cust = db.Customers.Where(c => c.MobileNo == sales.MobileNo).FirstOrDefault();
if (cust == null)
{
string[] names = sales.Name.Split(" ");
string FName = names[0];
string LName = "";
for (int i = 1; i < names.Length; i++)
{
LName += names[i] + " ";
}
cust = new Customer
{
City = "",
Age = 30,
FirstName = FName,
Gender = Gender.Male,
LastName = LName,
MobileNo = sales.MobileNo,
NoOfBills = 0,
TotalAmount = 0,
CreatedDate = DateTime.Now.Date
};
db.Customers.Add(cust);
db.SaveChanges();
}
RegularInvoice inv = db.RegularInvoices.Find(sales.InvoiceNo);
if (inv == null)
{
return(null);
}
inv.SaleItems = db.RegularSaleItems.Where(c => c.InvoiceNo == sales.InvoiceNo).ToList();
inv.PaymentDetail = db.PaymentDetails.Include(c => c.CardAmount).Where(c => c.InvoiceNo == sales.InvoiceNo).FirstOrDefault();
return(null);//TODO: temp
}
public InvoiceSaveReturn OnInsert(eStoreDbContext db, SaveOrderDTO sales, string userName, int StoreId = 1)
{
Customer cust = db.Customers.Where(c => c.MobileNo == sales.MobileNo).FirstOrDefault();
if (cust == null)
{
string[] names = sales.Name.Split(" ");
string FName = names[0];
string LName = "";
for (int i = 1; i < names.Length; i++)
{
LName += names[i] + " ";
}
cust = new Customer
{
City = sales.Address,
Age = 30,
FirstName = FName,
Gender = Gender.Male,
LastName = LName,
MobileNo = sales.MobileNo,
NoOfBills = 0,
TotalAmount = 0,
CreatedDate = DateTime.Now.Date
};
db.Customers.Add(cust);
}
string InvNo = GenerateInvoiceNo(db, StoreId, true);
List <RegularSaleItem> itemList = new List <RegularSaleItem>();
List <Stock> stockList = new List <Stock>();
foreach (var item in sales.SaleItems)
{
RegularSaleItem sItem = new RegularSaleItem
{
BarCode = item.BarCode,
MRP = item.Price,
Qty = item.Quantity,
Discount = 0,
SalesmanId = item.Salesman,
Units = item.Units,
InvoiceNo = InvNo,
BasicAmount = item.Amount,
TaxAmount = 0,
ProductItemId = -1,
BillAmount = 0,
SaleTaxTypeId = 1, //TODO: default tax id needed
};
ProductItem pItem = db.ProductItems.Where(c => c.Barcode == item.BarCode).FirstOrDefault();
Stock stock = db.Stocks.Where(c => c.ProductItemId == pItem.ProductItemId && c.StoreId == StoreId).FirstOrDefault();
sItem.ProductItemId = pItem.ProductItemId;
decimal amt = (decimal)item.Quantity * item.Price;
sItem.BasicAmount = (amt * 100) / (100 + pItem.TaxRate);
sItem.TaxAmount = (sItem.BasicAmount * pItem.TaxRate) / 100;
sItem.BillAmount = sItem.BasicAmount + sItem.TaxAmount;
//SaleTax Id
var taxid = db.SaleTaxTypes.Where(c => c.CompositeRate == pItem.TaxRate).Select(c => c.SaleTaxTypeId).FirstOrDefault();
if (taxid <= 0)
{
taxid = 1; //TODO: Handle it for creating new saletax id
}
sItem.SaleTaxTypeId = taxid;
itemList.Add(sItem);
stock.SaleQty += item.Quantity;
stock.Quantity -= item.Quantity;
stockList.Add(stock);
}
var totalBillamt = itemList.Sum(c => c.BillAmount);
var totaltaxamt = itemList.Sum(c => c.TaxAmount);
var totalDiscount = itemList.Sum(c => c.Discount);
var totalQty = itemList.Sum(c => c.Qty);
var totalitem = itemList.Count;
decimal roundoffamt = Math.Round(totalBillamt) - totalBillamt;
PaymentDetail pd = new PaymentDetail
{
CardAmount = sales.PaymentInfo.CardAmount,
CashAmount = sales.PaymentInfo.CashAmount,
InvoiceNo = InvNo,
IsManualBill = true,
MixAmount = 0,
PayMode = SalePayMode.Cash
};
if (sales.PaymentInfo.CardAmount > 0)
{
if (sales.PaymentInfo.CashAmount > 0)
{
pd.PayMode = SalePayMode.Mix;
}
else
{
pd.PayMode = SalePayMode.Card;
}
CardDetail cd = new CardDetail
{
CardCode = CardType.Visa,//TODO: default
Amount = sales.PaymentInfo.CardAmount,
AuthCode = (int)Int64.Parse(sales.PaymentInfo.AuthCode),
InvoiceNo = InvNo,
LastDigit = (int)Int64.Parse(sales.PaymentInfo.CardNo),
CardType = CardMode.DebitCard//TODO: default
};
if (sales.PaymentInfo.CardType.Contains("Debit") || sales.PaymentInfo.CardType.Contains("debit") || sales.PaymentInfo.CardType.Contains("DEBIT"))
{
cd.CardType = CardMode.DebitCard;
}
else if (sales.PaymentInfo.CardType.Contains("Credit") || sales.PaymentInfo.CardType.Contains("credit") || sales.PaymentInfo.CardType.Contains("CREDIT"))
{
cd.CardType = CardMode.CreditCard;
}
if (sales.PaymentInfo.CardType.Contains("visa") || sales.PaymentInfo.CardType.Contains("Visa") || sales.PaymentInfo.CardType.Contains("VISA"))
{
cd.CardCode = CardType.Visa;
}
else if (sales.PaymentInfo.CardType.Contains("MasterCard") || sales.PaymentInfo.CardType.Contains("mastercard") || sales.PaymentInfo.CardType.Contains("MASTERCARD"))
{
cd.CardCode = CardType.MasterCard;
}
else if (sales.PaymentInfo.CardType.Contains("Rupay") || sales.PaymentInfo.CardType.Contains("rupay") || sales.PaymentInfo.CardType.Contains("RUPAY"))
{
cd.CardCode = CardType.Rupay;
}
else if (sales.PaymentInfo.CardType.Contains("MASTRO") || sales.PaymentInfo.CardType.Contains("mastro") || sales.PaymentInfo.CardType.Contains("Mastro"))
{
cd.CardCode = CardType.Rupay;
}
pd.CardDetail = cd;
}
RegularInvoice Invoice = new RegularInvoice
{
Customer = cust,
InvoiceNo = InvNo,
OnDate = sales.OnDate,
IsManualBill = true,
StoreId = StoreId,
SaleItems = itemList,
CustomerId = cust.CustomerId,
TotalBillAmount = totalBillamt + roundoffamt,
TotalDiscountAmount = totalDiscount,
TotalItems = totalitem,
TotalQty = totalQty,
TotalTaxAmount = totaltaxamt,
RoundOffAmount = roundoffamt,
PaymentDetail = pd,
UserId = userName
};
db.RegularInvoices.Add(Invoice);
db.Stocks.UpdateRange(stockList);
InvoiceSaveReturn returnData = new InvoiceSaveReturn
{
NoOfRecord = db.SaveChanges(),
FileName = "NotSaved"
};
if (returnData.NoOfRecord > 0)
{
ReceiptHeader header = PrinterHelper.GetReceiptHeader(db, StoreId);
ReceiptDetails details = PrinterHelper.GetReceiptDetails(Invoice.InvoiceNo, Invoice.OnDate, DateTime.Now.ToShortTimeString(), sales.Name);
ReceiptItemTotal itemtotal = PrinterHelper.GetReceiptItemTotal(Invoice);
List <ReceiptItemDetails> itemDetailList = PrinterHelper.GetInvoiceDetails(db, itemList);
returnData.FileName = "/" + InvoicePrinter.PrintManaulInvoice(header, itemtotal, details, itemDetailList, false);
}
return(returnData);
}
//StoreBased Action
private List <CashInHand> CreateCashInHands(eStoreDbContext db, List <CashBook> orderBook, int Store)
{
List <CashInHand> inHandList = new List <CashInHand>();
CashInHand cashInHand = null;
DateTime startDate = orderBook.First().EDate;
//Remove CashInHand from Database
DeleteCashInHandForMonth(db, startDate, Store);
if (startDate.Date != new DateTime(startDate.Year, startDate.Month, 1))
{
CashInHand first = new CashInHand()
{
CIHDate = new DateTime(startDate.Year, startDate.Month, 1),
OpenningBalance = 0,
CashIn = 0,
CashOut = 0,
ClosingBalance = 0,
StoreId = Store
};
db.CashInHands.Add(first);
inHandList.Add(first);
db.SaveChanges();
}
foreach (var item in orderBook)
{
if (cashInHand == null)
{
db.SaveChanges();
cashInHand = new CashInHand()
{
CIHDate = item.EDate,
OpenningBalance = 0,
CashIn = item.CashIn,
CashOut = item.CashOut,
ClosingBalance = 0,
StoreId = Store
};
}
else if (startDate != item.EDate && cashInHand != null)
{
db.CashInHands.Add(cashInHand);
inHandList.Add(cashInHand);
db.SaveChanges();
var datediff = item.EDate - startDate;
if (datediff.TotalDays > 1)
{
for (int xo = 1; xo < datediff.TotalDays; xo++)
{
cashInHand = new CashInHand()
{
CIHDate = startDate.AddDays(xo),
OpenningBalance = 0,
CashIn = 0,
CashOut = 0,
ClosingBalance = 0,
StoreId = Store
};
db.CashInHands.Add(cashInHand);
inHandList.Add(cashInHand);
db.SaveChanges();
}
}
cashInHand = new CashInHand()
{
CIHDate = item.EDate,
OpenningBalance = 0,
CashIn = item.CashIn,
CashOut = item.CashOut,
ClosingBalance = 0,
StoreId = Store
};
startDate = item.EDate;
}
else
{
cashInHand.CashIn += item.CashIn;
cashInHand.CashOut += item.CashOut;
}
}
db.CashInHands.Add(cashInHand);
inHandList.Add(cashInHand);
db.SaveChanges();
DateTime endDate;
endDate = new DateTime(startDate.Year, startDate.Month, DateTime.DaysInMonth(startDate.Year, startDate.Month));
if (startDate != endDate)
{
var datediff = endDate - startDate;
if (datediff.TotalDays > 1)
{
for (int xo = 1; xo < datediff.TotalDays; xo++)
{
cashInHand = new CashInHand()
{
CIHDate = startDate.AddDays(xo),
OpenningBalance = 0,
CashIn = 0,
CashOut = 0,
ClosingBalance = 0,
StoreId = Store
};
db.CashInHands.Add(cashInHand);
inHandList.Add(cashInHand);
db.SaveChanges();
}
}
cashInHand = new CashInHand()
{
CIHDate = endDate,
OpenningBalance = 0,
CashIn = 0,
CashOut = 0,
ClosingBalance = 0,
StoreId = Store
};
db.CashInHands.Add(cashInHand);
inHandList.Add(cashInHand);
db.SaveChanges();
}
return(inHandList);
}
//StoreBased Action
private List <CashBook> CreateCashInHands(eStoreDbContext db, List <CashBook> books, int Store)
{
IEnumerable <CashBook> orderBook = books.OrderBy(c => c.EDate);
CashInHand cashInHand = null;
DateTime startDate = orderBook.First().EDate;
//Remove CashInHand from Database
DeleteCashInHandForMonth(db, startDate, Store);
foreach (var item in orderBook)
{
if (cashInHand == null)
{
db.SaveChanges();
cashInHand = new CashInHand()
{
CIHDate = item.EDate,
OpenningBalance = 0,
CashIn = item.CashIn,
CashOut = item.CashOut,
ClosingBalance = 0,
StoreId = Store
};
}
else if (startDate != item.EDate && cashInHand != null)
{
db.CashInHands.Add(cashInHand);
var datediff = startDate - item.EDate;
if (datediff.TotalDays > 1)
{
for (int xo = 1; xo < datediff.TotalDays; xo++)
{
cashInHand = new CashInHand()
{
CIHDate = startDate.AddDays(xo),
OpenningBalance = 0,
CashIn = 0,
CashOut = 0,
ClosingBalance = 0,
StoreId = Store
};
db.CashInHands.Add(cashInHand);
}
}
db.SaveChanges();
cashInHand = new CashInHand()
{
CIHDate = item.EDate,
OpenningBalance = 0,
CashIn = item.CashIn,
CashOut = item.CashOut,
ClosingBalance = 0,
StoreId = Store
};
startDate = item.EDate;
}
else
{
cashInHand.CashIn += item.CashIn;
cashInHand.CashOut += item.CashOut;
}
}
db.CashInHands.Add(cashInHand);
db.SaveChanges();
return(orderBook.ToList());
}
public void UpDateToDoList(eStoreDbContext db, ToDoMessage todo)
{
db.Update(todo);
db.SaveChanges();
}
public static async System.Threading.Tasks.Task <string> ProcessExpensesAsync(eStoreDbContext db)
{
string Message = "";
int PartyId = 0;
int TotalUpdate = 0;
var exps = await db.Expenses.Where(c => c.PartyName.Contains("KITES") && c.PartyId == null).ToListAsync();
PartyId = GetPartyId(db, "Kites");
foreach (var e in exps)
{
e.PartyId = PartyId;
e.EntryStatus = EntryStatus.Updated;
db.Expenses.Update(e);
}
PartyId = 0;
exps = await db.Expenses.Where(c => c.Particulars.Contains("water") && c.PartyId == null).ToListAsync();
PartyId = GetPartyId(db, "Kites");
foreach (var e in exps)
{
e.PartyId = PartyId;
e.EntryStatus = EntryStatus.Updated;
db.Expenses.Update(e);
}
PartyId = 0;
TotalUpdate += db.SaveChanges();
foreach (var h in Head)
{
if (h == "maa bhawani art")
{
PartyId = GetPartyId(db, "Maa Bhawani Art");
}
else if (h == "painter")
{
PartyId = GetPartyId(db, "Painter");
}
else if (h == "store renovation cost")
{
PartyId = GetPartyId(db, "Store Renovation");
}
else if (h == "telephone")
{
PartyId = GetPartyId(db, "Telephone Bill");
}
else if (h == "Kites")
{
var exp1 = await db.Expenses.Where(c => c.Particulars.Contains("water") && c.PartyId == null).ToListAsync();
foreach (var e in exp1)
{
e.PartyId = PartyId;
e.EntryStatus = EntryStatus.Updated;
db.Expenses.Update(e);
}
PartyId = 0;
}
else
{
PartyId = GetPartyId(db, h);
}
if (PartyId > 0)
{
var exp = await db.Expenses.Where(c => c.Particulars.ToLower().Contains(h.ToLower()) && c.PartyId == null).ToListAsync();
foreach (var e in exp)
{
e.PartyId = PartyId;
e.EntryStatus = EntryStatus.Updated;
db.Expenses.Update(e);
}
PartyId = 0;
TotalUpdate += db.SaveChanges();
}
else
{
Console.WriteLine("PartyName: " + h);
Message += "PartyName: " + h;
}
}
var exp12 = await db.Expenses.Where(c => c.PartyId == null).ToListAsync();
foreach (var e in exp12)
{
e.PartyId = 43;
e.EntryStatus = EntryStatus.Updated;
db.Expenses.Update(e);
}
TotalUpdate += db.SaveChanges();
Message += " #Total Update: " + TotalUpdate;
return(Message);
}