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