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