public List <ModelBookStore.UserItem> Search(ModelBookStore.UserItem objModelUserItem)
{
var UserItemlist = (from objItems in TBSEntities.UserItems
where objItems.id == objModelUserItem.id && objItems.UserId == objModelUserItem.UserId
select objItems
//select new Role { id = objItems.id, UserId = objItems.Name }
).ToList();
ModelBookStore.UserItem ModlelUsertemObj;
List <ModelBookStore.UserItem> objlist = new List <ModelBookStore.UserItem>();
foreach (var Useritem in UserItemlist)
{
ModlelUsertemObj = new ModelBookStore.UserItem();
ModlelUsertemObj.id = Useritem.id;
ModlelUsertemObj.UserId = Convert.ToInt32(Useritem.UserId);
ModlelUsertemObj.ItemId = Convert.ToInt32(Useritem.ItemId);
ModlelUsertemObj.DateOfPurchase = Convert.ToDateTime(Useritem.DateOfPurchase);
ModlelUsertemObj.NoOfItems = Convert.ToInt32(Useritem.NoOfItems);
objlist.Add(ModlelUsertemObj);
}
return(objlist);
}
public void Delete(ModelBookStore.UserItem objModelUserItem)
{
UserItem _SelectUserItemToDeleteRow = TBSEntities.UserItems.Where(x => x.id == objModelUserItem.id).Select(x => x).FirstOrDefault();
TBSEntities.UserItems.Remove(_SelectUserItemToDeleteRow);
TBSEntities.SaveChanges();
}
public void Add(ModelBookStore.UserItem objModelUserItem)
{
UserItem objUserItem = new UserItem()
{
UserId = objModelUserItem.UserId,
DateOfPurchase = objModelUserItem.DateOfPurchase,
ItemId = objModelUserItem.ItemId,
NoOfItems = objModelUserItem.NoOfItems,
DiscAmmount = objModelUserItem.DiscAmmount,
NetAmount = objModelUserItem.NetAmount
};
TBSEntities.UserItems.Add(objUserItem);
TBSEntities.SaveChanges();
}
public List <ModelBookStore.UserItem> Load()
{
var UserItemlist = (from objUserItems in TBSEntities.UserItems
join objCustomer in TBSEntities.UserDetails on objUserItems.UserId equals objCustomer.id
join objItem in TBSEntities.Items on objUserItems.ItemId equals objItem.id
// select objUserItems
select new
{
id = objUserItems.id,
UserId = objUserItems.UserId,
ItemId = objUserItems.ItemId,
CustomerName = objCustomer.FirstName,
ItemName = objItem.Name,
DateOfPurchase = objUserItems.DateOfPurchase,
NoOfItems = objUserItems.NoOfItems,
DiscAmmount = objUserItems.DiscAmmount,
NetAmount = objUserItems.NetAmount
}
).ToList();
ModelBookStore.UserItem ModlelUsertemObj;
List <ModelBookStore.UserItem> objlist = new List <ModelBookStore.UserItem>();
foreach (var UseritemLst in UserItemlist)
{
ModlelUsertemObj = new ModelBookStore.UserItem();
ModlelUsertemObj.id = UseritemLst.id;
ModlelUsertemObj.UserId = Convert.ToInt32(UseritemLst.UserId);
ModlelUsertemObj.ItemId = Convert.ToInt32(UseritemLst.ItemId);
ModlelUsertemObj.CustomerName = UseritemLst.CustomerName;
ModlelUsertemObj.ItemName = UseritemLst.ItemName;
ModlelUsertemObj.DateOfPurchase = Convert.ToDateTime(UseritemLst.DateOfPurchase);
ModlelUsertemObj.NoOfItems = Convert.ToInt32(UseritemLst.NoOfItems);
ModlelUsertemObj.DiscAmmount = Convert.ToDecimal(UseritemLst.DiscAmmount);
ModlelUsertemObj.NetAmount = Convert.ToDecimal(UseritemLst.NetAmount);
objlist.Add(ModlelUsertemObj);
}
return(objlist);
}
public void Update(ModelBookStore.UserItem objModelUserItem)
{
UserItem _SelectUserItemrow = TBSEntities.UserItems.Where(x => x.id == objModelUserItem.id).Select(x => x).FirstOrDefault();
if (_SelectUserItemrow == null)
{
Add(objModelUserItem);
}
else
{
_SelectUserItemrow.ItemId = objModelUserItem.ItemId;
_SelectUserItemrow.UserId = objModelUserItem.UserId;
_SelectUserItemrow.DateOfPurchase = objModelUserItem.DateOfPurchase;
_SelectUserItemrow.DiscAmmount = objModelUserItem.DiscAmmount;
_SelectUserItemrow.NetAmount = objModelUserItem.NetAmount;
_SelectUserItemrow.NoOfItems = objModelUserItem.NoOfItems;
TBSEntities.SaveChanges();
}
}
