//protected void btnSave_Click(object sender, EventArgs e) //{ // if (ddlFile.SelectedValue == "Excel") // { // HtmlForm form = new HtmlForm(); // string attachment = "attachment; filename=aaa.xls"; // Response.ClearContent(); // Response.AddHeader("content-disposition", attachment); // Response.ContentType = "application/ms-excel"; // Response.Charset = ""; // Response.ContentEncoding = System.Text.Encoding.Unicode; // Response.BinaryWrite(System.Text.Encoding.Unicode.GetPreamble()); // StringWriter stw = new StringWriter(); // HtmlTextWriter htextw = new HtmlTextWriter(stw); // gvDSTimeSheet.Columns[7].Visible = false; // gvDSTimeSheet.Columns[8].Visible = false; // form.Controls.Add(gvDSTimeSheet); // this.Controls.Add(form); // form.RenderControl(htextw); // Response.Write(stw.ToString()); // Response.End(); // } // if (ddlFile.SelectedValue == "Word") // { // Response.AddHeader("content-disposition", "attachment;filename=Export.doc"); // Response.Cache.SetCacheability(HttpCacheability.NoCache); // Response.ContentType = "application/vnd.word"; // Response.ClearContent(); // Response.Charset = ""; // Response.ContentEncoding = System.Text.Encoding.Unicode; // Response.BinaryWrite(System.Text.Encoding.Unicode.GetPreamble()); // StringWriter stringWrite = new StringWriter(); // HtmlTextWriter htmlWrite = new HtmlTextWriter(stringWrite); // HtmlForm frm = new HtmlForm(); // gvDSTimeSheet.Columns[7].Visible = false; // gvDSTimeSheet.Columns[8].Visible = false; // gvDSTimeSheet.Parent.Controls.Add(frm); // frm.Attributes["runat"] = "server"; // frm.Controls.Add(gvDSTimeSheet); // frm.RenderControl(htmlWrite); // Response.Write(stringWrite.ToString()); // Response.End(); // } //} protected void btnThem_Click(object sender, EventArgs e) { if (this.IsPostBack) { TimeSheetDTO tsdto = new TimeSheetDTO(); int maGDV = int.Parse(drGDV.SelectedItem.Value.ToString()); tsdto.MaGDV = maGDV; string maclaim = txtThamChieu.Text; bool kt = cl.KiemTraThamChieu(maclaim); string diengiai; if (kt == true) { tsdto.ThamChieu = maclaim; tsdto.Ngay = txtNgay.Text; tsdto.IdCongTacTimeSheet = drDienGiai.SelectedItem.Value.ToString(); diengiai = drDienGiai.SelectedItem.ToString(); tsdto.ThoiLuongPhatSinh = float.Parse(txtSoGio.Text); bool them = tsdao.ThemTimeSheet(tsdto); if (them == true) { float time = tsdao.TongThoiLuongPhatSinhTheoCliam(maclaim); wr.CapNhatGioTichLuy(maclaim, time); float gio = tsdao.TongThoiLuongPhatSinhTheoCliam(maclaim); bool updw = wr.CapNhatGioTichLuy(maclaim, gio); Response.Write("<script>alert('Đã thêm!');</script>"); } } } }
protected void btnThem_Click(object sender, EventArgs e) { if (this.IsPostBack) { TimeSheetDTO tsdto = new TimeSheetDTO(); GiamDinhVienDAO gdv = new GiamDinhVienDAO(); int maGDV = int.Parse(Request.Cookies["MaGDV"].Value); tsdto.MaGDV = maGDV; string tengdv = lblGiamDinhVien.Text; string maclaim = txtThamChieu.Text; bool kt = cl.KiemTraThamChieu(maclaim); float h = 0; if (txtSoGio.Text != "" && float.TryParse(txtSoGio.Text, out h)) { string diengiai = txtDienGiaiChiTiet.Text;; // string diengiaidetail = txtDienGiaiChiTiet.Text; string loaidiengiai = ""; if (diengiai != "") { tsdto.DienGiai = diengiai; } else { tsdto.DienGiai = ""; } string extr = txtEtraFee.Text; if (extr != "") { tsdto.ExtraFee = extr; } else { tsdto.ExtraFee = ""; } if (kt == true) { tsdto.ThamChieu = maclaim; tsdto.Ngay = txtNgay.Text; tsdto.IdCongTacTimeSheet = drDienGiai.SelectedItem.Value.ToString(); loaidiengiai = drDienGiai.SelectedItem.ToString(); if (int.Parse(drDienGiai.SelectedValue) != 0) { tsdto.ThoiLuongPhatSinh = float.Parse(txtSoGio.Text); tsdto.GioThuc = DateTime.Now; bool them = tsdao.ThemTimeSheet(tsdto); if (them == true) { float time = tsdao.TongThoiLuongPhatSinhTheoCliam(maclaim); wr.CapNhatGioTichLuy(maclaim, time); string noidung = gdv.LayTenTheoMa(maGDV) + " created timesheet of case " + txtThamChieu.Text + " ."; SaveLogTracking(maGDV, noidung, txtThamChieu.Text); #region KiemTra_GuiMail float gio = tsdao.TongThoiLuongPhatSinhTheoCliam(maclaim); bool updw = wr.CapNhatGioTichLuy(maclaim, gio); #region BodysendLA string bodyGDV = "Xin chào " + tengdv; bodyGDV += "<br/> Bạn vừa cập nhật TimeSheet mới. <br/> Thông tin TimeSheet:<br/>"; bodyGDV += "<table width='100%' align='center' style='border-bottom-color:#CCC; border-bottom-style:solid; border-bottom-width:1px; " + " border-top-color:#CCC; border-top-style:solid; border-top-width:1px;" + " border-left-color:#CCC; border-left-style:solid; border-left-width:1px;" + " border-right-color:#CCC; border-right-style:solid; border-right-width:1px;'>"; bodyGDV += "<tr style='background-color: #040; color:#FFF; font-weight:bold;'>"; //bodyGDV += "<th width='10%'>Giám định viên</th>"; bodyGDV += "<th width='10%'>Tham chiếu</th>"; bodyGDV += "<th width='10%'>Ngày</th>"; bodyGDV += "<th width='25%'>Diễn giải</th>"; bodyGDV += "<th width='25%'>Chi tiết</th>"; bodyGDV += "<th width='10%'>Số giờ</th>"; bodyGDV += "</tr>"; bodyGDV += "<tr style='text-align:center'>"; bodyGDV += "<td style ='border-top-color:#CCC; border-top-style:solid; border-top-width:1px;" + " border-left-color:#CCC; border-left-style:solid; border-left-width:1px;'>" + tsdto.ThamChieu + "</td>"; bodyGDV += "<td style ='border-top-color:#CCC; border-top-style:solid; border-top-width:1px;" + " border-left-color:#CCC; border-left-style:solid; border-left-width:1px;'>" + tsdto.Ngay + "</td>"; bodyGDV += "<td style ='border-top-color:#CCC; border-top-style:solid; border-top-width:1px;" + " border-left-color:#CCC; border-left-style:solid; border-left-width:1px;'>" + loaidiengiai + "</td>"; bodyGDV += "<td style ='border-top-color:#CCC; border-top-style:solid; border-top-width:1px;" + " border-left-color:#CCC; border-left-style:solid; border-left-width:1px;'>" + diengiai + "</td>"; bodyGDV += "<td style ='border-top-color:#CCC; border-top-style:solid; border-top-width:1px;" + " border-left-color:#CCC; border-left-style:solid; border-left-width:1px;'>" + tsdto.ThoiLuongPhatSinh + "</td>"; bodyGDV += "</tr>"; bodyGDV += "</table>"; #endregion #region BodyMailGiamDoc //timesheet gui giam doc string bodyGiamDoc = "Thông báo! "; bodyGiamDoc += "<br/>" + tengdv + " vừa cập nhật TimeSheet mới. <br/> Thông tin Timesheet :<br/>"; bodyGiamDoc += "<table width='100%' align='center' style='border-bottom-color:#CCC; border-bottom-style:solid; border-bottom-width:1px; " + " border-top-color:#CCC; border-top-style:solid; border-top-width:1px;" + " border-left-color:#CCC; border-left-style:solid; border-left-width:1px;" + " border-right-color:#CCC; border-right-style:solid; border-right-width:1px;'>"; bodyGiamDoc += "<tr style='background-color: #040; color:#FFF; font-weight:bold;'>"; bodyGiamDoc += "<th width='20%'>LA</th>"; bodyGiamDoc += "<th width='10%'>Reference</th>"; bodyGiamDoc += "<th width='10%'>Date Update</th>"; bodyGiamDoc += "<th width='10%'>Date</th>"; bodyGiamDoc += "<th width='30%'>Description</th>"; bodyGiamDoc += "<th width='10%'>Time-Spent</th>"; bodyGiamDoc += "</tr>"; bodyGiamDoc += "<tr style='text-align:center'>"; bodyGiamDoc += "<td style ='border-top-color:#CCC; border-top-style:solid; border-top-width:1px;" + " border-left-color:#CCC; border-left-style:solid; border-left-width:1px;'>" + tengdv + "</td>"; bodyGiamDoc += "<td style ='border-top-color:#CCC; border-top-style:solid; border-top-width:1px;" + " border-left-color:#CCC; border-left-style:solid; border-left-width:1px;'>" + tsdto.ThamChieu + "</td>"; bodyGiamDoc += "<td style ='border-top-color:#CCC; border-top-style:solid; border-top-width:1px;" + " border-left-color:#CCC; border-left-style:solid; border-left-width:1px;'>" + tsdto.GioThuc + "</td>"; bodyGiamDoc += "<td style ='border-top-color:#CCC; border-top-style:solid; border-top-width:1px;" + " border-left-color:#CCC; border-left-style:solid; border-left-width:1px;'>" + tsdto.Ngay + "</td>"; bodyGiamDoc += "<td style ='border-top-color:#CCC; border-top-style:solid; border-top-width:1px;" + " border-left-color:#CCC; border-left-style:solid; border-left-width:1px;'>" + diengiai + "</td>"; bodyGiamDoc += "<td style ='border-top-color:#CCC; border-top-style:solid; border-top-width:1px;" + " border-left-color:#CCC; border-left-style:solid; border-left-width:1px;'>" + tsdto.ThoiLuongPhatSinh + "</td>"; bodyGiamDoc += "</tr>"; bodyGiamDoc += "</table>"; #endregion string sTo = ""; int idgdv = int.Parse(Request.Cookies["MaGDV"].Value); GiamDinhVienDAO gdvdao = new GiamDinhVienDAO(); DataTable dt = new DataTable(); dt = gdvdao.GiamDinhVienTheoMa(idgdv); if (dt.Rows.Count > 0) { DataRow dr = dt.Rows[0]; sTo = dr[3].ToString(); } string ktmgdv = "", ktmgiamdoc = ""; int month = int.Parse(DateTime.Now.Month.ToString()); //Send_Email("*****@*****.**", sTo, "Thông báo timesheet mới", bodyGiamDoc, "[email protected],[email protected]"); //sm.KiemTraMailChinhCC(sTo, bodyGiamDoc, "Timesheet Notification", "Timesheet", "*****@*****.**"); sm.KiemTraMailChinhCC(sTo, bodyGDV, "Timesheet Notification", "Timesheet", "*****@*****.**"); #endregion ClearInputs(Page.Controls); //Response.Write("<script> window.parent.closeDialog(); </script>"); //Response.Write("<script> window.parent.location.reload();</script>"); } } else { Response.Write("<script>alert('Chưa chọn loại công tác!');</script>"); } } } else { Response.Write("<script>alert('Nhập sai định dạng giờ lẻ!');</script>"); } } }
protected void btnThem_Click(object sender, EventArgs e) { tsdto = new DiaryDTO(); string maclaim = txtThamChieu.Text; bool kt = cl.KiemTraThamChieu(maclaim); int maGDV = int.Parse(Session["MaGDV"].ToString()); string tengdv = Session["GDV"].ToString(); if (maGDV != null) { if (kt == true) { tsdto.MaClaim = maclaim; tsdto.MaGDV = maGDV; tsdto.NgayThuc = DateTime.Now; tsdto.Ngay = DateTime.Parse(txtNgay.Text); tsdto.DienGiai = txtDienGiai.Text.Trim(); tsdto.SoGio = float.Parse(txtSoGio.Text); tsdto.NgayGioBatDau = DateTime.Parse(txtNgayBatDau.Text); tsdto.NgayGioKetThuc = DateTime.Parse(txtNgayKetThuc.Text); tsdto.KetQua = txtKetQuaGhiNhan.Text.Trim(); bool them = drdao.DiaryMoi(tsdto); if (them == true) { #region KiemTra_GuiMail float gio = drdao.TongThoiLuongPhatSinh(maclaim); bool updw = wr.CapNhatGioTichLuy(maclaim, gio); #region BodysendLA string bodyGDV = "Xin chào " + tengdv; bodyGDV += "<br/> Bạn vừa cập nhật Diary mới. <br/> Thông tin Diary:<br/>"; bodyGDV += "<table width='100%' align='center' style='border-bottom-color:#CCC; border-bottom-style:solid; border-bottom-width:1px; " + " border-top-color:#CCC; border-top-style:solid; border-top-width:1px;" + " border-left-color:#CCC; border-left-style:solid; border-left-width:1px;" + " border-right-color:#CCC; border-right-style:solid; border-right-width:1px;'>"; bodyGDV += "<tr style='background-color: #040; color:#FFF; font-weight:bold;'>"; //bodyGDV += "<th width='10%'>Giám định viên</th>"; bodyGDV += "<th width='10%'>Tham chiếu</th>"; bodyGDV += "<th width='10%'>Ngày</th>"; bodyGDV += "<th width='30%'>Diễn giải</th>"; bodyGDV += "<th width='10%'>Số giờ</th>"; bodyGDV += "<th width='10%'>Start</th>"; bodyGDV += "<th width='10%'>Ended</th>"; bodyGDV += "<th width='30%'>Kết quả</th>"; bodyGDV += "</tr>"; bodyGDV += "<tr style='text-align:center'>"; //bodyGDV += "<td style ='border-top-color:#CCC; border-top-style:solid; border-top-width:1px;" + //" border-left-color:#CCC; border-left-style:solid; border-left-width:1px;'>" + tengdv + "</td>"; bodyGDV += "<td style ='border-top-color:#CCC; border-top-style:solid; border-top-width:1px;" + " border-left-color:#CCC; border-left-style:solid; border-left-width:1px;'>" + tsdto.MaClaim + "</td>"; bodyGDV += "<td style ='border-top-color:#CCC; border-top-style:solid; border-top-width:1px;" + " border-left-color:#CCC; border-left-style:solid; border-left-width:1px;'>" + tsdto.Ngay + "</td>"; bodyGDV += "<td style ='border-top-color:#CCC; border-top-style:solid; border-top-width:1px;" + " border-left-color:#CCC; border-left-style:solid; border-left-width:1px;'>" + tsdto.DienGiai + "</td>"; bodyGDV += "<td style ='border-top-color:#CCC; border-top-style:solid; border-top-width:1px;" + " border-left-color:#CCC; border-left-style:solid; border-left-width:1px;'>" + tsdto.SoGio + "</td>"; bodyGDV += "<td style ='border-top-color:#CCC; border-top-style:solid; border-top-width:1px;" + " border-left-color:#CCC; border-left-style:solid; border-left-width:1px;'>" + tsdto.NgayGioBatDau + "</td>"; bodyGDV += "<td style ='border-top-color:#CCC; border-top-style:solid; border-top-width:1px;" + " border-left-color:#CCC; border-left-style:solid; border-left-width:1px;'>" + tsdto.NgayGioKetThuc + "</td>"; bodyGDV += "<td style ='border-top-color:#CCC; border-top-style:solid; border-top-width:1px;" + " border-left-color:#CCC; border-left-style:solid; border-left-width:1px;'>" + tsdto.KetQua + "</td>"; bodyGDV += "</tr>"; bodyGDV += "</table>"; #endregion #region BodyMailGiamDoc //timesheet gui giam doc string bodyGiamDoc = "Thông báo! "; bodyGiamDoc += "<br/>" + tengdv + " vừa cập nhật Dairy mới. <br/> Thông tin Diary:<br/>"; bodyGiamDoc += "<table width='100%' align='center' style='border-bottom-color:#CCC; border-bottom-style:solid; border-bottom-width:1px; " + " border-top-color:#CCC; border-top-style:solid; border-top-width:1px;" + " border-left-color:#CCC; border-left-style:solid; border-left-width:1px;" + " border-right-color:#CCC; border-right-style:solid; border-right-width:1px;'>"; bodyGiamDoc += "<tr style='background-color: #040; color:#FFF; font-weight:bold;'>"; bodyGiamDoc += "<th width='20%'>GĐV</th>"; bodyGiamDoc += "<th width='10%'>Tham chiếu</th>"; bodyGiamDoc += "<th width='10%'>Ngày Thực</th>"; bodyGiamDoc += "<th width='10%'>Ngày</th>"; bodyGiamDoc += "<th width='30%'>Diễn giải</th>"; bodyGiamDoc += "<th width='10%'>Số giờ</th>"; bodyGiamDoc += "<th width='10%'>Start</th>"; bodyGiamDoc += "<th width='10%'>Ended</th>"; bodyGiamDoc += "<th width='30%'>Kết quả</th>"; bodyGiamDoc += "</tr>"; bodyGiamDoc += "<tr style='text-align:center'>"; bodyGiamDoc += "<td style ='border-top-color:#CCC; border-top-style:solid; border-top-width:1px;" + " border-left-color:#CCC; border-left-style:solid; border-left-width:1px;'>" + tengdv + "</td>"; bodyGiamDoc += "<td style ='border-top-color:#CCC; border-top-style:solid; border-top-width:1px;" + " border-left-color:#CCC; border-left-style:solid; border-left-width:1px;'>" + tsdto.MaClaim + "</td>"; bodyGiamDoc += "<td style ='border-top-color:#CCC; border-top-style:solid; border-top-width:1px;" + " border-left-color:#CCC; border-left-style:solid; border-left-width:1px;'>" + tsdto.NgayThuc + "</td>"; bodyGiamDoc += "<td style ='border-top-color:#CCC; border-top-style:solid; border-top-width:1px;" + " border-left-color:#CCC; border-left-style:solid; border-left-width:1px;'>" + tsdto.Ngay + "</td>"; bodyGiamDoc += "<td style ='border-top-color:#CCC; border-top-style:solid; border-top-width:1px;" + " border-left-color:#CCC; border-left-style:solid; border-left-width:1px;'>" + tsdto.DienGiai + "</td>"; bodyGiamDoc += "<td style ='border-top-color:#CCC; border-top-style:solid; border-top-width:1px;" + " border-left-color:#CCC; border-left-style:solid; border-left-width:1px;'>" + tsdto.SoGio + "</td>"; bodyGiamDoc += "<td style ='border-top-color:#CCC; border-top-style:solid; border-top-width:1px;" + " border-left-color:#CCC; border-left-style:solid; border-left-width:1px;'>" + tsdto.NgayGioBatDau + "</td>"; bodyGiamDoc += "<td style ='border-top-color:#CCC; border-top-style:solid; border-top-width:1px;" + " border-left-color:#CCC; border-left-style:solid; border-left-width:1px;'>" + tsdto.NgayGioKetThuc + "</td>"; bodyGiamDoc += "<td style ='border-top-color:#CCC; border-top-style:solid; border-top-width:1px;" + " border-left-color:#CCC; border-left-style:solid; border-left-width:1px;'>" + tsdto.KetQua + "</td>"; bodyGiamDoc += "</tr>"; bodyGiamDoc += "</table>"; #endregion string sTo = ""; int idgdv = int.Parse(Session["MaGDV"].ToString()); GiamDinhVienDAO gdvdao = new GiamDinhVienDAO(); DataTable dt = new DataTable(); dt = gdvdao.GiamDinhVienTheoMa(idgdv); if (dt.Rows.Count > 0) { DataRow dr = dt.Rows[0]; sTo = dr[3].ToString(); } string ktmgdv = "", ktmgiamdoc = ""; int month = int.Parse(DateTime.Now.Month.ToString()); //ktmgiamdoc = smdao.KiemTraMailChinh("Timesheet","*****@*****.**", bodyGiamDoc, "Thông báo Diary của tháng " + month); ktmgdv = smdao.KiemTraMailChinh("New_Claim", sTo, bodyGDV, "Thông báo cập nhật Diary"); if (updw == true && ktmgdv != "") { //Response.Redirect("~/Pages/DiaRy.aspx"); Response.Write("<script>alert('Updated!');</script>"); Response.Redirect(Request.Url.PathAndQuery, true); } #endregion Response.Write("<script>alert('Đã thêm!');</script>"); } else { lblThongBaoThem.Visible = true; lblThongBaoThem.Text = "Have something wrong here!"; } } else { Response.Write("<script>alert('Mã Claim không hợp lệ!');</script>"); lbllThongBao.Visible = true; } } else { Response.Redirect("~/Pages/Longin.aspx"); } }