public JsonResult LoginUser(string login_User_ArrayData)
{
HCM_Users login_user_Obj = new HCM_Users();
login_User_ArrayData = HttpUtility.UrlDecode(login_User_ArrayData);
NameValueCollectionData nameValueCollectionData_Obj = new NameValueCollectionData();
NameValueCollection Login_User_Collection_Obj = nameValueCollectionData_Obj.GetQueryStringCollection(login_User_ArrayData);
ModifyLoginData loginuser_Obj = new ModifyLoginData();
login_user_Obj = loginuser_Obj.LoginUser(Login_User_Collection_Obj);
if (login_user_Obj.UserID != 0)
{
Session["UserID"] = Convert.ToString(login_user_Obj.UserID);
Session["ClientID"] = Convert.ToString(login_user_Obj.Client.ClientID);
Session["UserType"] = Convert.ToString(login_user_Obj.UserType);
if (login_user_Obj.UserType == "SuperAdmin")
{
List <HCM_Client> client_list = new List <HCM_Client>();
ModifyGlobalClientsData client_Obj = new ModifyGlobalClientsData();
client_list = client_Obj.GetClients(String.IsNullOrEmpty(Convert.ToString(Session["ClientID"])) ? 0 : Convert.ToInt32(Session["ClientID"]), Convert.ToString(Session["UserType"]));
if (String.IsNullOrEmpty(Convert.ToString(Session["ClientID"])))
{
Session["ClientID"] = Convert.ToString(client_list.First().ClientID);
}
}
if (login_user_Obj.UserType == "ClientAdmin" || login_user_Obj.UserType == "SuperAdmin")
{
List <HCM_Versions> version_List = new List <HCM_Versions>();
ModifyVersionsData versionDataList_Obj = new ModifyVersionsData();
version_List = versionDataList_Obj.GetActiveVersions();
foreach (var item in version_List)
{
if (item.IsDefault)
{
Session["VersionID"] = Convert.ToString(item.VersionID);
}
}
}
if (login_user_Obj.UserType == "ClientAdmin" || login_user_Obj.UserType == "SuperAdmin")
{
List <HCM_Product> product_List = new List <HCM_Product>();
ModifyProductData productDataList_Obj = new ModifyProductData();
product_List = productDataList_Obj.GetAllProducts();
foreach (var item in product_List)
{
Session["ProductID"] = Convert.ToInt32(item.ProductID);
}
}
}
return(Json(login_user_Obj, JsonRequestBehavior.AllowGet));
}
public List <HCM_Users> GetUsers()
{
List <HCM_Users> users_list = new List <HCM_Users>();
HCM_Users user_obj = new HCM_Users();
try
{
using (SqlConnection sql_obj = new SqlConnection())
{
sql_obj.ConnectionString = sql.GetConnection();
sql_obj.Open();
using (SqlCommand cmd = new SqlCommand("HCM_PROC_GetUsers", sql_obj))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandTimeout = 0;
cmd.Parameters.AddWithValue("@ClientID", HttpContext.Current.Session["ClientID"]);
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
da.Fill(dt);
sql_obj.Close();
if (dt.Rows.Count > 0)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
user_obj = new HCM_Users();
user_obj.UserID = Convert.ToInt32(dt.Rows[i]["UserID"]);
user_obj.Client.ClientID = Convert.ToInt32(dt.Rows[i]["ClientID"]);
user_obj.UserType = Convert.ToString(dt.Rows[i]["UserType"]);
user_obj.FirstName = Convert.ToString(dt.Rows[i]["FirstName"]);
user_obj.LastName = Convert.ToString(dt.Rows[i]["LastName"]);
user_obj.Email = Convert.ToString(dt.Rows[i]["Email"]);
user_obj.Password = Convert.ToString(dt.Rows[i]["Password"]);
user_obj.Status = Convert.ToBoolean(dt.Rows[i]["Status"]);
user_obj.Country.Region.RegionID = dt.Rows[i]["RegionID"] == DBNull.Value ? (int?)null : Convert.ToInt32(dt.Rows[i]["RegionID"]);
// user_obj.Product.ProductID = dt.Rows[i]["ProductID"]==DBNull.Value ? (int?) null: Convert.ToInt32(dt.Rows[i]["ProductID"]);
// user_obj.Product.ProductName = Convert.ToString(dt.Rows[i]["ProductName"]);
user_obj.Country.Region.RegionCode = Convert.ToString(dt.Rows[i]["RegionCode"]);
user_obj.Country.CountryID = dt.Rows[i]["CountryID"] == DBNull.Value ? (int?)null : Convert.ToInt32(dt.Rows[i]["CountryID"]); //Convert.ToInt32(dt.Rows[i]["CountryID"]);
user_obj.Country.CountryName = Convert.ToString(dt.Rows[i]["CountryName"]);
user_obj.Location.LocationID = dt.Rows[i]["LocationID"] == DBNull.Value ? (int?)null : Convert.ToInt32(dt.Rows[i]["LocationID"]);
user_obj.Location.LocationName = Convert.ToString(dt.Rows[i]["LocationName"]);
users_list.Add(user_obj);
}
}
}
}
}
catch (Exception ex)
{
throw ex;
}
return(users_list);
}
public HCM_Users LoginUser(NameValueCollection Login_User_Collection_Obj)
{
HCM_Users login_user_Obj = new HCM_Users();
try
{
using (SqlConnection sql_obj = new SqlConnection())
{
sql_obj.ConnectionString = sql.GetConnection();
sql_obj.Open();
using (SqlCommand cmd = new SqlCommand("HCM_PROC_LoginUser", sql_obj))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandTimeout = 0;
cmd.Parameters.AddWithValue("@Email", Convert.ToString(Login_User_Collection_Obj["Email"]).Trim());
cmd.Parameters.AddWithValue("@Password", Convert.ToString(Login_User_Collection_Obj["Password"]).Trim());
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
da.Fill(dt);
sql_obj.Close();
if (dt.Rows.Count > 0)
{
login_user_Obj.UserID = Convert.ToInt32(dt.Rows[0]["UserID"]);
login_user_Obj.Client.ClientID = dt.Rows[0]["ClientID"] == DBNull.Value ? (int?)null : Convert.ToInt32(dt.Rows[0]["ClientID"]);
login_user_Obj.UserType = Convert.ToString(dt.Rows[0]["UserType"]);
login_user_Obj.Email = Convert.ToString(dt.Rows[0]["Email"]);
login_user_Obj.FirstName = Convert.ToString(dt.Rows[0]["FirstName"]);
login_user_Obj.LastName = Convert.ToString(dt.Rows[0]["LastName"]);
}
return(login_user_Obj);
}
}
}
catch (Exception ex)
{
throw ex;
}
}
