public void EditarFormula()
{
if (NewFormula.CodFormula != tempCode)
{
if (FormulaQueries.isRepeatedFormula(NewFormula.CodFormula))
{
System.Windows.MessageBox.Show("Codigo de Formula ya existe.");
}
else
{
//System.Windows.MessageBox.Show("This is form" + NewFormula.FormaFarm);
FormulaQueries.editarFormula(NewFormula, tempCode);
System.Windows.MessageBox.Show("Informacion de Formula Actualizada");
updateSelected();
editModal.Close();
}
}
else
{
FormulaQueries.editarFormula(NewFormula, tempCode);
System.Windows.MessageBox.Show("Informacion de Formula Actualizada");
updateSelected();
editModal.Close();
}
}
public void EliminarProcedimientoDetalle(object parameter)
{
int counter = 0;
MessageBoxResult result = MessageBox.Show("Eliminar esta instruccion de la formila?", "Eliminar Instruccion", MessageBoxButton.YesNo, MessageBoxImage.Question);
if (result == MessageBoxResult.Yes)
{
for (int i = 0; i < NewFormulaInstructions.Count; i++)
{
if (NewFormulaInstructions[i].Instruction == SelectedFormulaInstruction.Instruction)
{
counter = i + 1;
}
}
FormulaQueries.deleteProcedimiento(counter.ToString(), SelectedFormula.CodFormula);
NewFormulaInstructions.Remove(SelectedFormulaInstruction);
}
}
public void EditDetalle()
{
FormulaQueries.updateDetalle(SelectedFormula.CodFormula, SelectedDetalle.IdMp, NewFormulaNewDetalle.Quantity);
SelectedDetalle.Quantity = NewFormulaNewDetalle.Quantity;
System.Windows.MessageBox.Show("Cantidad Actualizada con exito.");
}
public FormulasVM()
{
//General setup
Formulas = new ObservableCollection <Formula>(FormulaQueries.GetFormulas());
InactiveFormulas = new ObservableCollection <Formula>(FormulaQueries.GetFormulasInactivas());
NewFormulaProducts = new ObservableCollection <formulaProduct>(ProductQueries.GetFormulaProducts());
NuevaFormulaCommand = new NewFormulaCommand(this);
AddDetalleNewFormulaDataGrid = new NewFormulaDetalleDatagridCommand(this);
newFormulaAddInstruction = new NewFormulaAddInstructionCommand(this);
editDetalleCommand = new EditDetalleCommand(this);
newDetalleCommand = new NewDetalleCommand(this);
newInstructionCommand = new NewInstructionCommand(this);
editFormulacommand = new EditFormulaCommand(this);
Transformations = new ObservableCollection <Formula>(FormulaQueries.GetFormulasTransformaciones());
UnidadCreada = new ObservableCollection <string> {
"galones", "kilos"
};
FormasFarmaceuticas = new ObservableCollection <string> {
"jarabe", "tableta", "pildora", "suspension"
};
//new formula modal window setup
NewFormula = new Formula();
NewFormulaSelectedProduct = new formulaProduct();
NewFormulaNewDetalle = new DetalleFormula();
NewFormulaNewInstruction = new ProcedimientoDetalle();
SelectedFormula = Formulas[0];
}
public void SetFormulaActive(object parameter)
{
FormulaQueries.setActive(SelectedInactive.CodFormula);
Formulas.Add(SelectedInactive);
InactiveFormulas.Remove(SelectedInactive);
}
public void SetFormulaInactive(object parameter)
{
FormulaQueries.setInactive(SelectedFormula.CodFormula);
InactiveFormulas.Add(SelectedFormula);
Formulas.Remove(SelectedFormula);
SelectedFormula = Formulas[0];
}
public void DeleteDetalle(object parameter)
{
MessageBoxResult result = MessageBox.Show("Eliminar este detalle de formula?", "Eliminar Detalle", MessageBoxButton.YesNo, MessageBoxImage.Question);
if (result == MessageBoxResult.Yes)
{
FormulaQueries.deleteDetalle(SelectedDetalle.IdMp, SelectedFormula.CodFormula);
Detalles.Remove(SelectedDetalle);
}
//System.Windows.MessageBox.Show(SelectedDetalle.IdMp + " s " + SelectedFormula.CodFormula);
}
public LoteSalidaCreateVM()
{
FormulasList = new List <Formula>(FormulaQueries.GetFormulas());
createLote = new CreateLoteSalidaCommand(this);
newOrden = new GenerateOrdenCommand(this);
NuevoLote = new LoteSalida();
SelectedFormula = FormulasList[0];
SalidaDetalles = new ObservableCollection <LoteSalidaDetalle>();
}
public void AgregarProcediminetoDetalle()
{
/*
* if (NewFormulaNewInstruction.Step == 0)
* {
* FormulaQueries.agregarProcedimiento(NewFormulaNewInstruction.Instruction, (NewFormulaInstructions.Count + 1), SelectedFormula.CodFormula);
*
* ProcedimientoDetalle testvar = new ProcedimientoDetalle()
* {
* Instruction = NewFormulaNewInstruction.Instruction
* };
*
* NewFormulaInstructions.Add(testvar);
*
* System.Windows.MessageBox.Show("Instruccion agregada");
* }
* else if (NewFormulaNewInstruction.Step > NewFormulaInstructions.Count)
* {
* System.Windows.MessageBox.Show("Porfavor ingrese un valor de orden no mayor al numero de instrucciones.");
* }
* else
* {*/
/* FormulaQueries.agregarProcedimientoEnPosicion(NewFormulaNewInstruction.Instruction, NewFormulaNewInstruction.Step, SelectedFormula.CodFormula);
* ProcedimientoDetalle testvar = new ProcedimientoDetalle()
* {
* Instruction = NewFormulaNewInstruction.Instruction
* };
* NewFormulaInstructions.Insert((NewFormulaNewInstruction.Step - 1), testvar);
*
* System.Windows.MessageBox.Show("Instruccion agregada");-*/
FormulaQueries.agregarProcedimiento(NewFormulaNewInstruction.Instruction, NewFormulaNewInstruction.Step, SelectedFormula.CodFormula);
ProcedimientoDetalle testvar = new ProcedimientoDetalle()
{
Instruction = NewFormulaNewInstruction.Instruction,
Step = NewFormulaNewInstruction.Step
};
NewFormulaInstructions.Add(testvar);
System.Windows.MessageBox.Show("Instruccion agregada");
// }
}
public void AgregarDetalle()
{
var testDetalle = new DetalleFormula
{
Name = NewFormulaSelectedProduct.Nombre,
IdMp = NewFormulaSelectedProduct.Codigo,
Quantity = NewFormulaNewDetalle.Quantity,
Unidad = NewFormulaSelectedProduct.Unidad
};
if (Detalles.Any(p => p.Name == testDetalle.Name))
{
MessageBox.Show("Esta MP ya se encuentra en la formula.");
}
else
{
FormulaQueries.agregarDetalle(testDetalle, SelectedFormula.CodFormula);
Detalles.Add(testDetalle);
}
}
public void createFormula()
{
if (FormulaQueries.isRepeatedFormula(NewFormula.CodFormula))
{
MessageBox.Show("Codigo de Formula ya existe.");
}
else
{
if (isTransform)
{
NewFormula.Transformacion = TransformFormula.CodFormula;
}
else
{
NewFormula.Transformacion = "";
}
//MessageBox.Show(NewFormula.FormaFarm + NewFormula.Cantidad);
//System.Windows.MessageBox.Show("This is form" + NewFormula.FormaFarm);
FormulaQueries.agregarFormula(NewFormulaDetalles.ToList(), NewFormula);
Formulas.Add(NewFormula);
if (NewFormulaInstructions.Count > 0)
{
foreach (var element in NewFormulaInstructions)
{
CurrentStep++;
FormulaQueries.agregarProcedimiento(element.Instruction, CurrentStep, NewFormula.CodFormula);
}
}
System.Windows.MessageBox.Show("Formula Maestra creada.");
limpiar(1);
}
}
public void EditarProcediminetoDetalle(object parameter)
{
FormulaQueries.updateProcedimiento(SelectedFormulaInstruction, SelectedFormula.CodFormula);
}
public void FormulaProcedimientoModal(object parameter)
{
NewFormulaInstructions = new ObservableCollection <ProcedimientoDetalle>(FormulaQueries.GetProcedimientoDetalles(SelectedFormula.CodFormula));
SelectedFormulaInstruction = new ProcedimientoDetalle();
var testview = new FormulaInstrucctionsModal(this);
testview.ShowDialog();
}
public void UpdateDetallesList(object parameter)
{
Detalles = new ObservableCollection <DetalleFormula>(FormulaQueries.GetDetalles(SelectedFormula.CodFormula));
}
