public static string deleteFrom_db(string id) { try { ValidateUserInput.IsThisUserexists(id); using (RentalcarsEntities1 ef = new RentalcarsEntities1()) { UserTable dbUser = ef.UserTables.FirstOrDefault(u => u.UserIdNumber == id); List <Order> ishaveOrder = ef.Orders.Where(u => u.UserID == dbUser.UserID && u.ActualReturnDate != null).ToList(); if (ishaveOrder.Count == 0) { ef.UserTables.Remove(ef.UserTables.FirstOrDefault(u => u.UserIdNumber == id)); ef.SaveChanges(); return("OK"); } else { return("This user has an order in his name"); } } } catch { return("Something is wrong with the data"); } }
public static string AddUserTo_db(BOLUserInfo userInfo) { try { using (RentalcarsEntities1 ef = new RentalcarsEntities1()) { ValidateUserInput.CheckUnique(userInfo.UserName, userInfo.UserIdNumber); ef.UserTables.Add(new UserTable { FullUserName = userInfo.FullUserName, UserIdNumber = userInfo.UserIdNumber, UserName = userInfo.UserName, Password = userInfo.Password, BirthDay = userInfo.BirthDay, Sex = userInfo.Sex, UserRole = 0, UserPic = userInfo.UserPic, Email = userInfo.Email }); ef.SaveChanges(); return("OK"); } } catch { return("Something is wrong with the data"); } }
public static string UpDataTo_db(BOLUserInfo olduserInfo, BOLUserInfo newuserInfo) { try { if (newuserInfo.UserRole != 0) { ValidateUserInput.CheckRole(newuserInfo.UserRole); } using (RentalcarsEntities1 ef = new RentalcarsEntities1()) { UserTable dbUser = ef.UserTables.FirstOrDefault(u => u.UserIdNumber == olduserInfo.UserIdNumber); dbUser.FullUserName = newuserInfo.FullUserName; dbUser.UserIdNumber = newuserInfo.UserIdNumber; dbUser.UserName = newuserInfo.UserName; dbUser.Password = newuserInfo.Password; dbUser.BirthDay = newuserInfo.BirthDay; dbUser.Sex = newuserInfo.Sex; dbUser.UserRole = newuserInfo.UserRole; dbUser.UserPic = newuserInfo.UserPic; dbUser.Email = newuserInfo.Email; ef.SaveChanges(); return("OK"); } } catch { return("Something is wrong with the data"); } }