예제 #1
0
        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);
     }
 }
예제 #3
0
 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);
        }
예제 #5
0
        /// <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);
        }
예제 #6
0
        /// <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));
            }
        }
예제 #8
0
        /// <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);
        }
예제 #9
0
        /// <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");
            }
        }
예제 #10
0
        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");
            }
        }
예제 #11
0
        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");
            }
        }
예제 #12
0
        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);
        }
예제 #16
0
        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"));
        }
예제 #17
0
 /// <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)
     }));
 }
예제 #18
0
        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));
        }
예제 #19
0
        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));
        }
예제 #20
0
        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));
        }
예제 #21
0
        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");
            }
        }
예제 #25
0
        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));
        }
예제 #26
0
        /// <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);
        }
예제 #27
0
        public User_Table GetUserInfo()
        {
            if (Session["loginUserName"] == null)
            {
                loginType = "登录";
            }
            User_Table u = Session["loginUserName"] as User_Table;

            return(u);
        }
예제 #28
0
 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));
        }