public ActionResult CreateCustomer() { Product_Details objProject = new Product_Details(); CMPSEntities5 dbcontext = new CMPSEntities5(); return(PartialView("InsertCustomers", dbcontext.Product_Details)); }
public ActionResult Create() { ClsProduct objProject = new ClsProduct(); using (CMPSEntities5 dbcontext = new CMPSEntities5()) { objProject.lstProduct = dbcontext.Products.Select(a => new Department() { ProductId = a.Id, Description = a.Description }).ToList(); } return(View(objProject)); }
public ActionResult Create(ClsProduct model) { using (CMPSEntities5 dbcontext = new CMPSEntities5()) { if (model.Id == 0) { Product_Details tblCustomer = new Product_Details(); tblCustomer.ModelPlace = model.ModelPlace; tblCustomer.Rate = model.Rate; tblCustomer.ProductId = model.ProductId; dbcontext.Product_Details.Add(tblCustomer); dbcontext.SaveChanges(); } } return(RedirectToAction("Index")); }
public ActionResult Update(ClsProduct model) { using (CMPSEntities5 dbcontext = new CMPSEntities5()) { if (model.Id > 0) { Product_Details tblCustomer = dbcontext.Product_Details.Where(a => a.Id == model.Id).FirstOrDefault(); if (tblCustomer != null) { tblCustomer.ModelPlace = model.ModelPlace; tblCustomer.Rate = model.Rate; dbcontext.SaveChanges(); } } } return(RedirectToAction("Index")); }
public ActionResult Details(int Id) { //List<ClsProduct> clsproduct = new List<ClsProduct>(); //using (CMPSEntities5 dbcontext = new CMPSEntities5()) //{ // clsproduct = (from cus in dbcontext.Product_Details // join dep in dbcontext.Products on cus.ProductId equals dep.Id // select new ClsProduct // { // Id = cus.Id, // ModelPlace = cus.ModelPlace, // Rate = cus.Rate, // }).ToList(); CMPSEntities5 dbcontext = new CMPSEntities5(); //ClsProduct pro = dbcontext.Products.Single(x => x.Id == Id); return(View()); }
public ActionResult Index(string sortOrder, string searchString) { CMPSEntities5 dbcontext = new CMPSEntities5(); ViewBag.NameSortParm = String.IsNullOrEmpty(sortOrder) ? "name_desc" : ""; List <ClsProduct> clsproduct = new List <ClsProduct>(); var product = (from cus in dbcontext.Product_Details join dep in dbcontext.Products on cus.ProductId equals dep.Id select new ClsProduct { Id = cus.Id, ModelPlace = cus.ModelPlace, Rate = cus.Rate, Description = dep.Description //Description =cus. }); if (!String.IsNullOrEmpty(searchString)) { product = product.Where(s => s.Description.Contains(searchString) || s.ModelPlace.Contains(searchString) || s.Rate.Contains(searchString)); } switch (sortOrder) { case "Description": product = product.OrderByDescending(s => s.Description); break; case "ModelPlace": product = product.OrderBy(s => s.ModelPlace); break; case "Rate": product = product.OrderByDescending(s => s.Rate); break; default: product = product.OrderBy(s => s.Description); break; } return(View(product.ToList())); }
public ActionResult Edit(int Id) { ClsProduct objProject = new ClsProduct(); using (CMPSEntities5 dbcontext = new CMPSEntities5()) { objProject = (from cus in dbcontext.Product_Details where cus.Id == Id select new ClsProduct { Id = cus.ProductId, ModelPlace = cus.ModelPlace, ProductId = cus.ProductId, Rate = cus.Rate }).FirstOrDefault(); objProject.lstProduct = dbcontext.Products.Select(a => new Department() { ProductId = a.Id, Description = a.Description }).ToList(); } return(View(objProject)); }
public JsonResult InsertProducts(List <Product_Details> products) { using (CMPSEntities5 entities = new CMPSEntities5()) { //Truncate Table to delete all old records. //entities.Database.ExecuteSqlCommand("TRUNCATE TABLE [product]"); //Check for NULL. if (products == null) { products = new List <Product_Details>(); } //Loop and insert records. foreach (Product_Details Product in products) { entities.Product_Details.Add(Product); } int insertedRecords = entities.SaveChanges(); return(Json(insertedRecords)); } }