protected void btn_follow_Click(object sender, EventArgs e) { follower fr = new follower(); following fi = new following(); fr.followers_id = int.Parse(Session["uid"].ToString()); fr.uid = uid; fr.status = "following"; fta.followers.Add(fr); fi.following_id = uid; fi.uid = int.Parse(Session["uid"].ToString()); fta.followings.Add(fi); fta.SaveChanges(); var followers = (from x in fta.followers where x.uid == uid select x.followers_id).Count(); int a = int.Parse(Session["uid"].ToString()); var following = (from y in fta.followings where y.uid == a select y.following_id).Count(); userprofile pf = fta.userprofiles.Where(x => x.uid == uid).FirstOrDefault(); pf.followers = followers; userprofile pfa = fta.userprofiles.Where(x => x.uid == a).FirstOrDefault(); pfa.following = following; fta.SaveChanges(); String url = "profileuser.aspx?id=" + uid; Response.Redirect(url); }
public async Task <bool> Add(userprofile item) { try { var obj = JsonConvert.SerializeObject(item); StringContent content = new StringContent(obj); var result = await client.ClientContext.PostAsync("/Api/UserProfile", content); if (result.IsSuccessStatusCode) { var newitem = JsonConvert.DeserializeObject <userprofile>(result.Content.ReadAsStringAsync().Result); this.Source.Add(newitem); return(true); } else { throw new SystemException("Data Tidak Tersimpan"); } } catch (Exception ex) { ResourcesBase.ShowMessageError(ex.Message); return(false); } }
public UserVM Login(UserVM loginVM) { userprofile user = new userprofile(); try { if (string.IsNullOrWhiteSpace(loginVM.Email)) { throw new Exception(Messages.BAD_DATA); } user = db.userprofiles.FirstOrDefault(x => x.Email == loginVM.Email && x.Password == loginVM.Password && !x.IsDeactive); if (user == null) { throw new Exception(Messages.INVALID_USER_PASS); } if (user.IsDeactive) { throw new Exception(Messages.NOT_ACTIVE); } } catch (Exception ex) { if (HttpContext.Current != null) { ErrorSignal.FromCurrentContext().Raise(ex); } throw new Exception(ex.Message.ToString()); } var _data = Mapper.Map <userprofile, UserVM>(user); _data.role_name = db.user_role.FirstOrDefault(r => r.Id == _data.RoleId).RoleName; return(_data); }
public ActionResult Login(userprofile objUser) { if (IsValid(objUser.UserName, objUser.Password)) { FormsAuthentication.SetAuthCookie(objUser.UserName, true); return(RedirectToAction("UserDashBoard", "Home")); } else { ModelState.AddModelError("", "Login details are wrong."); } //if (ModelState.IsValid) //{ //using (mydbEntities db = new mydbEntities()) // { // var obj = db.userprofiles.Where(a => a.UserName.Equals(objUser.UserName) && a.Password.Equals(objUser.Password)).FirstOrDefault(); // if (obj != null) // { // Session["userid"] = obj.UserId; // Session["username"] = obj.UserName; // return RedirectToAction("userdashboard"); // } // else // { // ModelState.AddModelError("", "Login details are wrong."); // } // } //} return(View(objUser)); }
public UserProfileDetail userprofiledetails(int studentscode) { userprofile profile = new userprofile(); UserProfileDetail Detils = new UserProfileDetail(); using (SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["con"].ConnectionString)) { using (SqlCommand cmd = new SqlCommand("usp_api_getuserprofile", con)) { con.Open(); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@studentcode", SqlDbType.Int).Value = studentscode; SqlDataReader rdr = cmd.ExecuteReader(); while (rdr.Read()) { profile.studentcode = Convert.ToInt32(rdr["code"]); profile.admissionno = Convert.ToString(rdr["admissionno"]); profile.firstname = Convert.ToString(rdr["Firstname"]); profile.lastname = Convert.ToString(rdr["Lastname"]); profile.middletname = Convert.ToString(rdr["Middlename"]); profile.aadharno = Convert.ToString(rdr["adharno"]); profile.correspondance = Convert.ToString(rdr["Correspondance"]); profile.homeaddress1 = Convert.ToString(rdr["HomeAddress1"]); profile.homeaddress2 = Convert.ToString(rdr["HomeAddress2"]); profile.homeaddress3 = Convert.ToString(rdr["HomeAddress3"]); profile.homeaddress4 = Convert.ToString(rdr["HomeAddress4"]); profile.homepincode = Convert.ToString(rdr["HomePincode"]); profile.hometelno = Convert.ToString(rdr["HomeTelno"]); profile.homemobileno = Convert.ToString(rdr["HomeMobileNo"]); profile.homeemail = Convert.ToString(rdr["HomeEmail"]); profile.officeemail = Convert.ToString(rdr["OfficeEmail"]); profile.officeaddress1 = Convert.ToString(rdr["OfficeAddress1"]); profile.officeaddress2 = Convert.ToString(rdr["OfficeAddress2"]); profile.officeaddress3 = Convert.ToString(rdr["OfficeAddress3"]); profile.officeaddress4 = Convert.ToString(rdr["OfficeAddress4"]); profile.officetelno = Convert.ToString(rdr["OfficeTelno"]); profile.officemobileno = Convert.ToString(rdr["OfficeMobileNo"]); profile.officepincode = Convert.ToString(rdr["OfficePincode"]); profile.fb = Convert.ToString(rdr["fb"]); profile.twitter = Convert.ToString(rdr["twitter"]); profile.linkedin = Convert.ToString(rdr["linkedin"]); profile.batchcode = Convert.ToInt32(rdr["BatchCode"].ToString()); profile.coursetypecode = Convert.ToInt32(rdr["CourseTypeCode"].ToString()); profile.coursecode = Convert.ToInt32(rdr["CourseCode"].ToString()); profile.homecity = Convert.ToInt32(rdr["HomeCity"].ToString()); profile.officecity = Convert.ToInt32(rdr["OfficeCity"].ToString()); profile.homestatecode = Convert.ToInt32(rdr["HomeStateCode"].ToString()); profile.officestatecode = Convert.ToInt32(rdr["OfficeStateCode"].ToString()); profile.homecountrycode = Convert.ToInt32(rdr["HomeCountryCode"].ToString()); profile.officecountrycode = Convert.ToInt32(rdr["OfficeCountryCode"].ToString()); profile.specicode = Convert.ToInt32(rdr["specicode"].ToString()); profile.studentimage = Convert.ToBase64String((byte[])rdr["picture"]); } con.Close(); } } Detils.userprofile = profile; return(Detils); }
public bool Post(userprofile t, string userName) { using (var db = new OcphDbContext()) { var u = db.Users.Where(O => O.UserName == userName).FirstOrDefault(); t.UserCode = u.Id; return(db.UserProfiles.Insert(t)); } }
// // GET: /User/userprofile/ public ActionResult Index() { List <userprofile> imagelst = new List <userprofile>(); SqlDataReader rdr = null; var profileinfo = new userprofile(); TempData["userId"] = System.Web.HttpContext.Current.Session["userId"]; TempData["userName"] = System.Web.HttpContext.Current.Session["userName"]; ViewBag.sectionName = "User Profile"; string cs = ConfigurationManager.ConnectionStrings["cs"].ConnectionString; SqlConnection con = new SqlConnection(cs); con.Open(); string usersp2 = "sp_ProfileInfo"; SqlCommand cmd4 = new SqlCommand(usersp2, con); cmd4.CommandType = CommandType.StoredProcedure; cmd4.Parameters.AddWithValue("@empid", System.Web.HttpContext.Current.Session["userId"]); //cmd4.ExecuteNonQuery(); // MISSING //getting reference_user_Id try { rdr = cmd4.ExecuteReader(); // iterate through results, printing each to console while (rdr.Read()) { profileinfo = new userprofile { sponsorid = rdr["sponsor_id"].ToString(), userid = rdr["user_id"].ToString(), pin = rdr["pin_no"].ToString(), city = rdr["city"].ToString(), pancardno = rdr["pancardno"].ToString(), state = rdr["state"].ToString(), nominee = rdr["nomineename"].ToString(), address = rdr["address"].ToString(), name = rdr["name"].ToString(), mobileno = rdr["mobileno"].ToString(), password = rdr["user_pw"].ToString(), bankname = rdr["bankaccount"].ToString(), accountno = rdr["accountno"].ToString(), holdername = rdr["holdername"].ToString(), ifsccode = rdr["ifsccode"].ToString(), }; } rdr.Close(); } catch (Exception e1) { //reference_user_id = null; } return(View(profileinfo)); }
private void savedata() { /* if () * Lpass.Text =" is Valid Email Address"; * else * Lpass.Text = " is Invalid Email Address"; */ userinfo user = new userinfo(); user.firstname = first_name.Text; user.lastname = last_name.Text; user.gender = gen.SelectedValue; user.dob = dob.Text; user.email = email.Text; user.mobile = phone.Text; user.password = password.Text; fta.userinfoes.Add(user); fta.SaveChanges(); image i = new image(); i.uid = user.uid; i.imagename = "user-admin.png"; i.imagepath = "~/images/user-admin.png"; fta.images.Add(i); fta.SaveChanges(); userprofile up = new userprofile(); up.uid = user.uid; up.location = "Add Location"; up.designation = "Add Designation"; up.education = "Add Education"; up.followers = 0; up.following = 0; fta.userprofiles.Add(up); fta.SaveChanges(); Session["email"] = email.Text; Session["username"] = user.firstname + user.lastname; Session["uid"] = user.uid; first_name.Text = string.Empty; last_name.Text = string.Empty; gen.SelectedValue = string.Empty; email.Text = string.Empty; phone.Text = string.Empty; dob.Text = string.Empty; Lphone.Text = string.Empty; Lpass.Text = string.Empty; Lemail.Text = string.Empty; Response.Redirect("Default.aspx"); }
protected void btn_location_Click(object sender, EventArgs e) { int id = int.Parse(Session["uid"].ToString()); userprofile pf = fta.userprofiles.Where(x => x.uid == id).FirstOrDefault(); pf.location = txt_location.Text; pf.uid = id; fta.SaveChanges(); Response.Redirect("profile.aspx"); }
public JsonResult AddProfile(frmUserData userDetail) { var profile = Request.Files; string imgname = string.Empty; string ImageName = string.Empty; //Following code will check that image is there //If it will Upload or else it will use Default Image if (System.Web.HttpContext.Current.Request.Files.AllKeys.Any()) { var logo = System.Web.HttpContext.Current.Request.Files["file"]; if (logo.ContentLength > 0) { var profileName = Path.GetFileName(logo.FileName); var ext = Path.GetExtension(logo.FileName); ImageName = profileName; var comPath = Server.MapPath("/Images/") + ImageName; logo.SaveAs(comPath); userDetail.Profile = ImageName; //obj.userprofiles.Add(userDetail); userprofile userObj = new userprofile(); userObj.name = userDetail.name; userObj.email = userDetail.email; userObj.password = userDetail.password; userObj.Profile = userDetail.Profile; userObj.gender = userDetail.gender; try { obj.userprofiles.Add(userObj); obj.SaveChanges(); } catch (Exception ex) { //throw; } } } else { userDetail.Profile = Server.MapPath("/Images/") + "profile.jpg"; } int response = 1; return(Json(response, JsonRequestBehavior.AllowGet)); }
private void ChangeRoleViews(userprofile selected) { if (selected != null && selected.Roles != null) { RoleSource.Clear(); foreach (var item in selected.Roles) { RoleSource.Add(item); } RolesView.Refresh(); Roles.Refresh(); } }
public IHttpActionResult Put(int id, [FromBody] userprofile value) { var identity = User.Identity.Name; try { return(Ok(context.Put(id, value, identity))); } catch (Exception ex) { return(Content(HttpStatusCode.NotModified, ex.Message)); } }
internal async Task <roles> RemoveRole(userprofile selectedItem, roles roleSelected) { string url = string.Format("RemoveRole?userId={0}&roleId={1}", selectedItem.Id, roleSelected.Id);; var result = await client.ClientContext.DeleteAsync(url); if (result.IsSuccessStatusCode) { return(JsonConvert.DeserializeObject <roles>(result.Content.ReadAsStringAsync().Result)); } else { return(null); } }
public userprofile Put(int profileid, userprofile value, string name) { using (var db = new OcphDbContext()) { string userid = Helpers.GetUserId(name); var isUpdated = db.UserProfiles.Update(O => new { O.FirstName, O.LastName, O.Address, O.Photo }, value, O => O.UserId == profileid); if (isUpdated) { return(value); } else { throw new SystemException(MessageCollection.Message(MessageType.UpdateFaild)); } } }
public ActionResult Register(userprofile user) { try { if (ModelState.IsValid) { //mydbEntities db = new mydbEntities() using (var db = new mydbEntities()) { var newUser = db.userprofiles.Create(); newUser.UserName = user.UserName; newUser.Password = user.Password; newUser.IsActive = true; db.userprofiles.Add(newUser); db.SaveChanges(); return(RedirectToAction("Index", "Home")); } } else { ModelState.AddModelError("", "Data is not correct"); } } catch (DbEntityValidationException e) { foreach (var eve in e.EntityValidationErrors) { Console.WriteLine("Entity of type \"{0}\" in state \"{1}\" has the following validation errors:", eve.Entry.Entity.GetType().Name, eve.Entry.State); foreach (var ve in eve.ValidationErrors) { Console.WriteLine("- Property: \"{0}\", Error: \"{1}\"", ve.PropertyName, ve.ErrorMessage); } } throw; } return(View()); }
public UserVM GetProfile(int id) { userprofile user = new userprofile(); try { user = db.userprofiles.FirstOrDefault(i => i.UserId == id && !i.IsDeactive); if (user == null) { throw new Exception(Messages.BAD_DATA); } } catch (Exception ex) { if (HttpContext.Current != null) { ErrorSignal.FromCurrentContext().Raise(ex); } throw new Exception(ex.Message.ToString()); } return(Mapper.Map <userprofile, UserVM>(user)); }
internal async Task <bool> Update(int v, userprofile item) { var res = await client.PutAsync("PUT", item.UserId, item); if (res != null) { var userProfile = Source.Where(O => O.UserId == item.UserId).FirstOrDefault(); if (userProfile != null) { item.FirstName = userProfile.FirstName; item.LastName = userProfile.LastName; item.Address = userProfile.Address; item.PhoneNumber = userProfile.PhoneNumber; } return(true); } else { return(false); } }
private async void GetProfile() { userprofile result = await MainVM.UserProfileCollections.GetProfile(); if (result != null) { if (result == null) { this.IsNew = true; } else { this.UserId = result.UserId; this.FirstName = result.FirstName; this.LastName = result.LastName; this.Email = result.Email; this.UserId = result.UserId; this.PhoneNumber = result.PhoneNumber; this.Address = result.Address; this.Photo = result.Photo; } } }
public ActionResult Index(userprofile model) { var profileinfo = new userprofile(); SqlDataReader rdr = null; string cs = ConfigurationManager.ConnectionStrings["cs"].ConnectionString; SqlConnection con = new SqlConnection(cs); con.Open(); try { string usersp3 = "sp_isert_update_bankdetails"; SqlCommand cmd4 = new SqlCommand(usersp3, con); cmd4.CommandType = CommandType.StoredProcedure; cmd4.Parameters.AddWithValue("@user_id", System.Web.HttpContext.Current.Session["userId"]); cmd4.Parameters.AddWithValue("@holdername", model.holdername); cmd4.Parameters.AddWithValue("@accountno", model.accountno); cmd4.Parameters.AddWithValue("@ifsccode", model.ifsccode); cmd4.Parameters.AddWithValue("@bankaccount", model.bankname); cmd4.ExecuteNonQuery(); // MISSING string usersp2 = "sp_ProfileInfo"; SqlCommand cmd5 = new SqlCommand(usersp2, con); cmd5.CommandType = CommandType.StoredProcedure; cmd5.Parameters.AddWithValue("@empid", System.Web.HttpContext.Current.Session["userId"]); cmd5.ExecuteNonQuery(); // MISSING rdr = cmd5.ExecuteReader(); // iterate through results, printing each to console while (rdr.Read()) { profileinfo = new userprofile { sponsorid = rdr["sponsor_id"].ToString(), userid = rdr["user_id"].ToString(), pin = rdr["pin_no"].ToString(), city = rdr["city"].ToString(), pancardno = rdr["pancardno"].ToString(), state = rdr["state"].ToString(), nominee = rdr["nomineename"].ToString(), address = rdr["address"].ToString(), name = rdr["name"].ToString(), mobileno = rdr["mobileno"].ToString(), password = rdr["user_pw"].ToString(), bankname = rdr["bankaccount"].ToString(), accountno = rdr["accountno"].ToString(), holdername = rdr["holdername"].ToString(), ifsccode = rdr["ifsccode"].ToString(), }; } rdr.Close(); ViewBag.Message = "Suuccess";// MISSING } catch (Exception e1) { ViewBag.Message = "Fail"; } return(View(profileinfo)); }
internal async Task <roles> AddNewUserRole(userprofile selectedItem, roles role) { string url = string.Format("AddNewRole?userId={0}", selectedItem.Id); return(await client.PostAsync <roles>(url, role)); }