public override bool?Update(User obj)
{
using (EvenselPOSEntities context = new EvenselPOSEntities())
{
var query = from n in context.Users
where n.ID == obj.ID
select n;
if (query != null)
{
context.Users.DeleteObject(query.FirstOrDefault());
context.AddToUsers(obj);
return(IsChanged(context.SaveChanges()));
}
return(null);
}
}
public override bool?Update(Sale obj)
{
using (EvenselPOSEntities context = new EvenselPOSEntities())
{
var query = from n in context.Sales
where n.ID == obj.ID
select n;
if (query != null)
{
context.AddToSales(obj);
context.ObjectStateManager.ChangeObjectState(obj, System.Data.EntityState.Modified);
return(IsChanged(context.SaveChanges()));
}
return(null);
}
}
public override bool?Delete(int ID)
{
using (EvenselPOSEntities context = new EvenselPOSEntities())
{
var query = from n in context.Sales
where n.ID == ID
select n;
if (query != null)
{
var selectedObject = query.SingleOrDefault();
context.DeleteObject(selectedObject);
return(IsChanged(context.SaveChanges()));
}
return(null);
}
}
public override Sale GetByID(int ID)
{
using (EvenselPOSEntities context = new EvenselPOSEntities())
{
context.ContextOptions.LazyLoadingEnabled = false;
var query = from n in context.Sales
where n.ID == ID
select n;
if (query != null)
{
return(query.SingleOrDefault());
}
}
return(null);
}
/// <summary>
/// Update Customer Details
/// </summary>
/// <param name="obj">New Customer Object</param>
/// <returns>Return true if suceed else retrun false, If Customer Not Found Return null</returns>
public override bool?Update(Customer obj)
{
using (EvenselPOSEntities context = new EvenselPOSEntities())
{
//var query = from i in context.Customers
// where i.ID == obj.ID
// select i;
//if (query != null)
//{
context.AddToCustomers(obj);
context.ObjectStateManager.ChangeObjectState(obj, System.Data.EntityState.Modified);
return(IsChanged(context.SaveChanges()));
//}
//return null;
}
}
public override bool?Update(Gift obj)
{
using (EvenselPOSEntities context = new EvenselPOSEntities())
{
var query = from n in context.Gifts
where n.ID == obj.ID
select n;
if (query != null)
{
var gift = query.SingleOrDefault();
gift.GiftNumber = obj.GiftNumber;
gift.Value = obj.Value;
return(IsChanged(context.SaveChanges()));
}
return(null);
}
}
/// <summary>
/// User Authentcation and retrive the level of roles assigned to the user
/// </summary>
/// <param name="username">UserName</param>
/// <param name="password">Password</param>
/// <returns>Return List of Role</returns>
public List <Role> UserAuthentication(string username, string password)
{
using (EvenselPOSEntities context = new EvenselPOSEntities())
{
List <Role> UsersroleList = new List <Role>();
var usrId = from n in context.Users
where n.UserName == username && n.Password == password
select n.ID;
if (usrId.Count() != 0)
{
var roleIds = from n in context.UserRoles
where n.UserID == usrId.FirstOrDefault()
select n.RoleID;
if (roleIds.Count() != 0)
{
foreach (var id in roleIds)
{
var usrRole = from n in context.Roles
where n.ID == id
select n;
if (usrRole != null)
{
UsersroleList.Add((Role)usrRole.FirstOrDefault());
}
}
return(UsersroleList);
}
}
}
return(null);
}
