bool ICRUD <User> .Update(User editObj)
{
bool isok = false;
try
{
using (var db = new TransEntities())
{
User updateUser = db.Users.FirstOrDefault(f => f.UserId == editObj.UserId);
if (updateUser != null)
{
updateUser.FirstName = editObj.FirstName;
updateUser.LastName = editObj.LastName;
updateUser.Email = editObj.Email;
updateUser.IsEnable = editObj.IsEnable;
db.SaveChanges();
}
isok = true;
}
}
catch (System.Exception)
{
throw;
}
return(isok);
}
public bool Update(Entity.LookUp editObj)
{
bool isok = false;
try
{
using (var db = new TransEntities())
{
Entity.LookUp update = db.LookUps.FirstOrDefault(f => f.LookupId == editObj.LookupId);
if (update != null)
{
update.ItemName = editObj.ItemName;
update.ItemId = editObj.ItemId;
update.GroupName = editObj.GroupName;
db.SaveChanges();
}
isok = true;
}
}
catch (System.Exception)
{
throw;
}
return(isok);
}
public List <LookUp> GetGroup(string GroupName)
{
List <LookUp> list = new List <LookUp>();
try
{
using (var db = new TransEntities())
{
list = db.LookUps.Where(f => f.GroupName == GroupName).ToList();
}
}
catch (System.Exception)
{
throw;
}
return(list);
}
public LookUp Select(int id)
{
LookUp obj = null;
try
{
using (var db = new TransEntities())
{
obj = db.LookUps.FirstOrDefault(f => f.LookupId == id);
}
}
catch (System.Exception)
{
throw;
}
return(obj);
}
User ICRUD <User> .Select(int id)
{
User user = null;
try
{
using (var db = new TransEntities())
{
user = db.Users.FirstOrDefault(f => f.UserId == id);
}
}
catch (System.Exception)
{
throw;
}
return(user);
}
public int Create(LookUp newObj)
{
int id = -1;
try
{
using (var db = new TransEntities())
{
db.LookUps.Add(newObj);
db.SaveChanges();
id = newObj.LookupId;
}
}
catch (System.Exception)
{
throw;
}
return(id);
}
int ICRUD <User> .Create(User newObj)
{
int userid = -1;
try
{
using (var db = new TransEntities())
{
db.Users.Add(newObj);
db.SaveChanges();
userid = newObj.UserId;
}
}
catch (System.Exception)
{
throw;
}
return(userid);
}
public bool Delete(int id)
{
bool isok = false;
try
{
using (var db = new TransEntities())
{
LookUp removeObj = db.LookUps.FirstOrDefault(f => f.LookupId == id);
if (removeObj != null)
{
removeObj.IsEnable = true;
db.SaveChanges();
}
isok = true;
}
}
catch (System.Exception)
{
throw;
}
return(isok);
}
bool ICRUD <User> .Delete(int id)
{
bool isok = false;
try
{
using (var db = new TransEntities())
{
User removeUesr = db.Users.FirstOrDefault(f => f.UserId == id);
if (removeUesr != null)
{
db.Users.Remove(removeUesr);
db.SaveChanges();
}
isok = true;
}
}
catch (System.Exception)
{
throw;
}
return(isok);
}
