public string Insert_phongban(PhongBanModels clParam)
{
logger.Start("InsertRow");
string strResult = "";
try
{
if (clParam.maphongban.ToString().Trim() == "")
{
strResult = GetSequence_All("dm_seq", "m_donvi_phongban");
//string[] chuoi = clParam.tenphongban.ToString().Trim().Split(' ');
//for (int i = 0; i < chuoi.Length; i++)
//{
// maphongban += chuoi[i].Substring(0, 1);
//}
clParam.maphongban = int.Parse(strResult).ToString();
base.InsertData(clParam, strTableName);
}
else
{
Hashtable param = new Hashtable();
param = base.SetDataToHashtable(false, clParam);
sqlMap.Update("Danhmuc.UpdateRow_phongban", param);
}
strResult = clParam.maphongban;
}
catch (Exception ex)
{
strResult = "-1";
logger.Error(ex.Message);
}
logger.End("InsertRow");
return strResult;
}
public string InsertRow(PhongBanModels clParam)
{
logger.Start("InsertRow");
string strResult = "";
try
{
sqlMap.BeginTransaction();
Hashtable param = new Hashtable();
param = base.SetDataToHashtable(false, clParam);
//param["seqname"] = "seq_vb_capdouutien";
//string strid = sqlMap.ExecuteQueryForObject("Common.GetNextVal", param).ToString();
//param["macapdouutien"] = strid;
sqlMap.Insert("m_donvi_phongban.Insert", param);
sqlMap.CommitTransaction();
//strResult = param["macapdouutien"].ToString();
}
catch (Exception ex)
{
sqlMap.RollbackTransaction();
strResult = "-1";
logger.Error(ex.Message);
}
logger.End("InsertRow");
return(strResult);
}
//Hiệu chỉnh đơn đăng ký
public ActionResult Editforleave(string madangky)
{
//check login
if (!IsLogged())
{
return(BackToLogin());
}
DanhmucServices service = new DanhmucServices();
PhongBanModels parampb = new PhongBanModels();
List <PhongBanModels> lstResult_phongban = service.SelectRows(parampb);
StringBuilder sbphongban = new StringBuilder();
foreach (var item in lstResult_phongban)
{
sbphongban.Append(string.Format("<option value='{0}'>{1}</option>", item.maphongban, item.tenphongban));
}
ViewBag.sbphongban = sbphongban.ToString();
if (madangky != "0" && madangky != null)
{
FunctionXML function = new FunctionXML(Functions.MapPath("~/Xml/Config/encryptionkeyEncodeLink.config"));
madangky = AES.DecryptText(madangky, function.ReadXMLGetKeyEncrypt());
MaDangKyNP = madangky;
AbsentModels param = new AbsentModels();
param.manghiphep = madangky.Trim();
AbsentServices service_dangky = new AbsentServices();
List <AbsentModels> lstResult_dangky = service_dangky.SelectRows_Danhsachnghiphep_11111(param);
if (lstResult_dangky.Count > 0)
{
if (lstResult_dangky[0].duyetcap1 == "1")
{
}
string[] chuoi = lstResult_dangky[0].ngaysinh.Split('/');
if (chuoi.Length == 3)
{
lstResult_dangky[0].ngaysinh = chuoi[0];
lstResult_dangky[0].thangsinh = chuoi[1];
lstResult_dangky[0].namsinh = chuoi[2];
}
else if (chuoi.Length == 2)
{
lstResult_dangky[0].thangsinh = chuoi[0];
lstResult_dangky[0].namsinh = chuoi[1];
}
else
{
lstResult_dangky[0].namsinh = chuoi[0];
}
if (lstResult_dangky.Count > 0)
{
return(View(lstResult_dangky[0]));
}
}
}
return(View());
}
public ActionResult Createtrainning(string idmalophc)
{
if (!IsLogged())
{
return(BackToLogin());
}
daotao_taolopModels param = new daotao_taolopModels();
List <daotao_taolopModels> lstResult_lop = new List <daotao_taolopModels>();
SaudaotaoServices service_lop = new SaudaotaoServices();
param.email = Session["thudientu"].ToString();
lstResult_lop = service_lop.SelectRows_Laydslophoctheo_nhanvien(param);
if (idmalophc == null)
{
StringBuilder sblophoc = new StringBuilder();
sblophoc.Append(string.Format("<option value='{0}'>{1}</option>", "0", "Chọn tên lớp học"));
foreach (var item in lstResult_lop)
{
sblophoc.Append(string.Format("<option value='{0}'>{1}</option>", item.malop, item.tenlop));
}
ViewBag.sblophoc = sblophoc.ToString();
}
else
{
StringBuilder sblophoc = new StringBuilder();
foreach (var item in lstResult_lop.Where(p => p.malop == int.Parse(idmalophc.Trim())))
{
sblophoc.Append(string.Format("<option value='{0}'>{1}</option>", item.malop, item.tenlop));
}
ViewBag.sblophoc = sblophoc.ToString();
}
//phong ban
PhongBanModels parampb = new PhongBanModels();
DanhmucServices service = new DanhmucServices();
List <PhongBanModels> lstResult_phongban = service.SelectRows(parampb);
StringBuilder sbphongban = new StringBuilder();
foreach (var item in lstResult_phongban)
{
sbphongban.Append(string.Format("<option value={0}>{1}</option>", item.maphongban, item.tenphongban));
}
ViewBag.sbphongban = sbphongban.ToString();
return(View());
}
public ActionResult Index()
{
//check login
if (!IsLogged())
{
return(BackToLogin());
}
DanhmucServices service = new DanhmucServices();
PhongBanModels parampb = new PhongBanModels();
List <PhongBanModels> lstResult_phongban = service.SelectRows2(parampb);
StringBuilder sbphongban = new StringBuilder();
string pb = "";
string thudientu = Session["thudientu"].ToString().Trim();
if (Session["loginid"].ToString().Trim().ToLower() == "admin" || Session["grouptk"].ToString().Trim() == "1")
{
//var lstpban = lstResult_phongban.Where(p => p.maphongban == maphongban).ToList();
//if (lstpban.Count() > 0)
// pb = "<option value=" + lstpban[0].maphongban + ">" + lstpban[0].tenphongban + "</option>";
//pb = pb + "<option value=0>Chọn phòng ban</option>";
foreach (var item in lstResult_phongban)
{
pb = pb + "<option value=" + item.maphongban + "> " + item.tenphongban + " </option>";
}
}
else
{
foreach (var item in lstResult_phongban.Where(p => p.email == thudientu || p.sodienthoai == thudientu || p.ghichu == thudientu ||
p.ghichu1 == thudientu || p.ghichu2 == thudientu ||
p.cv_thietbi == thudientu || p.gs_thietbi == thudientu ||
p.cv_hsse == thudientu || p.gs_hsse == thudientu ||
p.cv_qaqc == thudientu || p.gs_qaqc == thudientu ||
p.cv_mep == thudientu || p.gs_mep == thudientu))
{
pb = pb + "<option value=" + item.maphongban + "> " + item.tenphongban + " </option>";
}
}
ViewBag.sbphongban = pb.ToString();
//foreach (var item in lstResult_phongban.Where(p=>p.phongban_congtruong=="0"))
//{
// sbphongban.Append(string.Format("<option value='{0}'>{1}</option>", item.maphongban, item.tenphongban));
//}
// ViewBag.sbphongban = sbphongban.ToString();
return(View());
}
public ActionResult Vacationlist()
{
if (!IsLogged())
{
return(BackToLogin());
}
DanhmucServices service = new DanhmucServices();
PhongBanModels parampb = new PhongBanModels();
List <PhongBanModels> lstResult_phongban = service.SelectRows(parampb);
StringBuilder sbphongban = new StringBuilder();
foreach (var item in lstResult_phongban)
{
sbphongban.Append(string.Format("<option value='{0}'>{1}</option>", item.maphongban, item.tenphongban));
}
ViewBag.sbphongban = sbphongban.ToString();
return(View());
}
public ActionResult Index_EmployeeYear()
{
if (!IsLogged())
{
return(BackToLogin());
}
DanhmucServices service = new DanhmucServices();
PhongBanModels parampb = new PhongBanModels();
lstResult_phongban = new List <PhongBanModels>();
lstResult_phongban = service.SelectRows(parampb);
StringBuilder sbphongban = new StringBuilder();
string maphongban = Session["maphongban"].ToString().Trim();
string machucdanhkpi = Session["chucdanhkpi"].ToString().Trim();
string pb = "";
if (Session["loginid"].ToString().Trim().ToLower() == "admin" || Session["grouptk"].ToString().Trim() == "1")
{
var lstpban = lstResult_phongban.Where(p => p.maphongban == maphongban).ToList();
if (lstpban.Count() > 0)
{
pb = "<option value=" + 0 + ">" + "Lựa chọn phòng ban" + "</option>";
pb = pb + "<option value=" + lstpban[0].maphongban + ">" + lstpban[0].tenphongban + "</option>";
}
foreach (var item in lstResult_phongban.Where(p => p.maphongban != maphongban))
{
pb = pb + "<option value=" + item.maphongban + "> " + item.tenphongban + " </option>";
}
}
else
{
foreach (var item in lstResult_phongban.Where(p => p.maphongban == maphongban))
{
pb = pb + "<option value=" + item.maphongban + "> " + item.tenphongban + " </option>";
}
}
ViewBag.sbphongban = pb.ToString();
var lstphongban = lstResult_phongban.Where(p => p.maphongban == maphongban).ToList();
lstphongban[0].xoa = machucdanhkpi;
lstphongban[0].sodienthoai = DateTime.Now.ToString("MM/yyyy");
return(View(lstphongban[0]));
}
public List<PhongBanModels> SelectRowsGDDA(PhongBanModels clParam)
{
logger.Start("SelectRowsGDDA");
List<PhongBanModels> lstResult = new List<PhongBanModels>();
try
{
Hashtable param = new Hashtable();
param = base.SetDataToHashtable(false, clParam);
IList ilist = sqlMap.ExecuteQueryForList("Danhmuc.SelectRowsGDDA", param);
CastDataType cast = new CastDataType();
lstResult = cast.AdvanceCastDataToList<PhongBanModels>(ilist);
}
catch (Exception ex)
{
logger.Error("Loi ---> " + ex.Message);
}
logger.End("SelectRowsGDDA");
return lstResult;
}
public int CountRows(PhongBanModels clparam)
{
logger.Start("CountRows");
int iResult = 0;
try
{
Hashtable param = new Hashtable();
param = base.SetDataToHashtable(false, clparam);
iResult = (int)sqlMap.ExecuteQueryForObject("Danhmuc.CountRows", param);
}
catch (Exception ex)
{
sqlMap.RollbackTransaction();
iResult = 0;
logger.Error(ex.Message);
}
logger.End("CountRows");
return iResult;
}
public JsonResult SelectRows2(PhongBanModels model)
{
PhongBanModels param = new PhongBanModels();
DanhmucServices service = new DanhmucServices();
List <PhongBanModels> lstResult = service.SelectRows2(param);
StringBuilder sbResult = new StringBuilder();
StringBuilder sbRows = new StringBuilder();
if (lstResult.Count > 0)
{
string strSTT = "";
int i = 1;
foreach (var item in lstResult)
{
strSTT = i.ToString();
if (item.madonvi == "1")
{
item.tendonvi = "Công ty cổ phẩn Ricons";
}
sbRows.Append(PrepareDataJson(item, strSTT));
i++;
}
if (sbRows.Length > 0)
{
sbRows.Remove(sbRows.Length - 1, 1);
}
}
sbResult.Append("{");
sbResult.Append("\"isHeader\":\"" + "111" + "\",");
sbResult.Append("\"currentRow\":\"" + lstResult.Count + "\",");
sbResult.Append("\"Pages\":\"" + lstResult.Count + "\",");
if (model.maphongban != "0")
{
sbResult.Append("\"SubRow\":\"" + "true" + "\",");
sbResult.Append("\"RowID\":\"" + model.maphongban + "\",");
}
sbResult.Append("\"data\":[" + sbRows.ToString() + "]");
sbResult.Append("}");
return(Json(sbResult.ToString(), JsonRequestBehavior.AllowGet));
}
public PhongBanModels RowDetail(PhongBanModels clparam)
{
logger.Start("RowDetail");
PhongBanModels vbResult = new PhongBanModels();
try
{
Hashtable param = new Hashtable();
param = base.SetDataToHashtable(false, clparam);
IList ilist = sqlMap.ExecuteQueryForList("m_donvi_phongban.RowDetail", param);
CastDataType cast = new CastDataType();
vbResult = cast.AdvanceCastDataToList <PhongBanModels>(ilist)[0];
}
catch (Exception ex)
{
logger.Error(ex.Message);
vbResult = new PhongBanModels();
}
logger.End("RowDetail");
return(vbResult);
}
public bool UpdateRow(PhongBanModels clParam)
{
logger.Start("UpdateRow");
bool bResult = false;
try
{
sqlMap.BeginTransaction();
Hashtable param = new Hashtable();
param = base.SetDataToHashtable(false, clParam);
sqlMap.Update("m_donvi_phongban.UpdateRow", param);
sqlMap.CommitTransaction();
bResult = true;
}
catch (Exception ex)
{
sqlMap.RollbackTransaction();
bResult = false;
logger.Error(ex.Message);
}
logger.End("UpdateRow");
return(bResult);
}
public ActionResult Edit(string macuochop)
{
if (!IsLogged())
{
return(BackToLogin());
}
Item_weedModels param = new Item_weedModels();
DanhmucServices service = new DanhmucServices();
List <Item_weedModels> lstResult_Tuan = service.SelectRows_giaovien(param);
StringBuilder sbtuan = new StringBuilder();
foreach (var item in lstResult_Tuan)
{
item.tentuan = item.tentuan + " " + item.tungay + " - " + item.denngay;
sbtuan.Append(string.Format("<option value='{0}'>{1}</option>", item.matuan, item.tentuan));
}
ViewBag.sbtuan = sbtuan.ToString();
//phong ban
PhongBanModels parampb = new PhongBanModels();
List <PhongBanModels> lstResult_phongban = service.SelectRows2(parampb);
StringBuilder sbphongban = new StringBuilder();
string pb = "";
string maphongban = Session["maphongban"].ToString().Trim();
if (Session["loginid"].ToString().Trim().ToLower() == "admin" || Session["grouptk"].ToString().Trim() == "1")
{
pb = pb + "<option value=0>Chọn phòng ban</option>";
foreach (var item in lstResult_phongban)
{
pb = pb + "<option value=" + item.maphongban + "> " + item.tenphongban + " </option>";
}
}
else
{
foreach (var item in lstResult_phongban.Where(p => p.maphongban == maphongban))
{
pb = pb + "<option value=" + item.maphongban + "> " + item.tenphongban + " </option>";
}
}
ViewBag.sbphongban = pb.ToString();
StringBuilder sbphonghop = new StringBuilder();
sbphonghop.Append(string.Format("<option value={0}>{1}</option>", "0", "Lựa chọn Phòng họp"));
sbphonghop.Append(string.Format("<option value={0}>{1}</option>", "1", "Tầng 3 - Phòng họp 1"));
sbphonghop.Append(string.Format("<option value={0}>{1}</option>", "2", "Tầng 3 - Phòng họp 2"));
sbphonghop.Append(string.Format("<option value={0}>{1}</option>", "3", "Tầng 3 - Phòng họp lớn"));
sbphonghop.Append(string.Format("<option value={0}>{1}</option>", "4", "Tầng 3A - Phòng họp nhỏ"));
sbphonghop.Append(string.Format("<option value={0}>{1}</option>", "5", "Tầng 3A - Phòng họp lớn"));
sbphonghop.Append(string.Format("<option value={0}>{1}</option>", "6", "Khác"));
ViewBag.sbphonghop = sbphonghop.ToString();
FunctionXML function = new FunctionXML(Functions.MapPath("~/Xml/Config/encryptionkeyEncodeLink.config"));
macuochop = AES.DecryptText(macuochop, function.ReadXMLGetKeyEncrypt());
DaotaoServices servicevpp = new DaotaoServices();
List <WeedMeetingModels> lstResult = new List <WeedMeetingModels>();
lstResult = servicevpp.SelectRows_WeedMeeting_hieuchinh(macuochop);
if (lstResult.Count > 0)
{
//replace(/'/g, "daunhaydon").replace(/"/g, '').replace(/&/g, 'daukytuva') + "',";
lstResult[0].lydobuoihop = lstResult[0].lydobuoihop.Replace("daunhaydon", "'").Replace("daukytuva", "&");
lstResult[0].thanhphanthamdu = lstResult[0].thanhphanthamdu.Replace("daunhaydon", "'").Replace("daukytuva", "&");
//System.Text.RegularExpressions.Regex.Replace(json["noidungcuochop"].ToString().Trim(), @"\n", "\\n").Replace("'", "");
string chuoinoidungs = "";
string chuoinoidung = System.Text.RegularExpressions.Regex.Replace(lstResult[0].noidungcuochop, @"\\n", "\n");
string[] noisungcuochop = chuoinoidung.Split(new char[] { '\n' });
for (int i = 0; i < noisungcuochop.Length; i++)
{
chuoinoidungs = chuoinoidungs + noisungcuochop[i].Replace("daunhaydon", "'").Replace("daukytuva", "&") + Environment.NewLine;
}
lstResult[0].noidungcuochop = chuoinoidungs;
return(View(lstResult[0]));
}
return(View());
}
public ActionResult Editforleave(string madangky, AbsentModels model, string luu)
{
if (!IsLogged())
{
return(BackToLogin());
}
if (model.nghiphep == "on")
{
model.nghiphep = "1";
}
else
{
model.nghikhac = "0";
}
if (model.nghikhongluong == "on")
{
model.nghikhongluong = "1";
}
else
{
model.nghikhac = "0";
}
if (model.nghithaisan == "on")
{
model.nghithaisan = "1";
}
else
{
model.nghikhac = "0";
}
if (model.conkh == "on")
{
model.conkh = "1";
}
else
{
model.conkh = "0";
}
if (model.canhankh == "on")
{
model.canhankh = "1";
}
else
{
model.canhankh = "0";
}
if (model.chame_mat == "on")
{
model.chame_mat = "1";
}
else
{
model.chame_mat = "0";
}
if (model.ongba_mat == "on")
{
model.ongba_mat = "1";
}
else
{
model.ongba_mat = "0";
}
if (model.thangsinh.ToString() != "")
{
model.ngaysinh = model.ngaysinh + "/" + model.thangsinh.ToString();
}
if (model.namsinh.ToString() != "")
{
model.ngaysinh = model.ngaysinh + "/" + model.namsinh.ToString();
}
model.xoa = "0";
model.nguoitao = int.Parse(Session["userid"].ToString());
model.ngaytao = "GETDATE()";
model.manghiphep = MaDangKyNP;
AbsentServices service = new AbsentServices();
model.manghiphep = service.Insert_Donxinnghiphep(model);
DanhmucServices service_pb = new DanhmucServices();
PhongBanModels parampb = new PhongBanModels();
parampb.maphongban = model.maphongban.ToString().Trim();
List <PhongBanModels> lstResult_phongban = service_pb.SelectRows(parampb);
if (lstResult_phongban.Count > 0)
{
string hotento = "";
if (lstResult_phongban[0].hovaten.ToString() != "")
{
hotento = System.Threading.Thread.CurrentThread.CurrentCulture.TextInfo.ToTitleCase(lstResult_phongban[0].hovaten.ToString().Trim().ToLower());
}
if (lstResult_phongban[0].email.ToString().Trim() != "")
{
#region
string mailto = lstResult_phongban[0].email.ToString().Trim();
model.tenphongban = lstResult_phongban[0].tenphongban.ToString().Trim();
string strEncryptCode = MaDangKyNP + "0070pXQSeNsQRuzoCmUYfuX/vA==6";
string mailcapquanly = "";
if (model.machucdanh == "1" && double.Parse(model.songayxinnghi) > 2)
{
if (lstResult_phongban[0].thuocquanly.ToString().Trim() == "1")
{
mailcapquanly = string.Format(Functiontring.ReturnStringFormatEmail("1"));
}
else if (lstResult_phongban[0].thuocquanly.ToString().Trim() == "2")
{
mailcapquanly = string.Format(Functiontring.ReturnStringFormatEmail("2"));
}
else if (lstResult_phongban[0].thuocquanly.ToString().Trim() == "3")
{
mailcapquanly = string.Format(Functiontring.ReturnStringFormatEmail("3"));
}
else if (lstResult_phongban[0].thuocquanly.ToString().Trim() == "4")
{
mailcapquanly = string.Format(Functiontring.ReturnStringFormatEmail("4"));
}
else if (lstResult_phongban[0].thuocquanly.ToString().Trim() == "5")
{
mailcapquanly = string.Format(Functiontring.ReturnStringFormatEmail("5"));
}
else if (lstResult_phongban[0].thuocquanly.ToString().Trim() == "6")
{
mailcapquanly = string.Format(Functiontring.ReturnStringFormatEmail("6"));
}
else if (lstResult_phongban[0].thuocquanly.ToString().Trim() == "7")
{
mailcapquanly = string.Format(Functiontring.ReturnStringFormatEmail("7"));
}
string[] chuoitach = mailcapquanly.Split('/');
strEncryptCode = strEncryptCode + "&emailto=" + chuoitach[0] + "&hotento=" + chuoitach[1];
}
else if (model.machucdanh == "2")
{
if (lstResult_phongban[0].thuocquanly.ToString().Trim() == "1")
{
mailto = string.Format(Functiontring.ReturnStringFormatEmail("1"));
}
else if (lstResult_phongban[0].thuocquanly.ToString().Trim() == "2")
{
mailto = string.Format(Functiontring.ReturnStringFormatEmail("2"));
}
else if (lstResult_phongban[0].thuocquanly.ToString().Trim() == "3")
{
mailto = string.Format(Functiontring.ReturnStringFormatEmail("3"));
}
else if (lstResult_phongban[0].thuocquanly.ToString().Trim() == "4")
{
mailto = string.Format(Functiontring.ReturnStringFormatEmail("4"));
}
else if (lstResult_phongban[0].thuocquanly.ToString().Trim() == "5")
{
mailto = string.Format(Functiontring.ReturnStringFormatEmail("5"));
}
else if (lstResult_phongban[0].thuocquanly.ToString().Trim() == "6")
{
mailto = string.Format(Functiontring.ReturnStringFormatEmail("6"));
}
else if (lstResult_phongban[0].thuocquanly.ToString().Trim() == "7")
{
mailto = string.Format(Functiontring.ReturnStringFormatEmail("7"));
}
string[] chuoicap1 = mailto.Split('/');
mailto = chuoicap1[0].Trim();
hotento = chuoicap1[1].Trim();
mailcapquanly = string.Format(Functiontring.ReturnStringFormatEmail("1")); /// Goi cho tong giam doc
string[] chuoitach = mailcapquanly.Split('/');
strEncryptCode = strEncryptCode + "&emailto=" + chuoitach[0] + "&hotento=" + chuoitach[1];
}
#endregion
send_Mail(strEncryptCode, mailto, "Đơn xin nghỉ phép", "Nội dung", model, hotento);
}
return(RedirectToAction("Vacationlist", "Absent"));
}
else
{
return(RedirectToAction("Editforleave"));
}
//return View();
}
public void MailLich(string NoiDung, string path, string filename, string maphongban, int phongban_congtruong, string matuan)
{
string sMailGui = System.Configuration.ConfigurationManager.AppSettings["MailSend"];
string sPass = System.Configuration.ConfigurationManager.AppSettings["MailPass"];
string sHost = System.Configuration.ConfigurationManager.AppSettings["MailHost"];
string sPort = System.Configuration.ConfigurationManager.AppSettings["MailPort"];
string sTieuDe = System.Configuration.ConfigurationManager.AppSettings["ScheduleSubject"];
string sMailTo = System.Configuration.ConfigurationManager.AppSettings["schedulerman"];
// gui mail
var fromAddress = new MailAddress(sMailGui);
string fromPassword = sPass;
string subject = sTieuDe;
string body = NoiDung;
DanhmucServices service = new DanhmucServices();
PhongBanModels parampb = new PhongBanModels();
Item_weedModels Week = new Item_weedModels();
List <PhongBanModels> lstResult_phongban;
List <Item_weedModels> lstResult_Item_weedModels;
List <PhongBanModels> y = null;
List <Item_weedModels> z = null;
var lstcaptrentt = y;
var lstweekitemtt = z;
lstResult_Item_weedModels = service.SelectRows_giaovien(Week);
lstweekitemtt = lstResult_Item_weedModels.Where(x => x.matuan == matuan).ToList();
if (phongban_congtruong == 0)
{
lstResult_phongban = service.SelectRows(parampb);
lstcaptrentt = lstResult_phongban.Where(p => p.maphongban == maphongban).ToList();
if (lstcaptrentt[0].email.ToString().Trim() == null)
{
sMailTo = "*****@*****.**";
}
else
{
sMailTo = lstcaptrentt[0].email;
}
}
else
{
lstResult_phongban = service.SelectRows2(parampb);
lstcaptrentt = lstResult_phongban.Where(p => p.maphongban == maphongban).ToList();
if (lstcaptrentt[0].email.ToString().Trim() == null)
{
sMailTo = "*****@*****.**";
}
else
{
sMailTo = lstcaptrentt[0].email;
}
}
var toAddress = new MailAddress(sMailTo);
var smtp = new SmtpClient
{
Host = sHost,
Port = int.Parse(sPort),
EnableSsl = false,
DeliveryMethod = SmtpDeliveryMethod.Network,
UseDefaultCredentials = false,
Credentials = new NetworkCredential(fromAddress.Address, fromPassword)
};
//var smtp = new SmtpClient();
subject = "NEWTECONS WEEKLY REPORT: " + lstcaptrentt[0].tenphongban;
body = "<p>Kính gửi Ban Tổng Giám Đốc Công ty Newtecons,</p><p>" + lstcaptrentt[0].tenphongban + " xin phép gửi báo cáo tuần: " + lstweekitemtt[0].tentuan + ". Vui lòng xem file đính kèm.</p>" + "<p>Trân trọng,</p>";
using (var message = new MailMessage(fromAddress, toAddress)
{
IsBodyHtml = true,
Subject = subject,
Body = body
})
{
try
{
Attachment data = new Attachment(path, MediaTypeNames.Application.Octet);
message.Attachments.Add(data);
if (!string.IsNullOrEmpty(lstcaptrentt[0].sodienthoai))
{
message.CC.Add(lstcaptrentt[0].sodienthoai);
}
if (!string.IsNullOrEmpty(lstcaptrentt[0].ghichu))
{
message.CC.Add(lstcaptrentt[0].ghichu);
}
if (!string.IsNullOrEmpty(lstcaptrentt[0].ghichu1))
{
message.CC.Add(lstcaptrentt[0].ghichu1);
}
if (!string.IsNullOrEmpty(lstcaptrentt[0].ghichu2))
{
message.CC.Add(lstcaptrentt[0].ghichu2);
}
smtp.Send(message);
smtp.Dispose();
}
catch (SmtpFailedRecipientsException ex)
{
for (int i = 0; i < ex.InnerExceptions.Length; i++)
{
SmtpStatusCode status = ex.InnerExceptions[i].StatusCode;
if (status == SmtpStatusCode.MailboxBusy || status == SmtpStatusCode.MailboxUnavailable)
{
// Console.WriteLine("Delivery failed - retrying in 5 seconds.");
System.Threading.Thread.Sleep(5000);
smtp.Send(message);
}
else
{
// Console.WriteLine("Failed to deliver message to {0}", ex.InnerExceptions[i].FailedRecipient);
throw ex;
}
}
}
catch (Exception ex)
{
// Console.WriteLine("Exception caught in RetryIfBusy(): {0}",ex.ToString());
throw ex;
}
finally
{
smtp.Dispose();
}
}
}
public JsonResult SelectRows_WeedMeeting(WeedMeetingModels model, int curentPage)
{
WeedMeetingModels param = new WeedMeetingModels();
DaotaoServices service = new DaotaoServices();
DanhmucServices service_danhmuc = new DanhmucServices();
//param.nguoitao = int.Parse(Session["userid"].ToString());
param.maphongban = model.maphongban;
param.loaibaocao = model.loaibaocao;
//if (Session["loginid"].ToString().Trim().ToLower() == "admin" || Session["grouptk"].ToString().Trim() == "1")
//{
param.nguoitao = 0;
//}
string thudientu = Session["thudientu"].ToString().Trim();
List <PhongBanModels> y = null;
var lstcaptrentt = y;
PhongBanModels parampb = new PhongBanModels();
List <PhongBanModels> lstResult_phongban = service_danhmuc.SelectRows2(parampb);
lstcaptrentt = lstResult_phongban.Where(p => p.maphongban == model.maphongban).ToList();
//StringBuilder sbloaibaocao = new StringBuilder();
//sbloaibaocao.Append(string.Format("<option value={0}>{1}</option>", "1", "Báo cáo tuần CHT/TPB"));
if (lstcaptrentt[0].email == thudientu || lstcaptrentt[0].ghichu == thudientu || lstcaptrentt[0].sodienthoai == thudientu ||
lstcaptrentt[0].ghichu1 == thudientu || lstcaptrentt[0].ghichu2 == thudientu || Session["loginid"].ToString().Trim().ToLower() == "admin" || Session["grouptk"].ToString().Trim() == "1")
{
param.loaibaocao = param.loaibaocao;
}
else if (model.loaibaocao == 2 && (lstcaptrentt[0].cv_thietbi == thudientu || lstcaptrentt[0].gs_thietbi == thudientu))
{
param.loaibaocao = 2;
}
else if (model.loaibaocao == 3 && (lstcaptrentt[0].cv_hsse == thudientu || lstcaptrentt[0].gs_hsse == thudientu))
{
param.loaibaocao = 3;
}
else if (model.loaibaocao == 4 && (lstcaptrentt[0].cv_qaqc == thudientu || lstcaptrentt[0].gs_qaqc == thudientu))
{
param.loaibaocao = 4;
}
else if (model.loaibaocao == 5 && (lstcaptrentt[0].cv_mep == thudientu || lstcaptrentt[0].gs_mep == thudientu))
{
param.loaibaocao = 5;
}
else
{
param.loaibaocao = 6;
}
int tongsodong = service.CountRows_WeedMeeting2(param);
int sotrang = 1;
if (tongsodong > 20)
{
if (tongsodong % 20 > 0)
{
sotrang = (tongsodong / 20) + 1;
}
else
{
sotrang = (tongsodong / 20);
}
}
int trangbd = 1; int trangkt = 20;
if (curentPage != 1 && curentPage <= sotrang)
{
trangbd = (trangkt * (curentPage - 1)) + 1;
trangkt = trangkt * curentPage;
}
List <WeedMeetingModels> lstResult = new List <WeedMeetingModels>();
if (curentPage <= sotrang)
{
lstResult = service.SelectRows_WeedMeeting2(param, trangbd, trangkt);
}
else if (curentPage != 1 && curentPage > sotrang)
{
curentPage = curentPage - 1;
}
StringBuilder sbResult = new StringBuilder();
StringBuilder sbRows = new StringBuilder();
int tongdong = 0;
if (lstResult.Count > 0)
{
string strSTT = "";
int i = trangbd;
foreach (var item in lstResult)
{
strSTT = i.ToString();
if (item.loaicuochop == "1")
{
item.tenloaicuochop = "Họp tuần phòng";
}
else if (item.loaicuochop == "2")
{
item.tenloaicuochop = "Họp tuần BGĐ";
}
else if (item.loaicuochop == "3")
{
item.tenloaicuochop = "Họp khác";
}
else
{
item.tenloaicuochop = "";
}
if (item.phonghop == "1")
{
item.tenphonghop = "Tầng 3 - Phòng họp 1";
}
else if (item.phonghop == "2")
{
item.tenphonghop = "Tầng 3 - Phòng họp 2";
}
else if (item.phonghop == "3")
{
item.tenphonghop = "Tầng 3 - Phòng họp lớn";
}
else if (item.phonghop == "4")
{
item.tenphonghop = "Tầng 3A - Phòng họp nhỏ";
}
else if (item.phonghop == "5")
{
item.tenphonghop = "Tầng 3A - Phòng họp lớn";
}
else if (item.phonghop == "6")
{
item.tenphonghop = "Khác";
}
else
{
item.tenphonghop = "";
}
sbRows.Append(PrepareDataJson_WeedMeeting(item, strSTT));
i++;
}
tongdong = i - 1;
if (sbRows.Length > 0)
{
sbRows.Remove(sbRows.Length - 1, 1);
}
}
if (tongsodong == 0)
{
sotrang = 0;
}
sbResult.Append("{");
sbResult.Append("\"isHeader\":\"" + "111" + "\",");
sbResult.Append("\"tongdong\":\"" + "" + tongsodong + "" + "\",");
sbResult.Append("\"Pages\":\"" + "" + sotrang + "" + "\",");
sbResult.Append("\"SubRow\":\"" + "false" + "\",");
sbResult.Append("\"data\":[" + sbRows.ToString() + "]");
sbResult.Append("}");
return(Json(sbResult.ToString(), JsonRequestBehavior.AllowGet));
}
//Thêm mới đơn đăng ký
public ActionResult Registerforleave()
{
//check login
if (!IsLogged())
{
return(BackToLogin());
}
DanhmucServices service = new DanhmucServices();
PhongBanModels parampb = new PhongBanModels();
List <PhongBanModels> lstResult_phongban = service.SelectRows(parampb);
StringBuilder sbphongban = new StringBuilder();
foreach (var item in lstResult_phongban)
{
sbphongban.Append(string.Format("<option value='{0}'>{1}</option>", item.maphongban, item.tenphongban));
}
ViewBag.sbphongban = sbphongban.ToString();
AbsentServices service_nghiphep = new AbsentServices();
AbsentModels param = new AbsentModels();
int loginid = 0;
if (Session["userid"].ToString().Trim() != "1")
{
loginid = int.Parse(Session["userid"].ToString());
}
param.nguoitao = loginid;
List <AbsentModels> lstResult_songaynghi = service_nghiphep.SelectRows_Danhsachnghiphep_songayphep(param);
double songayphep = double.Parse(DateTime.Now.Month.ToString("00"));
foreach (var item in lstResult_songaynghi)
{
double songayxinnghi = double.Parse(item.songayxinnghi);
if (songayphep >= 0)
{
if (item.canhankh.Trim() == "1" && songayxinnghi >= 3)
{
songayphep = songayphep + 3 - songayxinnghi;
}
else if (item.conkh.Trim() == "1" && songayxinnghi >= 1)
{
songayphep = songayphep + 1 - songayxinnghi;
}
else if (item.chame_mat.Trim() == "1" && songayxinnghi >= 3)
{
songayphep = songayphep + 3 - songayxinnghi;
}
else if (item.ongba_mat.Trim() == "1")
{
songayphep = songayphep - songayxinnghi;
}
else if (item.nghiphep.Trim() == "1" && songayphep >= 1)
{
songayphep = songayphep - songayxinnghi;
}
}
}
if (songayphep >= 1)
{
songayphep = songayphep - 1;
}
else
{
songayphep = 0;
}
List <AbsentModels> lstsongayphep = new List <AbsentModels>();
param = new AbsentModels();
param.songayphepconlai = songayphep.ToString();
lstsongayphep.Insert(0, param);
return(View(lstsongayphep[0]));
}
public ActionResult Updatephongban(string act, string ID, PhongBanModels model)
{
if (!IsLogged())
{
return(BackToLogin());
}
if (act == "create")
{
PhongBanModels paramphongban = new PhongBanModels();
paramphongban.maphongban = "";
paramphongban.madonvi = "1";
paramphongban.tenphongban = model.tenphongban;
paramphongban.sodienthoai = model.sodienthoai;
paramphongban.email = model.email;
paramphongban.hovaten = model.hovaten;
//var lstcaptrentt = lstthongtingiamdoc.Where(p => p.mathongtin == model.thuocquanly).ToList();
//if (lstcaptrentt.Count > 0)
//{
//paramphongban.thuocquanly = model.thuocquanly;
//paramphongban.hotenquanly = lstcaptrentt[0].hovaten;
paramphongban.ghichu = model.ghichu;
//}
//var lstcaptrentt1 = lstthongtingiamdoc.Where(p => p.mathongtin == model.thuocquanly1).ToList();
//if (lstcaptrentt1.Count > 0)
//{
//paramphongban.thuocquanly1 = model.thuocquanly1;
//paramphongban.hotenquanly1 = lstcaptrentt1[0].hovaten;
paramphongban.ghichu1 = model.ghichu1;
//}
//var lstcaptrentt2 = lstthongtingiamdoc.Where(p => p.mathongtin == model.thuocquanly2).ToList();
//if (lstcaptrentt2.Count > 0)
//{
//paramphongban.thuocquanly2 = model.thuocquanly2;
//paramphongban.hotenquanly2 = lstcaptrentt1[0].hovaten;
paramphongban.ghichu2 = model.ghichu2;
//}
paramphongban.cv_thietbi = model.cv_thietbi;
paramphongban.gs_thietbi = model.gs_thietbi;
paramphongban.cv_hsse = model.cv_hsse;
paramphongban.gs_hsse = model.gs_hsse;
paramphongban.cv_qaqc = model.cv_qaqc;
paramphongban.gs_qaqc = model.gs_qaqc;
paramphongban.cv_mep = model.cv_mep;
paramphongban.gs_mep = model.gs_mep;
paramphongban.xoa = "0";
paramphongban.nguoitao = int.Parse(Session["userid"].ToString());
paramphongban.ngaytao = ngaytao;
paramphongban.phongban_congtruong = "1";
DanhmucServices services = new DanhmucServices();
string result = services.Insert_phongban(paramphongban);
maphongban = result;
}
else if (act == "update")
{
PhongBanModels paramphongban = new PhongBanModels();
FunctionXML function = new FunctionXML(Functions.MapPath("~/Xml/Config/encryptionkeyEncodeLink.config"));
paramphongban.maphongban = AES.DecryptText(ID, function.ReadXMLGetKeyEncrypt());
paramphongban.madonvi = "1";
paramphongban.tenphongban = model.tenphongban;
paramphongban.sodienthoai = model.sodienthoai;
paramphongban.email = model.email;
paramphongban.hovaten = model.hovaten;
//var lstcaptrentt = lstthongtingiamdoc.Where(p => p.mathongtin == model.thuocquanly).ToList();
//if (lstcaptrentt.Count > 0)
//
//paramphongban.thuocquanly = model.thuocquanly;
//paramphongban.hotenquanly = lstcaptrentt[0].hovaten;
paramphongban.ghichu = model.ghichu;
//}
//var lstcaptrentt1 = lstthongtingiamdoc.Where(p => p.mathongtin == model.thuocquanly1).ToList();
//if (lstcaptrentt1.Count > 0)
//{
//paramphongban.thuocquanly1 = model.thuocquanly1;
//paramphongban.hotenquanly1 = lstcaptrentt1[0].hovaten;
paramphongban.ghichu1 = model.ghichu1;
//}
//var lstcaptrentt2 = lstthongtingiamdoc.Where(p => p.mathongtin == model.thuocquanly2).ToList();
//if (lstcaptrentt2.Count > 0)
//{
//paramphongban.thuocquanly2 = model.thuocquanly2;
//paramphongban.hotenquanly2 = lstcaptrentt1[0].hovaten;
paramphongban.ghichu2 = model.ghichu2;
//}
paramphongban.cv_thietbi = model.cv_thietbi;
paramphongban.gs_thietbi = model.gs_thietbi;
paramphongban.cv_hsse = model.cv_hsse;
paramphongban.gs_hsse = model.gs_hsse;
paramphongban.cv_qaqc = model.cv_qaqc;
paramphongban.gs_qaqc = model.gs_qaqc;
paramphongban.cv_mep = model.cv_mep;
paramphongban.gs_mep = model.gs_mep;
paramphongban.xoa = "0";
paramphongban.nguoitao = int.Parse(Session["userid"].ToString());
paramphongban.ngaytao = ngaytao;
DanhmucServices services = new DanhmucServices();
string result = services.Insert_phongban(paramphongban);
maphongban = result;
}
else if (act == "delete")
{
PhongBanModels paramphongban = new PhongBanModels();
FunctionXML function = new FunctionXML(Functions.MapPath("~/Xml/Config/encryptionkeyEncodeLink.config"));
paramphongban.maphongban = AES.DecryptText(ID, function.ReadXMLGetKeyEncrypt());
paramphongban.nguoihieuchinh = int.Parse(Session["userid"].ToString());
DanhmucServices services = new DanhmucServices();
string result = services.Deleted_phongban(paramphongban.maphongban.ToString(), paramphongban.nguoihieuchinh.ToString());
maphongban = result;
}
return(RedirectToAction("Index", "Danhmuc2"));
}
private StringBuilder PrepareDataJson(PhongBanModels model, string couter)
{
//duong dan file encryption key
FunctionXML function = new FunctionXML(Functions.MapPath("~/Xml/Config/encryptionkeyEncodeLink.config"));
StringBuilder sbResult = new StringBuilder();
string strEncryptCode = AES.EncryptText(model.maphongban, function.ReadXMLGetKeyEncrypt());
try
{
sbResult.Append("{");
sbResult.Append("\"col_class\":\"rows-box\",");
sbResult.Append("\"col_id\":\"" + strEncryptCode + "\",");
sbResult.Append("\"col_attr\":[{\"name\":\"" + "subparent" + "\", \"value\":\"" + AES.EncryptText(model.maphongban, function.ReadXMLGetKeyEncrypt()) + "\"}],");
sbResult.Append("\"col_value\":[");
#region Data cell
//colum checkbox
string strHTML_Checkbox = string.Format("<input type='checkbox' onclick='Select(this);' class='chkCheck' codeid='{0}' mpb='" + strEncryptCode + "'/>", model.maphongban);
sbResult.Append("{");
sbResult.Append("\"colspan\":\"1\",");
sbResult.Append("\"col_class\":\"ovh col1\",");
sbResult.Append("\"col_id\":\"1\",");
sbResult.Append("\"col_value\":\"" + strHTML_Checkbox + "\"");
sbResult.Append("},");
//stt
sbResult.Append("{");
sbResult.Append("\"colspan\":\"1\",");
sbResult.Append("\"col_class\":\"ovh col2 stt\",");
sbResult.Append("\"col_id\":\"2\",");
sbResult.Append("\"col_value\":\"" + couter + "\"");
sbResult.Append("},");
//Mã đơn vị
sbResult.Append("{");
sbResult.Append("\"colspan\":\"1\",");
sbResult.Append("\"col_class\":\"ovh col3\",");
sbResult.Append("\"col_id\":\"3\",");
sbResult.Append("\"col_value\":\"" + model.maphongban.Trim() + "\"");
sbResult.Append("},");
//Mã phòng ban
sbResult.Append("{");
sbResult.Append("\"colspan\":\"1\",");
sbResult.Append("\"col_class\":\"ovh col4\",");
sbResult.Append("\"col_id\":\"4\",");
sbResult.Append("\"col_value\":\"" + model.tenphongban.Trim() + "\"");
sbResult.Append("},");
//ho va ten
sbResult.Append("{");
sbResult.Append("\"colspan\":\"1\",");
sbResult.Append("\"col_class\":\"ovh col5\",");
sbResult.Append("\"col_id\":\"5\",");
sbResult.Append("\"col_value\":\"" + model.hovaten.Trim() + "\"");
sbResult.Append("},");
//Email
sbResult.Append("{");
sbResult.Append("\"colspan\":\"1\",");
sbResult.Append("\"col_class\":\"ovh col6\",");
sbResult.Append("\"col_id\":\"6\",");
sbResult.Append("\"col_value\":\"" + model.email + "\"");
sbResult.Append("},");
//so dien thoai luu thanh email cap quan ly
sbResult.Append("{");
sbResult.Append("\"colspan\":\"1\",");
sbResult.Append("\"col_class\":\"ovh col8\",");
sbResult.Append("\"col_id\":\"8\",");
sbResult.Append("\"col_value\":\"" + model.sodienthoai.Trim() + "\"");
sbResult.Append("},");
////thuoc quan ly
//sbResult.Append("{");
//sbResult.Append("\"colspan\":\"1\",");
//sbResult.Append("\"col_class\":\"ovh col7\",");
//sbResult.Append("\"col_id\":\"7\",");
//sbResult.Append("\"title\":\"" + model.thuocquanly.Trim() + "\",");
//sbResult.Append("\"col_value\":\"" + model.hotenquanly + "\"");
//sbResult.Append("},");
//Ghi chú
sbResult.Append("{");
sbResult.Append("\"colspan\":\"1\",");
sbResult.Append("\"col_class\":\"ovh col9\",");
sbResult.Append("\"col_id\":\"9\",");
sbResult.Append("\"col_value\":\"" + model.ghichu.Trim() + "\"");
sbResult.Append("},");
////thuoc quan ly1
//sbResult.Append("{");
//sbResult.Append("\"colspan\":\"1\",");
//sbResult.Append("\"col_class\":\"ovh col11\",");
//sbResult.Append("\"col_id\":\"11\",");
//sbResult.Append("\"title\":\"" + model.thuocquanly1.Trim() + "\",");
//sbResult.Append("\"col_value\":\"" + model.hotenquanly1 + "\"");
//sbResult.Append("},");
//Ghi chú1
sbResult.Append("{");
sbResult.Append("\"colspan\":\"1\",");
sbResult.Append("\"col_class\":\"ovh col12\",");
sbResult.Append("\"col_id\":\"12\",");
sbResult.Append("\"col_value\":\"" + model.ghichu1.Trim() + "\"");
sbResult.Append("},");
////thuoc quan ly2
//sbResult.Append("{");
//sbResult.Append("\"colspan\":\"1\",");
//sbResult.Append("\"col_class\":\"ovh col13\",");
//sbResult.Append("\"col_id\":\"13\",");
//sbResult.Append("\"title\":\"" + model.thuocquanly2.Trim() + "\",");
//sbResult.Append("\"col_value\":\"" + model.hotenquanly2 + "\"");
//sbResult.Append("},");
//Ghi chú2
sbResult.Append("{");
sbResult.Append("\"colspan\":\"1\",");
sbResult.Append("\"col_class\":\"ovh col14\",");
sbResult.Append("\"col_id\":\"14\",");
sbResult.Append("\"col_value\":\"" + model.ghichu2.Trim() + "\"");
sbResult.Append("},");
//CV_Thietbi
sbResult.Append("{");
sbResult.Append("\"colspan\":\"1\",");
sbResult.Append("\"col_class\":\"ovh col15\",");
sbResult.Append("\"col_id\":\"15\",");
sbResult.Append("\"col_value\":\"" + model.cv_thietbi.Trim() + "\"");
sbResult.Append("},");
//GS_Thietbi
sbResult.Append("{");
sbResult.Append("\"colspan\":\"1\",");
sbResult.Append("\"col_class\":\"ovh col16\",");
sbResult.Append("\"col_id\":\"16\",");
sbResult.Append("\"col_value\":\"" + model.gs_thietbi.Trim() + "\"");
sbResult.Append("},");
//CV_HSSE
sbResult.Append("{");
sbResult.Append("\"colspan\":\"1\",");
sbResult.Append("\"col_class\":\"ovh col17\",");
sbResult.Append("\"col_id\":\"17\",");
sbResult.Append("\"col_value\":\"" + model.cv_hsse.Trim() + "\"");
sbResult.Append("},");
//GS_HSSE
sbResult.Append("{");
sbResult.Append("\"colspan\":\"1\",");
sbResult.Append("\"col_class\":\"ovh col18\",");
sbResult.Append("\"col_id\":\"18\",");
sbResult.Append("\"col_value\":\"" + model.gs_hsse.Trim() + "\"");
sbResult.Append("},");
//CV_QAQC
sbResult.Append("{");
sbResult.Append("\"colspan\":\"1\",");
sbResult.Append("\"col_class\":\"ovh col19\",");
sbResult.Append("\"col_id\":\"19\",");
sbResult.Append("\"col_value\":\"" + model.cv_qaqc.Trim() + "\"");
sbResult.Append("},");
//GS_QAQC
sbResult.Append("{");
sbResult.Append("\"colspan\":\"1\",");
sbResult.Append("\"col_class\":\"ovh col20\",");
sbResult.Append("\"col_id\":\"20\",");
sbResult.Append("\"col_value\":\"" + model.gs_qaqc.Trim() + "\"");
sbResult.Append("},");
//CV_MEP
sbResult.Append("{");
sbResult.Append("\"colspan\":\"1\",");
sbResult.Append("\"col_class\":\"ovh col21\",");
sbResult.Append("\"col_id\":\"21\",");
sbResult.Append("\"col_value\":\"" + model.cv_mep.Trim() + "\"");
sbResult.Append("},");
//GS_MEP
sbResult.Append("{");
sbResult.Append("\"colspan\":\"1\",");
sbResult.Append("\"col_class\":\"ovh col22\",");
sbResult.Append("\"col_id\":\"22\",");
sbResult.Append("\"col_value\":\"" + model.gs_mep.Trim() + "\"");
sbResult.Append("},");
//dinh kem tap tin
string strHTML_Attachment = "";
#region
//string link = Url.Action("Edit", "Account", new { id = EncDec.EncodeCrypto(model.mataikhoan) });
strHTML_Attachment = "<a href='#' class='edit' ><i class='fa fa-pencil-square-o' ></i></a> <a href='#' class='del'><i class='fa fa-trash-o' ></i></a>";
#endregion
sbResult.Append("{");
sbResult.Append("\"colspan\":\"1\",");
sbResult.Append("\"col_class\":\"ovh col10\",");
sbResult.Append("\"col_id\":\"10\",");
sbResult.Append("\"col_value\":\"" + strHTML_Attachment + "\"");
sbResult.Append("}");
#endregion
sbResult.Append("]");
sbResult.Append("},");
}
catch (Exception ex)
{
_logger.Error(ex);
}
return(sbResult);
}
///Thêm mới lịch họp tuần
public ActionResult Create()
{
if (!IsLogged())
{
return(BackToLogin());
}
Item_weedModels param = new Item_weedModels();
DanhmucServices service = new DanhmucServices();
List <Item_weedModels> lstResult_Tuan = service.SelectRows_giaovien(param);
StringBuilder sbtuan = new StringBuilder();
foreach (var item in lstResult_Tuan)
{
item.tentuan = item.tentuan + " " + item.tungay + " " + item.denngay;
sbtuan.Append(string.Format("<option value='{0}'>{1}</option>", item.matuan, item.tentuan));
}
ViewBag.sbtuan = sbtuan.ToString();
//phong ban
PhongBanModels parampb = new PhongBanModels();
List <PhongBanModels> lstResult_phongban = service.SelectRows2(parampb);
StringBuilder sbphongban = new StringBuilder();
string pb = "";
string maphongban = Session["maphongban"].ToString().Trim();
string macongtruong = Session["macongtruong"].ToString().Trim();
int loaicuochop = (int)Session["loaicuochop"];
if (Session["loginid"].ToString().Trim().ToLower() == "admin" || Session["grouptk"].ToString().Trim() == "1")
{
pb = pb + "<option value=0>Chọn phòng ban</option>";
foreach (var item in lstResult_phongban)
{
pb = pb + "<option value=" + item.maphongban + "> " + item.tenphongban + " </option>";
}
}
else
{
foreach (var item in lstResult_phongban.Where(p => p.maphongban == macongtruong))
{
pb = pb + "<option value=" + item.maphongban + "> " + item.tenphongban + " </option>";
}
}
ViewBag.sbphongban = pb.ToString();
StringBuilder sbphonghop = new StringBuilder();
sbphonghop.Append(string.Format("<option value={0}>{1}</option>", "0", "Lựa chọn Phòng họp"));
sbphonghop.Append(string.Format("<option value={0}>{1}</option>", "1", "Tầng 3 - Phòng họp 1"));
sbphonghop.Append(string.Format("<option value={0}>{1}</option>", "2", "Tầng 3 - Phòng họp 2"));
sbphonghop.Append(string.Format("<option value={0}>{1}</option>", "3", "Tầng 3 - Phòng họp lớn"));
sbphonghop.Append(string.Format("<option value={0}>{1}</option>", "4", "Tầng 3A - Phòng họp nhỏ"));
sbphonghop.Append(string.Format("<option value={0}>{1}</option>", "5", "Tầng 3A - Phòng họp lớn"));
sbphonghop.Append(string.Format("<option value={0}>{1}</option>", "6", "Khác"));
ViewBag.sbphonghop = sbphonghop.ToString();
StringBuilder sbloaibaocao = new StringBuilder();
if (loaicuochop == 1)
{
sbloaibaocao.Append(string.Format("<option value={0}>{1}</option>", "1", "Báo cáo tuần CHT/TPB"));
}
else if (loaicuochop == 2)
{
sbloaibaocao.Append(string.Format("<option value={0}>{1}</option>", "2", "Báo cáo tuần Thiết Bị"));
}
else if (loaicuochop == 3)
{
sbloaibaocao.Append(string.Format("<option value={0}>{1}</option>", "3", "Báo cáo tuần HSSE"));
}
else if (loaicuochop == 4)
{
sbloaibaocao.Append(string.Format("<option value={0}>{1}</option>", "4", "Báo cáo tuần QAQC"));
}
else if (loaicuochop == 5)
{
sbloaibaocao.Append(string.Format("<option value={0}>{1}</option>", "5", "Báo cáo tuần MEP"));
}
else
{
sbloaibaocao.Append(string.Format("<option value={0}>{1}</option>", "6", "Chọn loại báo cáo"));
}
ViewBag.sbloaibaocao = sbloaibaocao.ToString();
return(View());
}
