public ActionResult Myprofile() { paresetEntities db = new paresetEntities(); List <Chresqlist> objcountrylist = (from data in db.Chresqlists select data).ToList(); Chresqlist objcountry = new Chresqlist(); objcountry.Usersqlist = "Select"; objcountry.id = 0; objcountrylist.Insert(0, objcountry); SelectList objmodeldata = new SelectList(objcountrylist, "id", "Usersqlist", 0); /*Assign value to model*/ List <Userinfo> lstResult = (from data1 in db.Userinfoes where data1.username == User.Identity.Name select data1).ToList(); UserReg objcountrymodel = new UserReg(); objcountrymodel.Username = lstResult[0].username; objcountrymodel.Password = lstResult[0].password; objcountrymodel.email = lstResult[0].email; objcountrymodel.phone = lstResult[0].phone; objcountrymodel.Adinq = int.Parse(lstResult[0].adminq.ToString()); var Adminqst = db.Chresqlists.FirstOrDefault(u => u.id == objcountrymodel.Adinq); objcountrymodel.Adinqs = Adminqst.Adminsqlist.ToString(); objcountrymodel.Ansforaq = lstResult[0].ansforaq; objcountrymodel.Userq = int.Parse(lstResult[0].userq.ToString()); objcountrymodel.Ansforuq = lstResult[0].ansforuq; objcountrymodel.Usersqlist1 = objmodeldata; return(View(objcountrymodel)); }
public UserReg Getusqlist() { paresetEntities db = new paresetEntities(); List <Chresqlist> objcountrylist = (from data in db.Chresqlists select data).ToList(); Chresqlist objcountry = new Chresqlist(); objcountry.Usersqlist = "Select"; objcountry.id = 0; objcountrylist.Insert(0, objcountry); SelectList objmodeldata = new SelectList(objcountrylist, "id", "Usersqlist", 0); /*Assign value to model*/ UserReg objcountrymodel = new UserReg(); objcountrymodel.Usersqlist1 = objmodeldata; return(objcountrymodel); }
public SelectList GetAsqlist() { paresetEntities db = new paresetEntities(); List <Chresqlist> objcountrylist = (from data in db.Chresqlists select data).ToList(); Chresqlist objcountry = new Chresqlist(); objcountry.Usersqlist = "Select"; objcountry.id = 0; objcountrylist.Insert(0, objcountry); SelectList objmodeldata = new SelectList(objcountrylist, "id", "Adminsqlist", 0); /*Assign value to model*/ //Admindetails adminde = new Admindetails(); //adminde.Adminsqlist = objmodeldata; return(objmodeldata); }