public bool updateQuyenTruycap(BKIT.Entities.QuyenTruycap objQuyenTruycap) { Database db = DatabaseFactory.CreateDatabase(); string sqlCommand = "UPDATE QuyenTruycap SET Ngaythietlap = @ngaythietlap, TenLoaiNV = @tenloainv, Vanhanh = @vanhanh, HoadonNhap = @hoadonnhap, Setting = @setting, Nhanvien = @nhanvien, HoadonxuatSP = @hoadonxuatsp, Sanpham = @sanpham, Phong = @phong, Report = @report, Khachhang = @khachhang, Khuyenmai = @khuyenmai, Tonkho = @tonkho " + "WHERE IDQuyentruycap = @idquyentruycap"; DbCommand dbCommand = db.GetSqlStringCommand(sqlCommand); try { db.AddInParameter(dbCommand, "ngaythietlap", DbType.DateTime, objQuyenTruycap.Ngaythietlap); db.AddInParameter(dbCommand, "tenloainv", DbType.String, objQuyenTruycap.TenLoaiNV); db.AddInParameter(dbCommand, "vanhanh", DbType.Int32, objQuyenTruycap.Vanhanh); db.AddInParameter(dbCommand, "hoadonnhap", DbType.Int32, objQuyenTruycap.HoadonNhap); db.AddInParameter(dbCommand, "setting", DbType.Int32, objQuyenTruycap.Setting); db.AddInParameter(dbCommand, "nhanvien", DbType.Int32, objQuyenTruycap.Nhanvien); db.AddInParameter(dbCommand, "hoadonxuatsp", DbType.Int32, objQuyenTruycap.HoadonxuatSP); db.AddInParameter(dbCommand, "sanpham", DbType.Int32, objQuyenTruycap.Sanpham); db.AddInParameter(dbCommand, "phong", DbType.Int32, objQuyenTruycap.Phong); db.AddInParameter(dbCommand, "report", DbType.Int32, objQuyenTruycap.Report); db.AddInParameter(dbCommand, "khachhang", DbType.Int32, objQuyenTruycap.Khachhang); db.AddInParameter(dbCommand, "khuyenmai", DbType.Int32, objQuyenTruycap.Khuyenmai); db.AddInParameter(dbCommand, "tonkho", DbType.Int32, objQuyenTruycap.Tonkho); db.AddInParameter(dbCommand, "idquyentruycap", DbType.Int32, objQuyenTruycap.IDQuyentruycap); db.ExecuteNonQuery(dbCommand); dbCommand.Connection.Close(); return(true); } catch { return(false); } }
public int insertQuyenTruycap(BKIT.Entities.QuyenTruycap objQuyenTruycap) { Database db = DatabaseFactory.CreateDatabase(); string sqlCommand = "INSERT INTO QuyenTruycap(IDQuyentruycap,Ngaythietlap,TenLoaiNV,Vanhanh,HoadonNhap,Setting,Nhanvien,HoadonxuatSP,Sanpham,Phong,Report,Khachhang,Khuyenmai,Tonkho) " + "VALUES (@idquyentruycap,@ngaythietlap,@tenloainv,@vanhanh,@hoadonnhap,@setting,@nhanvien,@hoadonxuatsp,@sanpham,@phong,@report,@khachhang,@khuyenmai,@tonkho)"; DbCommand dbCommand = db.GetSqlStringCommand(sqlCommand); try { int ID = GetNextAVailableID(); objQuyenTruycap.IDQuyentruycap = ID; db.AddInParameter(dbCommand, "idquyentruycap", DbType.Int32, objQuyenTruycap.IDQuyentruycap); db.AddInParameter(dbCommand, "ngaythietlap", DbType.DateTime, objQuyenTruycap.Ngaythietlap); db.AddInParameter(dbCommand, "tenloainv", DbType.String, objQuyenTruycap.TenLoaiNV); db.AddInParameter(dbCommand, "vanhanh", DbType.Int32, objQuyenTruycap.Vanhanh); db.AddInParameter(dbCommand, "hoadonnhap", DbType.Int32, objQuyenTruycap.HoadonNhap); db.AddInParameter(dbCommand, "setting", DbType.Int32, objQuyenTruycap.Setting); db.AddInParameter(dbCommand, "nhanvien", DbType.Int32, objQuyenTruycap.Nhanvien); db.AddInParameter(dbCommand, "hoadonxuatsp", DbType.Int32, objQuyenTruycap.HoadonxuatSP); db.AddInParameter(dbCommand, "sanpham", DbType.Int32, objQuyenTruycap.Sanpham); db.AddInParameter(dbCommand, "phong", DbType.Int32, objQuyenTruycap.Phong); db.AddInParameter(dbCommand, "report", DbType.Int32, objQuyenTruycap.Report); db.AddInParameter(dbCommand, "khachhang", DbType.Int32, objQuyenTruycap.Khachhang); db.AddInParameter(dbCommand, "khuyenmai", DbType.Int32, objQuyenTruycap.Khuyenmai); db.AddInParameter(dbCommand, "tonkho", DbType.Int32, objQuyenTruycap.Tonkho); db.ExecuteNonQuery(dbCommand); dbCommand.Connection.Close(); return(ID); } catch { dbCommand.Connection.Close(); return(-1); } }
public bool deleteQuyenTruycap(BKIT.Entities.QuyenTruycap objQuyenTruycap) { Database db = DatabaseFactory.CreateDatabase(); string sqlCommand = "DELETE FROM QuyenTruycap WHERE IDQuyentruycap = @idquyentruycap"; DbCommand dbCommand = db.GetSqlStringCommand(sqlCommand); try { db.AddInParameter(dbCommand, "idquyentruycap", DbType.Int32, objQuyenTruycap.IDQuyentruycap); db.ExecuteNonQuery(dbCommand); dbCommand.Connection.Close(); return(true); } catch { return(false); } }
private void UnLoadForm() { DataAccess da = new DataAccess(); QuyenTruycap objQuyenTruycap = new QuyenTruycap(); DataSet ds = null; switch (Program.userLevel) { case Level.Admin: //Do nothing break; case Level.User: //UnLoad all admin forms ds = new DataAccess().getQuyenTruycapByDate("", "Người dùng"); break; case Level.Guest: //UnLoad all admin and User forms ds = new DataAccess().getQuyenTruycapByDate("", "Khách"); //foreach (Form child in MdiChildren) //{ // if (child.Text == "Nhân viên" || child.Text == "Thống kê Tồn kho" // || child.Text == "Thống kê" || child.Text == "Quản lý Hóa đơn" // || child.Text == "Thêm Hóa đơn nhập" || child.Text == "Hóa đơn nhập hàng" // || child.Text == "Quản lý Phòng" || child.Text == "Quản lý Sản phẩm") // { // child.Close(); // } //} break; default: break; } if (ds != null && ds.Tables[0].Rows.Count > 0) { objQuyenTruycap.Ngaythietlap = Convert.ToDateTime(ds.Tables[0].Rows[0]["Ngaythietlap"]); objQuyenTruycap.TenLoaiNV = Convert.ToString(ds.Tables[0].Rows[0]["TenLoaiNV"]); objQuyenTruycap.Vanhanh = Convert.ToInt32(ds.Tables[0].Rows[0]["Vanhanh"]); objQuyenTruycap.HoadonNhap = Convert.ToInt32(ds.Tables[0].Rows[0]["HoadonNhap"]); objQuyenTruycap.Setting = Convert.ToInt32(ds.Tables[0].Rows[0]["Setting"]); objQuyenTruycap.Nhanvien = Convert.ToInt32(ds.Tables[0].Rows[0]["Nhanvien"]); objQuyenTruycap.HoadonxuatSP = Convert.ToInt32(ds.Tables[0].Rows[0]["HoadonxuatSP"]); objQuyenTruycap.Sanpham = Convert.ToInt32(ds.Tables[0].Rows[0]["Sanpham"]); objQuyenTruycap.Phong = Convert.ToInt32(ds.Tables[0].Rows[0]["Phong"]); objQuyenTruycap.Report = Convert.ToInt32(ds.Tables[0].Rows[0]["Report"]); objQuyenTruycap.Khachhang = Convert.ToInt32(ds.Tables[0].Rows[0]["Khachhang"]); objQuyenTruycap.Khuyenmai = Convert.ToInt32(ds.Tables[0].Rows[0]["Khuyenmai"]); objQuyenTruycap.Tonkho = Convert.ToInt32(ds.Tables[0].Rows[0]["Tonkho"]); foreach (Form child in MdiChildren) { if (child.Text == "Quản lý nhân viên" && objQuyenTruycap.Nhanvien == 0) child.Close(); if (child.Text == "Thống kê Tồn kho" && objQuyenTruycap.Tonkho == 0) child.Close(); if (child.Text == "Thống kê" && objQuyenTruycap.Report == 0) child.Close(); if (child.Text == "Quản lý Hóa đơn" && objQuyenTruycap.Vanhanh == 0)//Van hanh child.Close(); if (child.Text == "Thêm Hóa đơn nhập" && objQuyenTruycap.HoadonNhap == 0) child.Close(); if (child.Text == "Hóa đơn nhập hàng" && objQuyenTruycap.HoadonNhap == 0) child.Close(); if (child.Text == "Quản lý Phòng" && objQuyenTruycap.Phong == 0) child.Close(); if (child.Text == "Quản lý Sản phẩm" && objQuyenTruycap.Sanpham == 0) child.Close(); if (child.Text == "Cài đặt" && objQuyenTruycap.Setting == 0) child.Close(); if (child.Text == "Biểu đồ" && objQuyenTruycap.HoadonxuatSP == 0) child.Close(); } } }
private void chkListBoxPermission_Update(QuyenTruycap quyentruycap) { enableItemCheckEvent = false; if (quyentruycap.Vanhanh == 1) chkListBoxPermission.SetItemCheckState(Convert.ToInt32(Quyen.Vanhanh), CheckState.Checked); else chkListBoxPermission.SetItemCheckState(Convert.ToInt32(Quyen.Vanhanh), CheckState.Unchecked); if (quyentruycap.HoadonNhap == 1) chkListBoxPermission.SetItemCheckState(Convert.ToInt32(Quyen.Hoadonnhap), CheckState.Checked); else chkListBoxPermission.SetItemCheckState(Convert.ToInt32(Quyen.Hoadonnhap), CheckState.Unchecked); if (quyentruycap.Setting == 1) chkListBoxPermission.SetItemCheckState(Convert.ToInt32(Quyen.Caidat), CheckState.Checked); else chkListBoxPermission.SetItemCheckState(Convert.ToInt32(Quyen.Caidat), CheckState.Unchecked); if (quyentruycap.Nhanvien == 1) chkListBoxPermission.SetItemCheckState(Convert.ToInt32(Quyen.Nhanvien), CheckState.Checked); else chkListBoxPermission.SetItemCheckState(Convert.ToInt32(Quyen.Nhanvien), CheckState.Unchecked); if (quyentruycap.HoadonxuatSP == 1) chkListBoxPermission.SetItemCheckState(Convert.ToInt32(Quyen.Hoadonxuat), CheckState.Checked); else chkListBoxPermission.SetItemCheckState(Convert.ToInt32(Quyen.Hoadonxuat), CheckState.Unchecked); if (quyentruycap.Sanpham == 1) chkListBoxPermission.SetItemCheckState(Convert.ToInt32(Quyen.Sanpham), CheckState.Checked); else chkListBoxPermission.SetItemCheckState(Convert.ToInt32(Quyen.Sanpham), CheckState.Unchecked); if (quyentruycap.Phong == 1) chkListBoxPermission.SetItemCheckState(Convert.ToInt32(Quyen.Phong), CheckState.Checked); else chkListBoxPermission.SetItemCheckState(Convert.ToInt32(Quyen.Phong), CheckState.Unchecked); if (quyentruycap.Report == 1) chkListBoxPermission.SetItemCheckState(Convert.ToInt32(Quyen.Baocao), CheckState.Checked); else chkListBoxPermission.SetItemCheckState(Convert.ToInt32(Quyen.Baocao), CheckState.Unchecked); if (quyentruycap.Khachhang == 1) chkListBoxPermission.SetItemCheckState(Convert.ToInt32(Quyen.Khachhang), CheckState.Checked); else chkListBoxPermission.SetItemCheckState(Convert.ToInt32(Quyen.Khachhang), CheckState.Unchecked); if (quyentruycap.Khuyenmai == 1) chkListBoxPermission.SetItemCheckState(Convert.ToInt32(Quyen.Khuyenmai), CheckState.Checked); else chkListBoxPermission.SetItemCheckState(Convert.ToInt32(Quyen.Khuyenmai), CheckState.Unchecked); if (quyentruycap.Tonkho == 1) chkListBoxPermission.SetItemCheckState(Convert.ToInt32(Quyen.Tonkho), CheckState.Checked); else chkListBoxPermission.SetItemCheckState(Convert.ToInt32(Quyen.Tonkho), CheckState.Unchecked); enableItemCheckEvent = true; }
private void setAuthority() { if (Program.isLogin) { this.btnLogIn.Enabled = false; this.btnLogOut.Enabled = true; } else { this.btnLogIn.Enabled = true; this.btnLogOut.Enabled = false; } DataAccess da = new DataAccess(); QuyenTruycap objQuyenTruycap = new QuyenTruycap(); DataSet ds = null; this.btnProduct.Enabled = false; this.btnEmployee.Enabled = false; this.btnRoom.Enabled = false; this.btnInvoice.Enabled = false; this.btnAddInvoice.Enabled = false; this.btnTonKho.Enabled = false; this.btnReceipt.Enabled = false; this.btnReport.Enabled = false; this.btnChart.Enabled = false; this.btnSetting.Enabled = false; if (Program.userLevel == Level.Admin) { ds = new DataAccess().getQuyenTruycapByDate("", "Quản lý"); } else if (Program.userLevel == Level.User) { ds = new DataAccess().getQuyenTruycapByDate("", "Người dùng"); } else if (Program.userLevel == Level.Guest) { ds = new DataAccess().getQuyenTruycapByDate("", "Khách"); } if (ds != null && ds.Tables[0].Rows.Count > 0) { objQuyenTruycap.Ngaythietlap = Convert.ToDateTime(ds.Tables[0].Rows[0]["Ngaythietlap"]); objQuyenTruycap.TenLoaiNV = Convert.ToString(ds.Tables[0].Rows[0]["TenLoaiNV"]); objQuyenTruycap.Vanhanh = Convert.ToInt32(ds.Tables[0].Rows[0]["Vanhanh"]); objQuyenTruycap.HoadonNhap = Convert.ToInt32(ds.Tables[0].Rows[0]["HoadonNhap"]); objQuyenTruycap.Setting = Convert.ToInt32(ds.Tables[0].Rows[0]["Setting"]); objQuyenTruycap.Nhanvien = Convert.ToInt32(ds.Tables[0].Rows[0]["Nhanvien"]); objQuyenTruycap.HoadonxuatSP = Convert.ToInt32(ds.Tables[0].Rows[0]["HoadonxuatSP"]); objQuyenTruycap.Sanpham = Convert.ToInt32(ds.Tables[0].Rows[0]["Sanpham"]); objQuyenTruycap.Phong = Convert.ToInt32(ds.Tables[0].Rows[0]["Phong"]); objQuyenTruycap.Report = Convert.ToInt32(ds.Tables[0].Rows[0]["Report"]); objQuyenTruycap.Khachhang = Convert.ToInt32(ds.Tables[0].Rows[0]["Khachhang"]); objQuyenTruycap.Khuyenmai = Convert.ToInt32(ds.Tables[0].Rows[0]["Khuyenmai"]); objQuyenTruycap.Tonkho = Convert.ToInt32(ds.Tables[0].Rows[0]["Tonkho"]); this.btnEmployee.Enabled = (objQuyenTruycap.Nhanvien == 1); this.btnTonKho.Enabled = (objQuyenTruycap.Tonkho == 1); this.btnReport.Enabled = (objQuyenTruycap.Report == 1); this.btnReceipt.Enabled = (objQuyenTruycap.Vanhanh == 1);//Van hanh this.btnAddInvoice.Enabled = (objQuyenTruycap.HoadonNhap == 1); this.btnInvoice.Enabled = (objQuyenTruycap.HoadonNhap == 1); this.btnRoom.Enabled = (objQuyenTruycap.Phong == 1); this.btnProduct.Enabled = (objQuyenTruycap.Sanpham == 1); this.btnSetting.Enabled = (objQuyenTruycap.Setting == 1); this.btnChart.Enabled = (objQuyenTruycap.HoadonxuatSP == 1); } }
public QuyenTruycap getQuyenTruycapByID(int p) { QuyenTruycap quyentruycap = null; Database db = DatabaseFactory.CreateDatabase(); string sqlCommand = ""; sqlCommand = "SELECT * FROM QuyenTruycap Where QuyenTruycap.IDQuyenTruycap = " + p.ToString(); try { DbCommand dbCommand = db.GetSqlStringCommand(sqlCommand); using (IDataReader dataReader = db.ExecuteReader(dbCommand)) { while (dataReader.Read()) { quyentruycap = new QuyenTruycap(); quyentruycap = (QuyenTruycap)getQuyenTruycap(dataReader); } dataReader.Close(); dbCommand.Connection.Close(); } } catch { return null; } return quyentruycap; }
private QuyenTruycap getQuyenTruycap(IDataReader dataReader) { QuyenTruycap quyentruycap = new QuyenTruycap(); try { if (!DBNull.Value.Equals(dataReader["IDQuyentruycap"])) quyentruycap.IDQuyentruycap = Convert.ToInt32(dataReader["IDQuyentruycap"].ToString().Trim()); else quyentruycap.IDQuyentruycap = 0; if (!DBNull.Value.Equals(dataReader["Ngaythietlap"])) quyentruycap.Ngaythietlap = Convert.ToDateTime(dataReader["Ngaythietlap"].ToString().Trim()); else quyentruycap.Ngaythietlap = DateTime.Now; if (!DBNull.Value.Equals(dataReader["TenLoaiNV"])) quyentruycap.TenLoaiNV = dataReader["TenLoaiNV"].ToString().Trim(); else quyentruycap.TenLoaiNV = ""; if (!DBNull.Value.Equals(dataReader["Vanhanh"])) quyentruycap.Vanhanh = Convert.ToInt32(dataReader["Vanhanh"].ToString().Trim()); else quyentruycap.Vanhanh = 0; if (!DBNull.Value.Equals(dataReader["Hoadonnhap"])) quyentruycap.HoadonNhap = Convert.ToInt32(dataReader["Hoadonnhap"].ToString().Trim()); else quyentruycap.HoadonNhap = 0; if (!DBNull.Value.Equals(dataReader["Setting"])) quyentruycap.Setting = Convert.ToInt32(dataReader["Setting"].ToString().Trim()); else quyentruycap.Setting = 0; if (!DBNull.Value.Equals(dataReader["Nhanvien"])) quyentruycap.Nhanvien = Convert.ToInt32(dataReader["Nhanvien"].ToString().Trim()); else quyentruycap.Nhanvien = 0; if (!DBNull.Value.Equals(dataReader["HoadonxuatSP"])) quyentruycap.HoadonxuatSP = Convert.ToInt32(dataReader["HoadonxuatSP"].ToString().Trim()); else quyentruycap.HoadonxuatSP = 0; if (!DBNull.Value.Equals(dataReader["Sanpham"])) quyentruycap.Sanpham = Convert.ToInt32(dataReader["Sanpham"].ToString().Trim()); else quyentruycap.Sanpham = 0; if (!DBNull.Value.Equals(dataReader["Phong"])) quyentruycap.Phong = Convert.ToInt32(dataReader["Phong"].ToString().Trim()); else quyentruycap.Phong = 0; if (!DBNull.Value.Equals(dataReader["Report"])) quyentruycap.Report = Convert.ToInt32(dataReader["Report"].ToString().Trim()); else quyentruycap.Report = 0; if (!DBNull.Value.Equals(dataReader["Khachhang"])) quyentruycap.Khachhang = Convert.ToInt32(dataReader["Khachhang"].ToString().Trim()); else quyentruycap.Khachhang = 0; if (!DBNull.Value.Equals(dataReader["Khuyenmai"])) quyentruycap.Khuyenmai = Convert.ToInt32(dataReader["Khuyenmai"].ToString().Trim()); else quyentruycap.Khuyenmai = 0; if (!DBNull.Value.Equals(dataReader["Tonkho"])) quyentruycap.Tonkho = Convert.ToInt32(dataReader["Tonkho"].ToString().Trim()); else quyentruycap.Tonkho = 0; } catch (Exception e) { Console.WriteLine("Error occurred in getPerson function: -" + e.ToString()); } return quyentruycap; }
public bool updateQuyenTruycap(QuyenTruycap objQuyenTruycap) { return new QuyenTruycapService().updateQuyenTruycap(objQuyenTruycap); }
public int insertQuyenTruycap(QuyenTruycap objQuyenTruycap) { return new QuyenTruycapService().insertQuyenTruycap(objQuyenTruycap); }
public bool deleteQuyenTruycap(QuyenTruycap objQuyenTruycap) { return new QuyenTruycapService().deleteQuyenTruycap(objQuyenTruycap); }