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"); }
}
}
