protected void WaiterInsert_Click(object sender, EventArgs e)
{
//inline version of using MessageUserControl
MessageUserControl.TryRun(() =>
//remainder of the code is what would have gone in the external method of
//(ProcessRequest(MethodName))
{
Waiter item = new Waiter();
item.FirstName = FirstName.Text;
item.LastName = LastName.Text;
item.Address = Address.Text;
item.Phone = Phone.Text;
item.HireDate = DateTime.Parse(HireDate.Text);
//What about nullable field
if (string.IsNullOrEmpty(ReleaseDate.Text))
{
item.ReleaseDate = null;
}
else
{
item.ReleaseDate = DateTime.Parse(ReleaseDate.Text);
}
AdminController sysmgr = new AdminController();
WaiterID.Text = sysmgr.Waiters_Add(item).ToString();
MessageUserControl.ShowInfo("Waiter added.");
WaiterList.DataBind();
RefreshWaiterList(WaiterID.Text);
}
);
}
public void InsertWaiterInfo()
{
//the code that exsits withen this method is a standered CRUD insert form AppDev1
eRestaurantController controller = new eRestaurantController();
//load an instance of contorller
Waiter item = new Waiter();
item.WaiterID = 0;//identity feild for 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();
}
//UPDATE
public void UpdateWaiterInfo()
{
//The code that exists within this method is a standard CRUD update.
//Similar to what was learned in APPDEV 1
eRestaurantController controller = new eRestaurantController();
//Load an instance of Waiter.
Waiter updateWaiter = new Waiter();
updateWaiter.WaiterID = int.Parse(WaiterList.SelectedValue);
updateWaiter.FirstName = FirstName.Text;
updateWaiter.LastName = LastName.Text;
updateWaiter.Phone = Phone.Text;
updateWaiter.Address = Address.Text;
updateWaiter.HireDate = DateTime.Parse(HiredDate.Text);
//Check if the release date is Null/Empty
if (string.IsNullOrEmpty(ReleaseDate.Text))
{
updateWaiter.ReleaseDate = null; //This can be null becuase in the database it is set to "Nullable"
}
else
{
updateWaiter.ReleaseDate = DateTime.Parse(ReleaseDate.Text);
}
//Add waiter to the database.
controller.Waiter_Update(updateWaiter);
//Rebind the dropdown (WaiterList) so the new entry will appear in the list.
WaiterList.DataBind();
}
protected void RefreshWaiterList(string selectedvalue)
{
//force a requery of
WaiterList.DataBind();
WaiterList.Items.Insert(0, "Select waiter");
WaiterList.SelectedValue = selectedvalue;
}
protected void RefreshwaiterList(String selectedValue)
{
// force a requery of the dropdown list
WaiterList.DataBind();
WaiterList.Items.Insert(0, "Select a Waiter");
//position on a waiter in the list
WaiterList.SelectedValue = selectedValue;
}
protected void RefreshWaiterList(string selectedvalue)
{
//force the re-execution of the query for the drop down list
WaiterList.DataBind();
//insert the prompt line into the drop down list
WaiterList.Items.Insert(0, "Select a waiter");
//position the WaiterList to the desired row reprenenting the waiter
WaiterList.SelectedValue = selectedvalue;
}
protected void RefreshWaiterList(string selectedvalue)
{
//force a requery of the DDL
WaiterList.DataBind();
//insert the prompt line
WaiterList.Items.Insert(0, "Select a Waiter");
//position on a waiter in the list
WaiterList.SelectedValue = selectedvalue;
}
protected void RefreshWaiterList(String selectedvalue) //2015.10.21
{
//force the re-execution of the query for the drop down list
WaiterList.DataBind(); //databind and evalbind()?
// insert the prompt line into the drop down list data
WaiterList.Items.Insert(0, "Select a waiter");
// position the waiterlist to the desired row representing the waiter
WaiterList.SelectedValue = selectedvalue;
}
protected void RefreshWaiterList(string selectedvalue)
{
//force the re-execution for the dropdown list
WaiterList.DataBind();
// Insert the prompt line into the dropdown list data
WaiterList.Items.Insert(0, "Select a Waiter");
//Position the waiter list to the Desired row representing the waiter
WaiterList.SelectedValue = selectedvalue;
}
protected void WaiterUpdate_Click(object sender, EventArgs e)
{
if (string.IsNullOrEmpty(WaiterID.Text))
{
MessageUserControl.ShowInfo("Please selece a waiter first before update.");
}
else
{
//standard update process
MessageUserControl.TryRun(() =>
//remainder of the code is what would have gone in the external method of
//(ProcessRequest(MethodName))
{
Waiter item = new Waiter();
//for an update you must supply the pkey value
item.WaiterID = int.Parse(WaiterID.Text);
item.FirstName = FirstName.Text;
item.LastName = LastName.Text;
item.Address = Address.Text;
item.Phone = Phone.Text;
item.HireDate = DateTime.Parse(HireDate.Text);
//What about nullable field
if (string.IsNullOrEmpty(ReleaseDate.Text))
{
item.ReleaseDate = null;
}
else
{
item.ReleaseDate = DateTime.Parse(ReleaseDate.Text);
}
AdminController sysmgr = new AdminController();
sysmgr.Waiters_Update(item);
MessageUserControl.ShowInfo("Waiter updated.");
WaiterList.DataBind();
RefreshWaiterList(WaiterID.Text);
}
);
}
}
protected void RefreshWaiterList(string selectedvalue)
{
WaiterList.DataBind();
WaiterList.Items.Insert(0, "Select a waiter");
WaiterList.SelectedValue = selectedvalue;
}
