/// <summary>
/// Deletes the product depending if the productID already exists
/// </summary>
/// <param name="productID">the product that is being deleted</param>
/// <returns>list of products</returns>
public void DeleteProduct(int productID)
{
try
{
using (ProductDBEntities context = new ProductDBEntities())
{
bool isProduct = IsProductID(productID);
if (isProduct == true)
{
// find the product removing them
tblProduct productToDelete = (from r in context.tblProducts where r.ProductID == productID select r).First();
context.tblProducts.Remove(productToDelete);
context.SaveChanges();
}
else
{
MessageBox.Show("Cannot delete the product");
}
}
}
catch (Exception ex)
{
Debug.WriteLine("Exception" + ex.Message.ToString());
}
}
public Product Save(Product model)
{
using (var db = new ProductDBEntities())
{
if (model.id != 0)
{
var obj1 = db.Products.SingleOrDefault(o => o.id == model.id);
obj1.name = model.name;
obj1.category = model.category;
obj1.price = model.price;
db.SaveChanges();
}
else
{
var obj2 = new Products();
obj2.name = model.name;
obj2.category = model.category;
obj2.price = model.price;
db.Products.Add(obj2);
model.id = obj2.id;
db.SaveChanges();
}
return(model);
}
}
/// <summary>
/// Stores a product
/// </summary>
/// <param name="product">the product that is stored</param>
/// <returns>stored product</returns>
public tblProduct StoreProduct(tblProduct product)
{
if (TotalQuantity() + product.Quantity <= 100)
{
try
{
using (ProductDBEntities context = new ProductDBEntities())
{
tblProduct productToStore = (from ss in context.tblProducts where ss.ProductID == product.ProductID select ss).First();
productToStore.Stored = true;
context.SaveChanges();
return(product);
}
}
catch (Exception ex)
{
Debug.WriteLine("Exception" + ex.Message.ToString());
return(null);
}
}
else
{
return(product);
}
}
public IList <Product> List()
{
using (var db = new ProductDBEntities())
{
return(db.Products.ToList().Select(o => ConvertToModel(o)).ToList());
}
}
public JsonResult LoginUser(LoginViewModel model)
{
ProductDBEntities db = new ProductDBEntities();
User user = db.Users.SingleOrDefault(x => x.Username == model.Username && x.Password == model.Password);
string result = "fail";
if (user != null)
{
Session["UserId"] = user.UserId;
Session["UserName"] = user.Username;
Session["RoleId"] = user.RoleId;
if (user.RoleId == 3)
{
result = "User";
}
else if (user.RoleId == 2)
{
result = "Manager";
}
else if (user.RoleId == 1)
{
result = "Admin";
}
}
return(Json(result, JsonRequestBehavior.AllowGet));
}
public HttpResponseMessage Get()
{
using (ProductDBEntities entities = new ProductDBEntities())
{
var message = Request.CreateResponse(HttpStatusCode.OK, entities.Products.ToList());
return(message);
}
}
public Product Get(int id)
{
using (var db = new ProductDBEntities())
{
var obj = db.Products.SingleOrDefault(o => o.id == id);
return(ConvertToModel(obj));
}
}
public void Delete(int id)
{
using (var db = new ProductDBEntities())
{
var obj = db.Products.SingleOrDefault(o => o.id == id);
db.Products.Remove(obj);
db.SaveChanges();
}
}
public ActionResult Exec()
{
ProductDBEntities db = new ProductDBEntities();
List <Product> list = db.Products.ToList();
ViewBag.ProductList = list;
return(View());
}
public IHttpActionResult AddProduct(ProductModel objProductModel)
{
objProductDBEntities = new ProductDBEntities();
Product objProduct = new Product();
objProduct.Category = objProductModel.Category;
objProduct.Code = objProductModel.Code;
objProduct.Name = objProductModel.Name;
objProduct.StockQty = objProductModel.StockQty;
objProduct.UnitPrice = objProductModel.UnitPrice;
objProductDBEntities.Products.Add(objProduct);
objProductDBEntities.SaveChanges();
return(Ok("Product is Added.."));
}
public ActionResult GetSearchRecord(string SearchText)
{
ProductDBEntities db = new ProductDBEntities();
List <ProductViewModel> listProd = db.Products.Where(
x => x.ProductClass.Contains(SearchText)).Select(x => new ProductViewModel
{
ProductID = x.ProductID,
ProductClass = x.ProductClass,
ProductModel = x.ProductModel,
Price = x.Price,
Supplier = x.Supplier
}).ToList();
return(PartialView("SearchPartial", listProd));
}
public IHttpActionResult GetProduct()
{
objProductDBEntities = new ProductDBEntities();
List <ProductModel> listOfProductModel = (from objProduct in objProductDBEntities.Products
select new ProductModel
{
Category = objProduct.Category,
Code = objProduct.Code,
Name = objProduct.Name,
ProductID = objProduct.ProductID,
StockQty = objProduct.StockQty,
UnitPrice = objProduct.UnitPrice
}).ToList();
return(Ok(listOfProductModel));
}
public ActionResult RegisterUser(RegistrationViewModel model)
{
ProductDBEntities db = new ProductDBEntities();
User user = new User()
{
Username = model.Username,
Password = model.Password,
RoleId = 3
};
db.Users.Add(user);
db.SaveChanges();
return(View());
}
public HttpResponseMessage Get(int id)
{
using (ProductDBEntities entities = new ProductDBEntities())
{
var entity = entities.Products.FirstOrDefault(x => x.ID == id);
if (entity != null)
{
var message = Request.CreateResponse(HttpStatusCode.OK, entity);
return(message);
}
else
{
return(Request.CreateErrorResponse(HttpStatusCode.NotFound,
String.Format("Product with ID = {0} not found", id)));
}
}
}
/// <summary>
/// Gets all information about products
/// </summary>
/// <returns>a list of found products</returns>
public List <tblProduct> GetAllProducts()
{
try
{
using (ProductDBEntities context = new ProductDBEntities())
{
List <tblProduct> list = new List <tblProduct>();
list = (from x in context.tblProducts select x).ToList();
OnNotification = logger.WriteToFile;
return(list);
}
}
catch (Exception ex)
{
Debug.WriteLine("Exception" + ex.Message.ToString());
return(null);
}
}
/// <summary>
/// Creates or edits a product
/// </summary>
/// <param name="product">the product that is added</param>
/// <returns>a new or edited product</returns>
public tblProduct AddProduct(tblProduct product)
{
try
{
using (ProductDBEntities context = new ProductDBEntities())
{
if (product.ProductID == 0)
{
tblProduct newProduct = new tblProduct
{
ProductName = product.ProductName,
ProductCode = product.ProductCode,
Quantity = product.Quantity,
Price = product.Price,
Stored = false
};
context.tblProducts.Add(newProduct);
context.SaveChanges();
product.ProductID = newProduct.ProductID;
return(product);
}
else
{
tblProduct productToEdit = (from ss in context.tblProducts where ss.ProductID == product.ProductID select ss).First();
productToEdit.ProductName = product.ProductName;
productToEdit.ProductCode = product.ProductCode;
productToEdit.Quantity = product.Quantity;
productToEdit.Price = product.Price;
productToEdit.Stored = product.Stored;
productToEdit.ProductID = product.ProductID;
context.SaveChanges();
return(product);
}
}
}
catch (Exception ex)
{
Debug.WriteLine("Exception" + ex.Message.ToString());
return(null);
}
}
public ActionResult DelSelPrd(string[] prdids)
{
int[] getid = null;
if (prdids != null)
{
getid = new int[prdids.Length];
int j = 0;
foreach (string i in prdids)
{
int.TryParse(i, out getid[j++]);
}
List <tblProduct> getprdids = new List <tblProduct>();
ProductDBEntities pd = new ProductDBEntities();
getprdids = pd.tblProducts.Where(x => getid.Contains(x.Id)).ToList();
foreach (var s in getprdids)
{
pd.tblProducts.Remove(s);
}
pd.SaveChanges();
}
return(RedirectToAction("ProductList"));
}
/// <summary>
/// Search if product with that ID exists in the product table
/// </summary>
/// <param name="productID">Takes the product id that we want to search for</param>
/// <returns>True if the product exists</returns>
public bool IsProductID(int productID)
{
try
{
using (ProductDBEntities context = new ProductDBEntities())
{
int product = (from x in context.tblProducts where x.ProductID == productID select x.ProductID).FirstOrDefault();
if (product != 0)
{
return(true);
}
else
{
return(false);
}
}
}
catch (Exception ex)
{
Debug.WriteLine("Exception " + ex.Message.ToString());
return(false);
}
}
// Constructor
public ProductController()
{
// create instance of an object
dbContext = new ProductDBEntities();
}
public ProductsController()
{
_context = new ProductDBEntities();
}
