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());
}
