public void FillWorkOrderList()
{
List <string[]> lineItemData = DataLayer.GetTableData("WorkOrder");
string[] columns = { "WorkOrder_ID", "dateRequired", "Customer_customer_ID", "Quantity" };
List <string[]> workOrderData = DataLayer.GetTableData("WorkOrder", columns);
foreach (String[] row in workOrderData)
{
string[] columns1 = { "STLProduct_STLProduct_ID" };
DataLayer.RemoveCriteria();
DataLayer.SetCriteria("WorkOrder_WorkOrder_ID", row[0]);
List <string[]> workOrderData1 = DataLayer.GetTableData("WorkOrder_has_STLProduct", "WorkOrder", columns1);
foreach (String[] row1 in workOrderData1)
{
Guid uid = Guid.NewGuid();
GenericFactory <IWorkOrder> .Register(uid, () => new WorkOrder(Convert.ToInt16(row[0]), Convert.ToInt16(row[2]), Convert.ToInt16(row1[0]), Convert.ToInt16(row[3]), DateTime.ParseExact(row[1], "dd/MM/yyyy", null)));
IWorkOrder workOrder = GenericFactory <IWorkOrder> .Create(uid);
workOrderList.Add(workOrder);
}
}
}
public async Task <IWorkOrder> Update(IWorkOrder entity)
{
try
{
TWorkOrder tEntity = entity as TWorkOrder;
var errors = await this.ValidateEntityToUpdate(tEntity);
if (errors.Count() > 0)
{
await this.ThrowEntityException(errors);
}
this.StartTransaction();
await base.Update(tEntity, x => new
{
x.AssignedUserRoleId,
x.BatchName,
x.ScanDate,
x.PageNo,
x.ReferenceNo,
x.MRNo,
x.PatientName,
x.DOSDate,
x.Amount,
x.ClientDoctorName,
x.ReferingDoctorName,
x.Comments,
x.WorkOrderStatusId,
x.RequestTypeId,
x.ProcessId,
x.FacilityId,
x.ModifiedBy,
x.ModifiedDate
});
this.CommitTransaction();
return(tEntity);
}
catch (PostgresException ex)
{
throw new EntityUpdateException(ex);
}
catch
{
throw;
}
}
public CustomerOrderBookingController(IStockBookingQuery bookingQuery,
ILogger <CustomerOrderBookingController> logger,
IWorkOrder workOrderController,
IStockBookingCommand command,
ISalesOrderQuery saleOrderQuery,
IWorkOrdersFactory workOrderFactory,
IStockBookingFactory factory)
{
_logger = logger;
_bookingQuery = bookingQuery;
_salesOrderQuery = saleOrderQuery;
_bookingCommand = command;
_bookingFactory = factory;
_workOrderController = workOrderController;
_workOrderFactory = workOrderFactory;
}
public async Task <IWorkOrder> AddNew(IWorkOrder entity)
{
try
{
this.StartTransaction();
TWorkOrder tEntity = entity as TWorkOrder;
var savedEntity = await base.AddNew(entity as TWorkOrder);
this.CommitTransaction();
return(savedEntity);
}
catch (PostgresException ex)
{
throw new EntityUpdateException(ex);
}
catch
{
throw;
}
}
public async Task <IWorkOrder> AddNew(IWorkOrder entity, long loggedUserId)
{
TWorkOrder tEntity = entity as TWorkOrder;
var errors = await this.ValidateEntityToAdd(tEntity);
if (errors.Count() > 0)
{
await this.ThrowEntityException(errors);
}
try
{
this.StartTransaction();
if (tEntity.AssignedUserId > 0)
{
tEntity.WorkOrderStatusId = 2;
}
tEntity.CreatedBy = loggedUserId;
tEntity.CreatedDate = DateTime.Now;
var savedEntity = await base.AddNew(tEntity);
long workOrderId = savedEntity.Id;
this.CommitTransaction();
await this.SaveTicketStatusHistory(workOrderId, true, tEntity.WorkOrderStatusId, loggedUserId);
return(savedEntity);
}
catch (PostgresException ex)
{
throw new EntityUpdateException(ex);
}
catch
{
throw;
}
}
public async Task <IWorkOrder> Update(IWorkOrder entity, long loggedUserId)
{
try
{
TWorkOrder tEntity = entity as TWorkOrder;
var errors = await this.ValidateEntityToUpdate(tEntity);
if (errors.Count() > 0)
{
await this.ThrowEntityException(errors);
}
var isSaveStatusHistoryRequired = false;
if (tEntity.WorkOrderStatusId == 1 && tEntity.AssignedUserId > 0)
{
tEntity.WorkOrderStatusId = 2;
isSaveStatusHistoryRequired = true;
}
tEntity.ModifiedBy = loggedUserId;
tEntity.ModifiedDate = DateTime.Now;
this.StartTransaction();
await base.Update(tEntity, x => new
{
x.AssignedUserRoleId,
x.AssignedUserId,
x.BatchName,
x.ScanDate,
x.PageNo,
x.ReferenceNo,
x.MRNo,
x.PatientName,
x.DOSDate,
x.Amount,
x.ClientDoctorName,
x.ReferingDoctorName,
x.Comments,
x.WorkOrderStatusId,
x.RequestTypeId,
x.ProcessId,
x.FacilityId,
x.ModifiedBy,
x.ModifiedDate
});
if (isSaveStatusHistoryRequired)
{
await this.SaveTicketStatusHistory(tEntity.Id, false, tEntity.WorkOrderStatusId, loggedUserId);
}
this.CommitTransaction();
return(tEntity);
}
catch (PostgresException ex)
{
throw new EntityUpdateException(ex);
}
catch
{
throw;
}
}
