public List <AbsentModels> SelectRows_Danhsachnghiphep_11111(AbsentModels clParam)
{
logger.Start("SelectRows");
List <AbsentModels> lstResult = new List <AbsentModels>();
try
{
Hashtable param = new Hashtable();
param = base.SetDataToHashtable(false, clParam);
if (param["manghiphep"].ToString() == "")
{
param["manghiphep"] = "";
}
if (param["nguoitao"].ToString() == "0")
{
param["nguoitao"] = "";
}
IList ilist = sqlMap.ExecuteQueryForList("Dangkynghiphep.SelectRows_Danhsachnghiphep_11111", param);
CastDataType cast = new CastDataType();
lstResult = cast.AdvanceCastDataToList <AbsentModels>(ilist);
}
catch (Exception ex)
{
logger.Error("Loi ---> " + ex.Message);
}
logger.End("SelectRows");
return(lstResult);
}
public int CountRows(AbsentModels clparam)
{
logger.Start("CountRows");
int iResult = 0;
try
{
Hashtable param = new Hashtable();
param = base.SetDataToHashtable(false, clparam);
if (param["manghiphep"].ToString() == "")
{
param["manghiphep"] = "";
}
if (param["maphongban"].ToString() == "0")
{
param["maphongban"] = "";
}
iResult = (int)sqlMap.ExecuteQueryForObject("Dangkynghiphep.CountRows", param);
}
catch (Exception ex)
{
sqlMap.RollbackTransaction();
iResult = 0;
logger.Error(ex.Message);
}
logger.End("CountRows");
return(iResult);
}
public string Insert_Donxinnghiphep(AbsentModels clParam)
{
logger.Start("InsertRow");
string strResult = "";
try
{
if (clParam.manghiphep.ToString().Trim() == "")
{
Hashtable param = new Hashtable();
param = base.SetDataToHashtable(false, clParam);
strResult = GetSequence_All("dm_seq", "Dondangkynghiphep");
clParam.manghiphep = strResult;
base.InsertData(clParam, "Dondangkynghiphep");
}
else
{
Hashtable param = new Hashtable();
param = base.SetDataToHashtable(false, clParam);
sqlMap.Update("Dangkynghiphep.UpdateRow_Dondangkynghiphep", param);
}
strResult = clParam.manghiphep;
}
catch (Exception ex)
{
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 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 string send_Mail(string strEncryptCode, string mailto, string Subject, string Contents, AbsentModels model, string hotento)
{
_logger.Start("send_Mail");
try
{
string linkname = string.Format(Functiontring.ReturnStringFormatthongtincauhinhmail("linkname"));
strEncryptCode = linkname.Trim() + strEncryptCode + "&mailcanhan=" + mailto;
if ((model.machucdanh == "1" && double.Parse(model.songayxinnghi) > 2) || model.machucdanh == "2")
{
strEncryptCode = strEncryptCode + "&hovaten=" + model.hovaten + "&tenphongban=" + model.tenphongban
+ "&songayxinnghi=" + model.songayxinnghi + "&ngayxinnghitu=" + model.ngayxinnghitu + "&ngayxinnghiden=" + model.ngayxinnghiden
+ "&lydoxinnghi=" + model.lydoxinnghi + "&sodienthoai=" + model.sodienthoai + "&mailcanhan=" + model.email;
}
//string smtp_port = string.Format(Functiontring.ReturnStringFormatthongtincauhinhmail("smtp_port"));
string smtp_host = string.Format(Functiontring.ReturnStringFormatthongtincauhinhmail("smtp_host"));
string smtp_user = string.Format(Functiontring.ReturnStringFormatthongtincauhinhmail("smtp_user"));
#region
StringBuilder sb = new StringBuilder();
sb.Append("<html><head>");
sb.Append("<link rel='stylesheet' type='text/css' href='theme.css' />");
sb.Append("</head>");
sb.Append("<body style='margin-top: 20px; padding: 0; width: 650px; font-size: 1em;color:black;'>"); //margin: 0 auto; de canh giua
sb.Append("<table cellpadding='0' cellspacing='0' width='650px' >");
sb.Append("<tbody>");
sb.Append("<tr>");
sb.Append("<td height='76px' width='650px' >");
sb.Append("<table cellpadding='0' cellspacing='0' width='100%'>");
sb.Append("<tbody>");
sb.Append("<tr>");
sb.Append("<td>");
sb.Append("<div style='width:150px;float:left;height :45px; line-height:45px; padding-top:10px;'>");
sb.Append("<img src='http://i.imgur.com/yKqNNy2.png' alt='ddd' style='width:100px; height:45px;'/>");
sb.Append("</div>");
sb.Append("</td>");
sb.Append("<td>");
sb.Append("<div style='width:400px; text-align:center;font-weight: bold;float:left;line-height:45px'>");
sb.Append("<p style= 'width:400px;text-align:center;font-size:18px;font-weight:bold;line-height:45px;padding-left:80px;float:left;'> ĐƠN XIN NGHỈ PHÉP</p>");
sb.Append("</div>");
sb.Append("</td>");
sb.Append("</tr>");
sb.Append("</tbody>");
sb.Append("</table>");
sb.Append("</td>");
sb.Append("</tr>");
sb.Append("</tbody>");
sb.Append("</table>");
sb.Append("<hr style=border: 1px solid #000; width: 100% />");
sb.Append("<table style='width:650px; font-size:14px;'>");
sb.Append("<tr><td style='padding-left:10px;'><p><strong><em><u>Kính gửi Anh/Chị:</u></em> " + hotento + "</strong></p></td></tr>");
sb.Append("<tr><td style='float:left;height :22px; line-height:22px; padding-left:10px;'>" + "Họ và tên: " + model.hovaten + "" + "</td></tr>");
sb.Append("<tr><td style='float:left;height :22px; line-height:22px; padding-left:10px;'>" + "Công tác tại: " + model.tenphongban + "" + "</td></tr>");
sb.Append("<tr><td style='float:left;height :22px; line-height:22px; padding-left:10px;'>" + "Số ngày xin nghỉ: " + model.songayxinnghi + "" + "</td></tr>");
sb.Append("<tr><td style='float:left;height :22px; line-height:22px; padding-left:10px;'>" + "Từ ngày: " + model.ngayxinnghitu + " đến ngày: " + model.ngayxinnghiden + "" + "</td></tr>");
sb.Append("<tr><td style='float:left;height :22px; line-height:22px; padding-left:10px;'>" + "Lý do xin nghỉ: " + model.lydoxinnghi + "" + "</td></tr>");
sb.Append("<tr><td style='float:left;height :22px; line-height:22px; padding-left:10px;'>" + "Số điện thoại: " + model.sodienthoai + "" + "</td></tr>");
sb.Append("<tr><td style='float:left;height :22px; line-height:22px; padding-left:10px;'>" + "Email: " + model.email + "" + "</td></tr>"); //style='background-color:blue;color:white'
sb.Append("<tr><td style='float:left; padding-left:10px; padding-top:10px;'><a href='" + strEncryptCode + "&dongy=1'> Đồng ý</a> <a href='" + strEncryptCode + "&dongy=3'>Không đồng ý</a></td></tr>");
sb.Append("</table>");
sb.Append("</body>");
sb.Append("</html>");
#endregion
System.Net.Mail.MailMessage message = new System.Net.Mail.MailMessage(smtp_user, mailto.Trim());
message.From = new MailAddress(mailto.Trim(), Subject, System.Text.Encoding.UTF8);
message.Subject = Subject;
message.Body = sb.ToString();
message.BodyEncoding = System.Text.Encoding.UTF8;
message.IsBodyHtml = true;
message.Priority = MailPriority.High;
SmtpClient client = new SmtpClient(smtp_host);
client.UseDefaultCredentials = true;
try
{
client.Send(message);
}
catch (Exception ex)
{
Console.WriteLine("Exception caught in CreateTestMessage2(): {0}",
ex.ToString());
}
return("Successfull!");
}
catch (Exception ms)
{
_logger.Error(ms);
return(ms.Message);
}
_logger.End("send_Mail");
}
public JsonResult SelectRows_Danhsachnghiphep(AbsentModels model, string curentPage)
{
AbsentModels param = new AbsentModels();
AbsentServices service = new AbsentServices();
int loginid = 0;
if (Session["userid"].ToString().Trim() != "1")
{
loginid = int.Parse(Session["userid"].ToString());
}
param.nguoitao = loginid;
param.maphongban = model.maphongban;
maphongbanexcel = model.maphongban;
int tongsodong = service.CountRows(param);
int trang = 1;
try
{
trang = int.Parse(curentPage);
trang = trang + 1;
}
catch (Exception) { trang = 1; }
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 (trang != 1 && trang <= sotrang)
{
trangbd = (trangkt * (trang - 1)) + 1;
trangkt = trangkt * trang;
}
List <AbsentModels> lstResult = new List <AbsentModels>();
if (trang <= sotrang)
{
lstResult = service.SelectRows_Danhsachnghiphep(param, trangbd, trangkt);
}
else if (trang != 1 && trang > sotrang)
{
trang = trang - 1;
}
foreach (var list in lstResult)
{
string mang = "";
if (list.nghiphep.Trim() == "1")
{
mang = mang + "Nghỉ phép" + ", ";
}
if (list.nghiom.Trim() == "1")
{
mang = mang + "Nghỉ ốm" + ", ";
}
if (list.nghithaisan.Trim() == "1")
{
mang = mang + "Nghỉ thai sản" + ", ";
}
if (list.nghikhongluong.Trim() == "1")
{
mang = mang + "Nghỉ không lương" + ", ";
}
if (list.nghiviecrieng.Trim() == "1")
{
mang = mang + "Nghỉ việc riêng có lương" + ", ";
}
if (list.nghikhac.Trim() == "1")
{
mang = mang + "Nghỉ khác" + ", ";
}
if (mang.Length > 0)
{
mang = mang.Trim().Remove(mang.Trim().Length - 1);
}
list.loaiphepnam = mang;
if (list.duyetcap1 == "0")
{
list.duyetcap1ten = "Chờ duyệt";
}
else if (list.duyetcap1 == "1")
{
list.duyetcap1ten = "Đã duyệt";
}
else if (list.duyetcap1 == "2")
{
list.duyetcap1ten = "Không duyệt";
}
if (list.duyetcap2 == "0")
{
list.duyetcap2ten = "Chờ duyệt";
}
else if (list.duyetcap2 == "1")
{
list.duyetcap2ten = "Đã duyệt";
}
else if (list.duyetcap2 == "2")
{
list.duyetcap2ten = "Không duyệt";
}
if (list.xacnhantruockhivaolamlai == "0")
{
list.xacnhantruockhivaolamlaiten = "No";
}
else
{
list.xacnhantruockhivaolamlaiten = "Yes";
}
}
StringBuilder sbResult = new StringBuilder();
StringBuilder sbRows = new StringBuilder();
if (lstResult.Count > 0)
{
string strSTT = "";
int i = trangbd;
foreach (var item in lstResult)
{
strSTT = i.ToString();
sbRows.Append(PrepareDataJson_Danhsachnghiphep(item, strSTT));
i++;
}
if (sbRows.Length > 0)
{
sbRows.Remove(sbRows.Length - 1, 1);
}
}
sbResult.Append("{");
sbResult.Append("\"isHeader\":\"" + "111" + "\",");
sbResult.Append("\"curentPage\":\"" + "" + trang + "" + "\",");
sbResult.Append("\"Pages\":\"" + "" + sotrang + "" + "\",");
if (trang > 1 && lstResult.Count > 0)
{
sbResult.Append("\"SubRow\":\"" + "true" + "\",");
sbResult.Append("\"RowID\":\"" + model.manghiphep + "\",");
}
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]));
}
private StringBuilder PrepareDataJson_Danhsachnghiphep(AbsentModels 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.manghiphep.ToString(), 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.manghiphep.ToString(), 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}' mdk='" + strEncryptCode + "' duyet='" + model.duyetcap1 + "' />", model.manghiphep);
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.manghiphep + "\"");
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.hovaten + "\"");
sbResult.Append("},");
//Tên đon vi
sbResult.Append("{");
sbResult.Append("\"colspan\":\"1\",");
sbResult.Append("\"col_class\":\"ovh col5\",");
sbResult.Append("\"col_id\":\"5\",");
//sbResult.Append("\"title\":\"" + model.madonvi + "\",");
sbResult.Append("\"col_value\":\"" + model.ngaysinh + "\"");
sbResult.Append("},");
////Tên phòng ban
//sbResult.Append("{");
//sbResult.Append("\"colspan\":\"1\",");
//sbResult.Append("\"col_class\":\"ovh col6\",");
//sbResult.Append("\"col_id\":\"6\",");
//sbResult.Append("\"title\":\"" + model.machucdanh + "\",");
//sbResult.Append("\"col_value\":\"" + model.tenchucdanh + "\"");
//sbResult.Append("},");
//Tên phòng ban
sbResult.Append("{");
sbResult.Append("\"colspan\":\"1\",");
sbResult.Append("\"col_class\":\"ovh col7\",");
sbResult.Append("\"col_id\":\"7\",");
sbResult.Append("\"title\":\"" + model.maphongban + "\",");
sbResult.Append("\"col_value\":\"" + model.tenphongban + "\"");
sbResult.Append("},");
//Tên phòng ban
sbResult.Append("{");
sbResult.Append("\"colspan\":\"1\",");
sbResult.Append("\"col_class\":\"ovh col8\",");
sbResult.Append("\"col_id\":\"8\",");
sbResult.Append("\"col_value\":\"" + model.ngayxinnghitu + "\"");
sbResult.Append("},");
//Tên phòng ban
sbResult.Append("{");
sbResult.Append("\"colspan\":\"1\",");
sbResult.Append("\"col_class\":\"ovh col9\",");
sbResult.Append("\"col_id\":\"9\",");
sbResult.Append("\"col_value\":\"" + model.songayxinnghi + "\"");
sbResult.Append("},");
//Tên phòng ban
sbResult.Append("{");
sbResult.Append("\"colspan\":\"1\",");
sbResult.Append("\"col_class\":\"ovh col10\",");
sbResult.Append("\"col_id\":\"10\",");
sbResult.Append("\"title\":\"" + model.machucdanh + "\",");
sbResult.Append("\"col_value\":\"" + model.ngayxinnghiden + "\"");
sbResult.Append("},");
////Tên phòng ban
//sbResult.Append("{");
//sbResult.Append("\"colspan\":\"1\",");
//sbResult.Append("\"col_class\":\"ovh col11\",");
//sbResult.Append("\"col_id\":\"11\",");
//sbResult.Append("\"col_value\":\"" + model.songayphepconlai + "\"");
//sbResult.Append("},");
//Tên phòng ban
sbResult.Append("{");
sbResult.Append("\"colspan\":\"1\",");
sbResult.Append("\"col_class\":\"ovh col12\",");
sbResult.Append("\"col_id\":\"12\",");
sbResult.Append("\"col_value\":\"" + model.lydoxinnghi + "\"");
sbResult.Append("},");
//Tên phòng ban
sbResult.Append("{");
sbResult.Append("\"colspan\":\"1\",");
sbResult.Append("\"col_class\":\"ovh col13\",");
sbResult.Append("\"col_id\":\"13\",");
sbResult.Append("\"col_value\":\"" + model.loaiphepnam + "\"");
sbResult.Append("},");
//Tên phòng ban
sbResult.Append("{");
sbResult.Append("\"colspan\":\"1\",");
sbResult.Append("\"col_class\":\"ovh col14\",");
sbResult.Append("\"col_id\":\"14\",");
sbResult.Append("\"title\":\"" + model.duyetcap1 + "\",");
sbResult.Append("\"col_value\":\"" + model.duyetcap1ten + "\"");
sbResult.Append("},");
//Tên phòng ban
sbResult.Append("{");
sbResult.Append("\"colspan\":\"1\",");
sbResult.Append("\"col_class\":\"ovh col15\",");
sbResult.Append("\"col_id\":\"15\",");
sbResult.Append("\"col_value\":\"" + model.duyetcap2ten + "\"");
sbResult.Append("},");
//Tên phòng ban
sbResult.Append("{");
sbResult.Append("\"colspan\":\"1\",");
sbResult.Append("\"col_class\":\"ovh col16\",");
sbResult.Append("\"col_id\":\"16\",");
sbResult.Append("\"col_value\":\"" + model.xacnhantruockhivaolamlaiten + "\"");
sbResult.Append("},");
//Ghi chú
sbResult.Append("{");
sbResult.Append("\"colspan\":\"1\",");
sbResult.Append("\"col_class\":\"ovh col17\",");
sbResult.Append("\"col_id\":\"17\",");
sbResult.Append("\"col_value\":\"''\"");
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 col8\",");
//sbResult.Append("\"col_id\":\"8\",");
//sbResult.Append("\"col_value\":\"" + strHTML_Attachment + "\"");
//sbResult.Append("}");
#endregion
sbResult.Append("]");
sbResult.Append("},");
}
catch (Exception ex)
{
_logger.Error(ex);
}
return(sbResult);
}
public ActionResult ExportLicensing()
{
//check login
if (!IsLogged())
{
return(BackToLogin());
}
List <AbsentModels> lstResult = new List <AbsentModels>();
AbsentModels param = new AbsentModels();
AbsentServices service = new AbsentServices();
param.maphongban = maphongbanexcel;
int loginid = 0;
if (Session["loginid"].ToString() != "admin")
{
loginid = int.Parse(Session["userid"].ToString());
}
param.nguoitao = loginid;
lstResult = service.SelectRows_Danhsachnghiphep(param, 1, 5000);
DataTable dt = new DataTable();
dt.TableName = "Employee";
dt.Columns.Add("hovaten");
dt.Columns.Add("ngaynghi");
dt.Columns.Add("songay");
dt.Columns.Add("nghiden");
foreach (var item in lstResult)
{
DataRow row = dt.NewRow();
dt.Rows.Add(row);
row["hovaten"] = item.hovaten;
row["ngaynghi"] = item.ngayxinnghitu;
row["songay"] = item.songayxinnghi;
row["nghiden"] = item.ngayxinnghiden;
dt.AcceptChanges();
}
using (XLWorkbook wb = new XLWorkbook())
{
wb.Worksheets.Add(dt);
wb.Style.Alignment.Horizontal = XLAlignmentHorizontalValues.Center;
wb.Style.Font.Bold = true;
Response.Clear();
Response.Buffer = true;
Response.Charset = "";
Response.ContentType = "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet";
Response.AddHeader("content-disposition", "attachment;filename= EmployeeReport.xlsx");
using (MemoryStream MyMemoryStream = new MemoryStream())
{
wb.SaveAs(MyMemoryStream);
MyMemoryStream.WriteTo(Response.OutputStream);
Response.Flush();
Response.End();
}
}
return(RedirectToAction("Vacationlist"));
}
