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); }
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 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 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 CommonResponseViewModel SaveExpensesCategory(ExpensesCategoryViewModel expensesCategoryVM) { CommonResponseViewModel response = new CommonResponseViewModel(); List <ExpensesCategoryViewModel> expensesCategories = GetExpensesCategories(); bool isDuplicate = CheckIsDuplicate(expensesCategoryVM); if (isDuplicate) { response.message = "Expenses Category Name already exists"; return(response); } if (expensesCategoryVM.id <= 0) { // insert expensesCategoryVM.id = expensesCategories[expensesCategories.Count - 1].id + 1; expensesCategoryVM.expensesTypeName = ((ExpensesTypeEnum)expensesCategoryVM.expensesTypeId).Description(); expensesCategories.Add(expensesCategoryVM); response.isSuccess = true; response.recordId = expensesCategoryVM.id; } else { // update var expensesCategory = expensesCategories.Where(x => x.id == expensesCategoryVM.id).FirstOrDefault(); if (expensesCategory != null) { int index = expensesCategories.FindIndex(x => x.id == expensesCategoryVM.id); expensesCategories[index] = expensesCategoryVM; response.isSuccess = true; response.recordId = expensesCategoryVM.id; } } if (response.isSuccess) { HttpContext.Current.Cache.Remove(_cacheName); HttpContext.Current.Cache.Insert(_cacheName, expensesCategories); } return(response); }
public CommonResponseViewModel SaveCustomer(CustomerViewModel customerVM) { CommonResponseViewModel response = new CommonResponseViewModel(); List <CustomerViewModel> customers = GetCustomers(); if (customerVM.id <= 0) { // insert customerVM.id = customers[customers.Count - 1].id + 1; customers.Add(customerVM); response.isSuccess = true; response.recordId = customerVM.id; } else { // update var customer = customers.Where(x => x.id == customerVM.id).FirstOrDefault(); if (customer != null) { int index = customers.FindIndex(x => x.id == customerVM.id); customers[index] = customer; response.isSuccess = true; response.recordId = customerVM.id; } } if (response.isSuccess) { HttpContext.Current.Cache.Remove("Customers"); HttpContext.Current.Cache.Insert("Customers", customers); } return(response); }
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 CommonResponseViewModel SaveVendor(VendorViewModel vendorVM) { CommonResponseViewModel response = new CommonResponseViewModel(); List <VendorViewModel> vendors = GetVendors(); if (vendorVM.id <= 0) { // insert vendorVM.id = vendors[vendors.Count - 1].id + 1; vendors.Add(vendorVM); response.isSuccess = true; response.recordId = vendorVM.id; } else { // update var vendor = vendors.Where(x => x.id == vendorVM.id).FirstOrDefault(); if (vendor != null) { int index = vendors.FindIndex(x => x.id == vendorVM.id); vendors[index] = vendorVM; response.isSuccess = true; response.recordId = vendorVM.id; } } if (response.isSuccess) { HttpContext.Current.Cache.Remove("Vendors"); HttpContext.Current.Cache.Insert("Vendors", vendors); } return(response); }
public CommonResponseViewModel AddCustomer(CustomerViewModel customerVM) { CommonResponseViewModel response = new CommonResponseViewModel(); try { var cust = new EfDbContext.Customer(); cust.FirstName = customerVM.firstName; cust.MiddleName = customerVM.middleName; cust.NickName = customerVM.nickName; cust.LastName = customerVM.lastName; cust.Mobile = customerVM.mobile; cust.ReferredBy = customerVM.referredBy; cust.CreatedBy = customerVM.createdBy; cust.ModifiedBy = customerVM.modifiedBy; using (_dbContext = new AccountdbContext()) { //Save the customer entity first........ _dbContext.Customer.Add(cust); _dbContext.SaveChanges(); response.isSuccess = true; //update the custid from db to viewModel............................ response.recordId = cust.CustId; customerVM.id = response.recordId; EfDbContext.CustomerDetails customerDetails = new EfDbContext.CustomerDetails() { CustId = customerVM.id, AlternateMobile = customerVM.alternateMobile, HomePhone = customerVM.homePhone, OfficePhone = customerVM.officePhone, Email = customerVM.email, Address = customerVM.address, City = customerVM.city, State = customerVM.state, ShopName = customerVM.shopName, ShopLocation = customerVM.shopLocation }; _dbContext.CustomerDetails.Add(customerDetails); _dbContext.SaveChanges(); //Loop all the address list and update the address in the db.................... //if (customerVM.CustAddressList != null && customerVM.CustAddressList.Any()) //{ // foreach (var item in customerVM.CustAddressList) // { // _dbContext.CustomerDetails.Add(ConstructCustAddressAsPerContext(item, customerVM.id)); // } //} } } catch (Exception ex) { throw ex; } return(response); }