public async override Task TestUpdateAsync() { int provinceId = 5; Province province = await provinceDao.FindByIdAsync(provinceId); province.Name = "ProvinceUpdate"; Assert.IsTrue(await provinceDao.UpdateAsync(province)); Province test = await provinceDao.FindByIdAsync(provinceId); Assert.IsTrue(test.Equals(province)); }
public async override Task TestInsertAsync() { using (var transaction = new TransactionScope(TransactionScopeAsyncFlowOption.Enabled)) { int provinceId = 12; Province province = new Province { CountryId = 8, ProvinceId = provinceId, Name = "Province 2" }; await provinceDao.InsertAsync(province); Province test = await provinceDao.FindByIdAsync(provinceId); Assert.IsTrue(test.Equals(province)); } }
public ActionResult DistInd([Bind(Include = "Region,Province,District,Round,Measure")] requestfilter req) { Int16 Region; Int16 Province; Int16 District; Int16 Round; string Measure; Region = req.Region; Province = req.Province; District = req.District; Round = req.Round; Measure = req.Measure; var data = _context.IndDistircts.Select (x => new { Region = x.Region, Province = x.Province, District = x.District, Year = x.Year, Month = x.Month, Round = x.Round, ShorName = x.ShortName, Indicator = x.Indicator, Measure = x.Measure, Numerator = x.Numerator, Denominator = x.Denominator, RegionId = x.RegionId, ProvinceId = x.ProvinceId, DistrictId = x.DistrictId, RoundId = x.RoundId, CampaignType = x.CampaignType, Form = x.Form } ).ToList(); if (!Region.Equals(0) & !Province.Equals(0) & !District.Equals(0)) { data = data.Where(m => m.RegionId.Equals(Region) & m.ProvinceId.Equals(Province) & m.DistrictId.Equals(District)).ToList(); } else if (!Region.Equals(0) & !Province.Equals(0)) { data = data.Where(m => m.RegionId.Equals(Region) & m.ProvinceId.Equals(Province)).ToList(); } else if (!Region.Equals(0)) { data = data.Where(m => m.RegionId.Equals(Region)).ToList(); } if (!Round.Equals(0)) { data = data.Where(m => m.RoundId.Equals(Round)).ToList(); } ExcelEngine excelEngine = new ExcelEngine(); IApplication application = excelEngine.Excel; application.DefaultVersion = ExcelVersion.Excel2013; IWorkbook workbook; workbook = application.Workbooks.Create(3); IWorksheet sheet = workbook.Worksheets[0]; if (!data.Any()) { return(HttpNotFound()); } sheet.ImportData(data, 1, 1, true); sheet.Name = "Data"; IWorksheet pivotSheet = workbook.Worksheets[1]; pivotSheet.Name = "Percentage"; IPivotCache cash_data = workbook.PivotCaches.Add(sheet[sheet.Range.AddressLocal]); //Adding calculated fields to cache. PivotCacheFieldImpl Result = (cash_data as PivotCacheImpl).CacheFields.AddNewField("Result", "Numerator/Denominator"); PivotCacheFieldImpl Result2 = (cash_data as PivotCacheImpl).CacheFields.AddNewField("Result2", "Numerator*1"); //Percentage indicator - Pivot Table (Percentage) #region "Percentage Pivot Table" IPivotTable pivotTable = pivotSheet.PivotTables.Add("PivotTable1", pivotSheet["A5"], cash_data); IPivotField field = pivotTable.Fields["Result"]; pivotTable.DataFields.Add(field, "%", PivotSubtotalTypes.Sum); pivotTable.Fields["Region"].Axis = PivotAxisTypes.Page; pivotTable.Fields["Province"].Axis = PivotAxisTypes.Page; pivotTable.Fields["District"].Axis = PivotAxisTypes.Page; pivotTable.Fields["CampaignType"].Axis = PivotAxisTypes.Page; pivotTable.Fields["Round"].Axis = PivotAxisTypes.Page; pivotTable.Fields["Year"].Axis = PivotAxisTypes.Page; pivotTable.Fields["Month"].Axis = PivotAxisTypes.Page; pivotTable.Fields["Measure"].Axis = PivotAxisTypes.Page; pivotTable.Fields["Form"].Axis = PivotAxisTypes.Page; pivotTable.Fields["Indicator"].Axis = PivotAxisTypes.Row; IPivotField num = pivotTable.Fields["Numerator"]; IPivotField denom = pivotTable.Fields["Denominator"]; if (Measure.Equals("1")) { pivotTable.Fields["Region"].Axis = PivotAxisTypes.Column; pivotSheet["A2"].Text = "Indicators comparison by region"; } else if (Measure.Equals("2")) { pivotTable.Fields["Province"].Axis = PivotAxisTypes.Column; pivotSheet["A2"].Text = "Indicators comparison by province"; } else if (Measure.Equals("3")) { pivotTable.Fields["District"].Axis = PivotAxisTypes.Column; pivotSheet["A2"].Text = "Indicators comparison by district"; } else if (Measure.Equals("4")) { pivotTable.Fields["Year"].Axis = PivotAxisTypes.Column; pivotSheet["A2"].Text = "Indicators comparison by year"; } else if (Measure.Equals("5")) { pivotTable.Fields["Year"].Axis = PivotAxisTypes.Column; pivotTable.Fields["Month"].Axis = PivotAxisTypes.Column; pivotSheet["A2"].Text = "Indicators comparison by month"; IPivotField pivotField = pivotTable.Fields["Month"]; pivotField.Sort(new string[12] { "January", "February", "March", "April", "May", "June", "July", "August", "September", "October", "November", "December" }); } pivotSheet.Range["A2"].CellStyle.Font.Size = 14f; pivotSheet.Range["A2"].CellStyle.Font.Bold = true; pivotSheet.Range["A3"].Text = "Date extracted: " + DateTime.Now.ToString();; pivotSheet.Range["A3"].CellStyle.Font.Size = 10f; pivotSheet.Range["A3"].CellStyle.Font.Bold = true; pivotSheet.Range["A3"].CellStyle.Font.Italic = true; pivotTable.Fields["Measure"].Axis = PivotAxisTypes.Page; IPivotField pageField = pivotTable.Fields["Measure"]; pageField.Items[0].Visible = false; pivotTable.BuiltInStyle = PivotBuiltInStyles.PivotStyleDark7; pivotTable.ColumnGrand = false; pivotTable.RowGrand = false; PivotTableOptions pivotOption = pivotTable.Options as PivotTableOptions; pivotOption.ShowGridDropZone = true; IPivotTableOptions option = pivotTable.Options; option.ErrorString = "NA"; option.ColumnHeaderCaption = "CompareBy"; option.RowHeaderCaption = "Indicator"; #endregion //Number indicator - Pivot Table (Numeric) #region "Numeric Pivot Table" IWorksheet pivotSheet2 = workbook.Worksheets[2]; pivotSheet2.Name = "Numeric"; IPivotTable pivotTable2 = pivotSheet2.PivotTables.Add("PivotTable2", pivotSheet["A5"], cash_data); IPivotField field2 = pivotTable2.Fields["Result2"]; pivotTable2.DataFields.Add(field2, "#", PivotSubtotalTypes.Sum); pivotTable2.Fields["Region"].Axis = PivotAxisTypes.Page; pivotTable2.Fields["Province"].Axis = PivotAxisTypes.Page; pivotTable2.Fields["District"].Axis = PivotAxisTypes.Page; pivotTable2.Fields["CampaignType"].Axis = PivotAxisTypes.Page; pivotTable2.Fields["Round"].Axis = PivotAxisTypes.Page; pivotTable2.Fields["Year"].Axis = PivotAxisTypes.Page; pivotTable2.Fields["Month"].Axis = PivotAxisTypes.Page; pivotTable2.Fields["Form"].Axis = PivotAxisTypes.Page; pivotTable2.Fields["Indicator"].Axis = PivotAxisTypes.Row; IPivotField num2 = pivotTable2.Fields["Numerator"]; IPivotField denom2 = pivotTable2.Fields["Denominator"]; if (Measure.Equals("1")) { pivotTable2.Fields["Region"].Axis = PivotAxisTypes.Column; pivotSheet2["A2"].Text = "Indicators comparison by region"; } else if (Measure.Equals("2")) { pivotTable2.Fields["Province"].Axis = PivotAxisTypes.Column; pivotSheet2["A2"].Text = "Indicators comparison by province"; } else if (Measure.Equals("3")) { pivotTable2.Fields["District"].Axis = PivotAxisTypes.Column; pivotSheet2["A2"].Text = "Indicators comparison by district"; } else if (Measure.Equals("4")) { pivotTable2.Fields["Year"].Axis = PivotAxisTypes.Column; pivotSheet2["A2"].Text = "Indicators comparison by year"; } else if (Measure.Equals("5")) { pivotTable2.Fields["Year"].Axis = PivotAxisTypes.Column; pivotTable2.Fields["Month"].Axis = PivotAxisTypes.Column; pivotSheet2["A2"].Text = "Indicators comparison by month"; IPivotField pivotField = pivotTable2.Fields["Month"]; pivotField.Sort(new string[12] { "January", "February", "March", "April", "May", "June", "July", "August", "September", "October", "November", "December" }); } pivotSheet2.Range["A2"].CellStyle.Font.Size = 14f; pivotSheet2.Range["A2"].CellStyle.Font.Bold = true; pivotSheet2.Range["A3"].Text = "Date extracted: " + DateTime.Now.ToString();; pivotSheet2.Range["A3"].CellStyle.Font.Size = 10f; pivotSheet2.Range["A3"].CellStyle.Font.Bold = true; pivotSheet2.Range["A3"].CellStyle.Font.Italic = true; pivotTable2.Fields["Measure"].Axis = PivotAxisTypes.Page; IPivotField pageField2 = pivotTable2.Fields["Measure"]; pageField2.Items[1].Visible = false; pivotTable2.BuiltInStyle = PivotBuiltInStyles.PivotStyleDark7; pivotTable2.ColumnGrand = false; pivotTable2.RowGrand = false; PivotTableOptions pivotOption2 = pivotTable2.Options as PivotTableOptions; pivotOption2.ShowGridDropZone = true; IPivotTableOptions option2 = pivotTable2.Options; option2.ErrorString = "NA"; option2.ColumnHeaderCaption = "CompareBy"; option2.RowHeaderCaption = "Indicator"; pivotTable.Fields["Result"].NumberFormat = "#.0%"; pivotTable2.Fields["Result2"].NumberFormat = "#"; (pivotTable.Options as PivotTableOptions).ShowGridDropZone = true; (pivotTable2.Options as PivotTableOptions).ShowGridDropZone = true; (pivotTable as PivotTableImpl).Cache.IsRefreshOnLoad = true; (pivotTable2 as PivotTableImpl).Cache.IsRefreshOnLoad = true; pivotSheet2.Range["A5"].Activate(); pivotSheet2.Activate(); #endregion string ContentType = "Application/msexcel"; string filename = "Report_" + "donor" + "_" + DateTime.Now.Year + "_" + DateTime.Now.Month + "_" + DateTime.Now.Day + ".xlsx"; MemoryStream ms = new MemoryStream(); workbook.SaveAs(ms); ms.Position = 0; workbook.Close(); excelEngine.Dispose(); return(File(ms, ContentType, filename)); }
/// <summary> /// Returns true if Contact instances are equal /// </summary> /// <param name="other">Instance of Contact to be compared</param> /// <returns>Boolean</returns> public bool Equals(Contact other) { if (other is null) { return(false); } if (ReferenceEquals(this, other)) { return(true); } return (( Id == other.Id || Id.Equals(other.Id) ) && ( GivenName == other.GivenName || GivenName != null && GivenName.Equals(other.GivenName) ) && ( Surname == other.Surname || Surname != null && Surname.Equals(other.Surname) ) && ( OrganizationName == other.OrganizationName || OrganizationName != null && OrganizationName.Equals(other.OrganizationName) ) && ( Role == other.Role || Role != null && Role.Equals(other.Role) ) && ( Notes == other.Notes || Notes != null && Notes.Equals(other.Notes) ) && ( EmailAddress == other.EmailAddress || EmailAddress != null && EmailAddress.Equals(other.EmailAddress) ) && ( WorkPhoneNumber == other.WorkPhoneNumber || WorkPhoneNumber != null && WorkPhoneNumber.Equals(other.WorkPhoneNumber) ) && ( MobilePhoneNumber == other.MobilePhoneNumber || MobilePhoneNumber != null && MobilePhoneNumber.Equals(other.MobilePhoneNumber) ) && ( FaxPhoneNumber == other.FaxPhoneNumber || FaxPhoneNumber != null && FaxPhoneNumber.Equals(other.FaxPhoneNumber) ) && ( Address1 == other.Address1 || Address1 != null && Address1.Equals(other.Address1) ) && ( Address2 == other.Address2 || Address2 != null && Address2.Equals(other.Address2) ) && ( City == other.City || City != null && City.Equals(other.City) ) && ( Province == other.Province || Province != null && Province.Equals(other.Province) ) && ( PostalCode == other.PostalCode || PostalCode != null && PostalCode.Equals(other.PostalCode) )); }
/// <summary> /// Returns true if Owner instances are equal /// </summary> /// <param name="other">Instance of Owner to be compared</param> /// <returns>Boolean</returns> public bool Equals(Owner other) { if (other is null) { return(false); } if (ReferenceEquals(this, other)) { return(true); } return (( Id == other.Id || Id.Equals(other.Id) ) && ( OwnerCode == other.OwnerCode || OwnerCode != null && OwnerCode.Equals(other.OwnerCode) ) && ( OrganizationName == other.OrganizationName || OrganizationName != null && OrganizationName.Equals(other.OrganizationName) ) && ( MeetsResidency == other.MeetsResidency || MeetsResidency.Equals(other.MeetsResidency) ) && ( LocalArea == other.LocalArea || LocalArea != null && LocalArea.Equals(other.LocalArea) ) && ( Status == other.Status || Status != null && Status.Equals(other.Status) ) && ( StatusComment == other.StatusComment || StatusComment != null && StatusComment.Equals(other.StatusComment) ) && ( DoingBusinessAs == other.DoingBusinessAs || DoingBusinessAs != null && DoingBusinessAs.Equals(other.DoingBusinessAs) ) && ( RegisteredCompanyNumber == other.RegisteredCompanyNumber || RegisteredCompanyNumber != null && RegisteredCompanyNumber.Equals(other.RegisteredCompanyNumber) ) && ( PrimaryContact == other.PrimaryContact || PrimaryContact != null && PrimaryContact.Equals(other.PrimaryContact) ) && ( IsMaintenanceContractor == other.IsMaintenanceContractor || IsMaintenanceContractor != null && IsMaintenanceContractor.Equals(other.IsMaintenanceContractor) ) && ( WorkSafeBCPolicyNumber == other.WorkSafeBCPolicyNumber || WorkSafeBCPolicyNumber != null && WorkSafeBCPolicyNumber.Equals(other.WorkSafeBCPolicyNumber) ) && ( WorkSafeBCExpiryDate == other.WorkSafeBCExpiryDate || WorkSafeBCExpiryDate != null && WorkSafeBCExpiryDate.Equals(other.WorkSafeBCExpiryDate) ) && ( GivenName == other.GivenName || GivenName != null && GivenName.Equals(other.GivenName) ) && ( Surname == other.Surname || Surname != null && Surname.Equals(other.Surname) ) && ( Address1 == other.Address1 || Address1 != null && Address1.Equals(other.Address1) ) && ( Address2 == other.Address2 || Address2 != null && Address2.Equals(other.Address2) ) && ( City == other.City || City != null && City.Equals(other.City) ) && ( Province == other.Province || Province != null && Province.Equals(other.Province) ) && ( PostalCode == other.PostalCode || PostalCode != null && PostalCode.Equals(other.PostalCode) ) && ( CGLEndDate == other.CGLEndDate || CGLEndDate != null && CGLEndDate.Equals(other.CGLEndDate) ) && ( CglPolicyNumber == other.CglPolicyNumber || CglPolicyNumber != null && CglPolicyNumber.Equals(other.CglPolicyNumber) ) && ( ArchiveCode == other.ArchiveCode || ArchiveCode != null && ArchiveCode.Equals(other.ArchiveCode) ) && ( ArchiveReason == other.ArchiveReason || ArchiveReason != null && ArchiveReason.Equals(other.ArchiveReason) ) && ( ArchiveDate == other.ArchiveDate || ArchiveDate != null && ArchiveDate.Equals(other.ArchiveDate) ) && ( Contacts == other.Contacts || Contacts != null && Contacts.SequenceEqual(other.Contacts) ) && ( Notes == other.Notes || Notes != null && Notes.SequenceEqual(other.Notes) ) && ( Attachments == other.Attachments || Attachments != null && Attachments.SequenceEqual(other.Attachments) ) && ( History == other.History || History != null && History.SequenceEqual(other.History) ) && ( EquipmentList == other.EquipmentList || EquipmentList != null && EquipmentList.SequenceEqual(other.EquipmentList) )); }
public ActionResult DistInd([Bind(Include = "Region,Province,District,Round,Measure,Filter")] requestfilter req) { Int16 Region; Int16 Province; Int16 District; Int16 Round; string Measure; string Filter; Region = req.Region; Province = req.Province; District = req.District; Round = req.Round; Measure = req.Measure; Filter = req.Filter; var data = _context.IndDistircts.Select (x => new { Region = x.Region, Province = x.Province, District = x.District, Year = x.Year, Month = x.Month, Round = x.Round, ShorName = x.ShortName, Indicator = x.Indicator, Measure = x.Measure, Numerator = x.Numerator, Denominator = x.Denominator, RegionId = x.RegionId, ProvinceId = x.ProvinceId, DistrictId = x.DistrictId, RoundId = x.RoundId, CampaignType = x.CampaignType, Form = x.Form } ).ToList() /*.Where(m=>m.Measure.Equals(Measure) & m.Denominator>0)*/; if (!Region.Equals(0) & !Province.Equals(0) & !District.Equals(0)) { data = data.Where(m => m.RegionId.Equals(Region) & m.ProvinceId.Equals(Province) & m.DistrictId.Equals(District)).ToList(); } else if (!Region.Equals(0) & !Province.Equals(0)) { data = data.Where(m => m.RegionId.Equals(Region) & m.ProvinceId.Equals(Province)).ToList(); } else if (!Region.Equals(0)) { data = data.Where(m => m.RegionId.Equals(Region)).ToList(); } if (!Round.Equals(0)) { data = data.Where(m => m.RoundId.Equals(Round)).ToList(); } ExcelEngine excelEngine = new ExcelEngine(); IApplication application = excelEngine.Excel; application.DefaultVersion = ExcelVersion.Excel2013; IWorkbook workbook; workbook = application.Workbooks.Create(2); IWorksheet sheet = workbook.Worksheets[0]; if (!data.Any()) { return(HttpNotFound()); } sheet.ImportData(data, 1, 1, true); sheet.Name = "Data"; IWorksheet pivotSheet = workbook.Worksheets[1]; pivotSheet.Name = "Result"; IPivotCache cash_data = workbook.PivotCaches.Add(sheet[sheet.Range.AddressLocal]); //Percentage indicator IPivotTable pivotTable = pivotSheet.PivotTables.Add("PivotTable1", pivotSheet["A5"], cash_data); //IPivotTableOptions options = pivotTable.Options; pivotTable.Fields["Region"].Axis = PivotAxisTypes.Page; pivotTable.Fields["Province"].Axis = PivotAxisTypes.Page; pivotTable.Fields["District"].Axis = PivotAxisTypes.Page; pivotTable.Fields["CampaignType"].Axis = PivotAxisTypes.Page; pivotTable.Fields["Round"].Axis = PivotAxisTypes.Page; pivotTable.Fields["Year"].Axis = PivotAxisTypes.Page; pivotTable.Fields["Month"].Axis = PivotAxisTypes.Page; pivotTable.Fields["Form"].Axis = PivotAxisTypes.Page; pivotTable.Fields["Indicator"].Axis = PivotAxisTypes.Row; IPivotField num = pivotTable.Fields["Numerator"]; IPivotField denom = pivotTable.Fields["Denominator"]; if (Measure.Equals("1")) { pivotTable.Fields["Region"].Axis = PivotAxisTypes.Column; pivotSheet["A2"].Text = "Indicators comparison by region"; } else if (Measure.Equals("2")) { pivotTable.Fields["Province"].Axis = PivotAxisTypes.Column; pivotSheet["A2"].Text = "Indicators comparison by province"; } else if (Measure.Equals("3")) { pivotTable.Fields["District"].Axis = PivotAxisTypes.Column; pivotSheet["A2"].Text = "Indicators comparison by district"; } else if (Measure.Equals("4")) { pivotTable.Fields["Year"].Axis = PivotAxisTypes.Column; pivotSheet["A2"].Text = "Indicators comparison by year"; } else if (Measure.Equals("5")) { pivotTable.Fields["Year"].Axis = PivotAxisTypes.Column; pivotTable.Fields["Month"].Axis = PivotAxisTypes.Column; pivotSheet["A2"].Text = "Indicators comparison by month"; IPivotField pivotField = pivotTable.Fields["Month"]; pivotField.Sort(new string[1] { pivotField.Items[1].Text }); } pivotSheet.Range["A2"].CellStyle.Font.Size = 14f; pivotSheet.Range["A2"].CellStyle.Font.Bold = true; pivotSheet.Range["A3"].Text = "Date extracted: " + DateTime.Now.ToString();; pivotSheet.Range["A3"].CellStyle.Font.Size = 10f; pivotSheet.Range["A3"].CellStyle.Font.Bold = true; pivotSheet.Range["A3"].CellStyle.Font.Italic = true; pivotTable.Fields["Measure"].Axis = PivotAxisTypes.Page; IPivotField pageField = pivotTable.Fields["Measure"]; pageField.Items[0].Visible = false; if (Filter == "%") { IPivotField Result = pivotTable.CalculatedFields.Add("Result", "Numerator/Denominator"); Result.Name = " Result"; Result.NumberFormat = "#.0%"; } else if (Filter == "#") { IPivotField Result = pivotTable.CalculatedFields.Add("Result", "Numerator*1"); Result.Name = " Result"; Result.NumberFormat = "#"; } //IPivotField pivotField = pivotTable.Fields[0]; //pivotField.Sort(new string[1] { pivotField.Items[4].Text }); pivotTable.BuiltInStyle = PivotBuiltInStyles.PivotStyleDark7; pivotTable.ColumnGrand = false; pivotTable.RowGrand = false; PivotTableOptions pivotOption = pivotTable.Options as PivotTableOptions; pivotOption.ShowGridDropZone = true; IPivotTableOptions option = pivotTable.Options; option.ErrorString = "NA"; option.ColumnHeaderCaption = "CompareBy"; option.RowHeaderCaption = "Indicator"; pivotSheet.Activate(); //else if (Filter == "#") //{ // //Number indicator // IWorksheet pivotSheet2 = workbook.Worksheets[1]; // pivotSheet2.Name = "Numeric"; // IPivotTable pivotTable2 = pivotSheet2.PivotTables.Add("PivotTable2", pivotSheet["A5"], cash_data); // //IPivotTableOptions options2 = pivotTable2.Options; // //options2.ShowFieldList = true; // pivotTable2.Fields["Region"].Axis = PivotAxisTypes.Page; // pivotTable2.Fields["Province"].Axis = PivotAxisTypes.Page; // pivotTable2.Fields["District"].Axis = PivotAxisTypes.Page; // pivotTable2.Fields["CampaignType"].Axis = PivotAxisTypes.Page; // pivotTable2.Fields["Round"].Axis = PivotAxisTypes.Page; // pivotTable2.Fields["Year"].Axis = PivotAxisTypes.Page; // pivotTable2.Fields["Month"].Axis = PivotAxisTypes.Page; // pivotTable2.Fields["Form"].Axis = PivotAxisTypes.Page; // pivotTable2.Fields["Indicator"].Axis = PivotAxisTypes.Row; // IPivotField num2 = pivotTable2.Fields["Numerator"]; // IPivotField denom2 = pivotTable2.Fields["Denominator"]; // if (Measure.Equals("1")) // { // pivotTable2.Fields["Region"].Axis = PivotAxisTypes.Column; // pivotSheet2["A2"].Text = "Indicators comparison by region"; // } // else if (Measure.Equals("2")) // { // pivotTable2.Fields["Province"].Axis = PivotAxisTypes.Page; // pivotSheet2["A2"].Text = "Indicators comparison by province"; // } // else if (Measure.Equals("3")) // { // pivotTable2.Fields["District"].Axis = PivotAxisTypes.Page; // pivotSheet2["A2"].Text = "Indicators comparison by district"; // } // else if (Measure.Equals("4")) // { // pivotTable2.Fields["Year"].Axis = PivotAxisTypes.Page; // pivotSheet2["A2"].Text = "Indicators comparison by year"; // } // else if (Measure.Equals("5")) // { // pivotTable2.Fields["Month"].Axis = PivotAxisTypes.Page; // pivotSheet2["A2"].Text = "Indicators comparison by month"; // } // pivotSheet2.Range["A2"].CellStyle.Font.Size = 14f; // pivotSheet2.Range["A2"].CellStyle.Font.Bold = true; // pivotSheet2.Range["A3"].Text = "Date extracted: " + DateTime.Now.ToString(); ; // pivotSheet2.Range["A3"].CellStyle.Font.Size = 10f; // pivotSheet2.Range["A3"].CellStyle.Font.Bold = true; // pivotSheet2.Range["A3"].CellStyle.Font.Italic = true; // IPivotField result2 = pivotTable2.CalculatedFields.Add("Result2", "Numerator*1"); // result2.Name = " #"; // result2.NumberFormat = "#"; // pivotTable2.Fields["Measure"].Axis = PivotAxisTypes.Page; // IPivotField pageField2 = pivotTable2.Fields["Measure"]; // pageField2.Items[1].Visible = false; // pivotTable2.BuiltInStyle = PivotBuiltInStyles.PivotStyleDark7; // pivotTable2.ColumnGrand = false; // pivotTable2.RowGrand = false; // PivotTableOptions pivotOption2 = pivotTable2.Options as PivotTableOptions; // pivotOption2.ShowGridDropZone = true; // IPivotTableOptions option2 = pivotTable2.Options; // option2.ErrorString = "NA"; // option2.ColumnHeaderCaption = "CompareBy"; // option2.RowHeaderCaption = "Indicator"; // pivotSheet2.Range["A5"].Activate(); // pivotSheet2.Activate(); //} string ContentType = "Application/msexcel"; string filename = "NEOC_" + "Indicators" + "_" + DateTime.Now.Year + "_" + DateTime.Now.Month + "_" + DateTime.Now.Day + ".xlsx"; MemoryStream ms = new MemoryStream(); workbook.SaveAs(ms); ms.Position = 0; workbook.Close(); excelEngine.Dispose(); return(File(ms, ContentType, filename)); }