public ActionResult ProductCapabilitiesPartial(ProductsCapabilityModel model) { var record = new ProductsCapability(); if (model.ProductsCapabilityId > 0) { record = _db.ProductsCapabilities.FirstOrDefault(a => a.ProductsCapabilityId == model.ProductsCapabilityId); } record.Name = model.Name; record.CompanyId = model.CompanyId; if (model.ProductsCapabilityId == 0) { record.CreatedDate = DateTime.Now; _db.ProductsCapabilities.Add(record); } else { record.ModifiedDate = DateTime.Now; _db.Entry(record).State = EntityState.Modified; } _db.SaveChanges(); ProductsCapabilityModel _ProductsCapabilityModel = GetProductCapabilities(model.CompanyId); return(PartialView(_ProductsCapabilityModel)); }
public ActionResult Index([Bind(Include = "ProductsCapabilityId,CompanyId,Name,Description,CreatedBy,CreatedDate,ModifiedBy,ModifiedDate")] ProductsCapability productsCapability) { ViewBag.productsCapabilities = db.ProductsCapabilities.Where(a => a.CompanyId == productsCapability.CompanyId).ToList(); ViewBag.CompanyId = productsCapability.CompanyId; if (ModelState.IsValid) { if (productsCapability.ProductsCapabilityId == 0) { productsCapability.CreatedDate = DateTime.Now; productsCapability.ModifiedDate = DateTime.Now; db.ProductsCapabilities.Add(productsCapability); } else { var record = db.ProductsCapabilities.FirstOrDefault(a => a.ProductsCapabilityId == productsCapability.ProductsCapabilityId); record.Name = productsCapability.Name; record.CompanyId = productsCapability.CompanyId; record.ModifiedDate = DateTime.Now; db.Entry(record).State = EntityState.Modified; } db.SaveChanges(); return(RedirectToAction("Index", new { companyId = productsCapability.CompanyId })); } return(View(productsCapability)); }
public JsonResult SaveProductCapability(string ProductCapabilityData, int ProductCapabilityId) { var serializer = new JavaScriptSerializer(); var productCapability = serializer.Deserialize(ProductCapabilityData, typeof(ProductsCapabilityModel)); ProductsCapabilityModel model = (dynamic)(productCapability); ProductsCapability product = new ProductsCapability(); if (ProductCapabilityId > 0) { product = _db.ProductsCapabilities.FirstOrDefault(a => a.ProductsCapabilityId == ProductCapabilityId); product.ModifiedDate = DateTime.Now; } product.Name = model.Name; product.CompanyId = model.CompanyId; if (ProductCapabilityId > 0) { _db.Entry(product).State = EntityState.Modified; } else { product.CreatedDate = DateTime.Now; _db.ProductsCapabilities.Add(product); } _db.SaveChanges(); ProductNProgramsResponseModel response = new ProductNProgramsResponseModel(); response.Message = "Success"; response.Id = product.ProductsCapabilityId; response.Name = product.Name; return(Json(response, JsonRequestBehavior.AllowGet)); }
// GET: Admin/ProductsCapabilities public ActionResult Index(int companyId, int?id = 0) { ProductsCapability productsCapability = db.ProductsCapabilities.Find(id); ViewBag.productsCapabilities = db.ProductsCapabilities.Where(a => a.CompanyId == companyId).ToList(); ViewBag.CompanyId = companyId; return(View(productsCapability)); }
public ActionResult DeleteConfirmed(int id) { ProductsCapability productsCapability = db.ProductsCapabilities.Find(id); int companyid = productsCapability.CompanyId; db.ProductsCapabilities.Remove(productsCapability); db.SaveChanges(); return(RedirectToAction("Index", new { companyId = companyid })); }
public ActionResult Edit([Bind(Include = "ProductsCapabilityId,CompanyId,Name,CreatedBy,CreatedDate,ModifiedBy,ModifiedDate")] ProductsCapability productsCapability) { if (ModelState.IsValid) { db.Entry(productsCapability).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.CompanyId = new SelectList(db.Companies, "CompanyId", "PartnerType", productsCapability.CompanyId); return(View(productsCapability)); }
// GET: Admin/ProductsCapabilities/Details/5 public ActionResult Details(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } ProductsCapability productsCapability = db.ProductsCapabilities.Find(id); if (productsCapability == null) { return(HttpNotFound()); } return(View(productsCapability)); }
// GET: Admin/ProductsCapabilities/Edit/5 public ActionResult Edit(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } ProductsCapability productsCapability = db.ProductsCapabilities.Find(id); if (productsCapability == null) { return(HttpNotFound()); } ViewBag.CompanyId = new SelectList(db.Companies, "CompanyId", "PartnerType", productsCapability.CompanyId); return(View(productsCapability)); }
public ProductsCapabilityModel GetProductCapabilities(int companyId) { ProductsCapabilityModel _ProductsCapabilityModel = new ProductsCapabilityModel(); _ProductsCapabilityModel.CompanyId = companyId; var _ProductsCapabilities = _db.ProductsCapabilities.Where(a => a.CompanyId == companyId).ToList(); if (_ProductsCapabilities.Count > 0) { List <ProductsCapability> lstProductsCapability = new List <ProductsCapability>(); foreach (var item in _ProductsCapabilities) { ProductsCapability _ProductsCapability = new ProductsCapability(); _ProductsCapability.CompanyId = item.CompanyId; _ProductsCapability.Name = item.Name; _ProductsCapability.ProductsCapabilityId = item.ProductsCapabilityId; lstProductsCapability.Add(_ProductsCapability); } _ProductsCapabilityModel.lstProductsCapabilities = lstProductsCapability; } return(_ProductsCapabilityModel); }
public ActionResult CompanyProgramsNProducts() { string[] stringSeparators = new string[] { ",", ". ", "\n", ";" }; SourcingGuideDevEntities _db = new SourcingGuideDevEntities(); var companies = _db.Companies.ToList(); foreach (var comp in companies) { //Manage Proforma Programs var proformaProgram = comp.ProformaPrograms; if (!string.IsNullOrEmpty(proformaProgram)) { var lstProformaPrograms = proformaProgram.Split(stringSeparators, StringSplitOptions.RemoveEmptyEntries); // proformaProgram.Split(new[] { ",", ". ", "\n", ";" }).ToList(); foreach (var pp in lstProformaPrograms) { var strProformaProgram = pp.Trim(); if (!string.IsNullOrEmpty(strProformaProgram)) { var _ProformaProgram = _db.ProformaPrograms.FirstOrDefault(p => p.CompanyId == comp.CompanyId && p.Name == strProformaProgram); if (null == _ProformaProgram) { _ProformaProgram = new ProformaProgram(); _ProformaProgram.CompanyId = comp.CompanyId; _ProformaProgram.Name = strProformaProgram; _ProformaProgram.CreatedDate = DateTime.Now; _db.ProformaPrograms.Add(_ProformaProgram); } else { _ProformaProgram.Name = strProformaProgram; _ProformaProgram.ModifiedDate = DateTime.Now; _db.Entry(_ProformaProgram).State = EntityState.Modified; } } } } //Manage ProductsCapabilities var productsCapability = comp.ProductsNCapabilities; if (!string.IsNullOrEmpty(productsCapability)) { var lstProductsCapabilities = productsCapability.Split(stringSeparators, StringSplitOptions.RemoveEmptyEntries); //productsCapability.Split(new[] { ',', '. ', '\n', ';' }).ToList(); foreach (var pc in lstProductsCapabilities) { var strProductsCapability = pc.Trim(); if (!string.IsNullOrEmpty(strProductsCapability)) { var _ProductsCapability = _db.ProductsCapabilities.FirstOrDefault(p => p.CompanyId == comp.CompanyId && p.Name == strProductsCapability); if (null == _ProductsCapability) { _ProductsCapability = new ProductsCapability(); _ProductsCapability.CompanyId = comp.CompanyId; _ProductsCapability.Name = strProductsCapability; _ProductsCapability.CreatedDate = DateTime.Now; _db.ProductsCapabilities.Add(_ProductsCapability); } else { _ProductsCapability.Name = strProductsCapability; _ProductsCapability.ModifiedDate = DateTime.Now; _db.Entry(_ProductsCapability).State = EntityState.Modified; } } } } _db.SaveChanges(); } ViewBag.OperationStatus = "ProformaPrograms/ProductsCapabilities updated successfully!"; return(View()); }