public void LoadWorkOrderDetails(int row)
{
if (WorkOrderGrid.GetRow(row) is WorkOrders item)
{
cboEmployeeId.EditValue = item.Employees?.Id;
txtPosition.Text = item.Employees?.Position;
txtOffice.Text = item.Employees?.Offices?.OfficeName;
txtPropNo.EditValue = item.PPEs?.PropertyNo;
dtRequestedDate.EditValue = item.RequestedDate;
cboEquipmentType.EditValue = item.PPEs?.EquipmentTypeId;
txtDescription.Text = item.PPEs?.Description;
lblPODescription.Text = item.WorkOrderId + " - " + item.PPEs?.PPEId + " - " + item.PPEs?.EquipmentTypes?.EquipmentType;
txtFindings.Text = item.Findings;
txtProblems.Text = item.Problem;
txtRecommendation.Text = item.Recommendation;
lblBox.Text = item.Box?.ToString();
this.WOId = item.Id;
this.WorkOrders = item;
lblFolderNo.Text = item.FolderNo;
txtDeliveredDescription.Text = item.DeliveredDescription;
cboDeliveredBy.EditValue = item.DeliveredBy;
this.DocumentBindingSource.DataSource =
new UnitOfWork().DocumentsRepo.Get(m => m.RefId == item.Id && m.TableName == "WorkOrders");
backgroundWorker = new BackgroundWorker();
backgroundWorker.DoWork += (a, b) =>
{
this.Invoke(new Action(() =>
{
LoadActions();
LoadTechEvalSheet();
}));
};
backgroundWorker.RunWorkerAsync();
}
}
public void LoadWorkOrders()
{
UnitOfWork unitOfWork = new UnitOfWork();
Search();
this.EmployeeBindingSource.DataSource = unitOfWork.EmployeesRepo.Get();
this.EquipmentTypeBindingSource.DataSource = unitOfWork.EquipmentTypesRepo.Get();
this.ProgramLookUpRepo.DataSource = unitOfWork.DropdownsRepo.Get(m => m.Category == "Programs");
this.MainActLookUpRepo.DataSource = unitOfWork.DropdownsRepo.Get(m => m.Category == "Projects");
this.ActivityLookUpRepo.DataSource = unitOfWork.DropdownsRepo.Get(m => m.Category == "Activity");
this.SubActLookUpRepo.DataSource = unitOfWork.DropdownsRepo.Get(m => m.Category == "SubActivity");
this.txtSearch.Properties.DataSource = new UnitOfWork().WorkOrdersRepo.Get(m => m.PPEId != null);
WorkOrderGrid.RefreshData();
backgroundWorker.RunWorkerCompleted += (s, eventArgs) =>
{
backgroundWorker = new BackgroundWorker();
backgroundWorker.DoWork += (a, b) =>
{
this.Invoke(new Action(() =>
{
LoadWorkOrderDetails(0);
}));
};
backgroundWorker.RunWorkerAsync();
};
}
public void LoadWorkOrders()
{
UnitOfWork unitOfWork = new UnitOfWork();
this.EmployeeBindingSource.DataSource = unitOfWork.EmployeesRepo.Get();
this.WorkOrderBindingSource.DataSource = unitOfWork.WorkOrdersRepo.Get(m => m.DocActions.Any(x => x.EndorsedTo == User.UserId));
this.EquipmentTypeBindingSource.DataSource = unitOfWork.EquipmentTypesRepo.Get();
WorkOrderGrid.RefreshData();
}
private void btnScan_Click(object sender, EventArgs e)
{
if (WorkOrderGrid.GetFocusedRow() is WorkOrders item)
{
frmScanner frmScanPO = new frmScanner(scanner =>
{
scanner.RefId = item.Id;
scanner.TableName = "WorkOrders";
});
}
}
private void btnEvalSheet_Click(object sender, EventArgs e)
{
if (WorkOrderGrid.GetFocusedRow() is WorkOrders item)
{
frmTechnicalEvalSheet frmTechnicalEvalSheet = new frmTechnicalEvalSheet()
{
WorkOrderId = item.Id
};
frmTechnicalEvalSheet.ShowDialog();
}
}
private void btnEditPo_Click(object sender, EventArgs e)
{
if (!User.UserInAction("Edit Work Order"))
{
return;
}
if (WorkOrderGrid.GetFocusedRow() is WorkOrders item)
{
frmAddEditWorkOrder frm = new frmAddEditWorkOrder(item, MethodType.Edit);
frm.ShowDialog();
}
}
private void btnScan_Click(object sender, EventArgs e)
{
if (!User.UserInAction("Work Order Scan Document"))
{
return;
}
frmScanner frmScanPO = new frmScanner(scanner =>
{
scanner.RefId = Convert.ToInt32((WorkOrderGrid.GetFocusedRow() as WorkOrders)?.Id);
scanner.TableName = "WorkOrders";
});
var res = frmScanPO.ShowDialogResult();
}
private void WorkOrderGrid_CustomDrawCell(object sender, DevExpress.XtraGrid.Views.Base.RowCellCustomDrawEventArgs e)
{
if (e.Column.Name == "WorkOrderId")
{
if (WorkOrderGrid.GetRow(e.RowHandle) is WorkOrders item)
{
// if (item.WOActions.OrderByDescending(m => m.Id)?.FirstOrDefault()?.Status == "")
var status = item.DocActions.OrderByDescending(m => m.Id)?.FirstOrDefault()?.Status;
var customValue = new UnitOfWork().StatusesRepo.Find(m => m.Value == status && m.TableName == "Status")?.CustomValue;
var color = System.Drawing.ColorTranslator.FromHtml(customValue);
e.Appearance.BackColor = color;
}
}
}
private void btnAction_Click(object sender, EventArgs e)
{
if (!User.UserInAction("Work Order Action"))
{
return;
}
if (WorkOrderGrid.GetFocusedRow() is WorkOrders item)
{
frmDocActions frm = new frmDocActions(tableName: "WorkOrders", refId: item.Id,
label: item?.Employees?.EmployeeName + " - " + item?.PPEs?.EquipmentTypes?.EquipmentType);
frm.ShowDialog();
Details(item);
}
}
public void Init()
{
var workOrders = new UnitOfWork().WorkOrdersRepo.Fetch(x => x.PPEId != null);
WorkOrderGrid.SelectRow(this.rowHandle);
WorkOrderGridControl.DataSource = new EntityServerModeSource()
{
QueryableSource = workOrders,
DefaultSorting = "Id DESC",
};
workOrdersBindingSource.DataSource = workOrders.ToList();
Details(workOrders.FirstOrDefault());
}
private void WorkOrderGrid_FocusedRowChanged(object sender, DevExpress.XtraGrid.Views.Base.FocusedRowChangedEventArgs e)
{
try
{
this.rowHandle = e.FocusedRowHandle;
if (WorkOrderGrid.GetFocusedRow() is WorkOrders item)
{
Details(item);
}
}
catch (Exception exception)
{
MessageBox.Show(exception.Message, exception.Message, MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void btnNewPO_Click(object sender, EventArgs e)
{
if (!User.UserInAction("New Work Order"))
{
return;
}
frmAddEditWorkOrder frm = new frmAddEditWorkOrder(null, MethodType.Add);
frmAddEditWorkOrder res = frm.ShowDialogResult() as frmAddEditWorkOrder;
Init();
var rowHandle = this.WorkOrderGrid.LocateByValue("Id", res.workOrders.Id);
WorkOrderGrid.FocusedRowHandle = rowHandle;
WorkOrderGrid.MakeRowVisible(rowHandle);
}
private void btnTS_Click(object sender, EventArgs e)
{
if (WorkOrderGrid.GetFocusedRow() is WorkOrders workOrders)
{
if (Application.OpenForms["FrmMain"] is FrmMain frmMain)
{
frmMain.pnlDashoard.Controls.Clear();
var ts = new frmTechSpecs()
{
Dock = DockStyle.Fill
};
frmMain.pnlDashoard.Controls.Add(ts);
ts.NewTS(workOrders);
}
}
}
private void btnPrintTR_Click(object sender, EventArgs e)
{
if (WorkOrderGrid.GetFocusedRow() is WorkOrders item)
{
item.PrintedBy = User.GetUserName();
Rpt.rptTechnicalReport rpt = new Rpt.rptTechnicalReport()
{
DataSource = new List <WorkOrders>()
{
item
}
};
rpt.CreateDocument();
Rpt.frmReportViewer frm = new Rpt.frmReportViewer(rpt);
frm.ShowDialog();
}
}
/*
* if (UcTechSpecGrid.GridView.GetFocusedRow() is TechSpecs item)
* {
* this.oldData = item;
* this.oldSelectedRow = UcTechSpecGrid.GridView.FocusedRowHandle;
* frmAddEditTechSpecs frm = new frmAddEditTechSpecs()
* {
* frmTechSpecs = this,
* TechSpecsId = Convert.ToInt32((UcTechSpecGrid.GridView.GetFocusedRow() as TechSpecs)?.Id),
* MethodType = MethodType.Edit
* };
* frm.ShowDialog();
* UcTechSpecGrid.CreateUcControl();
*
* TechSpecDetails.Details(item);
* lblPODescription.Text = item.TechSpecsId;
* ucTSEquipmentProfiles1.Details(item.Id, "TechSpecs");
* UcTechSpecGrid.GridView.SelectRow(this.oldSelectedRow);
* UcTechSpecGrid.GridView.FocusedRowHandle = this.oldSelectedRow;
* UcTechSpecGrid.GridView.MakeRowVisible(oldSelectedRow);
* }
*
*/
private void btnEditPo_Click(object sender, EventArgs e)
{
if (!User.UserInAction("Edit Work Order"))
{
return;
}
if (WorkOrderGrid.GetFocusedRow() is WorkOrders item)
{
this.rowHandle = WorkOrderGrid.FocusedRowHandle;
frmAddEditWorkOrder frm = new frmAddEditWorkOrder(item, MethodType.Edit);
frm.ShowDialog();
Details(item);
Init();
WorkOrderGrid.FocusedRowHandle = rowHandle;
WorkOrderGrid.SelectRow(rowHandle);
WorkOrderGrid.MakeRowVisible(rowHandle);
}
}
private void btnPrint_Click(object sender, EventArgs e)
{
if (WorkOrderGrid.GetFocusedRow() is WorkOrders item)
{
DocumentLedgerViewModel vm = new DocumentLedgerViewModel();
vm.WorkOrders = item;
vm.DocActions = vm.GetDocActions(item.Id);
vm.PrintedBy = User.GetUserName();
Rpt.rptDocumentLedger rpt = new Rpt.rptDocumentLedger()
{
DataSource = new List <DocumentLedgerViewModel>()
{
vm
}
};
rpt.CreateDocument();
Rpt.frmReportViewer frm = new Rpt.frmReportViewer(rpt);
frm.ShowDialog();
}
}
private void btnDelete_ButtonClick(object sender, DevExpress.XtraEditors.Controls.ButtonPressedEventArgs e)
{
if (WorkOrderGrid.GetFocusedRow() is WorkOrders item)
{
try
{
if (MessageBox.Show("Do you want to delete this?", "Delete", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.No)
{
return;
}
UnitOfWork unitOfWork = new UnitOfWork();
unitOfWork.WorkOrdersRepo.Delete(x => x.Id == item.Id);
unitOfWork.Save();
Init();
}
catch (Exception exception)
{
MessageBox.Show(exception.Message, exception.Message, MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}
