public static bool InsertDetailsInputExit(string idEmployee, string destiny, string provider)
{
try
{
string[] inputInvoice = new string[] { idEmployee, destiny, provider };
if (ValidateData.VerifyFields(inputInvoice))
{
InputExitDetaillsModel inputInvoiceModel = new InputExitDetaillsModel()
{
idEmployee = int.Parse(idEmployee),
destinyBusiness = int.Parse(destiny),
ProviderBusiness = int.Parse(provider)
};
return(DBDetailsInputExit.InsertInputExitInvoice(inputInvoiceModel));
}
else
{
return(false);
}
}
catch (Exception ex)
{
//Log4Net
return(false);
}
}
public static List <InputExitDetaillsModel> SelectAllInputExitInvoice(InputExitDetaillsModel DetailsInputExit)
{
using (IDbConnection cnn = new MySqlConnection(LoadConnectionString()))
{
var output = cnn.Query <InputExitDetaillsModel>("SELECT * FROM detailinvoice", DetailsInputExit);
return(output.ToList());
}
}
public static InputExitDetaillsModel SelectInputExitInvoiceByIdNum(InputExitDetaillsModel IdNum)
{
using (IDbConnection cnn = new MySqlConnection(LoadConnectionString()))
{
var output = cnn.Query <InputExitDetaillsModel>("SELECT * FROM detailinvoice WHERE idNumInvoice = @idNumInvoice", IdNum);
return(output.Single());
}
}
private void commitButton_Click(object sender, EventArgs e)
{
EmployeeModel employee = (EmployeeModel)EmployeeComboBox.SelectedItem;
BusinessModel destiny = (BusinessModel)DestinyComboBox.SelectedItem;
BusinessModel provider = (BusinessModel)ProviderComboBox.SelectedItem;
try
{
if (MinusQuantity(provider))
{
if (DetaillsInputExitManagement.InsertDetailsInputExit(employee.IdEmployee.ToString(), destiny.IdBusiness.ToString(), provider.IdBusiness.ToString()))
{
InputExitDetaillsModel id = DetaillsInputExitManagement.SelectDetailsInputExitID();
for (int i = 0; i < dgvInputExitProduct.RowCount; i++)
{
string idProduct = dgvInputExitProduct.Rows[i].Cells[0].Value.ToString();
int quantity = int.Parse(dgvInputExitProduct.Rows[i].Cells[4].Value.ToString());
if (InputExitInvoiceManagement.InsertInputExitInvoice(id.idNumInvoice.ToString(), idProduct, quantity.ToString()))
{
if (destiny.fantasyName.ToString().Equals("Principal"))
{
ProductModel LastQuantity = ProductManagement.SelectProductById(idProduct);
int newQuantity = LastQuantity.variableQuantity + quantity;
ProductManagement.UpdateQuantity(idProduct, newQuantity.ToString());
}
if (provider.fantasyName.ToString().Equals("Principal"))
{
ProductModel LastQuantity = ProductManagement.SelectProductById(idProduct);
int newQuantity = LastQuantity.variableQuantity - quantity;
ProductManagement.UpdateQuantity(idProduct, newQuantity.ToString());
}
}
else
{
FrmMain.Instance.ToolStripLabel.Text = "Error al agregar la factura de entrada";
}
}
FrmMain.Instance.ToolStripLabel.Text = "Producto modificado correctamente";
}
}
else
{
MessageBox.Show("La cantidad no puede ser menor que la que se cuenta en la tienda");
}
}
catch (Exception)
{
throw;
}
}
public static bool InsertInputExitInvoice(InputExitDetaillsModel DetailsInputExit)
{
try
{
using (IDbConnection cnn = new MySqlConnection(LoadConnectionString()))
{
cnn.Execute("INSERT INTO detailinvoice (idEmployee, Provider, Destiny)" +
" VALUES(@idEmployee, @providerBusiness, @destinyBusiness)", DetailsInputExit);
}
return(true);
}
catch (Exception ex)
{
throw;
}
}
