public GetWorkOrderDetailsStatusQM Execute(GetWorkOrderDetailsStatusCM modelCM)
{
var response = new GetWorkOrderDetailsStatusQM();
using (var sqlCommand = CreateCommand())
{
sqlCommand.Connection = Connection;
sqlCommand.CommandText = "[dbo].[uspGetWorkOrderDetailsStatus]";
sqlCommand.CommandType = CommandType.StoredProcedure;
sqlCommand.Parameters.Add(AddParameter("@WONumber", SsDbType.VarChar, ParameterDirection.Input, modelCM.WorkOrderNumber));
sqlCommand.Parameters.Add(AddParameter("@WOSerial", SsDbType.Decimal, ParameterDirection.Input, modelCM.WorkOrderSerial));
using (var reader = SsDbCommandHelper.ExecuteReader(sqlCommand))
{
if (reader.Read())
{
response.Dc = Convert.ToBoolean(reader["Dc"]);
response.Invoice = Convert.ToBoolean(reader["Invoice"]);
response.SubContract = Convert.ToBoolean(reader["SubContract"]);
response.JTC = Convert.ToBoolean(reader["JTC"]);
}
}
}
return(response);
}
public GetWorkOrderDetailsStatusQM GetWorkOrderDetailsStatus(GetWorkOrderDetailsStatusCM modelCM)
{
var model = new GetWorkOrderDetailsStatusQM();
using (var connection = new DbConnectionProvider().CreateConnection())
{
connection.Open();
var command = new WorkOrderDetailsStatusSelectCommand {
Connection = connection
};
model = command.Execute(modelCM);
}
return(model);
}
public DeleteWorkOrderResponseDto DeleteWorkOrder(DeleteWorkOrderRequestDto deleteWorkOrderRequestDto)
{
// Section to verify, whether the particular order has delivered or not
GetWorkOrderDetailsStatusQM getWorkOrderDetailsStatusQM = new GetWorkOrderDetailsStatusQM();
GetWorkOrderDetailsStatusCM getWorkOrderDetailsStatusCM = new GetWorkOrderDetailsStatusCM
{
WorkOrderNumber = deleteWorkOrderRequestDto.WorkOrderNumber,
WorkOrderSerial = deleteWorkOrderRequestDto.WorkOrderSerial
};
getWorkOrderDetailsStatusQM = workOrderRepository.GetWorkOrderDetailsStatus(getWorkOrderDetailsStatusCM);
if (!getWorkOrderDetailsStatusQM.Dc)
{
workOrderRepository.DeleteWorkOrder(getWorkOrderDetailsStatusCM);
}
return(new DeleteWorkOrderResponseDto());
}
