public ActionResult Create([Bind(Include = "ID,Ten")] TheLoai theLoai) { if (ModelState.IsValid) { db.TheLoai.Add(theLoai); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(theLoai)); }
public ActionResult Create([Bind(Include = "ID,MaPhieuTra,NgayTra,DocGiaID")] PhieuTra phieuTra) { if (ModelState.IsValid) { db.PhieuTra.Add(phieuTra); db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.DocGiaID = new SelectList(db.DocGia, "ID", "MaThe", phieuTra.DocGiaID); return(View(phieuTra)); }
public ActionResult Create([Bind(Include = "ID,PhieuMuonID,CuonSachID,TinhTrang")] ChiTietMuon chiTietMuon) { if (ModelState.IsValid) { db.ChiTietMuon.Add(chiTietMuon); db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.CuonSachID = new SelectList(db.CuonSach, "ID", "MaVach", chiTietMuon.CuonSachID); ViewBag.PhieuMuonID = new SelectList(db.PhieuMuon, "ID", "MaPhieuMuon", chiTietMuon.PhieuMuonID); return(View(chiTietMuon)); }
private void btn_add_Click(object sender, EventArgs e) { try { var dausach = new DauSach(); dausach.Ten = txt_name.Text; dausach.TheLoaiID = Convert.ToInt32(cbb_category.SelectedValue); dausach.TacGiaID = Convert.ToInt32(cbb_author.SelectedValue); dausach.TomTat = txt_summary.Text; dausach.TaiBan = Convert.ToInt32(txt_republish.Text); dausach.NhaSanXuatID = Convert.ToInt32(cbb_producer.SelectedValue); dausach.SoLuongTong = Convert.ToInt32(txt_sumnumber.Text); dausach.TinhTrang = Convert.ToByte(cbb_state.SelectedValue); _context.DauSach.Add(dausach); _context.SaveChanges(); for (int i = 1; i <= Convert.ToInt32(txt_sumnumber.Text); i++) { var cuonsach = new CuonSach(); cuonsach.MaVach = "MV" + dausach.ID + i; cuonsach.DauSachID = dausach.ID; cuonsach.TinhTrang = 2; _context.CuonSach.Add(cuonsach); } var phieunhap = new PhieuNhapDauSach(); phieunhap.DauSachID = dausach.ID; phieunhap.NgayNhap = DateTime.Now; phieunhap.SoLuongCuonSach = dausach.SoLuongTong; _context.PhieuNhapDauSach.Add(phieunhap); _context.SaveChanges(); txt_name.Text = null; txt_republish.Text = null; txt_summary.Text = null; txt_sumnumber.Text = null; form_qlds = new QuanLyDauSach(); form_qlds.Refresh(); form_qlds.Refresh_DataGridView(); } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private void btn_add_Click(object sender, EventArgs e) { try { if (id != -1) { var dausach = _context.DauSach.Where(i => i.ID.Equals(id)).FirstOrDefault(); dausach.Ten = txt_name.Text; dausach.TheLoaiID = Convert.ToInt32(cbb_category.SelectedValue); dausach.TacGiaID = Convert.ToInt32(cbb_author.SelectedValue); dausach.TomTat = txt_summary.Text; dausach.TaiBan = Convert.ToInt32(txt_republish.Text); dausach.NhaSanXuatID = Convert.ToInt32(cbb_producer.SelectedValue); dausach.TinhTrang = Convert.ToByte(cbb_state.SelectedValue); _context.SaveChanges(); this.Close(); form_qlds = new QuanLyDauSach(); form_qlds.Refresh(); form_qlds.Refresh_DataGridView(); } } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private void btn_delete_Click(object sender, EventArgs e) { Int32 selectedRowCount = dataGridView1.Rows.GetRowCount(DataGridViewElementStates.Selected); if (selectedRowCount > 0) { for (int i = 0; i < selectedRowCount; i++) { //sb.Append("Row: "); //sb.Append(dataGridView1.SelectedRows[i].Index.ToString()); //sb.Append(Environment.NewLine); var index_row = dataGridView1.SelectedRows[i].Index; int dausach_id = Convert.ToInt32(dataGridView1.Rows[index_row].Cells[0].Value); var dausach = _context.DauSach.Where(o => o.ID.Equals(dausach_id)).FirstOrDefault(); dausach.TT_Xoa = 1; } _context.SaveChanges(); MessageBox.Show("Success...!!!"); //reload Refresh_DataGridView(); } }
private void btn_save_Click(object sender, EventArgs e) { try { var cuonsach_id = label_id.Text; int soluong_dausach = Convert.ToInt32(label_sumnumber.Text); if (cuonsach_id != "mới") { int id = Convert.ToInt32(cuonsach_id); var cuonsach = _context.CuonSach.Where(i => i.ID.Equals(id)).FirstOrDefault(); cuonsach.TinhTrang = Convert.ToByte(cbb_state.SelectedValue); } else { var cuonsach = new CuonSach(); cuonsach.MaVach = txt_key.Text; cuonsach.DauSachID = DauSachID; cuonsach.TinhTrang = Convert.ToByte(cbb_state.SelectedValue); _context.CuonSach.Add(cuonsach); var dausach = _context.DauSach.Where(i => i.ID.Equals(DauSachID)).FirstOrDefault(); dausach.SoLuongTong = dausach.SoLuongTong + 1; soluong_dausach = dausach.SoLuongTong; var phieunhap = new PhieuNhapDauSach(); phieunhap.DauSachID = dausach.ID; phieunhap.NgayNhap = DateTime.Now; phieunhap.SoLuongCuonSach = 1; _context.PhieuNhapDauSach.Add(phieunhap); } _context.SaveChanges(); label_sumnumber.Text = soluong_dausach.ToString(); Refresh_DataGridView(); label_id.Text = "mới"; txt_key.ReadOnly = false; txt_key.Text = null; //label_defaultMV.Text = "MV" + DauSachID.ToString(); } catch (Exception ex) { MessageBox.Show(ex.Message); } }
public ActionResult Create([Bind(Include = "ID,MaPhieuMuon,NgayMuon,DocGiaID,NhanVienID,NgayHetHan,TongSoLuongMuon,TinhTrang")] PhieuMuon phieuMuon) { if (ModelState.IsValid) { db.PhieuMuon.Add(phieuMuon); db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.DocGiaID = new SelectList(db.DocGia, "ID", "MaThe", phieuMuon.DocGiaID); ViewBag.NhanVienID = new SelectList(db.NhanVien, "ID", "MaNhanVien", phieuMuon.NhanVienID); return(View(phieuMuon)); }
private void btn_save_Click(object sender, EventArgs e) { //two ways, 1: insert, update if (!string.IsNullOrEmpty(dlg.FileName)) { var path = Path.GetDirectoryName(Path.GetDirectoryName(System.IO.Directory.GetCurrentDirectory())); int d = path.LastIndexOf("\\"); path = path.Substring(0, d); var des = @"\EF-Models\Images\"; string iName = dlg.SafeFileName; // <--- string filepath = dlg.FileName; // <--- if (File.Exists(path + des + iName)) { MessageBox.Show("Ten File da ton tai"); } else { try { if (label_id.Text == "Mới") { //get data from input DocGia docgia = new DocGia(); docgia.MaThe = "DG" + txt_key.Text; docgia.Ten = txt_name.Text; docgia.Email = txt_email.Text; docgia.DienThoai = txt_phone.Text; docgia.DiaChi = txt_address.Text; docgia.NgayCapThe = DateTime.Now.Date; docgia.NgayHetHan = dateTimePicker_dateend.Value; docgia.NamTotNghiep = Convert.ToInt32(txt_yeargraduate.Text); docgia.Loai = (byte)cbb_category.SelectedValue; docgia.SoSachConLai = Convert.ToInt32(txt_numberbooks.Text); docgia.TinhTrang = (byte)cbb_state.SelectedValue; docgia.HinhAnh = des + iName; _context.DocGia.Add(docgia); } else { int docgia_id = Convert.ToInt16(label_id.Text); var docgia = _context.DocGia.Where(i => i.ID.Equals(docgia_id)).FirstOrDefault(); docgia.MaThe = "DG" + txt_key.Text; docgia.Ten = txt_name.Text; docgia.Email = txt_email.Text; docgia.DienThoai = txt_phone.Text; docgia.DiaChi = txt_address.Text; docgia.NgayCapThe = DateTime.Now.Date; docgia.NgayHetHan = dateTimePicker_dateend.Value; docgia.NamTotNghiep = Convert.ToInt32(txt_yeargraduate.Text); docgia.Loai = (byte)cbb_category.SelectedValue; docgia.SoSachConLai = Convert.ToInt32(txt_numberbooks.Text); docgia.TinhTrang = (byte)cbb_state.SelectedValue; docgia.HinhAnh = des + iName; } _context.SaveChanges(); File.Copy(filepath, path + des + iName); // <--- } catch (Exception ex) { MessageBox.Show(ex.Message); } } } // 1 way: update else { if (label_id.Text != "Mới") { try { int docgia_id = Convert.ToInt16(label_id.Text); var docgia = _context.DocGia.Where(i => i.ID.Equals(docgia_id)).FirstOrDefault(); docgia.MaThe = "DG" + txt_key.Text; docgia.Ten = txt_name.Text; docgia.Email = txt_email.Text; docgia.DienThoai = txt_phone.Text; docgia.DiaChi = txt_address.Text; docgia.NgayCapThe = DateTime.Now.Date; docgia.NgayHetHan = dateTimePicker_dateend.Value; docgia.NamTotNghiep = Convert.ToInt32(txt_yeargraduate.Text); docgia.Loai = (byte)cbb_category.SelectedValue; docgia.SoSachConLai = Convert.ToInt32(txt_numberbooks.Text); docgia.TinhTrang = (byte)cbb_state.SelectedValue; _context.SaveChanges(); } catch (Exception ex) { MessageBox.Show(ex.Message); } } else { MessageBox.Show("Chon hinh anh cho Doc Gia"); } } Refresh_DataGridView(); }