public void Item_Select(object sender, EventArgs e)
{
purchase_tender purchase_tender = purchase_tenderViewSource.View.CurrentItem as purchase_tender;
if (purchase_tender != null)
{
item item = PurchaseTenderDB.items.Where(x => x.id_item == sbxItem.ItemID).FirstOrDefault();
if (item != null)
{
//Checks if product exists.
if (purchase_tender.purchase_tender_item_detail.Where(x => x.id_item == item.id_item).Count() == 0)
{
purchase_tender_item purchase_tender_item = new purchase_tender_item();
purchase_tender_item.item = item;
purchase_tender_item.id_item = item.id_item;
purchase_tender_item.item_description = item.name;
purchase_tender_item.quantity = 1;
foreach (item_dimension item_dimension in item.item_dimension)
{
purchase_tender_dimension purchase_tender_dimension = new purchase_tender_dimension();
purchase_tender_dimension.purchase_tender_item = purchase_tender_item;
purchase_tender_dimension.id_dimension = item_dimension.id_app_dimension;
purchase_tender_dimension.id_measurement = item_dimension.id_measurement;
if (PurchaseTenderDB.app_dimension.Where(x => x.id_dimension == item_dimension.id_app_dimension).FirstOrDefault() != null)
{
purchase_tender_dimension.app_dimension = PurchaseTenderDB.app_dimension.Where(x => x.id_dimension == item_dimension.id_app_dimension).FirstOrDefault();
}
purchase_tender_dimension.app_measurement = item_dimension.app_measurement;
purchase_tender_dimension.value = item_dimension.value;
purchase_tender_item.purchase_tender_dimension.Add(purchase_tender_dimension);
}
purchase_tender.purchase_tender_item_detail.Add(purchase_tender_item);
}
else
{
toolBar.msgWarning("Product Exists");
}
}
else
{
if (sbxItem.Text != string.Empty)
{
purchase_tender_item purchase_tender_item = new purchase_tender_item();
purchase_tender_item.item_description = sbxItem.Text;
purchase_tender_item.quantity = 1;
purchase_tender.purchase_tender_item_detail.Add(purchase_tender_item);
}
}
purchase_tenderViewSource.View.Refresh();
purchase_tenderpurchase_tender_itemViewSource.View.Refresh();
}
}
private void UserControl_Loaded(object sender, RoutedEventArgs e)
{
if (!System.ComponentModel.DesignerProperties.GetIsInDesignMode(this))
{
try
{
CollectionViewSource app_dimensionViewSource = ((CollectionViewSource)(FindResource("app_dimensionViewSource")));
ProjectTaskDB.app_dimension.Where(a => a.id_company == CurrentSession.Id_Company).Load();
app_dimensionViewSource.Source = ProjectTaskDB.app_dimension.Local;
CollectionViewSource app_measurementViewSource = ((CollectionViewSource)(FindResource("app_measurementViewSource")));
ProjectTaskDB.app_measurement.Where(a => a.id_company == CurrentSession.Id_Company).Load();
app_measurementViewSource.Source = ProjectTaskDB.app_measurement.Local;
cmbtask.ItemsSource = project_taskList;
purchase_tender purchase_tender = new purchase_tender();
purchase_tender.status = Status.Documents_General.Pending;
purchase_tender.name = project_taskList.FirstOrDefault().project.name;
purchase_tender.code = 000;
purchase_tender.trans_date = DateTime.Now;
foreach (project_task project_task in project_taskList)
{
if (project_task.project.id_branch != null)
{
purchase_tender.app_branch = ProjectTaskDB.app_branch.Where(x => x.id_branch == project_task.project.id_branch).FirstOrDefault();
}
else
{
purchase_tender.app_branch = ProjectTaskDB.app_branch.Where(x => x.can_invoice == true && x.can_stock == true).FirstOrDefault();
}
if (purchase_tender.purchase_tender_item_detail.Where(x => x.id_item == project_task.id_item).Count() == 0)
{
purchase_tender.id_project = project_task.id_project;
purchase_tender_item purchase_tender_item = new purchase_tender_item();
purchase_tender_item.id_item = project_task.id_item;
purchase_tender_item.id_project_task = project_task.id_project_task;
purchase_tender_item.item_description = project_task.item_description;
purchase_tender_item.quantity = (decimal)project_task.quantity_est;
foreach (project_task_dimension project_task_dimension in project_task.project_task_dimension)
{
purchase_tender_dimension purchase_tender_dimension = new purchase_tender_dimension();
purchase_tender_dimension.id_dimension = project_task_dimension.id_dimension;
purchase_tender_dimension.id_measurement = project_task_dimension.id_measurement;
purchase_tender_dimension.value = 0;
purchase_tender_item.purchase_tender_dimension.Add(purchase_tender_dimension);
}
purchase_tender.purchase_tender_item_detail.Add(purchase_tender_item);
}
else
{
purchase_tender_item purchase_tender_item = purchase_tender.purchase_tender_item_detail.Where(x => x.id_item == project_task.id_item).FirstOrDefault();
purchase_tender_item.quantity = purchase_tender_item.quantity + (decimal)project_task.quantity_est;
}
}
ProjectTaskDB.purchase_tender.Add(purchase_tender);
CollectionViewSource purchase_tender_itemViewSource = (CollectionViewSource)this.FindResource("purchase_tender_itemViewSource");
ProjectTaskDB.purchase_tender_item_detail.Load();
purchase_tender_itemViewSource.Source = ProjectTaskDB.purchase_tender_item_detail.Local;
if (purchase_tender_itemViewSource != null)
{
if (purchase_tender_itemViewSource.View != null)
{
purchase_tender_itemViewSource.View.Filter = i =>
{
purchase_tender_item purchase_tender_item = (purchase_tender_item)i;
if (purchase_tender_item.id_purchase_tender_item == 0)
{
return(true);
}
else
{
return(false);
}
};
}
}
}
catch (Exception ex)
{
throw ex;
}
}
}
private void btnRequestResource_Click(object sender, EventArgs e)
{
if (project_taskViewSource.Source != null)
{
if (tabraw.IsSelected)
{
List <project_task> productlist = ProjectTaskDB.project_task.ToList();
productlist = productlist.Where(x => x.IsSelected == true).ToList();
if (ProjectTaskDB.project_task.Local.Where(x => x.IsSelected == true).Count() > 0)
{
PurchaseTender = new cntrl.Curd.PurchaseTender();
crud_modal.Visibility = Visibility.Visible;
PurchaseTender.ProjectTaskDB = ProjectTaskDB;
PurchaseTender.project_taskList = productlist;
crud_modal.Children.Add(PurchaseTender);
}
else
{
toolBar.msgWarning("Select a Task");
}
}
else
{
project project = ((project)projectViewSource.View.CurrentItem);
int id_project = ((project)projectViewSource.View.CurrentItem).id_project;
List <project_task> productlist = ProjectTaskDB.project_task.ToList();
productlist = productlist.Where(x => x.IsSelected == true).ToList();
purchase_tender purchase_tender = new purchase_tender();
purchase_tender.status = Status.Documents_General.Pending;
purchase_tender.name = project.name;
purchase_tender.code = 000;
purchase_tender.trans_date = DateTime.Now;
foreach (project_task project_task in productlist)
{
if (project.id_branch != null)
{
purchase_tender.app_branch = ProjectTaskDB.app_branch.Where(x => x.id_branch == project.id_branch).FirstOrDefault();
}
else
{
purchase_tender.app_branch = ProjectTaskDB.app_branch.Where(x => x.can_invoice == true && x.can_stock == true).FirstOrDefault();
}
purchase_tender.id_project = project_task.id_project;
purchase_tender_item purchase_tender_item = new purchase_tender_item();
purchase_tender_item.id_item = project_task.id_item;
purchase_tender_item.id_project_task = project_task.id_project_task;
purchase_tender_item.item_description = project_task.item_description;
purchase_tender_item.quantity = (decimal)project_task.quantity_est;
foreach (project_task_dimension project_task_dimension in project_task.project_task_dimension)
{
purchase_tender_dimension purchase_tender_dimension = new purchase_tender_dimension();
purchase_tender_dimension.id_dimension = project_task_dimension.id_dimension;
purchase_tender_dimension.id_measurement = project_task_dimension.id_measurement;
purchase_tender_dimension.value = project_task_dimension.value;
purchase_tender_item.purchase_tender_dimension.Add(purchase_tender_dimension);
}
purchase_tender.purchase_tender_item_detail.Add(purchase_tender_item);
}
ProjectTaskDB.purchase_tender.Add(purchase_tender);
if (ProjectTaskDB.SaveChanges() > 0)
{
toolBar.msgSaved(ProjectTaskDB.NumberOfRecords);
}
}
}
}
