public ActionResult LoadKhuVuc_Xa(int ID) { using (Models.Planner2Entities db = new Planner2Entities()) { var data = db.ThanhPhoes.Where(z => z.MaQuanHuyen == ID).GroupBy(z => z.MaPhuongXa).Select(v => new { Name = v.FirstOrDefault().PhuongXa, Key = v.FirstOrDefault().MaPhuongXa }).ToList(); return(Json(data, JsonRequestBehavior.AllowGet)); } }
public ActionResult Page() { using (Models.Planner2Entities db = new Planner2Entities()) { var data = db.MainTasks.Where(z => z.Page == true).FirstOrDefault(); return(View(data)); } }
public ActionResult History(int TaskID = 0) { ViewBag.TaskID = TaskID; using (Models.Planner2Entities db = new Planner2Entities()) { var data = db.Histories.Where(z => z.TaskID == TaskID).ToList(); return(PartialView(data)); } }
public ActionResult Page(string NamePage, string TT = "") { ViewBag.TT = TT; using (Models.Planner2Entities db = new Planner2Entities()) { var data = db.CustomPages.Where(z => z.NamePage == NamePage).FirstOrDefault(); return(View(data)); } }
public void UpdateHuy(int ID, string Noidung = "", Planner2.Models.User nguoidung = null) { using (Models.Planner2Entities db = new Planner2Entities()) { var data = db.MainTasks.Where(c => c.Id == ID).FirstOrDefault(); data.Status = ConstTrangThai.Huy; db.SaveChanges(); } }
public ActionResult InfoDanhMuc(int ID) { using (Models.Planner2Entities db = new Planner2Entities()) { var data = db.Categories.Where(v => v.CategoryRowID == ID).FirstOrDefault(); return(Json(data, JsonRequestBehavior.AllowGet)); } }
public ActionResult XoaBai(int ID) { using (Models.Planner2Entities db = new Planner2Entities()) { var data = db.MainTasks.Where(z => z.Id == ID).FirstOrDefault(); db.MainTasks.Remove(data); db.SaveChanges(); return(Json("", JsonRequestBehavior.AllowGet)); } }
public ActionResult GetListAllTask() { using (var db = new Planner2Entities()) { var data = db.MainTasks.Where(v => v.XetDuyet == 0).ToList(); JsonResult jsonResult = Json(data, JsonRequestBehavior.AllowGet); jsonResult.MaxJsonLength = 2147483647; return(jsonResult); } }
public ActionResult ResetPass(int Id) { using (Models.Planner2Entities db = new Planner2Entities()) { var data = db.Users.Where(z => z.Id == Id).FirstOrDefault(); string PassMD = "ABC123456"; data.Password = LoginController.EncryptPassword(PassMD); db.SaveChanges(); return(Json(data, JsonRequestBehavior.AllowGet)); } }
public ActionResult Page(MainTask Item) { using (Models.Planner2Entities db = new Planner2Entities()) { ViewBag.TitleChuDe = "Giới thiệu"; var data = db.MainTasks.Where(z => z.Id == Item.Id).FirstOrDefault(); data.Description = Item.Description; db.SaveChanges(); return(RedirectToAction("INFO", "POST", new { id = data.SeoUrl })); } }
public ActionResult Comment(int TaskID = 0) { ViewBag.TaskID = TaskID; using (Models.Planner2Entities db = new Planner2Entities()) { var data = db.CommentTasks.Where(z => z.TaskID == TaskID && z.NOIDUNG != null && z.NOIDUNG.Trim() != "").ToList(); ViewBag.FileUpload = db.UploadFiles.Where(v => v.TaskID.HasValue && db.CommentTasks.Where(x => x.TaskID == TaskID).Select(z => z.ID).Contains(v.TaskID.Value) && v.TableName == "CommentTask").ToList(); return(PartialView(data)); } }
public async Task <ActionResult> ExternalLoginCallback(string returnUrl) { var loginInfo = await AuthenticationManager.GetExternalLoginInfoAsync(); if (loginInfo == null) { return(RedirectToAction("Login")); } using (Planner2Entities db = new Planner2Entities()) { if (string.IsNullOrEmpty(loginInfo.Email)) { loginInfo.Email = loginInfo.DefaultUserName; } var data = db.Users.Where(z => z.Email.ToUpper() == loginInfo.Email.ToUpper()).FirstOrDefault(); if (data == null) { Planner2.Models.User item = new Planner2.Models.User(); item.UserName = loginInfo.Email; item.Email = loginInfo.Email; item.StaffName = loginInfo.DefaultUserName; db.Users.Add(item); db.SaveChanges(); } data = db.Users.Where(z => z.Email.ToUpper() == loginInfo.Email.ToUpper()).FirstOrDefault(); if (data != null) { Session[LoginAuth.NameSession] = data; HttpCookie cookie = new HttpCookie(LoginAuth.NameSession); string _Key = EncryptPassword(data.UserName); cookie.Values["_Key"] = _Key; cookie.Expires = DateTime.Now.AddDays(30); Response.Cookies.Add(cookie); if (Session["lastUrl"] != null) { var lastUrl = (string)Session["lastUrl"]; Session["lastUrl"] = null; return(Redirect(lastUrl)); } else { Session["lastUrl"] = null; return(RedirectToAction("Index", "Profile")); } } } return(RedirectToAction("INDEX", "PROFILE")); }
public ActionResult GetListAllTask() { var nguoidung = (Planner2.Models.User)Session[Planner2.Controllers.LoginAuth.NameSession]; using (var db = new Planner2Entities()) { var data = db.MainTasks.Where(v => v.Page == false && v.CreatedBy == nguoidung.UserName).ToList();//.Where(z => !string.IsNullOrEmpty(z.AttendPerson) && z.AttendPerson.ToUpper().Contains(nguoidung.UserName.ToUpper())).OrderByDescending(z=>z.NgayDang).ToList(); JsonResult jsonResult = Json(data, JsonRequestBehavior.AllowGet); jsonResult.MaxJsonLength = 2147483647; return(jsonResult); } }
public JsonResult Update_StaffOn(User_Category obj, DateTime?NgayHetHan = null) { using (Planner2Entities rrc_db = new Planner2Entities()) { User_Category a = rrc_db.User_Category.Find(obj.ID); bool result = false; a.NgayHetHan = obj.NgayHetHan ?? a.NgayHetHan; rrc_db.SaveChanges(); MvcApplication.ReloadSetting(); result = true; return(Json(new { result = result, data = a }, JsonRequestBehavior.AllowGet)); } }
public ActionResult RemoveFilePicture(int ID = 0) { using (Models.Planner2Entities db = new Planner2Entities()) { var data = db.MainTasks.Where(v => v.Id == ID).FirstOrDefault(); var nguoidung = (Planner2.Models.User)Session[Planner2.Controllers.LoginAuth.NameSession]; string noidungmail = nguoidung.StaffID + "-" + nguoidung.StaffName.Trim() + " đã Xoá file : <a target='_blank' href='" + data.Picture + "'>" + data.Picture + "</a>"; AddHistory(ID, noidungmail); data.Picture = ""; db.SaveChanges(); return(Json("", JsonRequestBehavior.AllowGet)); } }
double PhaiThanhToan(List <int> ThanhToan, MainTask item) { if (!(item.FinishDate.HasValue && item.StartDate.HasValue) || ThanhToan == null) { return(0); } double SoTienPhaiThanhToan = 0; var Day = (item.FinishDate - item.StartDate).Value.TotalDays; using (Models.Planner2Entities db = new Planner2Entities()) { foreach (var x in ThanhToan) { var task = db.MainTasks.Where(z => z.Id == item.Id).FirstOrDefault(); task = task ?? new MainTask(); var CategoryList = task.CategoryList; CategoryList = CategoryList ?? ""; var arrCategoryList = CategoryList.Split(',').Where(z => !string.IsNullOrEmpty(z)).Select(z => int.Parse(z)).ToList(); var cate = db.Categories.Where(v => v.CategoryRowID == x).FirstOrDefault(); if (cate != null) { // nếu đã mua trước đó if (arrCategoryList.Contains(x)) { Day = 0; if (task.FinishDate < item.FinishDate) { Day += (item.FinishDate - task.FinishDate).Value.TotalDays; } if (task.StartDate > item.StartDate) { Day += (task.StartDate - item.StartDate).Value.TotalDays; } } // nếu chưa mua bao giờ thì tính nguyên tiền theo số ngày } else { cate = new Category(); } cate.onePrice = cate.onePrice ?? 0; SoTienPhaiThanhToan += cate.onePrice.Value * Day; } } return(SoTienPhaiThanhToan); }
public JsonResult NAPTIEN(int ID, int SOTIEN = 0) { using (Planner2Entities rrc_db = new Planner2Entities()) { if (SOTIEN == 0) { return(Json("Vui lòng nhập số tiền chính xác", JsonRequestBehavior.AllowGet)); } var data = rrc_db.Users.Where(v => v.Id == ID).FirstOrDefault(); data.SoTien = data.SoTien ?? 0; data.SoTien += SOTIEN; rrc_db.SaveChanges(); return(Json("", JsonRequestBehavior.AllowGet)); } }
public ActionResult NG(int[] data = null) { using (var db = new Planner2Entities()) { foreach (var item in data) { var row = db.MainTasks.Where(v => v.Id == item).FirstOrDefault(); db.MainTasks.Remove(row); } db.SaveChanges(); JsonResult jsonResult = Json("", JsonRequestBehavior.AllowGet); jsonResult.MaxJsonLength = 2147483647; return(jsonResult); } }
public JsonResult AddNew(Bank obj) { using (Planner2Entities rrc_db = new Planner2Entities()) { bool?result = false; if (obj.ID == 0) { rrc_db.Banks.Add(obj); rrc_db.SaveChanges(); result = true; } return(Json(new { result = result, obj = obj }, JsonRequestBehavior.AllowGet)); } }
public ActionResult Index(CustomPage item) { using (Models.Planner2Entities db = new Planner2Entities()) { var data = db.CustomPages.Where(z => z.NamePage == item.NamePage).FirstOrDefault(); data.ContentPage = item.ContentPage; if (item.NamePage == "HEADER") { Common.SettingData.HeaderHTML = data.ContentPage; db.SaveChanges(); return(RedirectToAction("IndexText", new { NamePage = item.NamePage, TT = "Đã lưu" })); } db.SaveChanges(); return(RedirectToAction("Index", new { NamePage = item.NamePage, TT = "Đã lưu" })); } }
public JsonResult Delete(int id) { using (Planner2Entities rrc_db = new Planner2Entities()) { Category a = rrc_db.Categories.Find(id); bool result = false; if (a != null) { rrc_db.Categories.Remove(a); rrc_db.SaveChanges(); result = true; } return(Json(result, JsonRequestBehavior.AllowGet)); } }
public JsonResult Delete(int ID) { using (Planner2Entities rrc_db = new Planner2Entities()) { var a = rrc_db.CommentTasks.Find(ID); bool result = false; if (a != null) { rrc_db.CommentTasks.Remove(a); rrc_db.SaveChanges(); result = true; } return(Json(result, JsonRequestBehavior.AllowGet)); } }
public JsonResult AddNew(User obj) { using (Planner2Entities rrc_db = new Planner2Entities()) { bool?result = false; if (obj.Id == 0) { obj.Password = LoginController.EncryptPassword(obj.Password); rrc_db.Users.Add(obj); rrc_db.SaveChanges(); result = true; } return(Json(new { result = result, obj = obj }, JsonRequestBehavior.AllowGet)); } }
public JsonResult Update_StaffOn(SettingData obj) { using (Planner2Entities rrc_db = new Planner2Entities()) { SettingData a = rrc_db.SettingDatas.Find(obj.KeyID); bool result = false; a.Value = obj.Value; if (!string.IsNullOrEmpty(obj.Type)) { a.Type = obj.Type; } rrc_db.SaveChanges(); MvcApplication.ReloadSetting(); result = true; return(Json(new { result = result, data = a }, JsonRequestBehavior.AllowGet)); } }
public JsonResult Update_StaffOn(User obj) { using (Planner2Entities rrc_db = new Planner2Entities()) { User a = rrc_db.Users.Find(obj.Id); bool result = false; a.Email = obj.Email ?? a.Email; a.StaffName = obj.StaffName ?? a.StaffName; a.UserName = obj.UserName ?? a.UserName; a.Password = obj.Password ?? a.Password; a.SoTien = obj.SoTien ?? a.SoTien; a.Active = obj.Active ?? a.Active; a.SupperAdmin = obj.SupperAdmin ?? a.SupperAdmin; rrc_db.SaveChanges(); result = true; return(Json(new { result = result, data = a }, JsonRequestBehavior.AllowGet)); } }
public JsonResult Update_StaffOn(Bank obj) { using (Planner2Entities rrc_db = new Planner2Entities()) { Bank a = rrc_db.Banks.Find(obj.ID); bool result = false; a.BankName = obj.BankName ?? a.BankName; a.ChuTaiKhoan = obj.ChuTaiKhoan ?? a.ChuTaiKhoan; a.ChiNhanh = obj.ChiNhanh ?? a.ChiNhanh; a.SoTaiKhoan = obj.SoTaiKhoan ?? a.SoTaiKhoan; rrc_db.SaveChanges(); MvcApplication.ReloadSetting(); result = true; return(Json(new { result = result, data = a }, JsonRequestBehavior.AllowGet)); } }
public JsonResult AddNew(Category obj) { using (Planner2Entities rrc_db = new Planner2Entities()) { bool?result = false; if (obj.STT == null) { obj.STT = 9999; } if (obj.CategoryRowID == 0) { obj.SeoUrl = Extentions.SeoUrl.SeoURL(obj.CategoryName); rrc_db.Categories.Add(obj); rrc_db.SaveChanges(); result = true; } return(Json(new { result = result, obj = obj }, JsonRequestBehavior.AllowGet)); } }
public List <UploadFile> SubmitFile(HttpFileCollectionBase files, string TableName, string ColumnName, int TaskID) { using (Models.Planner2Entities db = new Planner2Entities()) { List <UploadFile> FileUp = new List <UploadFile>(); for (int i = 0; i < files.Count; i++) { try { HttpPostedFileBase file = files[i]; string fname; if (Request.Browser.Browser.ToUpper() == "IE" || Request.Browser.Browser.ToUpper() == "INTERNETEXPLORER") { string[] testfiles = file.FileName.Split(new char[] { '\\' }); fname = testfiles[testfiles.Length - 1]; } else { fname = Guid.NewGuid() + Path.GetExtension(file.FileName); } string newnane = "/FileUpload/" + fname; FileUp.Add(new Models.UploadFile { TaskID = TaskID, UrlFile = newnane, FileName = file.FileName, DateCreated = DateTime.Now, TableName = TableName, ColumnName = ColumnName }); fname = Path.Combine(Server.MapPath("~/FileUpload/"), fname); file.SaveAs(fname); } catch (Exception) { } } db.UploadFiles.AddRange(FileUp); db.SaveChanges(); return(FileUp); } }
public ActionResult UploadFile() { try { List <string> FileUp = new List <string>(); var TaskID = int.Parse(Request.Params["TaskID"].ToString()); var GuiMail = bool.Parse(Request.Params["GuiMail"].ToString()); var NOIDUNG = Request.Params["NOIDUNG"].ToString(); var ParentID = int.Parse(Request.Params["ParentID"].ToString()); NOIDUNG = NOIDUNG.Replace("\r\n", "<br>"); using (Models.Planner2Entities db = new Planner2Entities()) { Models.CommentTask tim = new CommentTask(); tim.DateCreate = DateTime.Now; tim.TaskID = TaskID; tim.ParentID = ParentID; var nguoidung = (Planner2.Models.User)Session[Planner2.Controllers.LoginAuth.NameSession]; tim.NOIDUNG = (GuiMail == true ? "<B>[Mail]</B>:<br> " : "") + NOIDUNG; db.CommentTasks.Add(tim); db.SaveChanges(); SubmitFile(Request.Files, "CommentTask", "FileDinhKem", tim.ID); var data = db.MainTasks.Where(z => z.Id == TaskID).FirstOrDefault(); AddNotify(data, "Đã phản hồi dữ liệu :<br>" + tim.NOIDUNG, nguoidung.UserName); if (GuiMail == true) { SendMainTask(TaskID, nguoidung.StaffID + "-" + nguoidung.StaffName + " đã gửi phản hồi :<br> <br> <br> " + NOIDUNG); } // Models.BackUpDB.BackUpNow(); return(Json("1", JsonRequestBehavior.AllowGet)); } } catch (Exception e) { return(Json("0", JsonRequestBehavior.AllowGet)); } }
public ActionResult Create(int TaskID = 0) { using (Models.Planner2Entities db = new Planner2Entities()) { // nếu = 0 => tạo mới dữ liệu ViewBag.FileUpload = db.UploadFiles.Where(v => v.TaskID == TaskID && v.TableName == "MainTask").ToList(); var nguoidung = (Planner2.Models.User)Session[Planner2.Controllers.LoginAuth.NameSession]; var Categories = db.Categories.Where(v => v.Menu == "Top").ToList(); var CategoriesVIP = db.Categories.Where(v => v.Menu != "Top").ToList(); ViewBag.Categories = Categories; ViewBag.CategoriesVIP = CategoriesVIP; #region create if (TaskID == 0) { return(View(new MainTask())); } #endregion // nếu != 0 => Sửa dữ liệu #region Edit var data = db.MainTasks.Where(z => z.Id == TaskID).FirstOrDefault(); data = data ?? new MainTask(); ViewBag.SeoUrl = "http://" + Request.Url.Authority + "/post/info?id=" + data.SeoUrl; // hoàn thành hoặc Hủy thì không được sửa nữa //if (!(data.AttendPerson+"").ToUpper().Contains(nguoidung.UserName.ToUpper())) //{ // return Content("Bạn không được quyền chỉnh sửa dữ liệu này" + MvcApplication.HomePage); //} return(View(data)); #endregion } }