public static bool InsertExternalInvoiceSell(ExternalInvoiceSellModel externalInvoiceSellModel) { try { using (IDbConnection cnn = new MySqlConnection(LoadConnectionString())) { cnn.Execute("INSERT INTO ExternalInvoiceSell (idDetailExternalInvoiceSell, Product_idProduct1) VALUES(@idDetailExternalInvoiceSell, @Product_idProduct1)", externalInvoiceSellModel); } return(true); } catch (Exception ex) { throw; } }
public static bool InsertExternalInvoice(string idInvoice, string idProduct) { try { ExternalInvoiceSellModel externalInvoiceSellModel = new ExternalInvoiceSellModel() { idDetailExternalInvoiceSell = int.Parse(idInvoice), Product_idProduct = int.Parse(idProduct) }; return(DBExternalInvoiceSell.InsertExternalInvoiceSell(externalInvoiceSellModel)); } catch (Exception ex) { throw; } }
public static ExternalInvoiceSellModel SelectExternalInvoiceProductsById(ExternalInvoiceSellModel externalInvoiceSellModel) { try { using (IDbConnection cnn = new MySqlConnection(LoadConnectionString())) { var output = cnn.Query <ExternalInvoiceSellModel>("SELECT * FROM ExternalInvoiceSell WHERE idDetailExternalInvoiceSell like @idDetailExternalInvoiceSell", externalInvoiceSellModel); return(output.Single()); } } catch (Exception ex) { return(null); } }