protected void SetMockLastBillingDateTime() { var controller = new eRestaurantController(); var info = controller.GetLastBillDate(); TB_SearchDate.Text = info.ToString("yyyy-MM-dd"); TB_SearchTime.Text = info.ToString("HH:mm:ss"); }
public void InsertWaiterInfo() { //the code that exists within this method //is a standard CRUD insert which you learned in AppDev 1 eRestaurantController controller = new eRestaurantController(); //load an instance of Waiter Waiter item = new Waiter(); item.WaiterID = 0; //identity field on SQL therefore set to 0 item.FirstName = FirstName.Text; item.LastName = LastName.Text; item.Phone = Phone.Text; item.Address = Address.Text; item.HireDate = DateTime.Parse(HiredDate.Text); if (string.IsNullOrEmpty(ReleaseDate.Text)) { item.ReleaseDate = null; } else { item.ReleaseDate = DateTime.Parse(ReleaseDate.Text); } //call the controller's Add method for the Waiter controller.Waiter_Add(item); //rebind the drop down list (WaiterList) so the new //waiter will appear in the list WaiterList.DataBind(); }
//INSERT public void InsertWaiterInfo() { //The code that exists within this method is a standard CRUD insert. //Similar to what was learned in APPDEV 1 eRestaurantController controller = new eRestaurantController(); //Load an instance of Waiter. Waiter insertWaiter = new Waiter(); insertWaiter.WaiterID = 0; insertWaiter.FirstName = FirstName.Text; insertWaiter.LastName = LastName.Text; insertWaiter.Phone = Phone.Text; insertWaiter.Address = Address.Text; insertWaiter.HireDate = DateTime.Parse(HiredDate.Text); //Check if the release date is Null/Empty if (string.IsNullOrEmpty(ReleaseDate.Text)) { insertWaiter.ReleaseDate = null; //This can be null becuase in the database it is set to "Nullable" } else { insertWaiter.ReleaseDate = DateTime.Parse(ReleaseDate.Text); } //Add waiter to the database. controller.Waiter_Add(insertWaiter); //Rebind the dropdown (WaiterList) so the new entry will appear in the list. WaiterList.DataBind(); }
public void GetWaiterInfo() { eRestaurantController controller = new eRestaurantController(); var waiter = controller.GetWaiter(int.Parse(WaiterList.SelectedValue)); WaiterID.Text = waiter.WaiterID.ToString(); FirstName.Text = waiter.FirstName; LastName.Text = waiter.LastName; Phone.Text = waiter.Phone; Address.Text = waiter.Address; HiredDate.Text = waiter.HireDate.ToShortDateString(); if (waiter.ReleaseDate.HasValue) ReleaseDate.Text = waiter.ReleaseDate.Value.ToShortDateString(); }