Beispiel #1
0
 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);
 }