public ActionResult DeleteConfirmedPackageTable(int id)
{
app_package_table app_package_table = db.app_package_table.Where(x => x.id == id).FirstOrDefault();
db.app_package_table.Remove(app_package_table);
db.SaveChanges();
int packageid = Convert.ToInt32(app_package_table.level_id);
return(RedirectToAction("EditPackage", new { id = packageid }));
//return RedirectToAction("Index");
}
public ActionResult EditPackageTable([Bind(Include = "id,level_id,table_id,relation_type")] app_package_table app_package_table)
{
if (ModelState.IsValid)
{
db.Entry(app_package_table).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.level_id = new SelectList(db.app_package, "level_id", "package_name", app_package_table.level_id);
ViewBag.table_id = new SelectList(db.app_table, "id", "tab_schema", app_package_table.table_id);
return(View(app_package_table));
}
// GET: Test/Delete/5
public ActionResult DeletePackageTable(int id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
app_package_table app_package_table = db.app_package_table.Where(x => x.id == id).FirstOrDefault();
if (app_package_table == null)
{
return(HttpNotFound());
}
return(View(app_package_table));
}
// GET: Test/Details/5
public ActionResult Details(decimal id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
app_package_table app_package_table = db.app_package_table.Find(id);
if (app_package_table == null)
{
return(HttpNotFound());
}
return(View(app_package_table));
}
// GET: Test/Edit/5
public ActionResult EditPackageTable(decimal id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
app_package_table app_package_table = db.app_package_table.Find(id);
if (app_package_table == null)
{
return(HttpNotFound());
}
ViewBag.level_id = new SelectList(db.app_package, "level_id", "package_name", app_package_table.level_id);
ViewBag.table_id = new SelectList(db.app_table, "id", "tab_schema", app_package_table.table_id);
return(View(app_package_table));
}
//public ActionResult CreatePackageTable([Bind(Include = "id,level_id,table_id,relation_type")] app_package_table app_package_table)
public ActionResult CreatePackageTable(int packageid, int[] table_id_source, int[] table_id_target, int[] table_id_db2, int[] table_id_procedure)
{
if (ModelState.IsValid)
{
//db.app_package_table.Add(app_package_table);
Decimal levelId = Convert.ToDecimal(packageid);
var existing_tables = db.app_package_table.Where(x => x.level_id == levelId).ToList();
List <int> existing_table_ids = new List <int>();
foreach (var et in existing_tables)
{
existing_table_ids.Add(et.table_id);
}
if (table_id_source != null)
{
foreach (var i in table_id_source)
{
if (!existing_table_ids.Contains(i))
{
app_package_table app = new app_package_table {
level_id = levelId, relation_type = (int)Enumerations.RelationTypeEnum.Source, table_id = i
};
db.app_package_table.Add(app);
}
}
}
if (table_id_target != null)
{
foreach (var i in table_id_target)
{
if (!existing_table_ids.Contains(i))
{
app_package_table app = new app_package_table {
level_id = levelId, relation_type = (int)Enumerations.RelationTypeEnum.Target, table_id = i
};
db.app_package_table.Add(app);
}
}
}
if (table_id_db2 != null)
{
foreach (var i in table_id_db2)
{
if (!existing_table_ids.Contains(i))
{
app_package_table app = new app_package_table {
level_id = levelId, relation_type = (int)Enumerations.RelationTypeEnum.DB2, table_id = i
};
db.app_package_table.Add(app);
}
}
}
if (table_id_procedure != null)
{
foreach (var i in table_id_procedure)
{
if (!existing_table_ids.Contains(i))
{
app_package_table app = new app_package_table {
level_id = levelId, relation_type = (int)Enumerations.RelationTypeEnum.PROCEDURE_DB2, table_id = i
};
db.app_package_table.Add(app);
}
}
}
db.SaveChanges();
//int packageid = Convert.ToInt32(app_package_table.level_id);
return(RedirectToAction("EditPackage", new { id = packageid }));
}
//ViewBag.level_id = new SelectList(db.app_package, "level_id", "package_name", app_package_table.level_id);
//ViewBag.table_id = new SelectList(db.app_table, "id", "name", app_package_table.table_id);
ViewBag.table_id_target = new SelectList(db.app_table.Where(x => x.tab_type == "vrp"), "id", "name");
ViewBag.table_id_source = new SelectList(db.app_table.Where(x => x.tab_type == "core"), "id", "name");
ViewBag.table_id_db2 = new SelectList(db.app_table.Where(x => x.is_db2 == true && x.is_procedure == false), "id", "name");
ViewBag.table_id_procedure = new SelectList(db.app_table.Where(x => x.is_procedure), "id", "name");
//return View(app_package_table);
return(View());
}
