//Constructor public MakeAPayment(AggActiveAccount prof) { InitializeComponent(); profile = prof; CopyObject2Form(profile); this.Show(); }
public void CopyObject2Form(string movieSelect, AggActiveAccount prof, double moviePrice, int rentLength) { movieTitle_TXT.Text = movieSelect; currentBal_TXT.Text = prof.Balance.ToString(); afterBal_TXT.Text = Convert.ToString((prof.Balance) + (moviePrice)); dueDateBox.Text = Convert.ToString(DateTime.Now.AddDays(rentLength)); }
//Constructor public AccountInfo(AggActiveAccount prof) { InitializeComponent(); this.Show(); profile = prof; CopyObject2Form(prof); }
private void login_BTN_Click(object sender, EventArgs e) { userProfile = new AggActiveAccount(); DataTable memberData = new DataTable(); //Creates DataTable with all relevant user information memberData = AggActiveAccount.CreateAggDataTable(loginUserBox.Text, loginPassBox.Text); //if username/pass combo does not exist if (memberData.Rows.Count == 0) { MessageBox.Show("The username or password are invalid."); loginPassBox.Text = " "; } else //User is authenticated { DataRow memberInfo = memberData.Rows[0]; userProfile.PopulateProfile(memberData.Rows[0]); string MemberIDString = Convert.ToString(memberInfo["MemberID"]); string LoginIDString = Convert.ToString(memberInfo["MemID"]); string isAdminString = Convert.ToString(memberInfo["IsAdmin"]); //Checks if user is Member or Admin and opens appropriate Home Page if (LoginIDString == MemberIDString & isAdminString != "True") { this.Hide(); new MemberHome(userProfile); } else if (LoginIDString == MemberIDString & isAdminString == "True") { this.Hide(); new AdminHome().Show(); } } }
public WishList(AggActiveAccount prof) { InitializeComponent(); this.Show(); profile = prof; //MovieList mList = new MovieList(prof); //mList.Hide(); }
//Constructor public Checkout(AggActiveAccount prof, string movieSelect, double moviePrice, int daysForRent) { InitializeComponent(); profile = prof; movie = movieSelect; price = moviePrice; rentLength = daysForRent; CopyObject2Form(movieSelect, profile, moviePrice, rentLength); }
public void CopyObject2Form(AggActiveAccount prof) { firstName_TXT.Text = prof.FName; lastName_TXT.Text = prof.LName; address1_TXT.Text = prof.Address1; address2_TXT.Text = prof.Address2; city_TXT.Text = prof.City; state_TXT.Text = prof.State; zip_TXT.Text = prof.Zip.ToString(); phone_TXT.Text = prof.Phone; cardNum_TXT.Text = prof.CardNum.ToString(); memStatus_TXT.Text = prof.MemStatus; paymentType_TXT.Text = prof.PaymentType.ToString(); //Date joined..? birthDate_TXT.Text = prof.DateOfBirth.ToString(); }
public void CopyObject2Form(AggActiveAccount profile) { MemID_TXT.Text = profile.MemId.ToString(); firstName_TXT.Text = profile.FName; lastName_TXT.Text = profile.LName; address1_TXT.Text = profile.Address1; address2_TXT.Text = profile.Address2; city_TXT.Text = profile.City; state_TXT.Text = profile.State; zip_TXT.Text = profile.Zip.ToString(); phone_TXT.Text = profile.Phone.ToString(); accountID_TXT.Text = profile.AccId.ToString(); memStatus_TXT.Text = profile.MemStatus; balance_TXT.Text = profile.Balance.ToString(); cardNum_TXT.Text = profile.CardNum.ToString(); paymentType_TXT.Text = profile.PaymentType.ToString(); }
private void RunConfirmOrderSqlStatement(AggActiveAccount prof, string movieSelect, double moviePrice) { prof.Balance = Convert.ToDouble(afterBal_TXT.Text); //SQL Statement for processing movie order string sqlProfileCreate = //updating active user account balance by subtracting the movie price (math is already done in copyObjectToForm method) "update Account " + "set Balance = '" + Convert.ToDouble(afterBal_TXT.Text) + "' " + "where AccountID = '" + prof.AccId + "' " + //creating a new transaction "declare @movieID int " + "set @movieID = (select movieID from Movie where Title = '" + movieSelect + "') " + "insert into Transactions(AccountID, MovieID, RewardID, RentDate, DueDate, Total) " + "values('"+ prof.AccId + "', @movieID, null, GETDATE(), '"+dueDateBox.Text+"', '"+moviePrice+"')"; //Establishes connection with SQL DB string dbStr = "Data Source = mis220.eil-server.cba.ua.edu; Initial Catalog = MovieRental; user id = uamis; password=RollTide"; SqlConnection dbCon = new SqlConnection(dbStr); try { //non-query SqlCommand cmdIns = new SqlCommand(sqlProfileCreate, dbCon); dbCon.Open(); cmdIns.ExecuteNonQuery(); cmdIns.Parameters.Clear(); cmdIns.Dispose(); cmdIns = null; } //catch(Exception ex)//need to write exceptions finally { dbCon.Close(); MessageBox.Show("Your order has been confirmed! Thank you for your business!"); this.Hide(); MovieList movieListForm = new MovieList(profile); movieListForm.Show(); } }
public AggActiveAccount CopyForm2Object() { AggActiveAccount profile = new AggActiveAccount(); profile.MemId = Convert.ToInt32(MemID_TXT.Text); profile.FName = firstName_TXT.Text; profile.LName = lastName_TXT.Text; profile.Address1 = address1_TXT.Text; profile.Address2 = address2_TXT.Text; profile.City = city_TXT.Text; profile.State = state_TXT.Text; profile.Zip = Convert.ToInt32(zip_TXT.Text); profile.Phone = phone_TXT.Text; profile.AccId = Convert.ToInt32(accountID_TXT.Text); profile.MemStatus = memStatus_TXT.Text; profile.Balance = Convert.ToDouble(balance_TXT.Text); profile.CardNum = Convert.ToInt64(cardNum_TXT); profile.PaymentType = Convert.ToInt32(paymentType_TXT); return profile; }
public void CopyObject2Form(AggActiveAccount profile) { accBalBox2.Text = profile.Balance.ToString(); cardNumberBox.Text = profile.CardNum.ToString(); }
//Constructor public MovieList(AggActiveAccount prof) { InitializeComponent(); this.Show(); profile = prof; }
public MemberBackgroundForm(AggActiveAccount prof) { InitializeComponent(); CopyObject2Form(prof); }
//-------Constructors------------ public NewMemForm() { thisAGG = new AggActiveAccount(); InitializeComponent(); }