public static Identity GetData(int id) { using (rapidInfoEntities context = new rapidInfoEntities()) { return(context.Identities.FirstOrDefault(m => m.Id == id)); } }
public static Identity GetData(string name) { using (rapidInfoEntities context = new rapidInfoEntities()) { return(context.Identities.FirstOrDefault(m => m.Name.Replace(" ", "").ToLower() == name.Replace(" ", "").ToLower())); } }
public static List <Area> GetData() { using (rapidInfoEntities context = new rapidInfoEntities()) { return(context.Areas.ToList()); } }
public static List <Identity> GetData() { using (rapidInfoEntities context = new rapidInfoEntities()) { return(context.Identities.ToList()); } }
public static List <Area> GetDataByParent(int ParentId) { using (rapidInfoEntities context = new rapidInfoEntities()) { return(context.Areas.Where(m => m.ParentId == ParentId).ToList()); } }
public static List <Area> GetData(string term) { using (rapidInfoEntities context = new rapidInfoEntities()) { return(context.Areas.Where(m => m.Name.ToLower().StartsWith(term.ToLower()) || m.Name.ToLower().Contains(term.ToLower())).ToList()); } }
public static List <AreaLink> GetDataByArea(int areaId) { using (rapidInfoEntities context = new rapidInfoEntities()) { return(context.AreaLinks.Where(m => m.AreaId == areaId).ToList()); } }
public AreaLink Save() { try { using (rapidInfoEntities context = new rapidInfoEntities()) { var temp = context.AreaLinks.FirstOrDefault(m => m.AreaId == AreaId && m.IdentityId == IdentityId); context.AddToAreaLinks(this); context.SaveChanges(); //Message = "Successfully Updated"; } } catch (Exception ex) { //Message += ex.Message; } return(this); }
public AreaLink Delete() { try { using (rapidInfoEntities context = new rapidInfoEntities()) { var temp = context.AreaLinks.FirstOrDefault(m => m.AreaId == AreaId && m.IdentityId == IdentityId); context.AreaLinks.Attach(this); context.AreaLinks.DeleteObject(this); context.SaveChanges(); } } catch (Exception ex) { } return(this); }
public Identity Save() { try { using (rapidInfoEntities context = new rapidInfoEntities()) { var temp = context.Identities.FirstOrDefault(m => m.Id == Id); Boolean IsNew = temp == null ? true : false; if (Id == 0) { Id = 1; try { Id = context.Identities.Max(m => m.Id) + 1; } catch { } IsNew = true; } LUDate = DateTime.Now; if (IsNew) { context.AddToIdentities(this); } else { if (temp != null) { context.CreateObjectSet <Identity>().Detach(temp); } context.CreateObjectSet <Identity>().Attach(this); context.ObjectStateManager.ChangeObjectState(this, EntityState.Modified); } context.SaveChanges(); //Message = "Successfully Updated"; } } catch (Exception ex) { //Message += ex.Message; } return(this); }