public ActionResult DeleteConfirmed(int id)
{
CustCat custCat = db.CustCats.Find(id);
db.CustCats.Remove(custCat);
db.SaveChanges();
return(RedirectToAction("Index"));
}
// POST: CustCats/Delete/catid?custid?
public ActionResult Remove(int?catid, int custid)
{
CustCat cust = db.CustCats.Where(c => c.CustCategoryId == catid && c.CustomerId == custid).FirstOrDefault();
CustCat custCat = db.CustCats.Find(cust.Id);
db.CustCats.Remove(custCat);
db.SaveChanges();
return(RedirectToAction("Details", "Customers", new { id = custid }));
}
public ActionResult Edit([Bind(Include = "Id,CustomerId,CustCategoryId")] CustCat custCat)
{
if (ModelState.IsValid)
{
db.Entry(custCat).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.CustomerId = new SelectList(db.Customers, "Id", "Name", custCat.CustomerId);
ViewBag.CustCategoryId = new SelectList(db.CustCategories, "Id", "Name", custCat.CustCategoryId);
return(View(custCat));
}
public ActionResult addCategory(int catid, int userid)
{
CustCat cat = new CustCat();
db.CustCats.Add(new CustCat
{
CustCategoryId = catid,
CustomerId = userid
});
db.SaveChanges();
// return RedirectToAction("Index");
return(RedirectToAction("Details", "Customers", new { id = userid }));
}
public ActionResult Create([Bind(Include = "Id,CustomerId,CustCategoryId")] CustCat custCat)
{
if (ModelState.IsValid)
{
db.CustCats.Add(custCat);
db.SaveChanges();
// return RedirectToAction("Index");
return(RedirectToAction("Details", "Customers", new { id = custCat.CustomerId }));
}
ViewBag.CustomerId = new SelectList(db.Customers, "Id", "Name", custCat.CustomerId);
ViewBag.CustCategoryId = new SelectList(db.CustCategories, "Id", "Name", custCat.CustCategoryId);
return(View(custCat));
}
// GET: CustCats/Details/5
public ActionResult Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
CustCat custCat = db.CustCats.Find(id);
if (custCat == null)
{
return(HttpNotFound());
}
return(RedirectToAction("Index"));
}
// GET: CustCats/Delete/5
public ActionResult Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
CustCat custCat = db.CustCats.Find(id);
if (custCat == null)
{
return(HttpNotFound());
}
return(View(custCat));
}
// GET: CustCats/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
CustCat custCat = db.CustCats.Find(id);
if (custCat == null)
{
return(HttpNotFound());
}
ViewBag.CustomerId = new SelectList(db.Customers, "Id", "Name", custCat.CustomerId);
ViewBag.CustCategoryId = new SelectList(db.CustCategories, "Id", "Name", custCat.CustCategoryId);
return(View(custCat));
}
// GET: Customers
public ActionResult Index()
{
var customerList = db.Customers.ToList();
string category;
string companyName;
List <CustomerDetails> customerDetailList = new List <CustomerDetails>();
foreach (var customer in customerList)
{
CustCategory custcategory = new CustCategory();
CustCat custcat = new CustCat();
CustEntity companyEntity = new CustEntity();
CustEntMain company = new CustEntMain();
try
{
custcat = db.CustCats.Where(c => c.CustomerId == customer.Id).FirstOrDefault();
custcategory = db.CustCategories.Where(cat => cat.Id == custcat.CustCategoryId).FirstOrDefault();
}
catch (Exception ex)
{
custcategory = new CustCategory
{
Id = 0,
Name = "Not Assigned",
iconPath = "Images/Customers/Category/unavailable-40.png"
};
}
try
{
companyEntity = db.CustEntities.Where(ce => ce.CustomerId == customer.Id).FirstOrDefault();
company = db.CustEntMains.Where(co => co.Id == companyEntity.CustEntMainId).FirstOrDefault();
}
catch (Exception ex)
{
company = new CustEntMain
{
Id = 0,
Name = "Not Assigned",
Address = "none",
Contact1 = "0",
Contact2 = "0",
iconPath = "Images/Customers/Category/unavailable-40.png"
};
}
customerDetailList.Add(new CustomerDetails
{
Id = customer.Id,
Name = customer.Name,
Email = customer.Email,
Contact1 = customer.Contact1,
Contact2 = customer.Contact2,
Remarks = customer.Remarks,
Status = customer.Status,
JobID = customer.JobMains.Count(),
CustCategoryID = custcategory.Id,
CustCategoryIcon = custcategory.iconPath,
CustEntID = company.Id,
CustEntName = company.Name,
CustEntIconPath = "~/Images/Customers/Company/organization-40.png",
categories = getCategoriesList(customer.Id),
companies = getCompanyList(customer.Id)
// JobID = db.JobMains.Where(jm => jm.CustomerId.Equals(customer.Id)).FirstOrDefault() == null ? 0 : db.JobMains.Where(jm => jm.CustomerId.Equals(customer.Id)).FirstOrDefault().Id,
//end
});
}
//return View(db.Customers.ToList());
return(View(customerDetailList));
}
