public ActionResult ProformaProgramsPartial(ProformaProgramModel model)
{
var record = new ProformaProgram();
if (model.ProformaProgramId > 0)
{
record = _db.ProformaPrograms.FirstOrDefault(a => a.ProformaProgramId == model.ProformaProgramId);
}
record.Name = model.Name;
record.CompanyId = model.CompanyId;
if (model.ProformaProgramId == 0)
{
record.CreatedDate = DateTime.Now;
_db.ProformaPrograms.Add(record);
}
else
{
record.ModifiedDate = DateTime.Now;
_db.Entry(record).State = EntityState.Modified;
}
_db.SaveChanges();
ProformaProgramModel _ProformaProgramModel = GetProFormaPrograms(model.CompanyId);
return(PartialView(_ProformaProgramModel));
}
public ActionResult Index([Bind(Include = "ProformaProgramId,CompanyId,Name,Description,CreatedBy,CreatedDate,ModifiedBy,ModifiedDate")] ProformaProgram proformaProgram)
{
ViewBag.CompanyId = proformaProgram.CompanyId;
ViewBag.proformaPrograms = db.ProformaPrograms.Where(a => a.CompanyId == proformaProgram.CompanyId).ToList();
if (ModelState.IsValid)
{
if (proformaProgram.ProformaProgramId == 0)
{
proformaProgram.CreatedDate = DateTime.Now;
proformaProgram.ModifiedDate = DateTime.Now;
db.ProformaPrograms.Add(proformaProgram);
}
else
{
var record = db.ProformaPrograms.FirstOrDefault(a => a.ProformaProgramId == proformaProgram.ProformaProgramId);
record.Name = proformaProgram.Name;
record.CompanyId = proformaProgram.CompanyId;
record.ModifiedDate = DateTime.Now;
db.Entry(record).State = EntityState.Modified;
}
db.SaveChanges();
return(RedirectToAction("Index", new { companyId = proformaProgram.CompanyId }));
}
return(View(proformaProgram));
}
public JsonResult SaveProformaPrograms(string ProformaProgramsData, int ProformaProgramsId)
{
var serializer = new JavaScriptSerializer();
var proformaProgram = serializer.Deserialize(ProformaProgramsData, typeof(ProformaProgramModel));
ProformaProgramModel model = (dynamic)(proformaProgram);
ProformaProgram program = new ProformaProgram();
if (ProformaProgramsId > 0)
{
program = _db.ProformaPrograms.FirstOrDefault(a => a.ProformaProgramId == ProformaProgramsId);
program.ModifiedDate = DateTime.Now;
}
program.Name = model.Name;
program.CompanyId = model.CompanyId;
if (ProformaProgramsId > 0)
{
_db.Entry(program).State = EntityState.Modified;
}
else
{
program.CreatedDate = DateTime.Now;
_db.ProformaPrograms.Add(program);
}
_db.SaveChanges();
ProductNProgramsResponseModel response = new ProductNProgramsResponseModel();
response.Message = "Success";
response.Id = program.ProformaProgramId;
response.Name = program.Name;
return(Json(response, JsonRequestBehavior.AllowGet));
}
// GET: Admin/ProformaPrograms
public ActionResult Index(int companyId, int?id = 0)
{
ProformaProgram proformaProgram = db.ProformaPrograms.Find(id);
ViewBag.CompanyId = companyId;
ViewBag.proformaPrograms = db.ProformaPrograms.Where(a => a.CompanyId == companyId).ToList();
return(View(proformaProgram));
}
public ActionResult DeleteConfirmed(int id)
{
ProformaProgram proformaProgram = db.ProformaPrograms.Find(id);
db.ProformaPrograms.Remove(proformaProgram);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Edit([Bind(Include = "ProformaProgramId,CompanyId,Name,CreatedBy,CreatedDate,ModifiedBy,ModifiedDate")] ProformaProgram proformaProgram)
{
if (ModelState.IsValid)
{
db.Entry(proformaProgram).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.CompanyId = new SelectList(db.Companies, "CompanyId", "PartnerType", proformaProgram.CompanyId);
return(View(proformaProgram));
}
// GET: Admin/ProformaPrograms/Details/5
public ActionResult Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
ProformaProgram proformaProgram = db.ProformaPrograms.Find(id);
if (proformaProgram == null)
{
return(HttpNotFound());
}
return(View(proformaProgram));
}
// GET: Admin/ProformaPrograms/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
ProformaProgram proformaProgram = db.ProformaPrograms.Find(id);
if (proformaProgram == null)
{
return(HttpNotFound());
}
ViewBag.CompanyId = new SelectList(db.Companies, "CompanyId", "PartnerType", proformaProgram.CompanyId);
return(View(proformaProgram));
}
public ProformaProgramModel GetProFormaPrograms(int companyId)
{
ProformaProgramModel _ProformaProgramModel = new ProformaProgramModel();
_ProformaProgramModel.CompanyId = companyId;
var _ProformaPrograms = _db.ProformaPrograms.Where(a => a.CompanyId == companyId).ToList();
if (_ProformaPrograms.Count > 0)
{
List <ProformaProgram> lstProductsCapability = new List <ProformaProgram>();
foreach (var item in _ProformaPrograms)
{
ProformaProgram _ProformaProgram = new ProformaProgram();
_ProformaProgram.CompanyId = item.CompanyId;
_ProformaProgram.Name = item.Name;
_ProformaProgram.ProformaProgramId = item.ProformaProgramId;
lstProductsCapability.Add(_ProformaProgram);
}
_ProformaProgramModel.lstProformaProgram = lstProductsCapability;
}
return(_ProformaProgramModel);
}
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());
}
