private void BtnLogin_Click(object sender, RoutedEventArgs e)
{
ForceValidation();
if (Validation.GetHasError(txtPasword) || Validation.GetHasError(txtuName))
{
MessageBox.Show("Error Some Data is Missing", "ERROR");
return;
}
ResourceForm RFobj = new ResourceForm();
LoginFactory obj = new LoginFactory();
Admin_Table Aobj = new Admin_Table();
Aobj = obj.GetData(2);
if (txtuName.Text == Aobj.A_UserName && txtPasword.Text == Aobj.A_Password)
{
this.Close();
RFobj.ShowDialog();
}
else if (Aobj.A_UserName != txtuName.Text)
{
MessageBox.Show("User Name is Wrong Please Enter Again", "Error!");
}
else if (txtPasword.Text != Aobj.A_Password)
{
MessageBox.Show("Password is Wrong Please Enter Again", "Error!");
}
else
{
MessageBox.Show("Something is Wrong", "Error!");
}
}
public IHttpActionResult PostAdmin_Table(Admin_Table admin_Table)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
db.Admin_Table.Add(admin_Table);
try
{
db.SaveChanges();
}
catch (DbUpdateException)
{
if (Admin_TableExists(admin_Table.AminId))
{
return(Conflict());
}
else
{
throw;
}
}
return(CreatedAtRoute("DefaultApi", new { id = admin_Table.AminId }, admin_Table));
}
public IHttpActionResult PutAdmin_Table(int id, Admin_Table admin_Table)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != admin_Table.AminId)
{
return(BadRequest());
}
db.Entry(admin_Table).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!Admin_TableExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
public IHttpActionResult DeleteAdmin_Table(int id)
{
Admin_Table admin_Table = db.Admin_Table.Find(id);
if (admin_Table == null)
{
return(NotFound());
}
db.Admin_Table.Remove(admin_Table);
db.SaveChanges();
return(Ok(admin_Table));
}
public IHttpActionResult LoginCheck(Admin_Table user)
{
Admin_Table foundUser = db.Admin_Table.Where(a => a.Admin_username.Equals(user.Admin_username)).FirstOrDefault();
if (foundUser == null)
{
return(NotFound());
}
else if (foundUser != null && user.Admin_password.Equals(foundUser.Admin_password))
{
return(Ok("Correct"));
}
else
{
return(NotFound());
}
}
private async void RegisterButton_Clicked(object sender, EventArgs e)
{
if ((string.IsNullOrWhiteSpace(userNameEntry.Text)) || (string.IsNullOrWhiteSpace(passwordEntry.Text)) ||
(string.IsNullOrWhiteSpace(emailEntry.Text)))
{
await DisplayAlert("Warning", "All fields are required", "Ok");
}
else if (!string.Equals(passwordEntry.Text, confirmPasswordEntry.Text))
{
await DisplayAlert("Warning", "Passwords don't match", "Ok");
passwordEntry.Text = string.Empty;
confirmPasswordEntry.Text = string.Empty;
}
else
{
var admin = new Admin_Table();
conn.CreateTable <Admin_Table>();
admin.AdminEmail = emailEntry.Text;
admin.AdminUserName = userNameEntry.Text;
admin.AdminPassword = passwordEntry.Text;
var returnValue = helper.AddAdmin(userNameEntry.Text);
if (returnValue)
{
conn.Insert(admin);
await DisplayAlert("Success!", "New admin created", "Ok");
await Navigation.PopAsync();
}
else
{
await DisplayAlert("Failure", "That Admin Username already exists", "OK");
warningLabel.IsVisible = false;
emailEntry.Text = string.Empty;
userNameEntry.Text = string.Empty;
passwordEntry.Text = string.Empty;
confirmPasswordEntry.Text = string.Empty;
}
}
}
private void button1_Click(object sender, EventArgs e)
{
Bank_Mangment_SystemEntities1 dbe = new Bank_Mangment_SystemEntities1();
if (oldpasswordtxt.Text != string.Empty || newpasswordtxt.Text != string.Empty || retypepasswordtxt.Text != string.Empty)
{
Admin_Table user1 = dbe.Admin_Table.FirstOrDefault(a => a.Username.Equals(usertxt.Text));
if (user1 != null)
{
if (user1.Password.Equals(oldpasswordtxt.Text))
{
user1.Password = newpasswordtxt.Text;
dbe.SaveChanges();
MessageBox.Show("Password Changed Successfully!");
}
else
{
MessageBox.Show("Password Incorrect");
}
}
}
}
public MainPage()
{
InitializeComponent();
Title = "Welcome";
conn = DependencyService.Get <ITravelApp_db>().GetConnection();
NavigationPage.SetHasNavigationBar(this.Main, true);
conn.CreateTable <Admin_Table>();
conn.CreateTable <User_Table>();
conn.CreateTable <Trips_Table>();
conn.CreateTable <Flights_Table>();
conn.CreateTable <Dining_Table>();
conn.CreateTable <Entertainment_Table>();
conn.CreateTable <Lodging_Table>();
conn.CreateTable <Transportation_Table>();
var _UserList = conn.Query <User_Table>($"SELECT * FROM User_Table");
var adminList = conn.Query <Admin_Table>($"SELECT * FROM Admin_Table");
if (!adminList.Any())
{
var admin = new Admin_Table();
admin.AdminUserName = "******";
admin.AdminPassword = "******";
admin.AdminEmail = "*****@*****.**";
conn.Insert(admin);
adminList.Add(admin);
}
if (!_UserList.Any())
{
#region User Data
var newUser = new User_Table();
newUser.UserName = "******";
newUser.Password = "******";
newUser.FirstName = "User";
newUser.LastName = "Test";
newUser.UserEmail = "*****@*****.**";
conn.Insert(newUser);
_UserList.Add(newUser);
var newUser1 = new User_Table();
newUser1.UserName = "******";
newUser1.Password = "******";
newUser1.FirstName = "John";
newUser1.LastName = "Doe";
newUser1.UserEmail = "*****@*****.**";
conn.Insert(newUser1);
_UserList.Add(newUser1);
#endregion
#region Trips Data
var newTrip2 = new Trips_Table();
newTrip2.UserName = newUser.UserName;
newTrip2.TripName = "Disneyland 2021";
newTrip2.TripStart = new DateTime(2021, 11, 12);
newTrip2.TripEnd = new DateTime(2021, 11, 17);
newTrip2.Notes = "We're In Disneyland Evan";
newTrip2.TripNotifications = 0;
newTrip2.UserId = newUser.UserId;
conn.Insert(newTrip2);
var newTrip3 = new Trips_Table();
newTrip3.UserName = newUser1.UserName;
newTrip3.TripName = "Utah 2020";
newTrip3.TripStart = new DateTime(2020, 11, 12);
newTrip3.TripEnd = new DateTime(2020, 11, 17);
newTrip3.Notes = "Request time off";
newTrip3.TripNotifications = 1;
newTrip3.UserId = newUser1.UserId;
conn.Insert(newTrip3);
#endregion
#region Dining Data
var newRes = new Dining_Table();
newRes.ResName = "Carnation Cafe";
newRes.ResAddress = "Disneyland Park, Anaheim, CA 92802";
newRes.ResPhone = "(714)781-3463";
newRes.ResDate = DateTime.Today;
newRes.ResNotes = "Dinner with my wife";
newRes.ResNotifications = 1;
newRes.TripId = newTrip2.TripId;
conn.Insert(newRes);
var newRes2 = new Dining_Table();
newRes2.ResName = "Rainforest Cafe";
newRes2.ResAddress = "123 Downtown Disney District, Anaheim, CA 92802";
newRes2.ResPhone = "(714)866-5555";
newRes2.ResDate = new DateTime(2020, 11, 12);
newRes2.ResNotes = "Birthday Dinner";
newRes2.ResNotifications = 1;
newRes2.TripId = newTrip2.TripId;
conn.Insert(newRes2);
#endregion
#region Entertainment Data
var newActivity = new Entertainment_Table();
newActivity.EntertainName = "Disneyland";
newActivity.EntertaninStart = new DateTime(2020, 11, 12, 08, 00, 00);
newActivity.EntertainEnd = new DateTime(2020, 11, 12, 23, 00, 00);
newActivity.EnterainAddress = "1313 Disneyland Dr, Anaheim, CA 92802";
newActivity.EntertainPhone = "(714)781-4636";
newActivity.EntertainNotes = "Get to the park at 7:00";
newActivity.EntertainNotifications = 1;
newActivity.TripId = newTrip2.TripId;
conn.Insert(newActivity);
var newActivity2 = new Entertainment_Table();
newActivity2.EntertainName = "Disneyland";
newActivity2.EntertaninStart = new DateTime(2020, 11, 14, 07, 00, 00);
newActivity2.EntertainEnd = new DateTime(2020, 11, 15, 00, 00, 00);
newActivity2.EnterainAddress = "1313 Disneyland Dr, Anaheim, CA 92802";
newActivity2.EntertainPhone = "(714)781-4636";
newActivity2.EntertainNotes = "Get to the park at 6:00";
newActivity2.EntertainNotifications = 1;
newActivity2.TripId = newTrip2.TripId;
conn.Insert(newActivity2);
#endregion
#region Flights Data
var newflight = new Flights_Table();
newflight.FlightNumber = "SWA123";
newflight.AirlineName = "Southwest";
newflight.DepartTime = new DateTime(2020, 11, 12, 1, 45, 00);
newflight.ArriveTime = new DateTime(2020, 11, 12, 3, 30, 00);
newflight.DepartLocation = "SLC";
newflight.ArriveLocation = "LAX";
newflight.DepartGate = "A5";
newflight.FlightNotifications = 1;
newflight.TripId = newTrip2.TripId;
conn.Insert(newflight);
var newflight1 = new Flights_Table();
newflight1.FlightNumber = "SWA987";
newflight1.AirlineName = "Southwest";
newflight1.DepartTime = new DateTime(2020, 11, 17, 8, 00, 00);
newflight1.ArriveTime = new DateTime(2020, 11, 17, 10, 10, 00);
newflight1.DepartLocation = "LAX";
newflight1.ArriveLocation = "SLC";
newflight1.DepartGate = "G13";
newflight1.FlightNotifications = 0;
newflight1.TripId = newTrip2.TripId;
conn.Insert(newflight1);
#endregion
#region Lodging Data
var newLodge = new Lodging_Table();
newLodge.LodgeName = "Best Western Plus Pavilions";
newLodge.LodgeLocation = "1176 W Katella Ave, Anaheim, CA 92802";
newLodge.LodgePhone = "(714)776-0140";
newLodge.LodgeStart = new DateTime(2020, 11, 12, 11, 00, 00);
newLodge.LodgeEnd = new DateTime(2020, 11, 15, 9, 00, 00);
newLodge.LodgeNotifications = 1;
newLodge.TripId = newTrip2.TripId;
conn.Insert(newLodge);
var newLodge1 = new Lodging_Table();
newLodge1.LodgeName = "Best Western Plus Stovals";
newLodge1.LodgeLocation = "1100 W Katella Ave, Anaheim, CA 92802";
newLodge1.LodgePhone = "(714)776-5555";
newLodge1.LodgeStart = new DateTime(2020, 11, 15, 11, 00, 00);
newLodge1.LodgeEnd = new DateTime(2020, 11, 17, 9, 00, 00);
newLodge1.LodgeNotifications = 0;
newLodge1.TripId = newTrip2.TripId;
conn.Insert(newLodge1);
#endregion
#region Transportation Data
var newRental = new Transportation_Table();
newRental.RentalName = "Hertz";
newRental.ConfNumber = "1E0C2G";
newRental.PickUpDate = new DateTime(2020, 11, 12);
newRental.ReturnDate = new DateTime(2020, 11, 17);
newRental.PickUpLocation = "Los Angeles International Airport";
newRental.ReturnLocation = "Los Angeles International Airport";
newRental.RentalPhone = "(555)888-5555";
newRental.RentalNotifications = 1;
newRental.TripId = newTrip2.TripId;
conn.Insert(newRental);
#endregion
}
}
