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