public void AddNotify(MainTask Task, string NOIDUNG, string UseSend, string URL = "/Tasks/Info?ID=")
{
var ToUse = GetPeopleOfTask(Task).Where(z => z != UseSend);
using (Models.Planner2Entities db = new Planner2Entities())
{
if (NOIDUNG.Length >= 2000)
{
NOIDUNG = NOIDUNG.Substring(0, 2000);
}
Models.Notify tim = new Notify();
tim.NOIDUNG = NOIDUNG;
tim.URL = URL + Task.Id.ToString();
tim.TaskID = Task.Id;
var nguoidung = (Planner2.Models.User)Session[Planner2.Controllers.LoginAuth.NameSession];
tim.CREATE_BY = nguoidung.UserName;
tim.CREATED = DateTime.Now;
db.Notifies.Add(tim);
db.SaveChanges();
foreach (var item in ToUse)
{
var u = new NotifyUser();
u.NotifyID = tim.ID;
u.TaskID = tim.TaskID;
u.ToUser = item;
u.ReadNotify = false;
db.NotifyUsers.Add(u);
}
db.SaveChanges();
}
}
public void AddHistory(int TaskID, string NoiDung = "", string Notify = "")
{
if (NoiDung == "")
{
return;
}
if (Notify == "")
{
Notify = NoiDung;
}
var nguoidung = (Planner2.Models.User)Session[Planner2.Controllers.LoginAuth.NameSession];
History his = new History();
his.DATECREATE = DateTime.Now;
his.StaffID = nguoidung.UserName;
his.TaskID = TaskID;
his.NOIDUNG = NoiDung;
using (Planner2Entities db = new Planner2Entities())
{
db.Histories.Add(his);
db.SaveChanges();
var data = db.MainTasks.Where(z => z.Id == TaskID).FirstOrDefault();
AddNotify(data, Notify, nguoidung.UserName);
}
// Models.BackUpDB.BackUpNow();
}
public JsonResult Update_StaffOn(Category obj)
{
using (Planner2Entities rrc_db = new Planner2Entities())
{
Category a = rrc_db.Categories.Find(obj.CategoryRowID);
bool result = false;
a.Description = obj.Description ?? a.Description;
a.ParentID = obj.ParentID ?? a.ParentID;
a.Menu = obj.Menu ?? a.Menu;
a.CategoryName = obj.CategoryName ?? a.CategoryName;
a.STT = obj.STT ?? a.STT;
a.onePrice = obj.onePrice ?? a.onePrice;
a.Price7Day = obj.Price7Day ?? a.Price7Day;
a.Price15Day = obj.Price15Day ?? a.Price15Day;
a.Price30Day = obj.Price30Day ?? a.Price30Day;
a.Price2Month = obj.Price2Month ?? a.Price2Month;
a.Price3Month = obj.Price3Month ?? a.Price3Month;
a.Price6Month = obj.Price6Month ?? a.Price6Month;
a.Price1Year = obj.Price1Year ?? a.Price1Year;
a.Price2Year = obj.Price2Year ?? a.Price2Year;
a.Price5Year = obj.Price5Year ?? a.Price5Year;
a.SeoUrl = Extentions.SeoUrl.SeoURL(a.CategoryName);
rrc_db.SaveChanges();
MvcApplication.ReloadSetting();
result = true;
return(Json(new { result = result, data = a }, 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 ActionResult addDanhMuc(int DM, string TYPECHOOSE)
{
using (Models.Planner2Entities db = new Planner2Entities())
{
var nguoidung = (Planner2.Models.User)Session[Planner2.Controllers.LoginAuth.NameSession];
var nd = db.Users.Where(c => c.Id == nguoidung.Id).FirstOrDefault();
nd.SoTien = nd.SoTien ?? 0;
var data = db.Categories.Where(v => v.CategoryRowID == DM).FirstOrDefault();
var dmlast = db.User_Category.Where(v => v.CategoryRowID == DM && v.UserName.ToUpper() == nguoidung.UserName.ToUpper()).FirstOrDefault();
if (dmlast == null)
{
dmlast = new User_Category();
dmlast.CategoryRowID = DM;
dmlast.UserName = nguoidung.UserName;
dmlast.UserID = nguoidung.Id;
dmlast.NgayHetHan = DateTime.Now;
}
double?Tien = 0;
switch (TYPECHOOSE)
{
case "Price7Day": Tien = data.Price7Day; dmlast.NgayHetHan = dmlast.NgayHetHan.Value.AddDays(7); break;
case "Price15Day": Tien = data.Price15Day; dmlast.NgayHetHan = dmlast.NgayHetHan.Value.AddDays(15); break;
case "Price30Day": Tien = data.Price30Day; dmlast.NgayHetHan = dmlast.NgayHetHan.Value.AddDays(30); break;
case "Price2Month": Tien = data.Price2Month; dmlast.NgayHetHan = dmlast.NgayHetHan.Value.AddMonths(2); break;
case "Price3Month": Tien = data.Price3Month; dmlast.NgayHetHan = dmlast.NgayHetHan.Value.AddMonths(3); break;
case "Price6Month": Tien = data.Price6Month; dmlast.NgayHetHan = dmlast.NgayHetHan.Value.AddMonths(6); break;
case "Price1Year": Tien = data.Price1Year; dmlast.NgayHetHan = dmlast.NgayHetHan.Value.AddYears(1); break;
case "Price2Year": Tien = data.Price2Year; dmlast.NgayHetHan = dmlast.NgayHetHan.Value.AddYears(2); break;
case "Price5Year": Tien = data.Price5Year; dmlast.NgayHetHan = dmlast.NgayHetHan.Value.AddYears(5); break;
default:
break;
}
if (Tien > nd.SoTien)
{
return(Json("Số tiền bạn đang có không đủ để mua gói này, vui lòng nạp thêm", JsonRequestBehavior.AllowGet));
}
nd.SoTien = nd.SoTien.Value - (int)Tien.Value;
if (dmlast.ID == 0)
{
db.User_Category.Add(dmlast);
}
db.SaveChanges();
Session[Planner2.Controllers.LoginAuth.NameSession] = nd;
return(Json("", JsonRequestBehavior.AllowGet));
}
}
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 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 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 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 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));
}
}
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 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 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 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 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 GuiPhanHoi(CommentTask item)
{
using (Models.Planner2Entities db = new Planner2Entities())
{
item.DateCreate = DateTime.Now;
db.CommentTasks.Add(item);
db.SaveChanges();
var date = DateTime.Now.Date;
var task = db.MainTasks
.Where(v => v.FinishDate >= date && v.StartDate <= date).Where(v => v.Id == item.TaskID).FirstOrDefault();
if (task != null)
{
var seourl = db.MainTasks
.Where(v => v.FinishDate >= date && v.StartDate <= date).Where(v => v.Id == item.TaskID).Select(v => v.SeoUrl).FirstOrDefault();
var HOST = "http://" + Request.Url.Authority + "/post/info?id=" + seourl;
var html = @"<b>Xin chào " + task.Map_TenLienLac + @"</b>, <br>
Bài đăng của bạn trên website " + Common.SettingData.TenCongTy + @" có người phản hồi:
<br>";
html += " <b>Tiêu đề</b>: " + item.TieuDe + @"<br>";
html += " <b>Họ tên</b>: " + item.HoTen + @"<br>";
html += " <b>Địa chỉ</b>: " + item.DiaChi + @"<br>";
html += " <b>Email</b>: " + item.Email + @"<br>";
html += " <b>Điện thoại: </b>:" + item.DienThoai + @"<br>";
html += " <b>Mục đích: </b>:" + item.MucDich + @"<br>";
html += " <b>Nội dung: </b>:" + item.NOIDUNG + @"<br>";
html += "<a href='" + HOST + "'><H3>Click vào đây để xem chi tiết</H3></a>";
html += "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(task.Map_Email);
Module.SendMail.SendEmail(nguoinhan, Common.SettingData.TenCongTy + ": Phản hồi : " + task.TaskName, html, "", Common.SettingData.TenCongTy);
}
}
return(Json("", JsonRequestBehavior.AllowGet));
}
public void AddHistory(int TaskID, string NoiDung = "")
{
if (NoiDung == "")
{
return;
}
var nguoidung = (Planner2.Models.User)Session[Planner2.Controllers.LoginAuth.NameSession];
History his = new History();
his.DATECREATE = DateTime.Now;
his.StaffID = nguoidung.UserName;
his.TaskID = TaskID;
his.NOIDUNG = NoiDung;
using (Planner2Entities db = new Planner2Entities())
{
db.Histories.Add(his);
db.SaveChanges();
}
}
public ActionResult Edit(User item, HttpPostedFileBase AvartaImg = null)
{
using (Models.Planner2Entities db = new Planner2Entities())
{
var file = SubmitFile(new List <HttpPostedFileBase> {
AvartaImg
});
var nguoidung = (Planner2.Models.User)Session[Planner2.Controllers.LoginAuth.NameSession];
var user = db.Users.Where(v => v.Id == nguoidung.Id).FirstOrDefault();
user.Email = item.Email;
user.SDT = item.SDT;
user.DiaChi = item.DiaChi;
user.StaffName = item.StaffName;
if (file.Count > 0)
{
user.AvartaImg = string.Join("|", file);
}
db.SaveChanges();
Session[Planner2.Controllers.LoginAuth.NameSession] = user;
return(RedirectToAction("index", "Profile"));
}
}