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