public static void SetBought(User user, Items iten)
{
//if (!user.isAuthorized(user, EventController.GetEvent(iten.EventID), EnumFunctions.Manage_Items))
// throw new FaultException<SException>(new SException(),
// new FaultReason("Invalid User, User Does Not Have Rights To Update Items properties!"));
try
{
DAL dalDataContext = new DAL();
OptimizedBudgetItemsDetails matchedItem = (from item in dalDataContext.optimizedBudgetItemDetails
where item.typeString == iten.typeString
&& item.EventID == iten.EventID
&& item.ItemName == iten.ItemName
select item).FirstOrDefault<OptimizedBudgetItemsDetails>();
if (matchedItem == null)
{
throw new FaultException<SException>(new SException(),
new FaultReason("Invalid Item "));
}
else
{
matchedItem.IsBought = true;
dalDataContext.SubmitChanges();
}
}
catch
{
throw new FaultException<SException>(new SException(),
new FaultReason("An Error occured While Updating Item, Please Try Again!"));
}
}
public static void deleteItem(User user, Items iten)
{
if (!user.isAuthorized( EventController.GetEvent(iten.EventID), EnumFunctions.Manage_Items))
throw new FaultException<SException>(new SException(),
new FaultReason("Invalid User, User Does Not Have Rights To Delete Item!"));
DAL dalDataContext = new DAL();
try
{
Items matchedItem = (from item in dalDataContext.items
where item.typeString == iten.typeString
&& item.EventID == iten.EventID
&& item.ItemName == iten.ItemName
select item).FirstOrDefault<Items>();
dalDataContext.items.DeleteOnSubmit(matchedItem);
dalDataContext.SubmitChanges();
}
catch
{
throw new FaultException<SException>(new SException(),
new FaultReason("An Error occured While Deleting Item , Please Try Again!"));
}
}
public static Items AddItem(int eventID, string type, string name, int sat, decimal est, DAL dalDataContext)
{
Table<Items> itemTable = dalDataContext.items;
Items newItem = new Items(eventID,type, name, sat, est);
itemTable.InsertOnSubmit(newItem);
itemTable.Context.SubmitChanges();
return newItem;
}
public static Items AddItem(User user, ItemTypes type, string name, int sat, decimal est)
{
if (!user.isAuthorized( EventController.GetEvent(type.EventID), EnumFunctions.Manage_Items))
throw new FaultException<SException>(new SException(),
new FaultReason("Invalid User, User Does Not Have Rights To Add Items!"));
if (GetItem(type, name) == null)
{
DAL dalDataContext = new DAL();
Table<Items> itemTable = dalDataContext.items;
Items newItem = new Items(type, name, sat, est);
itemTable.InsertOnSubmit(newItem);
itemTable.Context.SubmitChanges();
return newItem;
}
else
{
throw new FaultException<SException>(new SException(),
new FaultReason("Item already exist!"));
}
}
private void mapItem(Items Item2Edit)
{
txtItemName.Text = Item2Edit.ItemName;
cboItemTypeIL.SelectedValue = Item2Edit.typeString;
txtItemPrice.Text = Item2Edit.EstimatedPrice.ToString();
txtItemSatisfaction.Text = Item2Edit.Satisfaction.ToString();
}
private void btnEditItem_Click(object sender, RoutedEventArgs e)
{
//Items Item2Edit = lvItem.GetEditItem();
if (lvItem.SelectedIndex == -1)
{
MessageBox.Show("Please select an item!", "Information", MessageBoxButton.OK, MessageBoxImage.Information);
return;
}
string FunctionName = btnEditItem.Content.ToString().Trim();
if (FunctionName.CompareTo("Edit") == 0)
{
Items item = (Items)lvItem.Items[lvItem.SelectedIndex];
mapItem(item);
EnabledItemControl(false);
}
else
{
decimal price;
bool isdecimal = decimal.TryParse(txtItemPrice.Text, out price);
if (!isdecimal)
{
MessageBox.Show("Invalid price");
txtItemPrice.Text = "";
txtItemPrice.Focus();
return;
}
int satisfactionValue;
bool isInt = int.TryParse(txtItemSatisfaction.Text, out satisfactionValue);
if (!isInt)
{
MessageBox.Show("Invalid satisfaction value");
txtItemSatisfaction.Text = "";
txtItemSatisfaction.Focus();
return;
}
int index = lvItem.SelectedIndex;
lvItem.Items.RemoveAt(index);
Items i = new Items();
i.ItemName = txtItemName.Text;
i.typeString = ((ItemTypes)cboItemTypeIL.SelectedItem).typeString;
i.EstimatedPrice = price;
i.Satisfaction = satisfactionValue;
lvItem.Items.Insert(index, i);
//lvItem.EditItem(user, (ItemTypes)cboItemTypeIL.SelectedItem, price, satisfactionValue);
EnabledItemControl(true);
clearItemInput();
}
}
private void btnAddItem_Click(object sender, RoutedEventArgs e)
{
if (validateInput())
{
decimal price;
bool isdecimal = decimal.TryParse(txtItemPrice.Text, out price);
if (!isdecimal)
{
MessageBox.Show("Invalid price");
txtItemPrice.Text = "";
txtItemPrice.Focus();
return;
}
int satisfactionValue;
bool isInt = int.TryParse(txtItemSatisfaction.Text, out satisfactionValue);
if (!isInt)
{
MessageBox.Show("Invalid satisfaction value");
txtItemSatisfaction.Text = "";
txtItemSatisfaction.Focus();
return;
}
Items i = new Items();
i.ItemName = txtItemName.Text;
i.typeString = ((ItemTypes)cboItemTypeIL.SelectedItem).typeString;
i.EstimatedPrice = price;
i.Satisfaction = satisfactionValue;
lvItem.Items.Add(i);
//lvItem.AddNewItem(user, (ItemTypes)cboItemTypeIL.SelectedItem, txtItemName.Text, cboItemTypeIL.SelectedValue.ToString(), price, satisfactionValue);
clearItemInput();
}
else
{
MessageBox.Show("Invalid input!");
}
}
public static void UpdateSatifactionAndEstPrice(User user, Items iten, int sat, decimal est)
{
if (!user.isAuthorized( EventController.GetEvent(iten.EventID), EnumFunctions.Manage_Items))
throw new FaultException<SException>(new SException(),
new FaultReason("Invalid User, User Does Not Have Rights To Update this Item!"));
try
{
DAL dalDataContext = new DAL();
Items matchedItem = (from item in dalDataContext.items
where item.typeString == iten.typeString
&& item.EventID == iten.EventID
&& item.ItemName == iten.ItemName
select item).FirstOrDefault<Items>();
if (matchedItem == null)
{
throw new FaultException<SException>(new SException(),
new FaultReason("Invalid Item "));
}
else
{
matchedItem.Satisfaction = sat;
matchedItem.EstimatedPrice = est;
dalDataContext.SubmitChanges();
}
}
catch
{
throw new FaultException<SException>(new SException(),
new FaultReason("An Error occured While Updating Item, Please Try Again!"));
}
}
public static void UpdateActualPrice(User user, Items iten, decimal actual)
{
if (!user.isAuthorized( EventController.GetEvent(iten.EventID), EnumFunctions.Manage_ItemTypes))
throw new FaultException<SException>(new SException(),
new FaultReason("Invalid User, User Does Not Have Rights To Update Price!"));
try
{
DAL dalDataContext = new DAL();
Items matchedItem = (from item in dalDataContext.items
where item.typeString == iten.typeString
&& item.EventID == iten.EventID
&& item.ItemName == iten.ItemName
select item).FirstOrDefault<Items>();
if (matchedItem == null)
{
throw new FaultException<SException>(new SException(),
new FaultReason("Invalid Item "));
}
else
{
matchedItem.ActualPrice = actual;
dalDataContext.SubmitChanges();
BudgetDetailsController.SetBought(user, iten);
}
}
catch
{
throw new FaultException<SException>(new SException(),
new FaultReason("An Error occured While Updating Item, Please Try Again!"));
}
}
public BudgetItemState(Items item, bool isBought)
{
this.isBought = isBought;
this.item = item;
}
private void mapItem(Items Item2Edit)
{
OptimizedBudgetItemsDetails budgetItem = lvBItem.GetEditItem();
bool isbought = budgetItem.IsBought;
txtItemName.Text = Item2Edit.ItemName;
txtItemType.Text = Item2Edit.typeString;
txtItemPrice.Text = Item2Edit.EstimatedPrice.ToString("0.00");
txtItemSatisfaction.Text = Item2Edit.Satisfaction.ToString();
if (isbought)
{
txtItemActualPrice.Text = Item2Edit.ActualPrice.ToString("0.00");
}
else
txtItemActualPrice.Text = "N.A";
}
public void UpdateSatifactionAndEstPrice(User user, Items iten, int s, decimal est)
{
ItemsController.UpdateSatifactionAndEstPrice(user, iten, s, est);
}
public void UpdateActualPrice(User user, Items iten, decimal price)
{
ItemsController.UpdateActualPrice(user, iten, price);
}
public void DeleteEventItem(User user, Items iten)
{
ItemsController.deleteItem(user, iten);
}
