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()); }