public void LoadList()
{
foreach (DataRow drAccountBudget in AccountBudget.GetDSG(ddlDivision.SelectedValue.ToString(), Convert.ToInt16(ddlFiscalYear.SelectedValue)).Rows)
{
Response.Write("<tr>");
Response.Write("<td class='GridRows'><a href='AccountBudgetDivisionViewer.aspx?rccode=" + drAccountBudget["rccode"] + "'>" + drAccountBudget["rccode"] + "</td>");
Response.Write("<td class='GridRows'>" + drAccountBudget["rcname"] + "</td>");
if (Convert.ToDouble(drAccountBudget["bud_value"]) < 0)
{
Response.Write("<td class='GridRows' style='text-align:right;'>(" + (Convert.ToDouble(drAccountBudget["bud_value"]) * -1).ToString("###,##0.00") + ")</td>");
}
else
{
Response.Write("<td class='GridRows' style='text-align:right;'>" + Convert.ToDouble(drAccountBudget["bud_value"]).ToString("###,##0.00") + "</td>");
}
if (Convert.ToDouble(drAccountBudget["availed_value"]) < 0)
{
Response.Write("<td class='GridRows' style='text-align:right;'>(" + (Convert.ToDouble(drAccountBudget["availed_value"]) * -1).ToString("###,##0.00") + ")</td>");
}
else
{
Response.Write("<td class='GridRows' style='text-align:right;'>" + Convert.ToDouble(drAccountBudget["availed_value"]).ToString("###,##0.00") + "</td>");
}
if ((Convert.ToDouble(drAccountBudget["bud_value"]) - Convert.ToDouble(drAccountBudget["availed_value"])) < 0)
{
Response.Write("<td class='GridRows' style='text-align:right;'>(" + ((Convert.ToDouble(drAccountBudget["bud_value"]) - Convert.ToDouble(drAccountBudget["availed_value"])) * -1).ToString("###,##0.00") + ")</td>");
}
else
{
Response.Write("<td class='GridRows' style='text-align:right;'>" + (Convert.ToDouble(drAccountBudget["bud_value"]) - Convert.ToDouble(drAccountBudget["availed_value"])).ToString("###,##0.00") + "</td>");
}
Response.Write("</tr>");
}
}
public void LoadGrid()
{
string strWrite = "";
int intCounter = 0;
double dblAmountPossitive = 0;
double dblAmountNegative = 0;
foreach (DataRow drBudgetItem in AccountBudget.GetDSGforAdjustmentBudget(Request.QueryString["rccode"], Convert.ToInt16(ddlFiscalYear.SelectedValue), Request.QueryString["accnt_items_code"].ToString()).Rows)
{
intCounter += 1;
strWrite += "<tr>";
strWrite += "<td class='GridRows'>" + intCounter.ToString() + "</td>";
strWrite += "<td class='GridRows'>" + drBudgetItem["created_on"].ToString() + "</td>";
strWrite += "<td class='GridRows'>" + drBudgetItem["accnt_bud_cat_name"].ToString() + "</td>";
strWrite += "<td class='GridRows'>" + drBudgetItem["remarks"].ToString() + "</td>";
if (drBudgetItem["accnt_bud_cat_code"].ToString() == "04")
{
strWrite += "<td class='GridRows' style='text-align:right;'>(" + Convert.ToDouble(drBudgetItem["bud_value"]).ToString("###,##0.00") + ")</td>";
dblAmountNegative += Convert.ToDouble(drBudgetItem["bud_value"]);
}
else
{
strWrite += "<td class='GridRows' style='text-align:right;'>" + Convert.ToDouble(drBudgetItem["bud_value"]).ToString("###,##0.00") + "</td>";
dblAmountPossitive += Convert.ToDouble(drBudgetItem["bud_value"]);
}
strWrite += "</tr>";
}
strWrite += "<tr><td colspan='4' class='GridRows' style='text-align:right;'>Total</td><td class='GridRows' style='text-align:right;'>" + (dblAmountPossitive - dblAmountNegative).ToString("###,##0.00") + "</td></tr>";
lblItems.Text = strWrite;
}
protected void btnSave_Click(object sender, EventArgs e)
{
divError.Visible = false;
using (AccountBudget objAccountBudget = new AccountBudget())
{
objAccountBudget.AccountBudgetCategoryCode = "01";
objAccountBudget.FiscalYearCode = Convert.ToInt16(ddlFiscalYear.SelectedValue);
objAccountBudget.ResponsibilityCode = Request.QueryString["rccode"].ToString();
objAccountBudget.ChargeTypeCode = "01";
objAccountBudget.AccountItemCode = Convert.ToInt16(ddlAccountItem.SelectedValue);
objAccountBudget.BudgetValue = Convert.ToDouble(txtInitialBudget.Text);
objAccountBudget.Remarks = txtRemarks.Text;
objAccountBudget.CreatedBy = Request.Cookies["Speedo"]["UserName"].ToString();
objAccountBudget.CreatedOn = DateTime.Now;
objAccountBudget.ModifiedBy = Request.Cookies["Speedo"]["UserName"].ToString();
objAccountBudget.ModifiedOn = DateTime.Now;
objAccountBudget.RecordStatus = "1";
if (AccountBudget.IsInitialBudgetExist(Convert.ToInt16(ddlFiscalYear.SelectedValue), Request.QueryString["rccode"].ToString(), Convert.ToInt16(ddlAccountItem.SelectedValue)) == false)
{
if (objAccountBudget.Insert() > 0)
{
this.LoadGrid();
}
}
else
{
divError.Visible = true;
lblErrMsg.Text = "Budget for the selected account item already initialized.";
}
}
}
/// <summary>Snippet for GetAccountBudget</summary>
/// <remarks>
/// This snippet has been automatically generated for illustrative purposes only.
/// It may require modifications to work in your environment.
/// </remarks>
public void GetAccountBudget()
{
// Create client
AccountBudgetServiceClient accountBudgetServiceClient = AccountBudgetServiceClient.Create();
// Initialize request argument(s)
string resourceName = "customers/[CUSTOMER]/accountBudgets/[ACCOUNT_BUDGET]";
// Make the request
AccountBudget response = accountBudgetServiceClient.GetAccountBudget(resourceName);
}
/// <summary>Snippet for GetAccountBudget</summary>
/// <remarks>
/// This snippet has been automatically generated for illustrative purposes only.
/// It may require modifications to work in your environment.
/// </remarks>
public void GetAccountBudgetResourceNames()
{
// Create client
AccountBudgetServiceClient accountBudgetServiceClient = AccountBudgetServiceClient.Create();
// Initialize request argument(s)
AccountBudgetName resourceName = AccountBudgetName.FromCustomerAccountBudget("[CUSTOMER]", "[ACCOUNT_BUDGET]");
// Make the request
AccountBudget response = accountBudgetServiceClient.GetAccountBudget(resourceName);
}
/// <summary>
/// Update an existing entity
/// </summary>
/// <param name="cf">A company file that has been retrieved</param>
/// <param name="entity">The entity to update</param>
/// <param name="credentials">The credentials to access the company file</param>
/// <param name="errorLevel"></param>
/// <returns></returns>
public string Update(CompanyFile cf, AccountBudget entity, ICompanyFileCredentials credentials,
ErrorLevel errorLevel = ErrorLevel.IgnoreWarnings)
{
var queryString = QueryStringFromErrorLevel(errorLevel);
return
(MakeApiPutRequestSync(
BuildUri(cf, entity.FinancialYear,
extraQueryString: queryString), entity, credentials));
}
/// <summary>
/// Update an existing entity
/// </summary>
/// <param name="cf">A company file that has been retrieved</param>
/// <param name="entity">The entity to update</param>
/// <param name="credentials">The credentials to access the company file</param>
/// <param name="onComplete">The action to call when the operation is complete</param>
/// <param name="onError">The action to call when the operation has an error</param>
/// <param name="errorLevel"></param>
public void Update(CompanyFile cf, AccountBudget entity, ICompanyFileCredentials credentials,
Action <HttpStatusCode, string> onComplete, Action <Uri, Exception> onError,
ErrorLevel errorLevel = ErrorLevel.IgnoreWarnings)
{
var queryString = QueryStringFromErrorLevel(errorLevel);
MakeApiPutRequestDelegate(
BuildUri(cf, entity.FinancialYear, extraQueryString: queryString),
entity, credentials, onComplete, onError);
}
/// <summary>Snippet for GetAccountBudgetAsync</summary>
/// <remarks>
/// This snippet has been automatically generated for illustrative purposes only.
/// It may require modifications to work in your environment.
/// </remarks>
public async Task GetAccountBudgetResourceNamesAsync()
{
// Create client
AccountBudgetServiceClient accountBudgetServiceClient = await AccountBudgetServiceClient.CreateAsync();
// Initialize request argument(s)
AccountBudgetName resourceName = AccountBudgetName.FromCustomerAccountBudget("[CUSTOMER_ID]", "[ACCOUNT_BUDGET_ID]");
// Make the request
AccountBudget response = await accountBudgetServiceClient.GetAccountBudgetAsync(resourceName);
}
/// <summary>Snippet for GetAccountBudgetAsync</summary>
/// <remarks>
/// This snippet has been automatically generated for illustrative purposes only.
/// It may require modifications to work in your environment.
/// </remarks>
public async Task GetAccountBudgetAsync()
{
// Create client
AccountBudgetServiceClient accountBudgetServiceClient = await AccountBudgetServiceClient.CreateAsync();
// Initialize request argument(s)
string resourceName = "customers/[CUSTOMER_ID]/accountBudgets/[ACCOUNT_BUDGET_ID]";
// Make the request
AccountBudget response = await accountBudgetServiceClient.GetAccountBudgetAsync(resourceName);
}
/// <summary>Snippet for GetAccountBudget</summary>
public void GetAccountBudgetResourceNames()
{
// Snippet: GetAccountBudget(AccountBudgetName, CallSettings)
// Create client
AccountBudgetServiceClient accountBudgetServiceClient = AccountBudgetServiceClient.Create();
// Initialize request argument(s)
AccountBudgetName resourceName = AccountBudgetName.FromCustomerAccountBudget("[CUSTOMER_ID]", "[ACCOUNT_BUDGET_ID]");
// Make the request
AccountBudget response = accountBudgetServiceClient.GetAccountBudget(resourceName);
// End snippet
}
/// <summary>
/// Update an existing entity
/// </summary>
/// <param name="cf">A company file that has been retrieved</param>
/// <param name="entity">The entity to update</param>
/// <param name="credentials">The credentials to access the company file</param>
/// <param name="errorLevel"></param>
/// <param name="cancellationToken"></param>
/// <returns></returns>
public Task <string> UpdateAsync(CompanyFile cf, AccountBudget entity, ICompanyFileCredentials credentials,
CancellationToken cancellationToken,
ErrorLevel errorLevel = ErrorLevel.IgnoreWarnings)
{
var queryString = QueryStringFromErrorLevel(errorLevel);
return
(this.MakeApiPutRequestAsync(
this.BuildUri(cf, entity.FinancialYear,
extraQueryString: queryString), entity, credentials, cancellationToken));
}
/// <summary>Snippet for GetAccountBudget</summary>
public void GetAccountBudget()
{
// Snippet: GetAccountBudget(string, CallSettings)
// Create client
AccountBudgetServiceClient accountBudgetServiceClient = AccountBudgetServiceClient.Create();
// Initialize request argument(s)
string resourceName = "customers/[CUSTOMER_ID]/accountBudgets/[ACCOUNT_BUDGET_ID]";
// Make the request
AccountBudget response = accountBudgetServiceClient.GetAccountBudget(resourceName);
// End snippet
}
/// <summary>Snippet for GetAccountBudget</summary>
/// <remarks>
/// This snippet has been automatically generated for illustrative purposes only.
/// It may require modifications to work in your environment.
/// </remarks>
public void GetAccountBudgetRequestObject()
{
// Create client
AccountBudgetServiceClient accountBudgetServiceClient = AccountBudgetServiceClient.Create();
// Initialize request argument(s)
GetAccountBudgetRequest request = new GetAccountBudgetRequest
{
ResourceNameAsAccountBudgetName = AccountBudgetName.FromCustomerAccountBudget("[CUSTOMER_ID]", "[ACCOUNT_BUDGET_ID]"),
};
// Make the request
AccountBudget response = accountBudgetServiceClient.GetAccountBudget(request);
}
/// <summary>Snippet for GetAccountBudgetAsync</summary>
/// <remarks>
/// This snippet has been automatically generated for illustrative purposes only.
/// It may require modifications to work in your environment.
/// </remarks>
public async Task GetAccountBudgetRequestObjectAsync()
{
// Create client
AccountBudgetServiceClient accountBudgetServiceClient = await AccountBudgetServiceClient.CreateAsync();
// Initialize request argument(s)
GetAccountBudgetRequest request = new GetAccountBudgetRequest
{
ResourceNameAsAccountBudgetName = AccountBudgetName.FromCustomerAccountBudget("[CUSTOMER]", "[ACCOUNT_BUDGET]"),
};
// Make the request
AccountBudget response = await accountBudgetServiceClient.GetAccountBudgetAsync(request);
}
/// <summary>Snippet for GetAccountBudgetAsync</summary>
public async Task GetAccountBudgetAsync()
{
// Snippet: GetAccountBudgetAsync(string, CallSettings)
// Additional: GetAccountBudgetAsync(string, CancellationToken)
// Create client
AccountBudgetServiceClient accountBudgetServiceClient = await AccountBudgetServiceClient.CreateAsync();
// Initialize request argument(s)
string resourceName = "customers/[CUSTOMER_ID]/accountBudgets/[ACCOUNT_BUDGET_ID]";
// Make the request
AccountBudget response = await accountBudgetServiceClient.GetAccountBudgetAsync(resourceName);
// End snippet
}
/// <summary>Snippet for GetAccountBudgetAsync</summary>
public async Task GetAccountBudgetResourceNamesAsync()
{
// Snippet: GetAccountBudgetAsync(AccountBudgetName, CallSettings)
// Additional: GetAccountBudgetAsync(AccountBudgetName, CancellationToken)
// Create client
AccountBudgetServiceClient accountBudgetServiceClient = await AccountBudgetServiceClient.CreateAsync();
// Initialize request argument(s)
AccountBudgetName resourceName = AccountBudgetName.FromCustomerAccountBudget("[CUSTOMER_ID]", "[ACCOUNT_BUDGET_ID]");
// Make the request
AccountBudget response = await accountBudgetServiceClient.GetAccountBudgetAsync(resourceName);
// End snippet
}
public void LoadList()
{
foreach (DataRow drAccountBudget in AccountBudget.GetDSG(ddlDivision.SelectedValue.ToString(), Convert.ToInt16(ddlFiscalYear.SelectedValue)).Rows)
{
Response.Write("<tr>");
Response.Write("<td class='GridRows'><a href='AccountBudgetMaintenance.aspx?rccode=" + drAccountBudget["rccode"] + "'>" + drAccountBudget["rccode"] + "</td>");
Response.Write("<td class='GridRows'>" + drAccountBudget["rcname"] + "</td>");
if (Convert.ToDouble(drAccountBudget["bud_value"]) < 0)
{
Response.Write("<td class='GridRows' style='text-align:right;'>(" + (Convert.ToDouble(drAccountBudget["bud_value"]) * -1).ToString("###,##0.00") + ")</td>");
}
else
{
Response.Write("<td class='GridRows' style='text-align:right;'>" + Convert.ToDouble(drAccountBudget["bud_value"]).ToString("###,##0.00") + "</td>");
}
if (Convert.ToDouble(drAccountBudget["availed_value"]) < 0)
{
Response.Write("<td class='GridRows' style='text-align:right;'>(" + (Convert.ToDouble(drAccountBudget["availed_value"]) * -1).ToString("###,##0.00") + ")</td>");
}
else
{
Response.Write("<td class='GridRows' style='text-align:right;'>" + Convert.ToDouble(drAccountBudget["availed_value"]).ToString("###,##0.00") + "</td>");
}
if ((Convert.ToDouble(drAccountBudget["bud_value"]) - Convert.ToDouble(drAccountBudget["availed_value"])) < 0)
{
Response.Write("<td class='GridRows' style='text-align:right;'>(" + ((Convert.ToDouble(drAccountBudget["bud_value"]) - Convert.ToDouble(drAccountBudget["availed_value"])) * -1).ToString("###,##0.00") + ")</td>");
}
else
{
Response.Write("<td class='GridRows' style='text-align:right;'>" + (Convert.ToDouble(drAccountBudget["bud_value"]) - Convert.ToDouble(drAccountBudget["availed_value"])).ToString("###,##0.00") + "</td>");
}
Response.Write("</tr>");
//Response.Write("<tr>");
}
//Response.Write("<tr>");
//Response.Write("<td class='GridRows'>1</td>");
//Response.Write("<td class='GridRows'>Management Information Systems</td>");
//Response.Write("<td class='GridRows' style='text-align:right;'>10,000,000</td>");
//Response.Write("<td class='GridRows' style='text-align:right;'>5,000,000</td>");
//Response.Write("<td class='GridRows' style='text-align:right;'>5,000,000</td>");
//Response.Write("</tr>");
//Response.Write("<tr>");
//Response.Write("<td class='GridRows2' colspan='2'>Category 1</td>");
//Response.Write("<td class='GridRows2' style='text-align:right;'>10,000,000</td>");
//Response.Write("<td class='GridRows2' style='text-align:right;'>5,000,000</td>");
//Response.Write("<td class='GridRows2' style='text-align:right;'>5,000,000</td>");
//Response.Write("</tr>");
}
public void GetAccountBudget2()
{
Mock <AccountBudgetService.AccountBudgetServiceClient> mockGrpcClient = new Mock <AccountBudgetService.AccountBudgetServiceClient>(MockBehavior.Strict);
GetAccountBudgetRequest request = new GetAccountBudgetRequest
{
ResourceName = new AccountBudgetName("[CUSTOMER]", "[ACCOUNT_BUDGET]").ToString(),
};
AccountBudget expectedResponse = new AccountBudget
{
ResourceName = "resourceName2625949903",
};
mockGrpcClient.Setup(x => x.GetAccountBudget(request, It.IsAny <CallOptions>()))
.Returns(expectedResponse);
AccountBudgetServiceClient client = new AccountBudgetServiceClientImpl(mockGrpcClient.Object, null);
AccountBudget response = client.GetAccountBudget(request);
Assert.AreEqual(expectedResponse, response);
mockGrpcClient.VerifyAll();
}
public async Task GetAccountBudgetAsync()
{
Mock <AccountBudgetService.AccountBudgetServiceClient> mockGrpcClient = new Mock <AccountBudgetService.AccountBudgetServiceClient>(MockBehavior.Strict);
GetAccountBudgetRequest expectedRequest = new GetAccountBudgetRequest
{
ResourceName = new AccountBudgetName("[CUSTOMER]", "[ACCOUNT_BUDGET]").ToString(),
};
AccountBudget expectedResponse = new AccountBudget
{
ResourceName = "resourceName2625949903",
};
mockGrpcClient.Setup(x => x.GetAccountBudgetAsync(expectedRequest, It.IsAny <CallOptions>()))
.Returns(new Grpc.Core.AsyncUnaryCall <AccountBudget>(Task.FromResult(expectedResponse), null, null, null, null));
AccountBudgetServiceClient client = new AccountBudgetServiceClientImpl(mockGrpcClient.Object, null);
string formattedResourceName = new AccountBudgetName("[CUSTOMER]", "[ACCOUNT_BUDGET]").ToString();
AccountBudget response = await client.GetAccountBudgetAsync(formattedResourceName);
Assert.AreEqual(expectedResponse, response);
mockGrpcClient.VerifyAll();
}
protected override OpResult _Store(AccountBudget _obj)
{
if (_obj == null)
{
return(OpResult.NotifyStoreAction(OpResult.ResultStatus.ObjectIsNull, _obj, "AccountBudget object cannot be created as it is null"));
}
if (Exists(_obj))
{
ExecuteNonQuery(GetQuery_UpdateQuery(_obj));
return(OpResult.NotifyStoreAction(OpResult.ResultStatus.Updated, _obj));
}
ExecuteNonQuery(GetQuery_InsertQuery(_obj));
if (_obj.AccountBudgetID == null)
{
_obj.AccountBudgetID = DbMgr.GetLastInsertID();
}
_obj.FromDb = true;
return(OpResult.NotifyStoreAction(OpResult.ResultStatus.Created, _obj));
}
protected void btnSave_Click(object sender, EventArgs e)
{
divError.Visible = false;
using (AccountBudget objAccountBudget = new AccountBudget())
{
objAccountBudget.AccountBudgetCategoryCode = ddlBudgetCategory.SelectedValue.ToString();
objAccountBudget.FiscalYearCode = Convert.ToInt16(ddlFiscalYear.SelectedValue);
objAccountBudget.ResponsibilityCode = Request.QueryString["rccode"].ToString();
objAccountBudget.ChargeTypeCode = "01";
objAccountBudget.AccountItemCode = Convert.ToInt16(Request.QueryString["accnt_items_code"]);
objAccountBudget.BudgetValue = Convert.ToDouble(txtAmount.Text);
objAccountBudget.Remarks = txtRemarks.Text;
objAccountBudget.CreatedBy = Request.Cookies["Speedo"]["UserName"].ToString();
objAccountBudget.CreatedOn = DateTime.Now;
objAccountBudget.ModifiedBy = Request.Cookies["Speedo"]["UserName"].ToString();
objAccountBudget.ModifiedOn = DateTime.Now;
objAccountBudget.RecordStatus = "1";
if (objAccountBudget.Insert() > 0)
{
this.LoadGrid();
}
}
}
/// <summary>
/// Runs the code example.
/// </summary>
/// <param name="client">The Google Ads client.</param>
/// <param name="customerId">The Google Ads customer ID for which the call is made.</param>
public void Run(GoogleAdsClient client, long customerId)
{
// Get the GoogleAdsServiceClient.
GoogleAdsServiceClient googleAdsService = client.GetService(
Services.V3.GoogleAdsService);
// Construct a GAQL query which will retrieve AccountBudgetProposals.
String searchQuery =
@"SELECT
account_budget.status,
account_budget.billing_setup,
account_budget.approved_spending_limit_micros,
account_budget.approved_spending_limit_type,
account_budget.proposed_spending_limit_micros,
account_budget.proposed_spending_limit_type,
account_budget.approved_start_date_time,
account_budget.proposed_start_date_time,
account_budget.approved_end_date_time,
account_budget.approved_end_time_type,
account_budget.proposed_end_date_time,
account_budget.proposed_end_time_type
FROM
account_budget";
// Creates a request that will retrieve all account budgets using pages of the
// specified page size.
SearchGoogleAdsRequest request = new SearchGoogleAdsRequest()
{
PageSize = PAGE_SIZE,
Query = searchQuery,
CustomerId = customerId.ToString()
};
try
{
// Issues the search request.
PagedEnumerable <SearchGoogleAdsResponse, GoogleAdsRow> searchPagedResponse =
googleAdsService.Search(request);
// Iterates over all rows in all pages and prints the requested field values for
// the account budget in each row.
foreach (GoogleAdsRow googleAdsRow in searchPagedResponse)
{
AccountBudget budget = googleAdsRow.AccountBudget;
Console.WriteLine(String.Format("Account budget '{0}' with status '{1}', " +
"billing setup '{2}', amount served {3:0.00}, total adjustments " +
"{4:0.00}, approved spending limit '{5}' (proposed '{6}'), approved " +
"start time '{7}' (proposed '{8}'), approved end time '{9}' " +
"(proposed '{10}')",
budget.ResourceName,
budget.Status,
budget.BillingSetup,
budget.AmountServedMicros.Value / 1_000_000.0,
budget.TotalAdjustmentsMicros.Value / 1_000_000.0,
budget.ApprovedSpendingLimitMicros.HasValue
? String.Format(
"%.2f", budget.ApprovedSpendingLimitMicros.Value / 1_000_000.0)
: budget.ApprovedSpendingLimitType.ToString(),
budget.ProposedSpendingLimitMicros.HasValue
? String.Format(
"%.2f", budget.ProposedSpendingLimitMicros.Value / 1_000_000.0)
: budget.ProposedSpendingLimitType.ToString(),
budget.ApprovedStartDateTime,
budget.ProposedStartDateTime,
String.IsNullOrEmpty(budget.ApprovedEndDateTime)
? budget.ApprovedEndTimeType.ToString()
: budget.ApprovedEndDateTime,
String.IsNullOrEmpty(budget.ProposedEndDateTime)
? budget.ProposedEndTimeType.ToString()
: budget.ProposedEndDateTime));
}
}
catch (GoogleAdsException e)
{
Console.WriteLine("Failure:");
Console.WriteLine($"Message: {e.Message}");
Console.WriteLine($"Failure: {e.Failure}");
Console.WriteLine($"Request ID: {e.RequestId}");
throw;
}
}
/// <summary>
/// Runs the code example.
/// </summary>
/// <param name="client">The Google Ads client.</param>
/// <param name="customerId">The Google Ads customer ID for which the call is made.</param>
public void Run(GoogleAdsClient client, long customerId)
{
// Get the GoogleAdsServiceClient.
GoogleAdsServiceClient googleAdsService = client.GetService(
Services.V4.GoogleAdsService);
// Construct a GAQL query which will retrieve AccountBudgetProposals.
String query =
@"SELECT
account_budget.status,
account_budget.billing_setup,
account_budget.approved_spending_limit_micros,
account_budget.approved_spending_limit_type,
account_budget.proposed_spending_limit_micros,
account_budget.proposed_spending_limit_type,
account_budget.adjusted_spending_limit_micros,
account_budget.adjusted_spending_limit_type,
account_budget.approved_start_date_time,
account_budget.proposed_start_date_time,
account_budget.approved_end_date_time,
account_budget.approved_end_time_type,
account_budget.proposed_end_date_time,
account_budget.proposed_end_time_type
FROM
account_budget";
try
{
// Issues the search request.
googleAdsService.SearchStream(customerId.ToString(), query,
delegate(SearchGoogleAdsStreamResponse resp)
{
// Displays the results
foreach (GoogleAdsRow googleAdsRow in resp.Results)
{
AccountBudget budget = googleAdsRow.AccountBudget;
Console.WriteLine(String.Format("Account budget '{0}' with status '{1}', " +
"billing setup '{2}', amount served {3:0.00}, total adjustments " +
"{4:0.00}, approved spending limit '{5}' (proposed '{6}', " +
"adjusted '{7}'), approved start time '{8}' (proposed '{9}'), " +
"approved end time '{10}' (proposed '{11}')",
budget.ResourceName,
budget.Status,
budget.BillingSetup,
budget.AmountServedMicros.Value / 1_000_000.0,
budget.TotalAdjustmentsMicros.Value / 1_000_000.0,
budget.ApprovedSpendingLimitMicros.HasValue
? String.Format(
"%.2f", budget.ApprovedSpendingLimitMicros.Value / 1_000_000.0)
: budget.ApprovedSpendingLimitType.ToString(),
budget.ProposedSpendingLimitMicros.HasValue
? String.Format(
"%.2f", budget.ProposedSpendingLimitMicros.Value / 1_000_000.0)
: budget.ProposedSpendingLimitType.ToString(),
budget.AdjustedSpendingLimitMicros.HasValue
? String.Format(
"%.2f", budget.AdjustedSpendingLimitMicros.Value / 1_000_000.0)
: budget.AdjustedSpendingLimitType.ToString(),
budget.ApprovedStartDateTime,
budget.ProposedStartDateTime,
String.IsNullOrEmpty(budget.ApprovedEndDateTime)
? budget.ApprovedEndTimeType.ToString()
: budget.ApprovedEndDateTime,
String.IsNullOrEmpty(budget.ProposedEndDateTime)
? budget.ProposedEndTimeType.ToString()
: budget.ProposedEndDateTime));
}
}
);
}
catch (GoogleAdsException e)
{
Console.WriteLine("Failure:");
Console.WriteLine($"Message: {e.Message}");
Console.WriteLine($"Failure: {e.Failure}");
Console.WriteLine($"Request ID: {e.RequestId}");
throw;
}
}
private DbUpdateStatement GetQuery_UpdateQuery(AccountBudget _obj)
{
return(DbMgr.CreateUpdateClause("AccountBudgets", GetFields(_obj), "AccountBudgetID", _obj.AccountBudgetID));
}
public void LoadGrid()
{
//string strWrite = "";
//int intCounter = 0;
//double dblCategoryBudget = 0;
//double dblCategoryAvailed = 0;
//double dblCategoryVariant = 0;
//double dblCategoryTotalBudget = 0;
//double dblCategoryTotalAvailed = 0;
//foreach (DataRow drCategory in AccountCategory.GetDSG().Rows)
//{
// foreach (DataRow drAccountItems in AccountBudget.GetDSGRCBudget(clsEmployee.GetRCCode(Request.Cookies["Speedo"]["UserName"].ToString()), Convert.ToInt16(ddlFiscalYear.SelectedValue), drCategory["accnt_cat_code"].ToString()).Rows)
// {
// intCounter += 1;
// strWrite += "<tr>";
// strWrite += "<td class='GridRows'>" + drAccountItems["oracle_code"] + "</td>";
// strWrite += "<td class='GridRows'>" + drAccountItems["accnt_items_name"] + "</td>";
// if (Convert.ToDouble(drAccountItems["bud_value"]) < 0)//negative
// {
// strWrite += "<td class='GridRows' style='text-align:right;'><a href='AccountBudgetAdjustmentViewer.aspx?rccode=" + clsEmployee.GetRCCode(Request.Cookies["Speedo"]["UserName"].ToString()) + "&accnt_cat_code=" + drCategory["accnt_cat_code"].ToString() + "&accnt_items_code=" + drAccountItems["accnt_items_code"] + "'>(" + (Convert.ToDouble(drAccountItems["bud_value"]) * -1).ToString("###,##0.00") + ")</a></td>";
// }
// else //positive
// {
// strWrite += "<td class='GridRows' style='text-align:right;'><a href='AccountBudgetAdjustmentViewer.aspx?rccode=" + clsEmployee.GetRCCode(Request.Cookies["Speedo"]["UserName"].ToString()) + "&accnt_cat_code=" + drCategory["accnt_cat_code"].ToString() + "&accnt_items_code=" + drAccountItems["accnt_items_code"] + "'>" + Convert.ToDouble(drAccountItems["bud_value"]).ToString("###,##0.00") + "</a></td>";
// }
// if (Convert.ToDouble(drAccountItems["availed_value"]) < 0) //negative
// {
// strWrite += "<td class='GridRows' style='text-align:right;'><a href='AccountBudgetActualsViewer.aspx?rccode=" + clsEmployee.GetRCCode(Request.Cookies["Speedo"]["UserName"].ToString()) + "&accnt_cat_code=" + drCategory["accnt_cat_code"].ToString() + "&accnt_items_code=" + drAccountItems["accnt_items_code"] + "'>(" + (Convert.ToDouble(drAccountItems["availed_value"]) * -1).ToString("###,##0.00") + ")</a></td>";
// }
// else //positive
// {
// strWrite += "<td class='GridRows' style='text-align:right;'><a href='AccountBudgetActualsViewer.aspx?rccode=" + clsEmployee.GetRCCode(Request.Cookies["Speedo"]["UserName"].ToString()) + "&accnt_cat_code=" + drCategory["accnt_cat_code"].ToString() + "&accnt_items_code=" + drAccountItems["accnt_items_code"] + "'>" + Convert.ToDouble(drAccountItems["availed_value"]).ToString("###,##0.00") + "</a></td>";
// }
// if ((Convert.ToDouble(drAccountItems["bud_value"]) - Convert.ToDouble(drAccountItems["availed_value"])) < 0) //negative
// {
// strWrite += "<td class='GridRows' style='text-align:right;'>(" + ((Convert.ToDouble(drAccountItems["bud_value"]) - Convert.ToDouble(drAccountItems["availed_value"])) * -1).ToString("###,##0.00") + ")</td>";
// }
// else //positive
// {
// strWrite += "<td class='GridRows' style='text-align:right;'>" + (Convert.ToDouble(drAccountItems["bud_value"]) - Convert.ToDouble(drAccountItems["availed_value"])).ToString("###,##0.00") + "</td>";
// }
// strWrite += "</tr>";
// strWrite += "<tr>";
// dblCategoryBudget += Convert.ToDouble(drAccountItems["bud_value"]);
// dblCategoryAvailed += Convert.ToDouble(drAccountItems["availed_value"]);
// }
// strWrite += "<td class='GridRows2' colspan='2'> " + drCategory["accnt_cat_name"].ToString() + "</td>";
// if (dblCategoryBudget < 0)
// {
// strWrite += "<td class='GridRows2' style='text-align:right;'>(" + (dblCategoryBudget * -1).ToString("###,##0.00") + ")</td>";
// }
// else
// {
// strWrite += "<td class='GridRows2' style='text-align:right;'>" + dblCategoryBudget.ToString("###,##0.00") + "</td>";
// }
// if (dblCategoryAvailed < 0)
// {
// strWrite += "<td class='GridRows2' style='text-align:right;'>(" + (dblCategoryAvailed * -1).ToString("###,##0.00") + ")</td>";
// }
// else
// {
// strWrite += "<td class='GridRows2' style='text-align:right;'>" + dblCategoryAvailed.ToString("###,##0.00") + "</td>";
// }
// if ((dblCategoryBudget - dblCategoryAvailed) < 0)
// {
// strWrite += "<td class='GridRows2' style='text-align:right;'>(" + ((dblCategoryBudget - dblCategoryAvailed) * -1).ToString("###,##0.00") + ")</td>";
// }
// else
// {
// strWrite += "<td class='GridRows2' style='text-align:right;'>" + (dblCategoryBudget - dblCategoryAvailed).ToString("###,##0.00") + "</td>";
// }
// strWrite += "</tr>";
// dblCategoryTotalBudget += dblCategoryBudget;
// dblCategoryTotalAvailed += dblCategoryAvailed;
// dblCategoryBudget = 0;
// dblCategoryAvailed = 0;
// //strWrite += "<td class='GridRows2' colspan='2'>Category 1</td>";
// //strWrite += "<td class='GridRows2' style='text-align:right;'>10,000,000</td>";
// //strWrite += "<td class='GridRows2' style='text-align:right;'>5,000,000</td>";
// //strWrite += "<td class='GridRows2' style='text-align:right;'>5,000,000</td>";
// //strWrite += "</tr>";
//}
//strWrite += "<tr>";
//strWrite += "<td class='GridRows' style='text-align:right;' colspan='2'>TOTAL</td>";
//if (dblCategoryTotalBudget < 0)
//{
// strWrite += "<td class='GridRows' style='text-align:right;'>(" + (dblCategoryTotalBudget * -1).ToString("###,##0.00") + ")</td>";
//}
//else
//{
// strWrite += "<td class='GridRows' style='text-align:right;'>" + dblCategoryTotalBudget.ToString("###,##0.00") + "</td>";
//}
//if (dblCategoryTotalAvailed < 0)
//{
// strWrite += "<td class='GridRows' style='text-align:right;'>(" + (dblCategoryTotalAvailed * -1).ToString("###,##0.00") + ")</td>";
//}
//else
//{
// strWrite += "<td class='GridRows' style='text-align:right;'>" + dblCategoryTotalAvailed.ToString("###,##0.00") + "</td>";
//}
//if ((dblCategoryTotalBudget - dblCategoryTotalAvailed) < 0)
//{
// strWrite += "<td class='GridRows' style='text-align:right;'>(" + ((dblCategoryTotalBudget - dblCategoryTotalAvailed) * -1).ToString("###,##0.00") + ")</td>";
//}
//else
//{
// strWrite += "<td class='GridRows' style='text-align:right;'>" + (dblCategoryTotalBudget - dblCategoryTotalAvailed).ToString("###,##0.00") + "</td>";
//}
//strWrite += "</tr>";
//strWrite += "<tr>";
//lblItems.Text = strWrite;
string strWrite = "";
int intCounter = 0;
double dblCategoryBudget = 0;
double dblCategoryAvailed = 0;
double dblCategoryVariant = 0;
double dblCategoryTotalBudget = 0;
double dblCategoryTotalAvailed = 0;
double dblTotalIncomeBudget = 0;
double dblTotalIncomeAvailed = 0;
double dblTotalExpensesBudget = 0;
double dblTotalExpensesAvailed = 0;
foreach (DataRow drCategoryType in AccountCategoryType.GetDSG().Rows)
{
foreach (DataRow drCategory in AccountCategory.GetDSG(drCategoryType["accnt_cat_type_code"].ToString()).Rows)
{
foreach (DataRow drAccountItems in AccountBudget.GetDSGRCBudget(clsEmployee.GetRCCode(Request.Cookies["Speedo"]["UserName"].ToString()), Convert.ToInt16(ddlFiscalYear.SelectedValue), drCategory["accnt_cat_code"].ToString()).Rows)
{
intCounter += 1;
strWrite += "<tr>";
strWrite += "<td class='GridRows'>" + drAccountItems["oracle_code"] + "</td>";
strWrite += "<td class='GridRows'>" + drAccountItems["accnt_items_name"] + "</td>";
if (Convert.ToDouble(drAccountItems["bud_value"]) < 0)//negative
{
strWrite += "<td class='GridRows' style='text-align:right;'><a href='AccountBudgetAdjustmentViewer.aspx?rccode=" + clsEmployee.GetRCCode(Request.Cookies["Speedo"]["UserName"].ToString()).ToString() + "&accnt_cat_code=" + drCategory["accnt_cat_code"].ToString() + "&accnt_items_code=" + drAccountItems["accnt_items_code"] + "'>(" + (Convert.ToDouble(drAccountItems["bud_value"]) * -1).ToString("###,##0.00") + ")</a></td>";
}
else //positive
{
strWrite += "<td class='GridRows' style='text-align:right;'><a href='AccountBudgetAdjustmentViewer.aspx?rccode=" + clsEmployee.GetRCCode(Request.Cookies["Speedo"]["UserName"].ToString()).ToString() + "&accnt_cat_code=" + drCategory["accnt_cat_code"].ToString() + "&accnt_items_code=" + drAccountItems["accnt_items_code"] + "'>" + Convert.ToDouble(drAccountItems["bud_value"]).ToString("###,##0.00") + "</a></td>";
}
if (Convert.ToDouble(drAccountItems["availed_value"]) < 0) //negative
{
strWrite += "<td class='GridRows' style='text-align:right;'><a href='AccountBudgetActualsViewer.aspx?rccode=" + clsEmployee.GetRCCode(Request.Cookies["Speedo"]["UserName"].ToString()).ToString() + "&accnt_cat_code=" + drCategory["accnt_cat_code"].ToString() + "&accnt_items_code=" + drAccountItems["accnt_items_code"] + "'>(" + (Convert.ToDouble(drAccountItems["availed_value"]) * -1).ToString("###,##0.00") + ")</a></td>";
}
else //positive
{
strWrite += "<td class='GridRows' style='text-align:right;'><a href='AccountBudgetActualsViewer.aspx?rccode=" + clsEmployee.GetRCCode(Request.Cookies["Speedo"]["UserName"].ToString()).ToString() + "&accnt_cat_code=" + drCategory["accnt_cat_code"].ToString() + "&accnt_items_code=" + drAccountItems["accnt_items_code"] + "'>" + Convert.ToDouble(drAccountItems["availed_value"]).ToString("###,##0.00") + "</a></td>";
}
if ((Convert.ToDouble(drAccountItems["bud_value"]) - Convert.ToDouble(drAccountItems["availed_value"])) < 0) //negative
{
strWrite += "<td class='GridRows' style='text-align:right;'>(" + ((Convert.ToDouble(drAccountItems["bud_value"]) - Convert.ToDouble(drAccountItems["availed_value"])) * -1).ToString("###,##0.00") + ")</td>";
}
else //positive
{
strWrite += "<td class='GridRows' style='text-align:right;'>" + (Convert.ToDouble(drAccountItems["bud_value"]) - Convert.ToDouble(drAccountItems["availed_value"])).ToString("###,##0.00") + "</td>";
}
strWrite += "</tr>";
strWrite += "<tr>";
dblCategoryBudget += Convert.ToDouble(drAccountItems["bud_value"]);
dblCategoryAvailed += Convert.ToDouble(drAccountItems["availed_value"]);
}
strWrite += "<td class='GridRows2' colspan='2'> " + drCategory["accnt_cat_name"].ToString() + "</td>";
if (dblCategoryBudget < 0)
{
strWrite += "<td class='GridRows2' style='text-align:right;'>(" + (dblCategoryBudget * -1).ToString("###,##0.00") + ")</td>";
}
else
{
strWrite += "<td class='GridRows2' style='text-align:right;'>" + dblCategoryBudget.ToString("###,##0.00") + "</td>";
}
if (dblCategoryAvailed < 0)
{
strWrite += "<td class='GridRows2' style='text-align:right;'>(" + (dblCategoryAvailed * -1).ToString("###,##0.00") + ")</td>";
}
else
{
strWrite += "<td class='GridRows2' style='text-align:right;'>" + dblCategoryAvailed.ToString("###,##0.00") + "</td>";
}
if ((dblCategoryBudget - dblCategoryAvailed) < 0)
{
strWrite += "<td class='GridRows2' style='text-align:right;'>(" + ((dblCategoryBudget - dblCategoryAvailed) * -1).ToString("###,##0.00") + ")</td>";
}
else
{
strWrite += "<td class='GridRows2' style='text-align:right;'>" + (dblCategoryBudget - dblCategoryAvailed).ToString("###,##0.00") + "</td>";
}
strWrite += "</tr>";
dblCategoryTotalBudget += dblCategoryBudget;
dblCategoryTotalAvailed += dblCategoryAvailed;
dblCategoryBudget = 0;
dblCategoryAvailed = 0;
if (drCategoryType["accnt_cat_type_code"].ToString() == "01")
{
dblTotalIncomeBudget += dblCategoryBudget;
dblTotalIncomeAvailed += dblCategoryTotalAvailed;
}
if (drCategoryType["accnt_cat_type_code"].ToString() == "02")
{
dblTotalExpensesBudget += dblCategoryBudget;
dblTotalExpensesAvailed += dblCategoryAvailed;
}
}
strWrite += "<tr>";
strWrite += "<td class='GridRows' style='text-align:right;' colspan='2'>TOTAL " + drCategoryType["accnt_cat_type_name"].ToString() + "</td>";
if (dblCategoryTotalBudget < 0)
{
strWrite += "<td class='GridRows' style='text-align:right;'>(" + (dblCategoryTotalBudget * -1).ToString("###,##0.00") + ")</td>";
}
else
{
strWrite += "<td class='GridRows' style='text-align:right;'>" + dblCategoryTotalBudget.ToString("###,##0.00") + "</td>";
}
if (dblCategoryTotalAvailed < 0)
{
strWrite += "<td class='GridRows' style='text-align:right;'>(" + (dblCategoryTotalAvailed * -1).ToString("###,##0.00") + ")</td>";
}
else
{
strWrite += "<td class='GridRows' style='text-align:right;'>" + dblCategoryTotalAvailed.ToString("###,##0.00") + "</td>";
}
if ((dblCategoryTotalBudget - dblCategoryTotalAvailed) < 0)
{
strWrite += "<td class='GridRows' style='text-align:right;'>(" + ((dblCategoryTotalBudget - dblCategoryTotalAvailed) * -1).ToString("###,##0.00") + ")</td>";
}
else
{
strWrite += "<td class='GridRows' style='text-align:right;'>" + (dblCategoryTotalBudget - dblCategoryTotalAvailed).ToString("###,##0.00") + "</td>";
}
strWrite += "</tr>";
strWrite += "<tr>";
dblCategoryTotalBudget = 0;
dblCategoryTotalAvailed = 0;
}
lblItems.Text = strWrite;
}
/// <summary>
/// Update an existing entity
/// </summary>
/// <param name="cf">A company file that has been retrieved</param>
/// <param name="entity">The entity to update</param>
/// <param name="credentials">The credentials to access the company file</param>
/// <param name="errorLevel"></param>
/// <returns></returns>
public Task <string> UpdateAsync(CompanyFile cf, AccountBudget entity, ICompanyFileCredentials credentials,
ErrorLevel errorLevel = ErrorLevel.IgnoreWarnings)
{
return(this.UpdateAsync(cf, entity, credentials, CancellationToken.None, errorLevel));
}
private DbInsertStatement GetQuery_InsertQuery(AccountBudget _obj)
{
Dictionary <string, DbFieldEntry> fields = GetFields(_obj);
return(DbMgr.CreateInsertClause("AccountBudgets", fields));
}
public void LoadGrid()
{
string strWrite = "";
int intCounter = 0;
double dblCategoryBudget = 0;
double dblCategoryAvailed = 0;
double dblCategoryVariant = 0;
double dblCategoryTotalBudget = 0;
double dblCategoryTotalAvailed = 0;
double dblTotalIncomeBudget = 0;
double dblTotalIncomeAvailed = 0;
double dblTotalExpensesBudget = 0;
double dblTotalExpensesAvailed = 0;
foreach (DataRow drCategoryType in AccountCategoryType.GetDSG().Rows)
{
foreach (DataRow drCategory in AccountCategory.GetDSG(drCategoryType["accnt_cat_type_code"].ToString()).Rows)
{
foreach (DataRow drAccountItems in AccountBudget.GetDSGRCBudget(Request.QueryString["rccode"].ToString(), Convert.ToInt16(Request.QueryString["fiscal_year_code"].ToString()), drCategory["accnt_cat_code"].ToString()).Rows)
{
intCounter += 1;
strWrite += "<tr>";
strWrite += "<td class='GridRows'>" + drAccountItems["oracle_code"] + "</td>";
strWrite += "<td class='GridRows'>" + drAccountItems["accnt_items_name"] + "</td>";
if (Convert.ToDouble(drAccountItems["bud_value"]) < 0)//negative
{
strWrite += "<td class='GridRows' style='text-align:right;'><a href='AccountBudgetAdjustment.aspx?rccode=" + Request.QueryString["rccode"].ToString() + "&accnt_cat_code=" + drCategory["accnt_cat_code"].ToString() + "&accnt_items_code=" + drAccountItems["accnt_items_code"] + "'>(" + (Convert.ToDouble(drAccountItems["bud_value"]) * -1).ToString("###,##0.00") + ")</a></td>";
}
else //positive
{
strWrite += "<td class='GridRows' style='text-align:right;'><a href='AccountBudgetAdjustment.aspx?rccode=" + Request.QueryString["rccode"].ToString() + "&accnt_cat_code=" + drCategory["accnt_cat_code"].ToString() + "&accnt_items_code=" + drAccountItems["accnt_items_code"] + "'>" + Convert.ToDouble(drAccountItems["bud_value"]).ToString("###,##0.00") + "</a></td>";
}
if (Convert.ToDouble(drAccountItems["availed_value"]) < 0) //negative
{
strWrite += "<td class='GridRows' style='text-align:right;'><a href='AccountBudgetActuals.aspx?rccode=" + Request.QueryString["rccode"].ToString() + "&accnt_cat_code=" + drCategory["accnt_cat_code"].ToString() + "&accnt_items_code=" + drAccountItems["accnt_items_code"] + "'>(" + (Convert.ToDouble(drAccountItems["availed_value"]) * -1).ToString("###,##0.00") + ")</a></td>";
}
else //positive
{
strWrite += "<td class='GridRows' style='text-align:right;'><a href='AccountBudgetActuals.aspx?rccode=" + Request.QueryString["rccode"].ToString() + "&accnt_cat_code=" + drCategory["accnt_cat_code"].ToString() + "&accnt_items_code=" + drAccountItems["accnt_items_code"] + "'>" + Convert.ToDouble(drAccountItems["availed_value"]).ToString("###,##0.00") + "</a></td>";
}
if ((Convert.ToDouble(drAccountItems["bud_value"]) - Convert.ToDouble(drAccountItems["availed_value"])) < 0) //negative
{
strWrite += "<td class='GridRows' style='text-align:right;'>(" + ((Convert.ToDouble(drAccountItems["bud_value"]) - Convert.ToDouble(drAccountItems["availed_value"])) * -1).ToString("###,##0.00") + ")</td>";
}
else //positive
{
strWrite += "<td class='GridRows' style='text-align:right;'>" + (Convert.ToDouble(drAccountItems["bud_value"]) - Convert.ToDouble(drAccountItems["availed_value"])).ToString("###,##0.00") + "</td>";
}
strWrite += "</tr>";
strWrite += "<tr>";
dblCategoryBudget += Convert.ToDouble(drAccountItems["bud_value"]);
dblCategoryAvailed += Convert.ToDouble(drAccountItems["availed_value"]);
}
strWrite += "<td class='GridRows2' colspan='2'> " + drCategory["accnt_cat_name"].ToString() + "</td>";
if (dblCategoryBudget < 0)
{
strWrite += "<td class='GridRows2' style='text-align:right;'>(" + (dblCategoryBudget * -1).ToString("###,##0.00") + ")</td>";
}
else
{
strWrite += "<td class='GridRows2' style='text-align:right;'>" + dblCategoryBudget.ToString("###,##0.00") + "</td>";
}
if (dblCategoryAvailed < 0)
{
strWrite += "<td class='GridRows2' style='text-align:right;'>(" + (dblCategoryAvailed * -1).ToString("###,##0.00") + ")</td>";
}
else
{
strWrite += "<td class='GridRows2' style='text-align:right;'>" + dblCategoryAvailed.ToString("###,##0.00") + "</td>";
}
if ((dblCategoryBudget - dblCategoryAvailed) < 0)
{
strWrite += "<td class='GridRows2' style='text-align:right;'>(" + ((dblCategoryBudget - dblCategoryAvailed) * -1).ToString("###,##0.00") + ")</td>";
}
else
{
strWrite += "<td class='GridRows2' style='text-align:right;'>" + (dblCategoryBudget - dblCategoryAvailed).ToString("###,##0.00") + "</td>";
}
strWrite += "</tr>";
dblCategoryTotalBudget += dblCategoryBudget;
dblCategoryTotalAvailed += dblCategoryAvailed;
dblCategoryBudget = 0;
dblCategoryAvailed = 0;
if (drCategoryType["accnt_cat_type_code"].ToString() == "01")
{
dblTotalIncomeBudget += dblCategoryBudget;
dblTotalIncomeAvailed += dblCategoryTotalAvailed;
}
if (drCategoryType["accnt_cat_type_code"].ToString() == "02")
{
dblTotalExpensesBudget += dblCategoryBudget;
dblTotalExpensesAvailed += dblCategoryAvailed;
}
}
strWrite += "<tr>";
strWrite += "<td class='GridRows' style='text-align:right;' colspan='2'>TOTAL " + drCategoryType["accnt_cat_type_name"].ToString() + "</td>";
if (dblCategoryTotalBudget < 0)
{
strWrite += "<td class='GridRows' style='text-align:right;'>(" + (dblCategoryTotalBudget * -1).ToString("###,##0.00") + ")</td>";
}
else
{
strWrite += "<td class='GridRows' style='text-align:right;'>" + dblCategoryTotalBudget.ToString("###,##0.00") + "</td>";
}
if (dblCategoryTotalAvailed < 0)
{
strWrite += "<td class='GridRows' style='text-align:right;'>(" + (dblCategoryTotalAvailed * -1).ToString("###,##0.00") + ")</td>";
}
else
{
strWrite += "<td class='GridRows' style='text-align:right;'>" + dblCategoryTotalAvailed.ToString("###,##0.00") + "</td>";
}
if ((dblCategoryTotalBudget - dblCategoryTotalAvailed) < 0)
{
strWrite += "<td class='GridRows' style='text-align:right;'>(" + ((dblCategoryTotalBudget - dblCategoryTotalAvailed) * -1).ToString("###,##0.00") + ")</td>";
}
else
{
strWrite += "<td class='GridRows' style='text-align:right;'>" + (dblCategoryTotalBudget - dblCategoryTotalAvailed).ToString("###,##0.00") + "</td>";
}
strWrite += "</tr>";
strWrite += "<tr>";
dblCategoryTotalBudget = 0;
dblCategoryTotalAvailed = 0;
}
lblItems.Text = strWrite;
}