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);
}
