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