public static int UpdateApprovedAssetOffer(int legalEntityId, string assetCode, DateTime?endDate) { var sqlCommand = BuildEndApprovedAssetOffer_Update(legalEntityId, assetCode, endDate); var result = AdoService.Update(sqlCommand); return(result); }
public static string GetTestRead() { var sqlCommand = AdoService.BuildTest_Read(); var dt = AdoService.Fetch(sqlCommand); string json = JsonConvert.SerializeObject(dt, Formatting.Indented); return(json); }
public static string GetApprovedAssetOffer(int legalEntityId, string assetCode) { var sqlCommand = BuildEndApprovedAssetOffer_Read(legalEntityId, assetCode); var dt = AdoService.Fetch(sqlCommand); string json = JsonConvert.SerializeObject(dt, Formatting.Indented); return(json); }
private static SqlCommand BuildEndApprovedAssetOffer_Read(int legalEntityId, string assetCode) { var paraLegalEntityId = new SqlParameter("LegalEntityId", legalEntityId); var paraAssetCode = new SqlParameter("AssetCode", assetCode); return(AdoService.BuildSqlCommand( "EndApprovedAssetOffer.Read", paraLegalEntityId, paraAssetCode )); }
private static SqlCommand BuildEndApprovedAssetOffer_Update(int legalEntityId, string assetCode, DateTime?endDate) { var paraEndDate = new SqlParameter("EndDate", SqlDbType.DateTime); paraEndDate.Value = (object)endDate ?? DBNull.Value; var paraAssetCode = new SqlParameter("AssetCode", assetCode); var paraLegalEntityId = new SqlParameter("LegalEntityId", legalEntityId); return(AdoService.BuildSqlCommand( "EndApprovedAssetOffer.Update", paraEndDate, paraAssetCode, paraLegalEntityId )); }