public bool AddCashBackDetails(CashBackDetailsInfo cashBackDetailsInfo, DbTransaction dbTrans = null)
{
DbCommand sqlStringCommand = this.database.GetSqlStringCommand("INSERT INTO Hishop_CashBackDetails (CashBackId,CashBackAmount,CashBackType,CashBackDate) VALUES(@CashBackId,@CashBackAmount,@CashBackType,@CashBackDate)");
this.database.AddInParameter(sqlStringCommand, "CashBackId", DbType.Int32, cashBackDetailsInfo.CashBackId);
this.database.AddInParameter(sqlStringCommand, "CashBackAmount", DbType.Decimal, cashBackDetailsInfo.CashBackAmount);
this.database.AddInParameter(sqlStringCommand, "CashBackType", DbType.Int32, (int)cashBackDetailsInfo.CashBackType);
this.database.AddInParameter(sqlStringCommand, "CashBackDate", DbType.DateTime, cashBackDetailsInfo.CashBackDate);
if (dbTrans == null)
{
return(this.database.ExecuteNonQuery(sqlStringCommand) > 0);
}
return(this.database.ExecuteNonQuery(sqlStringCommand, dbTrans) > 0);
}
public static bool AddCashBackDetails(CashBackDetailsInfo cashBackDetailsInfo, DbTransaction dbTrans = null)
{
return(new CashBackDao().AddCashBackDetails(cashBackDetailsInfo, dbTrans));
}
