public static ItemTypes AddItemType(int evid, string type, bool isImpt, DAL dalDataContext)
{
Table<ItemTypes> typeTable = dalDataContext.itemTypes;
ItemTypes newItemType = new ItemTypes(evid, type, isImpt);
typeTable.InsertOnSubmit(newItemType);
typeTable.Context.SubmitChanges();
return newItemType;
}
public Items(ItemTypes t, string itemName, int sat, decimal est)
{
this.eventID = t.EventID;
this.typeName = t.typeString;
this.itemName = itemName;
this.satisfaction = sat;
this.estimatedPrice = est;
this.actualPrice = 0;
}
public static ItemTypes AddItemType(User user, int evid, string type, bool isImpt)
{
if (!user.isAuthorized( EventController.GetEvent(evid), EnumFunctions.Manage_ItemTypes))
throw new FaultException<SException>(new SException(),
new FaultReason("Invalid User, User Does Not Have Rights To Add Items!"));
ItemTypes iType = GetItemType(evid, type);
if (iType == null)
{
DAL dalDataContext = new DAL();
Table<ItemTypes> typeTable = dalDataContext.itemTypes;
ItemTypes newItemType = new ItemTypes(evid, type, isImpt);
typeTable.InsertOnSubmit(newItemType);
typeTable.Context.SubmitChanges();
return newItemType;
}
else
{
throw new FaultException<SException>(new SException(),
new FaultReason("Item type already exist!"));
}
}
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!"));
}
}
public static void deleteItemType(User user, ItemTypes type)
{
if (!user.isAuthorized( EventController.GetEvent(type.EventID), EnumFunctions.Manage_ItemTypes))
throw new FaultException<SException>(new SException(),
new FaultReason("Invalid User, User Does Not Have Rights To Delete Guest!"));
DAL dalDataContext = new DAL();
try
{
ItemTypes itemType = (from iType in dalDataContext.itemTypes
where iType.EventID == type.EventID
&& iType.typeString == type.typeString
select iType).FirstOrDefault<ItemTypes>();
dalDataContext.itemTypes.DeleteOnSubmit(itemType);
dalDataContext.SubmitChanges();
}
catch
{
throw new FaultException<SException>(new SException(),
new FaultReason("An Error occured While Deleting Item Type, Please Try Again!"));
}
}
public static void setItemTypeImportance(User user, ItemTypes type, bool isImpt)
{
if (!user.isAuthorized( EventController.GetEvent(type.EventID), EnumFunctions.Manage_ItemTypes))
throw new FaultException<SException>(new SException(),
new FaultReason("Invalid User, User Does Not Have Rights To Edit this Guest!"));
try
{
DAL dalDataContext = new DAL();
ItemTypes matchedItem = (from iten in dalDataContext.itemTypes
where iten.EventID == type.EventID
&& iten.typeString == type.typeString
select iten).FirstOrDefault<ItemTypes>();
if (matchedItem == null)
{
throw new FaultException<SException>(new SException(),
new FaultReason("Invalid Item Type"));
}
else
{
matchedItem.IsImportantType = isImpt;
dalDataContext.SubmitChanges();
}
}
catch
{
throw new FaultException<SException>(new SException(),
new FaultReason("An Error occured While Updating Item Type, Please Try Again!"));
}
}
private void btnAddItemType_Click(object sender, RoutedEventArgs e)
{
String itemType2Add = "";
if (radItemType.IsChecked == true)
{
if (cboItemType.SelectedIndex == -1)
{
MessageBox.Show("Please Select an Item Type!");
}
itemType2Add = cboItemType.SelectedItem.ToString();
}
else
{
//Save to item type repository here
itemType2Add = txtOthers.Text.ToString().Trim();
refreshItemTypes();
}
//check if got already
for (int i = 0; i < lvItemType.Items.Count; i++)
{
ItemTypes itemtype = (ItemTypes)lvItemType.Items[i];
if (itemtype.typeString == itemType2Add)
{
MessageBox.Show("Item type already added");
return;
}
}
//lvItemType.AddNewItemType(user, event_, itemType2Add, chkNecessary.IsChecked.Value);
//lvItemType.Items.Add("Column1Text").SubItems.AddRange(row1);
ItemTypes it = new ItemTypes();
it.typeString = itemType2Add;
it.IsImportantType = chkNecessary.IsChecked.Value;
lvItemType.Items.Add(it);
rebindcboItemType4Item();
clearItemTypeInput();
}
public static List<Items> GetItemsList(ItemTypes type)
{
DAL dalDataContext = new DAL();
List<Items> itemList = (from iten in dalDataContext.items
where iten.EventID == type.EventID
&& iten.typeString == type.typeString
select iten).ToList<Items>();
return itemList;
}
private static Items GetItem(ItemTypes type, string name)
{
DAL dalDataContext = new DAL();
Items matchedItem = (from item in dalDataContext.items
where item.typeString == type.typeString
&& item.EventID == type.EventID
&& item.ItemName == name
select item).FirstOrDefault<Items>();
return matchedItem;
}
public void SetItemTypeImportance(User user, ItemTypes type, Boolean isImpt)
{
ItemTypesController.setItemTypeImportance(user, type, isImpt);
}
//Event Specific Item
public Items AddEventItem(User user, ItemTypes type, string name, int sat, decimal est)
{
return ItemsController.AddItem(user, type, name, sat, est);
}
public void DeleteEventItemType(User user, ItemTypes type)
{
ItemTypesController.deleteItemType(user, type);
}