protected void btnDeleteClient_Click(object sender, EventArgs e)
{
pageID = Convert.ToInt32(lblClientID.Text);
CharityKitchenServiceReference.CKServiceSoapClient svc = new CharityKitchenServiceReference.CKServiceSoapClient();
svc.DeleteClient(pageID);
Server.Transfer("Clients.aspx");
}
protected void ChangeIngredientUnit()
{
CharityKitchenServiceReference.CKServiceSoapClient svc = new CharityKitchenServiceReference.CKServiceSoapClient();
Unit = svc.ReturnStockUnit(drpIngredients.SelectedItem.Value);
if (Unit == 1)
{
lblUnit.Text = "KG";
}
else if (Unit == 2)
{
lblUnit.Text = "g";
}
else if (Unit == 3)
{
lblUnit.Text = "L";
}
else if (Unit == 4)
{
lblUnit.Text = "mL";
}
else
{
lblUnit.Text = "Por";
}
}
protected void AddRoleCombo()
{
CharityKitchenServiceReference.CKServiceSoapClient svc = new CharityKitchenServiceReference.CKServiceSoapClient();
int id = svc.GetLastUserID();
svc.AddRoleCombo(id, Convert.ToInt32(drpRoles.SelectedItem.Value), Convert.ToInt32(drpAccessLevel.SelectedItem.Value));
}
protected void AddIngredientToList()
{
CharityKitchenServiceReference.CKServiceSoapClient svc = new CharityKitchenServiceReference.CKServiceSoapClient();
svc.AddMealLine(Convert.ToInt32(lblMealID.Text), Convert.ToInt32(drpIngredients.SelectedItem.Value), Convert.ToInt32(txtQuantity.Text), Unit);
//will refresh the gridview
ViewMealIngredients();
}
protected void LoadRoles()
{
CharityKitchenServiceReference.CKServiceSoapClient svc = new CharityKitchenServiceReference.CKServiceSoapClient();
drpRoles.DataSource = svc.GetRoles();
drpRoles.DataTextField = "RoleDescription";
drpRoles.DataValueField = "RoleID";
drpRoles.DataBind();
}
protected void GetStockList()
{
CharityKitchenServiceReference.CKServiceSoapClient svc = new CharityKitchenServiceReference.CKServiceSoapClient();
drpIngredients.DataSource = svc.GetStockList();
drpIngredients.DataValueField = "StockID";
drpIngredients.DataTextField = "StockName";
drpIngredients.DataBind();
}
protected void AddStatesToDropDown()
{
CharityKitchenServiceReference.CKServiceSoapClient svc = new CharityKitchenServiceReference.CKServiceSoapClient();
drpState.DataSource = svc.GetStateList();
drpState.DataTextField = "StateName";
drpState.DataValueField = "StateID";
drpState.DataBind();
}
protected void GetUnitList()
{
CharityKitchenServiceReference.CKServiceSoapClient svc = new CharityKitchenServiceReference.CKServiceSoapClient();
drpUnits.DataSource = svc.GetMeasurementUnits();
drpUnits.DataTextField = "Shorthand";
drpUnits.DataValueField = "MeasurementUnitID";
drpUnits.DataBind();
}
protected void AddStock()
{
int qty = Convert.ToInt16(txtStockQuantity.Text);
CharityKitchenServiceReference.CKServiceSoapClient svc = new CharityKitchenServiceReference.CKServiceSoapClient();
svc.AddNewStock(txtStockName.Text, qty, drpUnits.SelectedIndex + 1, txtStockDescription.Text);
ClearTheFields();
}
protected void GetMealList()
{
CharityKitchenServiceReference.CKServiceSoapClient svc = new CharityKitchenServiceReference.CKServiceSoapClient();
drpMeals.DataSource = svc.GetMealNames();
drpMeals.DataValueField = "MealID";
drpMeals.DataTextField = "MealName";
drpMeals.DataBind();
}
protected void LoadUserRoleInfo()
{
int id = Convert.ToInt32(gvResult.Rows[RowIndex].Cells[2].Text);
CharityKitchenServiceReference.CKServiceSoapClient svc = new CharityKitchenServiceReference.CKServiceSoapClient();
drpRoles.SelectedIndex = (int)svc.GetRoleCombo(id)[0] - 1;
drpAccessLevel.SelectedIndex = (int)svc.GetRoleCombo(id)[1];
}
protected void AddOrderLinesToDB()
{
CharityKitchenServiceReference.CKServiceSoapClient svc = new CharityKitchenServiceReference.CKServiceSoapClient();
for (int i = OrderLines.Rows.Count - 1; i >= 0; i--)
{
DataRow OrderLine = OrderLines.Rows[i];
svc.AddOrderLine(Convert.ToInt32(lblID.Text), Convert.ToInt32(OrderLine["MealID"]), Convert.ToDecimal(OrderLine["MealPrice"]));
}
}
protected void GetOrderInfo()
{
CharityKitchenServiceReference.CKServiceSoapClient svc = new CharityKitchenServiceReference.CKServiceSoapClient();
calDelDate.SelectedDate = (DateTime)svc.GetOrderInfo(Convert.ToInt32(lblID.Text))[0];
clientID = (int)svc.GetOrderInfo(Convert.ToInt32(lblID.Text))[1];
lblOrderTotal.Text = svc.GetOrderInfo(Convert.ToInt32(lblID.Text))[2].ToString();
lblOrderDate.Text = svc.GetOrderInfo(Convert.ToInt32(lblID.Text))[3].ToString();
lblClientFirstName.Text = svc.GetClientName(clientID)[0].ToString();
lblClientLastName.Text = svc.GetClientName(clientID)[1].ToString();
}
protected void gvResults_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
CharityKitchenServiceReference.CKServiceSoapClient svc = new CharityKitchenServiceReference.CKServiceSoapClient();
int id = Convert.ToInt32(gvResults.Rows[rowIndex].Cells[2].Text);//NEED A METHOD TO DELETE RELATED ORDERLINES OR IT SHITS ITSELF
DeleteOrderLines(id);
DeleteOrder(id);
gvResults.DataSource = svc.GetAllOrders();
gvResults.DataBind();
}
protected void GetStockInfo()
{
int id = Convert.ToInt16(lblStockID.Text);
CharityKitchenServiceReference.CKServiceSoapClient svc = new CharityKitchenServiceReference.CKServiceSoapClient();
txtStockName.Text = svc.GetStockInfo(id)[0].ToString();
txtQuantity.Text = svc.GetStockInfo(id)[1].ToString();
drpUnits.SelectedIndex = (int)svc.GetStockInfo(id)[2] - 1;
txtDescription.Text = svc.GetStockInfo(id)[3].ToString();
}
protected void SaveCurrentEdit()
{
pageID = Convert.ToInt32(lblClientID.Text);
DateTime dt = Convert.ToDateTime(txtDOB.Text);
CharityKitchenServiceReference.CKServiceSoapClient svc = new CharityKitchenServiceReference.CKServiceSoapClient();
svc.SaveClientEdit(txtFirstName.Text, txtLastName.Text, dt, txtPhoneNumber.Text, txtEmail.Text, txtAddress.Text, Convert.ToInt32(drpState.SelectedItem.Value), txtSuburb.Text, txtPostcode.Text, pageID);
lblUserMessage.Text = "Client edit was successful";
System.Threading.Thread.Sleep(2000);
Server.Transfer("Clients.aspx");
}
protected void LoadUserInfo()
{
int id = Convert.ToInt32(gvResult.Rows[RowIndex].Cells[2].Text);
CharityKitchenServiceReference.CKServiceSoapClient svc = new CharityKitchenServiceReference.CKServiceSoapClient();
lblID.Text = id.ToString();
txtUsername.Text = svc.GetUserInfo(id)[1].ToString();
txtFirstName.Text = svc.GetUserInfo(id)[2].ToString();
txtLastName.Text = svc.GetUserInfo(id)[3].ToString();
txtPassword.Text = svc.GetUserInfo(id)[4].ToString();
}
protected void DeleteMeal()
{
CharityKitchenServiceReference.CKServiceSoapClient svc = new CharityKitchenServiceReference.CKServiceSoapClient();
svc.DeleteMeal(Convert.ToInt32(lblMealID.Text));
GetAllMeals();
if (CurrentIndex != 1)
{
GetPrevious();
}
else
{
GetNext();
}
}
protected void DeleteStock()
{
CharityKitchenServiceReference.CKServiceSoapClient svc = new CharityKitchenServiceReference.CKServiceSoapClient();
if (svc.DeleteStock(Convert.ToInt16(lblStockID.Text)))
{
Server.Transfer("Stock.aspx");
}
else
{
lblInfo.ForeColor = System.Drawing.Color.Red;
lblInfo.Text = "*Cannot delete item because it is used in a meal";
}
}
protected void ChangeClient()
{
try
{
clientID = Convert.ToInt32(txtID.Text);
lblID.Text = txtID.Text;
CharityKitchenServiceReference.CKServiceSoapClient svc = new CharityKitchenServiceReference.CKServiceSoapClient();
lblClientFirstName.Text = svc.GetClientName(clientID)[0].ToString();
lblClientLastName.Text = svc.GetClientName(clientID)[1].ToString();
}
catch
{
//Server.Transfer("GeneralError.aspx");
}
}
protected void AddStatesToDropDown()
{
try
{
CharityKitchenServiceReference.CKServiceSoapClient svc = new CharityKitchenServiceReference.CKServiceSoapClient();
drpState.DataSource = svc.GetStateList();
drpState.DataTextField = "StateName";
drpState.DataValueField = "StateID";
drpState.DataBind();
}
catch (Exception ex)
{
lblInfo.Text = ex.ToString();
}
}
protected void ViewMealIngredients()
{
int id = AllMeals[MealIndex].ID;
try
{
CharityKitchenServiceReference.CKServiceSoapClient svc = new CharityKitchenServiceReference.CKServiceSoapClient();
gvResults.DataSource = svc.GetMealLinesByID(id);
gvResults.DataBind();
}
catch
{
lblInfo.ForeColor = System.Drawing.Color.Red;
lblInfo.Text = "This meal has no ingredients set";
}
}
protected void GetClientInfo()
{
try
{
clientID = Convert.ToInt32(txtID.Text);
CharityKitchenServiceReference.CKServiceSoapClient svc = new CharityKitchenServiceReference.CKServiceSoapClient();
//Converting all data into textboxes etc.
lblClientFirstName.Text = svc.GetClientInfo(clientID)[1].ToString();
lblClientLastName.Text = svc.GetClientInfo(clientID)[2].ToString();
}
catch
{
//Server.Transfer("GeneralError.aspx");
}
}
protected bool AddOrderToDB()
{
bool Success = true;
if (CheckForDeliveryDate() && CheckForClient())
{
CharityKitchenServiceReference.CKServiceSoapClient svc = new CharityKitchenServiceReference.CKServiceSoapClient();
svc.AddOrder(calDelDate.SelectedDate, Convert.ToInt32(txtID.Text), Convert.ToDecimal(lblOrderTotal.Text), Convert.ToDateTime(lblCurrentDate.Text));//ADDS THE ORDER
lblID.Text = svc.GetLastOrderID();
}
else
{
Success = false;
}
return(Success);
}
protected void gvResult_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
if (Convert.ToInt32(gvResult.Rows[RowIndex].Cells[3].Text) != 1)
{
CharityKitchenServiceReference.CKServiceSoapClient svc = new CharityKitchenServiceReference.CKServiceSoapClient();
svc.DeleteUserRole(Convert.ToInt32(gvResult.Rows[RowIndex].Cells[3].Text));
svc.DeleteUser(Convert.ToInt32(gvResult.Rows[RowIndex].Cells[2].Text));
}
else
{
lblInfo.ForeColor = System.Drawing.Color.Red;
lblInfo.Text = "*You cannot delete a Master";
}
LoadAllUserAccounts();
}
protected void AddClientToDB()
{
int state = drpState.SelectedIndex;
CharityKitchenServiceReference.CKServiceSoapClient svc = new CharityKitchenServiceReference.CKServiceSoapClient();
try
{
svc.AddNewClient(txtFirstName.Text, txtLastName.Text, Convert.ToDateTime(txtDOB.Text), txtPhoneNumber.Text, txtEmail.Text, txtAddress.Text, state, txtSuburb.Text, txtPostcode.Text);
lblInfo.ForeColor = System.Drawing.Color.Green;
lblInfo.Text = "*Client successfully added";
}
catch
{
lblInfo.ForeColor = System.Drawing.Color.Red;
lblInfo.Text = "*Please check all fields are entered correctly.";
}
}
protected void QuickEditStockQty()
{
try
{
int _qty = Convert.ToInt16(txtQuickEditUnits.Text);
int _id = Convert.ToInt16(txtQuickEditID.Text);
CharityKitchenServiceReference.CKServiceSoapClient svc = new CharityKitchenServiceReference.CKServiceSoapClient();
svc.QuickEditStockQty(_qty, _id);
txtQuickEditID.Text = "*Enter Stock ID*";
txtQuickEditUnits.Text = "*Updated Quantity*";
lblInfo.Text = "*SUCCESSFUL OPERATION";
}
catch
{
lblInfo.Text = "*Incorrect value type entered";
}
}
protected void btnLogin_Click(object sender, EventArgs e)
{
lblInfo.Text = "Logging in...";
var svc = new CharityKitchenServiceReference.CKServiceSoapClient();
var user = svc.UserLogin(txtUsername.Text, txtPassword.Text);
if (user.ID > 0)
{
Session["user"] = user;
Response.Redirect("~/Default.aspx");
}
else
{
lblInfo.ForeColor = System.Drawing.Color.Red;
lblInfo.Text = "Invalid credentials";
}
}
private void OpenEditStockWindow()
{
try
{
CharityKitchenServiceReference.CKServiceSoapClient svc = new CharityKitchenServiceReference.CKServiceSoapClient();
if (svc.ValidateStockID(Convert.ToInt32(txtStockID.Text)))
{
HttpContext.Current.Items["idData"] = txtStockID.Text; //holds data from the client ID wanting to be edited
Server.Transfer("StockEdit.aspx"); //sends the data to the page and opens page
}
else
{
lblInfo.Text = "*Stock ID not found, please enter valid ID";
}
}
catch
{
lblInfo.Text = "*Stock ID not found, please enter valid ID";
}
}
protected void OpenEditClientScreen()
{
try
{
CharityKitchenServiceReference.CKServiceSoapClient svc = new CharityKitchenServiceReference.CKServiceSoapClient();
if (svc.ValidateClientID(Convert.ToInt32(txtClientID.Text)))
{
HttpContext.Current.Items["idData"] = txtClientID.Text; //holds data from the client ID wanting to be edited
Server.Transfer("ClientEdit.aspx"); //sends the data to the page and opens page
}
else
{
lblClientIDErrors.Text = "*Client ID not found, please enter valid ID";
}
}
catch
{
lblClientIDErrors.Text = "*Client ID not found, please enter valid ID";
}
}
