public List <ModelBookStore.UserDetail> SearchCustomer()
{
var CustomerList = (from objItems in TBSEntities.UserDetails
select objItems
//select new Role { id = objItems.id, UserId = objItems.Name }
).ToList();
ModelBookStore.UserDetail ModelCustomerObj;
List <ModelBookStore.UserDetail> objlist = new List <ModelBookStore.UserDetail>();
foreach (var item in CustomerList)
{
ModelCustomerObj = new ModelBookStore.UserDetail();
ModelCustomerObj.id = item.id;
ModelCustomerObj.UserId = Convert.ToInt32(item.UserId);
ModelCustomerObj.FirstName = item.FirstName;
ModelCustomerObj.LastName = item.LastName;
ModelCustomerObj.DOB = item.DOB;
ModelCustomerObj.PhoneNumber = item.PhoneNumber;
ModelCustomerObj.EmailId = item.EmailId;
ModelCustomerObj.Address = item.Address;
ModelCustomerObj.city = item.city;
ModelCustomerObj.state = item.state;
ModelCustomerObj.IsMembership = item.IsMembership;
objlist.Add(ModelCustomerObj);
}
return(objlist);
}
public List <ModelBookStore.UserDetail> LoadCustBDay()
{
var UserDetaillist = TBSEntities.usp_UpCmgBdayCust();
ModelBookStore.UserDetail ModlelUserDetailObj;
List <ModelBookStore.UserDetail> objlist = new List <ModelBookStore.UserDetail>();
foreach (var Useritem in UserDetaillist)
{
ModlelUserDetailObj = new ModelBookStore.UserDetail();
//ModlelUserDetailObj.id = Useritem.id;
ModlelUserDetailObj.FirstName = Useritem.FirstName;
ModlelUserDetailObj.LastName = Useritem.LastName;
ModlelUserDetailObj.DOB = Convert.ToDateTime(Useritem.DOB);
ModlelUserDetailObj.PhoneNumber = Useritem.PhoneNumber;
ModlelUserDetailObj.EmailId = Useritem.EmailId;
ModlelUserDetailObj.Address = Useritem.Address;
ModlelUserDetailObj.city = Useritem.city;
ModlelUserDetailObj.state = Useritem.state;
// ModlelUserDetailObj.IsMembership = Useritem.IsMembership;
objlist.Add(ModlelUserDetailObj);
}
return(objlist);
}
public List <ModelBookStore.UserDetail> Load()
{
var UserDetaillist = (from objUserDetail in TBSEntities.UserDetails
select objUserDetail
//select new Role { id = objItems.id, UserId = objItems.Name }
).ToList();
ModelBookStore.UserDetail ModlelUserDetailObj;
List <ModelBookStore.UserDetail> objlist = new List <ModelBookStore.UserDetail>();
foreach (var Useritem in UserDetaillist)
{
ModlelUserDetailObj = new ModelBookStore.UserDetail();
ModlelUserDetailObj.id = Useritem.id;
ModlelUserDetailObj.FirstName = Useritem.FirstName;
ModlelUserDetailObj.LastName = Useritem.LastName;
ModlelUserDetailObj.DOB = Convert.ToDateTime(Useritem.DOB);
ModlelUserDetailObj.PhoneNumber = Useritem.PhoneNumber;
ModlelUserDetailObj.EmailId = Useritem.EmailId;
ModlelUserDetailObj.Address = Useritem.Address;
ModlelUserDetailObj.city = Useritem.city;
ModlelUserDetailObj.state = Useritem.state;
ModlelUserDetailObj.IsMembership = Useritem.IsMembership;
objlist.Add(ModlelUserDetailObj);
}
return(objlist);
}
public void Delete(ModelBookStore.UserDetail objModelUserDetail)
{
UserDetail _SelectRoleToDeleteRow = TBSEntities.UserDetails.Where(x => x.id == objModelUserDetail.id).Select(x => x).FirstOrDefault();
TBSEntities.UserDetails.Remove(_SelectRoleToDeleteRow);
TBSEntities.SaveChanges();
}
public void Update(ModelBookStore.UserDetail objModelUserDetail)
{
UserDetail _SelectUserrow = TBSEntities.UserDetails.Where(x => x.id == objModelUserDetail.id).Select(x => x).FirstOrDefault();
_SelectUserrow.FirstName = objModelUserDetail.FirstName;
_SelectUserrow.LastName = objModelUserDetail.LastName;
_SelectUserrow.PhoneNumber = objModelUserDetail.PhoneNumber;
_SelectUserrow.EmailId = objModelUserDetail.EmailId;
_SelectUserrow.Address = objModelUserDetail.Address;
_SelectUserrow.DOB = objModelUserDetail.DOB;
_SelectUserrow.city = objModelUserDetail.city;
_SelectUserrow.state = objModelUserDetail.state;
_SelectUserrow.IsMembership = objModelUserDetail.IsMembership;
TBSEntities.SaveChanges();
}
public List <ModelBookStore.UserDetail> LoadCustomers()
{
var Customerlist = (from objCustomers in TBSEntities.UserDetails
select objCustomers).ToList();
ModelBookStore.UserDetail ModleCustomerObj;
List <ModelBookStore.UserDetail> objCustomerlist = new List <ModelBookStore.UserDetail>();
foreach (var item in Customerlist)
{
ModleCustomerObj = new ModelBookStore.UserDetail();
ModleCustomerObj.id = item.id;
ModleCustomerObj.FirstName = item.FirstName;
objCustomerlist.Add(ModleCustomerObj);
}
return(objCustomerlist);
}
public void Add(ModelBookStore.UserDetail objModelUserDetail)
{
// UserDetail _SelectUserrow = TBSEntities.UserDetails.Where(x => x.id == objModelUserDetail.id).Select(x => x).FirstOrDefault();
UserDetail objUserDetail = new UserDetail()
{
FirstName = objModelUserDetail.FirstName,
LastName = objModelUserDetail.LastName,
PhoneNumber = objModelUserDetail.PhoneNumber,
EmailId = objModelUserDetail.EmailId,
Address = objModelUserDetail.Address,
DOB = objModelUserDetail.DOB,
city = objModelUserDetail.city,
state = objModelUserDetail.state,
IsMembership = objModelUserDetail.IsMembership
};
TBSEntities.UserDetails.Add(objUserDetail);
TBSEntities.SaveChanges();
}
public List <ModelBookStore.UserDetail> LoadAnnualBilling()
{
var UserDetaillist = TBSEntities.usp_AnualCustBilling();
ModelBookStore.UserDetail ModlelUserDetailObj;
List <ModelBookStore.UserDetail> objlist = new List <ModelBookStore.UserDetail>();
foreach (var Useritem in UserDetaillist)
{
ModlelUserDetailObj = new ModelBookStore.UserDetail();
//ModlelUserDetailObj.id = Useritem.id;
ModlelUserDetailObj.FirstName = Useritem.FirstName;
ModlelUserDetailObj.LastName = Useritem.LastName;
ModlelUserDetailObj.DOB = Convert.ToDateTime(Useritem.DOB);
ModlelUserDetailObj.PhoneNumber = Useritem.PhoneNumber;
ModlelUserDetailObj.EmailId = Useritem.EmailId;
ModlelUserDetailObj.state = Convert.ToString(Useritem.TotalAmount);
objlist.Add(ModlelUserDetailObj);
}
return(objlist);
}
