public ActionResult DeleteConfirmed(int id) { try { Option option = db.Option.Find(id); var opv = db.OptionValue.Where(x => x.OptionID == option.OptionID); foreach (var s in opv) { var set = db.SetValue.Where(x => x.OptionValueID == s.OptionValueID); foreach (var item in set) { var rev = new RevisionHistory(); rev.Action = "Deleted"; rev.CreatedOn = item.ModifiedOn; rev.ModifiedOn = DateTime.Now; rev.ModifiedBy = User.Identity.Name; rev.SystemName = item.OptionValue.Option.Lsystem.LsystemName; rev.Option = item.OptionValue.Option.OptionName; rev.Optionvalue = item.OptionValue.OptionVal; rev.TCSetName = item.TcSet.SetName; rev.SetValueID = item.SetValueID; rev.InitialValue = item.Value; db.RevisionHistory.Add(rev); db.SetValue.Remove(item); } var cv = db.Config_OptionVal.Where(x => x.OptionValueID == s.OptionValueID); foreach (var cvl in cv) db.Config_OptionVal.Remove(cvl); db.OptionValue.Remove(s); } db.Option.Remove(option); db.SaveChanges(); return RedirectToAction("ViewOptions", new { id = option.LsystemID }); } catch { return View("Error"); } }
public ActionResult DeleteConfirmed(int id) { try { LsystemFamily lsystemFamily = db.LsystemFamily.Find(id); var sys = db.Lsystem.Where(x => x.LsystemFamilyID == lsystemFamily.LsystemFamilyID); foreach (var sy in sys) { var cc = db.ConfigurationCollection.Where(x => x.LsystemID == sy.LsystemID); foreach (var c in cc) { var cv = db.Config_OptionVal.Where(x => x.ConfigurationCollectionID == c.ConfigurationCollectionID); foreach (var item in cv) db.Config_OptionVal.Remove(item); db.ConfigurationCollection.Remove(c); } var op = db.Option.Where(x => x.LsystemID == sy.LsystemID); foreach (var o in op) { var opv = db.OptionValue.Where(x => x.OptionID == o.OptionID); foreach (var ov in opv) { var set = db.SetValue.Where(x => x.OptionValueID == ov.OptionValueID); foreach (var item in set) { var rev = new RevisionHistory(); rev.Action = "Deleted"; rev.CreatedOn = item.ModifiedOn; rev.ModifiedOn = DateTime.Now; rev.ModifiedBy = User.Identity.Name; rev.SystemName = item.OptionValue.Option.Lsystem.LsystemName; rev.Option = item.OptionValue.Option.OptionName; rev.Optionvalue = item.OptionValue.OptionVal; rev.TCSetName = item.TcSet.SetName; rev.SetValueID = item.SetValueID; rev.InitialValue = item.Value; db.RevisionHistory.Add(rev); db.SetValue.Remove(item); } db.OptionValue.Remove(ov); } db.Option.Remove(o); } db.Lsystem.Remove(sy); } db.LsystemFamily.Remove(lsystemFamily); db.SaveChanges(); return RedirectToAction("Index"); } catch(Exception e) { ViewBag.Error = e.Message; return View("Error"); } }
public string Edit(SetValue setValue, IPrincipal user=null) { try { var opv = db.OptionValue.FirstOrDefault(x => x.OptionValueID == setValue.OptionValueID); var q1 = db.TcSet.FirstOrDefault(x => x.TcSetID == setValue.TcSetID); if (ModelState.IsValid) { var q = db.TcSet.FirstOrDefault(x => x.TcSetID == setValue.TcSetID); var data = q.DataFormat.FormatType; var precision = q.DataFormat.PrecisionDigits; var scaling = q.DataFormat.ScalingDigits; double val = 0; double value; string valuestring = setValue.Value; bool flag = double.TryParse(setValue.Value, out value); if (setValue.Value != "#" && data != "String" && setValue.Value != "?") { if (!flag) { return "Error"; } if (precision != null && value >= 0) { int precision1 = precision ?? default(int); if (precision != 0) valuestring = Significant(value, precision1); else valuestring = setValue.Value; } else if (scaling != null && value >= 0) { int sca = scaling ?? default(int); valuestring = Scaling(value, sca); } } setValue.Value = valuestring; var original = db.SetValue.Find(setValue.SetValueID); bool modified = original.Value != setValue.Value; if (modified) { //var old = db.RevisionHistory.FirstOrDefault(x => x.SetValueID == setValue.SetValueID); var rev = new RevisionHistory(); rev.CreatedOn = original.ModifiedOn; rev.ModifiedOn = DateTime.Now; rev.ModifiedBy = user.Identity.Name; rev.InitialValue = original.Value; ; rev.Optionvalue = original.OptionValue.OptionVal; rev.TCSetName = original.TcSet.SetName; rev.Option = original.OptionValue.Option.OptionName; rev.SystemName = original.OptionValue.Option.Lsystem.LsystemName; rev.SetValueID = original.SetValueID; rev.ModifiedValue = setValue.Value; rev.Action = "Modified"; db.Entry(original).CurrentValues.SetValues(setValue); db.RevisionHistory.Add(rev); } original.ModifiedOn = DateTime.Now; original.ModifiedBy = user.Identity.Name; db.Entry(original).State = EntityState.Modified; db.Entry(original).Property("CreatedOn").IsModified = false; db.Entry(original).Property("CreatedBy").IsModified = false; db.Entry(original).Property("OptionValueID").IsModified = false; db.Entry(original).Property("TcSetID").IsModified = false; db.SaveChanges(); return "Success"; } return "Error"; } catch (Exception e) { ViewBag.Error = e.Message; return "Error"; } }
public ActionResult EditAll([Bind(Include = "SetValueID,Value,Status,TcSetID,OptionValueID")] List<SetValue> setValue) { try { int ovid1 = setValue[0].OptionValueID; var opv = db.OptionValue.FirstOrDefault(x => x.OptionValueID == ovid1); ViewBag.OptionValue = opv.OptionVal; ViewBag.Option = opv.Option.OptionName; ViewBag.Lsystem = opv.Option.Lsystem.LsystemName; ViewBag.FamilyName = opv.Option.Lsystem.LsystemFamily.FamilyName; ViewBag.id = opv.OptionValueID; int ovid = 0; bool error = false; double val; if (ModelState.IsValid) { for (int i = 0; i < setValue.Count(); i++) { int setid = setValue[i].TcSetID; if (db.TcSet.FirstOrDefault(x => x.TcSetID == setid).DataFormat.FormatType == "Number" && setValue[i].Value != "#" && setValue[i].Value!="?") { if (!double.TryParse(setValue[i].Value, out val)) { error = true; Expression<Func<List<SetValue>, string>> exp = x => x[i].Value; string key = ExpressionHelper.GetExpressionText(exp); ModelState.AddModelError(key, "Value can only be a number or #"); //int sd = setValue[i].OptionValueID; //var ov = db.OptionValue.Include(x => x.Option).FirstOrDefault(x => x.OptionValueID == sd); //var opid = ov.OptionID; //var op = db.Option.Include(x => x.TechnicalCharacteristic).FirstOrDefault(x => x.OptionID == opid); //var tcid = op.TechnicalCharacteristicID; //var tc = db.TechnicalCharacteristic.Include(x => x.TcSets).FirstOrDefault(x => x.TechnicalCharacteristicID == tcid); //var tcset = tc.TcSets; //ViewBag.OptionValueID = new SelectList(db.OptionValue, "OptionValueID", "OptionVal", setValue.OptionValueID); } } } if (error) { int count = setValue.Count(); for (int j = 0; j < count; j++) { int setid = setValue[j].TcSetID; setValue[j].TcSet = db.TcSet.FirstOrDefault(x => x.TcSetID == setid); } return View(setValue); } foreach(var item in setValue) { var original = db.SetValue.Find(item.SetValueID); if(original.Value!=item.Value) { var tcsetid = item.TcSetID; var tcset = db.TcSet.FirstOrDefault(x => x.TcSetID == tcsetid); var dataformat = tcset.DataFormat; var precision = dataformat.PrecisionDigits; var scaling = dataformat.ScalingDigits; string valuestring = item.Value.ToString(); double value; if(dataformat.FormatType!="String"&&item.Value!="#" && item.Value!="?") { bool flag = double.TryParse(item.Value, out value); if (precision != null && value>=0) { int precision1 = precision ?? default(int); if (precision != 0) valuestring = Significant(value, precision1); else valuestring = item.Value; } else if (scaling != null && value>=0) { int sca = scaling ?? default(int); valuestring = Scaling(value, sca); } } item.Value = valuestring; } bool modified = item.Value != original.Value; if (modified) { //var old = db.RevisionHistory.FirstOrDefault(x => x.SetValueID == setValue.SetValueID); var rev = new RevisionHistory(); rev.CreatedOn = original.ModifiedOn; rev.ModifiedOn = DateTime.Now; rev.ModifiedBy = User.Identity.Name; rev.InitialValue = original.Value; ; rev.Optionvalue = original.OptionValue.OptionVal; rev.TCSetName = original.TcSet.SetName; rev.Option = original.OptionValue.Option.OptionName; rev.SystemName = original.OptionValue.Option.Lsystem.LsystemName; rev.SetValueID = original.SetValueID; rev.ModifiedValue = item.Value; rev.Action = "Modified"; db.Entry(original).CurrentValues.SetValues(item); db.RevisionHistory.Add(rev); original.ModifiedOn = DateTime.Now; original.ModifiedBy = User.Identity.Name; db.Entry(original).State = EntityState.Modified; db.Entry(original).Property("CreatedOn").IsModified = false; db.Entry(original).Property("CreatedBy").IsModified = false; db.Entry(original).Property("OptionValueID").IsModified = false; db.Entry(original).Property("TcSetID").IsModified = false; } } db.SaveChanges(); return RedirectToAction("Index", "SetValues", new { id = ovid1 }); } return View(setValue); } catch (Exception e) { ViewBag.Error = e.Message; return View("Error"); } }
public ActionResult Edit([Bind(Include = "SetValueID,Value,Status,TcSetID,OptionValueID,CreatedOn,CreatedBy,ModifiedOn,ModifiedBy")] SetValue setValue) { try { var opv = db.OptionValue.FirstOrDefault(x => x.OptionValueID == setValue.OptionValueID); ViewBag.OptionValue = opv.OptionVal; ViewBag.Option = opv.Option.OptionName; ViewBag.Lsystem = opv.Option.Lsystem.LsystemName; ViewBag.FamilyName = opv.Option.Lsystem.LsystemFamily.FamilyName; ViewBag.id = setValue.OptionValueID; var q1 = db.TcSet.FirstOrDefault(x => x.TcSetID == setValue.TcSetID); ViewBag.TcSet = q1.SetName; if (ModelState.IsValid) { //if (db.SetValue.Any(x => x.TcSetID == setValue.TcSetID && x.OptionValueID == setValue.OptionValueID && x.SetValueID != setValue.SetValueID)) //{ // ModelState.AddModelError("TcSetID", "Property already exists"); // var ov = db.OptionValue.Include(x => x.Option).FirstOrDefault(x => x.OptionValueID == setValue.OptionValueID); // var opid = ov.OptionID; // var op = db.Option.Include(x => x.TechnicalCharacteristic).FirstOrDefault(x => x.OptionID == opid); // var tcid = op.TechnicalCharacteristicID; // var tc = db.TechnicalCharacteristic.Include(x => x.TcSets).FirstOrDefault(x => x.TechnicalCharacteristicID == tcid); // var tcset = tc.TcSets; // //ViewBag.OptionValueID = new SelectList(db.OptionValue, "OptionValueID", "OptionVal", setValue.OptionValueID); // ViewBag.TcSetID = new SelectList(tcset, "TcSetID", "SetName"); // return View(); //} var q = db.TcSet.FirstOrDefault(x => x.TcSetID == setValue.TcSetID); var data = q.DataFormat.FormatType; var precision = q.DataFormat.PrecisionDigits; var scaling = q.DataFormat.ScalingDigits; double val = 0; ViewBag.val = val; double value; string valuestring =setValue.Value; bool flag= double.TryParse(setValue.Value,out value); if (setValue.Value != "#" && data != "String" && setValue.Value != "?") { if(!flag) { ModelState.AddModelError("Value", "Value can only be a number, # or ?"); return View(setValue); } if(precision!=null && value>=0) { int precision1 = precision ?? default(int); if (precision != 0) valuestring = Significant(value, precision1); else valuestring = setValue.Value; } else if(scaling!=null&& value>=0) { int sca = scaling ?? default(int); valuestring = Scaling(value, sca); } } setValue.Value = valuestring; var original = db.SetValue.Find(setValue.SetValueID); bool modified = original.Value != setValue.Value; if (modified) { //var old = db.RevisionHistory.FirstOrDefault(x => x.SetValueID == setValue.SetValueID); var rev = new RevisionHistory(); rev.CreatedOn = original.ModifiedOn; rev.ModifiedOn = DateTime.Now; rev.ModifiedBy = User.Identity.Name; rev.InitialValue = original.Value; ; rev.Optionvalue = original.OptionValue.OptionVal; rev.TCSetName = original.TcSet.SetName; rev.Option = original.OptionValue.Option.OptionName; rev.SystemName = original.OptionValue.Option.Lsystem.LsystemName; rev.SetValueID = original.SetValueID; rev.ModifiedValue = setValue.Value; rev.Action = "Modified"; db.Entry(original).CurrentValues.SetValues(setValue); db.RevisionHistory.Add(rev); } original.ModifiedOn = DateTime.Now; original.ModifiedBy = User.Identity.Name; db.Entry(original).State = EntityState.Modified; db.Entry(original).Property("CreatedOn").IsModified = false; db.Entry(original).Property("CreatedBy").IsModified = false; db.Entry(original).Property("OptionValueID").IsModified = false; db.Entry(original).Property("TcSetID").IsModified = false; db.SaveChanges(); return RedirectToAction("Index", "SetValues", new { id = setValue.OptionValueID }); } ViewBag.OptionValueID = new SelectList(db.OptionValue.OrderBy(x=>x.OptionVal), "OptionValueID", "OptionVal", setValue.OptionValueID); return View(setValue); } catch(Exception e) { ViewBag.Error = e.Message; return View("Error"); } }
public ActionResult copy(int CopyID,int OptionValueID) { try { if (db.UserRight.FirstOrDefault(x => x.UserCode == User.Identity.Name).IsAdmin || db.UserRight.FirstOrDefault(x => x.UserCode == User.Identity.Name).IsEditor) { //if (CopyID == null) //{ // ViewBag.Error = "A null parameter was passed to the function"; // return View("Error"); //} if (CopyID == OptionValueID) { ViewBag.id = OptionValueID; ViewBag.Message = "Cannot copy Option value to itself. Select another Option value to copy"; return View("Empty"); } var ovtobecopied = db.OptionValue.FirstOrDefault(x => x.OptionValueID == CopyID); var ovtobecreated = db.OptionValue.FirstOrDefault(x => x.OptionValueID == OptionValueID); var oldsetval = ovtobecopied.SetValue; if(db.SetValue.Where(x=>x.OptionValueID==OptionValueID).Count()!=0) { ViewBag.id = OptionValueID; ViewBag.Message = "Copy cannot be completed. There are a existing Property values for the Option value you tried to create"; return View("Empty"); } if (!db.SetValue.Any(x => x.OptionValueID == OptionValueID)) { foreach (var item in ovtobecopied.SetValue) { var setVal = new SetValue { OptionValueID = OptionValueID, Value = item.Value, TcSet = item.TcSet, TcSetID = item.TcSetID, OptionValue = db.OptionValue.FirstOrDefault(x => x.OptionValueID == OptionValueID), CreatedBy = User.Identity.Name, ModifiedBy = User.Identity.Name, CreatedOn = DateTime.Now, ModifiedOn = DateTime.Now }; db.SetValue.Add(setVal); var rev = new RevisionHistory(); rev.CreatedOn = setVal.CreatedOn; rev.ModifiedOn = setVal.ModifiedOn; rev.ModifiedBy = setVal.ModifiedBy; rev.Optionvalue = setVal.OptionValue.OptionVal; rev.Option = setVal.OptionValue.Option.OptionName; rev.SystemName = setVal.OptionValue.Option.Lsystem.LsystemName; var p = db.TcSet.FirstOrDefault(x => x.TcSetID == setVal.TcSetID); rev.TCSetName = p.SetName; rev.InitialValue = setVal.Value; rev.ModifiedValue = setVal.Value; ; rev.SetValueID = setVal.SetValueID; rev.Action = "Created"; db.RevisionHistory.Add(rev); db.SaveChanges(); } } return RedirectToAction("Index", "SetValues", new { id = OptionValueID }); } else return View("AuthorizationError"); } catch(Exception e) { ViewBag.Error = e.Message; return View("Error"); } }
public ActionResult DeleteConfirmed(int id) { try { SetValue setValue = db.SetValue.Find(id); var rev = new RevisionHistory(); rev.Action = "Deleted"; rev.CreatedOn = setValue.ModifiedOn; rev.ModifiedOn = DateTime.Now; rev.ModifiedBy = User.Identity.Name; rev.SystemName = setValue.OptionValue.Option.Lsystem.LsystemName; rev.Option = setValue.OptionValue.Option.OptionName; rev.Optionvalue = setValue.OptionValue.OptionVal; rev.TCSetName = setValue.TcSet.SetName; rev.SetValueID = setValue.SetValueID; rev.InitialValue = setValue.Value; db.RevisionHistory.Add(rev); db.SetValue.Remove(setValue); db.SaveChanges(); return RedirectToAction("Index", "SetValues", new { id = setValue.OptionValueID }); } catch(Exception e) { ViewBag.Error = e.Message; return View("Error"); } }
public ActionResult DeleteConfirmed(int id) { try { DataFormat dataFormat = db.DataFormat.Find(id); var tset = db.TcSet.Where(x => x.DataFormatID == dataFormat.DataFormatID); foreach (var s in tset) { var set = db.SetValue.Where(x => x.TcSetID == s.TcSetID); foreach (var item in set) { var rev = new RevisionHistory(); rev.Action = "Deleted"; rev.CreatedOn = item.ModifiedOn; rev.ModifiedOn = DateTime.Now; rev.ModifiedBy = User.Identity.Name; rev.SystemName = item.OptionValue.Option.Lsystem.LsystemName; rev.Option = item.OptionValue.Option.OptionName; rev.Optionvalue = item.OptionValue.OptionVal; rev.TCSetName = item.TcSet.SetName; rev.SetValueID = item.SetValueID; rev.InitialValue = item.Value; db.RevisionHistory.Add(rev); db.SetValue.Remove(item); } db.TcSet.Remove(s); } db.DataFormat.Remove(dataFormat); db.SaveChanges(); return RedirectToAction("Index"); } catch(Exception e) { ViewBag.Error = e.Message; return View("Error"); } }
public ActionResult DeleteConfirmed(int id) { try { TechnicalCharacteristic technicalCharacteristic = db.TechnicalCharacteristic.Find(id); var tset = db.TcSet.Where(x => x.TechnicalCharacteristicID == technicalCharacteristic.TechnicalCharacteristicID); var op = db.Option.Where(x => x.TechnicalCharacteristicID == technicalCharacteristic.TechnicalCharacteristicID); foreach (var o in op) { var opv = db.OptionValue.Where(x => x.OptionID == o.OptionID); foreach (var ov in opv) { var set = db.SetValue.Where(x => x.OptionValueID == ov.OptionValueID); foreach (var item in set) { var rev = new RevisionHistory(); rev.Action = "Deleted"; rev.CreatedOn = item.ModifiedOn; rev.ModifiedOn = DateTime.Now; rev.ModifiedBy = User.Identity.Name; rev.SystemName = item.OptionValue.Option.Lsystem.LsystemName; rev.Option = item.OptionValue.Option.OptionName; rev.Optionvalue = item.OptionValue.OptionVal; rev.TCSetName = item.TcSet.SetName; rev.SetValueID = item.SetValueID; rev.InitialValue = item.Value; db.RevisionHistory.Add(rev); db.SetValue.Remove(item); } var con = db.Config_OptionVal.Where(x => x.OptionValueID == ov.OptionValueID).ToList(); foreach (var c in con) db.Config_OptionVal.Remove(c); db.OptionValue.Remove(ov); } db.Option.Remove(o); } foreach (var s in tset) { var viewprop = db.ViewsProperty.Where(x => x.TcSetID == s.TcSetID); foreach (var vp in viewprop) db.ViewsProperty.Remove(vp); db.TcSet.Remove(s); } db.TechnicalCharacteristic.Remove(technicalCharacteristic); db.SaveChanges(); return RedirectToAction("Index"); } catch(Exception e) { ViewBag.Error = e.Message; return View("Error"); } }