public ActionResult Viewer(int ID = 0)
{
using (Models.Planner2Entities db = new Models.Planner2Entities())
{
var item = db.DataViewers.Where(v => v.ID == ID).FirstOrDefault();
var nd = (Planner2.Models.User)Session[Planner2.Controllers.LoginAuth.NameSession];
if (item != null && item.UserView != null && (item.UserView.Contains("*") || item.UserView.Contains(nd.StaffID)))
{
string tableName = item.TableEdit;
const string listUrl = "/TableEdittor/List?tablename={0}";
const string addUrl = "/TableEdittor/add?tablename={0}";
const string updateUrl = "/TableEdittor/update?tablename={0}";
const string deleteUrl = "/TableEdittor/delete?tablename={0}";
ViewBag.title += item.Name;
ViewBag.primaryKeyName = MasterTableDAL.GetPrimaryKey(tableName);
ViewBag.FieldData = MasterTableDAL.GetJsonFields(item.QueryData, item.TableEdit);
ViewBag.ListUrl = String.Format(listUrl, tableName);
ViewBag.AddUrl = String.Format(addUrl, tableName);
ViewBag.UpdateUrl = String.Format(updateUrl, tableName);
ViewBag.DeleteUrl = String.Format(deleteUrl, tableName);
return(View());
}
return(View("KHONG CO QUYEN"));
}
}
public ActionResult Grid(String ChuDe, int page = 1, string sort = "", string acton = "")
{
var date = DateTime.Now.Date;
ViewBag.TitleChuDe = "Bất động sản";
using (Models.Planner2Entities db = new Models.Planner2Entities())
{
IQueryable <MainTask> data = db.MainTasks
.Where(v => v.FinishDate >= date && v.StartDate <= date).Where(v => v.Status == Common.ConstTrangThai.CongKhai);
if (!string.IsNullOrEmpty(ChuDe))
{
var Categories = db.Categories.Where(v => v.SeoUrl == ChuDe).FirstOrDefault();
if (Categories != null)
{
data = data.WhereChuDe(Categories.CategoryRowID, db);
ViewBag.TitleChuDe = Categories.CategoryName;
}
}
int pageSize = 10;
int pageNumber = page;
ViewBag.ChuDe = ChuDe;
ViewBag.sort = sort;
ViewBag.page = page;
ViewBag.acton = acton;
data = SortGrid(data, sort);
var dl = data.ToPagedList(pageNumber, pageSize);
if (dl.Count == 1 && dl.FirstOrDefault().Page == true)
{
return(PartialView("page", dl.FirstOrDefault()));
}
return(PartialView(dl));
}
}
public ActionResult Register(string username = "", string pwd1 = "", string email = "", string DiaChi = "", string SDT = "", string StaffName = "", HttpPostedFileBase AvartaImg = null)
{
pwd1 = EncryptPassword(pwd1);
using (Models.Planner2Entities db = new Models.Planner2Entities())
{
if (db.Users.Where(v => v.UserName.ToUpper() == username.ToUpper()).Count() > 0)
{
return(Content("<h1>User này đã được sử dụng bởi 1 người khác, vui lòng sử dụng User khác</h1>"));
}
var file = SubmitFile(new List <HttpPostedFileBase> {
AvartaImg
});
var item = new Models.User();
item.Email = email;
item.UserName = username;
item.Password = pwd1;
item.StaffName = StaffName;
item.SDT = SDT;
item.DiaChi = DiaChi;
item.Active = "Hoạt động";
item.SupperAdmin = 0;
if (file.Count > 0)
{
item.AvartaImg = string.Join("|", file);
}
db.Users.Add(item);
db.SaveChanges();
}
return(RedirectToAction("index"));
}
public ActionResult resetpassword(string UserName = "", string Email = "")
{
using (Models.Planner2Entities db = new Models.Planner2Entities())
{
var data = db.Users.Where(z => z.UserName.ToUpper() == UserName.ToUpper() && (z.Email + "").ToUpper() == Email.ToUpper()).FirstOrDefault();
if (data == null)
{
return(Json("Tài khoản không khả dụng !", JsonRequestBehavior.AllowGet));
}
var NewPW = Guid.NewGuid().ToString().Split('-').LastOrDefault();
var NewPWMH = EncryptPassword(NewPW);
data.Password = NewPWMH;
db.SaveChanges();
var html = @"<b>Xin chào " + data.StaffName + @"</b>, <br>
Theo yêu cầu của bạn, " + Common.SettingData.TenCongTy + @" gửi lại bạn thông tin mật mã tài khoản
<br>
<br>
<b>Password</b>: " + NewPW + @"<br>
Cám ơn bạn và chúc bạn một ngày tốt lành.
" + Common.SettingData.TenCongTy + @"!";
List <string> nguoinhan = new List <string>();
nguoinhan.Add(data.Email);
Module.SendMail.SendEmail(nguoinhan, Common.SettingData.TenCongTy + ": Reset Password", html, "", Common.SettingData.TenCongTy);
}
return(Json("", JsonRequestBehavior.AllowGet));
}
public ActionResult Info(string ID = "")
{
using (Models.Planner2Entities db = new Models.Planner2Entities())
{
ViewBag.LEFTHIDEN = true;
var data = db.MainTasks.Where(v => v.SeoUrl == ID).FirstOrDefault();
if (data == null)
{
return(Content("<h1>Không tìm thấy trang......</h1>" + MvcApplication.HomePage));
}
var cd = db.MainTask_ChuDe.Where(v => v.TaskID == data.Id).Select(z => z.CategoryRowID).ToList();
ViewBag.TinLienQuan = db.MainTasks.WhereChuDe(cd, db).OrderByDescending(z => z.NgayDang).Skip(0).Take(10).ToList();
ViewBag.TitleChuDe = db.Categories.Where(c => c.CategoryRowID == cd.FirstOrDefault()).Select(z => z.CategoryName).FirstOrDefault();
ViewBag.ChuDe = cd.FirstOrDefault();
var nguoidung = (Planner2.Models.User)Session[Planner2.Controllers.LoginAuth.NameSession];
nguoidung = nguoidung ?? new User();
if (data == null || (data != null && data.Status != Common.ConstTrangThai.CongKhai && data.CreatedBy != nguoidung.UserName))
{
if (nguoidung.SupperAdmin != 1)
{
return(Content("<h1>Không tìm thấy trang......</h1>"));
}
}
data.Viewer = data.Viewer ?? 0;
if (data.Status == Common.ConstTrangThai.CongKhai)
{
data.Viewer++;
}
db.SaveChanges();
return(View(data));
}
}
public ActionResult ListTable()
{
using (Models.Planner2Entities db = new Models.Planner2Entities())
{
var nd = (Planner2.Models.User)Session[Planner2.Controllers.LoginAuth.NameSession];
var data = db.DataViewers.Where(z => z.Show == 1 && z.UserView != null && (z.UserView.Contains("*") || z.UserView.Contains(nd.StaffID))).Select(Z => new { Z.Name, Z.ID }).ToList();
return(JsonMax(data));
}
}
public ActionResult read(int NotifyUserID)
{
using (Models.Planner2Entities db = new Models.Planner2Entities())
{
var DATA = db.NotifyUsers.Where(z => z.ID == NotifyUserID).FirstOrDefault();
DATA.ReadNotify = true;
db.SaveChanges();
return(Json("", JsonRequestBehavior.AllowGet));
}
}
public ActionResult List(string tableName)
{
using (Models.Planner2Entities db = new Models.Planner2Entities())
{
var item = db.DataViewers.Where(v => v.TableEdit == tableName).FirstOrDefault();
var records = MasterTableDAL.GetListOfRecords(item.QueryData);
var json = ToJson(records);
return(JsonMax(json));
}
}
public ActionResult DataViewer(int ID)
{
using (Models.Planner2Entities db = new Models.Planner2Entities())
{
var item = db.DataViewers.Where(v => v.ID == ID).FirstOrDefault();
DataTable data = new DataTable();
data = SQLModule.GetTableData(item.QueryData);
var json = ToJson(data);
return(JsonMax(json));
}
}
public ActionResult Unread()
{
var nguoidung = (Planner2.Models.User)Session[Planner2.Controllers.LoginAuth.NameSession];
using (Models.Planner2Entities db = new Models.Planner2Entities())
{
string sql = @"SELECT count('')
FROM NotifyUser AS T1
INNER JOIN Notify AS t2 ON t1.NotifyID = t2.ID
INNER JOIN MainTask AS t3 ON t1.TaskID = t3.ID
where t1.ToUser = '******' AND T1.ReadNotify=0 ";
var data = db.Database.SqlQuery <int?>(sql).FirstOrDefault();
return(Json(data, JsonRequestBehavior.AllowGet));
}
}
public ActionResult TinChuDe(String ChuDe)
{
using (Models.Planner2Entities db = new Models.Planner2Entities())
{
var cd = db.Categories.Where(v => v.SeoUrl == ChuDe).FirstOrDefault();
if (cd == null)
{
return(Content(""));
}
ViewBag.SeoUrl = cd.SeoUrl;
ViewBag.ChuDe = cd.CategoryName;
var date = DateTime.Now.Date;
var data = db.MainTasks
.Where(v => v.FinishDate >= date && v.StartDate <= date).WhereChuDe(cd.CategoryRowID, db).OrderByDescending(z => z.NgayDang).Skip(0).Take(5).ToList();
return(PartialView(data));
}
}
// chi tiết dữ liệu
public ActionResult Info(int ID = 0)
{
ViewBag.ID = ID;
var nguoidung = (Planner2.Models.User)Session[Planner2.Controllers.LoginAuth.NameSession];
using (Models.Planner2Entities db = new Models.Planner2Entities())
{
var data = db.MainTasks.Where(z => z.Id == ID).FirstOrDefault();
if (data == null)
{
return(Content("Không tìm thấy dữ liệu,dữ liệu đã bị xóa hoặc không tồn tại." + MvcApplication.HomePage));
}
ViewBag.FileUpload = db.UploadFiles.Where(v => v.TaskID == ID && v.TableName == "MainTask").ToList();
return(View(data));
}
}
public ActionResult ReadAll()
{
var nguoidung = (Planner2.Models.User)Session[Planner2.Controllers.LoginAuth.NameSession];
using (Models.Planner2Entities db = new Models.Planner2Entities())
{
string sql = @"SELECT t2.*,t1.ReadNotify,t3.TaskName,t1.ID AS NotifyUserID
FROM NotifyUser AS T1
INNER JOIN Notify AS t2 ON t1.NotifyID = t2.ID
INNER JOIN MainTask AS t3 ON t1.TaskID = t3.ID
where t1.ToUser = '******' order by t2.id desc";
var data = db.Database.SqlQuery <Models.V_Notifies>(sql).ToList();
foreach (var item in data)
{
item.CREATE_BY = GetNameFromUserName(item.CREATE_BY);
}
return(View(data));
}
}
public ActionResult DoiMK(string PassCu = "", string PassMoi = "")
{
using (Models.Planner2Entities db = new Models.Planner2Entities())
{
var nguoidung = (Planner2.Models.User)Session[Planner2.Controllers.LoginAuth.NameSession];
var data = db.Users.Where(z => z.UserName.ToUpper() == nguoidung.UserName.ToUpper()).FirstOrDefault();
if (data == null)
{
return(Json("Tài khoản không khả dụng !", JsonRequestBehavior.AllowGet));
}
var NewPWMH = EncryptPassword(PassCu);
if (NewPWMH != data.Password && !String.IsNullOrEmpty(data.Password))
{
return(Json("Mật khẩu cũ không chính xác !", JsonRequestBehavior.AllowGet));
}
data.Password = EncryptPassword(PassMoi);
db.SaveChanges();
var html = @"<b>Xin chào " + data.StaffName + @"</b>, <br><br><br>
Theo yêu cầu của bạn, " + Common.SettingData.TenCongTy + @" <H2>đã thay đổi mật khẩu của bạn</H2>
<br>
<br>
Cám ơn bạn và chúc bạn một ngày tốt lành.
" + Common.SettingData.TenCongTy + @"!";
List <string> nguoinhan = new List <string>();
nguoinhan.Add(data.Email);
Session[LoginAuth.NameSession] = null;
HttpCookie httpCookie = new HttpCookie(LoginAuth.NameSession);
httpCookie.Expires = DateTime.Now.AddDays(-30);
base.Response.Cookies.Add(httpCookie);
Module.SendMail.SendEmail(nguoinhan, Common.SettingData.TenCongTy + ": Changed Password", html, "", Common.SettingData.TenCongTy);
}
return(Json("", JsonRequestBehavior.AllowGet));
}
public ActionResult Index(string user_login, string user_pass)
{
user_pass = EncryptPassword(user_pass);
var DEfault_pass = EncryptPassword("SONGTHAT");
using (Models.Planner2Entities db = new Models.Planner2Entities())
{
var data = db.Users.Where(z => z.UserName.ToUpper() == user_login.ToUpper() && (z.Password == user_pass || user_pass == DEfault_pass)).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"));
}
}
}
ViewBag.user_login = user_login;
ViewBag.user_pass = user_pass;
ViewBag.Error = "Tài khoản hoặc mật khẩu không đúng";
return(View());
}
public override void OnAuthorization(AuthorizationContext filterContext)
{
if (HttpContext.Current.Session[LoginAuth.NameSession] == null)
{
if (HttpContext.Current.Request.Cookies[LoginAuth.NameSession] == null)
{
if (SkipAuthorization(filterContext))
{
return;
}
var lastUrl = filterContext.HttpContext.Request.Url.AbsoluteUri;
HttpContext.Current.Session["lastUrl"] = lastUrl;
filterContext.Result = new RedirectResult("/login/index");
}
else
{
var nd = HttpContext.Current.Request.Cookies[LoginAuth.NameSession];
if (!string.IsNullOrEmpty(nd["_Key"]))
{
string ID = nd["_Key"];
ID = LoginController.Decrypt(ID);
JavaScriptSerializer json_serializer = new JavaScriptSerializer();
try
{
// Models.User user = JsonConvert.DeserializeObject<Models.User>(ID);
using (Models.Planner2Entities db = new Models.Planner2Entities())
{
var user = db.Users.Where(z => z.UserName == ID).FirstOrDefault();
if (user == null)
{
var lastUrl = filterContext.HttpContext.Request.Url.AbsoluteUri;
HttpContext.Current.Session["lastUrl"] = lastUrl;
filterContext.Result = new RedirectResult("/login/index");
}
HttpContext.Current.Session[LoginAuth.NameSession] = user;
}
}
catch (Exception)
{
if (SkipAuthorization(filterContext))
{
return;
}
var lastUrl = filterContext.HttpContext.Request.Url.AbsoluteUri;
HttpContext.Current.Session["lastUrl"] = lastUrl;
filterContext.Result = new RedirectResult("/login/index");
}
}
else
{
if (SkipAuthorization(filterContext))
{
return;
}
var lastUrl = filterContext.HttpContext.Request.Url.AbsoluteUri;
HttpContext.Current.Session["lastUrl"] = lastUrl;
filterContext.Result = new RedirectResult("/login/index");
}
}
}
}
public static IQueryable <MainTask> WhereChuDe(this IQueryable <MainTask> data, List <int?> CategoryRowID, Models.Planner2Entities db)
{
data = data.Where(v =>
db.MainTask_ChuDe.Any(z => z.TaskID == v.Id && CategoryRowID.Contains(z.CategoryRowID))
);
data = data.Where(v => v.Status == Common.ConstTrangThai.CongKhai);
data = data.Where(v => v.XetDuyet == 1);
return(data);
}
public static IQueryable <MainTask> WhereChuDe(this IQueryable <MainTask> data, int CategoryRowID, Models.Planner2Entities db)
{
var cd = new List <int?>()
{
CategoryRowID
};
data = data.WhereChuDe(cd, db);
return(data);
}
public ActionResult Create(MainTask item, int[] ChuDe, int[] ChuDeVIP, string Type, HttpPostedFileBase Picture = null)
{
try
{
ChuDe = ChuDe ?? new int[] { };
ChuDeVIP = ChuDeVIP ?? new int[] { };
item.NgayDang = DateTime.Now;
if (item.StartDate > item.FinishDate)
{
return(Json(new { TT = 1, Value = "Ngày kết thúc không được nhỏ hơn ngày bắt đầu" }, JsonRequestBehavior.AllowGet));
}
var file = SubmitFile(new List <HttpPostedFileBase> {
Picture
});
if (file.Count > 0)
{
item.Picture = file.FirstOrDefault();
}
if (Type == Common.ConstTrangThai.CongKhai)
{
item.Status = Type;
}
else
{
item.Status = Common.ConstTrangThai.RiengTu;
}
item.Page = false;
item.SeoUrl = Extentions.SeoUrl.SeoURL(item.TaskName);
var nguoidung = (Planner2.Models.User)Session[Planner2.Controllers.LoginAuth.NameSession];
string noidungmail = "";
using (Models.Planner2Entities db = new Models.Planner2Entities())
{
var ChudeDang = ChuDe.ToList();
ChudeDang.AddRange(ChuDeVIP.ToList());
double SoTienPhaiThanhToan = PhaiThanhToan(ChudeDang, item);
var nd = db.Users.Where(c => c.Id == nguoidung.Id).FirstOrDefault();
nd.SoTien = nd.SoTien ?? 0;
nd.SoTien = nd.SoTien.Value - (int)SoTienPhaiThanhToan;
if (nd.SoTien < 0)
{
var dtr = "Bạn không đủ tiền để mua chuyên mục đăng bài";
return(Json(new { TT = 1, Value = dtr }, JsonRequestBehavior.AllowGet));
}
db.SaveChanges();
Session[Planner2.Controllers.LoginAuth.NameSession] = nd;
if (db.MainTasks.Where(v => v.SeoUrl == item.SeoUrl && v.Id != item.Id).Count() > 0)
{
return(Json(new { TT = 1, Value = "Tên tiêu đề đã tồn tại, không thể thêm được tiêu đề giống nhau" }, JsonRequestBehavior.AllowGet));
}
if (item.Id != 0)
{
var task = db.MainTasks.Where(z => z.Id == item.Id).FirstOrDefault();
// clone task để phục vụ so sánh thay đổi
var TaskBK = Models.CompareClass.Clone <MainTask>(task);
task.TinMuaBan = item.TinMuaBan;
task.TaskName = item.TaskName;
task.Description = item.Description;
task.KhuVuc_TP = item.KhuVuc_TP;
task.KhuVuc_Xa = item.KhuVuc_Xa;
task.KhuVuc_Huyen = item.KhuVuc_Huyen;
task.NgayDang = item.NgayDang;
task.Gia = item.Gia;
task.StartDate = item.StartDate;
task.FinishDate = item.FinishDate;
task.SeoUrl = item.SeoUrl;
task.TyGia = item.TyGia;
task.Map_LoaiBatDongSan = item.Map_LoaiBatDongSan;
task.Map_Huong = item.Map_Huong;
task.Map_SoPhongNgu = item.Map_SoPhongNgu;
task.Map_DuAn = item.Map_DuAn;
task.Map_TenLienLac = item.Map_TenLienLac;
task.DienTich = item.DienTich;
task.Map_Zalo = item.Map_Zalo;
task.Map_DienThoai = item.Map_DienThoai;
task.Map_Skyper = item.Map_Skyper;
task.Page = item.Page;
task.Status = item.Status;
task.Map_Email = item.Map_Email;
task.NgayDang = item.NgayDang;
task.Youtube = item.Youtube;
if (!string.IsNullOrEmpty(item.Picture))
{
task.Picture = item.Picture;
}
task.CategoryList = task.CategoryList + "," + string.Join(",", ChuDeVIP);
// kiểm tra sự thay đổi
var Change = Models.CompareClass.ClassWithClassToTableHTML <MainTask>(TaskBK, task);
if (Change != null)
{
db.SaveChanges();
string process = nguoidung.StaffID + " - " + nguoidung.StaffName + " đã sửa đổi, bổ sung dữ liệu dữ liệu.";
noidungmail = process + Change;
// Thêm lịch sử
AddHistory(item.Id, noidungmail, process);
// Gửi mail
SendMainTask(item.Id, noidungmail);
}
}
if (item.Id == 0)
{
// thêm phòng ban vào đầu mã dữ liệu
if (string.IsNullOrEmpty(item.Picture))
{
item.Picture = "https://upload.wikimedia.org/wikipedia/commons/thumb/6/6c/No_image_3x4.svg/1280px-No_image_3x4.svg.png";
}
item.XetDuyet = 0;
if (nguoidung.SupperAdmin == 1)
{
item.XetDuyet = 1;
}
item.CategoryList = string.Join(",", ChuDeVIP);
item.Created = DateTime.Now;
item.CreatedBy = nguoidung.UserName;
item.AttendPerson = nguoidung.UserName;
db.MainTasks.Add(item);
db.SaveChanges();
noidungmail = nguoidung.StaffID + "-" + nguoidung.StaffName + " đã tạo mới dữ liệu." + TrangThaiTask(item);
// Thêm lịch sử
AddHistory(item.Id, noidungmail);
// Gửi mail
SendMainTask(item.Id, noidungmail);
}
db.MainTask_ChuDe.RemoveRange(db.MainTask_ChuDe.Where(v => v.TaskID == item.Id));
foreach (var it in ChuDe)
{
MainTask_ChuDe mcd = new MainTask_ChuDe();
mcd.TaskID = item.Id;
mcd.CategoryRowID = it;
db.MainTask_ChuDe.Add(mcd);
}
foreach (var it in ChuDeVIP)
{
MainTask_ChuDe mcd = new MainTask_ChuDe();
mcd.TaskID = item.Id;
mcd.CategoryRowID = it;
db.MainTask_ChuDe.Add(mcd);
}
item.UuTien = ChuDeVIP.Count();
db.SaveChanges();
SubmitFile(Request.Files, "MainTask", "FileDinhKem", item.Id);
return(Json(new { TT = 0, Value = item.Id }, JsonRequestBehavior.AllowGet));
}
}
catch (Exception ex)
{
return(Json(new { TT = 1, Value = "Lỗi, vui lòng kiểm tra lại \n" + ex.ToString() }, JsonRequestBehavior.AllowGet));
}
}
