public List <HT_UserInfo> GetList(HT_UserInfo pHT_UserInfo)
{
List <HT_UserInfo> oHT_UserInfoList = new List <HT_UserInfo>();
DataTable dtb = Get(pHT_UserInfo);
if (dtb != null)
{
for (int i = 0; i < dtb.Rows.Count; i++)
{
oHT_UserInfo = new HT_UserInfo();
oHT_UserInfo.HT_UserID = int.Parse(dtb.Rows[i]["HT_UserID"].ToString());
oHT_UserInfo.UserName = dtb.Rows[i]["UserName"].ToString();
oHT_UserInfo.Password = dtb.Rows[i]["Password"].ToString();
oHT_UserInfo.FullName = dtb.Rows[i]["FullName"].ToString();
oHT_UserInfo.IDNS_GiaoVien = "" + dtb.Rows[i]["IDNS_GiaoVien"] == "" ? 0 : int.Parse("" + dtb.Rows[i]["IDNS_GiaoVien"]);
oHT_UserInfo.IDHT_UserGroup = "" + dtb.Rows[i]["IDHT_UserGroup"] == "" ? 0 : int.Parse("" + dtb.Rows[i]["IDHT_UserGroup"]);
oHT_UserInfo.Active = bool.Parse(dtb.Rows[i]["Active"].ToString());
oHT_UserInfo.IpAddress = dtb.Rows[i]["IpAddress"].ToString();
oHT_UserInfo.MacAddress = dtb.Rows[i]["MacAddress"].ToString();
oHT_UserInfoList.Add(oHT_UserInfo);
}
}
return(oHT_UserInfoList);
}
public void Delete(HT_UserInfo pHT_UserInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@HT_UserID", SqlDbType.Int, pHT_UserInfo.HT_UserID));
RunProcedure("sp_HT_User_Delete", colParam);
}
public DataTable Get(HT_UserInfo pHT_UserInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@HT_UserID", SqlDbType.Int, pHT_UserInfo.HT_UserID));
return(RunProcedureGet("sp_HT_User_Get", colParam));
}
public int Add(HT_UserInfo pHT_UserInfo)
{
int ID = 0;
ID = oDHT_User.Add(pHT_UserInfo);
mErrorMessage = oDHT_User.ErrorMessages;
mErrorNumber = oDHT_User.ErrorNumber;
return(ID);
}
public frmQuanLyNguoiDung()
{
InitializeComponent();
oBNS_GiaoVien = new cBNS_GiaoVien();
pHT_UserInfo = new HT_UserInfo();
oBHT_User = new cBHT_User();
pHT_ChucNangInfo = new HT_ChucNangInfo();
oBHT_ChucNang = new cBHT_ChucNang();
}
public void ToDataRow(HT_UserInfo pHT_UserInfo, ref DataRow dr)
{
dr[pHT_UserInfo.strHT_UserID] = pHT_UserInfo.HT_UserID;
dr[pHT_UserInfo.strUserName] = pHT_UserInfo.UserName;
dr[pHT_UserInfo.strPassword] = pHT_UserInfo.Password;
dr[pHT_UserInfo.strFullName] = pHT_UserInfo.FullName;
dr[pHT_UserInfo.strIDNS_GiaoVien] = pHT_UserInfo.IDNS_GiaoVien;
dr[pHT_UserInfo.strIDHT_UserGroup] = pHT_UserInfo.IDHT_UserGroup;
dr[pHT_UserInfo.strActive] = pHT_UserInfo.Active;
dr[pHT_UserInfo.strIpAddress] = pHT_UserInfo.IpAddress;
dr[pHT_UserInfo.strMacAddress] = pHT_UserInfo.MacAddress;
}
public frmTraCuuLog()
{
InitializeComponent();
oBPhanHe = new cBHT_PhanHe();
pPhanHeInfo = new HT_PhanHeInfo();
oBChucNang = new cBHT_ChucNang();
pChucNangInfo = new HT_ChucNangInfo();
pHT_LogInfo = new HT_LogInfo();
oBHT_Log = new cBHT_Log();
pHT_UserInfo = new HT_UserInfo();
oBHT_User = new cBHT_User();
}
public void Update(HT_UserInfo pHT_UserInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@UserName", SqlDbType.NVarChar, pHT_UserInfo.UserName));
colParam.Add(CreateParam("@Password", SqlDbType.NVarChar, pHT_UserInfo.Password));
colParam.Add(CreateParam("@FullName", SqlDbType.NVarChar, pHT_UserInfo.FullName));
colParam.Add(CreateParam("@IDNS_GiaoVien", SqlDbType.Int, pHT_UserInfo.IDNS_GiaoVien));
colParam.Add(CreateParam("@IDHT_UserGroup", SqlDbType.Int, pHT_UserInfo.IDHT_UserGroup));
colParam.Add(CreateParam("@Active", SqlDbType.Bit, pHT_UserInfo.Active));
colParam.Add(CreateParam("@IpAddress", SqlDbType.NVarChar, pHT_UserInfo.IpAddress));
colParam.Add(CreateParam("@MacAddress", SqlDbType.NVarChar, pHT_UserInfo.MacAddress));
colParam.Add(CreateParam("@HT_UserID", SqlDbType.Int, pHT_UserInfo.HT_UserID));
RunProcedure("sp_HT_User_Update", colParam);
}
public int Add(HT_UserInfo pHT_UserInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@UserName", SqlDbType.NVarChar, pHT_UserInfo.UserName));
colParam.Add(CreateParam("@Password", SqlDbType.NVarChar, pHT_UserInfo.Password));
colParam.Add(CreateParam("@FullName", SqlDbType.NVarChar, pHT_UserInfo.FullName));
colParam.Add(CreateParam("@IDNS_GiaoVien", SqlDbType.Int, pHT_UserInfo.IDNS_GiaoVien));
colParam.Add(CreateParam("@IDHT_UserGroup", SqlDbType.Int, pHT_UserInfo.IDHT_UserGroup));
colParam.Add(CreateParam("@Active", SqlDbType.Bit, pHT_UserInfo.Active));
colParam.Add(CreateParam("@IpAddress", SqlDbType.NVarChar, pHT_UserInfo.IpAddress));
colParam.Add(CreateParam("@MacAddress", SqlDbType.NVarChar, pHT_UserInfo.MacAddress));
colParam.Add(CreateParamOut("@ID", SqlDbType.Int));
return((int)RunProcedureOut("sp_HT_User_Add", colParam));
}
public void ToInfo(ref HT_UserInfo pHT_UserInfo, DataRow dr)
{
pHT_UserInfo.HT_UserID = int.Parse(dr[pHT_UserInfo.strHT_UserID].ToString());
pHT_UserInfo.UserName = dr[pHT_UserInfo.strUserName].ToString();
pHT_UserInfo.Password = dr[pHT_UserInfo.strPassword].ToString();
pHT_UserInfo.FullName = dr[pHT_UserInfo.strFullName].ToString();
if ("" + dr[pHT_UserInfo.strIDNS_GiaoVien] != "")
{
pHT_UserInfo.IDNS_GiaoVien = int.Parse(dr[pHT_UserInfo.strIDNS_GiaoVien].ToString());
}
if ("" + dr[pHT_UserInfo.strIDHT_UserGroup] != "")
{
pHT_UserInfo.IDHT_UserGroup = int.Parse(dr[pHT_UserInfo.strIDHT_UserGroup].ToString());
}
pHT_UserInfo.Active = bool.Parse(dr[pHT_UserInfo.strActive].ToString());
pHT_UserInfo.IpAddress = "" + dr[pHT_UserInfo.strIpAddress].ToString();
pHT_UserInfo.MacAddress = "" + dr[pHT_UserInfo.strMacAddress].ToString();
}
public void Delete(HT_UserInfo pHT_UserInfo)
{
oDHT_User.Delete(pHT_UserInfo);
mErrorMessage = oDHT_User.ErrorMessages;
mErrorNumber = oDHT_User.ErrorNumber;
}
public DataTable Get(HT_UserInfo pHT_UserInfo)
{
return(oDHT_User.Get(pHT_UserInfo));
}
public frmLogIn()
{
InitializeComponent();
oBHT_User = new cBHT_User();
pHT_UserInfo = new HT_UserInfo();
}
