//public string fnGetEmail(int userID)
//{
// string mail = "";
// DS_AdminTableAdapters.up_GetEmailUserTableAdapter emailTA;
// DS_Admin.up_GetEmailUserDataTable emailDT;
// try
// {
// emailTA = new DS_AdminTableAdapters.up_GetEmailUserTableAdapter();
// emailDT = new DS_Admin.up_GetEmailUserDataTable();
// emailDT = emailTA.GetData(userID);
// mail = emailDT.Rows[0][0].ToString();
// }
// catch (Exception ex)
// {
// ERROR += "<br/>" + ex.Message.ToString();
// }
// return mail;
//}
public DataSet fnGetUserDetails(int userID)
{
CLPalletLink.SC_Users Users = new CLPalletLink.SC_Users();
DataSet dsUsers = new DataSet();
DataSet ds = null;
try
{
dsUsers = Users.GetUserDetail(strSQLServer, strSQLDataBase, userID);
if (dsUsers.Tables[0].Rows.Count > 0)
{
ds = dsUsers;
}
else
{
ds = null;
}
}
catch (Exception ex)
{
ERROR = "Error to get user data information, " + ex.Message.ToString();
}
return(ds);
}
// public bool fnUserHasAccess(string pageName, int fkUser)
public bool fnUserHasAccess(string pageName, int fkUser)
{
CLPalletLink.SC_Users Users = new CLPalletLink.SC_Users();
DataSet dsUsersAccess = new DataSet();
dsUsersAccess = Users.UserHasAccess(strSQLServer, strSQLDataBase, pageName, fkUser);
//return dsUsersAccess.Tables[0].Rows.Count > 0;
if (dsUsersAccess.Tables[0].Rows.Count > 0)
{
return(true);
}
else
{
return(false);
}
}
public static bool fnUserHasAccess(string strSQLServer, string strSQLDataBase, int fkUser)
{
CLPalletLink.SC_Users scUsers = new CLPalletLink.SC_Users();
DataSet dsAccess = new DataSet();
bool HasAccess = false;
dsAccess = scUsers.CheckIfHaveAccess(strSQLServer, strSQLDataBase, fkUser);
if (dsAccess.Tables[0].Rows.Count > 0)
{
int haveAccess = Int32.Parse(dsAccess.Tables[0].Rows[0].ItemArray[3].ToString());
if (haveAccess == 1)
{
HasAccess = true;
}
}
return(HasAccess);
}
public int fnGetUserID(string user, int PKCustomer)
{
int userID = 0;
CLPalletLink.SC_Users Users = new CLPalletLink.SC_Users();
DataSet dsUsers = new DataSet();
try
{
dsUsers = Users.GetUserID(strSQLServer, strSQLDataBase, user, PKCustomer);
if (dsUsers.Tables[0].Rows.Count > 0)
{
userID = Convert.ToInt32(dsUsers.Tables[0].Rows[0][0]);
}
}
catch (Exception ex)
{
ERROR += "<br/>" + ex.Message.ToString();
}
return(userID);
}
//public int fnGetUserIDByEmployeeID(int employeeID)
//{
// int userID = 0;
// DS_AdminTableAdapters.up_GetUserIDByEmployeeIDTableAdapter idUserTA;
// DS_Admin.up_GetUserIDByEmployeeIDDataTable idUserDT;
// try
// {
// idUserTA = new DS_AdminTableAdapters.up_GetUserIDByEmployeeIDTableAdapter();
// idUserDT = new DS_Admin.up_GetUserIDByEmployeeIDDataTable();
// idUserDT = idUserTA.GetData(employeeID);
// userID = Convert.ToInt32(idUserDT.Rows[0][0]);
// }
// catch (Exception ex)
// {
// ERROR += "<br/>" + ex.Message.ToString();
// }
// return userID;
//}
public int fnVerifyType(int userID, int PKCustomer)
{
int aux = 6;
CLPalletLink.SC_Users Users = new CLPalletLink.SC_Users();
DataSet dsUsers = new DataSet();
try
{
dsUsers = Users.GetUserType(strSQLServer, strSQLDataBase, userID, PKCustomer);
if (dsUsers.Tables[0].Rows.Count > 0)
{
aux = Convert.ToInt32(dsUsers.Tables[0].Rows[0][0]);
}
}
catch (Exception ex)
{
aux = 6;
ERROR += "<br/>" + ex.Message.ToString();
}
return(aux);
}
//public string fnGetServerName
//{
//get
//{
// //DS_ConfigTableAdapters.up_GetServerNameTableAdapter serverTA = new DS_ConfigTableAdapters.up_GetServerNameTableAdapter();
// //DS_Config.up_GetServerNameDataTable serverDT = new DS_Config.up_GetServerNameDataTable();
// serverDT = serverTA.GetData();
// return serverDT.Rows[0]["ServerName"].ToString();
//}
//}
public bool fnCheckUser(string user, int PKCustomer)
{
bool aux = false;
CLPalletLink.SC_Users Users = new CLPalletLink.SC_Users();
DataSet dsUsers = new DataSet();
try
{
dsUsers = Users.GetCheckUser(strSQLServer, strSQLDataBase, user, PKCustomer);
if (dsUsers.Tables[0].Rows.Count > 0)
{
aux = true;
}
}
catch (Exception ex)
{
aux = false;
ERROR += "<br/>" + ex.Message.ToString();
}
return(aux);
}
public string fnRoleName(int userID, int PKCustomer)
{
string role = " ";
CLPalletLink.SC_Users Users = new CLPalletLink.SC_Users();
DataSet dsUsers = new DataSet();
try
{
dsUsers = Users.GetUserType(strSQLServer, strSQLDataBase, userID, PKCustomer);
if (dsUsers.Tables[0].Rows.Count > 0)
{
role = dsUsers.Tables[0].Rows[0]["Role"].ToString();
}
}
catch (Exception ex)
{
ERROR += "<br/>" + ex.Message.ToString();
}
return(role);
}
