public override void ActionCancel()
{
CPViewPage.CPRedirectHome();
}
/// <summary>
/// Chốt kỳ kinh doanh
/// </summary>
/// <param name="model"></param>
public void ActionChotKy(ModDT_KyModel model)
{
CPViewPage.Message.MessageType = Message.MessageTypeEnum.Error;
DbDataContext db = DbExecute.Create(true);
Mod_DT_Ky objMod_DT_Ky = db.Mod_DT_Kies.Where(o => o.ID == model.RecordID).SingleOrDefault();
if (objMod_DT_Ky == null)
{
CPViewPage.Message.ListMessage.Add("Không tìm thấy kỳ kinh doanh hiện tại.");
return;
}
// Cập nhật trạng thái cho Kỳ
objMod_DT_Ky.Activity = false; // Đóng kỳ
// Tổng hợp lại các giá trị hoa hồng cho từng đại lý
if (objMod_DT_Ky.Mod_DT_Ky_DaiLies == null || objMod_DT_Ky.Mod_DT_Ky_DaiLies.Count <= 0)
{
db.SubmitChanges();
return;
}
List <Mod_DT_Ky_DaiLy> lstMod_DT_Ky_DaiLy = objMod_DT_Ky.Mod_DT_Ky_DaiLies.ToList();
lstMod_DT_Ky_DaiLy = lstMod_DT_Ky_DaiLy.OrderBy(o => o.ModProductAgentParentId).ToList();
// Tính tổng tiền lấy hàng
foreach (var itemKyDaiLy in lstMod_DT_Ky_DaiLy)
{
List <Mod_DT_Ky_DaiLy_DonHang> lstMod_DT_Ky_DaiLy_DonHang = itemKyDaiLy.Mod_DT_Ky_DaiLy_DonHangs.ToList();
double doubTongTienLayHang = 0;
foreach (var itemDaiLy_DonHang in lstMod_DT_Ky_DaiLy_DonHang)
{
doubTongTienLayHang += getValueDouble(itemDaiLy_DonHang.TongSauGiam);
}
// Cập nhật tổng tiền
itemKyDaiLy.TongTienLayHang = doubTongTienLayHang;
}
// Lấy cấp tỷ lệ ăn chia hoa hồng
List <Mod_DT_CapDaiLy_TyLe> lstMod_DT_CapDaiLy_TyLe = db.Mod_DT_CapDaiLy_TyLes.OrderBy(o => o.ID).ToList();
// Lấy các cấp cha để duyệt
List <Mod_DT_Ky_DaiLy> lstMod_DT_Ky_DaiLy_Parent = lstMod_DT_Ky_DaiLy
.Where(o => o.ModProductAgentParentId == null || o.ModProductAgentParentId == 0).ToList();
// TÍnh tổng hoa hồng trong kỳ
double doubTongHoaHong = 0;
foreach (var itemParent in lstMod_DT_Ky_DaiLy)
{
int iCapHoaHong = 0;
double doubTongTienHoaHong = 0;
// Cộng giá trị đầu kỳ nếu có
double doubTotalLast = getValueDouble(itemParent.TotalFirst);
// Lấy các đại lý con: Tính hoa hồng
List <Mod_DT_Ky_DaiLy> lstMod_DT_Ky_DaiLy_Child = lstMod_DT_Ky_DaiLy
.Where(o => o.ModProductAgentParentId != null && o.ModProductAgentParentId == itemParent.ModProductAgentId)
.ToList();
if (lstMod_DT_Ky_DaiLy_Child != null && lstMod_DT_Ky_DaiLy_Child.Count > 0)
{
// Tính hoa hồng cho đại lý cấp đầu trước (Nếu tồn tại ít nhất một con)
doubTongTienHoaHong = (getValueDouble(itemParent.TongTienLayHang) * getValueDouble(lstMod_DT_CapDaiLy_TyLe[iCapHoaHong].Value)) / 100;
}
// Duyệt các đại lý con
foreach (var itemChild in lstMod_DT_Ky_DaiLy_Child)
{
doubTongTienHoaHong += getTienHoaHong(ref lstMod_DT_Ky_DaiLy, itemChild, lstMod_DT_CapDaiLy_TyLe, iCapHoaHong + 1);
}
// Lưu lại tổng tiền hoa hồng
itemParent.TongTienHoaHong = doubTongTienHoaHong;
// Tổng tiền thu nhập cuối kỳ
itemParent.TotalLast = doubTotalLast + doubTongTienHoaHong;
// Tổng hoa hồng trong kỳ
doubTongHoaHong += doubTongTienHoaHong;
}
// Tính tổng hoa hồng trong kỳ
doubTongHoaHong += getValueDouble(objMod_DT_Ky.TotalFirst);
// Tổng hoa hồng trong kỳ
objMod_DT_Ky.TotalLast = doubTongHoaHong;
// Cập nhật vào DB
db.SubmitChanges();
// Hiển thị thông báo
CPViewPage.SetMessage("Đã chốt kỳ doanh thu thành công.");
CPViewPage.Response.Redirect(CPViewPage.Request.RawUrl.Replace("Add.aspx", "Index.aspx"));
}
public void ActionLogout()
{
CPViewPage.SetLog("Thoát khỏi hệ thống.");
CPLogin.Logout();
CPViewPage.CPRedirect("Login.aspx");
}
public void ActionUpload(SysConfigModel model)
{
CPViewPage.Script("Redirect", "REDDEVILRedirect('Import')");
}
public void ActionSendMailExcute(EmailEntity emailEntity)
{
ViewBag.Data = emailEntity;
CPViewPage.Message.MessageType = Message.MessageTypeEnum.Error;
if (string.IsNullOrEmpty(emailEntity.To))
{
CPViewPage.Message.ListMessage.Add("Bạn chưa nhập Email tiếp nhận.");
}
else
{
var toArr = emailEntity.To.Split(',');
foreach (var i in toArr)
{
if (Utils.GetEmailAddress(i) == string.Empty)
{
CPViewPage.Message.ListMessage.Add("Định dạng Email tiếp nhận không đúng.");
}
}
}
if (!string.IsNullOrEmpty(emailEntity.Cc))
{
var ccArr = emailEntity.Cc.Split(',');
foreach (var i in ccArr)
{
if (Utils.GetEmailAddress(i) == string.Empty)
{
CPViewPage.Message.ListMessage.Add("Định dạng Email Cc không đúng.");
}
}
}
if (string.IsNullOrEmpty(emailEntity.Subject))
{
CPViewPage.Message.ListMessage.Add("Bạn chưa nhập Tiêu đề.");
}
if (string.IsNullOrEmpty(emailEntity.Body))
{
CPViewPage.Message.ListMessage.Add("Bạn chưa nhập Nội dung.");
}
if (CPViewPage.Message.ListMessage.Count == 0)
{
// Goi ham send mail
string sendResult = Mail.SendMailUseSMTP(emailEntity.To, emailEntity.Cc, emailEntity.Subject, emailEntity.Body, emailEntity.Attach);
if (!string.IsNullOrEmpty(sendResult))
{
CPViewPage.Message.ListMessage.Add("Gửi mail lỗi. Hãy kiểm tra lại việc cấu hình email của bạn.");
}
else
{
CPViewPage.SetMessage("Gửi mail thành công.");
// Thuc hien tang so lan gui mail them 1
var incident = ModIncidentService.Instance.CreateQuery().Where(o => o.ID == emailEntity.RecordID).ToSingle();
incident.EmailNo++;
ModIncidentService.Instance.Save(incident);
}
}
}
public void ActionExport2(ModIncidentModel model)
{
RenderView(model.Menu);
//lấy danh sách
// sap xep tu dong
string orderBy = AutoSort(model.Sort);
string orderAdd = string.Empty;
if (model.Menu == "Phishing" && (model.PhishingState == 1 || model.PhishingState == 3) ||
model.Menu == "Malware" && (model.MalwareState == 1 || model.MalwareState == 3))
{
orderAdd += "ChildNum DESC";
}
else if (model.Menu == "Phishing" && (model.PhishingState == 2 || model.PhishingState == 4) ||
model.Menu == "Malware" && (model.MalwareState == 2 || model.MalwareState == 4))
{
orderAdd += "ChildNum ASC";
}
DateTime?f = HL.Core.Global.Convert.ToDateTime(model.From, DateTime.MinValue);
DateTime?t = HL.Core.Global.Convert.ToDateTime(model.To, DateTime.MaxValue);
DateTime?from = f != DateTime.MinValue ? f : null;
DateTime?to = t != DateTime.MaxValue ? t : null;
var all = ModIncidentService.Instance.CreateQuery()
.Where(model.State > 0, o => (o.State & model.State) == model.State)
.Where(from != null, o => o.AttackOn >= from)
.Where(to != null, o => o.AttackOn <= to)
.WhereIn(o => o.MenuID, WebMenuService.Instance.GetChildIDForCP("Incident", model.MenuID, model.LangID))
.ToList();
// Tao danh sach cha
DBQuery <ModIncidentEntity> dbQuery = null;
if (model.PhishingState == 1 || model.PhishingState == 2 || model.MalwareState == 1 || model.MalwareState == 2)
{
if (model.Menu == "Phishing")
{
dbQuery = ModIncidentService.Instance.CreateQuery()
.WhereIn(o => o.MenuID, WebMenuService.Instance.GetChildIDForCP("Incident", model.MenuID, model.LangID))
.Select(o => o.Path)
.Distinct();
}
if (model.Menu == "Malware")
{
dbQuery = ModIncidentService.Instance.CreateQuery()
.WhereIn(o => o.MenuID, WebMenuService.Instance.GetChildIDForCP("Incident", model.MenuID, model.LangID))
.Select(o => o.MalwareName)
.Distinct();
}
}
else
{
dbQuery = ModIncidentService.Instance.CreateQuery()
.WhereIn(o => o.MenuID, WebMenuService.Instance.GetChildIDForCP("Incident", model.MenuID, model.LangID))
.Select(o => o.ISP)
.Distinct();
}
var lst = dbQuery.ToList();
if (lst == null || all == null)
{
CPViewPage.SetMessage("Không có dữ liệu.");
return;
}
var listEntity = new List <ModIncidentEntity>();
if (model.Menu == "Phishing")
{
if (model.PhishingState == 1)
{
listEntity = dbQuery.ToList().Select(o => new ModIncidentEntity
{
Path = o.Path,
ISP = "",
AttackOn = null,
ChildNum = ModIncidentService.Instance.CreateQuery().Where(a => a.ParentID == o.ID).ToList().Count
})
.OrderByDescending(o => o.ChildNum)
.Take(model.PageSize)
.Skip(model.PageIndex * model.PageSize)
.ToList();
}
else if (model.PhishingState == 2)
{
listEntity = dbQuery.ToList().Select(o => new ModIncidentEntity
{
Path = o.Path,
ISP = "",
AttackOn = null,
ChildNum = ModIncidentService.Instance.CreateQuery().Where(a => a.ParentID == o.ID).ToList().Count
})
.OrderBy(o => o.ChildNum)
.Take(model.PageSize)
.Skip(model.PageIndex * model.PageSize)
.ToList();
}
else if (model.PhishingState == 3)
{
listEntity = dbQuery.ToList().Select(o => new ModIncidentEntity
{
Path = "",
ISP = o.ISP,
AttackOn = null,
ChildNum = ModIncidentService.Instance.CreateQuery().Where(a => a.ISP == o.ISP).ToList().Count
})
.OrderByDescending(o => o.ChildNum)
.Take(model.PageSize)
.Skip(model.PageIndex * model.PageSize)
.ToList();
}
else if (model.PhishingState == 4)
{
listEntity = dbQuery.ToList().Select(o => new ModIncidentEntity
{
Path = "",
ISP = o.ISP,
AttackOn = null,
ChildNum = ModIncidentService.Instance.CreateQuery().Where(a => a.ISP == o.ISP).ToList().Count
})
.OrderBy(o => o.ChildNum)
.Take(model.PageSize)
.Skip(model.PageIndex * model.PageSize)
.ToList();
}
else
{
listEntity = dbQuery.ToList().Select(o => new ModIncidentEntity
{
Path = o.Path,
ISP = "",
AttackOn = null,
ChildNum = ModIncidentService.Instance.CreateQuery().Where(a => a.ParentID == o.ID).ToList().Count
})
.OrderBy(o => o.Path)
.Take(model.PageSize)
.Skip(model.PageIndex * model.PageSize)
.ToList();
}
}
if (model.Menu == "Malware")
{
if (model.MalwareState == 1)
{
listEntity = dbQuery.ToList().Select(o => new ModIncidentEntity
{
MalwareName = o.MalwareName,
ISP = "",
AttackOn = null,
ChildNum = ModIncidentService.Instance.CreateQuery().Where(a => a.MalwareName == o.MalwareName).ToList().Count
})
.OrderByDescending(o => o.ChildNum)
.Take(model.PageSize)
.Skip(model.PageIndex * model.PageSize)
.ToList();
}
else if (model.MalwareState == 2)
{
listEntity = dbQuery.ToList().Select(o => new ModIncidentEntity
{
MalwareName = o.MalwareName,
ISP = "",
AttackOn = null,
ChildNum = ModIncidentService.Instance.CreateQuery().Where(a => a.MalwareName == o.MalwareName).ToList().Count
})
.OrderBy(o => o.ChildNum)
.Take(model.PageSize)
.Skip(model.PageIndex * model.PageSize)
.ToList();
}
else if (model.MalwareState == 3)
{
listEntity = dbQuery.ToList().Select(o => new ModIncidentEntity
{
MalwareName = "",
ISP = o.ISP,
AttackOn = null,
ChildNum = ModIncidentService.Instance.CreateQuery().Where(a => a.ISP == o.ISP).ToList().Count
})
.OrderByDescending(o => o.ChildNum)
.Take(model.PageSize)
.Skip(model.PageIndex * model.PageSize)
.ToList();
}
else if (model.MalwareState == 4)
{
listEntity = dbQuery.ToList().Select(o => new ModIncidentEntity
{
MalwareName = "",
ISP = o.ISP,
AttackOn = null,
ChildNum = ModIncidentService.Instance.CreateQuery().Where(a => a.ISP == o.ISP).ToList().Count
})
.OrderBy(o => o.ChildNum)
.Take(model.PageSize)
.Skip(model.PageIndex * model.PageSize)
.ToList();
}
else
{
listEntity = dbQuery.ToList().Select(o => new ModIncidentEntity
{
MalwareName = o.MalwareName,
ISP = "",
AttackOn = null,
ChildNum = ModIncidentService.Instance.CreateQuery().Where(a => a.MalwareName == o.MalwareName).ToList().Count
})
.OrderBy(o => o.Path)
.Take(model.PageSize)
.Skip(model.PageIndex * model.PageSize)
.ToList();
}
}
//khai báo tập hợp bản ghi excel
List <List <object> > list = new List <List <object> >();
//khai báo 1 dòng excel
List <object> _list = null;
for (int i = 0; listEntity != null && listEntity.Count > 0 && i < listEntity.Count; i++)
{
_list = new List <object>();
// _list.Add(i + 1);
if (model.PhishingState == 1)
{
_list.Add(listEntity[i].Path);
var ChildNum = ModIncidentService.Instance.CreateQuery().Where(a => a.ParentID == listEntity[i].ID).ToList().Count;
_list.Add(ChildNum);
}
else if (model.MalwareState == 1)
{
_list.Add(listEntity[i].MalwareName);
var ChildNum = ModIncidentService.Instance.CreateQuery().Where(a => a.MalwareName == listEntity[i].MalwareName).ToList().Count;
_list.Add(ChildNum);
}
else
{
_list.Add(listEntity[i].ISP);
var ChildNum = ModIncidentService.Instance.CreateQuery().Where(a => a.ISP == listEntity[i].ISP).ToList().Count;
_list.Add(ChildNum);
}
list.Add(_list);
}
//ghi exel
string temp_file = CPViewPage.Server.MapPath("~/Data/upload/files/Excel/BaoCaoSuCo_" + model.Menu + "_" +
string.Format("{0:yyyy_MM_dd}", DateTime.Now) + ".xlsx");
string filePath = CPViewPage.Server.MapPath("~/TTPortal/Templates/Export_Deface.xlsx");
Excel.Export(list, 1, filePath, temp_file);
CPViewPage.Response.Clear();
CPViewPage.Response.ContentType = "application/excel";
CPViewPage.Response.AppendHeader("Content-Disposition", "attachment; filename=" + System.IO.Path.GetFileName(temp_file));
CPViewPage.Response.WriteFile(temp_file);
CPViewPage.Response.End();
}
public override void ActionCancel()
{
CPViewPage.Script("Cancel", "Cancel()");
}
public void ActionApply(SysResourceModel model)
{
if (model.Type > 0)
{
if (model.Type == 1 && !string.IsNullOrEmpty(model.Value1))
{
string[] Arr = model.Value1.Split('\n');
for (int i = 0; i < Arr.Length; i++)
{
string s = Arr[i].Trim();
if (string.IsNullOrEmpty(s))
{
continue;
}
if (s.StartsWith("//"))
{
continue;
}
int index = s.IndexOf('=');
if (index == -1)
{
continue;
}
string key = s.Substring(0, index).Trim();
string value = s.Substring(index + 1).Trim();
if (WebResourceService.Instance.CP_HasExists(key, model.LangID1))
{
if (model.Overwrite1)
{
var rs = WebResourceService.Instance.CreateQuery()
.Where(o => o.LangID == model.LangID1 && o.Code == key)
.ToSingle();
rs.Value = value;
WebResourceService.Instance.Save(rs, o => o.Value);
}
}
else
{
WebResourceService.Instance.Save(new WebResourceEntity
{
LangID = model.LangID1,
Code = key,
Value = value
});
}
}
}
else if (model.Type == 2)
{
if (model.FLangID2 != model.TLangID2)
{
var listRS = WebResourceService.Instance.CreateQuery()
.Where(o => o.LangID == model.FLangID2)
.ToList();
for (int i = 0; listRS != null && i < listRS.Count; i++)
{
string key = listRS[i].Code;
string value = listRS[i].Value;
if (WebResourceService.Instance.CP_HasExists(key, model.TLangID2))
{
if (model.Overwrite2)
{
var rs = WebResourceService.Instance.CreateQuery()
.Where(o => o.LangID == model.TLangID2 && o.Code == key)
.ToSingle();
rs.Value = value;
WebResourceService.Instance.Save(rs, o => o.Value);
}
}
else
{
WebResourceService.Instance.Save(new WebResourceEntity
{
LangID = model.TLangID2,
Code = key,
Value = value
});
}
}
}
}
else if (model.Type == 3)
{
//var listRS = WebResourceService.Instance.CreateQuery()
// .Where(o => o.LangID == model.LangID3)
// .ToList();
//for (int i = 0; listRS != null && i < listRS.Count; i++)
//{
// string key = listRS[i].Code;
// string value = GetTranslate(listRS[i].Value, model.FLangID3, model.TLangID3);
// if (value != string.Empty)
// {
// listRS[i].Value = value;
// WebResourceService.Instance.Save(listRS[i], o => o.Value);
// }
//}
}
if ((model.Type == 1 && !string.IsNullOrEmpty(model.Value1)) || model.Type == 2 || model.Type == 3)
{
CPViewPage.SetMessage("Thông tin đã cập nhật.");
return;
}
}
if (ValidSave(model))
{
ApplyRedirect(model.RecordID, item.ID);
}
}
public void ActionUpload(SysResourceModel model)
{
CPViewPage.Script("Redirect", "VSWRedirect('Import')");
}
public void ActionExport(ModNhanLucUCSCModel model)
{
//lấy danh sách
// sap xep tu dong
string orderBy = AutoSort(model.Sort);
var lstDonDk = ModDonDangKyUCSCService.Instance.CreateQuery()
.Where(o => o.UserID == model.ThanhVienID && o.Activity == true)
.ToSingle();
var lstHSThanhVien = ModHSThanhVienUCSCService.Instance.CreateQuery()
.Where(o => o.UserID == model.ThanhVienID && o.Activity == true)
.ToSingle();
int donDk = 0, hsThanhVien = 0;
if (lstDonDk != null)
{
donDk = lstDonDk.ID;
}
if (lstHSThanhVien != null)
{
hsThanhVien = lstHSThanhVien.ID;
}
// tao danh sach
var dbQuery = ModNhanLucUCSCService.Instance.CreateQuery()
.Where(!string.IsNullOrEmpty(model.SearchText), o => o.Name.Contains(model.SearchText))
.Where(model.MenuIDs_TrinhDoDT > 0, o => o.MenuIDs_TrinhDoDT.Contains(model.MenuIDs_TrinhDoDT.ToString()))
.Where(model.MenuIDs_ChungChi > 0, o => o.MenuIDs_ChungChi.Contains(model.MenuIDs_ChungChi.ToString()))
.Where(donDk > 0, o => o.DonDangKyUCSCID == donDk)
.Where(hsThanhVien > 0, o => o.HSThanhVienUCSCID == hsThanhVien)
.OrderBy(orderBy);
var listEntity = dbQuery.ToList();
if (listEntity == null)
{
CPViewPage.SetMessage("Không có dữ liệu.");
return;
}
//khai báo tập hợp bản ghi excel
List <List <object> > list = new List <List <object> >();
//khai báo 1 dòng excel
List <object> _list = null;
for (int i = 0; listEntity != null && listEntity.Count > 0 && i < listEntity.Count; i++)
{
_list = new List <object>();
var lstTd = listEntity[i].getMenuTrinhDo().Select(o => o.Name).ToArray();
var lstCc = listEntity[i].getMenuChungChi().Select(o => o.Name).ToArray();
string td = "", cc = "";
if (lstTd.Length > 0)
{
td = string.Join(",", lstTd);
}
if (lstCc.Length > 0)
{
cc = string.Join(",", lstCc);
}
var donDangky = ModDonDangKyUCSCService.Instance.CreateQuery()
.Where(o => o.ID == listEntity[i].DonDangKyUCSCID && o.Activity == true)
.ToSingle();
var hSThanhVien = ModHSThanhVienUCSCService.Instance.CreateQuery()
.Where(o => o.ID == listEntity[i].HSThanhVienUCSCID && o.Activity == true)
.ToSingle();
int tvId = donDangky != null ? donDangky.UserID : hSThanhVien.UserID;
var user = CPUserService.Instance.GetByID(tvId);
string loginName = "";
if (user != null)
{
loginName = user.LoginName;
}
_list.Add(loginName);
_list.Add(td);
_list.Add(cc);
_list.Add(listEntity[i].Name);
_list.Add(listEntity[i].School);
_list.Add(listEntity[i].NamTotNghiep);
list.Add(_list);
}
//ghi exel
string temp_file = CPViewPage.Server.MapPath("~/Data/upload/files/Excel/NhanLuc_" +
string.Format("{0:yyyy_MM_dd}", DateTime.Now) + ".xlsx");
string filePath = CPViewPage.Server.MapPath("~/TTPortal/Templates/Export_NhanLuc.xlsx");
Excel.Export(list, 1, filePath, temp_file);
//CPViewPage.Response.Write("Here!6");
CPViewPage.Response.Clear();
CPViewPage.Response.ContentType = "application/excel";
CPViewPage.Response.AppendHeader("Content-Disposition", "attachment; filename=" + System.IO.Path.GetFileName(temp_file));
CPViewPage.Response.WriteFile(temp_file);
CPViewPage.Response.End();
//CPViewPage.Response.Write("Here!");
}
public void ActionChangeLang(string langCode)
{
Cookies.SetValue("CP.Lang", langCode, true);
CPViewPage.RefreshPage();
}
