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