public ActionResult Edit([Bind(Include = "Id,Reason")] PendingReason model)
{
if (ModelState.IsValid)
{
db.Entry(model).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(model));
}
public ActionResult Create([Bind(Include = "Id,Reason")] PendingReason model)
{
if (ModelState.IsValid)
{
db.PendingReasons.Add(model);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(model));
}
private void ImportPendingReasons(SCMContext ctx, ref IEnumerable <ServiceRequestRecord> data)
{
ResetProgress();
var curList = ctx.PendingReasons.Select(x => x.Reason).ToList();
var dic = new Dictionary <string, PendingReason>();
var objects = data.Select(x => new { Reason = x.Pending_Reason }).Distinct().Where(x => !string.IsNullOrEmpty(x.Reason)).ToList();
var objectsToAdd = objects.Where(x => !curList.Contains(x.Reason));
total = objectsToAdd.Count();
foreach (var item in objectsToAdd)
{
var rec = new PendingReason()
{
Reason = item.Reason
};
ctx.PendingReasons.Add(rec);
ctx.SaveChanges();
if (!dic.ContainsKey(rec.Reason.ToUpper()))
{
dic.Add(rec.Reason.ToUpper(), rec);
}
UpdateProgress();
}
foreach (var item in ctx.PendingReasons)
{
if (!dic.ContainsKey(item.Reason.ToUpper()))
{
dic.Add(item.Reason.ToUpper(), item);
}
}
foreach (var item in data)
{
if (!string.IsNullOrEmpty(item.Pending_Reason))
{
item.PendingReasonId = dic[item.Pending_Reason.ToUpper()].Id;
}
else
{
item.PendingReasonId = null;
}
}
Progress = 100;
}
