public List <StockInViewModel> GetAllStockList()
{
var stockList = new List <StockInViewModel>();
using (_dbContext = new AccountdbContext())
{
stockList = (from s in _dbContext.StockIn
join v in _dbContext.Vendor on s.VendorId equals v.VendorId
where s.IsActive.Equals(true)
select new StockInViewModel
{
id = s.StockId,
loadName = s.LoadName,
vendorId = s.VendorId,
totalQuantity = s.Quantity,
isActive = Convert.ToBoolean(s.IsActive),
createdDate = s.CreatedDate,
formattedCreatedDate = s.CreatedDate.HasValue ? s.CreatedDate.Value.ToString(_dateFormat) : "",
formattedModifiedDate = s.UpdatedDate.HasValue ? s.UpdatedDate.Value.ToString(_dateFormat) : "",
nickName = v.NickName,
firstName = v.FirstName
}).ToList();
}
return(stockList);
}
public CommonResponseViewModel UpdateStock(StockInViewModel stockInVM)
{
CommonResponseViewModel response = new CommonResponseViewModel();
try
{
using (_dbContext = new AccountdbContext())
{
var dbStockIn = _dbContext.StockIn.Where(s => s.StockId.Equals(stockInVM.id)).FirstOrDefault();
if (dbStockIn != null)
{
dbStockIn.Quantity = stockInVM.totalQuantity;
dbStockIn.CreatedDate = stockInVM.createdDate.HasValue ? stockInVM.createdDate.Value : dbStockIn.CreatedDate;
dbStockIn.UpdatedDate = DateTime.Now;
_dbContext.StockIn.Update(dbStockIn);
_dbContext.SaveChanges();
response.isSuccess = true;
}
}
}
catch (Exception ex)
{
throw ex;
}
return(response);
}
public CustomerViewModel GetCustomerById(int id)
{
var customerViewModel = new CustomerViewModel();
var cust = new EfDbContext.Customer();
try
{
using (_dbContext = new AccountdbContext())
{
//cust = _dbContext.Customer.Where(e => e.CustId.Equals(id)).FirstOrDefault();
customerViewModel = (from c in _dbContext.Customer
join cd in _dbContext.CustomerDetails on c.CustId equals cd.CustId
where c.CustId == id
select ConstructCustomerViewModelFromContext(c, cd)
).FirstOrDefault();
}
//customerViewModel = ConstructCustomerViewModelFromContext(cust);
}
catch (Exception ex)
{
throw ex;
}
return(customerViewModel);
}
public StockInViewModel StockById(string id)
{
var stockid = Convert.ToInt64(id);
var stockInfo = new StockInViewModel();
using (_dbContext = new AccountdbContext())
{
stockInfo = (from s in _dbContext.StockIn
join v in _dbContext.Vendor on s.VendorId equals v.VendorId
where s.IsActive.Equals(true) && s.StockId.Equals(stockid)
select new StockInViewModel
{
id = s.StockId,
loadName = s.LoadName,
vendorId = s.VendorId,
totalQuantity = s.Quantity,
isActive = Convert.ToBoolean(s.IsActive),
createdDate = s.CreatedDate,
formattedCreatedDate = s.CreatedDate.HasValue ? s.CreatedDate.Value.ToString(_dateFormat) : "",
formattedModifiedDate = s.UpdatedDate.HasValue ? s.UpdatedDate.Value.ToString(_dateFormat) : "",
nickName = v.NickName,
firstName = v.FirstName
}).FirstOrDefault();
}
return(stockInfo);
}
public CommonResponseViewModel UpdateExpense(ExpenseViewModel expenseVM)
{
var responseVM = new CommonResponseViewModel();
try
{
bool isDuplicate = CheckIsDuplicate(expenseVM);
if (isDuplicate)
{
responseVM.message = "Expense Name already exists";
return(responseVM);
}
using (_dbContext = new AccountdbContext())
{
var expenseDBModel = _dbContext.Expenses.Where(e => e.ExpenseId.Equals(expenseVM.id)).FirstOrDefault();
if (expenseDBModel != null)
{
ConstructExpenseDBModel(expenseVM, ref expenseDBModel, true);
_dbContext.Update(expenseDBModel);
_dbContext.SaveChanges();
responseVM.isSuccess = true;
}
}
}
catch (Exception ex)
{
throw ex;
}
return(responseVM);
}
public List <CustomerViewModel> CustomerNames(AutoCompleteModel data)
{
var custList = new List <CustomerViewModel>();
try
{
var customerList = new List <EfDbContext.Customer>();
using (_dbContext = new AccountdbContext())
{
customerList = _dbContext.Customer.Where(e => e.NickName.Contains(data.q)).ToList();
}
if (customerList.Any())
{
foreach (var item in customerList)
{
custList.Add(ConstructCustomerViewModelFromContext(item));
}
}
}
catch (Exception ex)
{
throw ex;
}
return(custList);
}
public List <CustomerViewModel> GetAllCustomers()
{
var custList = new List <CustomerViewModel>();
var dbcustList = new List <EfDbContext.Customer>();
try
{
using (_dbContext = new AccountdbContext())
{
// dbcustList = _dbContext.Customer.ToList();
custList = (from c in _dbContext.Customer
join cd in _dbContext.CustomerDetails on c.CustId equals cd.CustId
select ConstructCustomerViewModelFromContext(c, cd)
).ToList();
}
//if (dbcustList.Any())
//{
// foreach (var item in dbcustList)
// {
// custList.Add(ConstructCustomerViewModelFromContext(item));
// }
//}
}
catch (Exception ex)
{
throw ex;
}
return(custList);
}
public List <VendorViewModel> VendorNames(AutoCompleteModel data)
{
var vendorList = new List <VendorViewModel>();
try
{
var vendors = new List <EfDbContext.Vendor>();
using (_dbContext = new AccountdbContext())
{
vendors = _dbContext.Vendor.Where(e => e.NickName.Contains(data.q)).ToList();
}
if (vendors.Any())
{
foreach (var item in vendors)
{
vendorList.Add(ConstructVendorViewModelFromContext(item));
}
}
}
catch (Exception ex)
{
throw ex;
}
return(vendorList);
}
public CommonResponseViewModel AddExpense(ExpenseViewModel expenseVM)
{
var responseVM = new CommonResponseViewModel();
try
{
var expenseDBModel = new EfDbContext.Expenses();
ConstructExpenseDBModel(expenseVM, ref expenseDBModel);
bool isDuplicate = CheckIsDuplicate(expenseVM);
if (isDuplicate)
{
responseVM.message = "Expense Name already exists";
return(responseVM);
}
using (_dbContext = new AccountdbContext())
{
_dbContext.Expenses.Add(expenseDBModel);
_dbContext.SaveChanges();
responseVM.isSuccess = true;
responseVM.recordId = expenseDBModel.ExpenseId;
}
}
catch (Exception ex)
{
throw ex;
}
return(responseVM);
}
private void AddVendorPaymentToDb(VendorPayments vendorPayment)
{
using (_dbContext = new AccountdbContext())
{
_dbContext.VendorPayments.Add(vendorPayment);
_dbContext.SaveChanges();
}
}
public int StockInCount(StockInViewModel stock)
{
var countOfRecords = 0;
using (_dbContext = new AccountdbContext())
{
countOfRecords = _dbContext.StockIn.Where(e => e.VendorId.Equals(stock.vendorId)).Count();
}
return(countOfRecords);
}
public bool CheckIsDuplicateNickName([FromBody] string data)
{
using (_dbContext = new AccountdbContext())
{
if (_dbContext.StockIn.Any(x => x.LoadName.ToLower() == data.ToLower() && x.IsActive == true))
{
return(true);
}
}
return(false);
}
public CommonResponseViewModel UpdateCustomer(CustomerViewModel customerVM)
{
CommonResponseViewModel response = new CommonResponseViewModel();
try
{
using (_dbContext = new AccountdbContext())
{
var customer = _dbContext.Customer.Where(c => c.CustId.Equals(customerVM.id)).FirstOrDefault();
if (customer != null)
{
customer.FirstName = customerVM.firstName;
customer.MiddleName = customerVM.middleName;
//customer.NickName = customerVM.nickName;
customer.LastName = customerVM.lastName;
customer.Mobile = customerVM.mobile;
customer.ReferredBy = customerVM.referredBy;
customer.CreatedBy = customerVM.createdBy;
customer.ModifiedBy = customerVM.modifiedBy;
customer.ModifiedDate = DateTime.Now;
_dbContext.Update(customer);
var customerDetails = _dbContext.CustomerDetails.Where(c => c.CustId.Equals(customerVM.id)).FirstOrDefault();
if (customerDetails != null)
{
customerDetails.CustId = customerVM.id;
customerDetails.AlternateMobile = customerVM.alternateMobile;
customerDetails.HomePhone = customerVM.homePhone;
customerDetails.OfficePhone = customerVM.officePhone;
customerDetails.Email = customerVM.email;
customerDetails.Address = customerVM.address;
customerDetails.City = customerVM.city;
customerDetails.State = customerVM.state;
customerDetails.ShopName = customerVM.shopName;
customerDetails.ShopLocation = customerVM.shopLocation;
_dbContext.Update(customerDetails);
}
_dbContext.SaveChanges();
response.isSuccess = true;
}
}
}
catch (Exception ex)
{
throw ex;
}
return(response);
}
public CommonResponseViewModel AddVendor(VendorViewModel vendorVM)
{
CommonResponseViewModel response = new CommonResponseViewModel();
var vendor = new EfDbContext.Vendor();
vendor.FirstName = vendorVM.firstName;
vendor.MiddleName = vendorVM.middleName;
vendor.NickName = vendorVM.nickName;
vendor.LastName = vendorVM.lastName;
vendor.MobileNo = vendorVM.mobile;
vendor.ReferredBy = vendorVM.referredBy;
vendor.CreatedBy = vendorVM.createdBy;
vendor.ModifiedBy = vendorVM.modifiedBy;
using (_dbContext = new AccountdbContext())
{
//Save the vendor entity first........
_dbContext.Vendor.Add(vendor);
_dbContext.SaveChanges();
response.isSuccess = true;
//update the vendorid from db to viewModel............................
response.recordId = vendor.VendorId;
vendorVM.id = response.recordId;
EfDbContext.VendorDetails vendorDetails = new EfDbContext.VendorDetails()
{
VendorId = vendorVM.id,
AlternateMobile = vendorVM.alternateMobile,
HomePhone = vendorVM.homePhone,
Email = vendorVM.email,
Address = vendorVM.address,
City = vendorVM.city,
State = vendorVM.state
};
_dbContext.VendorDetails.Add(vendorDetails);
_dbContext.SaveChanges();
////Loop all the address list and update the address in the db....................
//if (vendorVM.VendorAddressList.Any())
//{
// foreach (var item in vendorVM.VendorAddressList)
// {
// _dbContext.VendorDetails.Add(ConstructVendorAddressAsPerContext(item, vendorVM.id));
// }
//}
}
return(response);
}
public CommonResponseViewModel UpdateVendor(VendorViewModel vendorVM)
{
CommonResponseViewModel response = new CommonResponseViewModel();
try
{
using (_dbContext = new AccountdbContext())
{
var vendor = _dbContext.Vendor.Where(v => v.VendorId.Equals(vendorVM.id)).FirstOrDefault();
if (vendor != null)
{
vendor.FirstName = vendorVM.firstName;
vendor.MiddleName = vendorVM.middleName;
//vendor.NickName = vendorVM.nickName;
vendor.LastName = vendorVM.lastName;
vendor.MobileNo = vendorVM.mobile;
vendor.ReferredBy = vendorVM.referredBy;
vendor.CreatedBy = vendorVM.createdBy;
vendor.ModifiedBy = vendorVM.modifiedBy;
vendor.ModifiedDate = DateTime.Now;
_dbContext.Update(vendor);
var vendorDetails = _dbContext.VendorDetails.Where(c => c.VendorId.Equals(vendorVM.id)).FirstOrDefault();
if (vendorDetails != null)
{
vendorDetails.VendorId = vendorVM.id;
vendorDetails.AlternateMobile = vendorVM.alternateMobile;
vendorDetails.HomePhone = vendorVM.homePhone;
vendorDetails.Email = vendorVM.email;
vendorDetails.Address = vendorVM.address;
vendorDetails.City = vendorVM.city;
vendorDetails.State = vendorVM.state;
_dbContext.Update(vendorDetails);
}
_dbContext.SaveChanges();
response.isSuccess = true;
}
}
}
catch (Exception ex)
{
throw ex;
}
return(response);
}
public bool CheckIsDuplicate(ExpenseViewModel expenseVM)
{
bool isDuplicate = false;
try
{
using (_dbContext = new AccountdbContext())
{
isDuplicate = _dbContext.Expenses.Any(x => x.ExpenseName.ToLower() == expenseVM.name.Trim().ToLower() &&
x.ExpenseTypeId == expenseVM.expenseTypeId && x.ExpenseTypeId != expenseVM.id);
}
}
catch (Exception ex)
{
throw ex;
}
return(isDuplicate);
}
public bool CheckIsDuplicateNickName(string data)
{
bool results = false;
try
{
using (_dbContext = new AccountdbContext())
{
results = _dbContext.Vendor.Any(x => x.NickName.ToLower() == data.ToLower() &&
x.IsActive == true);
}
}
catch (Exception)
{
throw;
}
return(results);
}
public List <StockInViewModel> GetActiveStockList()
{
var stockList = new List <StockInViewModel>();
using (_dbContext = new AccountdbContext())
{
stockList = (from s in _dbContext.StockIn
where s.IsActive.Equals(true)
select new StockInViewModel
{
id = s.StockId,
loadName = s.LoadName,
vendorId = s.VendorId,
totalQuantity = s.Quantity
}).ToList();
}
return(stockList);
}
public List <StockInViewModel> GetStockBetweenDates(string startDate, string endDate)
{
var stockList = new List <StockInViewModel>();
using (_dbContext = new AccountdbContext())
{
stockList = (from s in _dbContext.StockIn
where s.CreatedDate >= Convert.ToDateTime(startDate)
where s.CreatedDate <= Convert.ToDateTime(endDate)
select new StockInViewModel
{
id = s.StockId,
loadName = s.LoadName,
vendorId = s.VendorId,
totalQuantity = s.Quantity,
isActive = Convert.ToBoolean(s.IsActive)
}).ToList();
}
return(stockList);
}
public List <ExpenseViewModel> GetAllExpenses()
{
var expenseList = new List <ExpenseViewModel>();
try
{
using (_dbContext = new AccountdbContext())
{
expenseList = (from e in _dbContext.Expenses
join et in _dbContext.ExpenseTypes on e.ExpenseTypeId equals et.ExpenseTypeId
select ConstructExpenseViewModelFromContext(e, et)
).ToList();
}
}
catch (Exception ex)
{
throw ex;
}
return(expenseList);
}
public List <SalesViewModel> LoadNames(AutoCompleteModel data)
{
var SalesList = new List <SalesViewModel>();
try
{
using (_dbContext = new AccountdbContext())
{
SalesList = (from stock in _dbContext.StockIn
from sales in _dbContext.Sales
from vendor in _dbContext.Vendor
from cust in _dbContext.Customer
where stock.LoadName.ToLower().Equals(data.q.ToLower()) &&
stock.StockId.Equals(sales.StockIn) &&
stock.VendorId.Equals(vendor.VendorId) &&
sales.CustId.Equals(cust.CustId)
select new SalesViewModel
{
VendorId = vendor.VendorId,
StockInId = stock.StockId,
CustomerId = cust.CustId,
CustomerName = HelperUtility.GetCustName(cust),
LoadName = stock.LoadName,
Id = sales.SalesId,
Quantity = sales.Quantity,
Total = sales.Total,
Price = sales.Price,
CreatedDate = sales.CreatedDate.ToString(),
VendorName = HelperUtility.GetVendorName(vendor),
}).ToList();
}
}
catch (Exception ex)
{
throw ex;
}
return(SalesList);
}
public List <VendorViewModel> GetAllVendors()
{
var vendorList = new List <VendorViewModel>();
var dbVendorList = new List <EfDbContext.Vendor>();
try
{
using (_dbContext = new AccountdbContext())
{
vendorList = (from c in _dbContext.Vendor
join cd in _dbContext.VendorDetails on c.VendorId equals cd.VendorId
select ConstructVendorViewModelFromContext(c, cd)
).ToList();
}
}
catch (Exception ex)
{
throw ex;
}
return(vendorList);
}
public bool DeleteCustomerById(int id)
{
bool result = false;
try
{
using (_dbContext = new AccountdbContext())
{
var cust = _dbContext.Customer.Where(e => e.CustId.Equals(id)).FirstOrDefault();
cust.IsActive = false;
_dbContext.Customer.Update(cust);
_dbContext.SaveChanges();
result = true;
}
}
catch (Exception ex)
{
throw ex;
}
return(result);
}
public bool DeleteVendorById(int id)
{
bool result = false;
try
{
using (_dbContext = new AccountdbContext())
{
var vendor = _dbContext.Vendor.Where(e => e.VendorId.Equals(id)).FirstOrDefault();
vendor.IsActive = false;
_dbContext.Vendor.Update(vendor);
_dbContext.SaveChanges();
}
}
catch (Exception ex)
{
throw ex;
}
return(result);
}
public ExpenseViewModel GetExpenseById(int id)
{
var expenseVM = new ExpenseViewModel();
try
{
using (_dbContext = new AccountdbContext())
{
expenseVM = (from e in _dbContext.Expenses
join et in _dbContext.ExpenseTypes on e.ExpenseTypeId equals et.ExpenseTypeId
where e.ExpenseId.Equals(id)
select ConstructExpenseViewModelFromContext(e, et)
).FirstOrDefault();
}
}
catch (Exception ex)
{
throw ex;
}
return(expenseVM);
}
public bool DeleteStockById(int id)
{
bool result = false;
try
{
using (_dbContext = new AccountdbContext())
{
var stockInfo = _dbContext.StockIn.Where(e => e.StockId.Equals(id)).FirstOrDefault();
stockInfo.IsActive = false;
_dbContext.StockIn.Update(stockInfo);
_dbContext.SaveChanges();
result = true;
}
}
catch (Exception ex)
{
throw ex;
}
return(result);
}
public VendorViewModel GetVendorById(int id)
{
var vendorViewModel = new VendorViewModel();
var cust = new EfDbContext.Vendor();
try
{
using (_dbContext = new AccountdbContext())
{
vendorViewModel = (from v in _dbContext.Vendor
join vd in _dbContext.VendorDetails on v.VendorId equals vd.VendorId
where v.VendorId == id
select ConstructVendorViewModelFromContext(v, vd)
).FirstOrDefault();
}
}
catch (Exception ex)
{
throw ex;
}
return(vendorViewModel);
}
public bool DeleteExpenseById(int id)
{
bool result = false;
try
{
using (_dbContext = new AccountdbContext())
{
var expense = _dbContext.Expenses.Where(e => e.ExpenseId.Equals(id)).FirstOrDefault();
//expense.IsActive = false;
//_dbContext.Expenses.Update(expense);
_dbContext.Expenses.Remove(expense);
_dbContext.SaveChanges();
result = true;
}
}
catch (Exception ex)
{
throw ex;
}
return(result);
}
public CommonResponseViewModel AddStock(StockInViewModel stockInVM)
{
CommonResponseViewModel response = new CommonResponseViewModel();
try
{
using (_dbContext = new AccountdbContext())
{
var dbStockIn = ConstructStockInAddressAsPerContext(stockInVM);
dbStockIn.CreatedDate = stockInVM.createdDate.HasValue ? stockInVM.createdDate.Value : DateTime.Now;
_dbContext.StockIn.Add(dbStockIn);
_dbContext.SaveChanges();
response.recordId = dbStockIn.StockId;
response.isSuccess = true;
}
}
catch (Exception ex)
{
throw ex;
}
return(response);
}
public List <ExpenseTypeViewModel> GetExpenseTypes()
{
var expenseTypesVM = new List <ExpenseTypeViewModel>();
try
{
using (_dbContext = new AccountdbContext())
{
expenseTypesVM = (from c in _dbContext.ExpenseTypes
select new ExpenseTypeViewModel
{
id = c.ExpenseTypeId,
name = c.ExpenseTypeName
}
).ToList();
}
}
catch (Exception ex)
{
throw ex;
}
return(expenseTypesVM);
}
