private void equipment_info_Click(object sender, RoutedEventArgs e)
{
// Go to equipment page, based on current Window
HomeWindow window = (HomeWindow)Window.GetWindow(this);
try
{
ResourceItem equipment = (ResourceItem)(sender as Button).DataContext;
window.goToEquipmentPage(equipment.Resource);
} catch (Exception exc)
{
KitItem kit = (KitItem)(sender as Button).DataContext;
window.goToKitPage(kit.Units[0]);
}
}
private void SubmitDeliveryResources()
{
int delID = -1;
if (SelectedProject == null)
{
return;
}
DataTable toDeliver = new DataTable();
toDeliver.Clear();
toDeliver.Columns.Add("ResourceID", typeof(int));
List <Resources> toDelete = new List <Resources>();
foreach (Resources resource in active_requisitions_list.Items)
{
var container = active_requisitions_list.ItemContainerGenerator.ContainerFromItem(resource) as FrameworkElement;
if (container == null)
{
active_requisitions_list.UpdateLayout();
active_requisitions_list.ScrollIntoView(resource);
container = active_requisitions_list.ItemContainerGenerator.ContainerFromItem(resource) as FrameworkElement;
}
ContentPresenter listBoxItemCP = Helpers.FindVisualChild <ContentPresenter>(container);
if (listBoxItemCP == null)
{
return;
}
DataTemplate dataTemplate = listBoxItemCP.ContentTemplate;
if (!((CheckBox)active_requisitions_list.ItemTemplate.FindName("active_checkbox", listBoxItemCP)).IsChecked ?? false)
{
continue;
}
toDelete.Add(resource);
DataRow row = toDeliver.NewRow();
row["ResourceID"] = resource.ResourceID;
toDeliver.Rows.Add(row);
}
if (toDeliver.Rows.Count == 0)
{
throw new Exception("You can't deliver 0 resources!");
}
delID = SubmitDelivery();
if (delID == -1)
{
throw new Exception("Error creating delivery");
}
cn = Helpers.getSGBDConnection();
if (!Helpers.verifySGBDConnection(cn))
{
throw new Exception("Error connecting to database");
}
SqlCommand cmd = new SqlCommand();
cmd.CommandType = CommandType.StoredProcedure;
cmd.Connection = cn;
SqlParameter listParam = cmd.Parameters.AddWithValue("@UnitsList", toDeliver);
listParam.SqlDbType = SqlDbType.Structured;
cmd.Parameters.AddWithValue("@delID", delID);
cmd.CommandText = "DML.DELIVER_RESOURCES";
try
{
cmd.ExecuteNonQuery();
foreach (Resources r in toDelete)
{
ActiveRequisitionsData.Remove(r);
if (typeof(ElectronicUnit).IsInstanceOfType(r))
{
ElectronicUnit unit = r as ElectronicUnit;
if (!addResourceItemUnit(unit))
{
ResourceItem ri = new ResourceItem(unit.Model);
ri.addUnit(unit);
ResourceItems.Add(ri);
ResourcesListData.Add(ri);
}
}
else if (typeof(Kit).IsInstanceOfType(r))
{
Kit unit = r as Kit;
if (!addKitItemUnit(unit))
{
KitItem ki = new KitItem(unit.Description);
ki.addUnit(unit);
KitItems.Add(ki);
ResourcesListData.Add(ki);
}
}
}
equipment_list.Items.Refresh();
}
catch (Exception ex)
{
throw ex;
}
finally
{
cn.Close();
}
}
private void SubmitRequisitionResources()
{
int reqID = -1;
if (SelectedProject == null)
{
throw new Exception("You have to select a project first!");
}
// List's to manage equipments for requisition
List <Resources> toBeRequested = new List <Resources>();
List <ListItem> toBeRemoved = new List <ListItem>();
DataTable toRequest = new DataTable();
toRequest.Clear();
toRequest.Columns.Add("ResourceID", typeof(int));
foreach (ListItem resource in equipment_list.Items)
{
var container = equipment_list.ItemContainerGenerator.ContainerFromItem(resource) as FrameworkElement;
if (container == null)
{
equipment_list.UpdateLayout();
equipment_list.ScrollIntoView(resource);
container = equipment_list.ItemContainerGenerator.ContainerFromItem(resource) as FrameworkElement;
}
ContentPresenter listBoxItemCP = Helpers.FindVisualChild <ContentPresenter>(container);
if (listBoxItemCP == null)
{
return;
}
DataTemplate dataTemplate = listBoxItemCP.ContentTemplate;
DecimalUpDown unitsTextBox = equipment_list.ItemTemplate.FindName("equipment_units", listBoxItemCP) as DecimalUpDown;
int units = int.Parse(unitsTextBox.Text);
if (units == 0)
{
continue;
}
unitsTextBox.Value = 0;
// Add chosen unit's number
while (units > 0)
{
Resources unit = null;
if (resource is ResourceItem)
{
ResourceItem r = resource as ResourceItem;
if (units > r.Units.Count)
{
throw new Exception("You cannot request more units than available!");
}
unit = r.requestUnit();
if (r.Units.Count == 0)
{
toBeRemoved.Add(r);
}
}
else if (resource is KitItem)
{
KitItem k = resource as KitItem;
if (units > k.Units.Count)
{
throw new Exception("You cannot request more units than available!");
}
unit = k.requestUnit();
if (k.Units.Count == 0)
{
toBeRemoved.Add(k);
}
}
toBeRequested.Add(unit);
DataRow row = toRequest.NewRow();
row["ResourceID"] = unit.ResourceID;
toRequest.Rows.Add(row);
units--;
}
}
if (toRequest.Rows.Count == 0)
{
throw new Exception("You can't request 0 resources!");
}
reqID = SubmitRequisition();
if (reqID == -1)
{
throw new Exception("Error creating requisition");
}
cn = Helpers.getSGBDConnection();
if (!Helpers.verifySGBDConnection(cn))
{
throw new Exception("Error connecting to database");
}
SqlCommand cmd = new SqlCommand();
cmd.CommandType = CommandType.StoredProcedure;
cmd.Connection = cn;
SqlParameter listParam = cmd.Parameters.AddWithValue("@UnitsList", toRequest);
listParam.SqlDbType = SqlDbType.Structured;
cmd.Parameters.AddWithValue("@reqID", reqID);
cmd.CommandText = "DML.REQUEST_RESOURCES";
try
{
cmd.ExecuteNonQuery();
foreach (Resources resource in toBeRequested)
{
ActiveRequisitionsData.Add(resource);
}
foreach (ListItem li in toBeRemoved)
{
ResourcesListData.Remove(li);
if (typeof(ResourceItem).IsInstanceOfType(li))
{
ResourceItem ri = li as ResourceItem;
ResourceItems.Remove(ri);
}
else if (typeof(KitItem).IsInstanceOfType(li))
{
KitItem ki = li as KitItem;
KitItems.Remove(ki);
}
}
equipment_list.Items.Refresh();
}
catch (Exception ex)
{
throw ex;
}
finally
{
cn.Close();
}
}
private void LoadAvailableResources()
{
cn = Helpers.getSGBDConnection();
if (!Helpers.verifySGBDConnection(cn))
{
throw new Exception("Cannot connect to database");
}
DataSet ds = new DataSet();
SqlCommand cmd = new SqlCommand("DML.RESOURCES_TO_REQUEST", cn);
cmd.CommandType = CommandType.StoredProcedure;
SqlDataAdapter da = new SqlDataAdapter(cmd);
da.Fill(ds);
cn.Close();
foreach (DataRow row in ds.Tables[0].Rows)
{
ElectronicResources resource = new ElectronicResources(
row["ProductName"].ToString(),
row["Manufacturer"].ToString(),
row["Model"].ToString(),
row["ResDescription"].ToString(),
null,
row["PathToImage"].ToString()
);
ElectronicUnit unit = new ElectronicUnit(
int.Parse(row["ResourceID"].ToString()),
resource,
row["Supplier"].ToString()
);
if (!addResourceItemUnit(unit))
{
Console.WriteLine(resource);
ResourceItem ri = new ResourceItem(resource);
ri.addUnit(unit);
ResourceItems.Add(ri);
}
}
foreach (DataRow row in ds.Tables[1].Rows)
{
Kit unit = new Kit(
int.Parse(row["ResourceID"].ToString()),
row["KitDescription"].ToString()
);
if (!addKitItemUnit(unit))
{
KitItem ki = new KitItem(unit.Description);
ki.addUnit(unit);
KitItems.Add(ki);
}
}
foreach (ResourceItem ri in ResourceItems)
{
ResourcesListData.Add(ri);
}
foreach (KitItem ki in KitItems)
{
ResourcesListData.Add(ki);
}
}
