private int GetNumFreePlacesInBatch(long idbatch, int idtemplate_method)
{
List <CBatch_detail_aa_twofold> lst = new CBatch_detail_aa_twofoldFactory().GetAll().Where(c => c.Idbatch == idbatch).ToList();
Methods oMethods = new Methods();
CTemplate_method_aa template_method_aa = new CTemplate_method_aaFactory().GetByPrimaryKey(new CTemplate_method_aaKeys(idtemplate_method));
return(Convert.ToInt32(template_method_aa.Limit_samples) - lst.Count);
}
private void InsertBatch(LinkedListNode <CBatch> node, CBatch_detail_aa_twofold sample)
{
if (node != null)
{
if (node.Next == null)
{
CBatch batch = node.Value;
List <CBatch_detail_aa_twofold> lst_tmp_samples = new List <CBatch_detail_aa_twofold>();
// --- seleccionar la lista de muestras del batch
CBatch_detail_aa_twofoldFactory faBatch_detail_aa_twofold = new CBatch_detail_aa_twofoldFactory();
List <CBatch_detail_aa_twofold> lst_samples =
new List <CBatch_detail_aa_twofold>(
faBatch_detail_aa_twofold.GetAll()
.Where(c => c.Idbatch == batch.Idbatch))
.OrderBy(c => c.Cod_interno).ToList();
// --- asignar nuevo idbatch a la muestra entrante
sample.Idbatch = batch.Idbatch;
faBatch_detail_aa_twofold.Update(sample);
}
else if (node.Next != null)
{
CBatch batch = node.Value;
List <CBatch_detail_aa_twofold> lst_tmp_samples = new List <CBatch_detail_aa_twofold>();
// --- seleccionar la lista de muestras del batch
CBatch_detail_aa_twofoldFactory faBatch_detail_aa_twofold = new CBatch_detail_aa_twofoldFactory();
List <CBatch_detail_aa_twofold> lst_samples =
new List <CBatch_detail_aa_twofold>(
faBatch_detail_aa_twofold.GetAll()
.Where(c => c.Idbatch == batch.Idbatch))
.OrderBy(c => c.Cod_interno).ToList();
// --- asignar nuevo idbatch a la muestra entrante
sample.Idbatch = batch.Idbatch;
faBatch_detail_aa_twofold.Update(sample);
// --- calcular el índice de la muestra a insertar
int i = lst_samples.Count - 1;
if (lst_samples[i].Flag_mri == 1)
{
i = i - 1;
}
CBatch_detail_aa_twofold sample_out = lst_samples[i];
// --- quitar la dirección del batch de la muestra saliente
sample_out.Idbatch = null;
faBatch_detail_aa_twofold.Update(sample_out);
InsertBatch(node.Next, sample_out);
}
}
}
public CDataBatch(long p_idbatch, int p_idtemplate_method, Comun.StatusWork statusWork, Comun.CriteriaSort criteriaSort)
{
Idtemplate_method = p_idtemplate_method;
Idbatch = p_idbatch;
TypeBatch = statusWork;
CriteriaSort = criteriaSort;
CBatch_detail_aa_twofoldFactory faBatch_detail_aa_twofold = new CBatch_detail_aa_twofoldFactory();
dtPivotBatch =
new BindingList<CBatch_detail_aa_twofold>(
faBatch_detail_aa_twofold
.GetAll()
.Where(c => c.Idbatch == p_idbatch && c.Idtemplate_method == p_idtemplate_method).ToList());
ExecuteQaqc(statusWork);
}
private long GetIndexMriPosition(long idbatch)
{
List <CBatch_detail_aa_twofold> lst = new CBatch_detail_aa_twofoldFactory().GetAll().Where(c => c.Idbatch == idbatch).ToList();
if (lst.Count > 0)
{
long min_cod_interno = Convert.ToInt64(lst.Min(c => c.Cod_interno));
long max_cod_interno = Convert.ToInt64(lst.Max(c => c.Cod_interno));
for (long i = min_cod_interno; i < max_cod_interno + 15; i++)
{
if (i % 15 == 6)
{
return(i);
}
}
}
return(0);
}
private long GetIndexMriPredecessor(long idbatch, long incoming_sample)
{
List <CBatch_detail_aa_twofold> lst = new CBatch_detail_aa_twofoldFactory().GetAll().Where(c => c.Idbatch == idbatch).ToList();
long cod_interno = incoming_sample;
long index_result = 0;
if (lst.Count > 0)
{
cod_interno = Convert.ToInt64(lst[0].Cod_interno);
}
for (long i = cod_interno; i < incoming_sample; i++)
{
if (i % 15 == 6)
{
index_result = i;
break;
}
}
return(index_result);
}
private void paNewTray_DragDrop(object sender, DragEventArgs e)
{
// --- get object column
DevExpress.XtraTreeList.Nodes.TreeListNode nodo = (DevExpress.XtraTreeList.Nodes.TreeListNode)e.Data.GetData(typeof(DevExpress.XtraTreeList.Nodes.TreeListNode));
CBatch_detail_aa_twofoldFactory faBatch_detail_aa_twofold = new CBatch_detail_aa_twofoldFactory();
CBatch_detail_aa_twofold sample = new CBatch_detail_aa_twofoldFactory().GetByPrimaryKey(new CBatch_detail_aa_twofoldKeys(Convert.ToInt64(nodo.GetValue("Idbatch_detail_aa"))));
CBatchManager oBatchManager = new CBatchManager();
long idbatch = Convert.ToInt64(oBatchManager.GetNewBatch(Idtemplate_method, Comun.GetUser(), Idbatch));
sample.Idbatch = idbatch;
faBatch_detail_aa_twofold.Update(sample);
// --- refrescar arbol
InitTreeBatch(Comun.StatusWork.Waiting);
}
private void treeTrayWaiting_AfterDragNode(object sender, DevExpress.XtraTreeList.NodeEventArgs e)
{
long id_drag = Convert.ToInt64(hi_drag.Node.GetValue("Idbatch_detail_aa"));
long id_over = Convert.ToInt64(hi_over.Node.GetValue("Idbatch_detail_aa"));
CBatch_detail_aa_twofold oBatch_detail_aa_twofold_drag = new CBatch_detail_aa_twofoldFactory().GetByPrimaryKey(new CBatch_detail_aa_twofoldKeys(id_drag));
CBatch_detail_aa_twofold oBatch_detail_aa_twofold_over = new CBatch_detail_aa_twofoldFactory().GetByPrimaryKey(new CBatch_detail_aa_twofoldKeys(id_over));
//List<CBatch> lstBatch = new CBatchFactory().GetAll().Where(c => Convert.ToChar(c.Status_process) == 'W').ToList();
CBatchManager batch_manager = new CBatchManager();
bool result_interchange = batch_manager.InterchangeSample(oBatch_detail_aa_twofold_drag, oBatch_detail_aa_twofold_over);
// --- refrescar arbol
InitTreeBatch(Comun.StatusWork.Waiting);
// expand parent nodes of drag and drop nodes
ExpandBatchNode(Convert.ToInt64(oBatch_detail_aa_twofold_drag.Idbatch));
ExpandBatchNode(Convert.ToInt64(oBatch_detail_aa_twofold_over.Idbatch));
}
void ApplyCriteriaSort()
{
CBatch_detail_aa_twofoldFactory faBatch_detail_aa_twofold = new CBatch_detail_aa_twofoldFactory();
// --- get by a criteria sort
var query = GetListByCriteriaSort();
// --- assign new order sample
short count = 1;
foreach (var varitem in query)
{
CBatch_detail_aa_twofold item = varitem as CBatch_detail_aa_twofold;
item.Order_sample_batch = count;
faBatch_detail_aa_twofold.Update(item);
count++;
}
// --- get source data
dtPivotBatch =
new BindingList<CBatch_detail_aa_twofold>(
faBatch_detail_aa_twofold
.GetAll()
.Where(c => c.Idbatch == Idbatch && c.Idtemplate_method == Idtemplate_method).ToList());
}
public void UpdateStatusResult(long p_idbatch, long p_idrecep_sample_detail, long p_idrecep_sample_detail_elem, short p_status_result, string p_str_result_analysis, decimal p_result_analysis)
{
CBatch_detail_aa_twofoldFactory faBatch_detail_aa_twofold = new CBatch_detail_aa_twofoldFactory();
List<CBatch_detail_aa_twofold> lst =
ListSamples.Where(c => c.Idbatch == p_idbatch
&& c.Idrecep_sample_detail == p_idrecep_sample_detail
&& c.Idrecep_sample_detail_elem == p_idrecep_sample_detail_elem).ToList();
foreach (CBatch_detail_aa_twofold item in lst)
{
item.Qaqc_review = true;
item.Qaqc_status_result = p_status_result;
faBatch_detail_aa_twofold.Update(item);
}
CRecep_sample_detail_elemFactory faRecep_sample_detail_elem = new CRecep_sample_detail_elemFactory();
List<CRecep_sample_detail_elem> lst2 =
faRecep_sample_detail_elem.GetAll().Where(c => c.Idrecep_sample_detail_elem == p_idrecep_sample_detail_elem).ToList();
foreach (CRecep_sample_detail_elem item in lst2)
{
item.Str_result_analysis = p_str_result_analysis;
item.Result_analysis = p_result_analysis;
faRecep_sample_detail_elem.Update(item);
}
}
public void Save(int position)
{
try
{
CBatch_detail_aa_twofold oBatch_detail_aa_twofold = ((BindingList<CBatch_detail_aa_twofold>)ListSamples)[position];
CBatch_detail_aa_twofoldFactory faBatch_detail_aa_twofold = new CBatch_detail_aa_twofoldFactory();
faBatch_detail_aa_twofold.Update(oBatch_detail_aa_twofold);
long Idrecep_sample_detail_elem = Convert.ToInt64(oBatch_detail_aa_twofold.Idrecep_sample_detail_elem);
// --- register in process,
LimsProcess.Advance_process(Idbatch, Idrecep_sample_detail_elem, LimsProcess.PROCESS_IN_READING);
}
catch (Exception ex)
{
Comun.Save_log(ex.InnerException.ToString());
//throw new Exception("pivot data row::update::Error occured.", ex);
}
}
public void Review()
{
try
{
CBatchFactory faBatch = new CBatchFactory();
CBatch oBatch = faBatch.GetByPrimaryKey(new CBatchKeys(Idbatch));
// --- save trace
CRecep_sample_detail_elemFactory faRecep_sample_detail_elem = new CRecep_sample_detail_elemFactory();
for (int i = 0; i < ListSamples.Count; i++)
{
CBatch_detail_aa_twofold current_row = ListSamples[i];
int status_result = Convert.ToInt32(current_row.Qaqc_status_result);
if (Convert.ToInt32(current_row.Flag_mri) == 0)
{
// --- set how accepted sample
// Espera = 0,
// Incorrecto = 1,
// Plausible = 2,
// Aceptado = 3,
// IncorrectoPlausible = 4,
// Espera reensayos = 5
// --- save only the accept samples
long Idrecep_sample_detail_elem = Convert.ToInt64(current_row.Idrecep_sample_detail_elem);
if (Convert.ToBoolean(oBatch.Flag_correct_mri) && Convert.ToBoolean(oBatch.Flag_correct_lrb))
{
if (status_result == Convert.ToInt32(Comun.Status_result.Plausible))
current_row.Qaqc_status_result = Convert.ToInt16(Comun.Status_result.Aceptado);
Qaqc oQaqc = new Qaqc();
if (!oQaqc.IsRetest(Idrecep_sample_detail_elem, Idbatch))
{
// --- save final element law
if (current_row.Qaqc_status_result == Convert.ToInt16(Comun.Status_result.Aceptado))
{
CRecep_sample_detail_elem oRecep_sample_detail_elem = faRecep_sample_detail_elem.GetByPrimaryKey(new CRecep_sample_detail_elemKeys(Idrecep_sample_detail_elem));
oRecep_sample_detail_elem.Result_analysis = current_row.Result_analysis;
oRecep_sample_detail_elem.Str_result_analysis = current_row.Str_result_analysis.ToString();
oRecep_sample_detail_elem.With_result = true;
if (current_row.Str_result_analysis == null)
oRecep_sample_detail_elem.With_result = false;
faRecep_sample_detail_elem.Update(oRecep_sample_detail_elem);
}
CBatch_detail_aa_twofoldFactory faBatch_detail_aa_twofold = new CBatch_detail_aa_twofoldFactory();
faBatch_detail_aa_twofold.Update(current_row);
}
else// --- es un reensayo
{
if (!oQaqc.ExistsResultPendingSel(Idrecep_sample_detail_elem, Idbatch))
{
// --- si no está pendiente de seleccionar entre varios análisis
// --- save final element law
if (current_row.Qaqc_status_result == Convert.ToInt16(Comun.Status_result.Aceptado))
{
CRecep_sample_detail_elem oRecep_sample_detail_elem = faRecep_sample_detail_elem.GetByPrimaryKey(new CRecep_sample_detail_elemKeys(Idrecep_sample_detail_elem));
oRecep_sample_detail_elem.Result_analysis = current_row.Result_analysis;
oRecep_sample_detail_elem.Str_result_analysis = current_row.Str_result_analysis.ToString();
oRecep_sample_detail_elem.With_result = true;
if (current_row.Str_result_analysis == null)
oRecep_sample_detail_elem.With_result = false;
faRecep_sample_detail_elem.Update(oRecep_sample_detail_elem);
}
CBatch_detail_aa_twofoldFactory faBatch_detail_aa_twofold = new CBatch_detail_aa_twofoldFactory();
faBatch_detail_aa_twofold.Update(current_row);
}
}
// --- save retest
if (current_row.Qaqc_tmp_retest == 1)
{
string cod_type_sample = new CTemplate_methodFactory().GetByPrimaryKey(new CTemplate_methodKeys(Convert.ToInt32(current_row.Idtemplate_method))).Cod_type_sample;
CCorrelative oCorrelative = new CCorrelativeFactory().GetByPrimaryKey(new CCorrelativeKeys(cod_type_sample));
CBatchManager oBatchManager = new CBatchManager();
oBatchManager.CallSaveSampleBatchWithRetest(
Convert.ToInt32(current_row.Idtemplate_method),
Convert.ToInt64(current_row.Idrecep_sample),
Convert.ToInt64(current_row.Idrecep_sample_detail),
Convert.ToInt64(current_row.Idrecep_sample_detail_elem),
Convert.ToInt64(current_row.Cod_interno),
current_row.Cod_sample,
Comun.GetUser(),
oCorrelative, Convert.ToInt32(current_row.Qaqc_par), Idbatch);
}
// --- register as finished trace process
CProcess_Sample_Manage.Finalize_process(Idrecep_sample_detail_elem, LimsProcess.PROCESS_APPROVE_SAMPLES, LimsProcess.PROCESS_ACCEPT_RESULTS);
}
else
{
// --- the samples pertain to batch with full batch retest
CProcess_Sample_Manage.Finalize_process(Idrecep_sample_detail_elem, LimsProcess.PROCESS_APPROVE_SAMPLES, LimsProcess.PROCESS_ACCEPT_RESULTS);
}
}
}
// --- modify the batch status, put in other process
CProcess oProcess = new CProcessFactory().GetByPrimaryKey(new CProcessKeys(LimsProcess.PROCESS_ACCEPT_RESULTS));
oBatch.Status_process = Convert.ToChar(LimsProcess.Status_Process.Waiting);
oBatch.Cod_module = oProcess.Cod_module;
oBatch.Cod_area = oProcess.Cod_area;
oBatch.Cod_process = LimsProcess.PROCESS_ACCEPT_RESULTS;
oBatch.User_review_tray = Comun.GetUser();
oBatch.Date_review_tray = Comun.GetDate();
faBatch.Update(oBatch);
// --- register as finished trace batch
Cprocess_Batch_Manage.Finalize_process(Idbatch, LimsProcess.PROCESS_APPROVE_SAMPLES, LimsProcess.PROCESS_ACCEPT_RESULTS);
}
catch (Exception ex)
{
Comun.Save_log(ex.InnerException.ToString());
throw new Exception("pivot data::approve::Error occured.", ex);
}
}
public void RetestBatch()
{
try
{
CBatchFactory faBatch = new CBatchFactory();
CBatch oBatch = faBatch.GetByPrimaryKey(new CBatchKeys(Idbatch));
// --- check parity
for (int i = 0; i < ListSamples.Count; i++)
{
CBatch_detail_aa_twofold row = ListSamples[i];
CBatch_detail_aa_twofoldFactory faBatch_detail_aa_twofold = new CBatch_detail_aa_twofoldFactory();
if (Convert.ToInt32(row.Flag_mri) == 0)
{
// --- approved samples with additional retest mark
row.Qaqc_has_retest = 1;
faBatch_detail_aa_twofold.Update(row);
// --- save retest
string cod_type_sample = new CTemplate_methodFactory().GetByPrimaryKey(new CTemplate_methodKeys(Convert.ToInt32(row.Idtemplate_method))).Cod_type_sample;
CCorrelative oCorrelative = new CCorrelativeFactory().GetByPrimaryKey(new CCorrelativeKeys(cod_type_sample));
CBatchManager oBatchManager = new CBatchManager();
oBatchManager.CallSaveFromRetestFullBatch(
Convert.ToInt32(row.Idtemplate_method),
Convert.ToInt64(row.Idrecep_sample),
Convert.ToInt64(row.Idrecep_sample_detail),
Convert.ToInt64(row.Idrecep_sample_detail_elem),
Convert.ToInt64(row.Cod_interno),
row.Cod_sample,
Comun.GetUser(),
oCorrelative,
row.Qaqc_par);
// --- register as finished trace process
CProcess_Sample_Manage.Finalize_process(Convert.ToInt64(row.Idrecep_sample_detail_elem), LimsProcess.PROCESS_IN_READING, LimsProcess.PROCESS_APPROVE_SAMPLES);
}
}
// --- modify the batch status, put in other process
CProcess oProcess = new CProcessFactory().GetByPrimaryKey(new CProcessKeys(LimsProcess.PROCESS_APPROVE_SAMPLES));
oBatch.Status_process = Convert.ToChar(LimsProcess.Status_Process.Waiting);
oBatch.Cod_module = oProcess.Cod_module;
oBatch.Cod_area = oProcess.Cod_area;
oBatch.Cod_process = LimsProcess.PROCESS_APPROVE_SAMPLES;
oBatch.User_approve_tray = Comun.GetUser();
oBatch.Date_approve_tray = Comun.GetDate();
faBatch.Update(oBatch);
// --- register as finished trace batch
Cprocess_Batch_Manage.Finalize_process(Idbatch, LimsProcess.PROCESS_IN_READING, LimsProcess.PROCESS_APPROVE_SAMPLES);
}
catch (Exception ex)
{
Comun.Save_log(ex.InnerException.ToString());
throw new Exception("pivot data::approve::Error occured.", ex);
}
}
public void MovePositionRow(CBatch_detail_aa_twofold row_ini, CBatch_detail_aa_twofold row_end)
{
CBatch_detail_aa_twofoldFactory faBatch_detail_aa_twofold = new CBatch_detail_aa_twofoldFactory();
BindingList<CBatch_detail_aa_twofold> lst = new BindingList<CBatch_detail_aa_twofold>(ListSamples);
// --- copiar muestra drag como temporal
CBatch_detail_aa_twofold tmp_row_ini = lst.Single(c => c.Cod_interno == row_ini.Cod_interno);
CBatch_detail_aa_twofold tmp_row_end = lst.Single(c => c.Cod_interno == row_end.Cod_interno);
// --- quitar muestra drag de la lista
lst.Remove(tmp_row_ini);
// --- obetener indice o posición a donde será movido
int new_index_end = lst.IndexOf(tmp_row_end);
// --- insertar la muestra que fue removida
lst.Insert(new_index_end, tmp_row_ini);
// --- reset orden de las muestras
short count = 1;
foreach (CBatch_detail_aa_twofold item in lst)
{
item.Order_sample_batch = count;
count++;
faBatch_detail_aa_twofold.Update(item);
}
// --- get source data
dtPivotBatch =
new BindingList<CBatch_detail_aa_twofold>(
faBatch_detail_aa_twofold
.GetAll()
.Where(c => c.Idbatch == Idbatch && c.Idtemplate_method == Idtemplate_method).ToList());
}
private void SaveInBatch(CBatch_detail_aa_twofold oBatch_detail_aa_twofold, string user)
{
// --- get batch
int idtemplate_method = Convert.ToInt32(oBatch_detail_aa_twofold.Idtemplate_method);
long origin_batch = -1;
if (Enabled_retest)
{
origin_batch = Convert.ToInt64(oRetest.Origin_batch);
}
long idbatch = Convert.ToInt64(GetBatchAvailable(idtemplate_method, user, origin_batch));
CBatch oBatch = new CBatchFactory().GetByPrimaryKey(new CBatchKeys(idbatch));
int num_free_places = GetNumFreePlacesInBatch(idbatch, idtemplate_method);
if (num_free_places >= 1)
{
if (!Convert.ToBoolean(oBatch.Has_sample_control)) // batch no tiene mri
{
long index_mri = GetIndexMriPredecessor(idbatch, Convert.ToInt64(oBatch_detail_aa_twofold.Cod_interno));
if (index_mri > 0)// --- el batch no tiene mri y en sus predecesores debe existir uno
{
if (num_free_places >= 2)
{
// --- insert mri
control_sample.Cod_interno = index_mri;
control_sample.Idbatch = idbatch;
control_sample.Cod_sample = Comun.FormatCorrelativeCode(Correlative.Prefix + Correlative.Cod_serie, index_mri, Convert.ToInt32(Correlative.Num_digits));
if (faBatch_detail_aa_twofold.Insert(control_sample))
{
oBatch.Has_sample_control = true;
new CBatchFactory().Update(oBatch);
}
// --- insert sample
CBatch_detail_aa_twofoldFactory faBatch_detail_aa_towfold = new CBatch_detail_aa_twofoldFactory();
oBatch_detail_aa_twofold.Idbatch = idbatch;
faBatch_detail_aa_towfold.Insert(oBatch_detail_aa_twofold);
SaveRetest(idbatch);
}
if (num_free_places == 1)
{
// --- insert mri
control_sample.Cod_interno = index_mri;
control_sample.Idbatch = idbatch;
control_sample.Cod_sample = Comun.FormatCorrelativeCode(Correlative.Prefix + Correlative.Cod_serie, index_mri, Convert.ToInt32(Correlative.Num_digits));
if (faBatch_detail_aa_twofold.Insert(control_sample))
{
oBatch.Has_sample_control = true;
new CBatchFactory().Update(oBatch);
}
// --- search batch to sample
SaveInBatch(oBatch_detail_aa_twofold, user);
}
}
else // --- index_mri = 0; entonces la bandeja no lleva mri
{
oBatch_detail_aa_twofold.Idbatch = idbatch;
faBatch_detail_aa_twofold.Insert(oBatch_detail_aa_twofold);
SaveRetest(idbatch);
}
}
else
{
oBatch_detail_aa_twofold.Idbatch = idbatch;
faBatch_detail_aa_twofold.Insert(oBatch_detail_aa_twofold);
SaveRetest(idbatch);
}
}
}
