public void UpdatePriceByUnitIdProductId(int unitId, int productId, SqlConnection con, IDbTransaction transaction)
{
int UpdatedBy = Convert.ToInt32(HttpContext.Current.Session["UserId"]);
var result = _dapperManager.ExecuteScalar <ProductPrice>(con, "UPDATE ProductPrice SET Status=0,IsPrimary=0,UpdatedBy=@UpdatedBy WHERE UnitId=@unitId AND ProductId=@productId", new { UpdatedBy, unitId, productId }, transaction);
}
public void MakeIsCurrentFalse(SqlConnection con, IDbTransaction transaction)
{
_dapperManager.ExecuteScalar <FiscalYear>(con, "UPDATE FiscalYear SET IsCurrent=0 WHERE IsCurrent=1", null, transaction);
}