// POST: Admin/Category_Details/Delete/5
public ActionResult Delete(int id)
{
Category_Details category_Details = db.Category_Details.Find(id);
var Greetings = db.Greetings.Where(mvs => mvs.categoryDetailsID == category_Details.id).AsEnumerable();
try
{
//foreach (var mvs in Greetings.ToList())
//{
// foreach(var sending in mvs.Sendings.ToList())
// {
// db.Sendings.Remove(sending);
// }
// db.Greetings.Remove(mvs);
//}
if (category_Details != null)
{
db.Category_Details.Remove(category_Details);
}
db.SaveChanges();
}
catch
{
TempData["error"] = "Delete Fail";
}
return(RedirectToAction("Index"));
}
public ActionResult Create([Bind(Include = "id,name,categoryID,dateOfEvent")] Category_Details category_Details)
{
var i = db.Category_Details.Count(acc => acc.name.Equals(category_Details.name));
if (ModelState.IsValid)
{
if (i < 1)
{
Category_DetailsViewModel category_DetailsViewModel = new Category_DetailsViewModel();
category_DetailsViewModel.category_details = new Category_Details();
category_DetailsViewModel.category_details.id = category_Details.id;
category_DetailsViewModel.category_details.name = category_Details.name;
category_DetailsViewModel.category_details.dateOfEvent = category_Details.dateOfEvent;
category_DetailsViewModel.category_details.status = category_Details.status;
category_DetailsViewModel.category_details.categoryID = category_Details.categoryID;
db.Category_Details.Add(category_DetailsViewModel.category_details);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ModelState.AddModelError("", "CategoryDetail Has been used");
}
ViewBag.categoryID = new SelectList(db.Categories, "id", "name", category_Details.categoryID);
return(View(category_Details));
}
public ActionResult DeleteConfirmed(int id)
{
Category_Details category_Details = db.Category_Details.Find(id);
db.Category_Details.Remove(category_Details);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Edit([Bind(Include = "Id,Pet_Id,Pet_Breed")] Category_Details category_Details)
{
if (ModelState.IsValid)
{
db.Entry(category_Details).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.Pet_Id = new SelectList(db.Pet_Details, "Id", "Pet_Category", category_Details.Pet_Id);
return(View(category_Details));
}
public ActionResult Create([Bind(Include = "Id,Pet_Id,Pet_Breed")] Category_Details category_Details)
{
if (ModelState.IsValid)
{
db.Category_Details.Add(category_Details);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.Pet_Id = new SelectList(db.Pet_Details, "Id", "Pet_Category", category_Details.Pet_Id);
return(View(category_Details));
}
public ActionResult Delete(int id)
{
var prd = db.Products_Details.Where(e => e.Category_Id == id).ToList();
db.Products_Details.RemoveRange(prd);
db.SaveChanges();
Category_Details category_Details = db.Category_Details.Find(id);
db.Category_Details.Remove(category_Details);
db.SaveChanges();
return(RedirectToAction("Index"));
}
// GET: Category/Details/5
public ActionResult Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Category_Details category_Details = db.Category_Details.Find(id);
if (category_Details == null)
{
return(HttpNotFound());
}
return(View(category_Details));
}
// GET: Category/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Category_Details category_Details = db.Category_Details.Find(id);
if (category_Details == null)
{
return(HttpNotFound());
}
ViewBag.Pet_Id = new SelectList(db.Pet_Details, "Id", "Pet_Category", category_Details.Pet_Id);
return(View(category_Details));
}
// GET: Admin/Category_Details/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Category_Details category_Details = db.Category_Details.Find(id);
if (category_Details == null)
{
return(HttpNotFound());
}
ViewBag.categoryID = new SelectList(db.Categories, "id", "name", category_Details.categoryID);
return(View(category_Details));
}
public ActionResult UpdateCategory(int categoryId)
{
Category_Details cd;
if (categoryId != null)
{
cd = JsonConvert.DeserializeObject <Category_Details>
(JsonConvert.SerializeObject
(_unitOfWork.GetRepositoryInstance <Tbl_Category>().GetFirstorDefault(categoryId)));
}
else
{
cd = new Category_Details();
}
return(View("UpdateCategory", cd));
}
public ActionResult Edit([Bind(Include = "id,name,categoryID,dateOfEvent")] Category_Details category_Details)
{
//var i = db.Category_Details.Count(acc => acc.name.Equals(category_Details.name));
if (ModelState.IsValid)
{
//if (i < 1)
//{
db.Entry(category_Details).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
//}
//ModelState.AddModelError("", "CategoryDetail Has been used");
}
ViewBag.categoryID = new SelectList(db.Categories, "id", "name", category_Details.categoryID);
return(View(category_Details));
}
// GET: Inventory/Category_Details/Create
public PartialViewResult CreatePartial(int?id)
{
string Company_Id = string.Empty;
HttpCookie myCookie = Request.Cookies["inventoryCookie"];
if (!string.IsNullOrEmpty(myCookie.Values["Company_Id"]))
{
Company_Id = myCookie.Values["Company_Id"].ToString();
}
Category_Details car = new Category_Details();
if (id != null)
{
car = db.Category_Details.Where(c => c.Category_Id == id).FirstOrDefault();
}
return(PartialView(car));
}
public ActionResult Create(Category_Details category_Details)
{
if (ModelState.IsValid)
{
string Company_Id = string.Empty;
string UserId = string.Empty;
string UserName = string.Empty;
HttpCookie myCookie = Request.Cookies["inventoryCookie"];
if (myCookie == null)
{
return(Redirect("/Auth/Login/Logout"));
}
if (!string.IsNullOrEmpty(myCookie.Values["Company_Id"]))
{
Company_Id = myCookie.Values["Company_Id"].ToString();
}
if (!string.IsNullOrEmpty(myCookie.Values["UserId"]))
{
UserId = myCookie.Values["UserId"].ToString();
}
if (!string.IsNullOrEmpty(myCookie.Values["UserName"]))
{
UserName = myCookie.Values["UserName"].ToString();
}
Category_Details cart = new Category_Details();
cart.Added_By = UserName;
cart.Date_Created = DateTime.Now;
cart.Company_Id = Convert.ToInt32(Company_Id);
cart.Name = category_Details.Name;
db.Category_Details.Add(cart);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.Company_Id = new SelectList(db.Company_Details, "Company_Id", "Name", category_Details.Company_Id);
return(View(category_Details));
}
public void MaptoModel(Category_Details category)
{
category.Category_Name = Name;
category.Description = Description;
}
public string Add(string name, int Id)
{
string Returns = "";
if (ModelState.IsValid)
{
string Company_Id = string.Empty;
string UserId = string.Empty;
string UserName = string.Empty;
HttpCookie myCookie = Request.Cookies["inventoryCookie"];
if (myCookie == null)
{
Returns = "Logout";
}
if (!string.IsNullOrEmpty(myCookie.Values["Company_Id"]))
{
Company_Id = myCookie.Values["Company_Id"].ToString();
}
if (!string.IsNullOrEmpty(myCookie.Values["UserId"]))
{
UserId = myCookie.Values["UserId"].ToString();
}
if (!string.IsNullOrEmpty(myCookie.Values["UserName"]))
{
UserName = myCookie.Values["UserName"].ToString();
}
int companyId = Convert.ToInt32(Company_Id);
if (Id != 0)
{
Category_Details cart = db.Category_Details.Where(e => e.Category_Id == Id).FirstOrDefault();
cart.Modified_By = UserName;
cart.Date_Modified = DateTime.Now;
cart.Name = name;
db.Entry(cart).State = EntityState.Modified;
db.SaveChanges();
Returns = " Category Updated Successfully";
}
else
{
Category_Details car = db.Category_Details.Where(e => e.Company_Id == companyId && e.Name == name).FirstOrDefault();
if (car == null)
{
Category_Details cart = new Category_Details();
cart.Added_By = UserName;
cart.Date_Created = DateTime.Now;
cart.Company_Id = Convert.ToInt32(Company_Id);
cart.Name = name;
db.Category_Details.Add(cart);
db.SaveChanges();
Returns = " Category Added Successfully";
}
else
{
Returns = "Category Already Exist";
}
}
}
return(Returns);
}
