public static DataSet SQLExec(string sql)
{
DataSet sql_CommonDS = new DataSet();
DatabaseMSSQL sql_Common = new DatabaseMSSQL();
sql_CommonDS = sql_Common.getDataSet(sql);
return(sql_CommonDS);
}
public static bool SetSessionLogin(string username, string password, string type)
{
bool ret = false;
DataTable get = new DataTable();
DatabaseMSSQL db = new DatabaseMSSQL();
string query = string.Empty;
if (type == "ADMIN")
{
query =
@"SELECT TOP(1)
[USER_GUID]
,[USER_ID]
,[USER_NAME_DISPLAY]
,[USER_EMAIL]
,[PRIV_ROLE_GUID]
,[PRIV_ROLE_GROUP_GUID]
FROM
[USER]
WHERE
USER_EMAIL = '" + username + @"'
AND USER_PWD = '" + password + @"'
AND USER_IS_ACTIVE = 'Y'";
get = db.GetDataTable(query);
HttpContext.Current.Session["IS_VENDOR"] = "N";
HttpContext.Current.Session["USER_GUID"] = get.Rows[0].ItemArray[0].ToString();
HttpContext.Current.Session["USER_ID"] = get.Rows[0].ItemArray[1].ToString();
HttpContext.Current.Session["USER_NAME_DISPLAY"] = get.Rows[0].ItemArray[2].ToString();
HttpContext.Current.Session["USER_EMAIL"] = get.Rows[0].ItemArray[3].ToString();
HttpContext.Current.Session["PRIV_ROLE_GUID"] = get.Rows[0].ItemArray[3].ToString();
HttpContext.Current.Session["PRIV_ROLE_GROUP_GUID"] = get.Rows[0].ItemArray[3].ToString();
ret = true;
}
else if (type == "VENDOR")
{
query =
@"SELECT
[VENDOR_GUID]
,[VENDOR_ID]
,[VENDOR_NAME]
,[VENDOR_CODE]
FROM
[VENDOR]
WHERE
VENDOR_IS_ACTIVE = 'Y'";
get = db.GetDataTable(query);
HttpContext.Current.Session["IS_VENDOR"] = "Y";
HttpContext.Current.Session["VENDOR_GUID"] = get.Rows[0].ItemArray[0].ToString();
HttpContext.Current.Session["VENDOR_ID"] = get.Rows[0].ItemArray[1].ToString();
HttpContext.Current.Session["VENDOR_NAME"] = get.Rows[0].ItemArray[2].ToString();
HttpContext.Current.Session["VENDOR_CODE"] = get.Rows[0].ItemArray[3].ToString();
ret = true;
}
return(ret);
}
public static DataSet SQLExec(string sql)
{
DataSet sql_CommonDS = new DataSet();
DatabaseMSSQL sql_Common = new DatabaseMSSQL();
sql_CommonDS = sql_Common.getDataSet(sql);
return sql_CommonDS;
}
