public bool CapNhat(WeeklyReportDTO w) { string sql = "sp_WeeklyReport_CapNhat"; List <SqlParameter> ds = new List <SqlParameter>(); SqlParameter id = new SqlParameter("@idweekly", SqlDbType.Int); id.Value = w.Ma; ds.Add(id); SqlParameter dx = new SqlParameter("@dexuat", SqlDbType.NVarChar); dx.Value = w.DeXuatGiamDinh; ds.Add(dx); return(SqlDataAcessHelper.exNonStoreParas(sql, ds)); }
public WeeklyReportDTO GetWeeklyReport(DateTime from, DateTime to) { _from = from; _to = to; GenerateCoverangeRange(); RetrieveItemHistoriesForEachCoverage(); ComputeOutQuantityForEachItems(); WeeklyReportDTO dto = new WeeklyReportDTO(); dto.From = from; dto.To = to; dto.DaySections = _range; dto.Items = _itemRows; return(dto); }
private void GenerateWeeklyReport(string fileName) { ItemService itemService = new ItemService(_context); HistoryService historyService = new HistoryService(_context); WeeklyHistoryReportService s = new WeeklyHistoryReportService(itemService, historyService); DateTime from = dtpWeeklyFrom.Value.Date; DateTime to = dtpWeeklyTo.Value.Date; SupplierInReportService d = new SupplierInReportService(new DRService(_context)); WeeklyReportDTO record = s.GetWeeklyReport(from, to); record.SupplierReport = d.blah(from, to); WeeklyReporter reporter = new WeeklyReporter(record, fileName); reporter.Export(); }
public bool Them(WeeklyReportDTO w) { string sql = "sp_WeeklyReport_Them"; List <SqlParameter> ds = new List <SqlParameter>(); SqlParameter maclaim = new SqlParameter("@maclaim", SqlDbType.VarChar); maclaim.Value = w.MaClaim; ds.Add(maclaim); SqlParameter gdv = new SqlParameter("@idgdv", SqlDbType.Int); gdv.Value = w.MaGDV; ds.Add(gdv); SqlParameter giotichluy = new SqlParameter("@giotichluy", SqlDbType.Float); giotichluy.Value = w.GioTichLuy; ds.Add(giotichluy); SqlParameter dexuatgiamdinh = new SqlParameter("@dexuatgiamdinh", SqlDbType.NVarChar); dexuatgiamdinh.Value = w.DeXuatGiamDinh; ds.Add(dexuatgiamdinh); return(SqlDataAcessHelper.exNonStoreParas(sql, ds)); }
protected void btnCapNhat_Click(object sender, EventArgs e) { if (IsPostBack) { //string maclaim = ""; //if (lblThamChieu.Text != "") // maclaim = lblThamChieu.Text; //if (txtThamChieu.Text != "") // maclaim = txtThamChieu.Text; string maclaim = Session["ThamChieu"].ToString(); bool kq = wrdao.KiemTraWR(maclaim); bool kt = tsdao.KiemTraTimeSheetTonTai(maclaim); if (kq == false) //chua co weekly report { //them moi wr //maclaim = lblThamChieu.Text; wrdto.MaClaim = maclaim; //wrdto.MaGDV = int.Parse(drGDV.SelectedValue); if (kt == true) { float gio = tsdao.TongThoiLuongPhatSinhTheoCliam(maclaim); wrdto.GioTichLuy = gio; } else { wrdto.GioTichLuy = (float)0; } string dexuatgiamdinh = txtDeXuatGiamDinh.Text; if (dexuatgiamdinh != "") { wrdto.DeXuatGiamDinh = dexuatgiamdinh; } else { wrdto.DeXuatGiamDinh = ""; } bool kqt = wrdao.Them(wrdto); if (kqt == true) { //string thamchieu = cldao.TenClaim(maclaim); //Session["ThamChieu"] = thamchieu; int maGDV = int.Parse(Request.Cookies["MaGDV"].Value); string noidung = gdv.LayTenTheoMa(maGDV) + " created a weeklyreport of case" + maclaim + " ."; SaveLogTracking(maGDV, noidung, maclaim); Response.Write("<script> window.parent.closeDialog(); </script>"); Response.Write("<script> window.parent.location.reload();</script>"); } } else { //cap nhat wr wrdto = new WeeklyReportDTO(); wrdto.Ma = wrdao.LayMa(maclaim); //wrdto.DuPhongTonThat = txtDuPhongTonThat.Text.Trim(); wrdto.DeXuatGiamDinh = txtDeXuatGiamDinh.Text.Trim(); //wrdto.GioTichLuy = float.Parse(txtGioTichLuy.Text); bool kqcn = wrdao.CapNhat(wrdto); if (kqcn == true) { // string tc = cldao.TenClaim(maclaim); // Session["ThamChieu"] = tc; int maGDV = int.Parse(Request.Cookies["MaGDV"].Value); string noidung = gdv.LayTenTheoMa(maGDV) + " edited weeklyreport of case" + maclaim + " ."; SaveLogTracking(maGDV, noidung, maclaim); Response.Write("<script> window.parent.closeDialog(); </script>"); Response.Write("<script> window.parent.location.reload();</script>"); } } } }
protected void btnCapNhat_Click(object sender, EventArgs e) { if (IsPostBack) { string maclaim = ""; if (lblThamChieu.Text != "") { maclaim = lblThamChieu.Text; } if (txtThamChieu.Text != "") { maclaim = txtThamChieu.Text; } bool kq = wrdao.KiemTraWR(maclaim); bool kt = tsdao.KiemTraTimeSheetTonTai(maclaim); if (kq == false) //chua co weekly report { //them moi wr maclaim = txtThamChieu.Text; wrdto.MaClaim = maclaim; //wrdto.MaGDV = int.Parse(drGDV.SelectedValue); if (kt == true) { float gio = tsdao.TongThoiLuongPhatSinhTheoCliam(maclaim); wrdto.GioTichLuy = gio; } else { wrdto.GioTichLuy = (float)0; } string dexuatgiamdinh = ckDeXuatGiamDinh.Text; if (dexuatgiamdinh != "") { wrdto.DeXuatGiamDinh = dexuatgiamdinh; } else { wrdto.DeXuatGiamDinh = ""; } bool kqt = wrdao.Them(wrdto); if (kqt == true) { string thamchieu = cldao.TenClaim(maclaim); Session["ThamChieu"] = thamchieu; Response.Redirect("~/Pages/XemWeeklyReport.aspx?viewthamchieu=" + thamchieu); } } else { //cap nhat wr wrdto = new WeeklyReportDTO(); wrdto.Ma = wrdao.LayMa(maclaim); //wrdto.DuPhongTonThat = txtDuPhongTonThat.Text.Trim(); wrdto.DeXuatGiamDinh = ckDeXuatGiamDinh.Text.Trim(); //wrdto.GioTichLuy = float.Parse(txtGioTichLuy.Text); bool kqcn = wrdao.CapNhat(wrdto); if (kqcn == true) { string tc = cldao.TenClaim(maclaim); Session["ThamChieu"] = tc; Response.Redirect("~/Pages/XemWeeklyReport.aspx?viewthamchieu=" + tc); //Response.RedirectLocation("~/Pages/ViewWR.aspx"); } } //} //else // lblThongBao.Text = "Sai tham chiếu."; //} //else // lblThongBao.Text = "Chưa nhập tham chiếu."; } }
public WeeklyReporter(WeeklyReportDTO weeklyReport, string path) { _weeklyReport = weeklyReport; _path = path; }