private void btnApprove_Click(object sender, RoutedEventArgs e)
{
item_request item_request = item_requestViewSource.View.CurrentItem as item_request;
//Search User.
security_user security_user = new security_user();
//Load User Name and Department.
if (ItemDB.security_user.Where(x => x.id_user == CurrentSession.Id_User).FirstOrDefault() != null)
{
security_user = ItemDB.security_user.Where(x => x.id_user == CurrentSession.Id_User).FirstOrDefault();
item_request.request_user = security_user;
item_request.security_user = security_user;
item_request.id_department = security_user.security_role.id_department;
}
//Get Branch.
if (ItemDB.app_branch.Where(x => x.id_branch == CurrentSession.Id_Branch).FirstOrDefault() != null)
{
item_request.id_branch = ItemDB.app_branch.Where(x => x.id_branch == CurrentSession.Id_Branch).FirstOrDefault().id_branch;
}
item_request.name = security_user.name + " Request";
ItemDB.SaveChanges();
//Creates a new Request
item_request item_request_New = new item_request();
ItemDB.item_request.Add(item_request_New);
item_requestViewSource.View.MoveCurrentTo(item_request_New);
}
public void item_request_Click(object sender)
{
if (dgvMaintainceDetail.ItemsSource != null)
{
List <item_asset_maintainance_detail> item_asset_maintainance_detaillist = db.db.item_asset_maintainance_detail.ToList();
item_asset_maintainance_detaillist = item_asset_maintainance_detaillist.Where(x => x.IsSelected == true).ToList();
item_request item_request = new item_request();
item_request.name = ItemRequest.name;
item_request.comment = ItemRequest.comment;
item_request.id_department = ItemRequest.id_department;
item_request.request_date = DateTime.Now;
foreach (item_asset_maintainance_detail data in item_asset_maintainance_detaillist)
{
item_request_detail item_request_detail = new entity.item_request_detail();
item_request_detail.date_needed_by = ItemRequest.neededDate;
item_request_detail.id_maintainance_detail = data.id_maintainance_detail;
item_request_detail.urgency = ItemRequest.Urgencies;
int idItem = data.item.id_item;
item_request_detail.id_item = idItem;
item item = db.db.items.Where(x => x.id_item == idItem).FirstOrDefault();
if (item != null)
{
item_request_detail.item = item;
item_request_detail.comment = item_request_detail.item.name;
}
item_request_detail.quantity = data.quantity;
item_request.item_request_detail.Add(item_request_detail);
}
db.db.item_request.Add(item_request);
db.db.SaveChanges();
//item_requestViewSource.View.Filter = i =>
//{
// item_request _item_request = (item_request)i;
// if (_item_request.id_production_order == id_production_order)
// return true;
// else
// return false;
//};
}
crud_modal_request.Children.Clear();
crud_modal_request.Visibility = System.Windows.Visibility.Collapsed;
}
private void toolBar_btnNew_Click(object sender)
{
item_request item_request = new item_request();
item_request.IsSelected = true;
// dbContext.sales_invoice.Local.Add(sales_invoice);
dbContext.Entry(item_request).State = EntityState.Added;
item_request.State = EntityState.Added;
item_requestViewSource.View.MoveCurrentToLast();
}
private void toolBar_btnEdit_Click(object sender)
{
if (item_requestDataGrid.SelectedItem != null)
{
item_request item_request_old = (item_request)item_requestDataGrid.SelectedItem;
item_request_old.IsSelected = true;
item_request_old.State = EntityState.Modified;
dbContext.Entry(item_request_old).State = EntityState.Modified;
}
else
{
toolBar.msgWarning("Please Select an Item");
}
}
private void toolBar_btnCancel_Click(object sender)
{
// dbContext.CancelAllChanges();
if (item_requestDataGrid.SelectedItem != null)
{
item_request item_request = (item_request)item_requestDataGrid.SelectedItem;
item_request.State = EntityState.Unchanged;
dbContext.Entry(item_request).State = EntityState.Unchanged;
}
else
{
toolBar.msgWarning("Please Select an Item");
}
}
private void toolBar_btnSearch_Click(object sender, string query)
{
if (!string.IsNullOrEmpty(query) && item_requestViewSource != null)
{
try
{
item_requestViewSource.View.Filter = i =>
{
item_request item_request = i as item_request;
if (item_request != null)
{
//Protect the code against null values.
//string number = item_request.number != null ? item_request.number : "";
string name = item_request.name != null ? item_request.name : "";
if ((name.ToLower().Contains(query.ToLower()))
)
{
return(true);
}
else
{
return(false);
}
}
else
{
return(false);
}
};
}
catch //(Exception ex)
{
//throw ex;
}
}
else
{
item_requestViewSource.View.Filter = null;
}
}
private void sbxItem_Select(object sender, RoutedEventArgs e)
{
if (sbxItem.ItemID > 0)
{
item item = ItemDB.items.Where(x => x.id_item == sbxItem.ItemID).FirstOrDefault();
if (item != null)
{
item_request item_request = item_requestViewSource.View.CurrentItem as item_request;
if (item_request != null)
{
item_request_detail item_request_detail = new item_request_detail();
item_request_detail.id_item = sbxItem.ItemID;
item_request_detail.item = item;
item_request_detail.quantity = 1;
item_request_detail.urgency = entity.item_request_detail.Urgencies.Medium;
item_request.item_request_detail.Add(item_request_detail);
item_requestitem_request_detailViewSource.View.Refresh();
}
}
}
}
public void item_request_Click(object sender)
{
production_order production_order = ((production_order)production_orderViewSource.View.CurrentItem);
int id_production_order = ((production_order)production_orderViewSource.View.CurrentItem).id_production_order;
if (itemDataGrid.ItemsSource != null)
{
List <production_order_detail> production_order_detaillist = OrderDB.production_order_detail.ToList();
production_order_detaillist = production_order_detaillist.Where(x => x.IsSelected == true).ToList();
item_request item_request = new item_request();
item_request.name = ItemRequest.name;
item_request.comment = ItemRequest.comment;
item_request.id_department = ItemRequest.id_department;
item_request.id_production_order = id_production_order;
if (production_order.id_project != null)
{
project project = OrderDB.projects.Where(x => x.id_project == production_order.id_project).FirstOrDefault();
item_request.id_project = production_order.id_project;
item_request.id_branch = production_order.id_branch;
}
item_request.request_date = DateTime.Now;
foreach (production_order_detail data in production_order_detaillist.Where(x => x.IsSelected == true))
{
item_request_detail item_request_detail = new entity.item_request_detail();
item_request_detail.date_needed_by = ItemRequest.neededDate;
item_request_detail.id_order_detail = data.id_order_detail;
item_request_detail.urgency = ItemRequest.Urgencies;
int idItem = data.item.id_item;
item_request_detail.id_item = idItem;
item item = OrderDB.items.Where(x => x.id_item == idItem).FirstOrDefault();
if (item != null)
{
item_request_detail.item = item;
item_request_detail.comment = item_request_detail.item.name;
}
if (data.project_task != null)
{
item_request_detail.id_project_task = data.project_task.id_project_task;
List <project_task_dimension> project_task_dimensionList = OrderDB.project_task_dimension.Where(x => x.id_project_task == data.project_task.id_project_task).ToList();
foreach (project_task_dimension project_task_dimension in project_task_dimensionList)
{
item_request_dimension item_request_dimension = new item_request_dimension();
item_request_dimension.id_dimension = project_task_dimension.id_dimension;
item_request_dimension.id_measurement = project_task_dimension.id_measurement;
item_request_dimension.value = project_task_dimension.value;
string comment = item_request_detail.item.name;
comment += project_task_dimension.value.ToString();
comment += "X";
item_request_detail.comment = comment.Substring(0, comment.Length - 1);
item_request_detail.item_request_dimension.Add(item_request_dimension);
}
}
item_request_detail.quantity = data.quantity;
item_request.item_request_detail.Add(item_request_detail);
}
OrderDB.item_request.Add(item_request);
OrderDB.SaveChanges();
//item_requestViewSource.View.Filter = i =>
//{
// item_request _item_request = (item_request)i;
// if (_item_request.id_production_order == id_production_order)
// return true;
// else
// return false;
//};
}
crud_modal_request.Children.Clear();
crud_modal_request.Visibility = System.Windows.Visibility.Collapsed;
}
