private void grv_thietbi_Click(object sender, EventArgs e)
{
THIETBI tb = new THIETBI();
btn_xoa.Enabled = btn_sua.Enabled = btn_huy.Enabled = true;
btn_them.Enabled = false;
int position = gridView_ThietBi.FocusedRowHandle;
try
{
tb.TENTB = gridView_ThietBi.GetRowCellValue(position, "TENTB").ToString();
tb.MATHIETBI = gridView_ThietBi.GetRowCellValue(position, "MATHIETBI").ToString();
tb.GIADENBUHUHAI = decimal.Parse(gridView_ThietBi.GetRowCellValue(position, "GIADENBUHUHAI").ToString());
//tb.SOLUONG_PHANBO = Int32.Parse(gridView_ThietBi.GetRowCellValue(position,"SOLUONG_PHANBO").ToString());
//tb.SOLUONG_HUHONG = Int32.Parse(gridView_ThietBi.GetRowCellValue(position, "SOLUONG_HUHONG").ToString());
//tb.SOLUONG_TONKHO = Int32.Parse(gridView_ThietBi.GetRowCellValue(position, "SOLUONG_TONKHO").ToString());
txt_maloai.Text = tb.MATHIETBI.ToString();
txt_tenloai.Text = tb.TENTB.ToString();
txt_gia.Text = String.Format("{0:#,##0.##}", tb.GIADENBUHUHAI);
//txt_slphanbo.Text = tb.SOLUONG_PHANBO.ToString();
//txt_slhuhong.Text = tb.SOLUONG_HUHONG.ToString();
//txt_sltonkho.Text = tb.SOLUONG_TONKHO.ToString();
}
catch { }
}
private void button1_Click(object sender, EventArgs e)
{
using (QUANLYKHACHSANEntities db = new QUANLYKHACHSANEntities())
{
THIETBI tb = new THIETBI
{
MaTB = textBoxMaTB.Text,
TenTB = textBoxTenTB.Text,
GhiChu = textBoxGhiChu.Text,
};
if (db.THIETBIs.Select(p => p.MaTB).Contains(textBoxMaTB.Text))
{
MessageBox.Show("Mã thiết bị đã tồn tại");
return;
}
if (db.THIETBIs.Select(p => p.TenTB).Contains(textBoxTenTB.Text))
{
MessageBox.Show("Tên thiết bị đã tồn tại");
return;
}
db.THIETBIs.Add(tb);
MessageBox.Show("Thêm thiết bị thành công");
db.SaveChanges();
LoadTB(dataGridViewTBP);
}
}
public static void xoathietbi(int mathietbi)
{
THIETBI tb = new THIETBI();
tb.mathietbi = mathietbi;
thietbiDAL.xoathietbi(tb);
}
public async Task <ActionResult> DeleteConfirmed(int id)
{
THIETBI thietbi = await db.THIETBIs.FindAsync(id);
db.THIETBIs.Remove(thietbi);
await db.SaveChangesAsync();
return(RedirectToAction("Index"));
}
public int Update(THIETBI TB)
{
int count = 0;
using (SqlConnection connection = con())
{
count = connection.Execute("UPDATE THIETBI SET TenThietBi= @TenThietBi WHERE MaThietBi =@MaThietBi", TB);
}
return(count);
}
public THIETBI GetId(int maTB)
{
THIETBI tb = new THIETBI();
using (SqlConnection connection = con())
{
tb = (THIETBI)connection.Query <THIETBI>("select TOP 1 * from THIETBI where MaThietBi=" + maTB).FirstOrDefault();
return(tb);
}
}
//GET: /DieuChuyenThietBi/Details/5
public async Task <ActionResult> Details(string MATB_DC)
{
if (!String.IsNullOrEmpty(MATB_DC))
{
var temp = Int32.Parse(MATB_DC);
THIETBI tHIET_BI = await db.THIETBIs.FindAsync(temp);
return(View(tHIET_BI));
}
return(View());
}
public int ThemThietBi(THIETBI tb)
{
try
{
db.THIETBIs.Add(tb);
return(db.SaveChanges());
}
catch (Exception ex)
{
return(0);
}
}
public IActionResult Post(THIETBI tb)
{
if (unitOfWork.ThietBi.Add(tb) == 0)
{
return(StatusCode(StatusCodes.Status500InternalServerError, new Reponse {
Status = "error", Massage = "error"
}));
}
return(Ok(new Reponse {
Status = "succes", Massage = "succes"
}));
}
public bool xoaTB(THIETBI tb)
{
try
{
mydb.THIETBIs.Remove(tb);
mydb.SaveChanges();
return(true);
}
catch (Exception e)
{
return(false);
}
}
public bool xoaTB(THIETBI tb)
{
try
{
connectQLKS.THIETBIs.Remove(tb);
connectQLKS.SaveChanges();
return(true);
}
catch (Exception e)
{
return(false);
}
}
private void btnLuu_Click(object sender, EventArgs e)
{
int soLuong = 0;
if (!int.TryParse(txtSoLuong.Text, out soLuong))
{
MessageBoxEx.Show("Bạn nhập sai số lượng", "Thông báo");
txtSoLuong.BackColor = Color.Coral;
return;
}
THIETBI tb = new THIETBI();
tb.MaThietBi = txtMaTB.Text == "" ? 0 : int.Parse(txtMaTB.Text);
tb.TenThietBi = txtTenTB.Text.Trim();
tb.MaLoaiPhong = (int)cboLoaiPhong.SelectedValue;
tb.SoLuong = soLuong;
if (tb.MaThietBi == 0)
{
int ketQua = ThietBiDAO.Instance.ThemThietBi(tb);
if (ketQua > 0)
{
MessageBoxEx.Show("Thêm mới thiết bị thành công", "Thông báo");
txtSoLuong.BackColor = Color.White;
LoadThietBi();
}
else
{
MessageBoxEx.Show("Thêm mới thiết bị thất bại", "Thông báo");
txtSoLuong.BackColor = Color.White;
LoadThietBi();
}
}
else
{
int ketQua = ThietBiDAO.Instance.ChinhSuaThietBi(tb);
if (ketQua > 0)
{
MessageBoxEx.Show("Chỉnh sửa thiết bị thành công", "Thông báo");
txtSoLuong.BackColor = Color.White;
LoadThietBi();
}
else
{
MessageBoxEx.Show("Chỉnh sửa thiết bị thất bại", "Thông báo");
txtSoLuong.BackColor = Color.White;
LoadThietBi();
}
}
}
public async Task <ActionResult> Edit([Bind(Include = "MATB,TENTB,SO_SERIAL,GIA_TIEN,THOI_HAN_BAO_HANH,TINH_TRANG,MA_LOAITB,MANS_QL,MA_DV,MA_NHA_CUNG_CAP,NGAY_GD")] THIETBI thietbi)
{
if (ModelState.IsValid)
{
db.Entry(thietbi).State = EntityState.Modified;
await db.SaveChangesAsync();
return(RedirectToAction("Index"));
}
ViewBag.MA_DV = new SelectList(db.DON_VI, "MA_DON_VI", "TEN_DON_VI", thietbi.MA_DV);
ViewBag.MA_LOAITB = new SelectList(db.LOAI_THIETBI, "MA_LOAITB", "TEN_LOAI", thietbi.MA_LOAITB);
ViewBag.MA_NHA_CUNG_CAP = new SelectList(db.NHA_CUNG_CAP, "MA_NCC", "TEN_NCC", thietbi.MA_NCC);
return(View(thietbi));
}
private void buttonSua_Click(object sender, EventArgs e)
{
using (QUANLYKHACHSANEntities db = new QUANLYKHACHSANEntities())
{
THIETBI tb = db.THIETBIs.Find(Int32.Parse(textBoxMaTB.Text));
tb.TenTB = textBoxTenTB.Text;
tb.GhiChu = textBoxGhiChu.Text;
db.SaveChanges();
MessageBox.Show("Sửa thành công");
LoadTB(dataGridViewTBP);
}
}
// GET: /ThongKeThietBi/Details/5
public async Task <ActionResult> Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
THIETBI thietbi = await db.THIETBIs.FindAsync(id);
if (thietbi == null)
{
return(HttpNotFound());
}
return(View(thietbi));
}
// GET: /ThongKeThietBi/Edit/5
public async Task <ActionResult> Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
THIETBI thietbi = await db.THIETBIs.FindAsync(id);
if (thietbi == null)
{
return(HttpNotFound());
}
ViewBag.MA_DV = new SelectList(db.DON_VI, "MA_DON_VI", "TEN_DON_VI", thietbi.MA_DV);
ViewBag.MA_LOAITB = new SelectList(db.LOAI_THIETBI, "MA_LOAITB", "TEN_LOAI", thietbi.MA_LOAITB);
ViewBag.MA_NHA_CUNG_CAP = new SelectList(db.NHA_CUNG_CAP, "MA_NCC", "TEN_NCC", thietbi.MA_NCC);
return(View(thietbi));
}
public static void themthietbi(string Tenthietbi, int Dongia, string Thongsokythuat, DateTime Ngaysanxuat, DateTime Ngayduavaosudung, DateTime Ngaycapnhat, int Soluong, int Madonvitinh, int Maloai, int Maphongquantri, int Matinhtrang)
{
THIETBI tb = new THIETBI();
tb.tenthietbi = Tenthietbi;
tb.dongia = Dongia;
tb.thongsokythuat = Thongsokythuat;
tb.ngaysanxuat = Ngaysanxuat;
tb.ngayduavaosudung = Ngayduavaosudung;
tb.ngaycapnhat = Ngaycapnhat;
tb.soluong = Soluong;
tb.madonvitinh = Madonvitinh;
tb.maloai = Maloai;
tb.maphongquantri = Maphongquantri;
tb.matinhtrang = Matinhtrang;
thietbiDAL.themthietbi(tb);
}
public int Add(THIETBI tb)
{
int x;
using (SqlConnection connection = con())
{
connection.Open();
x = connection.Query <PHONGTRO>($"SELECT UPPER(TenThietBi) From THIETBI Where Replace(dbo.TRIM1(UPPER(dbo.ufn_removeMark(TenThietBi))),' ','')=REPLACE(dbo.TRIM1(UPPER(dbo.ufn_removeMark(@TenThietBi))), ' ', '')", tb, commandType: CommandType.Text).Count();
if (x <= 0)
{
connection.Execute("insert THIETBI values(@TenThietBi)", tb);
return(1);
}
return(0);
}
}
public int XoaThietBi(int maTB)
{
try
{
THIETBI tb = db.THIETBIs.SingleOrDefault(item => item.MaThietBi == maTB);
if (tb == null)
{
return(0);
}
else
{
db.THIETBIs.Remove(tb);
return(db.SaveChanges());
}
}
catch (Exception ex)
{
return(0);
}
}
public THIETBI THEM_THIETBI(FormCollection form)
{
var temp = form["MA_NHOMTB"].ToString();
var nHOMTB = db.NHOM_THIETBI.FirstOrDefault(a => a.MA_NHOMTB == temp).MA_NHOMTB;
var cOUNT = db.THIETBIs.Where(a => a.LOAI_THIETBI.NHOM_THIETBI.MA_NHOMTB == nHOMTB).Count() + 1;
THIETBI tHIETBI = new THIETBI();
tHIETBI.MATB = nHOMTB + "0" + cOUNT;
tHIETBI.TENTB = form["TENTB"];
tHIETBI.SO_SERIAL = form["SO_SERIAL"];
tHIETBI.MA_LOAITB = form["MA_LOAITB"];
temp = Session["TEN_DANG_NHAP"].ToString();
var nGUOI_DUNG = db.NGUOI_DUNG.Where(a => a.TEN_DANG_NHAP == temp).FirstOrDefault();
tHIETBI.MAND_QL = nGUOI_DUNG.MA_ND;
tHIETBI.MA_DV = nGUOI_DUNG.MA_DON_VI;
if (!String.IsNullOrEmpty(form["MA_NCC"]))
{
tHIETBI.MA_NCC = Int32.Parse(form["MA_NCC"]);
}
tHIETBI.TINH_TRANG = "Mới nhập";
tHIETBI.NGAY_MUA = DateTime.Parse(form["NGAY_MUA"].ToString());
tHIETBI.THOI_HAN_BAO_HANH = Int32.Parse(form["THOI_HAN_BAO_HANH"]);
tHIETBI.THOI_HAN_HET_BAO_HANH = DateTime.Parse(form["THOI_HAN_HET_BAO_HANH"].ToString());
tHIETBI.SO_LUONG = Int32.Parse(form["SO_LUONG"]);
if (!String.IsNullOrEmpty(form["GIA_TIEN"]))
{
tHIETBI.GIA_TIEN = Decimal.Parse(form["GIA_TIEN"].ToString());
}
else
{
tHIETBI.GIA_TIEN = 0;
}
return(tHIETBI);
}
public int ChinhSuaThietBi(THIETBI tb)
{
try
{
THIETBI tbDT = db.THIETBIs.SingleOrDefault(item => item.MaThietBi == tb.MaThietBi);
if (tbDT == null)
{
return(0);
}
else
{
tbDT.TenThietBi = tb.TenThietBi;
tbDT.MaLoaiPhong = tb.MaLoaiPhong;
tbDT.SoLuong = tb.SoLuong;
return(db.SaveChanges());
}
}
catch (Exception ex)
{
return(0);
}
}
public int addTB(THIETBI tb)
{
connectQLKS.THIETBIs.Add(tb);
connectQLKS.SaveChanges();
return(tb.SoLuong);
}
public async Task <ActionResult> Create(FormCollection form, string SAVE, HttpPostedFileBase HINH_ANH)
{
//, string hinh_anh
if (!String.IsNullOrEmpty(SAVE))
{
//Tạo thiết bị
var thiet_Bi = new THIETBI();
thiet_Bi.TENTB = form["TENTB"];
thiet_Bi.SO_SERIAL = form["SO_SERIAL"];
//thiet_Bi.GIA_TIEN = Decimal.Parse(form["GIA_TIEN"]);
thiet_Bi.THOI_HAN_BAO_HANH = form["THOI_HAN_BAO_HANH"];
thiet_Bi.TINH_TRANG = "Mới nhập";
var temp = form["MA_LOAITB"].ToString();
thiet_Bi.MA_LOAITB = (from p in db.LOAI_THIETBI
where p.TEN_LOAI == temp
select p.MA_LOAITB).FirstOrDefault();
if (!String.IsNullOrEmpty(form["MA_DON_VI"]))
{
temp = form["MA_DON_VI"].ToString();
thiet_Bi.MA_DV = (from p in db.DON_VI
where p.TEN_DON_VI == temp
select p.MA_DON_VI).First();
}
if (!String.IsNullOrEmpty(form["MA_NCC"]))
{
temp = form["MA_NCC"].ToString();
thiet_Bi.MA_NCC = (from p in db.NHA_CUNG_CAP
where p.TEN_NCC == temp
select p.MA_NCC).First();
}
//thiet_Bi.NGAY_GD = DateTime.Now;
if (ModelState.IsValid)
{
db.THIETBIs.Add(thiet_Bi);
await db.SaveChangesAsync();
}
//Tạo cấu hình
var cau_Hinh = new CAU_HINH();
temp = form["TENTB"].ToString();
cau_Hinh.MATB = 17;
//(from p in db.THIETBIs
// where p.TENTB == temp
// select p.MATB).First();
if (!String.IsNullOrEmpty(form["CPU"]))
{
temp = form["CPU"].ToString();
cau_Hinh.CPU = (from p in db.DM_CPU
where p.TEN_CPU == temp
select p.MA_CPU).First();
}
if (!String.IsNullOrEmpty(form["MAN_HINH"]))
{
temp = form["MAN_HINH"].ToString();
cau_Hinh.MAN_HINH = (from p in db.DM_MAN_HINH
where p.TEN_MAN_HINH == temp
select p.MA_MAN_HINH).First();
}
if (!String.IsNullOrEmpty(form["RAM"]))
{
temp = form["RAM"].ToString();
cau_Hinh.RAM = (from p in db.DM_RAM
where p.TEN_RAM == temp
select p.MA_RAM).First();
}
if (!String.IsNullOrEmpty(form["HDH"]))
{
temp = form["HDH"].ToString();
cau_Hinh.HE_DIEU_HANH = (from p in db.DM_HDH
where p.TEN_HDH == temp
select p.MA_HDH).First();
}
if (!String.IsNullOrEmpty(form["O_CUNG"]))
{
temp = form["O_CUNG"].ToString();
cau_Hinh.O_CUNG = (from p in db.DM_O_CUNG
where p.TEN_O_CUNG == temp
select p.MA_O_CUNG).First();
}
if (!String.IsNullOrEmpty(form["VGA"]))
{
temp = form["VGA"].ToString();
cau_Hinh.VGA = (from p in db.DM_VGA
where p.TEN_VGA == temp
select p.MA_VGA).First();
}
if (ModelState.IsValid)
{
db.CAU_HINH.Add(cau_Hinh);
await db.SaveChangesAsync();
}
//Tạo nhập kho
var nhap_Kho_Create = new NHAP_KHO();
temp = form["TENTB"].ToString();
nhap_Kho_Create.MATB = (from p in db.THIETBIs
where p.TENTB == temp
select p.MATB).First();
if (!String.IsNullOrEmpty(form["MA_DON_VI"]))
{
temp = form["MA_DON_VI"].ToString();
nhap_Kho_Create.MADV_NHAP = (from p in db.DON_VI
where p.TEN_DON_VI == temp
select p.MA_DON_VI).FirstOrDefault();
}
nhap_Kho_Create.NGAY_NHAP = DateTime.Now;
if (ModelState.IsValid)
{
db.NHAP_KHO.Add(nhap_Kho_Create);
await db.SaveChangesAsync();
}
//Tạo hình ảnh
if (!String.IsNullOrEmpty(HINH_ANH.ToString()))
{
var hinh_Anh = new HINH_ANH();
temp = form["TENTB"].ToString();
hinh_Anh.MATB = (from p in db.THIETBIs
where p.TENTB == temp
select p.MATB).First();
string ImageName = System.IO.Path.GetFileName(HINH_ANH.FileName);
string physicalPath = Server.MapPath("~/Images/" + ImageName);
// save image in folder
HINH_ANH.SaveAs(physicalPath);
hinh_Anh.HINH1 = ImageName;
if (ModelState.IsValid)
{
db.HINH_ANH.Add(hinh_Anh);
await db.SaveChangesAsync();
}
}
}
//else if (!String.IsNullOrEmpty(REFESH))
//{
// return RedirectToAction("Index");
//}
return(RedirectToAction("Index"));
//ViewBag.MADV_NHAP = new SelectList(db.DON_VI, "MA_DON_VI", "TEN_DON_VI", nhap_kho.MADV_NHAP);
//ViewBag.MAND_NHAP = new SelectList(db.NGUOI_DUNG, "MA_ND", "TEN_ND", nhap_kho.MANS_NHAP);
//ViewBag.MATB = new SelectList(db.THIETBIs, "MATB", "TENTB", nhap_kho.MATB);
//return View(nhap_kho);
}
public int addTB(THIETBI tb)
{
mydb.THIETBIs.Add(tb);
mydb.SaveChanges();
return(tb.SoLuong);
}
public IActionResult Put(THIETBI tb)
{
unitOfWork.ThietBi.Update(tb);
return(Ok());
}
//Sửa
public bool sua_ThietBi(THIETBI pThietBi)
{
return(thietbi.sua_ThietBi(pThietBi));
}
//Thêm
public bool them_ThietBi(THIETBI pThietBi)
{
return(thietbi.them_ThietBi(pThietBi));
}
private void btn_luu_Click(object sender, EventArgs e)
{
THIETBI tb = new THIETBI();
if (btn_them.Enabled == true)
{
tb.MATHIETBI = txt_maloai.Text;
tb.TENTB = txt_tenloai.Text;
tb.GIADENBUHUHAI = decimal.Parse(txt_gia.Text);
//tb.SOLUONG_PHANBO =Convert.ToInt32(txt_slphanbo.Text);
//tb.SOLUONG_HUHONG = Convert.ToInt32(txt_slhuhong.Text);
//tb.SOLUONG_TONKHO = Convert.ToInt32(txt_sltonkho.Text);
if (txt_maloai.Text == string.Empty && txt_tenloai.Text == string.Empty &&
txt_gia.Text == string.Empty)
{
MessageBox.Show("không được để trống");
return;
}
//kiểm tra khóa chính
if (thietbi.ktkc_ThietBi(tb.MATHIETBI) == true)
{
MessageBox.Show("TRùng khóa chính");
return;
}
if (thietbi.them_ThietBi(tb) == true)
{
grv_thietbi.DataSource = thietbi.loadBang_TB();
MessageBox.Show("Thành công");
}
else
{
MessageBox.Show("Thất bại");
}
btn_sua.Enabled = btn_luu.Enabled = btn_them.Enabled = false;
}
if (btn_sua.Enabled == true)
{
try
{
if (txt_tenloai.Text == string.Empty)
{
MessageBox.Show("Tên thiết bị không được để trống");
return;
}
if (txt_gia.Text == string.Empty)
{
MessageBox.Show("Giá thiết bị không được để trống");
return;
}
tb.MATHIETBI = txt_maloai.Text;
tb.TENTB = txt_tenloai.Text;
tb.GIADENBUHUHAI = decimal.Parse(txt_gia.Text);
//tb.SOLUONG_PHANBO =Convert.ToInt32(txt_slphanbo.Text);
//tb.SOLUONG_HUHONG = Convert.ToInt32(txt_slhuhong.Text);
//tb.SOLUONG_TONKHO = Convert.ToInt32(txt_sltonkho.Text);
if (thietbi.sua_ThietBi(tb) == true)
{
grv_thietbi.DataSource = thietbi.loadBang_TB();
MessageBox.Show("Thành công");
}
}
catch
{
MessageBox.Show("thất bại");
}
}
btn_sua.Enabled = btn_xoa.Enabled = btn_huy.Enabled = btn_luu.Enabled =
txt_maloai.Enabled = txt_tenloai.Enabled = txt_gia.Enabled = false;
btn_them.Enabled = true;
}
