public bool IsExisted(CurrencyMasterInfo currency)
{
String query = "SELECT Count(*) FROM CurrencyMaster WHERE CurrencyCode = @CurrencyCode ";
var obj = (List <int>)db.Query <int>(query, new { CurrencyCode = currency.CurrencyCode }, transaction);
return(obj[0] > 0);
}
public void Update(CurrencyMasterInfo currency)
{
String query = "UPDATE [dbo].[CurrencyMaster] "
+ "SET "
+ "[Currency] = @Currency "
+ ",[Rate] = @Rate "
+ ",[LastModifiedUser] = @LastModifiedUser "
+ ",[LastModifiedDate] = @LastModifiedDate "
+ "WHERE CurrencyCode = @CurrencyCode ";
db.Execute(query, currency, transaction);
}
public void Insert(CurrencyMasterInfo currency)
{
String query = "INSERT INTO [dbo].[CurrencyMaster] "
+ "([CurrencyCode] "
+ ",[Currency] "
+ ",[Rate] "
+ ",[CreateUser] "
+ ",[CreateDate] "
+ ",[LastModifiedUser] "
+ ",[LastModifiedDate] ) "
+ "VALUES "
+ "(@CurrencyCode "
+ ",@Currency "
+ ",@Rate "
+ ",@CreateUser "
+ ",@CreateDate "
+ ",@LastModifiedUser "
+ ",@LastModifiedDate ) ";
db.Execute(query, currency, transaction);
}
