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);
}
