internal static Bitmap FxSqlImage(string pDatabase, string pSchema, string pStoredProcedure, object[][] pParameters)
{
DataTable ObjDt = ClsConnection.FxSqlExecute(pDatabase, pSchema, pStoredProcedure, pParameters);
if (ObjDt != null)
{
if (ObjDt.Rows.Count > 0)
{
byte[] ObjBuffer = (byte[])ObjDt.Rows[0][0];
MemoryStream ObjStream = new MemoryStream(ObjBuffer);
Bitmap ObjImage = new Bitmap(ObjStream);
ObjStream.Close();
ObjStream.Dispose();
return(ObjImage);
}
else
{
ObjDt.Dispose();
return(null);
}
}
else
{
return(null);
}
}
internal static long Fx_upt_tblUser_password(long pUserId, string pPassword)
{
long lUserId = 0;
object[][] lParameters = new object[2][];
lParameters[0] = new object[] { "UserId", "Password" };
lParameters[1] = new object[] { pUserId, pPassword };
DataTable ObjDt = ClsConnection.FxSqlExecute(ClsVariables.gDatabase, "Administrator", "sp_upt_tblUser_password", lParameters);
if (ObjDt != null)
{
if (ObjDt.Rows.Count > 0)
{
try
{
lUserId = long.Parse(ObjDt.Rows[0][0].ToString());
}
catch
{
lUserId = 0;
}
}
ObjDt.Dispose();
}
return(lUserId);
}
internal static DataTable Fx_sel_tblSetting(bool pEnabled)
{
object[][] lParameters = new object[2][];
lParameters[0] = new object[] { "Enabled" };
lParameters[1] = new object[] { pEnabled };
DataTable ObjDt = ClsConnection.FxSqlExecute(ClsVariables.gDatabase, "Administrator", "sp_sel_tblSetting", lParameters);
return(ObjDt);
}
internal static DataTable Fx_sel_tblUser_companyModule(long pUserId, long pCompanyId)
{
object[][] lParameters = new object[2][];
lParameters[0] = new object[] { "UserId", "CompanyId" };
lParameters[1] = new object[] { pUserId, pCompanyId };
DataTable ObjDt = ClsConnection.FxSqlExecute(ClsVariables.gDatabase, "Administrator", "sp_sel_tblUser_companyModule", lParameters);
return(ObjDt);
}
internal static long Fx_sel_tblUser_checkPassword(string pUserName, string pPassword)
{
long lUserId = 0;
string lUserName;
DateTime lExpirationDate;
object[][] lParameters = new object[2][];
lParameters[0] = new object[] { "UserName", "Password" };
lParameters[1] = new object[] { pUserName, pPassword };
DataTable ObjDt = ClsConnection.FxSqlExecute(ClsVariables.gDatabase, "Administrator", "sp_sel_tblUser_checkPassword", lParameters);
if (ObjDt != null)
{
if (ObjDt.Rows.Count > 0)
{
try
{
lUserId = long.Parse(ObjDt.Rows[0][0].ToString());
lUserName = ObjDt.Rows[0][2].ToString();
lExpirationDate = DateTime.Parse(ObjDt.Rows[0][3].ToString());
}
catch
{
lUserId = 0;
lUserName = "";
lExpirationDate = DateTime.Today;
}
if (lUserId > 0)
{
ClsVariables.gUserId = lUserId;
ClsVariables.gUserName = lUserName;
ClsVariables.gUserExpirationDate = lExpirationDate;
}
}
ObjDt.Dispose();
}
return(lUserId);
}
