public int DeleteFile(string file)
{
List <UploadedFile> dbFile = _serverContext.UploadedFiles.ToList();
//foreach(UploadedFile f in dbFile)
//{
// f.Path = Path.GetFileName(f.Path);
//};
List <UploadedFile> dbFileFiltered = dbFile.Where(x => Path.GetFileName(x.Path) == file).ToList();
//_serverContext.UploadedFiles.Remove(dbFile);
//_serverContext.SaveChanges();
string fullPath = Path.Combine(_environment.WebRootPath, file);
if (File.Exists(fullPath))
{
File.Delete(fullPath);
//UploadedFile dbFile1 = _serverContext.UploadedFiles.Find(x => x.P )
//_serverContext.UploadedFiles.Remove(dbFile1);
//_serverContext.SaveChanges();
if (dbFileFiltered.Count > 0)
{
foreach (UploadedFile f in dbFileFiltered)
{
_serverContext.UploadedFiles.Remove(f);
}
_serverContext.SaveChanges();
}
}
return(1);
}
public int Add(InventoryModel inventoryModel)
{
Inventory inventory = new Inventory
{
InventoryProductServiceName = inventoryModel.Name,
InventoryProductServiceType = inventoryModel.Type,
InventoryProductServiceCode = inventoryModel.ProductServiceCode,
InventoryProductDescription = inventoryModel.Description,
InventoryProductServiceIncomeAccountId = inventoryModel.IncomeAccount.Value,
InventoryProductServiceExpenseAccountId = inventoryModel.ExpenseAccount == null ? null : inventoryModel.ExpenseAccount.Value,
InventoryProductServiceCreatedDate = DateTime.Now,
};
_serverContext.Inventories.Add(inventory);
_serverContext.SaveChanges();
return(inventory.Id);
}
public int AddUser(User user)
{
if (_serverContext.Users.FirstOrDefault(e => e.Email.ToLower() == user.Email.ToLower()) != null)
{
return(-1);
}
_serverContext.Users.Add(user);
_serverContext.SaveChanges();
return(user.Id);
}
public int AddAccount(ChartOfAccount account)
{
_serverContext.ChartOfAccounts.Add(account);
_serverContext.SaveChanges();
return(1);
}
int UpdatePurchase(PurchaseModel purchaseModel, bool addMode)
{
Purchase purchase = null;
if (addMode)
{
purchase = new Purchase
{
SubsidiaryLedgerAccountId = purchaseModel.Vendor.Value,
PurchaseModeOfPayment = purchaseModel.ModeOfPayment,
ChartOfAccountId = purchaseModel.ModeOfPayment == "PD" ? purchaseModel.ChartOfAccounts.Value : null,
PurchaseReferenceNo = purchaseModel.ReferenceNo,
PurchaseAmount = purchaseModel.Amount,
PurchaseDate = purchaseModel.Date,
PurchaseDueDate = purchaseModel.DueDate,
Description = purchaseModel.Description,
PurchaseCreatedDate = DateTime.Now
};
_serverContext.Purchases.Add(purchase);
_serverContext.SaveChanges();
}
else
{
purchase = _serverContext.Purchases.Find(purchaseModel.Id);
purchase.SubsidiaryLedgerAccountId = purchaseModel.Vendor.Value;
purchase.PurchaseModeOfPayment = purchaseModel.ModeOfPayment;
purchase.ChartOfAccountId = purchaseModel.ModeOfPayment == "PD" ? purchaseModel.ChartOfAccounts.Value : null;
purchase.PurchaseAmount = purchaseModel.Amount;
purchase.PurchaseReferenceNo = purchaseModel.ReferenceNo;
purchase.Description = purchaseModel.Description;
purchase.PurchaseDate = purchaseModel.Date;
purchase.PurchaseDueDate = purchaseModel.DueDate;
_serverContext.SaveChanges();
}
if (!addMode)
{
foreach (var item in _serverContext.PurchaseDetails.Where(x => x.PurchaseId == purchaseModel.Id).ToList())
{
PurchaseDetail purchaseDetail = new PurchaseDetail();
purchaseDetail = _serverContext.PurchaseDetails.Find(item.Id);
if (purchaseDetail != null)
{
_serverContext.PurchaseDetails.Remove(purchaseDetail);
_serverContext.SaveChanges();
}
}
}
foreach (PurchaseItemModel item in purchaseModel.Items)
{
PurchaseDetail purchaseDetail = new PurchaseDetail();
purchaseDetail.PurchaseId = purchase.Id;
if (item.InventoryItem != null)
{
purchaseDetail.PurchaseInventoryId = item.InventoryItem.Value;
}
purchaseDetail.ChartOfAccountId = item.ChartOfAccountItem.Value;
purchaseDetail.PurchaseTaxRateId = item.TaxRateItem.Value;
purchaseDetail.PurchaseDetailDescription = item.Description;
purchaseDetail.PurchaseQuantity = item.Quantity;
purchaseDetail.PurchaseUnitPrice = item.UnitPrice;
_serverContext.PurchaseDetails.Add(purchaseDetail);
_serverContext.SaveChanges();
}
if (!addMode)
{
var tempGl = _serverContext.GeneralLedgers.Where(x => x.PurchaseId == purchaseModel.Id).SingleOrDefault();
_serverContext.GeneralLedgers.Remove(tempGl);
}
return(purchase.Id);
}
public CustomerInvoiceModel EditSalesInvoice(CustomerInvoiceModel customerInvoiceModel)
{
_serverContext.Database.BeginTransaction();
try
{
int ledgerMasterId = UpdateLedger(customerInvoiceModel, false);
UpdateGeneralLedger(customerInvoiceModel, ledgerMasterId, ARTradeKey, SalesTaxKey);
// collectively sum all qty per itemid inorder to check items availability
var results = customerInvoiceModel.Items.GroupBy(x => x.SalesItem.Value).Select(g => new { Id = g.Key, Value = g.Sum(s => s.Qty) });
foreach (var item in results)
{
var Quantity = (from a in _serverContext.ViewInventoryBalances
where a.Id == item.Id
select new { balance = a.Balance }).FirstOrDefault();
if (Quantity == null)
{
continue;
}
if (Quantity.balance < item.Value)
{
_serverContext.InvoiceWithoutCosts.Add(new InvoiceWithoutCost
{
InvoiceWithoutCostInvoiceNo = customerInvoiceModel.InvoiceNo,
InvoiceWithoutCostDate = customerInvoiceModel.Date
});
_serverContext.SaveChanges();
break;
}
}
_serverContext.Database.CommitTransaction();
}
catch (Exception ex)
{
_serverContext.Database.RollbackTransaction();
}
return(customerInvoiceModel);
}
public int AddAccount(Tracking account)
{
_serverContext.Trackings.Add(account);
_serverContext.SaveChanges();
return(account.Id);
}
public int AddAccount(SubsidiaryLedgerAccountName account)
{
_serverContext.SubsidiaryLedgerAccountNames.Add(account);
_serverContext.SaveChanges();
return(account.Id);
}
public int AddAccount(IncomeItem account)
{
_serverContext.IncomeItems.Add(account);
_serverContext.SaveChanges();
return(account.Id);
}
public int AddAccount(TaxRate taxRate)
{
_serverContext.TaxRates.Add(taxRate);
_serverContext.SaveChanges();
return(taxRate.Id);
}