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"); }
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 gvDSGDV_SelectedIndexChanged(object sender, EventArgs e) { GiamDinhVienDAO gdvdao = new GiamDinhVienDAO(); GridViewRow row = gvDSGDV.SelectedRow; int mgdv = 0; if (row != null) { string temp = row.Cells[0].Text; mgdv = int.Parse(temp.ToString()); } if (mgdv != null) { DataTable dt = new DataTable(); dt = gdvdao.GiamDinhVienTheoMa(mgdv); if (dt.Rows.Count > 0) { DataRow dr = dt.Rows[0]; txtMaS.Text = dr[0].ToString(); txtTenS.Text = dr[1].ToString(); txtDtS.Text = dr[2].ToString(); txtEmailS.Text = dr[3].ToString(); txtDiaChiS.Text = dr[5].ToString(); drChucVuS.SelectedValue = dr[6].ToString(); txtUsernameS.Text = dr[7].ToString(); txtMaTenS.Text = dr[9].ToString(); txtKichHoat.Text = dr[10].ToString(); txtPublic.Text = dr[11].ToString(); txtFullnameS.Text = dr["FullName"].ToString(); txtRateU.Text=dr["Rate"].ToString(); } sua.Visible = true; } }