public static void Delete(int Id)
 {
     dbFirstStepDataContext db = new dbFirstStepDataContext();
     EntityQuote tnew = db.EntityQuotes.Where(p => p.Id == Id).Single();
     db.EntityQuotes.DeleteOnSubmit(tnew);
     db.SubmitChanges();
 }
 public static void Edit(AdminDanhMucModel Banner)
 {
     dbFirstStepDataContext db = new dbFirstStepDataContext();
     EntityDanhMuc Faq = db.EntityDanhMucs.Where(p => p.Id == Banner.Id).First();
     Faq.TenDM = Banner.TieuDe;
     Faq.IdRoot = Banner.IdRoot;
     db.SubmitChanges();
 }
 public ActionResult Ban(int id, int t)
 {
     dbFirstStepDataContext db = new dbFirstStepDataContext();
     var item = db.EntityUsers.Where(p => p.Id == id).First();
     item.TrangThai = t;
     db.SubmitChanges();
     return RedirectToAction("Index", "AdminUser");
 }
        public static string Delete(int Id)
        {
            dbFirstStepDataContext db = new dbFirstStepDataContext();

            EntityBanner tnew = db.EntityBanners.Where(p => p.Id == Id).Single();
            db.EntityBanners.DeleteOnSubmit(tnew);
            db.SubmitChanges();
            return tnew.HinhAnh;
        }
 public ActionResult Block(AdminDuAnModel DA)
 {
     dbFirstStepDataContext db = new dbFirstStepDataContext();
     var item = db.EntityDuAns.Where(p => p.Id == DA.Id).First();
     item.TrangThai = 0;
     item.LyDoBlock = DA.LyDoBlock;
     db.SubmitChanges();
     return RedirectToAction("Index", "AdminDuAn");
 }
 public static void Edit(AdminGhiChuModel Banner)
 {
     dbFirstStepDataContext db = new dbFirstStepDataContext();
     EntityQuote Faq = db.EntityQuotes.Where(p => p.Id == Banner.Id).First();
     Faq.IdUser = Banner.IdUser;
     Faq.Image = Banner.HinhAnh;
     Faq.NoiDung = Banner.NoiDung;
     db.SubmitChanges();
 }
 public ActionResult HoatDong()
 {
     int idlogin = Convert.ToInt16(Request.Cookies["ftid"].Value);
     dbFirstStepDataContext db = new dbFirstStepDataContext();
     EntityUser user = db.EntityUsers.Where(g => g.Id == idlogin).First();
     user.SoLuongHoatDong = 0;
     db.SubmitChanges();
     tongdanhsach = HoatDongModel.getListHoatDongModel(user);
     if (tongdanhsach.Count() == 0)
     {
         ViewBag.Tin = 0;
     }
     return View();
 }
 public void bantintheodoi(int IdBanBe)
 {
     dbFirstStepDataContext db = new dbFirstStepDataContext();
     var tim = db.EntityHoatDongs.Where(p => p.IdBanBe == IdBanBe && p.IdUser == Convert.ToInt16(Request.Cookies["ftid"].Value) && p.Loai == 1).ToList();
     if (tim.Count() == 0)
     {
         EntityHoatDong taomoi = new EntityHoatDong();
         taomoi.IdUser = Convert.ToInt16(Request.Cookies["ftid"].Value);
         taomoi.IdBanBe = IdBanBe;
         taomoi.Date = DateTime.Now;
         taomoi.Loai = 1;
         //taomoi.IdDuAn = 1;
         db.EntityHoatDongs.InsertOnSubmit(taomoi);
         db.SubmitChanges();
     }
 }
        public ActionResult Insert(AdminDanhMucModel DM)
        {
            try
            {
                dbFirstStepDataContext db = new dbFirstStepDataContext();
                EntityDanhMuc ban = new EntityDanhMuc();
                ban.TenDM = DM.TieuDe;
                ban.IdRoot = DM.IdRoot;
                db.EntityDanhMucs.InsertOnSubmit(ban);
                db.SubmitChanges();

                return RedirectToAction("Index", "AdminDanhMuc");
            }
            catch
            {
                return RedirectToAction("Index", "Error");
            }
        }
        public string BlockFollow(int IdBanBe)
        {
            try
            {
                int idlogin = Convert.ToInt16(Request.Cookies["ftid"].Value);

                dbFirstStepDataContext db = new dbFirstStepDataContext();

                var user = db.EntityTheoDois.Where(g => g.IdUser == IdBanBe && g.IdBanBe == idlogin).FirstOrDefault();
                if (user != null)
                {
                    user.TrangThai = 0;
                    db.SubmitChanges();
                }
                HoatDongModel.AddHoatDong(idlogin, IdBanBe, 2, 0);
                return "complete";
            }
            catch { return "error"; }
        }
        public JsonResult changeAccount(string username, string password)
        {
            try
            {

                dbFirstStepDataContext db = new dbFirstStepDataContext();

                var adminquery = (from p in db.EntityAdmins
                                  where p.Username == Request.Cookies["Admin"].Value
                                  select p).Single();
                Security ser = new Security();
                string hex = ser.GetHashPassword(password);
                adminquery.Pass = hex;
                db.SubmitChanges();
                return Json(adminquery);
            }
            catch
            {
                EntityAdmin admin = new EntityAdmin();
                admin.Pass = "******"; // error
                return Json(admin);
            }
        }
 public ActionResult kichhoat(string HasCode)
 {
     try
     {
         if (HasCode != null)
         {
             dbFirstStepDataContext db = new dbFirstStepDataContext();
             var item = db.EntityUsers.Where(p => p.HasCode == HasCode).First();
             if (item.TrangThai == 0)
             {
                 item.TrangThai = 1;
                 db.SubmitChanges();
                 createnew_LoginHistory("Đã đăng nhập ", item.Id);
                 Response.Cookies["ftid"].Value = item.Id.ToString();
                 Response.Cookies["ftusername"].Value = item.Email;
                 Response.Cookies["fthoten"].Value = HttpUtility.UrlEncode(item.HoTen); //admin.HoTen;
                 Response.Cookies["ftavatar"].Value = item.Avatar;
                 Response.Cookies["ftidFacebook"].Value = item.IdFacebook;
                 Session["fsduytrihoatdong"] = "1";
                 return RedirectToAction("SuaThongTin", "Account");
             }
             return RedirectToAction("Index", "Home");
         }
         else
         {
             return RedirectToAction("Index", "Home");
         }
     }
     catch (Exception ex)
     {
         throw ex;
     }
 }
 public ActionResult Manager_Index(int IdModule1, int IdModule2, int IdModule3)
 {
     try
     {
         dbFirstStepDataContext db = new dbFirstStepDataContext();
         EntityHomePage homepage = db.EntityHomePages.First();
         homepage.IdModuleDanhMuc1 = IdModule1;
         homepage.IdModuleDanhMuc2 = IdModule2;
         homepage.IdModuleDanhMuc3 = IdModule3;
         db.SubmitChanges();
         ViewBag.DanhMuc = db.EntityDanhMucs.Where(p => p.IdRoot == 1 || p.IdRoot == 2).ToList();
         //AdminDanhMucModel.Edit(DM);
         //return RedirectToAction("Index", "AdminDanhMuc");
         return View(homepage);
     }
     catch
     {
         return RedirectToAction("Index", "Error");
     }
 }
        public static void DangKy(AccountModel dangky)
        {
            dbFirstStepDataContext db = new dbFirstStepDataContext();
            Security ser = new Security();
            string passHex = ser.GetHashPassword(dangky.Pass);
            string mailHex = ser.GetHashPassword(dangky.Email);
            EntityUser ban = new EntityUser();
            ban.TrangThai = 0;
            ban.HasCode = mailHex;
            ban.HoTen = dangky.HoTen;
            ban.Email = dangky.Email;
            ban.Pass = passHex;
            string[] mang = HttpContext.Current.Request.Url.AbsoluteUri.ToString().Split('/');
            string url = mang[0] + "//" + mang[2];
            ban.Avatar = url+"/Content/Images/Avatar/ava0.jpg";
            ban.VanityURL = mailHex;//

            db.EntityUsers.InsertOnSubmit(ban);
            db.SubmitChanges();
        }
 public ActionResult Open(int id)
 {
     dbFirstStepDataContext db = new dbFirstStepDataContext();
     var item = db.EntityDuAns.Where(p => p.Id == id).First();
     item.TrangThai = 2;
     item.ThoiGianBatDau = DateTime.Now;
     item.LyDoBlock = null;
     db.SubmitChanges();
     return RedirectToAction("Index", "AdminDuAn");
 }
 public static string Edit(AdminBannerModel Banner)
 {
     dbFirstStepDataContext db = new dbFirstStepDataContext();
     EntityBanner Faq = db.EntityBanners.Where(p => p.Id == Banner.Id).Single();
     string image = null;
     if (Banner.Anh != null)
     {
         image = Faq.HinhAnh;
         Faq.HinhAnh = Banner.Anh;
     }
     Faq.ViTri = Banner.ViTri;
     Faq.TenNut = Banner.TenNut;
     Faq.NoiDung = Banner.NoiDung;
     Faq.LinkNut = Banner.LinkNut;
     Faq.TieuDe = Banner.TieuDe;
     Faq.LoaiBanner = Banner.LoaiBanner;
     db.SubmitChanges();
     return image;
 }
        public ActionResult SuaThongTin(AccountModel Mtnew)
        {
            try
            {
                //if (ModelState.IsValid)
                //{
                dbFirstStepDataContext db = new dbFirstStepDataContext();
                for (int i = 0; i < Request.Files.Count; i++)
                {
                    HttpPostedFileBase hpf = Request.Files[i];
                    if (hpf.FileName != "")
                    {
                        var ava = db.EntityUsers.Where(p => p.Email == Request.Cookies["ftusername"].Value).First();

                        if (ava.Avatar != null && ava.Avatar.IndexOf("ava0.jpg") == -1)
                        {
                            string[] link = ava.Avatar.Split('/');
                            string fileToDelete = Path.Combine(Server.MapPath("~/Content/Images/Avatar"), link[link.Count() - 1]); // file hinh cu
                            System.IO.File.Delete(fileToDelete);
                        }

                        ImageHelper imgHelper = new ImageHelper();
                        string encodestring = imgHelper.encodeImageFile(hpf);
                        string[] mang = Request.Url.AbsoluteUri.ToString().Split('/');
                        string url = mang[0] + "//" + mang[2];
                        ava.Avatar = url + "/Content/Images/Avatar/" + encodestring;
                        imgHelper.ResizeStream(180, hpf.InputStream, Path.Combine(AppDomain.CurrentDomain.BaseDirectory + "Content\\Images\\Avatar\\", encodestring));
                        //  ava.Avatar = "http://localhost:41372/Content/Images/Avatar/" + encodestring;
                        db.SubmitChanges();
                        //var path = Path.Combine(Server.MapPath("~/Content/Images/Avatar"), encodestring);
                        //hpf.SaveAs(path);
                        Response.Cookies["ftavatar"].Value = ava.Avatar;

                        //ImageHelper imgHelper = new ImageHelper();
                        //string encodestring = imgHelper.encodeImageFile(hpf);
                        //ava.Avatar = "/Content/Images/Avatar/" + encodestring;
                        //db.SubmitChanges();
                        //if (encodestring == "!")
                        //    return RedirectToAction("Error", "Home", new { errorMsg = "Can't upload Images" });
                        //var path = Path.Combine(Server.MapPath("~/Content/Images/Avatar"), encodestring);
                        //hpf.SaveAs(path);
                        //Response.Cookies["ftavatar"].Value = ava.Avatar;
                    }
                }

                var query = from p in db.EntityUsers
                            where p.Email == Request.Cookies["ftusername"].Value
                            select p;
                if (query.Count() == 0)
                {
                    return RedirectToAction("Logout", "Account");
                }
                else
                {
                    query.First().HoTen = Mtnew.HoTen;
                    query.First().GioiThieu = Mtnew.GioiThieu;
                    query.First().DiaDiem = Mtnew.DiaDiem;
                    query.First().Website = Mtnew.Website;
                    string[] mang = Mtnew.Profile.Split('/');
                    string kt = mang[mang.Count() - 1].ToString().Replace("user/", "");
                    kt = Utilities.Encode(kt);
                    if (db.EntityUsers.Any(g => g.VanityURL == kt) == false)
                        query.First().VanityURL = kt;

                    db.SubmitChanges();
                    return RedirectToAction("SuaThongTin", "Account");
                    //  View(Mtnew);
                }
                //}
            }
            catch
            {
                return RedirectToAction("Index", "Error", new { errorMsg = "Lỗi SQL hosting / server" });
            }

            //string[] mang1 = Request.Url.AbsoluteUri.ToString().Split('/');
            //string url1 = mang1[0] + "//" + mang1[2];
            //ViewBag.Link = url1 + "/user/";

            //return View(Mtnew);
        }
        public ActionResult DangKy(AccountModel Mtnew)
        {
            try
            {
                if (ModelState.IsValid)
                {
                    dbFirstStepDataContext db = new dbFirstStepDataContext();
                    var query = from p in db.EntityUsers
                                where p.Email == Mtnew.Email
                                select p;
                    if (query.Count() > 0)
                    {
                        return RedirectToAction("TrungEmail", "Account");
                    }
                    else
                    {
                        #region "Add new user"
                        Security ser = new Security();
                        string passHex = ser.GetHashPassword(Mtnew.Pass);
                        string mailHex = ser.GetHashPassword(Mtnew.Email);
                        EntityUser ban = new EntityUser();
                        ban.TrangThai = 0;
                        ban.HasCode = mailHex;
                        ban.HoTen = Mtnew.HoTen;
                        ban.Email = Mtnew.Email;
                        ban.Pass = passHex;
                        string[] mang = Request.Url.AbsoluteUri.ToString().Split('/');
                        string url = mang[0] + "//" + mang[2];
                        ban.Avatar = url + "/Content/Images/Avatar/ava0.jpg";
                        ban.VanityURL = mailHex;//
                        #endregion

                        string HoTen = Mtnew.HoTen;
                        string Email = Mtnew.Email;
                        //GuiMailDangKy(HoTen,Email,HasCode);
                        MailHelper.SendMail_DangKy(HoTen, Email, url + "/account/kichhoat?HasCode=" + ban.HasCode);
                        db.EntityUsers.InsertOnSubmit(ban);
                        db.SubmitChanges();
                        return RedirectToAction("DangKyThanhCong", "Account");
                    }
                }
            }
            catch
            {
            }
            return View(Mtnew);
        }
        public ActionResult Index(string code)
        {
            var fb = new FacebookClient();
            dynamic result = fb.Post("oauth/access_token", new

            {

                client_id = "570964363013096",

                client_secret = "d6edfe3df4e121a296e8e542a8932154",

                redirect_uri = RedirectUri.AbsoluteUri,

                code = code

            });
            var accessToken = result.access_token;

            //Luu access token ma fb tra ve vao session
            Session["AccessToken"] = accessToken;

            FacebookFriendsModel friends = new FacebookFriendsModel();

            var client = new FacebookClient(Session["accessToken"].ToString());
            dynamic fbresult = client.Get("me/friends");
            var data = fbresult["data"].ToString();

            friends.friendsListing = JsonConvert.DeserializeObject<List<FacebookFriend>>(data);

            dbFirstStepDataContext db = new dbFirstStepDataContext();
            var item = db.EntityUsers.ToList();
            IList<EntityUser> banchung = new List<EntityUser>();

            foreach (var ds in friends.friendsListing)
            {
                var ban = item.Where(g => g.IdFacebook == ds.id).ToList();
                foreach (var item2 in ban)
                {
                    var daco = db.EntityTheoDois.Where(t => t.IdUser == Convert.ToInt16(Request.Cookies["ftid"].Value) && t.IdBanBe == item2.Id).ToList();
                    if (daco.Count() == 0)
                    {
                        banchung.Add(item2);
                        EntityTheoDoi dulieu = new EntityTheoDoi();
                        dulieu.IdUser = Convert.ToInt16(Request.Cookies["ftid"].Value);
                        dulieu.IdBanBe = item2.Id;
                        dulieu.TrangThai = 0;
                        dulieu.Loaifb = 1;
                        db.EntityTheoDois.InsertOnSubmit(dulieu);
                        db.SubmitChanges();
                    }
                }
            }
            return RedirectToAction("TimBan", "BanBe");
        }
        public ActionResult DoiMatKhau(AccountModel Mtnew)
        {
            try
            {
                dbFirstStepDataContext db = new dbFirstStepDataContext();

                var query = from p in db.EntityUsers
                                where p.Email == Mtnew.Email
                                select p;

                if (query.Count() == 0)
                {
                    return RedirectToAction("Index", "Home");
                }
                else
                {
                    ViewBag.history = getAccount(query.First());
                    ViewBag.User = query.First();
                    if (ModelState.IsValid)
                    {
                        Security ser = new Security();
                        string Passhex = ser.GetHashPassword(Mtnew.Pass);
                        query.First().Pass = Passhex;
                        db.SubmitChanges();
                        createnew_LoginHistory("Đã đổi mật khẩu", query.First().Id);
                        //Logout();
                        //return RedirectToAction("Login", "Account");
                    }
                }

                //if (ModelState.IsValid)
                //{
                //    var query = from p in db.EntityUsers
                //                where p.Email == Mtnew.Email
                //                select p;
                //    if (query.Count() == 0)
                //    {
                //        return RedirectToAction("Index", "Home");
                //    }
                //    else
                //    {
                //        Security ser = new Security();
                //        string Passhex = ser.GetHashPassword(Mtnew.Pass);
                //        query.First().Pass = Passhex;
                //        db.SubmitChanges();
                //        createnew_LoginHistory("Đã đổi mật khẩu", query.First().Id);
                //        Logout();
                //        return RedirectToAction("Login", "Account");
                //    }
                //}
            }
            catch
            {

                return RedirectToAction("Index", "Error", new { errorMsg = "Lỗi SQL hosting / server" });
            }
            return View(Mtnew);
        }
        public ActionResult FacebookCallback(string code)
        {
            var fb = new FacebookClient();
            dynamic result = fb.Post("oauth/access_token", new

            {

                client_id = "570964363013096",

                client_secret = "d6edfe3df4e121a296e8e542a8932154",

                redirect_uri = RedirectUri.AbsoluteUri,

                code = code

            });
            var accessToken = result.access_token;

            //Luu access token ma fb tra ve vao session
            Session["AccessToken"] = accessToken;

            fb.AccessToken = accessToken;

            var urlreturn = result.AbsoluteUri;

            //var friendListData = fb.Get("/me/friends?fields=first_name,id");
            //JObject friendListJson = JObject.Parse(friendListData.ToString());

            ////List<FbUser> fbUsers = new List<FbUser>();
            //foreach (var friend in friendListJson["data"].Children())
            //{
            //    string kkk = friend["id"].ToString().Replace("\"", "");

            //}
            dynamic info = fb.Get("me?fields=first_name,last_name,id,email,picture");
            string email = info.email;
            string HoTen = info.first_name + " " + info.last_name;
            string IdFacebook = info.id;
            //{"data":{"url":"https://fbcdn-profile-a.akamaihd.net/hprofile-ak-ash2/1119295_100000887034532_1079608060_q.jpg","is_silhouette":false}}
            //"{\"data\":{\"is_silhouette\":false,\"url\":\"https://fbcdn-profile-a.akamaihd.net/hprofile-ak-xaf1/t1.0-1/c34.34.422.422/s50x50/425336_196174787203821_1477323958_n.jpg\"}}"
            string picture = info.picture.ToString();
            string[] arr1 = picture.Split('"');
            foreach (var item in arr1)
            {
                if (item.ToString().IndexOf("http") != -1)
                {
                    picture = item.ToString();
                    break;
                }
            }
             //   string[] arr2 = arr1[3].Split('"');
               // picture = "https:" + arr2[0];
            if (email != null)
            {
                FormsAuthentication.SetAuthCookie(email, false);
                // luu vao CSDL 111
                dbFirstStepDataContext db = new dbFirstStepDataContext();
                Security ser = new Security();
                EntityUser user = new EntityUser();
                var query = from p in db.EntityUsers
                            where p.Email == email
                            select p;
                if (query.Count() > 0)
                {
                    if (query.First().TrangThai == 0)
                    {

                    }
                    if (query.First().TrangThai == 1)
                    {
                       // query.First().HoTen = HoTen;
                       // user.Email = email;
                       // query.First().Avatar = picture;
                        // user.HasCode = ser.GetHashPassword(email);
                        // user.Loai = 1;
                        //user.TrangThai = 1;
                        // user.Date = DateTime.Now;
                        query.First().IdFacebook = IdFacebook;
                        db.SubmitChanges();
                        DangNhapFB(email);
                       // return RedirectToAction("Index", "Home");
                        if (ViewBag.UrlReferrer != null)
                        {
                            string url = ViewBag.UrlReferrer;
                            if(url.IndexOf("Dang-Nhap") != -1)
                                return RedirectToAction("Index", "Home");
                            else return Redirect(url);
                        }
                        else
                        {
                            if (Request.UrlReferrer != null && Request.UrlReferrer.ToString().Contains("facebook") == false)
                            {
                                if (Request.UrlReferrer.ToString().IndexOf("Dang-Nhap") != -1)
                                    return RedirectToAction("Index", "Home");
                                else return Redirect(Request.UrlReferrer.ToString());
                                //else return Redirect(result.AbsoluteUri);
                            }
                            else
                            {
                                return RedirectToAction("Index", "Home");
                            }
                        }
                    }
                    else
                    {
                        return RedirectToAction("BanFacebook", "LoginAccount");
                    }
                }
                else
                {
                    user.HoTen = HoTen;
                    user.Email = email;
                    user.Avatar = picture;
                    user.IdFacebook = IdFacebook;
                    user.TrangThai = 1;

                    string HasCode = ser.GetHashPassword(user.Email);
                    user.VanityURL = HasCode;

                    db.EntityUsers.InsertOnSubmit(user);
                    user.Date = DateTime.Now;
                    db.SubmitChanges();
                    DangNhapFB(email);
                    if (ViewBag.UrlReferrer != null)
                    {
                        return Redirect(ViewBag.UrlReferrer);
                    }
                    else
                        return RedirectToAction("Index", "Home");

                }
            }
            else
            {
                ViewBag.Message = "Không thể lấy được email từ facebook của bạn";
                return Content("<script language='javascript' type='text/javascript'>alert('Không thể lấy được email từ facebook của bạn.'); window.location = '/Tai-Khoan/Dang-Nhap';</script>");
            }
        }
        // một là thêm bạn mới
        // follow ban be fb
        public string Follow(int IdBanBe)
        {
            try
            {
                int idlogin= Convert.ToInt16(Request.Cookies["ftid"].Value);

                dbFirstStepDataContext db = new dbFirstStepDataContext();

                var user = db.EntityTheoDois.Where(g=>g.IdUser== idlogin&& g.IdBanBe== IdBanBe).FirstOrDefault();
                if (user != null)
                {
                    user.TrangThai = 1;
                    db.SubmitChanges();
                }
                else
                {
                    EntityTheoDoi theodoi = new EntityTheoDoi();
                    theodoi.IdUser = idlogin;
                    theodoi.IdBanBe = IdBanBe;
                    theodoi.TrangThai = 1;
                    theodoi.Loaifb = 1;
                    theodoi.Date = DateTime.Now;
                    db.EntityTheoDois.InsertOnSubmit(theodoi);
                    db.SubmitChanges();
                }
                HoatDongModel.AddHoatDong(idlogin, IdBanBe, 1, 0);
                return "complete";
            }
            catch { return "error"; }
        }
        public ActionResult kichhoat_team(string HasCode)
        {
            try
            {
                dbFirstStepDataContext db = new dbFirstStepDataContext();
                var nhom = db.EntityNhomChienDiches.Where(g => g.EntityUser.HasCode == HasCode).First(); ;
                // string linkduan = Request.Url.AbsoluteUri.Split('/')[2] + Url.Action("ChiTietDuAn", "DuAn", new { Title = Utilities.Paste_Int64(Utilities.Encode(duan.TenDuAn.ToString()), duan.Id) });

                if (nhom.TrangThai == false)
                {
                    nhom.TrangThai = true;
                    db.SubmitChanges();
                }
                return RedirectToAction("ChiTietDuAn", "DuAn", new { Title = Utilities.Paste_Int64(Utilities.Encode(nhom.EntityDuAn.TenDuAn.ToString()), nhom.EntityDuAn.Id) });
            }
            catch {
                return RedirectToAction("Index", "Home");
            }
        }
        public ActionResult QuenMatKhau(AccountModel Mtnew)
        {
            try
             {
                 if (ModelState.IsValid)
                 {
                     dbFirstStepDataContext db = new dbFirstStepDataContext();
                     var query = from p in db.EntityUsers
                                 where p.Email == Mtnew.Email
                                 select p;
                     if (query.Count() == 0)
                     {
                         return RedirectToAction("DaGuiEmailQuenMK", "Account");
                     }
                     else
                     {
                         //string Pass = GenerateRandomText();
                         string Pass = GeneratePassword(4, 1, 3);
                         Security ser = new Security();
                         string Passhex = ser.GetHashPassword(Pass);
                         query.First().Pass = Passhex;
                         db.SubmitChanges();
                         string HoTen = query.First().HoTen;
                         string Email = Mtnew.Email;
                         string HasCode = Pass;
                         MailHelper.SendMail_Laylaimatkhau(HoTen, Email, HasCode);
                         return RedirectToAction("DaGuiEmailQuenMK", "Account");
                     }
                 }
             }
             catch
             {

                 return RedirectToAction("Index", "Error", new { errorMsg = "Lỗi SQL hosting / server" });
             }
             return View(Mtnew);
        }
 public String SaveAccountPayoo(String username)
 {
     String result = "";
     try
     {
         dbFirstStepDataContext db = new dbFirstStepDataContext();
         int idlogin = Convert.ToInt16(Request.Cookies["ftid"].Value);
         EntityUser user = db.EntityUsers.Where(g => g.Id == idlogin).FirstOrDefault();
         user.TKPayoo = username;
         db.SubmitChanges();
         result = "True";
     }
     catch (Exception ex)
     {
         result = "False";
         throw ex;
     }
     return result;
 }
        public ActionResult Insert(AdminGhiChuModel DM, HttpPostedFileBase Image)
        {
            try
            {
                dbFirstStepDataContext db = new dbFirstStepDataContext();
                EntityQuote ban = new EntityQuote();
                if (Image != null)
                {
                    ImageHelper imgHelper = new ImageHelper();
                    string encodestring = imgHelper.encodeImageFile(Image);
                    db.SubmitChanges();
                    if (encodestring == "!")
                        return RedirectToAction("Index", "Error", new { errorMsg = "Can't upload Images" });
                    var path = Path.Combine(Server.MapPath("~/Content/Images/GhiChu"), encodestring);
                    Image.SaveAs(path);
                    ban.Image = encodestring;
                    ban.IdUser = null;
                }
                else
                {
                    ban.IdUser = DM.IdUser>0?DM.IdUser:null;
                }
                ban.NoiDung = DM.NoiDung;
                db.EntityQuotes.InsertOnSubmit(ban);
                db.SubmitChanges();

                return RedirectToAction("Index", "AdminGhiChu");
            }
            catch
            {
                return RedirectToAction("Index", "Error");
            }
        }
        public ActionResult Insert(AdminBannerModel DM)
        {
            try
            {
                //AdminBannerModel.Insert(DM);
                dbFirstStepDataContext db = new dbFirstStepDataContext();
                // IList<EntityAnhChiTietSP> list = new List<EntityAnhChiTietSP>();
                //var idsp = db.EntitySanPhams.Where(t => t.TenSanPham == DM.TenSanPham && t.Date == ban.Date && t.MaSanPham == DM.MaSanPham).First();

                if (DM.LoaiBanner == LoaiBanner.Image)
                {
                    int tt = 0;
                    for (int i = 0; i < Request.Files.Count; i++)
                    {

                        HttpPostedFileBase hpf = Request.Files[i];
                        if (hpf.FileName == "")
                        {
                            tt = -1; // k co hinh anh
                            break;
                        }
                        tt++;

                        ImageHelper imgHelper = new ImageHelper();
                        string encodestring = imgHelper.encodeImageFile(hpf);
                        //var anh = db.EntitySanPhams.Where(t => t.MaSanPham == DM.MaSanPham && t.Date == DM.Date).First();
                        DM.Anh = encodestring;
                        db.SubmitChanges();
                        if (encodestring == "!")
                            return RedirectToAction("Error", "Home", new { errorMsg = "Can't upload Images" });
                        var path = Path.Combine(Server.MapPath("~/Content/Images/Banner"), encodestring);
                        hpf.SaveAs(path);

                        EntityBanner ban = new EntityBanner();
                        ban.HinhAnh = encodestring;
                        ban.ViTri = DM.ViTri;
                        ban.TenNut = DM.TenNut;
                        ban.NoiDung = DM.NoiDung;
                        ban.LinkNut = DM.LinkNut;
                        ban.TieuDe = DM.TieuDe;
                        ban.LoaiBanner = DM.LoaiBanner;
                        db.EntityBanners.InsertOnSubmit(ban);
                        db.SubmitChanges();

                    }
                }
                else
                {
                    EntityBanner ban = new EntityBanner();
                    ban.LinkNut = DM.LinkNut;
                    ban.LoaiBanner = DM.LoaiBanner;
                    ban.ViTri = DM.ViTri;
                    db.EntityBanners.InsertOnSubmit(ban);
                    db.SubmitChanges();
                }

                return RedirectToAction("Index", "AdminBanner");
            }
            catch
            {
                return RedirectToAction("Index", "Error");
            }
        }