public ActionResult Edit([FromBody] ServiceTreeModel model)
{
//validation
var result = db.ServiceTrees.Where(x => x.ServiceTreeId == model.ServiceTreeId).FirstOrDefault();
if (result == null)
{
return(BadRequest());
}
//result = model;
result.Title = model.Title;
result.ReginalPowerCorpRef = model.ReginalPowerCorpRef;
result.ServiceTemplateTreeRef = model.ServiceTemplateTreeRef;
result.Level = model.Level;
result.Code = model.Code;
result.State = model.State;
result.Description = model.Description;
db.Update(result);
db.SaveChanges();
//db.Entry(model).State = EntityState.Modified;
//var affectedRow = db.SaveChanges();
return(Ok());
}
public ActionResult CreateAsChild(int id, string level)
{
//var result = AllItems.Where(x => x.ProjectTreeId == id).Select( s=>new { s.Title ,s.ReginalPowerCorpRef,s.ProjectTreeRef, ReginalPowerCorpTitle=s.ReginalPowerCorp.Title, ProjectParent=s.ProjectTree.Title,s.LevelCode,s.Code,s.IsTemplate,s.State});
new ServiceTreeModel();
var result = new ServiceTreeModel {
ServiceTemplateTreeRef = id, Level = level
};
return(Ok(result));
}
public ActionResult Delete([FromBody] ServiceTreeModel model)
{
//validation
var result = AllItems.Where(x => x.ServiceTreeId == model.ServiceTreeId).FirstOrDefault();
if (result == null)
{
return(BadRequest());
}
db.Remove(result);
db.SaveChanges();
return(Ok());
}
public ActionResult Create([FromBody] ServiceTreeModel model)
{
//validation
if (ModelState.IsValid)
{
model.LevelCode = model.LevelCode + "-" + model.Level;
if (model.ServiceTemplateTreeRef == 0)
{
model.ServiceTemplateTreeRef = null;
}
db.Add(model);
db.SaveChanges();
}
return(Ok());
}
public void InserTempTree(int?ServiceTemplateTreeRef, int ProjectInfoRef, int parentServiceRef = 0)
{
if (parentServiceRef == 0)
{
var i = new ServiceTreeModel();
var ModservicetempTree = db.ServiceTemplateTrees.Where(w => w.ServiceTemplateTreeId == ServiceTemplateTreeRef).First();
i.Title = ModservicetempTree.Title;
i.ServiceTemplateTreeRef = ModservicetempTree.ServiceTemplateTreeId;
i.ProjectInfoRef = ProjectInfoRef;
db.Add(i);
db.SaveChanges();
int serviceId = i.ServiceTreeId;
InserTempTree(ServiceTemplateTreeRef, ProjectInfoRef, serviceId);
}
else
{
var ModservicetempTree = db.ServiceTemplateTrees.Where(w => w.ServiceTemplateTreeRef == ServiceTemplateTreeRef).ToList();
foreach (var a in ModservicetempTree)
{
var i = new ServiceTreeModel();
i.Title = a.Title;
i.ServiceTreeRef = parentServiceRef;
i.ServiceTemplateTreeRef = a.ServiceTemplateTreeId;
i.ProjectInfoRef = ProjectInfoRef;
db.Add(i);
db.SaveChanges();
int serviceId = i.ServiceTreeId;
ServiceTemplateTreeRef = a.ServiceTemplateTreeId;
InserTempTree(ServiceTemplateTreeRef, ProjectInfoRef, serviceId);
}
}
}
