////insert and update data into database
//public JsonResult EditCustomerRecord(CustomerViewModel model)
//{
// var result = false;
// try
// {
// //if id >0, update
// if (model.Id > 0)
// {
// Customer cust = db.Customers.SingleOrDefault(x => x.Id == model.Id);
// cust.Name = model.Name;
// cust.Address = model.Address;
// db.SaveChanges();
// result = true;
// }
// else
// {
// //insert
// //check if the product is already existing
// Customer cust = new Customer();
// cust.Name = model.Name;
// cust.Address = model.Address;
// db.Customers.Add(cust);
// db.SaveChanges();
// result = true;
// }
// }
// catch (Exception ex)
// {
// throw ex;
// }
// return Json(result, JsonRequestBehavior.AllowGet);
//}
//insert and update data into database
public JsonResult SaveDataInDatabase(CustomerViewModel model)
{
var result = false;
try
{
//if id >0, update
if (model.Id > 0)
{
Customer cust = db.Customers.SingleOrDefault(x => x.Id == model.Id);
////check if the customer name is already existing
Customer custvali = db.Customers.SingleOrDefault(x => x.Name == model.Name && x.Id != model.Id);
if (custvali == null)
{
cust.Name = model.Name;
cust.Address = model.Address;
db.SaveChanges();
result = true;
return(Json(result, JsonRequestBehavior.AllowGet));
}
else
{
return(Json("no", JsonRequestBehavior.AllowGet));
}
}
else
{
// insert
//check if the customer is already existing
Customer custvali = db.Customers.SingleOrDefault(x => x.Name == model.Name);
if (custvali == null)
{
Customer cust = new Customer();
cust.Name = model.Name;
cust.Address = model.Address;
db.Customers.Add(cust);
db.SaveChanges();
result = true;
return(Json(result, JsonRequestBehavior.AllowGet));
}
else
{
return(Json("no", JsonRequestBehavior.AllowGet));
}
}
}
catch (Exception ex)
{
throw ex;
}
}
//insert and update data into database
public JsonResult SaveDataInDatabase(ProductViewModel model)
{
var result = false;
try
{
//if id >0, update
if (model.Id > 0)
{
Product pro = db.Products.SingleOrDefault(x => x.Id == model.Id);
//check if the product name is already existing
Product provali = db.Products.SingleOrDefault(x => x.Name == model.Name && x.Id != model.Id);
if (provali == null)
{
pro.Name = model.Name;
pro.Price = model.Price;
db.SaveChanges();
result = true;
return(Json(result, JsonRequestBehavior.AllowGet));
}
else
{
return(Json("no", JsonRequestBehavior.AllowGet));
}
}
else
{
//insert
//check if the product is already existing
Product provali = db.Products.SingleOrDefault(x => x.Name == model.Name);
if (provali == null)
{
Product pro = new Product();
pro.Name = model.Name;
pro.Price = model.Price;
db.Products.Add(pro);
db.SaveChanges();
result = true;
return(Json(result, JsonRequestBehavior.AllowGet));
}
else
{
return(Json("no", JsonRequestBehavior.AllowGet));
}
}
}
catch (Exception ex)
{
throw ex;
}
}
//insert and update data into database
public JsonResult SaveDataInDatabase(SaleViewModel model)
{
var result = false;
try
{
//check if the input is null, return "re"
if (model.ProductId == null || model.CustomerId == null || model.StoreId == null || model.DataSold == null)
{
return(Json("re", JsonRequestBehavior.AllowGet));
}
else
{
//if id >0, update
if (model.Id > 0)
{
ProductSold prosold = db.ProductSolds.SingleOrDefault(x => x.Id == model.Id);
prosold.ProductId = model.ProductId;
prosold.CustomerId = model.CustomerId;
prosold.StoreId = model.StoreId;
prosold.DataSold = model.DataSold;
db.SaveChanges();
result = true;
}
else
{
// insert
//check if the customer is already existing
ProductSold prosold = new ProductSold();
prosold.ProductId = model.ProductId;
prosold.CustomerId = model.CustomerId;
prosold.StoreId = model.StoreId;
prosold.DataSold = model.DataSold;
db.ProductSolds.Add(prosold);
db.SaveChanges();
result = true;
}
}
return(Json(result, JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
throw ex;
}
}
//Create customer
public JsonResult CreateSale(Sale sale)
{
try
{
db.Sales.Add(sale);
db.SaveChanges();
}
catch (Exception e)
{
Console.Write("Exception Occured /n {0}", e.Data);
return(new JsonResult {
Data = "Create Sales Failed", JsonRequestBehavior = JsonRequestBehavior.AllowGet
});
}
return(new JsonResult {
Data = "Sale created", JsonRequestBehavior = JsonRequestBehavior.AllowGet
});
}
public ActionResult AddCustomer(Customer customer)
{
using (var db = new OnboardingEntities())
{
db.Customers.Add(customer);
db.SaveChanges();
return(this.Json(customer));
}
}
public JsonResult CreateProduct(Product product)
{
try
{
db.Products.Add(product);
db.SaveChanges();
}
catch (Exception e)
{
Console.Write("Exception Occured /n {0}", e.Data);
return(new JsonResult {
Data = "Create Product Failed", JsonRequestBehavior = JsonRequestBehavior.AllowGet
});
}
return(new JsonResult {
Data = "Product created", JsonRequestBehavior = JsonRequestBehavior.AllowGet
});
}
public JsonResult CreateCustomer(Customer customer)
{
try
{
db.Customers.Add(customer);
db.SaveChanges();
}
catch (Exception e)
{
Console.Write("Exception Occured /n {0}", e.Data);
return(new JsonResult {
Data = "Create Customer Failed", JsonRequestBehavior = JsonRequestBehavior.AllowGet
});
}
return(new JsonResult {
Data = "Customer created", JsonRequestBehavior = JsonRequestBehavior.AllowGet
});
}
public ActionResult DeleteCustomer(int Id)
{
using (var db = new OnboardingEntities())
{
var delete = db.Customers.Find(Id);
db.Customers.Remove(delete);
db.SaveChanges();
return(Json(new { success = true }));
}
}
public ActionResult DeleteSale(int Id)
{
using (var db = new OnboardingEntities())
{
var deleteSale = db.ProductSolds.Find(Id);
db.ProductSolds.Remove(deleteSale);
db.SaveChanges();
return(Json(new { success = true }, JsonRequestBehavior.AllowGet));
}
}
//delete Customer
public JsonResult deleteCustomer(int Id)
{
using (var db = new OnboardingEntities())
{
var delPerson = db.People.SingleOrDefault(id => id.Id == Id);
db.People.Remove(delPerson);
db.SaveChanges();
return(Json(new { Success = true }, JsonRequestBehavior.AllowGet));
}
}
public ActionResult UpdateSales(ProductSold sales)
{
using (var db = new OnboardingEntities())
{
var editSales = db.ProductSolds.SingleOrDefault(x => x.Id == sales.Id);
editSales.CustomerId = sales.CustomerId;
editSales.ProductId = sales.ProductId;
editSales.StoreId = sales.StoreId;
editSales.DateSold = sales.DateSold;
db.SaveChanges();
return(Json(new { Success = true }, JsonRequestBehavior.AllowGet));
}
}
public ActionResult AddProductSold(ProductSold productSold)
{
using (var db = new OnboardingEntities())
{
var proSold = new ProductSold
{
CustomerId = productSold.CustomerId,
ProductId = productSold.ProductId,
StoreId = productSold.StoreId,
DateSold = productSold.DateSold,
};
db.ProductSolds.Add(proSold);
db.SaveChanges();
return(Json(new { Success = true }, JsonRequestBehavior.AllowGet));
}
}
public ActionResult EditCustomer(Customer customer)
{
using (var db = new OnboardingEntities())
{
var editCustomer = db.Customers.SingleOrDefault(x => x.Id == customer.Id);
editCustomer.Name = customer.Name;
editCustomer.Address = customer.Address;
try
{
db.SaveChanges();
return(Json(new { success = true }));
}
catch (Exception ex)
{
return(Json(new { success = false }));
}
}
}
//edit Customer
public JsonResult editCustomer(CustomerModel model)
{
using (var db = new OnboardingEntities())
{
var getPeople = db.People.Find(model.Id);
// db.Configuration.LazyLoadingEnabled = false;
getPeople.Name = model.Name;
getPeople.Address1 = model.Address1;
getPeople.Address2 = model.Address2;
getPeople.Town_City = model.Town_City;
try
{
db.SaveChanges();
} catch (Exception e)
{
return(Json(new { Success = false, ErrorMsg = e.InnerException.InnerException.Message }, JsonRequestBehavior.AllowGet));
}
return(Json(new { Success = true }, JsonRequestBehavior.AllowGet));
}
}