/* [Obsolete]
*/
public ActionResult Create([Bind(Include = "ProductId,Unit,ProductName,Price,CreatedAt,CreatedBy,TotalQun,CurrentQun,CategoryId,IsActive,Image,Image1,ImageFile")] ProductList productList, HttpPostedFileBase file)
{
if (ModelState.IsValid)
{
using (EkartEntities7 db = new EkartEntities7())
{
var v = db.ProductLists.Where(a => a.ProductName.Equals(productList.ProductName)).FirstOrDefault();
if (v == null)
{
string fileName = Path.GetFileNameWithoutExtension(productList.Image1);
if (file != null)
{
productList.Image1 = /*"~/Content/ProductImages/" +*/ DateTime.Now.ToString("yymmssfff") + productList.ProductId + Path.GetExtension(file.FileName);
file.SaveAs(Server.MapPath("//Content//ProductImages//") + productList.Image1);
productList.IsActive = "Y";
productList.CreatedBy = Session["userName"].ToString();
productList.CreatedAt = DateTime.Now;
productList.TotalQun = productList.CurrentQun;
/* db.ProductLists.Add(productList);
* db.SaveChanges();
* return RedirectToAction("Index");*/
/* if (file != null)
* {
* productList.Image1 = productList.Image1+Path.GetExtension(file.FileName);
* file.SaveAs(Server.MapPath("//Content//ProductImages//") + productList.Image1);
* db.ProductLists.Add(productList);
* db.SaveChanges();
* return RedirectToAction("Index");
* }*/
db.ProductLists.Add(productList);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(RedirectToAction("Index"));
}
else
{
return(Content("<script language='javascript' type='text/javascript'>alert('Product Is Already Peresent'); window.location.replace('Create');</script>"));
}
}
}
else
{
}
ViewBag.CategoryId = new SelectList(db.CategoryLists, "CategoryId", "CategoryName", productList.CategoryId);
return(View(productList));
}
public ActionResult Edit([Bind(Include = "CategoryId,CategoryName,CreatedAt,CreatedBy,IsActive")] CategoryList categoryList)
{
if (ModelState.IsValid)
{
using (EkartEntities7 db = new EkartEntities7())
{
var v = db.CategoryLists.Where(a => a.CategoryName.Equals(categoryList.CategoryName)).FirstOrDefault();
if (v == null)
{
categoryList.CreatedAt = DateTime.Now;
categoryList.CreatedBy = Session["userName"].ToString();
/* categoryList.IsActive = "Y";*/
db.Entry(categoryList).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
else
{
/* CategoryList c1= db.CategoryLists.Where(a => a.CategoryId == categoryList.CategoryId).SingleOrDefault();
* db.CategoryLists.Find(id);
*
*
*/
CategoryList c1 = db.CategoryLists.Find(categoryList.CategoryId);
if (c1.CategoryName == categoryList.CategoryName)
{
/* db.Entry(categoryList).State = EntityState.Modified;
*/
c1.CreatedAt = categoryList.CreatedAt = DateTime.Now;
c1.CreatedBy = categoryList.CreatedBy = Session["userName"].ToString();
c1.IsActive = categoryList.IsActive;
/* categoryList.CreatedAt = DateTime.Now;
* db.Entry(categoryList).State = EntityState.Modified;*/
db.SaveChanges();
return(RedirectToAction("Index"));
}
else
{
return(Content("<script language='javascript' type='text/javascript'>alert('Category Is Already Peresent'); window.location.replace('Edit');</script>"));
}
}
}
}
return(View(categoryList));
}
public ActionResult Search(ProductList p1)
{
Session["Product"] = p1.ProductName;
using (EkartEntities7 dc = new EkartEntities7())
{
var v = dc.ProductLists.Where(a => a.ProductName.Equals(p1.ProductName)).FirstOrDefault();
if (v != null)
{
return(Content("<script language='javascript' type='text/javascript'>alert('Product is Found'); window.location.replace('AddQun');</script>"));
}
else
{
return(Content("<script language='javascript' type='text/javascript'>alert('Product Not Found'); window.location.replace('Search');</script>"));
}
}
}
public ActionResult Create([Bind(Include = "CategoryId,CategoryName,CreatedAt,CreatedBy,IsActive")] CategoryList categoryList)
{
if (ModelState.IsValid)
{
using (EkartEntities7 db = new EkartEntities7())
{
var v = db.CategoryLists.Where(a => a.CategoryName.Equals(categoryList.CategoryName)).FirstOrDefault();
if (v == null)
{
categoryList.CreatedAt = DateTime.Now;
categoryList.CreatedBy = Session["userName"].ToString();
categoryList.IsActive = "Y";
db.CategoryLists.Add(categoryList);
db.SaveChanges();
return(RedirectToAction("Index"));
}
else
{
return(Content("<script language='javascript' type='text/javascript'>alert('Category Is Already Peresent'); window.location.replace('Create');</script>"));
}
}
}
return(View(categoryList));
}
public ActionResult Edit([Bind(Include = "ProductId,Unit,ProductName,Price,CreatedAt,CreatedBy,TotalQun,CurrentQun,CategoryId,IsActive,Image,Image1")] ProductList productList)
{
if (ModelState.IsValid)
{
/* productList.CreatedAt = DateTime.Now;
* productList.CreatedBy = Session["userName"].ToString();
*//* ProductList product = new ProductList();
*
*
* product = db.ProductLists.Where(u => u.ProductName == productList.ProductName).SingleOrDefault();
* product.TotalQun = (productList.CurrentQun + product.TotalQun);
* product.CurrentQun = (productList.CurrentQun + product.CurrentQun);
*
*/
/* var productList1 = db.ProductLists.Where(u => u.ProductName == productList.ProductName).SingleOrDefault();
* productList1.TotalQun = productList1.TotalQun + productList.CurrentQun;
* productList1.CurrentQun = productList1.CurrentQun + productList.CurrentQun;
*
* db.ProductLists.Add(productList);
* db.SaveChanges();
* return RedirectToAction("Index");*//*
* db.Entry(productList).State = EntityState.Modified;
* db.SaveChanges();
* return RedirectToAction("Index");
* }
* ViewBag.CategoryId = new SelectList(db.CategoryLists, "CategoryId", "CategoryName", productList.CategoryId);
* return View(productList);*/
using (EkartEntities7 db = new EkartEntities7())
{
var v = db.ProductLists.Where(a => a.ProductName.Equals(productList.ProductName)).FirstOrDefault();
if (v == null)
{
productList.CreatedAt = DateTime.Now;
productList.CreatedBy = Session["userName"].ToString();
/* categoryList.IsActive = "Y";*/
db.Entry(productList).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
else
{
/* CategoryList c1= db.CategoryLists.Where(a => a.CategoryId == categoryList.CategoryId).SingleOrDefault();
* db.CategoryLists.Find(id);
*
*
*/
ProductList c1 = db.ProductLists.Find(productList.ProductId);
if (c1.ProductName == productList.ProductName)
{
/* db.Entry(categoryList).State = EntityState.Modified;
*/
c1.CreatedAt = productList.CreatedAt = DateTime.Now;
c1.CreatedBy = productList.CreatedBy = Session["userName"].ToString();
c1.IsActive = productList.IsActive;
c1.CategoryId = productList.CategoryId;
c1.Price = productList.Price;
c1.Unit = productList.Unit;
/* categoryList.CreatedAt = DateTime.Now;
* db.Entry(categoryList).State = EntityState.Modified;*/
db.SaveChanges();
return(RedirectToAction("Index"));
}
else
{
return(Content("<script language='javascript' type='text/javascript'>alert('Product Is Already Peresent'); window.location.replace('Edit');</script>"));
}
}
}
}
return(View(productList));
}
