public string AddEditExtraValue(int orgid, string field, string value) { try { var q = from v in Db.OrganizationExtras where v.Field == field where v.OrganizationId == orgid select v; var ev = q.SingleOrDefault(); if (ev == null) { ev = new OrganizationExtra { OrganizationId = orgid, Field = field, }; Db.OrganizationExtras.InsertOnSubmit(ev); } ev.Data = value; Db.SubmitChanges(); return "ok"; } catch (Exception ex) { return ex.Message; } }
public ExtraValue(OrganizationExtra v, ExtraValueModel model) { Type = v.Type; Field = v.Field; StrValue = v.StrValue; DateValue = v.DateValue; Data = v.Data; IntValue = v.IntValue; BitValue = v.BitValue; Id = v.OrganizationId; Model = model; }
public void AddEditExtra(CMSDataContext db, string field, string value, bool multiline = false) { var oev = db.OrganizationExtras.SingleOrDefault(oe => oe.OrganizationId == OrganizationId && oe.Field == field); if (oev == null) { oev = new OrganizationExtra { OrganizationId = OrganizationId, Field = field, }; db.OrganizationExtras.InsertOnSubmit(oev); } oev.Data = value; oev.DataType = multiline ? "text" : null; }
public static OrganizationExtra GetExtraValue(CMSDataContext db, int id, string field) { field = field.Trim(); var q = from v in db.OrganizationExtras where v.Field == field where v.OrganizationId == id select v; var ev = q.SingleOrDefault(); if (ev == null) { ev = new OrganizationExtra { OrganizationId = id, Field = field, TransactionTime = DateTime.Now }; db.OrganizationExtras.InsertOnSubmit(ev); } return(ev); }
public ActionResult AddMESEvent(int id, string mesID) { OrganizationExtra ev; string[] mesEvent = mesID.Split('|'); string name = "ministrEspace:" + mesEvent[0]; ev = (from e in DbUtil.Db.OrganizationExtras where e.Field == name select e).SingleOrDefault(); if (ev == null) { ev = new OrganizationExtra(); ev.OrganizationId = id; ev.Field = name; ev.Data = mesEvent[1]; DbUtil.Db.OrganizationExtras.InsertOnSubmit(ev); } else { ev.Data = mesEvent[1]; } DbUtil.Db.SubmitChanges(); return RedirectToAction("Index", "Org", new { id = id }); }
public OrganizationExtra GetExtraValue(string field) { var ev = OrganizationExtras.AsEnumerable().FirstOrDefault(ee => string.Compare(ee.Field, field, ignoreCase: true) == 0); if (ev == null) { ev = new OrganizationExtra() { OrganizationId = OrganizationId, Field = field, }; OrganizationExtras.Add(ev); } return ev; }
public void AddEditExtra(CMSDataContext Db, string field, string value, bool multiline = false) { var oev = Db.OrganizationExtras.SingleOrDefault(oe => oe.OrganizationId == OrganizationId && oe.Field == field); if (oev == null) { oev = new OrganizationExtra { OrganizationId = OrganizationId, Field = field, }; Db.OrganizationExtras.InsertOnSubmit(oev); } oev.Data = value; oev.DataType = multiline ? "text" : null; }
public static OrganizationExtra GetExtraValue(CMSDataContext db, int id, string field) { //field = field.Replace('/', '-'); var q = from v in db.OrganizationExtras where v.Field == field where v.OrganizationId == id select v; var ev = q.SingleOrDefault(); if (ev == null) { ev = new OrganizationExtra { OrganizationId = id, Field = field, TransactionTime = DateTime.Now }; db.OrganizationExtras.InsertOnSubmit(ev); } return ev; }
public OrganizationExtra GetExtraValue(string field) { var ev = OrganizationExtras.AsEnumerable().FirstOrDefault(ee => ee.Field.Equal(field)); if (ev == null) { ev = new OrganizationExtra() { OrganizationId = OrganizationId, Field = field, }; OrganizationExtras.Add(ev); } return ev; }
private void detach_OrganizationExtras(OrganizationExtra entity) { this.SendPropertyChanging(); entity.Organization = null; }