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