public void ApproveCBCReport(string taxRefNo, int year, int approved, string userId) { var result = DatabaseWriter.UpdateCBCStatus(approved, taxRefNo, year, userId); if (approved == 1) { string Subject = ""; var email = string.IsNullOrEmpty(ADUser.CurrentUser.Mail) ? "*****@*****.**" : ADUser.CurrentUser.Mail; string[] senderEmail = { email }; if (result.HasRows) { DateTime repperiod = Convert.ToDateTime(result.Tables[0].Rows[0]["ReportingPeriod"].ToString()); var reportingPeriod = repperiod.ToString("yyyy-MM-dd"); Subject = string.Format("New data came in for the reporting period {0} ", reportingPeriod); Common.SendEmailToUsers(result, reportingPeriod, Subject, FDRPage.Statuses.DeletePackage, senderEmail); Common.SendEmailToRole("Approver", reportingPeriod, Subject, FDRPage.Statuses.DeletePackage, senderEmail); } else { // DatabaseWriter.ApproveOutgoingCBC(outCBC.Id, countryCode, year, statusId, ADUser.CurrentSID); Subject = string.Format("CBC for Tax No: {0} has been Accepted ", taxRefNo); Common.SendEmailToRole("Reviewer", taxRefNo, Subject, FDRPage.Statuses.Accepted, senderEmail); } } }