public static BJUserInfo GetUserById(int changer) { BJUserLoader loader = new BJUserLoader("BJVVV"); BJUserInfo result = loader.GetUserById(changer); return(result); }
public static BJUserInfo GetUserByLogin(string login, string fund) { BJUserLoader loader = new BJUserLoader(fund); BJUserInfo result = loader.GetUserByLogin(login.ToUpper()); return(result); }
public BJUserInfo GetUserByLogin(string login) { DataTable table = wrapper.GetUserByLogin(login, fund); if (table.Rows.Count == 0) { return(null); } BJUserInfo result = new BJUserInfo(); result.Id = Convert.ToInt32(table.Rows[0]["ID"]); result.Login = login; result.HashedPwd = table.Rows[0]["HASH"].ToString(); result.FIO = table.Rows[0]["FIO"].ToString(); result.UserStatus = new List <UserStatus>(); foreach (DataRow row in table.Rows) { UserStatus us = new UserStatus(); us.DepId = Convert.ToInt32(row["DepId"]); us.DepName = row["DepName"].ToString(); us.RoleId = Convert.ToInt32(row["IDROLE"]); us.RoleName = row["ROLE"].ToString(); result.UserStatus.Add(us); } return(result); }
public ReaderLib(string login, string sess, LibflClassLibrary.BJUsers.BJUserInfo bjUser) { //SqlDataAdapter DA = new SqlDataAdapter(); //DA.SelectCommand = new SqlCommand(); //DA.SelectCommand.Connection = new SqlConnection(WebConfigurationManager.ConnectionStrings["BJVVV"].ConnectionString); //DA.SelectCommand.Parameters.Clear(); //DA.SelectCommand.Parameters.AddWithValue("LOGIN", login.ToLower()); //DA.SelectCommand.CommandText = "select USERS.ID id,USERS.NAME name,USERS.LOGIN login,dpt.NAME dname from BJVVV..USERS join BJVVV..LIST_8 dpt on USERS.DEPT = dpt.ID where lower([LOGIN]) = @LOGIN"; //DataSet DS = new DataSet(); //int recc = DA.Fill(DS, "Employee"); this.ID = bjUser.Id.ToString(); //DS.Tables["Employee"].Rows[0]["id"].ToString(); this.Login = bjUser.Login; //DS.Tables["Employee"].Rows[0]["login"].ToString(); this.Name = bjUser.FIO; // DS.Tables["Employee"].Rows[0]["name"].ToString(); this.Dep = bjUser.SelectedUserStatus.DepName; //DS.Tables["Employee"].Rows[0]["dname"].ToString(); this.Session = sess; this.DepId = bjUser.SelectedUserStatus.DepId; //DA.SelectCommand.Connection.Close(); }