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 static void Finalize_process(long idbatch, string process, string sgtProcess)
{
CTrace_batchFactory faTrace_batch = new CTrace_batchFactory();
// --- get a process existing
CTrace_batch oTrace_batch = new LimsProject.BusinessLayer.Modules.ModProcessBatch().GetLastProcessBatch(process, idbatch);
CProcess oProcess = new CProcessFactory().GetByPrimaryKey(new CProcessKeys(process));
if (oTrace_batch == null)
{
oTrace_batch = new CTrace_batch();
oTrace_batch.Date_in = Comun.GetDate();
oTrace_batch.Usernew = Comun.GetUser();
oTrace_batch.Idbatch = idbatch;
}
oTrace_batch.Date_out = Comun.GetDate();
oTrace_batch.Cod_process = process;
//oTrace_batch.Cod_module = modulo;
oTrace_batch.Useredit = Comun.GetUser();
oTrace_batch.Status_process = Convert.ToChar(LimsProcess.Status_Process.Finished);
if (!faTrace_batch.Update(oTrace_batch))
{
faTrace_batch.Insert(oTrace_batch);
}
// --- create a new process
Initialize_process(idbatch, sgtProcess);
}
public static void Advance_process(long idbatch, string process)
{
CTrace_batchFactory faTrace_batch = new CTrace_batchFactory();
// --- get a process existing
CTrace_batch oTrace_batch = new LimsProject.BusinessLayer.Modules.ModProcessBatch().GetLastProcessBatch(process, idbatch);
if (oTrace_batch == null)
{
oTrace_batch = new CTrace_batch();
oTrace_batch.Date_in = Comun.GetDate();
oTrace_batch.Usernew = Comun.GetUser();
oTrace_batch.Idbatch = idbatch;
}
oTrace_batch.Cod_process = process;
//oTrace_batch.Cod_module = module;
oTrace_batch.Usernew = Comun.GetUser();
oTrace_batch.Useredit = Comun.GetUser();
oTrace_batch.Status_process = Convert.ToChar(LimsProcess.Status_Process.InProcess);
if (!faTrace_batch.Update(oTrace_batch))
{
faTrace_batch.Insert(oTrace_batch);
}
}
public static void Finalize_process(long idrecep_sample_detail_elem, string process, string sgtProcess)
{
CTrace_sample_elemFactory faTrace_sample_elem = new CTrace_sample_elemFactory();
// --- get a process existing
CTrace_sample_elem oTrace_sample_elem =
faTrace_sample_elem.GetAll()
.Where(x => x.Idrecep_sample_detail_elem == idrecep_sample_detail_elem && x.Cod_process == process)
.OrderBy(x => x.Idtrace_sample_elem).OrderByDescending(x => x.Date_in).FirstOrDefault();
if (oTrace_sample_elem == null)
{
oTrace_sample_elem = new CTrace_sample_elem();
oTrace_sample_elem.Date_in = Comun.GetDate();
oTrace_sample_elem.Usernew = Comun.User_system.Cod_user;
oTrace_sample_elem.Idrecep_sample_detail_elem = idrecep_sample_detail_elem;
//oTrace_sample_elem.Cod_module = module;
oTrace_sample_elem.Cod_process = process;
}
oTrace_sample_elem.Date_out = Comun.GetDate();
oTrace_sample_elem.Status_process = Convert.ToChar(LimsProcess.Status_Process.Finished);
oTrace_sample_elem.Useredit = Comun.GetUser();
if (!faTrace_sample_elem.Update(oTrace_sample_elem))
{
faTrace_sample_elem.Insert(oTrace_sample_elem);
}
// --- create a new process
Initialize_process(idrecep_sample_detail_elem, sgtProcess);
}
public static void Advance_process(long idrecep_sample_detail_elem, string process)
{
CTrace_sample_elemFactory faTrace_sample_elem = new CTrace_sample_elemFactory();
// --- get a process existing
CTrace_sample_elem oTrace_sample_elem =
faTrace_sample_elem.GetAll()
.Where(x => x.Idrecep_sample_detail_elem == idrecep_sample_detail_elem && x.Cod_process == process)
.OrderBy(x => x.Idtrace_sample_elem).OrderByDescending(x => x.Date_in).FirstOrDefault();
if (oTrace_sample_elem == null)
{
oTrace_sample_elem = new CTrace_sample_elem();
oTrace_sample_elem.Usernew = Comun.GetUser();
oTrace_sample_elem.Date_in = Comun.GetDate();
}
oTrace_sample_elem.Cod_process = process;
oTrace_sample_elem.Idrecep_sample_detail_elem = idrecep_sample_detail_elem;
oTrace_sample_elem.Status_process = Convert.ToChar(LimsProcess.ModuleStatus.InProcess);
oTrace_sample_elem.Useredit = Comun.GetUser();
if (!faTrace_sample_elem.Update(oTrace_sample_elem))
{
faTrace_sample_elem.Insert(oTrace_sample_elem);
}
}
protected override bool Grabar_Registro()
{
try
{
// borrar datos
foreach (CCompound item in new CCompoundFactory().GetAll())
{
item.Status = false;
new CCompoundFactory().Update(item);
}
// guardar grid
foreach (CCompound item in gcCompound.DataSource as BindingList <CCompound> )
{
item.Status = true;
item.Useredit = Comun.GetUser();
item.Dateedit = Comun.GetDate();
if (!new CCompoundFactory().Update(item))
{
item.Usernew = Comun.GetUser();
item.Datenew = Comun.GetDate();
new CCompoundFactory().Insert(item);
}
}
return(true);
}
catch (Exception ex)
{
ComunForm.Send_message("Compuestos", TypeMsg.error, ex.Message);
return(false);
}
}
protected override bool Grabar_Registro()
{
CElement oElement = new CElement();
oElement.Idelement = Idelement;
oElement.Cod_element = tbCodElement.Text;
oElement.Name_element = tbDenomination.Text;
oElement.Description = tbDescription.Text;
oElement.Native_element = tbGroup.Text;
oElement.Type_element = 'C';
if (Idelement == 0)
{
oElement.Usernew = Comun.GetUser();
oElement.Useredit = Comun.GetUser();
oElement.Datenew = Comun.GetDate();
oElement.Dateedit = Comun.GetDate();
}
else
{
oElement.Datenew = Comun.GetDate();
oElement.Dateedit = Comun.GetDate();
}
CElementFactory faElement = new CElementFactory();
if (!faElement.Update(oElement))
{
faElement.Insert(oElement);
}
ComunForm.Send_message(this.Text, TypeMsg.ok, "");
return(true);
}
protected override bool Grabar_Registro()
{
try
{
// eliminar todo
foreach (CFactor_estequiometrico item in new CFactor_estequiometricoFactory().GetAll())
{
item.Status = false;
new CFactor_estequiometricoFactory().Update(item);
}
// guardar
foreach (CFactor_estequiometrico item in gcFactorEstequ.DataSource as BindingList <CFactor_estequiometrico> )
{
item.Status = true;
item.Dateedit = Comun.GetDate();
item.Useredit = Comun.GetUser();
if (!new CFactor_estequiometricoFactory().Update(item))
{
item.Useredit = Comun.GetUser();
item.Datenew = Comun.GetDate();
new CFactor_estequiometricoFactory().Insert(item);
}
}
return(true);
}
catch (Exception ex)
{
ComunForm.Send_message("Factores estequiométricos", TypeMsg.error, ex.Message);
return(true);
}
}
protected override bool Grabar_Registro()
{
CType_solutionFactory faType_solution = new CType_solutionFactory();
try
{
// --- remove all
List <CType_solution> lstType_solution = new List <CType_solution>(new CType_solutionFactory().GetAll());
for (int i = 0; i < lstType_solution.Count; i++)
{
CType_solution current_row = lstType_solution[i];
if (current_row.Idtype_solution > 0)
{
current_row.Status = false;
faType_solution.Update(current_row);
}
}
// --- save all
for (int i = 0; i < gvTypeSolution.RowCount; i++)
{
CType_solution current_row = gvTypeSolution.GetRow(i) as CType_solution;
if (current_row.Idtype_solution == 0)
{
current_row.Usernew = Comun.GetUser();
current_row.Datenew = Comun.GetDate();
current_row.Status = true;
}
else
{
current_row.Useredit = Comun.GetUser();
current_row.Dateedit = Comun.GetDate();
current_row.Status = true;
}
if (!faType_solution.Update(current_row))
{
faType_solution.Insert(current_row);
}
}
return(true);
}
catch (Exception ex)
{
ComunForm.Send_message(this.Text, TypeMsg.error, ex.Message);
return(false);
}
}
void AddParentNode()
{
// --- this method add a son node for one selected node
CDocumentation_User_File oDocUserFile =
new CDocumentation_User_File
{
Iddocumentation = -1,
Idtemplate_method = null,
Idconfiguration_folder = Convert.ToInt16(cbDocument.EditValue),
Name_doc = "Certificado",
Procedure_type = Convert.ToChar(cbProcedure.EditValue),
Type_doc = 'C',
Image_index = 0,
Id = GetNewIdNode(),
Parentid = 0,
Date_ini = DateTime.Now,
Date_end = DateTime.Now.AddMonths(12),
Rank_valid_inmonth = 12,
Prev_authorized = false
};
lstDocumentation_user_file.Add(oDocUserFile);
// --- save
CDocumentationFactory faDocumentation = new CDocumentationFactory();
CDocumentation oDocumentation = new CDocumentation();
oDocumentation.Iddocumentation = oDocUserFile.Iddocumentation;
oDocumentation.Idconfiguration_folder = oDocUserFile.Idconfiguration_folder;
oDocumentation.Idtemplate_method = oDocUserFile.Idtemplate_method;
oDocumentation.Image_index = oDocUserFile.Image_index;
oDocumentation.Name_doc = oDocUserFile.Name_doc;
oDocumentation.Procedure_type = oDocUserFile.Procedure_type;
oDocumentation.Type_doc = oDocUserFile.Type_doc;
oDocumentation.Flag_enabled = true;
oDocumentation.Id = oDocUserFile.Id;
oDocumentation.Parentid = oDocUserFile.Parentid;
oDocumentation.Usernew = Comun.GetUser();
oDocumentation.Useredit = Comun.GetUser();
oDocumentation.Datenew = DateTime.Now;
oDocumentation.Dateedit = DateTime.Now;
oDocumentation.Status = true;
treeAuthorization.DataSource = lstDocumentation_user_file;
faDocumentation.Insert(oDocumentation);
treeAuthorization.DataSource = lstDocumentation_user_file;
}
void SaveData()
{
//guardar las filas cuyo valor de idelement_wavelength sea igual a 0
foreach (CElement_wavelength item in gcElemWavelength.DataSource as BindingList <CElement_wavelength> )
{
if (item.Idelement_wavelength == 0)
{
item.Status = true;
item.Dateedit = Comun.GetDate();
item.Useredit = Comun.GetUser();
new CElement_wavelengthFactory().Insert(item);
}
}
}
protected override bool Grabar_Registro()
{
CCompanyFactory faCompany = new CCompanyFactory();
CCompany oCompany;
if ((oCompany = faCompany.GetByPrimaryKey(new CCompanyKeys(IDCompany))) == null)
{
oCompany = new CCompany();
}
oCompany.Idcompany = IDCompany;
oCompany.Business_name = tbBusinessName.Text;
oCompany.Domicile = tbClientDomicile.Text;
oCompany.Mail = tbClientEmail.Text;
oCompany.Phone_client = tbClientPhone.Text;
oCompany.Ruc = tbClientRuc.Text;
oCompany.Type_company = Convert.ToChar(cbTypeCompany.EditValue);
if (IDCompany == 0)
{
oCompany.Usernew = Comun.GetUser();
oCompany.Useredit = Comun.GetUser();
oCompany.Datenew = Comun.GetDate();
oCompany.Dateedit = Comun.GetDate();
}
else
{
oCompany.Useredit = Comun.GetUser();
oCompany.Dateedit = Comun.GetDate();
}
bool result = false;
if (!(result = faCompany.Update(oCompany)))
{
if (!result)
{
result = faCompany.Insert(oCompany);
}
}
if (result)
{
LoadDataMasterSearh(new CCompanyFactory().GetAllDataTable());
}
return(result);
}
public static void Initialize_process(long idbatch, string process)
{
// --- register the finished process,
CTrace_batchFactory faTrace_batch = new CTrace_batchFactory();
CTrace_batch oTrace_batch = new CTrace_batch();
// --- register the initiatied process
oTrace_batch = new CTrace_batch();
oTrace_batch.Date_in = Comun.GetDate();
oTrace_batch.Cod_process = process;
//oTrace_batch.Cod_module = module;
oTrace_batch.Idbatch = idbatch;
oTrace_batch.Status_process = Convert.ToChar(LimsProcess.Status_Process.Waiting);
oTrace_batch.Usernew = Comun.GetUser();
oTrace_batch.Datenew = Comun.GetDate();
faTrace_batch.Insert(oTrace_batch);
}
public static void Initialize_process(long idrecep_sample_detail_elem, string process)
{
// --- register the finished process,
CTrace_sample_elemFactory faTrace_sample_elem = new CTrace_sample_elemFactory();
CTrace_sample_elem oTrace_sample_elem = new CTrace_sample_elem();
// --- register the initiatied process
oTrace_sample_elem = new CTrace_sample_elem();
oTrace_sample_elem.Date_in = Comun.GetDate();
//oTrace_sample_elem.Cod_module = module;
oTrace_sample_elem.Cod_process = process;
oTrace_sample_elem.Idrecep_sample_detail_elem = idrecep_sample_detail_elem;
oTrace_sample_elem.Status_process = Convert.ToChar(LimsProcess.Status_Process.Waiting);
oTrace_sample_elem.Usernew = Comun.GetUser();
oTrace_sample_elem.Useredit = Comun.GetUser();
faTrace_sample_elem.Insert(oTrace_sample_elem);
}
void InitData()
{
CReactiveFactory faReactive = new CReactiveFactory();
List <CReactive> lstReactive = faReactive.GetAll();
lstReactive.Add(new CReactive()
{
Idreactive = 0, Reactive_name = "---", Chemical_formula = "---"
});
cbMedium.Properties.DataSource = lstReactive;
cbMedium.Properties.ValueMember = "Idreactive";
cbMedium.Properties.DisplayMember = "Reactive_name";
cbModif.Properties.DataSource = lstReactive;
cbModif.Properties.ValueMember = "Idreactive";
cbModif.Properties.DisplayMember = "Reactive_name";
CTemplate_method_aa oTemplate_method_aa = new CTemplate_method_aa();
CTemplate_method_aaFactory faTemplate_method_aa = new CTemplate_method_aaFactory();
oTemplate_method_aa =
faTemplate_method_aa.GetByPrimaryKey(new CTemplate_method_aaKeys(idtemplate_method));
idreactive_medium = oTemplate_method_aa.Medium;
idreactive_modif = oTemplate_method_aa.Modif;
LstAllCalibs = oModCalibStd.GetCustomCalibStd(idelement, idmr_detail, idreactive_medium, idreactive_modif);
gcCalibStd.DataSource = LstAllCalibs;
gvCalibStd.ExpandAllGroups();
//oGroup_solution = oModCalibStd.GetMethodCalib(idelement, idmr_detail, idreactive_medium, idreactive_modif);
CElement oElement = new CElementFactory()
.GetByPrimaryKey(new CElementKeys(Convert.ToInt16(idelement)));
ucTraceUser1.UserSign = Comun.GetUser();
ucTraceUser1.DateSign = Comun.GetDate();
}
private void tbPwd_KeyDown(object sender, KeyEventArgs e)
{
if (e.KeyCode == Keys.Enter)
{
if (tbPwd.Text.Length == 0)
{
btLock.ImageIndex = 0;
}
else
{
if (Comun.AreUserAndPwdRight(Comun.GetUser(), tbPwd.Text))
{
btLock.ImageIndex = 1;
OnSignPwd(true);
}
else
{
btLock.ImageIndex = 2;
OnSignPwd(false);
}
}
}
}
private void treeAuthorization_CellValueChanged(object sender, DevExpress.XtraTreeList.CellValueChangedEventArgs e)
{
if (e.Column == gcDoc_Rank_valid_inmonth ||
e.Column == gcDoc_Prev_authorized)
{
DateTime fend = Convert.ToDateTime(e.Node.GetValue("Date_ini")).AddMonths(Convert.ToInt32(e.Node.GetValue("Rank_valid_inmonth")));
e.Node.SetValue("Date_end", fend);
// --- save
CDocumentationFactory faDocumentation = new CDocumentationFactory();
CDocumentation oDocumentation =
faDocumentation
.GetByPrimaryKey(new CDocumentationKeys(Convert.ToInt16(e.Node.GetValue("Iddocumentation"))));
if (oDocumentation == null)
{
oDocumentation = new CDocumentation();
oDocumentation.Iddocumentation = 0;
}
oDocumentation.Idconfiguration_folder = Convert.ToInt16(e.Node.GetValue("Idconfiguration_folder"));
if (e.Node.GetValue("Idtemplate_method") != null)
{
oDocumentation.Idtemplate_method = Convert.ToInt32(e.Node.GetValue("Idtemplate_method"));
}
oDocumentation.Image_index = Convert.ToInt32(e.Node.GetValue("Image_index"));
oDocumentation.Name_doc = e.Node.GetValue("Name_doc").ToString();
oDocumentation.Procedure_type = Convert.ToChar(e.Node.GetValue("Procedure_type"));
oDocumentation.Type_doc = Convert.ToChar(e.Node.GetValue("Type_doc"));
oDocumentation.Flag_enabled = true;
oDocumentation.Id = Convert.ToInt32(e.Node.GetValue("Id"));
oDocumentation.Parentid = Convert.ToInt32(e.Node.GetValue("Parentid"));
oDocumentation.Usernew = Comun.GetUser();
oDocumentation.Useredit = Comun.GetUser();
oDocumentation.Datenew = DateTime.Now;
oDocumentation.Dateedit = DateTime.Now;
oDocumentation.Status = true;
treeAuthorization.DataSource = lstDocumentation_user_file;
bool result = false;
if (!(result = faDocumentation.Update(oDocumentation)))
{
result = faDocumentation.Insert(oDocumentation);
}
// --- Guardar acceso el usuario
if (result)
{
CDocumentation_userFactory faDocumentation_user = new CDocumentation_userFactory();
CDocumentation_user oDocumentation_user = new CDocumentation_user();
List <CDocumentation_user> lst = faDocumentation_user.GetAll();
if (lst.Exists(c => c.Iddocumentation == oDocumentation.Iddocumentation &&
c.Iduser == Convert.ToInt16(cbUser.EditValue)))
{
oDocumentation_user =
faDocumentation_user
.GetAll()
.Single(c => c.Iddocumentation == oDocumentation.Iddocumentation &&
c.Iduser == Convert.ToInt16(cbUser.EditValue));
}
else
{
oDocumentation_user = new CDocumentation_user();
oDocumentation_user.Iddocumentation_user = 0;
}
oDocumentation_user.Iddocumentation = oDocumentation.Iddocumentation;
oDocumentation_user.Date_ini = Convert.ToDateTime(e.Node.GetValue("Date_ini"));
oDocumentation_user.Date_end = Convert.ToDateTime(e.Node.GetValue("Date_end"));
oDocumentation_user.Rank_valid_inmonth = Convert.ToInt32(e.Node.GetValue("Rank_valid_inmonth"));
oDocumentation_user.Prev_authorized = Convert.ToBoolean(e.Node.GetValue("Prev_authorized"));
oDocumentation_user.Iduser = Convert.ToInt16(cbUser.EditValue);
if (!faDocumentation_user.Update(oDocumentation_user))
{
faDocumentation_user.Insert(oDocumentation_user);
}
}
}
}
bool SaveAA()
{
try
{
string Cod_method = gluCod_method.Text;
string Title = tbTitle.Text;
string messageOk = "";
Methods oMethods = new Methods();
Comun.MethodSaveProperty InspectionChanges = RequireNewVersionOrMethod(Comun.GetTypeAnalysis(Convert.ToChar(cbTypeAnalysis.EditValue)));
if (InspectionChanges == Comun.MethodSaveProperty.NewMethod)
{
Num_version = 1;
messageOk = "Se guardó un nuevo método con código " + Cod_method +
"\ncon título " + Title;
}
if (InspectionChanges == Comun.MethodSaveProperty.InspectionNewVersion)
{
// --- save as new version or overwrite
FormConfirmSaveMethod fmConfirmSaveMethod = new FormConfirmSaveMethod(true);
if (fmConfirmSaveMethod.ShowDialog() == System.Windows.Forms.DialogResult.OK)
{
if (fmConfirmSaveMethod.SaveType == Comun.Save_type.SaveAs)
{
FormMethodSaveAs fmMethodSaveAs = new FormMethodSaveAs();
fmMethodSaveAs.ListTemplate =
oMethods.GetAllLastVersionMethods(
Convert.ToInt32(cbElement.EditValue),
cbTypeSample.EditValue.ToString(),
Convert.ToChar(cbTypeAnalysis.EditValue));
if (fmMethodSaveAs.ShowDialog() == System.Windows.Forms.DialogResult.OK)
{
Num_version = 1;
IDTemplate_Method = 0;
Cod_method = fmMethodSaveAs.Cod_method;
Title = fmMethodSaveAs.Title;
messageOk = "Se guardó un nuevo método con código " + fmMethodSaveAs.Cod_method +
"\n con título '" + fmMethodSaveAs.Title + "'";
}
else
{
return(false);
}
}
if (fmConfirmSaveMethod.SaveType == Comun.Save_type.Save)
{
Num_version = oMethods.GetNumNewVersion(IDTemplate_Method);
IDTemplate_Method = 0;
messageOk = "Se guardó una nueva versión [" + Num_version.ToString() + "] del método " + Cod_method;
}
}
else
{
return(false);
}
}
if (InspectionChanges == Comun.MethodSaveProperty.InspectionNewMethod)
{
FormMethodSaveAs fmMethodSaveAs = new FormMethodSaveAs();
fmMethodSaveAs.ListTemplate =
oMethods.GetAllLastVersionMethods(
Convert.ToInt32(cbElement.EditValue),
cbTypeSample.EditValue.ToString(),
Convert.ToChar(cbTypeAnalysis.EditValue));
if (fmMethodSaveAs.ShowDialog() == System.Windows.Forms.DialogResult.OK)
{
Num_version = 1;
IDTemplate_Method = 0;
Cod_method = fmMethodSaveAs.Cod_method;
Title = fmMethodSaveAs.Title;
messageOk = "Se guardó un nuevo método con código " + fmMethodSaveAs.Cod_method +
"\n con título " + fmMethodSaveAs.Title;
}
else
{
return(false);
}
}
if (InspectionChanges == Comun.MethodSaveProperty.Nothing)
{
messageOk = "Se guardó correctamente";
}
// --- save head
CTemplate_methodFactory faTemplate_Method = new CTemplate_methodFactory();
CTemplate_method oTemplate_Method = new CTemplate_method();
oTemplate_Method.Idtemplate_method = IDTemplate_Method;
oTemplate_Method.Num_version = Num_version;
oTemplate_Method.Idelement = Convert.ToInt32(cbElement.EditValue);
oTemplate_Method.Cod_template_method = Cod_method;
oTemplate_Method.Title = Title;
oTemplate_Method.Cod_digestion_method = cbDigestion.EditValue.ToString();
oTemplate_Method.Cod_repetition = Convert.ToInt16(cbRepetition.EditValue);
oTemplate_Method.Abbreviation = tbAbreviation.Text;
oTemplate_Method.Recognized = ckRecognized.Checked;
oTemplate_Method.Cod_type_sample = cbTypeSample.EditValue.ToString();
oTemplate_Method.Cost_method = tbCost_Method.Value;
oTemplate_Method.Type_analisys = Convert.ToChar(cbTypeAnalysis.EditValue);
oTemplate_Method.Status = true;
if (IDTemplate_Method == 0)
{
oTemplate_Method.Usernew = Comun.GetUser();
oTemplate_Method.Datenew = Comun.GetDate();
oTemplate_Method.Useredit = Comun.GetUser();
oTemplate_Method.Dateedit = Comun.GetDate();
}
else
{
oTemplate_Method.Useredit = Comun.GetUser();
oTemplate_Method.Dateedit = Comun.GetDate();
}
bool result_template_method = false;
if (!(result_template_method = faTemplate_Method.Update(oTemplate_Method)))
{
result_template_method = faTemplate_Method.Insert(oTemplate_Method);
}
if (result_template_method)
{
IDTemplate_Method = oTemplate_Method.Idtemplate_method;
SaveTypeAnalysis();
}
FormResult fmResult = new FormResult();
fmResult.Message = messageOk;
fmResult.ShowDialog();
gluCod_method.Text = Cod_method;
return(true);
}
catch (Exception ex)
{
ComunForm.Send_message(this.Text, TypeMsg.error, ex.Message);
return(false);
}
}
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);
}
}
private void gvPrepSample_CellValueChanged(object sender, DevExpress.XtraGrid.Views.Base.CellValueChangedEventArgs e)
{
if (e.Column == gcol_Weight_gross)
{
// actualizar fecha entrada y usuario
CPrep_samples oPrep_sample = gvPrepSample.GetRow(e.RowHandle) as CPrep_samples;
oPrep_sample.Weight_gross_date = Comun.GetDate();
oPrep_sample.Weight_gross_user = Comun.GetUser();
SetComplete(oPrep_sample);
new CPrep_samplesFactory().Update(oPrep_sample);
}
else if (e.Column == gcol_Weight_moisture)
{
// actualizar fecha de peso húmedo y usuario
CPrep_samples oPrep_sample = gvPrepSample.GetRow(e.RowHandle) as CPrep_samples;
if (oPrep_sample.Weight_moisture != null && oPrep_sample.Weight_dry != null &&
oPrep_sample.Weight_dry > 0 && oPrep_sample.Weight_moisture > 0)
{
oPrep_sample.Percent_moisture = Math.Round(Convert.ToDecimal((oPrep_sample.Weight_moisture - oPrep_sample.Weight_dry) / oPrep_sample.Weight_moisture), 2);
}
oPrep_sample.Weight_moisture_date = Comun.GetDate();
oPrep_sample.Weight_moisture_user = Comun.GetUser();
SetComplete(oPrep_sample);
new CPrep_samplesFactory().Update(oPrep_sample);
}
else if (e.Column == gcol_Weight_dry)
{
// actualizar fecha de peso seco y usuario y calcular la humedad
CPrep_samples oPrep_sample = gvPrepSample.GetRow(e.RowHandle) as CPrep_samples;
if (oPrep_sample.Weight_moisture != null && oPrep_sample.Weight_dry != null &&
oPrep_sample.Weight_dry > 0 && oPrep_sample.Weight_moisture > 0)
{
oPrep_sample.Percent_moisture = Math.Round(Convert.ToDecimal((oPrep_sample.Weight_moisture - oPrep_sample.Weight_dry) / oPrep_sample.Weight_moisture), 2);
oPrep_sample.Weight_dry_date = Comun.GetDate();
oPrep_sample.Weight_dry_user = Comun.GetUser();
SetComplete(oPrep_sample);
new CPrep_samplesFactory().Update(oPrep_sample);
}
}
else if (e.Column == gcol_Weight_gross_reject)
{
// actualizar fecha de rechazo y usuario
CPrep_samples oPrep_sample = gvPrepSample.GetRow(e.RowHandle) as CPrep_samples;
oPrep_sample.Weight_gross_reject_date = Comun.GetDate();
oPrep_sample.Weight_gross_reject_user = Comun.GetUser();
SetComplete(oPrep_sample);
new CPrep_samplesFactory().Update(oPrep_sample);
}
else if (e.Column == gcol_Moisture_reject)
{
// actualizar fecha, usuario de humedad
CPrep_samples oPrep_sample = gvPrepSample.GetRow(e.RowHandle) as CPrep_samples;
oPrep_sample.Moisture_reject_date = Comun.GetDate();
oPrep_sample.Moisture_reject_user = Comun.GetUser();
SetComplete(oPrep_sample);
new CPrep_samplesFactory().Update(oPrep_sample);
}
else if (e.Column == gcol_Output_flag_sample)
{
// actualizar fecha, usuario en salida de muestra
CPrep_samples oPrep_sample = gvPrepSample.GetRow(e.RowHandle) as CPrep_samples;
oPrep_sample.Output_date_sample = Comun.GetDate();
oPrep_sample.Output_user_sample = Comun.GetUser();
SetComplete(oPrep_sample);
new CPrep_samplesFactory().Update(oPrep_sample);
}
else if (e.Column == gcol_Output_flag_cs)
{
// actualizar fecha, usuario en salida de contramuestra
CPrep_samples oPrep_sample = gvPrepSample.GetRow(e.RowHandle) as CPrep_samples;
oPrep_sample.Output_date_cs = Comun.GetDate();
oPrep_sample.Output_user_cs = Comun.GetUser();
SetComplete(oPrep_sample);
new CPrep_samplesFactory().Update(oPrep_sample);
}
else if (e.Column == gcol_Output_flag_re)
{
// actualizar fecha, usuario en salida de contramuestra
CPrep_samples oPrep_sample = gvPrepSample.GetRow(e.RowHandle) as CPrep_samples;
oPrep_sample.Output_date_re = Comun.GetDate();
oPrep_sample.Output_user_re = Comun.GetUser();
SetComplete(oPrep_sample);
new CPrep_samplesFactory().Update(oPrep_sample);
}
else if (e.Column == gcol_Observation1 || e.Column == gcol_Observation2)
{
CPrep_samples oPrep_sample = gvPrepSample.GetRow(e.RowHandle) as CPrep_samples;
new CPrep_samplesFactory().Update(oPrep_sample);
}
}
public void SaveCalibs(CSolution_interm pSolution_interm)
{
solution_interm = pSolution_interm;
Date_init = Convert.ToDateTime(solution_interm.Date_begin);
Date_end = Convert.ToDateTime(solution_interm.Date_end);
UserSign = Comun.GetUser();
DateSign = Comun.GetDate();
//poner como historico la actual grupo de calibraciones
CSet_calibs oSet_calib = oModCalibStd.GetSet_CalibBy(solution_interm.Idsolution_interm, idtemplate_method);
if (oSet_calib != null)
{
oSet_calib.Last_calib = false;
new CSet_calibsFactory().Update(oSet_calib);
}
// --- guardar la nueva calibración
oSet_calib = new CSet_calibs();
oSet_calib.Idset_calibs = 0;
oSet_calib.Idtemplate_method = idtemplate_method;
oSet_calib.Idsolution_interm = solution_interm.Idsolution_interm;
oSet_calib.Datesign = Comun.GetDate();
oSet_calib.Usersign = Comun.GetUser();
oSet_calib.Last_calib = true;
bool result_set_calib = new CSet_calibsFactory().Insert(oSet_calib);
// --- guardar estandares de calibración
if (result_set_calib)
{
for (int i = 0; i < gvCalibStd.RowCount; i++)
{
CSet_calibsFactory faSet_calibs = new CSet_calibsFactory();
CCustomCalibStd customCalibStd = gvCalibStd.GetRow(i) as CCustomCalibStd;
// --- guardar calibración
CCalib_stdFactory faCalib_std = new CCalib_stdFactory();
CCalib_std oCalib_std = new CCalib_std();
oCalib_std = new CCalib_std();
oCalib_std.Idcalib = customCalibStd.Idcalib;
oCalib_std.Absorbance = customCalibStd.Absorbance;
oCalib_std.Concentration = customCalibStd.Concentration;
oCalib_std.Idset_calibs = oSet_calib.Idset_calibs;
oCalib_std.Idsolution_interm = solution_interm.Idsolution_interm;
oCalib_std.Idtemplate_method = idtemplate_method;
bool result_std = false;
if (!(result_std = faCalib_std.Update(oCalib_std)))
{
result_std = faCalib_std.Insert(oCalib_std);
}
if (result_std)
{
gvCalibStd.SetRowCellValue(i, gcCal_Idcalib_std, oCalib_std.Idcalib_std);
}
}
}
}
void AddChildNode()
{
// ---
if (treeAuthorization.FocusedNode.Level == 0)
{
CDocumentation_User_File oDocUserFile =
new CDocumentation_User_File
{
Iddocumentation = -1,
Idtemplate_method = null,
Idconfiguration_folder = Convert.ToInt16(cbDocument.EditValue),
Name_doc = "Adjunto",
Procedure_type = Convert.ToChar(cbProcedure.EditValue),
Type_doc = 'E',
Id = GetNewIdNode(),
Image_index = 1,
Parentid = Convert.ToInt32(treeAuthorization.FocusedNode["Id"]),
Date_ini = DateTime.Now,
Date_end = DateTime.Now.AddMonths(12),
Rank_valid_inmonth = 12,
Prev_authorized = false
};
lstDocumentation_user_file.Add(oDocUserFile);
// --- save
CDocumentationFactory faDocumentation = new CDocumentationFactory();
CDocumentation oDocumentation = new CDocumentation();
oDocumentation.Iddocumentation = oDocUserFile.Iddocumentation;
oDocumentation.Idconfiguration_folder = oDocUserFile.Idconfiguration_folder;
oDocumentation.Idtemplate_method = oDocUserFile.Idtemplate_method;
oDocumentation.Image_index = oDocUserFile.Image_index;
oDocumentation.Name_doc = oDocUserFile.Name_doc;
oDocumentation.Procedure_type = oDocUserFile.Procedure_type;
oDocumentation.Type_doc = oDocUserFile.Type_doc;
oDocumentation.Flag_enabled = true;
oDocumentation.Id = oDocUserFile.Id;
oDocumentation.Parentid = oDocUserFile.Parentid;
oDocumentation.Usernew = Comun.GetUser();
oDocumentation.Useredit = Comun.GetUser();
oDocumentation.Datenew = DateTime.Now;
oDocumentation.Dateedit = DateTime.Now;
oDocumentation.Status = true;
treeAuthorization.DataSource = lstDocumentation_user_file;
//faDocumentation.Insert(oDocumentation);
treeAuthorization.DataSource = lstDocumentation_user_file;
treeAuthorization.FocusedNode.ExpandAll();
}
else if (treeAuthorization.FocusedNode.Level == 1)
{
CDocumentation_User_File oDocUserFile =
new CDocumentation_User_File
{
Iddocumentation = -1,
Idtemplate_method = null,
Idconfiguration_folder = Convert.ToInt16(cbDocument.EditValue),
Procedure_type = Convert.ToChar(cbProcedure.EditValue),
Type_doc = 'E',
Id = GetNewIdNode(),
Image_index = 1,
Parentid = Convert.ToInt32(treeAuthorization.FocusedNode.ParentNode["Id"]),
Date_ini = DateTime.Now,
Date_end = DateTime.Now.AddMonths(12),
Rank_valid_inmonth = 12,
Prev_authorized = false
};
lstDocumentation_user_file.Add(oDocUserFile);
// --- save
CDocumentationFactory faDocumentation = new CDocumentationFactory();
CDocumentation oDocumentation = new CDocumentation();
oDocumentation.Iddocumentation = oDocUserFile.Iddocumentation;
oDocumentation.Idconfiguration_folder = oDocUserFile.Idconfiguration_folder;
oDocumentation.Idtemplate_method = oDocUserFile.Idtemplate_method;
oDocumentation.Image_index = oDocUserFile.Image_index;
oDocumentation.Name_doc = oDocUserFile.Name_doc;
oDocumentation.Procedure_type = oDocUserFile.Procedure_type;
oDocumentation.Type_doc = oDocUserFile.Type_doc;
oDocumentation.Flag_enabled = true;
oDocumentation.Id = oDocUserFile.Id;
oDocumentation.Parentid = oDocUserFile.Parentid;
oDocumentation.Usernew = Comun.GetUser();
oDocumentation.Useredit = Comun.GetUser();
oDocumentation.Datenew = DateTime.Now;
oDocumentation.Dateedit = DateTime.Now;
oDocumentation.Status = true;
treeAuthorization.DataSource = lstDocumentation_user_file;
//faDocumentation.Insert(oDocumentation);
}
}