public static string GetUserName(int userID) { using (RentalcarsEntities1 ef = new RentalcarsEntities1()) { BOLUserInfo UsersInfo = new BOLUserInfo(); UserTable dbUser = ef.UserTables.FirstOrDefault(u => u.UserID == userID); if (dbUser != null) { return(dbUser.UserName); } else { return(null); } } }
public IHttpActionResult GetuserById(string userNumber) { var baseUrl = Request.RequestUri.GetLeftPart(UriPartial.Authority); BOLUserInfo user = RentUser.GetLoginUserFrom_db(userNumber); if (user != null) { UserModel convertedUsers = convertUser.convertUserFromBOLtoModel(user); if (convertedUsers.UserPic != null) { convertedUsers.UserPic = baseUrl + @"/image/" + convertedUsers.UserPic; } return(Ok(convertedUsers)); } else { return(NotFound()); } }
public static BOLUserInfo GetUser(string name, string password) { try { using (RentalcarsEntities1 ef = new RentalcarsEntities1()) { UserTable dbUser = ef.UserTables.FirstOrDefault(u => u.UserName == name && u.Password == password); if (dbUser != null) { BOLUserInfo user = new BOLUserInfo { UserName = dbUser.UserName, UserRole = dbUser.UserRole, }; return(user); } } } catch (Exception) { } return(null); }
internal static BOLUserInfo convertUserFromModeltoBOL(UserModel value) { try { BOLUserInfo usermodel = new BOLUserInfo { FullUserName = value.FullUserName, UserIdNumber = value.UserIdNumber, UserName = value.UserName, Password = value.Password, BirthDay = value.BirthDay, Sex = value.Sex == "male" ? true : false, UserRole = getRole(value.UserRole), UserPic = value.UserPic, Email = value.Email, }; return(usermodel); } catch { return(null); } }
public static UserModel convertUserFromBOLtoModel(BOLUserInfo userInfo) { try { UserModel usermodel = new UserModel { FullUserName = userInfo.FullUserName, UserIdNumber = userInfo.UserIdNumber, UserName = userInfo.UserName, Password = userInfo.Password, BirthDay = userInfo.BirthDay, Sex = userInfo.Sex ? "male" : "female", UserRole = getRole(userInfo.UserRole), UserPic = userInfo.UserPic, Email = userInfo.Email, }; return(usermodel); } catch { return(null); } }
public static List <BOLOrder> GetUsersOrdesrByidNumber(string idNumber) { List <BOLOrder> orderList = new List <BOLOrder>(); try { UserTable user; BOLUserInfo a = new BOLUserInfo(); a.UserIdNumber = idNumber; idNumber = a.UserIdNumber; using (RentalcarsEntities1 ef = new RentalcarsEntities1()) { user = ef.UserTables.FirstOrDefault(u => u.UserIdNumber == idNumber); } using (RentalcarsEntities1 ef = new RentalcarsEntities1()) { List <Order> dbOrder = ef.Orders.Where(u => u.ActualReturnDate == null && u.UserID == user.UserID).ToList(); foreach (var item in dbOrder) { orderList.Add(new BOLOrder { StartDate = item.StartDate, ReturnDate = item.ReturnDate, ActualReturnDate = item.ActualReturnDate, UserID = item.UserID, VehiclesID = item.VehiclesID, }); } return(orderList); } } catch { return(null); } }
public IHttpActionResult Post([FromBody] BOLUserInfo value) { RentUser.AddUserTo_db(value); return(Ok()); }