public async Task <ActionResult> Create([Bind(Include = "ID,Tuan,Nhom_ID,TieuDe,NoiDung,ThoiGianBaoCao,FileUpload,FilePath,PhanHoi")] BaoCao baoCao, HttpPostedFileBase FileUpload) { var session = (Common.UserLogin)Session[Web.Common.CommonConstants.USER_SESSION]; baoCao.Nhom_ID = session.NhomID; if (ModelState.IsValid) { if (FileUpload != null) { string pic = Path.GetFileName(DateTime.Now.ToString("yyyy_MM_dd-") + FileUpload.FileName); string path = Path.Combine(Server.MapPath("~/UploadFiles/") + pic); FileUpload.SaveAs(path); baoCao.FileUpload = pic; baoCao.FilePath = "UploadFiles/" + pic; } try { db.BaoCaos.Add(baoCao); await db.SaveChangesAsync(); return(RedirectToAction("Index")); } catch (Exception) { ViewBag.BaoCao = "Mỗi nhóm mỗi tuần chỉ báo cáo 1 lần"; } } ViewBag.Nhom_ID = new SelectList(db.Nhoms, "ID", "TenNhom", baoCao.Nhom_ID); return(View(baoCao)); }
public int BaoCaoNhiemVu(BaoCaoNhiemVuViewModel model) { try { using (var db = new dbnhiemvuEntities()) { var baocao = new BaoCao(); baocao.iMaNhiemVuCode = model.iMaNhiemVuCode; baocao.vMoTa = model.vMoTa; baocao.vDuongDanTapTin = model.vDuongDanTapTin; db.BaoCaos.Add(baocao); db.SaveChanges(); if (model.iMaChiTietLoiCode != 0) { var loi = db.ChiTietLois.Find(model.iMaChiTietLoiCode); loi.iTrangThai = 2; db.SaveChanges(); } return(baocao.iMaBaoCaoCode); } } catch { return(0); } }
private void Load_DanhSachHoSo(string Ids = ",26,") { string str = txtSearch.Value.Trim(); DateTime TuNgay = DateTime.Now, DenNgay = DateTime.Now; if (txtTuNgay.Value.Trim() == "") { _msg = "Bạn chưa chọn ngày bắt đầu"; return; } TuNgay = Convert.ToDateTime(txtTuNgay.Value, new CultureInfo("vi-VN")); if (txtDenNgay.Value.Trim() == "") { _msg = "Bạn chưa chọn ngày kết thúc"; return; } DenNgay = Convert.ToDateTime(txtDenNgay.Value, new CultureInfo("vi-VN")); List <BieuDoHinhCotBHTN> lstBieuDo = new List <BieuDoHinhCotBHTN>(); for (DateTime Start = TuNgay; Start <= DenNgay; Start = Start.AddDays(1)) { DataTable tblHoSoBHTN = new BaoCao().BieuDoDKBHTN(Start, Start); BieuDoHinhCotBHTN item = new BieuDoHinhCotBHTN(); item.Ngay = Start.ToString("dd/MM/yyyy"); item.SoHoSo = tblHoSoBHTN.Rows.Count; lstBieuDo.Add(item); } Chart1.DataSource = lstBieuDo; Chart1.Series["Category"].XValueMember = "Ngay"; Chart1.Series["Category"].YValueMembers = "SoHoSo"; Chart1.DataBind(); //name x,y Chart1.ChartAreas["ChartArea1"].AxisX.Title = "Các ngày nộp hồ sơ"; Chart1.ChartAreas["ChartArea1"].AxisY.Title = "Số hồ sơ nộp"; }
void loadForm(string start, string end) { panelLoad.Controls.Clear(); if (loaiForm == 0) { LichSuGiaoDich fr = new LichSuGiaoDich(IDUser, IDWallet, start, end) { Dock = DockStyle.Fill, TopLevel = false, TopMost = true }; panelLoad.Controls.Add(fr); fr.FormBorderStyle = FormBorderStyle.None; fr.Dock = DockStyle.Fill; fr.Show(); } else { BaoCao fr = new BaoCao(IDUser, IDWallet, start, end) { Dock = DockStyle.Fill, TopLevel = false, TopMost = true }; panelLoad.Controls.Add(fr); fr.FormBorderStyle = FormBorderStyle.None; fr.Dock = DockStyle.Fill; fr.Show(); } }
private void button_Click(object sender, RoutedEventArgs e) { try { int idcbsv = int.Parse(cbSV.SelectedValue.ToString()); int idcbdg = int.Parse(cbDG.SelectedValue.ToString()); int idcbmh = int.Parse(cbMH.SelectedValue.ToString()); int diem = int.Parse(tbDT.Text.ToString()); using (var db = new CSDLQlsv()) //connect database { var pc = new BaoCao { id_SinhVien = idcbsv, id_DanhGia = idcbdg, id_MonHoc = idcbmh, diemThi = diem }; db.BaoCaos.Add(pc); db.SaveChanges(); Clear(); lsvBC.Items.Refresh(); lsvBC.ItemsSource = db.BaoCaos.ToList(); } displayLop(); } catch (Exception) { MessageBox.Show("Không được trống", "Lỗi định dạng", MessageBoxButton.OK, MessageBoxImage.Error); } }
public bool InsertBaoCao(BaoCao baocao) { using (SqlConnection con = dc.getConnect()) { try { con.Open(); string sql = "insert into BAOCAO(MaBaoCao, Thang, Nam, SoChuyenBay, DoanhThu) values(@MaBaoCao, @Thang, @Nam, @SoChuyenBay, @DoanhThu)"; cmd = new SqlCommand(sql, con); cmd.Parameters.Add("@MaBaoCao", SqlDbType.VarChar).Value = baocao.MaBaoCao; cmd.Parameters.Add("@Thang", SqlDbType.Int).Value = baocao.Thang; cmd.Parameters.Add("@Nam", SqlDbType.Int).Value = baocao.Nam; cmd.Parameters.Add("@SoChuyenBay", SqlDbType.Int).Value = baocao.SoChuyenBay; cmd.Parameters.Add("@DoanhThu", SqlDbType.Money).Value = baocao.DoanhThu; cmd.ExecuteNonQuery(); con.Close(); return(true); } catch (Exception e) { MessageBox.Show(e.Message, "Thông báo lỗi", MessageBoxButtons.OK, MessageBoxIcon.Error); return(false); } } }
private void lapbctkbutton_Click(object sender, EventArgs e) { BaoCao BC = new BaoCao(); this.Visible = false; BC.ShowDialog(); this.Visible = true; }
public override global::System.Data.DataSet Clone() { BaoCao cln = ((BaoCao)(base.Clone())); cln.InitVars(); cln.SchemaSerializationMode = this.SchemaSerializationMode; return(cln); }
public ActionResult DeleteConfirmed(string id) { BaoCao baoCao = db.BaoCaos.Find(id); db.BaoCaos.Remove(baoCao); db.SaveChanges(); return(RedirectToAction("Index")); }
public static bool updatebc(BaoCao baocao) { using (var _context = new QuanlidoansinhvienEntities()) { _context.BaoCaos.AddOrUpdate(baocao); _context.SaveChanges(); return(true); } }
public async Task <ActionResult> DeleteConfirmed(int id) { BaoCao baoCao = await db.BaoCaos.FindAsync(id); db.BaoCaos.Remove(baoCao); await db.SaveChangesAsync(); return(RedirectToAction("Index")); }
public ActionResult Edit([Bind(Include = "DTNgay,DTThang,DTNam")] BaoCao baoCao) { if (ModelState.IsValid) { db.Entry(baoCao).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(baoCao)); }
public ActionResult Create([Bind(Include = "DTNgay,DTThang,DTNam")] BaoCao baoCao) { if (ModelState.IsValid) { db.BaoCaos.Add(baoCao); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(baoCao)); }
public IHttpActionResult PostBaoCao(BaoCao baoCao) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } baoCao.IDQuanLy = User.Identity.GetUserId(); baoCao.ThoiGian = getDateTime(); db.BaoCaos.Add(baoCao); db.SaveChanges(); return(CreatedAtRoute("DefaultApi", new { id = baoCao.IDBaoCao }, baoCao)); }
public static global::System.Xml.Schema.XmlSchemaComplexType GetTypedDataSetSchema(global::System.Xml.Schema.XmlSchemaSet xs) { BaoCao ds = new BaoCao(); global::System.Xml.Schema.XmlSchemaComplexType type = new global::System.Xml.Schema.XmlSchemaComplexType(); global::System.Xml.Schema.XmlSchemaSequence sequence = new global::System.Xml.Schema.XmlSchemaSequence(); global::System.Xml.Schema.XmlSchemaAny any = new global::System.Xml.Schema.XmlSchemaAny(); any.Namespace = ds.Namespace; sequence.Items.Add(any); type.Particle = sequence; global::System.Xml.Schema.XmlSchema dsSchema = ds.GetSchemaSerializable(); if (xs.Contains(dsSchema.TargetNamespace)) { global::System.IO.MemoryStream s1 = new global::System.IO.MemoryStream(); global::System.IO.MemoryStream s2 = new global::System.IO.MemoryStream(); try { global::System.Xml.Schema.XmlSchema schema = null; dsSchema.Write(s1); for (global::System.Collections.IEnumerator schemas = xs.Schemas(dsSchema.TargetNamespace).GetEnumerator(); schemas.MoveNext();) { schema = ((global::System.Xml.Schema.XmlSchema)(schemas.Current)); s2.SetLength(0); schema.Write(s2); if ((s1.Length == s2.Length)) { s1.Position = 0; s2.Position = 0; for (; ((s1.Position != s1.Length) && (s1.ReadByte() == s2.ReadByte()));) { ; } if ((s1.Position == s1.Length)) { return(type); } } } } finally { if ((s1 != null)) { s1.Close(); } if ((s2 != null)) { s2.Close(); } } } xs.Add(dsSchema); return(type); }
public IHttpActionResult DeleteBaoCao(int id) { BaoCao baoCao = db.BaoCaos.Find(id); if (baoCao == null) { return(NotFound()); } db.BaoCaos.Remove(baoCao); db.SaveChanges(); return(Ok(baoCao)); }
public async Task <ActionResult> Feedback(BaoCao baoCao) { if (ModelState.IsValid) { db.Entry(baoCao).State = EntityState.Modified; await db.SaveChangesAsync(); return(RedirectToAction("Index")); } ViewBag.Nhom_ID = new SelectList(db.Nhoms, "ID", "TenNhom", baoCao.Nhom_ID); return(View(baoCao)); }
public async Task <ActionResult> Edit([Bind(Include = "ID,Tuan,Nhom_ID,TieuDe,NoiDung,ThoiGianBaoCao,FileUpload,FilePath,PhanHoi")] BaoCao baoCao) { if (ModelState.IsValid) { db.Entry(baoCao).State = EntityState.Modified; await db.SaveChangesAsync(); return(RedirectToAction("Index")); } ViewBag.Nhom_ID = new SelectList(db.Nhoms, "ID", "TenNhom", baoCao.Nhom_ID); return(View(baoCao)); }
public static BaoCaoDTO FromEntity(BaoCao item) { return(new BaoCaoDTO() { Id = item.Id, ChiTietCongViecId = item.ChiTietCongViecId, ChiTietCongViec = item.ChiTietCongViec != null?ChiTietCongViecDTO.FromEntity(item.ChiTietCongViec) : null, ThanhVienDuAnId = item.ThanhVienDuAnId, ThanhVienDuAn = item.ThanhVienDuAn != null?ThanhVienDuAnDTO.FromEntity(item.ThanhVienDuAn) : null, NoiDung = item.NoiDung, ThoiGianTao = item.ThoiGianTao, }); }
// GET: BaoCaos/Delete/5 public ActionResult Delete(string id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } BaoCao baoCao = db.BaoCaos.Find(id); if (baoCao == null) { return(HttpNotFound()); } return(View(baoCao)); }
private void btninpm_Click(object sender, EventArgs e) { if (txtMaPhieu.Text == null || txtMaPhieu.Text == "") { MessageBox.Show("Hãy Chọn 1 phiếu để In"); } else { BaoCao.MaPM = txtMaPhieu.Text; BaoCao.keyn = 1; BaoCao baocaof = new BaoCao(); baocaof.ShowDialog(); } }
// GET: GiaoVien/BaoCao/Delete/5 public async Task <ActionResult> Delete(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } BaoCao baoCao = await db.BaoCaos.FindAsync(id); if (baoCao == null) { return(HttpNotFound()); } return(View(baoCao)); }
public IHttpActionResult GetByID(int id) { BaoCao baoCao = db.BaoCaos.Find(id); if (baoCao == null) { return(NotFound()); } if (!isAccess(baoCao.IDQuanLy)) { return(StatusCode(HttpStatusCode.Unauthorized)); } return(Ok(baoCao)); }
public async Task <ActionResult> Feedback(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } BaoCao baoCao = await db.BaoCaos.FindAsync(id); if (baoCao == null) { return(HttpNotFound()); } ViewBag.Nhom_ID = new SelectList(db.Nhoms, "ID", "TenNhom", baoCao.Nhom_ID); return(View(baoCao)); }
public ActionResult Report(string tieude, string mota, string idbv) { var session = (DACN.Common.UserLogin)Session[DACN.Common.CommonConstants.USER_SESSION]; BaoCao bc = new BaoCao(); var bcdao = new ReportDao(); bc.TieuDe = tieude; bc.TenBaoCao = mota; DateTime now = DateTime.Now; bc.NgayBC = now; bc.TrangThai = false; bc.idBV = Int32.Parse(idbv); bcdao.Insert(bc); return(Json(new { Message = "success", JsonRequestBehavior = JsonRequestBehavior.AllowGet })); }
// POST: api/BaoCao //[HttpPost] public IHttpActionResult Post(BaoCao bc, List <ViPhamLuatGT> dsViPham) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } using (GTVTContext ctx = new GTVTContext()) { var baocao = bc; bc.ViPhamLuatGTs = dsViPham; ctx.BaoCaos.Add(baocao); ctx.SaveChanges(); } return(Ok()); }
public int BaoCaoNhiemVu(BaoCaoNhiemVuViewModel model) { try { using (var db = new dbnhiemvuEntities()) { var baocao = new BaoCao(); baocao.iMaNhiemVuCode = model.iMaNhiemVuCode; baocao.vMoTa = model.vMoTa; baocao.vDuongDanTapTin = model.vDuongDanTapTin; db.BaoCaos.Add(baocao); db.SaveChanges(); return(baocao.iMaBaoCaoCode); } } catch { return(0); } }
private void load_table(string table) { switch (table) { case "Pxb": { PhieuXuatBan u1 = new PhieuXuatBan { Dock = DockStyle.Fill }; panel1.Controls.Add(u1); break; } case "pntp": { PhieuXuatKhoTp u2 = new PhieuXuatKhoTp { Dock = DockStyle.Fill }; panel1.Controls.Add(u2); break; } case "BaoCao": { BaoCao u3 = new BaoCao { Dock = DockStyle.Fill }; panel1.Controls.Add(u3); break; } case "bcmh": { MenuBaoCao u4 = new MenuBaoCao { Dock = DockStyle.Fill }; panel1.Controls.Add(u4); break; } } }
private void Load_DanhSachHoSo(string Ids = ",26,") { //string str = ""; DateTime TuNgay = DateTime.Now, DenNgay = DateTime.Now; if (txtTuNgay.Value.Trim() == "") { _msg = "Bạn chưa chọn ngày bắt đầu"; return; } TuNgay = Convert.ToDateTime(txtTuNgay.Value, new CultureInfo("vi-VN")); if (txtDenNgay.Value.Trim() == "") { _msg = "Bạn chưa chọn ngày kết thúc"; return; } DenNgay = Convert.ToDateTime(txtDenNgay.Value, new CultureInfo("vi-VN")); List <BieuDoHinhCotBHTN> lstBieuDo = new List <BieuDoHinhCotBHTN>(); DataTable tblThongKeDoTuoiDuoi24 = new BaoCao().BieuDoBHTNTheoDoTuoi(TuNgay, DenNgay, 10, 23); BieuDoHinhCotBHTN item1 = new BieuDoHinhCotBHTN(); item1.SoHoSo = tblThongKeDoTuoiDuoi24.Rows.Count; item1.Ngay = " Dưới 24 tuổi"; lstBieuDo.Add(item1); DataTable tblThongKeDoTuoi24_40 = new BaoCao().BieuDoBHTNTheoDoTuoi(TuNgay, DenNgay, 24, 40); BieuDoHinhCotBHTN item2 = new BieuDoHinhCotBHTN(); item2.SoHoSo = tblThongKeDoTuoi24_40.Rows.Count; item2.Ngay = "24 đến 40 tuổi"; lstBieuDo.Add(item2); DataTable tblThongKeDoTuoiTren40 = new BaoCao().BieuDoBHTNTheoDoTuoi(TuNgay, DenNgay, 40, 100); BieuDoHinhCotBHTN item3 = new BieuDoHinhCotBHTN(); item3.SoHoSo = tblThongKeDoTuoiTren40.Rows.Count; item3.Ngay = "Trên 40 tuổi"; lstBieuDo.Add(item3); Chart1.DataSource = lstBieuDo; Chart1.Series["Category"].XValueMember = "Ngay"; Chart1.Series["Category"].YValueMembers = "SoHoSo"; Chart1.DataBind(); //name x,y Chart1.ChartAreas["ChartArea1"].AxisX.Title = "Độ tuổi nộp hồ sơ"; Chart1.ChartAreas["ChartArea1"].AxisY.Title = "Số hồ sơ nộp"; }
private void btnDelete_Click(object sender, EventArgs e) { string MaBC = this.dgvBaocao.CurrentRow.Cells[0].Value.ToString(); DialogResult dr = MessageBox.Show("Bạn chắc chắn muốn xóa?", "confirm", MessageBoxButtons.YesNo); if (dr == System.Windows.Forms.DialogResult.Yes) { try { BaoCao bc = sv.BaoCaos.Single(t => t.IDBaoCao.Equals(MaBC)); sv.BaoCaos.Remove(bc); sv.SaveChanges(); Load_data(); MessageBox.Show("Xóa thành công!!!"); clean(); txtIDBaocao.Enabled = true; } catch { MessageBox.Show("Xóa thất bại"); } } }