public static void Insert_PostalAddress(Postal_Address postal)
{
using (var objUsersDbContext = new UsersDbContext())
{
try
{
var objPostalAddress = new Postal_Address
{
AddressLine1 = postal.AddressLine1,
AddressLine2 = postal.AddressLine2,
AddressLine3 = postal.AddressLine3,
FkSuburbId = postal.FkSuburbId,
FkUserId = postal.FkUserId
};
objUsersDbContext.PostalAddress.Add(objPostalAddress);
objUsersDbContext.SaveChanges();
Console.WriteLine("An Postal Address for User Id " + postal.FkUserId + " has beed added.");
Console.ReadKey();
}
catch (Exception)
{
Console.WriteLine("Could not add Postal Address");
Console.ReadKey();
}
}
}
public void Update_Postal(Postal_Address postal)
{
using (var usersDbContext = new UsersDbContext())
{
try
{
var objUpdatePostal = usersDbContext.PostalAddress.SingleOrDefault(x => x.PkPostalAddressId == postal.PkPostalAddressId);
objUpdatePostal.AddressLine1 = postal.AddressLine1;
objUpdatePostal.AddressLine2 = postal.AddressLine2;
objUpdatePostal.AddressLine3 = postal.AddressLine3;
objUpdatePostal.FkSuburbId = postal.FkSuburbId;
usersDbContext.SaveChanges();
Console.WriteLine("Postal Address Updated");
Console.ReadKey();
}
catch (Exception)
{
Console.WriteLine("Could not Update Postal Address");
Console.ReadKey();
}
}
}
public void EnterPostalUpdateDetails(Postal_Address postal)
{
Console.WriteLine("Please enter Postal AddressId");
postal.PkPostalAddressId = Convert.ToInt32(Console.ReadLine());
Console.WriteLine("Please enter AddressLine 1");
postal.AddressLine1 = Console.ReadLine();
Console.WriteLine("Please enter AddressLine 2");
postal.AddressLine2 = Console.ReadLine();
Console.WriteLine("Please enter AddressLine 3");
postal.AddressLine3 = Console.ReadLine();
Console.WriteLine("Please enter Suburb-ID");
postal.FkSuburbId = Convert.ToInt32(Console.ReadLine());
Update_Postal(postal);
}
public void EnterPostalAddressDetails(Postal_Address postal)
{
Console.WriteLine("Please enter User-ID");
postal.FkUserId = Convert.ToInt32(Console.ReadLine());
Console.WriteLine("Please enter AddressLine 1");
postal.AddressLine1 = Console.ReadLine();
Console.WriteLine("Please enter AddressLine 2");
postal.AddressLine2 = Console.ReadLine();
Console.WriteLine("Please enter AddressLine 3");
postal.AddressLine3 = Console.ReadLine();
Console.WriteLine("Please enter Suburb-ID");
postal.FkSuburbId = Convert.ToInt32(Console.ReadLine());
Console.WriteLine("\r\n");
Insert_PostalAddress(postal);
}
static void Main(string[] args)
{
Console.WriteLine("Main Menu \r\n \r\n User Operations: \r\n 0. See Registered Users \r\n 1. Register User \r\n 2. Update User \r\n ");
Console.WriteLine("Physical Address Operations: \r\n 3. Enter User Physical Address \r\n 4. Update User Physical Address \r\n ");
Console.WriteLine("Postal Address Operations: \r\n 5. Enter User Postal Address \r\n 6. Update User Postal Address \r\n ");
Console.WriteLine("User Approval Operations: \r\n 7. Press 1 to Approve User");
Console.WriteLine("User Deletion Operations: \r\n 8. Press 1 to Delete User");
//Object in use by 2---Methods as Parameter ,thats why is Glabol
var user = new _User();
var physical = new Physical_Address();
var postal = new Postal_Address();
int option = Convert.ToInt32(Console.ReadLine());
switch (option)
{
case 0:
var objSelectUser = new SelectUser();
objSelectUser.RetrieveUser();
break;
case 1:
var objInsertUser = new InsertUser();
objInsertUser.EnterUserDetails(user);
Console.WriteLine("would you like to add your physical address: Y/N");
string value = Console.ReadLine();
string lower = value.ToLower();
if (lower == "y")
{
var objaddressOption = new InsertPhysical();
objaddressOption.EnterPhysicalAddressDetails(physical);
}
else if (lower == "n")
{
Console.WriteLine("Thank you");
}
break;
case 2:
var objUpdateUser = new UpdateUser();
objUpdateUser.EnterUpdateUserDetails(user);
break;
case 3:
var objInsertPhysical = new InsertPhysical();
objInsertPhysical.EnterPhysicalAddressDetails(physical);
break;
case 4:
var objUpdatePhysical = new UpdatePhysical();
objUpdatePhysical.EnterPhysicalUpdateDetails(physical);
break;
case 5:
var objInsertPostal = new InsertPostal();
objInsertPostal.EnterPostalAddressDetails(postal);
break;
case 6:
var objUpdatePostal = new UpdatePostal();
objUpdatePostal.EnterPostalUpdateDetails(postal);
break;
case 7:
var objUpdateApprovalStatus = new UpdateApprovalStatus();
objUpdateApprovalStatus.EnterUpdateStatus();
break;
case 8:
var objSoftDeleteUser = new DeleteUser();
objSoftDeleteUser.UserIdToDelete();
break;
default:
Console.WriteLine("Opps! Invalid option entered. Retry");
Console.ReadKey();
break;
}
}
