// GET: DIM_FIELD/Edit/5
public ActionResult Edit(string CONFIG_COMMON_NAME, string DIM_COMMON_NAME, string DIM_FIELD_NAME, string DIM_FIELD_FEATURE, string SelectedClient)
{
DIM_FIELD dIM_FIELD = db.DIM_FIELD.Find(CONFIG_COMMON_NAME, DIM_COMMON_NAME, DIM_FIELD_NAME);
if (dIM_FIELD == null)
{
return(HttpNotFound());
}
var features = db.BITWISE_DICTIONARY
.Where(f => f.BITWISE_GROUP == "DIM_FIELDS")
.ToList()
.Select(c => new
{
DIM_FIELD_FEATURE = c.BITWISE_KEY,
DESCR = string.Format("{0} -- {1}", c.BITWISE_KEY, c.DESCR)
});
ViewBag.listFeatures = new MultiSelectList(features, "DIM_FIELD_FEATURE", "DESCR", dIM_FIELD.SelectedItems);
ViewBag.CONFIG_COMMON_NAME = new SelectList(db.CONFIGs, "CONFIG_COMMON_NAME", "CONFIG_DATA_PROCESS_PROC_SCHEMA", dIM_FIELD.CONFIG_COMMON_NAME);
ViewBag.DIM_COMMON_NAME = new SelectList(db.DIMs, "DIM_COMMON_NAME", "DIM_COMMON_NAME", dIM_FIELD.DIM_COMMON_NAME);
TempData["SelectedClient"] = SelectedClient;
return(View(dIM_FIELD));
}
public ActionResult Edit(string CONFIG_COMMON_NAME, string DIM_COMMON_NAME, string DIM_FIELD_NAME, string DIM_FIELD_FEATURE)
{
DIM_FIELD dIM_FIELD = db.DIM_FIELD.Find(CONFIG_COMMON_NAME, DIM_COMMON_NAME, DIM_FIELD_NAME);
if (dIM_FIELD == null)
{
return(HttpNotFound());
}
var features = db.BITWISE_DICTIONARY
.Where(f => f.BITWISE_GROUP == "DIM_FIELDS")
.ToList()
.Select(c => new
{
DIM_FIELD_FEATURE = c.BITWISE_KEY,
DESCR = string.Format("{0} -- {1}", c.BITWISE_KEY, c.DESCR)
});
var dims = db.DIMs
.Where(f => f.CONFIG_COMMON_NAME == CONFIG_COMMON_NAME)
.ToList();
SelectList datatypes = new SelectList(db.vDATA_TYPES, "DIM_DATA_TYPE", "DIM_DATA_TYPE", dIM_FIELD.DIM_DATA_TYPE);
ViewBag.DIM_COMMON_NAME = new SelectList(dims, "DIM_COMMON_NAME", "DIM_COMMON_NAME", dIM_FIELD.DIM_COMMON_NAME);
ViewBag.DIM_DATA_TYPE = datatypes;
ViewBag.listFeatures = new MultiSelectList(features, "DIM_FIELD_FEATURE", "DESCR", dIM_FIELD.SelectedItems);
return(View(dIM_FIELD));
}
public ActionResult DeleteConfirmed(string CONFIG_COMMON_NAME, string DIM_COMMON_NAME, string DIM_FIELD_NAME)
{
DIM_FIELD dIM_FIELD = db.DIM_FIELD.Find(CONFIG_COMMON_NAME, DIM_COMMON_NAME, DIM_FIELD_NAME);
db.DIM_FIELD.Remove(dIM_FIELD);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult DeleteConfirmed(string id)
{
DIM_FIELD dIM_FIELD = db.DIM_FIELD.Find(id);
db.DIM_FIELD.Remove(dIM_FIELD);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Details(string CONFIG_COMMON_NAME, string DIM_COMMON_NAME, string DIM_FIELD_NAME)
{
DIM_FIELD dIM_FIELD = db.DIM_FIELD.Find(CONFIG_COMMON_NAME, DIM_COMMON_NAME, DIM_FIELD_NAME);
if (dIM_FIELD == null)
{
return(HttpNotFound());
}
return(View(dIM_FIELD));
}
public ActionResult Create([Bind(Include = "CONFIG_COMMON_NAME,DIM_COMMON_NAME,DIM_FIELD_NAME,DIM_FIELD_NAME_CLEAN,DIM_DATA_TYPE,DIM_FIELD_FEATURE,DERIVED_CONFIGURATION")] DIM_FIELD dIM_FIELD)
{
if (ModelState.IsValid)
{
db.DIM_FIELD.Add(dIM_FIELD);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.CONFIG_COMMON_NAME = new SelectList(db.DIMs, "CONFIG_COMMON_NAME", "DIM_TABLE_SCHEMA", dIM_FIELD.CONFIG_COMMON_NAME);
ViewBag.DIM_FIELD_FEATURE = new SelectList(db.BITWISE_DICTIONARY, "DIM_FIELD_FEATURE", "BITWISE_KEY", dIM_FIELD.DIM_FIELD_FEATURE);
return(View(dIM_FIELD));
}
public ActionResult Create([Bind(Include = "CONFIG_COMMON_NAME,DIM_COMMON_NAME,DIM_FIELD_NAME,DIM_FIELD_NAME_CLEAN,DIM_DATA_TYPE,DIM_FIELD_FEATURE,DERIVED_CONFIGURATION")] DIM_FIELD dIM_FIELD, string[] SelectedItems, string CONFIG_COMMON_NAME, string DIM_COMMON_NAME, string DIM_FIELD_NAME)
{
dIM_FIELD.CONFIG_COMMON_NAME = Session["sClient"].ToString();
if (SelectedItems != null)
{
if (SelectedItems.Count() > 1)
{
dIM_FIELD.DIM_FIELD_FEATURE = String.Join(",", SelectedItems);
}
else
{
dIM_FIELD.DIM_FIELD_FEATURE = SelectedItems[0];
}
}
if (dIM_FIELD.DIM_FIELD_FEATURE != null)
{
int Total = 0;
var settings = db.BITWISE_DICTIONARY
.Where(f => f.BITWISE_GROUP == "DIM_FIELDS" && SelectedItems.Contains(f.BITWISE_KEY))
.Sum(x => x.BITWISE_VALUE);
Total = (int)settings;
//validate sum
bool exists = db.BITWISE_DICTIONARY_VALID_VALUES.Any(a => a.BITWISE_VALUE == Total && a.BITWISE_GROUP == "DIM_FIELDS");
if (!exists)
{
ModelState.AddModelError(String.Empty, "Cannot create due to selection of invalid features.");
return(RedirectToAction("Create"));
}
}
if (ModelState.IsValid)
{
try
{
db.DIM_FIELD.Add(dIM_FIELD);
db.SaveChanges();
}
catch (Exception ex)
{
ModelState.AddModelError(String.Empty, ex.InnerException.InnerException.Message);
return(RedirectToAction("Create", new { CONFIG_COMMON_NAME, DIM_COMMON_NAME, DIM_FIELD_NAME }));
}
//db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(dIM_FIELD));
}
// GET: DIM_FIELD/Details/5
public ActionResult Details(string CONFIG_COMMON_NAME, string DIM_COMMON_NAME, string DIM_FIELD_NAME)
{
//if (id == null)
//{
// return new HttpStatusCodeResult(HttpStatusCode.BadRequest);
//}
DIM_FIELD dIM_FIELD = db.DIM_FIELD.Find(CONFIG_COMMON_NAME, DIM_COMMON_NAME, DIM_FIELD_NAME);
if (dIM_FIELD == null)
{
return(HttpNotFound());
}
return(View(dIM_FIELD));
}
// GET: DIM_FIELD/Delete/5
public ActionResult Delete(string id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
DIM_FIELD dIM_FIELD = db.DIM_FIELD.Find(id);
if (dIM_FIELD == null)
{
return(HttpNotFound());
}
return(View(dIM_FIELD));
}
public ActionResult Edit([Bind(Include = "CONFIG_COMMON_NAME,DIM_COMMON_NAME,DIM_FIELD_NAME,DIM_FIELD_NAME_CLEAN,DIM_DATA_TYPE,DIM_FIELD_FEATURE,DERIVED_CONFIGURATION")] DIM_FIELD dIM_FIELD, string[] SelectedItems)
{
if (SelectedItems != null)
{
if (SelectedItems.Count() > 1)
{
dIM_FIELD.DIM_FIELD_FEATURE = String.Join(",", SelectedItems);
}
else
{
dIM_FIELD.DIM_FIELD_FEATURE = SelectedItems[0];
}
}
int Total = 0;
//var settings = db.BITWISE_DICTIONARY.Where(a => SelectedItems.Contains(a.BITWISE_KEY) && a.BITWISE_GROUP == "DIM_FIELDS");
var settings = db.BITWISE_DICTIONARY
.Where(f => f.BITWISE_GROUP == "DIM_FIELDS" && SelectedItems.Contains(f.BITWISE_KEY))
.Sum(x => x.BITWISE_VALUE);
Total = (int)settings;
//validate sum
bool exists = db.BITWISE_DICTIONARY_VALID_VALUES.Any(a => a.BITWISE_VALUE == Total && a.BITWISE_GROUP == "DIM_FIELDS");
if (!exists)
{
var features = db.BITWISE_DICTIONARY
.Where(f => f.BITWISE_GROUP == "DIM_FIELDS")
.ToList()
.Select(c => new
{
DIM_FIELD_FEATURE = c.BITWISE_KEY,
DESCR = string.Format("{0} -- {1}", c.BITWISE_KEY, c.DESCR)
});
ViewBag.DIM_COMMON_NAME = new SelectList(db.DIMs, "DIM_COMMON_NAME", "DIM_COMMON_NAME", dIM_FIELD.DIM_COMMON_NAME);
ViewBag.listFeatures = new MultiSelectList(features, "DIM_FIELD_FEATURE", "DESCR", dIM_FIELD.SelectedItems);
ViewBag.DIM_DATA_TYPE = new SelectList(db.vDATA_TYPES, "DIM_DATA_TYPE", "DIM_DATA_TYPE");
//throw error
ModelState.AddModelError(String.Empty, "Cannot create due to selection of invalid features.");
return(RedirectToAction("Edit", new { CONFIG_COMMON_NAME = Request["CONFIG_COMMON_NAME"].ToString(), DIM_COMMON_NAME = Request["DIM_COMMON_NAME"].ToString(), DIM_FIELD_NAME = Request["DIM_FIELD_NAME"].ToString() }));
}
if (ModelState.IsValid)
{
string DIM_COMMON_NAME = Request["DIM_COMMON_NAME"].ToString();
string CONFIG_COMMON_NAME = Request["CONFIG_COMMON_NAME"].ToString();
string DIM_FIELD_NAME = Request["DIM_FIELD_NAME"].ToString();
if (DIM_COMMON_NAME != dIM_FIELD.DIM_COMMON_NAME || CONFIG_COMMON_NAME != dIM_FIELD.CONFIG_COMMON_NAME || DIM_FIELD_NAME != dIM_FIELD.DIM_FIELD_NAME)
{
var fields = db.DIM_FIELD.Where(a => a.DIM_COMMON_NAME == DIM_COMMON_NAME && a.CONFIG_COMMON_NAME == CONFIG_COMMON_NAME && a.DIM_FIELD_NAME == DIM_FIELD_NAME);
foreach (var f in fields)
{
db.DIM_FIELD.Remove(f);
}
db.DIM_FIELD.Add(dIM_FIELD);
}
else
{
db.Entry(dIM_FIELD).State = EntityState.Modified;
}
try
{
db.SaveChanges();
}
catch (Exception ex)
{
ModelState.AddModelError(String.Empty, ex.InnerException.InnerException.Message);
return(RedirectToAction("Edit", new { CONFIG_COMMON_NAME, DIM_COMMON_NAME, DIM_FIELD_NAME }));
}
return(RedirectToAction("Index"));
}
return(View(dIM_FIELD));
}
public ActionResult Edit([Bind(Include = "CONFIG_COMMON_NAME,DIM_COMMON_NAME,DIM_FIELD_NAME,DIM_FIELD_NAME_CLEAN,DIM_DATA_TYPE,DIM_FIELD_FEATURE,DERIVED_CONFIGURATION")] DIM_FIELD dIM_FIELD, string[] SelectedItems, string SelectedClient, string old_DIM_COMMON_NAME)
{
if (SelectedItems != null)
{
if (SelectedItems.Count() > 1)
{
dIM_FIELD.DIM_FIELD_FEATURE = String.Join(",", SelectedItems);
}
else
{
dIM_FIELD.DIM_FIELD_FEATURE = SelectedItems[0];
}
}
int Total = 0;
//var settings = db.BITWISE_DICTIONARY.Where(a => SelectedItems.Contains(a.BITWISE_KEY) && a.BITWISE_GROUP == "DIM_FIELDS");
var settings = db.BITWISE_DICTIONARY
.Where(f => f.BITWISE_GROUP == "DIM_FIELDS" && SelectedItems.Contains(f.BITWISE_KEY))
.Sum(x => x.BITWISE_VALUE);
Total = (int)settings;
//validate sum
bool exists = db.BITWISE_DICTIONARY_VALID_VALUES.Any(a => a.BITWISE_VALUE == Total && a.BITWISE_GROUP == "DIM_FIELDS");
if (!exists)
{
//throw error
//return Json(new { success = false, responseText = "The selected combination of Features is not supported." }, JsonRequestBehavior.AllowGet);
ViewBag.DIM_COMMON_NAME = new SelectList(db.DIMs, "DIM_COMMON_NAME", "DIM_COMMON_NAME", dIM_FIELD.DIM_COMMON_NAME);
var features = db.BITWISE_DICTIONARY
.Where(f => f.BITWISE_GROUP == "DIM_FIELDS")
.ToList()
.Select(c => new
{
DIM_FIELD_FEATURE = c.BITWISE_KEY,
DESCR = string.Format("{0} -- {1}", c.BITWISE_KEY, c.DESCR)
});
ViewBag.listFeatures = new MultiSelectList(features, "DIM_FIELD_FEATURE", "DESCR", dIM_FIELD.SelectedItems);
TempData["FeaturesInvalid"] = true;
//TempData["SelectedClient"] = SelectedClient;
return(View(dIM_FIELD));
}
//ViewBag.SelectedClient = SelectedClient;
if (ModelState.IsValid)
{
string DIM_COMMON_NAME = Request["DIM_COMMON_NAME"].ToString();
string CONFIG_COMMON_NAME = Request["CONFIG_COMMON_NAME"].ToString();
string DIM_FIELD_NAME = Request["DIM_FIELD_NAME"].ToString();
var fields = db.DIM_FIELD.Where(a => a.DIM_COMMON_NAME == DIM_COMMON_NAME && a.CONFIG_COMMON_NAME == CONFIG_COMMON_NAME && a.DIM_FIELD_NAME == DIM_FIELD_NAME);
foreach (var f in fields)
{
db.DIM_FIELD.Remove(f);
}
db.DIM_FIELD.Add(dIM_FIELD);
try
{
db.SaveChanges();
}
catch
{
return(RedirectToAction("Index"));
}
db.Entry(dIM_FIELD).State = EntityState.Modified;
TempData["SelectedClient"] = SelectedClient;
return(RedirectToAction("Index"));
}
return(View(dIM_FIELD));
}
