public int SignUp(string incomingUsername, string incomingName, string incomingSurname, string incomingMail, string incomingPassword) { User_Table controlUsername = dbContext.User_Table.Where(u => u.user_nickname == incomingUsername).FirstOrDefault(); User_Table controlMail = dbContext.User_Table.Where(u => u.user_email == incomingName).FirstOrDefault(); if (controlUsername != null) { return(-1); } else if (controlMail != null) { return(-2); } else { User_Table newuser = new User_Table(); newuser.user_nickname = incomingUsername; newuser.user_name = incomingName; newuser.user_surname = incomingSurname; newuser.user_email = incomingMail; newuser.user_password = incomingPassword; dbContext.User_Table.Add(newuser); dbContext.SaveChanges(); return(newuser.user_id); } }
/// <summary> /// 保存按钮 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btnSaves_Click(object sender, EventArgs e) { try { string[] filePath = ConfigurationManager.AppSettings["filePath"].Split('|'); if (filePath[0] != "null" && filePath[1] != "nameNull") { string destFilePath = Server.MapPath(@"image\Head") + "\\" + filePath[1]; if (File.Exists(filePath[0])) { if (File.Exists(destFilePath)) { File.Delete(destFilePath); } File.Copy(filePath[0], destFilePath); File.Delete(filePath[0]); if (Session["loginUserName"] != null) { UserTable_BLL bll = new UserTable_BLL(); User_Table user = Session["loginUserName"] as User_Table; user.U_Head = filePath[1]; ConfigurationManager.AppSettings["defaultHead"] = filePath[1]; Session["loginUserName"] = user; int n = bll.Update_UserTableData(user); } } } } catch (Exception ex) { Page.ClientScript.RegisterStartupScript(this.GetType(), "", "alert('操作异常:" + ex.Message + "');", true); } }
public ActionResult create(User_Table obj) { if (ModelState.IsValid) { obj.UserCreatedDate = System.DateTime.Now; obj.UserUpdatedDate = System.DateTime.Now; if (obj.Roleid == 1 || obj.Roleid == 2 || obj.Roleid == 3) { obj.UserCreatedBy = obj.UserName; obj.UserUpdateBy = obj.UserName; obj.UserIsDeleted = true; db.User_Table.Add(obj); db.SaveChanges(); return(RedirectToAction("login")); } else { obj.UserCreatedBy = obj.UserName; obj.UserUpdateBy = obj.UserName; obj.UserIsDeleted = false; db.User_Table.Add(obj); db.SaveChanges(); return(RedirectToAction("login")); } } else { return(RedirectToAction("errror")); } }
internal static bool InsertUser(User_Table user) { bool inserted = false; try { string query = @"INSERT INTO [dbo].[user_table] ([name] ,[email] ,[password] ,[phone] ,[address] ,[image] ,[join_date] ,[role]) VALUES ( '" + user.name + "','" + user.email + "','" + user.password + "','" + user.phone + "','" + user.address + "','" + user.image + "','" + user.join_date + "','" + user.role + "')"; int row = DataAccess.ExecuteQuery(query); if (row == 1) { inserted = true; } } catch (Exception e) { return(false); } return(inserted); }
/// <summary> /// 根据条件查询用户信息 /// </summary> /// <param name="con"></param> /// <param name="type">[id,name,phone]选其一(必填)</param> /// <returns></returns> public User_Table GetUserTableByConn(string con, string type) { string sql = ""; User_Table obj = null; SqlDataReader dr = null; switch (type.ToLower()) { case "id": sql = "Select * from User_Table where U_id=@U_id"; dr = DBHerlper.ExecuteReader( sql, CommandType.Text, new SqlParameter[] { new SqlParameter("@U_id", con) }); break; case "name": sql = "Select * from User_Table where U_UserName=@U_UserName"; dr = DBHerlper.ExecuteReader( sql, CommandType.Text, new SqlParameter[] { new SqlParameter("@U_UserName", con) }); break; case "phone": sql = "Select * from User_Table where U_Phone=@U_Phone"; dr = DBHerlper.ExecuteReader( sql, CommandType.Text, new SqlParameter[] { new SqlParameter("@U_Phone", con) }); break; } if (dr.Read()) { obj = new User_Table() { U_PhoneVerify = dr["U_PhoneVerify"].ToString(), IDT_id = Convert.ToInt32(dr["IDT_id"]), U_ComPanyAddress = dr["U_ComPanyAddress"].ToString(), U_Company = dr["U_Company"].ToString(), M_id = Convert.ToInt32(dr["M_id"]), U_CreateUserDate = dr["U_CreateUserDate"].ToString(), U_Head = dr["U_Head"].ToString(), U_id = Convert.ToInt32(dr["U_id"]), U_IDS = dr["U_IDS"].ToString(), U_LastLoginAddress = dr["U_LastLoginAddress"].ToString(), U_LastLoginDatetime = dr["U_LastLoginDatetime"].ToString(), U_LoginAddress = dr["U_LoginAddress"].ToString(), U_LoginDatetime = dr["U_LoginDatetime"].ToString(), U_Sex = dr["U_Sex"].ToString(), U_Name = dr["U_Name"].ToString(), U_Phone = dr["U_Phone"].ToString(), U_UserName = dr["U_UserName"].ToString(), U_UserPwd = dr["U_UserPwd"].ToString(), LS_id = Convert.ToInt32(dr["LS_id"]) }; } dr.Close(); return(obj); }
/// <summary> /// Displaying the details of the user /// </summary> protected void Page_Load(object sender, EventArgs e) { try { if (Session["name"] != null) { PizzaDbEntities db = new PizzaDbEntities(); string name = Session["name"].ToString(); //Fetching the details User_Table exist = (from x in db.User_Table where x.UserName == name select x).FirstOrDefault(); phone.Text = exist.Phono; address.Text = exist.Address; } else { FormsAuthentication.SignOut(); } } catch (Exception) { Response.Redirect("UserError.aspx"); } }
public JsonResult search(string name) { int res = 0; BaseCategory_Table obj = db.BaseCategory_Table.Where(x => x.BaseCatName == name && x.BaseCatIsDeleted == false).FirstOrDefault(); ProductCategory_Table obj1 = db.ProductCategory_Table.Where(x => x.ProductCatName == name && x.ProductCatIsDeleted == false).FirstOrDefault(); User_Table obj2 = db.User_Table.Where(x => x.UserName == name && x.UserIsDeleted == false).FirstOrDefault(); if (obj != null) { res = 1; Session["base_cat"] = obj.BaseCatId; var redirectUrl = new UrlHelper(Request.RequestContext).Action("Product_cat", "Buyer"); return(Json(new { res, Url = redirectUrl }, JsonRequestBehavior.AllowGet)); } else if (obj1 != null) { res = 1; Session["prod_cat"] = obj1.ProductCatId; var redirectUrl = new UrlHelper(Request.RequestContext).Action("Product_page", "Buyer"); return(Json(new { res, Url = redirectUrl }, JsonRequestBehavior.AllowGet)); } else if (obj2 != null) { res = 1; Session["brand_id"] = obj2.UserId; var redirectUrl = new UrlHelper(Request.RequestContext).Action("Brand_page", "Buyer"); return(Json(new { res, Url = redirectUrl }, JsonRequestBehavior.AllowGet)); } else { return(Json(new { res }, JsonRequestBehavior.AllowGet)); } }
/// <summary> /// 获取全部的用户 /// </summary> /// <returns></returns> public List <User_Table> GetUserTableAll() { List <User_Table> list = new List <User_Table>(); SqlDataReader dr = DBHerlper.ExecuteReader(GetSqlString("Select"), CommandType.StoredProcedure); while (dr.Read()) { User_Table obj = new User_Table() { U_PhoneVerify = dr["U_PhoneVerify"].ToString(), IDT_id = Convert.ToInt32(dr["IDT_id"]), U_ComPanyAddress = dr["U_ComPanyAddress"].ToString(), U_Company = dr["U_Company"].ToString(), M_id = Convert.ToInt32(dr["M_id"]), U_CreateUserDate = dr["U_CreateUserDate"].ToString(), U_Head = dr["U_Head"].ToString(), U_id = Convert.ToInt32(dr["U_id"]), U_IDS = dr["U_IDS"].ToString(), U_LastLoginAddress = dr["U_LastLoginAddress"].ToString(), U_LastLoginDatetime = dr["U_LastLoginDatetime"].ToString(), U_LoginAddress = dr["U_LoginAddress"].ToString(), U_LoginDatetime = dr["U_LoginDatetime"].ToString(), U_Sex = dr["U_Sex"].ToString(), U_Name = dr["U_Name"].ToString(), U_Phone = dr["U_Phone"].ToString(), U_UserName = dr["U_UserName"].ToString(), U_UserPwd = dr["U_UserPwd"].ToString(), LS_id = Convert.ToInt32(dr["LS_id"]) }; list.Add(obj); } dr.Close(); return(list); }
/// <summary> /// Checking for username and password /// </summary> protected void loginbtb_Click(object sender, EventArgs e) { try { PizzaDbEntities db = new PizzaDbEntities(); User_Table exist = (from x in db.User_Table where x.UserName == nametxt.Text select x).FirstOrDefault(); //checking if username is correct if (exist != null) { //cheching if password is correct if (exist.Password == passwordtxt.Text) { Session["name"] = nametxt.Text; FormsAuthentication.RedirectFromLoginPage(nametxt.Text, true); } //when the password is wrong else { alertlbl.Text = "Invalid password!!"; } } //when user name is wrong else { alertlbl.Text = "Invalid Username!!"; } } catch (Exception) { Response.Redirect("UserError.aspx"); } }
public void ProcessRequest(HttpContext context) { context.Response.ContentType = "text/plain"; //context.Response.Write("Hello World"); User_Table getUserRegister = new User_Table() { U_Phone = context.Request["phone"], U_UserName = context.Request["username"], U_UserPwd = context.Request["userpwd"], LS_id = 0, U_CreateUserDate = DateTime.Now + "", IDT_id = 0, M_id = 0, U_Company = "", U_ComPanyAddress = "", U_Head = "Logo_ICO.png", U_LastLoginAddress = "", U_IDS = "", U_LoginAddress = "", U_Name = "客户(请完善信息)", U_PhoneVerify = "", U_Sex = "" }; int n = bll.Insert_UserTableData(getUserRegister); if (n > 0) { context.Response.Write("Yes"); } else { context.Response.Write("No"); } }
protected void confirmbtb_Click(object sender, EventArgs e) { try { PizzaDbEntities db = new PizzaDbEntities(); //Checking if user already exists User_Table exist = (from x in db.User_Table where x.UserName == nametxt.Text select x).FirstOrDefault(); if (exist != null) { alertlbl.Text = "username already exist"; } //Getting the user information from the user else { User_Table ob = new User_Table(); ob.UserName = nametxt.Text; ob.Phono = phonotxt.Text; ob.Password = passwordtxt.Text; ob.Address = addtext.Text; db.User_Table.Add(ob); db.SaveChanges(); Response.Redirect("Login.aspx"); } } catch (Exception) { Response.Redirect("UserError.aspx"); } }
public void ProcessRequest(HttpContext context) { context.Response.ContentType = "text/plain"; //context.Response.Write("Hello World"); var userName = context.Request["userName"]; var type = context.Request["con"]; User_Table getUser = new User_Table(); switch (type) { case "id": getUser = User.GetUserTableByConn(userName, "id"); break; case "name": getUser = User.GetUserTableByConn(userName, "name"); break; case "phone": getUser = User.GetUserTableByConn(userName, "phone"); break; } List <User_Table> getUserList = new List <User_Table>(); getUserList.Add(getUser); //创建可对数据进行Json【序列化/反序列化】操作对象 DataContractJsonSerializer dcjs = new DataContractJsonSerializer(typeof(List <User_Table>)); //将数据序列化为Jaon数据,通过流输出到客户端 dcjs.WriteObject(context.Response.OutputStream, getUserList); }
public string DeleteUser(int id) { User_Table user = GetUser(id); user = (from u in db.User_Tables where u.User_Id.Equals(id) select u).FirstOrDefault(); if (user == null) { return("User doesn't exist"); } else { user.Active = 0; try { db.SubmitChanges(); return(" Deleted"); } catch (Exception e) { return("User doesn't exist"); } } }
public string AddAdmin(User_Table user, string surname) { var admin = (from a in db.User_Tables where a.User_Id.Equals(user.User_Id) select a).FirstOrDefault(); if (admin == null) { var newAdmin = new Admin() { User_Id = user.User_Id, Surname = surname, }; db.Admins.InsertOnSubmit(newAdmin); try { db.SubmitChanges(); return(" added"); } catch (Exception ex) { ex.GetBaseException(); return("Something went wrong try again"); } } else { return(" Please try again"); } }
internal static bool UpdateUser(User_Table user) { bool inserted = false; try { string updateQuery = @"UPDATE [dbo].[user_table] SET [name] = '" + user.name + "',[email] = '" + user.email + "',[password] = '" + user.password + "',[phone] = '" + user.phone + "',[address] = '" + user.address + "',[image] = '" + user.image + "',[role] = '" + user.role + "WHERE user_id = '" + user.id + "'"; int row = DataAccess.ExecuteQuery(updateQuery); if (row == 1) { inserted = true; } } catch { return(false); } return(inserted); }
public ActionResult ChangePassword(ChangePasswordViewModel model) { if (!ModelState.IsValid) { return(View(model)); } User_Table obj = new User_Table(); string name = Session["user"].ToString(); User_Table details = (from a in db.User_Table where a.UserName == name select a).FirstOrDefault(); if (details.Password == model.OldPassword) { if (details.Password == model.NewPassword) { TempData["message"] = "your old password and new password are same!!!"; } else if (model.NewPassword == model.ConfirmPassword) { details.Password = model.NewPassword; db.SaveChanges(); TempData["message"] = "password changes successfully!!"; } else { TempData["message"] = "confirm password an new password does not match"; } } else { TempData["message"] = "your old password is incorrect "; } return(RedirectToAction("ChangePassword")); }
/// <summary> /// 更改用户 /// </summary> /// <param name="obj">带入参数</param> /// <returns></returns> public int Update_UserTableData(User_Table obj) { return(DBHerlper.ExecuteNonQuery(GetSqlString("Update"), CommandType.StoredProcedure, new SqlParameter[] { new SqlParameter("@U_PhoneVerify", obj.U_PhoneVerify), new SqlParameter("@IDT_id", obj.IDT_id), new SqlParameter("@U_ComPanyAddress", obj.U_ComPanyAddress), new SqlParameter("@U_Company", obj.U_Company), new SqlParameter("@M_id", obj.M_id), new SqlParameter("@U_CreateUserDate", obj.U_CreateUserDate), new SqlParameter("@U_Head", obj.U_Head), new SqlParameter("@U_id", obj.U_id), new SqlParameter("@U_IDS", obj.U_IDS), new SqlParameter("@U_LastLoginAddress", obj.U_LastLoginAddress), new SqlParameter("@U_LastLoginDatetime", obj.U_LastLoginDatetime), new SqlParameter("@U_LoginAddress", obj.U_LoginAddress), new SqlParameter("@U_LoginDatetime", obj.U_LoginDatetime), new SqlParameter("@U_Sex", obj.U_Sex), new SqlParameter("@U_Name", obj.U_Name), new SqlParameter("@U_Phone", obj.U_Phone), new SqlParameter("@U_UserName", obj.U_UserName), new SqlParameter("@U_UserPwd", obj.U_UserPwd), new SqlParameter("@LS_id", obj.LS_id) })); }
public ActionResult OrderHistoryDetails(int id) { List <OrderHistory_ViewModel> ohvmlist = new List <OrderHistory_ViewModel>(); var obj = db.OrderDetail_Table.Where(x => x.Orderid == id).ToList(); Service_Table s = new Service_Table(); User_Table uobj = new User_Table(); foreach (var item in obj) { var service = db.OrderDetail_Table.Where(x => x.Orderid == id).Select(x => x.Serviceid).FirstOrDefault(); // var servicename = db.Service_Table.Where(x => x.ServiceId == service).Select(x => x.ServiceName).FirstOrDefault(); s = db.Service_Table.Where(x => x.ServiceId == service).FirstOrDefault(); uobj = db.User_Table.Where(x => x.UserId == s.ServiceProviderid).FirstOrDefault(); var product_desc = db.Product_Table.Where(x => x.ProductId == item.Productid).Select(x => x.ProductDesc).FirstOrDefault(); var product = db.Product_Table.Where(x => x.ProductId == item.Productid).Select(x => x.ProductName).FirstOrDefault(); var deliveryadd = db.Order_Table.Where(x => x.OrderId == id).Select(x => x.OrderDeliveryAddress).FirstOrDefault(); var deliverydate = db.Order_Table.Where(x => x.OrderId == id).Select(x => x.OrderDeliveryDate).FirstOrDefault(); var image = db.Image_Table.Where(x => x.Productid == item.Productid).Select(x => x.BinaryImage).FirstOrDefault(); OrderHistory_ViewModel obj1 = new OrderHistory_ViewModel(); obj1.ProductName = product; obj1.ProductDesc = product_desc; obj1.OrderDelivryAddress = deliveryadd; obj1.Amount = (decimal)item.Amount; obj1.OrderDeliveryDate = (DateTime)deliverydate; obj1.ServiceName = uobj.UserName; obj1.BinaryImage = image; ohvmlist.Add(obj1); } return(View(ohvmlist)); }
public ActionResult service_name(string id) { Session["location"] = id; int pid = Convert.ToInt32(Session["pro_id"].ToString()); int locId; List <SelectListItem> ServiceList = new List <SelectListItem>(); if (!string.IsNullOrEmpty(id)) { locId = Convert.ToInt32(id); List <Service_Table> ser = db.Service_Table.Where(x => x.Locationid == locId & x.Productid == pid).ToList(); foreach (var item in ser) { User_Table obj = db.User_Table.Where(x => x.UserId == item.ServiceProviderid).FirstOrDefault(); ServiceList.Add(new SelectListItem { Text = obj.UserName.ToString(), Value = obj.UserId.ToString(), }); } ViewBag.procat = ServiceList; } return(Json(ServiceList, JsonRequestBehavior.AllowGet)); }
public ActionResult profile() { ViewBag.fill_msg = TempData["fill_msg"]; string name = Session["user"].ToString(); User_Table obj = db.User_Table.Where(x => x.UserName == name).FirstOrDefault(); return(View(obj)); }
public void UpdateHesap(int incomingID, string incomingnickname, string incomingpassword) { User_Table control = dbContext.User_Table.Where(u => u.user_id == incomingID).FirstOrDefault(); control.user_nickname = incomingnickname; control.user_password = incomingpassword; dbContext.SaveChanges(); }
public ActionResult Index(FormCollection form) { string username = form[0]; string password = form[1]; Logined_User = db.User_Table.FirstOrDefault(u => u.user_username == username && u.user_password == password); return(RedirectToAction("PHP")); }
public ActionResult DeleteConfirmed(int id) { User_Table user_Table = db.User_Table.Find(id); db.User_Table.Remove(user_Table); db.SaveChanges(); return(RedirectToAction("Index")); }
//register according to user type public string Register(string username, string password, string name, string email, string contactno, int active, string address, string surname = null, string businesstype = null, string usertype = "client") { var user = (from u in db.User_Tables where u.Email.Equals(email) select u).FirstOrDefault(); if (user == null) { var newUser = new User_Table { Username = username, //Surname = surname, Password = password, Name = name, Email = email, Contact_Number = contactno, Date_Created = DateTime.Today, Active = active, Address = address, Usertype = usertype }; if (usertype == "admin") { Admin a = new Admin { Surname = surname }; } else if (usertype == "client") { Client c = new Client { Business_Type = businesstype }; } else { return("unsuccessful"); } db.User_Tables.InsertOnSubmit(newUser); try { db.SubmitChanges(); return("registered"); } catch (Exception ex) { ex.GetBaseException(); return("unsuccessful"); } } else { return("unsuccessful"); } }
public JsonResult add_cart(int id) { string user = Session["user"].ToString(); int usid = db.User_Table.Where(x => x.UserName == user).Select(x => x.UserId).FirstOrDefault(); Order_Table obj = db.Order_Table.Where(x => x.OrderStatus == 0 & x.OrderIsDeleted == false & x.Userid == usid).FirstOrDefault(); if (obj == null) { Order_Table obj1 = new Order_Table(); obj1.OrderStatus = 0; obj1.OrderIsDeleted = false; string name = Session["user"].ToString(); User_Table uid = db.User_Table.Where(x => x.UserName == name).FirstOrDefault(); obj1.Userid = uid.UserId; obj1.OrderCreatedBy = name; obj1.OrderUpdatedBy = name; obj1.OrderCreatedDate = System.DateTime.Now; obj1.OrderUpdatedDate = System.DateTime.Now; db.Order_Table.Add(obj1); db.SaveChanges(); Order_Table obj2 = db.Order_Table.Where(x => x.OrderStatus == 0 & x.OrderIsDeleted == false & x.Userid == uid.UserId).FirstOrDefault(); OrderDetail_Table detail_obj = new OrderDetail_Table(); detail_obj.Orderid = obj2.OrderId; detail_obj.Productid = id; detail_obj.Quantity = 1; detail_obj.Amount = db.Product_Table.Where(x => x.ProductId == id).Select(x => x.ProductPrice).FirstOrDefault(); db.OrderDetail_Table.Add(detail_obj); db.SaveChanges(); } else { bool flag = false; var check = db.OrderDetail_Table.Where(x => x.Orderid == obj.OrderId).Select(x => x.Productid).ToList(); foreach (var item in check) { if (item == id) { flag = true; } } if (flag == false) { OrderDetail_Table detail_obj = new OrderDetail_Table(); detail_obj.Orderid = obj.OrderId; detail_obj.Productid = id; detail_obj.Quantity = 1; detail_obj.Amount = db.Product_Table.Where(x => x.ProductId == id).Select(x => x.ProductPrice).FirstOrDefault(); db.OrderDetail_Table.Add(detail_obj); db.SaveChanges(); } } count_cart(); var redirectUrl = new UrlHelper(Request.RequestContext).Action("Product_page", "Buyer"); return(Json(new { Url = redirectUrl }, JsonRequestBehavior.AllowGet)); }
/// <summary> /// 根据条件查询用户信息 /// </summary> /// <param name="con"></param> /// <param name="type">[id,name,phone]选其一(必填)</param> public User_Table GetUserTableByConn(string con, string type) { User_Table obj = relevanceClass.GetUserTableByConn(con, type); obj.GetIDTtpe = FK_IDType.GetIDTypeTableByConn(obj.IDT_id + ""); obj.GetLoginState = FK_LoginState.GetLoginStateTableByConn(obj.LS_id + ""); obj.GetMail = FK_Mail.GetMailTableByConn(obj.M_id + ""); return(obj); }
public User_Table GetUserInfo() { if (Session["loginUserName"] == null) { loginType = "登录"; } User_Table u = Session["loginUserName"] as User_Table; return(u); }
public ActionResult Edit([Bind(Include = "id,Name,Father_Name,CNIC,Current_Address,Product_Name,Phone_Number")] User_Table user_Table) { if (ModelState.IsValid) { db.Entry(user_Table).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(user_Table)); }
public ActionResult Edit([Bind(Include = "user_id,user_username,user_password")] User_Table user_Table) { if (ModelState.IsValid) { db.Entry(user_Table).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(user_Table)); }
public ActionResult Create([Bind(Include = "user_id,user_username,user_password")] User_Table user_Table) { if (ModelState.IsValid) { db.User_Table.Add(user_Table); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(user_Table)); }