public string UpdateCustomerAccount(Customer _customer) { string updatedREsult = string.Empty; if (_customer != null) { using (ELFILOEntities _enties = new ELFILOEntities()) { var _cust = _enties.Customer.Where(x => x.accountNumber == _customer.accountNumber).FirstOrDefault(); _cust.customerType = _customer.customerType; _cust.firstName = _customer.firstName; _cust.lastName = _customer.lastName; _cust.terms = _customer.terms; _cust.address = _customer.address; _cust.contactNumber = _customer.contactNumber; if (_cust != null) { _enties.Customer.AddOrUpdate(_cust); } _enties.SaveChanges(); updatedREsult = "Successfully Updated"; } } else { updatedREsult = "Error While updating"; } return(updatedREsult); }
/// <summary> /// Create/Add New Customer /// </summary> /// <param name="_customer"></param> /// <returns></returns> public string AddCustomer(Customer _customer) { //check if its not null if (_customer != null) { using (ELFILOEntities _entiies = new ELFILOEntities()) { //add the passed object. Customer customer = new Customer(); customer.accountCode = _customer.accountCode; customer.accountNumber = _entiies.Database.SqlQuery <string>("EXEC GenerateCCAnumbers").FirstOrDefault(); customer.customerType = _customer.customerType; customer.terms = _customer.terms; customer.firstName = _customer.firstName; customer.lastName = _customer.lastName; customer.address = _customer.address; customer.contactNumber = _customer.contactNumber; customer.date_added = DateTime.Today; if (customer != null) { _entiies.Customer.Add(customer); } _entiies.SaveChanges(); //save data return("Customer Successfully Added"); } } else { return("Error While Inserting..."); } }
/// <summary> /// Get List of Categories /// </summary> /// <returns></returns> public JsonResult ListOfCategories() { using (ELFILOEntities _entities = new ELFILOEntities()) { var _result = _entities.Category.Select(x => x.itemCategory).ToList(); return(Json(new { data = _result }, JsonRequestBehavior.AllowGet)); } }
/// <summary> /// Get All Transaction Details /// per account number /// </summary> /// <param name="accountNumber"></param> /// <returns></returns> public JsonResult TransactionDocument(string accountNumber) { using (ELFILOEntities _entities = new ELFILOEntities()) { var _result = _entities.Transaction.Where(x => x.accountNumber == accountNumber).ToList(); return(Json(new { data = _result }, JsonRequestBehavior.AllowGet)); } }
/// <summary> /// Get All List of Category /// </summary> /// <returns></returns> public JsonResult GetAllCategoryList() { using (ELFILOEntities _entites = new ELFILOEntities()) { List <Category> categories = _entites.Category.ToList(); return(Json(new { data = categories }, JsonRequestBehavior.AllowGet)); } }
/// <summary> /// Get All List of Items /// </summary> /// <returns></returns> public JsonResult GetAllItem() { using (ELFILOEntities _entities = new ELFILOEntities()) { List <Models.Inventory> _cusomter = _entities.Inventory.ToList(); return(Json(new { data = _cusomter }, JsonRequestBehavior.AllowGet)); } }
/// <summary> /// Get All List of Measurement /// </summary> /// <returns></returns> public JsonResult GetListOfMeasurement() { using (ELFILOEntities _entities = new ELFILOEntities()) { var measurement = _entities.Measurement.ToList(); return(Json(new { data = measurement }, JsonRequestBehavior.AllowGet)); } }
/// <summary> /// Get Single Account /// </summary> /// <param name="accountNumber"></param> /// <returns></returns> public JsonResult GetSingleCustomerAccount(string accountNumber) { using (ELFILOEntities _entites = new ELFILOEntities()) { var _result = _entites.Customer.Where(x => x.accountNumber == accountNumber).FirstOrDefault(); return(Json(_result, JsonRequestBehavior.AllowGet)); } }
/// <summary> /// Getl All Customer /// </summary> /// <returns></returns> public JsonResult GetAllCustomer() { using (ELFILOEntities _entities = new ELFILOEntities()) { List <Customer> _cusomter = _entities.Customer.ToList(); return(Json(new { data = _cusomter }, JsonRequestBehavior.AllowGet)); } }
/// <summary> /// Filter Inventory Items /// By Category /// </summary> /// <param name="category"></param> /// <returns></returns> public JsonResult FilterItemByCategory(string category) { using (ELFILOEntities _entities = new ELFILOEntities()) { List <string> inventory = new List <string>(); var _result = _entities.Inventory.Where(x => x.itemCategory == category).Select(x => x.itemName).ToList(); if (_result != null) { inventory = _result; } return(Json(new { data = inventory }, JsonRequestBehavior.AllowGet)); } }
/// <summary> /// Get Item Details /// </summary> /// <param name="itemName"></param> /// <returns></returns> public JsonResult GetItemDetails(string itemName) { using (ELFILOEntities _entites = new ELFILOEntities()) { Models.Inventory inventoryDetails = new Models.Inventory(); var _result = _entites.Inventory.Where(x => x.itemName == itemName).FirstOrDefault(); if (_result != null) { inventoryDetails = _result; } return(Json(new { data = inventoryDetails }, JsonRequestBehavior.AllowGet)); } }
/// <summary> /// Add New Cagories /// </summary> /// <param name="category"></param> /// <returns></returns> public string AddItemCategory(Category category) { if (category != null) { using (ELFILOEntities _entities = new ELFILOEntities()) { _entities.Category.Add(category); _entities.SaveChanges(); return("Item Category Successfully Added"); } } else { return("Error while Inserting"); } }
/// <summary> /// Delette Customer Account /// </summary> /// <param name="_customer"></param> /// <returns></returns> public string DeleteCustomer(string accountNumber) { using (ELFILOEntities _entites = new ELFILOEntities()) { var result = _entites.Customer.Where(x => x.accountNumber == accountNumber).FirstOrDefault(); if (result != null) { _entites.Customer.Remove(result); _entites.SaveChanges(); return("Successfully Deleted"); } else { return("Unable to delete"); } } }
/// <summary> /// Add Item in Inventory /// </summary> /// <param name="inventory"></param> /// <returns></returns> public string AddIventoryItem(Models.Inventory inventory) { //check if its not null if (inventory != null) { using (ELFILOEntities _entiies = new ELFILOEntities()) { //add the passed object. _entiies.Inventory.Add(inventory); _entiies.SaveChanges(); return("Customer Successfully Added"); } } else { return("Error While Inserting"); } }
/// <summary> /// Account Transactions /// </summary> /// <param name="transaction"></param> /// <returns></returns> public string AddTransaction(Transaction transaction) { string _result = string.Empty; if (transaction != null) { using (ELFILOEntities _entities = new ELFILOEntities()) { _entities.Transaction.Add(transaction); _entities.SaveChanges(); _result = "Successfully Added"; } } else { _result = "Error Occured while adding"; } return(_result); }