public ActionResult deleproduction(int id)
{
using (FinaEntities db = new FinaEntities())
{
var dp = db.Products.FirstOrDefault(x => x.ID == id);
ViewBag.ID = dp.ID;
}
return(View());
}
public ActionResult Deleprod(int id)
{
using (FinaEntities db = new FinaEntities())
{
db.Products.Remove(db.Products.FirstOrDefault(x => x.ID == id));
db.SaveChanges();
}
return(RedirectToAction("Index"));
}
public JsonResult DeletCategory(int id)
{
using (FinaEntities db = new FinaEntities())
{
db.Products.RemoveRange(db.Products.Where(x => x.CategoryId == id));
db.categories.Remove(db.categories.FirstOrDefault(x => x.ID == id));
db.SaveChanges();
return(Json(new { success = true, result = "saved", }, JsonRequestBehavior.AllowGet));
}
}
public JsonResult Delete(string id)
{
int a = Convert.ToInt32(id);
using (FinaEntities db = new FinaEntities())
{
db.categories.RemoveRange(db.categories.Where(x => x.GrupID == a));
db.Grups.Remove(db.Grups.FirstOrDefault(x => x.ID == a));
db.SaveChanges();
return(Json(new { success = true, result = "saved", }, JsonRequestBehavior.AllowGet));
}
}
public JsonResult AddCategory(string id, string name)
{
var intid = Convert.ToInt32(id);
using (FinaEntities db = new FinaEntities())
{
db.categories.Add(new category()
{
categoryName = name,
GrupID = intid,
});
db.SaveChanges();
}
return(Json(new { success = true, result = "saved", name }, JsonRequestBehavior.AllowGet));
}
public ActionResult Editproducticon(ProsuctListmodel pr)
{
using (FinaEntities db = new FinaEntities())
{
var dp = db.Products.FirstOrDefault(x => x.ID == pr.ID);
dp.Name = pr.Name;
dp.Price = pr.Price;
dp.startDate = pr.StartDate;
dp.country = pr.Country;
dp.CompletionDate = pr.CompletionDate;
dp.Code = pr.Code;
db.SaveChanges();
}
return(RedirectToAction("index"));
}
// GET: Home
public ActionResult Index()
{
var result = new List <HomeViewModel>();
using (FinaEntities db = new FinaEntities())
{
var c = db.categories.Select(x => x);
result = (from g in db.Grups
select new HomeViewModel
{
GrupId = g.ID,
GrupName = g.Name,
Category = c.Where(x => x.GrupID == g.ID).Select(x => new CategoryModel {
CategoryId = x.ID, CategoryName = x.categoryName
}).ToList()
}).ToList();
return(View(result));
}
}
public ActionResult Addproduct(ProductModel product)
{
var intid = Convert.ToInt32(product.CategoryId);
using (FinaEntities db = new FinaEntities())
{
_ = db.Products.Add(new Product()
{
Name = product.Name,
CategoryId = intid,
Code = product.Code,
country = product.Country,
Price = product.Price,
startDate = product.StartDate,
CompletionDate = product.CompletionDate
});
db.SaveChanges();
}
return(RedirectToAction("index"));
}
public JsonResult AddGrup(string name)
{
if (name == null)
{
string error = "ველი ცარიელია";
return(Json(new { success = false, result = "nosaved", error }));
}
else
{
using (FinaEntities db = new FinaEntities())
{
db.Grups.Add(new Grup()
{
Name = name,
});
db.SaveChanges();
}
return(Json(new { success = true, result = "saved", name }));
}
}
public ActionResult _Editproducticon(int?id)
{
using (FinaEntities db = new FinaEntities())
{
var p = db.Products.FirstOrDefault(x => x.ID == id);
var result = (new ProductModelStr()
{
ID = p.ID,
Name = p.Name,
Code = p.Code,
Country = p.country,
CompletionDate = p.CompletionDate.ToString("yyyy/dd/mm"),
Price = p.Price,
StartDate = p.startDate.ToString("yyyy/dd/mm")
});
return(View(result));
}
}
// GET: Diagram
public ActionResult Diagram(int id)
{
var result = new List <ProductModelStr>();
using (FinaEntities db = new FinaEntities())
{
result = (from p in db.Products
where (p.CategoryId == id)
select new ProductModelStr
{
ID = p.ID,
Name = p.Name,
Code = p.Code,
Country = p.country,
CompletionDate = p.CompletionDate.ToString(),
Price = p.Price,
StartDate = p.startDate.ToString()
}).ToList();
}
return(View(result));
}
public JsonResult Openproduct(int id)
{
var result = new List <ProductModelString>();
using (FinaEntities db = new FinaEntities())
{
result = (from p in db.Products
where (p.CategoryId == id)
select new ProductModelString
{
ID = p.ID,
Name = p.Name,
Code = p.Code,
Country = p.country,
CompletionDate = p.CompletionDate.ToString(),
Price = p.Price,
StartDate = p.startDate.ToString()
}).ToList();
return(Json(new { success = true, result }, JsonRequestBehavior.AllowGet));
}
}
