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