public static DetailExternalSellinvoiceModel SelectExternalInvoiceById(DetailExternalSellinvoiceModel externalSellinvoiceModel)
{
using (IDbConnection cnn = new MySqlConnection(LoadConnectionString()))
{
var output = cnn.QuerySingle <DetailExternalSellinvoiceModel>("SELECT * FROM DetailExternalInvoiceSell WHERE NumberInvoice = @NumberInvoice", externalSellinvoiceModel);
return(output);
}
}
public static bool updateExternalSellinvoice(
string NumberInvoice,
DateTime ActualDate,
int IdClient,
int IdEmployee,
int IdBusiness,
string CurrencyType,
string IviAmount,
string CashDeposit,
string CreditDeposit,
decimal TotalDiscount,
decimal SubTotal,
decimal Total
)
{
try
{
string[] externalSellinvoice = new string[] {
NumberInvoice,
CurrencyType,
IviAmount,
CashDeposit,
CreditDeposit
};
if (ValidateData.VerifyFields(externalSellinvoice))
{
DetailExternalSellinvoiceModel externalSellinvoiceModel = new DetailExternalSellinvoiceModel()
{
NumberInvoice = int.Parse(NumberInvoice),
ActualDate = ActualDate,
IdClient = IdClient,
IdEmployee = IdEmployee,
IdBusiness = IdBusiness,
CurrencyType = CurrencyType,
IviAmount = decimal.Parse(IviAmount),
CashDeposit = decimal.Parse(CashDeposit),
CreditDeposit = decimal.Parse(CreditDeposit),
TotalDiscount = TotalDiscount,
SubTotal = SubTotal,
Total = Total
};
return(DBDetailExternalInvoiceSell.UpdateExternalInvoice(externalSellinvoiceModel));
}
else
{
return(false);
}
}
catch (Exception ex)
{
//Log4Net
return(false);
}
}
public static bool DeleteExternalSellInvoice(DetailExternalSellinvoiceModel externalSellinvoiceModel)
{
try
{
using (IDbConnection cnn = new MySqlConnection(LoadConnectionString()))
{
cnn.Execute("DELETE DetailExternalInvoiceSell WHERE NumberInvoice = @NumberInvoice)", externalSellinvoiceModel);
}
return(true);
}
catch (Exception ex)
{
return(false);
}
}
public static bool UpdateExternalInvoice(DetailExternalSellinvoiceModel externalSellinvoiceModel)
{
try
{
using (IDbConnection cnn = new MySqlConnection(LoadConnectionString()))
{
cnn.Execute("UPDATE detailexternalinvoicesell SET (idClient, idEmployee, idBusiness, currencyType, iviAmount, cashDeposit, cardDeposit, totalDiscount, subTotal, Total) VALUES(" +
"@ActualDate, @idClient, @idEmployee, @idBusiness,@currencyType, @iviAmount, @cashDeposit, @cardDeposit,@totalDiscount, @subTotal, @Total)", externalSellinvoiceModel);
}
return(true);
}
catch (Exception ex)
{
return(false);
}
}
public static bool InsertExternalSellinvoice(
int IdClient,
int IdEmployee,
int IdBusiness,
string CurrencyType,
decimal IviAmount,
decimal CashDeposit,
decimal CreditDeposit,
decimal TotalDiscount,
decimal SubTotal,
decimal Total
)
{
try
{
string[] externalSellinvoice = new string[] {
CurrencyType,
};
if (ValidateData.VerifyFields(externalSellinvoice))
{
DetailExternalSellinvoiceModel externalSellinvoiceModel = new DetailExternalSellinvoiceModel()
{
IdClient = IdClient,
IdEmployee = IdEmployee,
IdBusiness = IdBusiness,
CurrencyType = CurrencyType,
IviAmount = IviAmount,
CashDeposit = CashDeposit,
CreditDeposit = CreditDeposit,
TotalDiscount = TotalDiscount,
SubTotal = SubTotal,
Total = Total
};
return(DBDetailExternalInvoiceSell.InsertExternalInvoice(externalSellinvoiceModel));
}
else
{
return(false);
}
}
catch (Exception ex)
{
//Log4Net
return(false);
}
}
/// <summary>
///
/// </summary>
/// <param name="idExternalSellinvoice"></param>
/// <returns></returns>
public static DetailExternalSellinvoiceModel SelectExternalSellinvoiceById(string idExternalSellinvoice)
{
try
{
string[] externalSellinvoice = new string[] { idExternalSellinvoice };
if (ValidateData.VerifyFields(externalSellinvoice))
{
DetailExternalSellinvoiceModel externalSellinvoiceModel = new DetailExternalSellinvoiceModel()
{
NumberInvoice = int.Parse(idExternalSellinvoice)
};
return(DBDetailExternalInvoiceSell.SelectExternalInvoiceById(externalSellinvoiceModel));
}
else
{
return(null);
}
}
catch (Exception ex)
{
//Log4Net
return(null);
}
}
/// <summary>
///
/// </summary>
/// <param name="idExternalSellinvoice"></param>
/// <returns></returns>
public static bool DeleteExternalSellinvoiceById(string idExternalSellinvoice)
{
try
{
string[] externalSellinvoice = new string[] { idExternalSellinvoice };
if (ValidateData.VerifyFields(externalSellinvoice))
{
DetailExternalSellinvoiceModel internalSellinvoiceModel = new DetailExternalSellinvoiceModel()
{
NumberInvoice = int.Parse(idExternalSellinvoice)
};
return(DBDetailExternalInvoiceSell.DeleteExternalSellInvoice(internalSellinvoiceModel));
}
else
{
return(false);
}
}
catch (Exception ex)
{
return(false);
//Log4Net
}
}