public static int AddCurrency(tCurrency currency)
{
try
{
return AccountingDataProvider.AddCurrency(currency);
}
catch (Exception exception)
{
throw new Exception(exception.Message);
}
}
public static int AddCurrency(tCurrency currency)
{
int rowsAdded;
using (IDbConnection connection = DbConnectionHelper.GetConnection())
{
var query =
new StringBuilder(
"INSERT INTO tCurrency(Code, Description, Note,Sign,CurrentRate,LastRate,UpdateDateTime)");
query.Append("VALUES(@Code, @Description, @Note,@Sign,@CurrentRate,@LastRate,@UpdateDateTime)");
rowsAdded = connection.Execute(query.ToString(), currency);
}
return rowsAdded;
}
public static int UpdateCurrency(tCurrency currency)
{
int rowsAdded;
using (IDbConnection connection = DbConnectionHelper.GetConnection())
{
var query =
new StringBuilder(
"UPDATE tCurrency SET Description = @Description,Note = @Note,Sign=@Sign,CurrentRate=@CurrentRate,LastRate=@LastRate,UpdateDateTime=@UpdateDateTime ");
query.Append(" WHERE Code = @Code");
rowsAdded = connection.Execute(query.ToString(), currency);
}
return rowsAdded;
}
public static int DeleteCurrency(tCurrency currency)
{
int rowsAdded;
using (IDbConnection connection = DbConnectionHelper.GetConnection())
{
var query =
new StringBuilder("DELETE FROM tCurrency WHERE Code = @Code");
rowsAdded = connection.Execute(query.ToString(), currency);
}
return rowsAdded;
}