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 Button_Click(object sender, RoutedEventArgs e)
{
try
{
project objProject = project_ViewSource.View.CurrentItem as project;
if (objProject != null)
{
using (db dbTender = new db())
{
int idProject = objProject.id_project;
purchase_tender purchase_tender = new purchase_tender();
if (idProject > 0)
{
purchase_tender.id_project = idProject;
}
purchase_tender.name = txtName.Text;
//purchase_tender.code = Convert.ToInt16(txtCode.Text);
purchase_tender.comment = txtComment.Text;
purchase_tender_contact purchase_tender_contact = new purchase_tender_contact();
purchase_tender_contact.id_contact = Convert.ToInt32(objProject.id_contact);
purchase_tender_contact.id_contract = Convert.ToInt32(cbxContract.SelectedValue);
purchase_tender_contact.id_condition = Convert.ToInt32(cbxCondition.SelectedValue);
purchase_tender_contact.id_currencyfx = Convert.ToInt32(cbxCurrency.SelectedValue);
purchase_tender.purchase_tender_contact_detail.Add(purchase_tender_contact);
int id = ((project)projectDataGrid.SelectedItem).id_project;
// List<project_task> productlist = entity.db.project_task.Where(x => x.id_project == id && x.items.id_item_type != item.item_type.Task && x.selected == true).ToList();
foreach (project_task data in Project_task)
{
purchase_tender_item purchase_tender_item = new purchase_tender_item();
//purchase_tender_item.id_cost_center = dbTender.app_cost_center.Where(a => a.id_company == _Setting.company_ID && a.is_active == true && a.is_administrative == true).FirstOrDefault().id_cost_center;
int idItem = data.items.id_item;
purchase_tender_item.id_item = idItem;
purchase_tender_item.item_description = dbTender.items.Where(a => a.id_item == idItem).FirstOrDefault().name;
purchase_tender_item.quantity = (decimal)data.quantity_est;
purchase_tender.purchase_tender_item_detail.Add(purchase_tender_item);
}
dbTender.purchase_tender.Add(purchase_tender);
dbTender.SaveChanges();
//dbTender.Entry(purchase_tender).State = EntityState.Detached;
//entity.db.purchase_tender.Attach(purchase_tender);
}
lblCancel_MouseDown(null, null);
}
else
{
MessageBox.Show("Error in getting Project details.", "Cognitivo", MessageBoxButton.OK, MessageBoxImage.Error);
}
}
catch { }
}
private void purchase_tender_item_detailDataGrid_LoadingRowDetails(object sender, DataGridRowDetailsEventArgs e)
{
if (purchase_tenderpurchase_tender_item_detailViewSource != null)
{
if (purchase_tenderpurchase_tender_item_detailViewSource.View != null)
{
purchase_tender_item purchase_tender_item = (purchase_tender_item)purchase_tenderpurchase_tender_itemViewSource.View.CurrentItem;
CollectionViewSource purchase_tender_dimensionViewSource = ((CollectionViewSource)(FindResource("purchase_tender_dimensionViewSource")));
if (purchase_tender_item != null)
{
if (purchase_tender_item.id_purchase_tender_item > 0)
{
purchase_tender_dimensionViewSource.Source = PurchaseTenderDB.purchase_tender_dimension.Where(x => x.id_purchase_tender_item == purchase_tender_item.id_purchase_tender_item).ToList();
}
}
}
}
}
private void purchase_tender_itemDataGrid_LoadingRowDetails(object sender, EventArgs e)
{
if (purchase_tenderpurchase_tender_itemViewSource != null)
{
if (purchase_tenderpurchase_tender_itemViewSource.View != null)
{
purchase_tender_item purchase_tender_item = (purchase_tender_item)purchase_tenderpurchase_tender_itemViewSource.View.CurrentItem;
CollectionViewSource purchase_tender_dimensionViewSource = ((CollectionViewSource)(FindResource("purchase_tender_dimensionViewSource")));
if (purchase_tender_item != null)
{
if (purchase_tender_item.id_item > 0)
{
purchase_tender_dimensionViewSource.Source = purchase_tender_item.purchase_tender_dimension.ToList();
}
}
}
}
}
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);
}
}
}
}
