public override void OnControlLoad(object sender, EventArgs e) { string accountNumber = this.Page.Request["AccountNumber"]; DateTime from = Conversion.TryCastDate(this.Page.Request["From"]); DateTime to = Conversion.TryCastDate(this.Page.Request["To"]); int userId = AppUsers.GetCurrent().View.UserId.ToInt(); int officeId = AppUsers.GetCurrent().View.OfficeId.ToInt(); Collection <KeyValuePair <string, object> > parameter1 = new Collection <KeyValuePair <string, object> >(); parameter1.Add(new KeyValuePair <string, object>("@OfficeId", officeId.ToString(CultureInfo.InvariantCulture))); parameter1.Add(new KeyValuePair <string, object>("@AccountNumber", accountNumber)); Collection <KeyValuePair <string, object> > parameter2 = new Collection <KeyValuePair <string, object> >(); parameter2.Add(new KeyValuePair <string, object>("@From", from)); parameter2.Add(new KeyValuePair <string, object>("@To", to)); parameter2.Add(new KeyValuePair <string, object>("@UserId", userId.ToString(CultureInfo.InvariantCulture))); parameter2.Add(new KeyValuePair <string, object>("@AccountNumber", accountNumber)); parameter2.Add(new KeyValuePair <string, object>("@OfficeId", officeId.ToString(CultureInfo.InvariantCulture))); using (WebReport report = new WebReport()) { report.AddParameterToCollection(parameter1); report.AddParameterToCollection(parameter2); report.RunningTotalText = Titles.RunningTotal; report.Path = "~/Modules/Finance/Reports/Source/Transactions.AccountStatement.xml"; report.AutoInitialize = true; this.Placeholder1.Controls.Add(report); } }
public override void OnControlLoad(object sender, EventArgs e) { string tranId = this.Page.Request["TranId"]; string tranCode = this.Page.Request["TranCode"]; if (Conversion.TryCastLong(tranId).Equals(0)) { if (!string.IsNullOrWhiteSpace(tranCode)) { tranId = Transaction.GetTranIdByTranCode(AppUsers.GetCurrentUserDB(), tranCode) .ToString(CultureInfo.InvariantCulture); } } Collection <KeyValuePair <string, object> > list = new Collection <KeyValuePair <string, object> >(); list.Add(new KeyValuePair <string, object>("@transaction_master_id", tranId)); using (WebReport report = new WebReport()) { report.AddParameterToCollection(list); report.AddParameterToCollection(list); report.RunningTotalText = Titles.RunningTotal; report.Path = "~/Modules/Finance/Reports/Source/Transactions.GLEntry.xml"; report.AutoInitialize = true; this.Placeholder1.Controls.Add(report); } }
public override void OnControlLoad(object sender, EventArgs e) { string itemCode = this.Page.Request["ItemCode"]; DateTime from = Conversion.TryCastDate(this.Page.Request["From"]); DateTime to = Conversion.TryCastDate(this.Page.Request["To"]); int storeId = Conversion.TryCastInteger(this.Page.Request["StoreId"]); int userId = AppUsers.GetCurrent().View.UserId.ToInt(); Collection <KeyValuePair <string, object> > parameter1 = new Collection <KeyValuePair <string, object> >(); parameter1.Add(new KeyValuePair <string, object>("@ItemCode", itemCode)); Collection <KeyValuePair <string, object> > parameter2 = new Collection <KeyValuePair <string, object> >(); parameter2.Add(new KeyValuePair <string, object>("@From", from)); parameter2.Add(new KeyValuePair <string, object>("@To", to)); parameter2.Add(new KeyValuePair <string, object>("@UserId", userId.ToString(CultureInfo.InvariantCulture))); parameter2.Add(new KeyValuePair <string, object>("@ItemCode", itemCode)); parameter2.Add(new KeyValuePair <string, object>("@StoreId", storeId.ToString(CultureInfo.InvariantCulture))); using (WebReport report = new WebReport()) { report.AddParameterToCollection(parameter1); report.AddParameterToCollection(parameter2); report.RunningTotalText = Titles.RunningTotal; report.Path = "~/Modules/Inventory/Reports/Source/Inventory.AccountStatement.xml"; report.AutoInitialize = true; this.Controls.Add(report); } }
public override void OnControlLoad(object sender, EventArgs e) { Collection <KeyValuePair <string, object> > list = new Collection <KeyValuePair <string, object> >(); list.Add(new KeyValuePair <string, object>("@transaction_master_id", this.Page.Request["TranId"])); using (WebReport report = new WebReport()) { report.AddParameterToCollection(list); report.AddParameterToCollection(list); report.AutoInitialize = true; report.Path = "~/Modules/Sales/Reports/Source/Sales.CustomerDeliveryNote.xml"; this.Controls.Add(report); } }
public override void OnControlLoad(object sender, EventArgs e) { DateTime fromDate = Conversion.TryCastDate(this.Page.Request["FromDate"]); DateTime toDate = Conversion.TryCastDate(this.Page.Request["ToDate"]); decimal factor = Conversion.TryCastDecimal(this.Page.Request["Factor"]); bool compact = Conversion.TryCastBoolean(this.Page.Request["Compact"]); bool changeSide = Conversion.TryCastBoolean(this.Page.Request["ChangeSide"]); bool includeZeroBalanceAccounts = Conversion.TryCastBoolean(this.Page.Request["IncludeZeroBalanceAccounts"]); int userId = AppUsers.GetCurrent().View.UserId.ToInt(); int officeId = AppUsers.GetCurrent().View.OfficeId.ToInt(); Collection <KeyValuePair <string, object> > parameter1 = new Collection <KeyValuePair <string, object> >(); parameter1.Add(new KeyValuePair <string, object>("@From", fromDate)); parameter1.Add(new KeyValuePair <string, object>("@To", toDate)); parameter1.Add(new KeyValuePair <string, object>("@OfficeId", officeId.ToString(CultureInfo.InvariantCulture))); parameter1.Add(new KeyValuePair <string, object>("@Compact", compact.ToString(CultureInfo.InvariantCulture))); parameter1.Add(new KeyValuePair <string, object>("@Factor", factor.ToString(CultureInfo.InvariantCulture))); parameter1.Add(new KeyValuePair <string, object>("@UserId", userId.ToString(CultureInfo.InvariantCulture))); parameter1.Add(new KeyValuePair <string, object>("@ChangeSideWhenNegative", changeSide.ToString(CultureInfo.InvariantCulture))); parameter1.Add(new KeyValuePair <string, object>("@IncludeZeroBalanceAccounts", includeZeroBalanceAccounts.ToString(CultureInfo.InvariantCulture))); using (WebReport report = new WebReport()) { report.AddParameterToCollection(parameter1); report.RunningTotalText = Titles.RunningTotal; report.Path = "~/Modules/Finance/Reports/Source/Transactions.TrialBalance.xml"; report.AutoInitialize = true; this.Placeholder1.Controls.Add(report); } }
public override void OnControlLoad(object sender, EventArgs e) { Collection <KeyValuePair <string, object> > list = new Collection <KeyValuePair <string, object> >(); list.Add(new KeyValuePair <string, object>("@TranCode", this.Page.Request["TranCode"])); using (WebReport report = new WebReport()) { report.AddParameterToCollection(list); report.AddParameterToCollection(list); report.AutoInitialize = true; report.Path = "~/Modules/Inventory/Reports/Source/Inventory.Advice.xml"; this.Controls.Add(report); } }
public override void OnControlLoad(object sender, EventArgs e) { DateTime previousPeriod = Conversion.TryCastDate(this.Page.Request["PreviousPeriod"]); DateTime currentPeriod = Conversion.TryCastDate(this.Page.Request["CurrentPeriod"]); decimal factor = Conversion.TryCastDecimal(this.Page.Request["Factor"]); int userId = AppUsers.GetCurrent().View.UserId.ToInt(); int officeId = AppUsers.GetCurrent().View.OfficeId.ToInt(); Collection <KeyValuePair <string, object> > parameter2 = new Collection <KeyValuePair <string, object> >(); parameter2.Add(new KeyValuePair <string, object>("@PreviousPeriod", previousPeriod)); parameter2.Add(new KeyValuePair <string, object>("@CurrentPeriod", currentPeriod)); parameter2.Add(new KeyValuePair <string, object>("@UserId", userId.ToString(CultureInfo.InvariantCulture))); parameter2.Add(new KeyValuePair <string, object>("@Factor", factor.ToString(CultureInfo.InvariantCulture))); parameter2.Add(new KeyValuePair <string, object>("@OfficeId", officeId.ToString(CultureInfo.InvariantCulture))); using (WebReport report = new WebReport()) { report.AddParameterToCollection(parameter2); report.Path = "~/Modules/Finance/Reports/Source/Transactions.BalanceSheet.xml"; report.AutoInitialize = true; this.Placeholder1.Controls.Add(report); } }
protected void Page_Init(object sender, EventArgs e) { string validationId = this.Page.Request.QueryString["ValidationId"]; if (string.IsNullOrWhiteSpace(validationId)) { this.DisplayError(Warnings.AccessIsDenied); return; } this.quotation = Data.Public.ApproveQuotation.GetQuotation(validationId); if (this.quotation == null || this.quotation.TranId <= 0) { this.DisplayError(Warnings.AccessIsDenied); return; } if (this.quotation.Accepted) { this.DisplayError(string.Format(Labels.SalesQuotationAlreadyAccepted, this.quotation.AcceptedOn)); return; } string catalog = this.quotation.Catalog; Collection <KeyValuePair <string, object> > list = new Collection <KeyValuePair <string, object> >(); list.Add(new KeyValuePair <string, object>("@non_gl_stock_master_id", this.quotation.TranId)); using (WebReport report = new WebReport()) { report.Catalog = catalog; report.NoHeader = true; report.AddParameterToCollection(list); report.AddParameterToCollection(list); report.AutoInitialize = true; report.Path = "~/Modules/Sales/Reports/Source/Sales.Quotation.xml"; this.Placeholder1.Controls.Add(report); } this.AcceptButton.Text = Titles.Accept; this.AcceptButton.Visible = true; this.AcceptButton.Enabled = this.IsValid(); }
public override void OnControlLoad(object sender, EventArgs e) { Collection <KeyValuePair <string, object> > list = new Collection <KeyValuePair <string, object> >(); list.Add(new KeyValuePair <string, object>("@transaction_master_id", this.Page.Request["TranId"])); using (WebReport report = new WebReport()) { report.AddParameterToCollection(list); report.AddParameterToCollection(list); report.RunningTotalText = Titles.RunningTotal; report.Path = "~/Modules/Finance/Reports/Source/Transactions.StockTransaction.xml"; report.AutoInitialize = true; this.Controls.Add(report); } }
public override void OnControlLoad(object sender, EventArgs e) { int officeId = AppUsers.GetCurrent().View.OfficeId.ToInt(); Collection <KeyValuePair <string, object> > parameter1 = new Collection <KeyValuePair <string, object> >(); parameter1.Add(new KeyValuePair <string, object>("@OfficeId", officeId.ToString(CultureInfo.InvariantCulture))); Collection <KeyValuePair <string, object> > parameter2 = new Collection <KeyValuePair <string, object> >(); parameter2.Add(new KeyValuePair <string, object>("@OfficeId", officeId.ToString(CultureInfo.InvariantCulture))); using (WebReport report = new WebReport()) { report.AddParameterToCollection(parameter1); report.AddParameterToCollection(parameter2); report.Path = "~/Modules/Finance/Reports/Source/Exchange.Rates.xml"; report.AutoInitialize = true; this.Placeholder1.Controls.Add(report); } }
public override void OnControlLoad(object sender, EventArgs e) { Collection <KeyValuePair <string, object> > list = new Collection <KeyValuePair <string, object> >(); list.Add(new KeyValuePair <string, object>("@office_id", AppUsers.GetCurrent().View.OfficeId.ToInt())); using (WebReport report = new WebReport()) { report.AutoInitialize = true; report.NoHeader = true; report.AddParameterToCollection(list); report.Path = "~/Modules/Sales/Reports/Source/SalesByOffice.xml"; this.Controls.Add(report); } }
public override void OnControlLoad(object sender, EventArgs e) { DateTime date = Conversion.TryCastDate(this.Page.Request["Date"]); decimal factor = Conversion.TryCastDecimal(this.Page.Request["Factor"]); int officeId = AppUsers.GetCurrentLogin().View.OfficeId.ToInt(); Collection <KeyValuePair <string, object> > parameter1 = new Collection <KeyValuePair <string, object> >(); parameter1.Add(new KeyValuePair <string, object>("@Date", date)); parameter1.Add(new KeyValuePair <string, object>("@Factor", factor.ToString(CultureInfo.InvariantCulture))); parameter1.Add(new KeyValuePair <string, object>("@OfficeId", officeId.ToString(CultureInfo.InvariantCulture))); using (WebReport report = new WebReport()) { report.AddParameterToCollection(parameter1); report.RunningTotalText = Titles.RunningTotal; report.Path = "~/Modules/Finance/Reports/Source/Transactions.RetainedEarnings.xml"; report.AutoInitialize = true; this.Placeholder1.Controls.Add(report); } }