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);
}
}
public IHttpActionResult PutProduct(int id, Product product)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != product.productId)
{
return(BadRequest());
}
db.Entry(product).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!ProductExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
public ActionResult AddOrder(int id)
{
try
{
Orders order = new Orders();
order.ProductID = id;
order.OrderTime = DateTime.Now;
order.IsStored = false;
_db.Orders.Add(order);
_db.SaveChanges();
OrderStatus os = new OrderStatus();
os.OrderID = order.OrderID;
os.Status = true;
_db.OrderStatus.Add(os);
_db.SaveChanges();
ViewBag.Message = "<div class='alert alert-success'><button type='button'class='close'data-dismiss='alert'>×</button><strong>Success!</strong>Ordered</div>";
}
catch
{
ViewBag.Message = "<div class='alert alert-alert'><button type='button'class='close'data-dismiss='alert'>×</button><strong>Error!</strong> Error.</div><br>";
}
return(RedirectToAction("OrderProduct", "Order"));
}
public ActionResult Add(Products product)
{
try
{
if (ModelState.IsValid)
{
if (product != null)
{
var checkProduct = _db.Products.Where(p => p.IsActive && p.IsDeleted == false).FirstOrDefault(p => p.ProductName == product.ProductName);
if (checkProduct != null)
{
ViewBag.Message =
"<div class='alert alert-danger'><button type='button'class='close'data-dismiss='alert'>×</button><strong>ERROR!</strong> Product has already exist!</div>";
return(View(product));
}
product.IsActive = true;
product.IsDeleted = false;
_db.Products.Add(product);
_db.SaveChanges();
ViewBag.Message =
"<div class='alert alert-success'><button type='button'class='close'data-dismiss='alert'>×</button><strong>SUCCESS!</strong> Product has succesfully added</div>";
}
}
return(View(product));
}
catch
{
ViewBag.Message = "<div class='alert alert-alert'><button type='button'class='close'data-dismiss='alert'>×</button><strong>ERROR!</strong> Error.</div><br>";
}
return(View());
}
public ActionResult Create(product rec)
{
try
{
if (ModelState.IsValid)
{
ProductTbl ptbl = new ProductTbl();
colorDataDropdown();
var CheckName = entity.ProductTbls.Any(p => p.ProductName == rec.productName);
if (CheckName == true)
{
TempData["already"] = "Product Name is Already Exist in Database..";
return(View());
}
ptbl.ProductName = rec.productName;
ptbl.Price = rec.Price;
ptbl.Quantity = rec.Quantity;
ptbl.IsGstApplicable = rec.IsGSTApplicable;
ptbl.PurchaseDate = Convert.ToDateTime(rec.Purchase_Date);
ptbl.ExpiryDate = Convert.ToDateTime(rec.Expiry_Date);
ptbl.Color = rec.ColorID;
entity.ProductTbls.Add(ptbl);
entity.SaveChanges();
TempData["save"] = "Record Inserted Successfully..";
return(RedirectToAction("Index"));
}
return(View());
}
catch (Exception e)
{
ModelState.AddModelError("", e.Message);
return(View());
}
}
public IHttpActionResult PutCategory(int id, Category category)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != category.categoryId)
{
return(BadRequest());
}
db.Entry(category).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!CategoryExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
public TblProductList Add(TblProductList item)
{
if (item == null)
{
throw new ArgumentNullException("item");
}
// TO DO : Code to save record into database
ProductDB.TblProductLists.Add(item);
ProductDB.SaveChanges();
return(item);
}
public HttpResponseMessage Post([FromBody] Product product)
{
try
{
_context.Products.Add(product);
_context.SaveChanges();
var message = Request.CreateResponse(HttpStatusCode.Created, product);
message.Headers.Location = new Uri(Request.RequestUri + product.ID.ToString());
return(message);
}
catch (Exception ex)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex));
}
}
/// <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);
}
}
/// <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 HttpResponseMessage SaveProduct(tblProduct asproduct)
{
int result = 0;
try
{
dbContext.tblProducts.Add(asproduct);
dbContext.SaveChanges();
result = 1;
}
catch (Exception e)
{
result = 0;
}
return(Request.CreateResponse(HttpStatusCode.OK, result));
}
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();
}
}
/// <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 AddProduct(HttpPostedFileBase file, HttpPostedFileBase file1, tblProduct insertprd)
{
string filename = Path.GetFileName(file.FileName);
string _filename = DateTime.Now.ToString("yymmssfff") + filename;
string extension = Path.GetExtension(file.FileName);
string path = Path.Combine(Server.MapPath("~/Image/"), _filename);
insertprd.SmallImage = "~/Image/" + _filename;
string filename1 = Path.GetFileName(file1.FileName);
string _filename1 = DateTime.Now.ToString("yymmssfff") + filename1;
string extension1 = Path.GetExtension(file1.FileName);
string path1 = Path.Combine(Server.MapPath("~/Image/"), _filename1);
insertprd.LargeImage = "~/Image/" + _filename1;
if ((extension.ToLower() == ".jpg" || extension.ToLower() == ".jpeg" || extension.ToLower() == ".png") && (extension1.ToLower() == ".jpg" || extension1.ToLower() == ".jpeg" || extension1.ToLower() == ".png"))
{
if (file.ContentLength <= 1000000 && file1.ContentLength <= 1000000)
{
pd.tblProducts.Add(insertprd);
if (pd.SaveChanges() > 0)
{
file.SaveAs(path);
file1.SaveAs(path1);
ViewBag.msg = "Record Added";
ModelState.Clear();
}
}
else
{
ViewBag.msg = "Size is not valid";
}
}
HttpClient hc = new HttpClient();
hc.BaseAddress = new Uri("https://localhost:44324/api/ProductCrud");
var insertrecord = hc.PostAsJsonAsync <tblProduct>("ProductCrud", insertprd);
insertrecord.Wait();
var savedata = insertrecord.Result;
ViewBag.tblProducts = new SelectList(pd.tblProducts, "Id", "Name");
if (savedata.IsSuccessStatusCode)
{
TempData["SuccessMessage"] = "Saved SucessFully";
return(RedirectToAction("ProductList"));
}
return(View("ProductList"));
}
public ActionResult Create(product p)
{
try
{
string fileName = Path.GetFileNameWithoutExtension(p.ImageFile.FileName);
string extension = Path.GetExtension(p.ImageFile.FileName);
fileName = fileName + DateTime.Now.ToString("yymmssfff") + extension;
p.Image = "~/Image/" + fileName;
fileName = Path.Combine(Server.MapPath("~/Image/"), fileName);
p.ImageFile.SaveAs(fileName);
db.products.Add(p);
db.SaveChanges();
ModelState.Clear();
return(RedirectToAction("Index"));
}
catch
{
return(View());
}
}
public bool CreateProduct(Product productToCreate)
{
try
{
_entities.AddToProductSet(productToCreate);
_entities.SaveChanges();
return(true);
}
catch
{
return(false);
}
}
public IHttpActionResult PutProduct(int id, Product product)
{
product.CreateDate = DateTime.Now;
db.Entry(product).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!ProductExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
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 IHttpActionResult Put(ProductClass pc)
{
var updateprd = pd.tblProducts.Where(x => x.Id == pc.Id).FirstOrDefault <tblProduct>();
if (updateprd != null)
{
updateprd.Id = pc.Id;
updateprd.Name = pc.Name;
updateprd.Category = pc.Category;
updateprd.Price = pc.Price;
updateprd.Quantity = pc.Quantity;
updateprd.ShortDescription = pc.ShortDescription;
updateprd.LongDescription = pc.LongDescription;
updateprd.SmallImage = pc.SmallImage;
updateprd.LargeImage = pc.LargeImage;
pd.SaveChanges();
}
else
{
return(NotFound());
}
return(Ok());
}
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 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"));
}