public ActionResult Edit([Bind(Include = "TemplateID,TemplateName,ParameterCount,Separator,tblResources,tblTemplateParameters")] tblTemplate tblTemplate)
{
string query = "update tblTemplate set TemplateName = '" + tblTemplate.TemplateName + "' where TemplateID = " + tblTemplate.TemplateID + "";
using (SqlConnection conn = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["DefaultConnection"].ConnectionString))
{
conn.Open();
SqlCommand comm = new SqlCommand(query, conn);
comm.ExecuteNonQuery();
conn.Close();
}
return(RedirectToAction("Index"));
}
public ActionResult Create([Bind(Include = "TemplateID,TemplateName,ParameterCount,Separator,tblResources,tblTemplateParameters")] tblTemplate tblTemplate)
{
if (ModelState.IsValid)
{
db.tblTemplates.Add(tblTemplate).CompanyID.Equals(Company);
db.SaveChanges();
DisplaySuccessMessage("Has append a tblTemplate record");
return(RedirectToAction("Index"));
}
DisplayErrorMessage();
return(View(tblTemplate));
}
// GET: Template/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
tblTemplate tblTemplate = db.tblTemplates.Find(id);
if (tblTemplate == null)
{
return(HttpNotFound());
}
return(View(tblTemplate));
}
/// <summary>
/// Saves all changes to the ViewModel
/// </summary>
private void SaveLevel(ObservableCollection <TemplateModel> treeLevel, EDBEntities eDB)
{
try
{
if (treeLevel != null)
{
foreach (var templateItem in treeLevel)
{
if (templateItem.IsNew)
{
tblTemplate NewRec = new tblTemplate();
var Rec = eDB.tblTemplates.Add(NewRec);
Rec.ID = templateItem.ID;
Rec.Parent_ID = templateItem.Parent_ID;
Rec.TemplateName = templateItem.TemplateName;
Rec.Description = templateItem.Description;
Rec.TemplateType_ID = templateItem.TemplateType_ID;
Rec.Project_ID = templateItem.Project_ID;
templateItem.IsNew = false;
}
if (templateItem.IsChanged)
{
tblTemplate Rec = eDB.tblTemplates.Where(o => o.ID == templateItem.ID).FirstOrDefault();
Rec.Parent_ID = templateItem.Parent_ID;
Rec.TemplateName = templateItem.TemplateName;
Rec.Description = templateItem.Description;
Rec.TemplateType_ID = templateItem.TemplateType_ID;
Rec.Project_ID = templateItem.Project_ID;
templateItem.IsChanged = false;
}
// Recursive call
if (templateItem.ChildTemplates != null)
{
SaveLevel(templateItem.ChildTemplates, eDB);
}
}
}
}
catch (Exception ex)
{
RadWindow.Alert(new DialogParameters()
{
Header = "Error",
Content = "Fault while adding/updating to database:\n" + ex.Message
});
}
}
public ActionResult DeleteConfirmed(int id)
{
tblTemplate tblTemplate = db.tblTemplates.Find(id);
//tblResource tblresource = db.tblResources.Where(item => item.TemplateID == id);
//IQueryable<tblResource> tblres = (from p in db.tblResources where p.TemplateID == id select p).AsQueryable();
//db.tblResources.Remove(tblres);
var res = db.tblResources.Where(item => item.TemplateID == id);
foreach (var reso in res)
{
db.tblResources.Remove(reso);
}
db.tblTemplates.Remove(tblTemplate);
db.SaveChanges();
DisplaySuccessMessage("Has delete a tblTemplate record");
return(RedirectToAction("Index"));
}
