protected void btnUpdate_Click(object sender, EventArgs e) { TimeSheetDTO ts = new TimeSheetDTO(); ts.ID = int.Parse(lblID.Text); if (drGDV.Visible == true) ts.MaGDV = int.Parse(drGDV.SelectedItem.Value.ToString()); else ts.MaGDV = int.Parse(lblID_GDV.Text); bool kttc = cl.KiemTraThamChieu(txtThamChieu.Text); if (kttc == true) ts.ThamChieu = txtThamChieu.Text; else Response.Write("<script>alert('Case no. isn't true!');</script>"); ts.Ngay = txtNgay.Text; if (drCongTac.Visible == true) ts.IdCongTacTimeSheet = drCongTac.SelectedItem.Value.ToString(); else ts.IdCongTacTimeSheet = lblID_CongTac.Text; ts.DienGiai = txtDienGiaiChiTiet.Text; string extr = txtEtraFee.Text; if (extr != "") ts.ExtraFee = extr; else ts.ExtraFee = ""; ts.ThoiLuongPhatSinh = float.Parse(txtSoGio.Text); ts.TimeIssue = float.Parse(txtTIssue.Text); bool up = tsdao.UpdateMa(ts); if (up == true) { int maGDV = int.Parse(Request.Cookies["MaGDV"].Value); string noidung = gdvdao.LayTenTheoMa(maGDV) + " updated a timesheet of case " + txtThamChieu.Text + " ."; SaveLogTracking(maGDV, noidung, txtThamChieu.Text); Response.Write("<script> window.parent.closeDialog(); </script>"); Response.Write("<script> window.parent.location.reload();</script>"); } else { int maGDV = int.Parse(Request.Cookies["MaGDV"].Value); string noidung = gdvdao.LayTenTheoMa(maGDV) + " failed to update timesheet of case" + txtThamChieu.Text + " ."; SaveLogTracking(maGDV, noidung, txtThamChieu.Text); Response.Write("<script>alert('Update fail!');</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>"); } }
public bool UpdateMa(TimeSheetDTO ts) { string sql = "sp_Timesheet_UpdateMa"; List<SqlParameter> ds = new List<SqlParameter>(); ds.Add(new SqlParameter("@id", ts.ID)); ds.Add(new SqlParameter("@idgdv",ts.MaGDV)); ds.Add(new SqlParameter("@thamchieu", ts.ThamChieu)); ds.Add(new SqlParameter("@ngay", ts.Ngay)); ds.Add(new SqlParameter("@idcongtac", ts.IdCongTacTimeSheet)); ds.Add(new SqlParameter("@diengiai", ts.DienGiai)); ds.Add(new SqlParameter("@gio", ts.ThoiLuongPhatSinh)); ds.Add(new SqlParameter("@gioissue",ts.TimeIssue)); ds.Add(new SqlParameter("@extra", ts.ExtraFee)); return SqlDataAcessHelper.exNonStoreParas(sql, ds); }
public bool ThemTimeSheet(TimeSheetDTO ts) { string sql="sp_TimeSheet_Them"; List<SqlParameter>ds=new List<SqlParameter>(); SqlParameter a = new SqlParameter("@magdv", SqlDbType.Int); a.Value = ts.MaGDV; ds.Add(a); SqlParameter b = new SqlParameter("@thamchieu", SqlDbType.NVarChar); b.Value = ts.ThamChieu; ds.Add(b); SqlParameter c = new SqlParameter("@ngay", SqlDbType.NVarChar); c.Value = ts.Ngay; ds.Add(c); SqlParameter e = new SqlParameter("@macongtactimesheet", SqlDbType.VarChar); e.Value = ts.IdCongTacTimeSheet; ds.Add(e); SqlParameter f = new SqlParameter("@diengiai", SqlDbType.NVarChar); f.Value = ts.DienGiai; ds.Add(f); SqlParameter g = new SqlParameter("@phatsinh", SqlDbType.Float); g.Value = ts.ThoiLuongPhatSinh; ds.Add(g); SqlParameter giothuc = new SqlParameter("@giothuc", SqlDbType.DateTime); giothuc.Value = ts.GioThuc; ds.Add(giothuc); SqlParameter extra = new SqlParameter("@extra",SqlDbType.NVarChar); extra.Value = ts.ExtraFee; ds.Add(extra); return SqlDataAcessHelper.exNonStoreParas(sql, ds); }
public bool SuaTimeSheet(TimeSheetDTO ts) { string sql= "sp_TimeSheet_Sua"; List<SqlParameter>ds=new List<SqlParameter>(); SqlParameter ma = new SqlParameter("@id", SqlDbType.Int); ma.Value = ts.ID; ds.Add(ma); SqlParameter b = new SqlParameter("@thamchieu", SqlDbType.NVarChar); b.Value = ts.ThamChieu; ds.Add(b); SqlParameter e = new SqlParameter("@macongtactimesheet", SqlDbType.VarChar); e.Value = ts.IdCongTacTimeSheet; ds.Add(e); SqlParameter ngay = new SqlParameter("@ngay", SqlDbType.VarChar); ngay.Value = ts.Ngay; ds.Add(ngay); SqlParameter f = new SqlParameter("@diengiai", SqlDbType.NVarChar); f.Value = ts.DienGiai; ds.Add(f); SqlParameter g = new SqlParameter("@phatsinh", SqlDbType.Float); g.Value = ts.ThoiLuongPhatSinh; ds.Add(g); return SqlDataAcessHelper.exNonStoreParas(sql, ds); }
//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>"); } } } }