public static OutGoingCBCDeclarations OutGoingCBCDeclarationsDetails(string countryCode, string reportingPeriod) { var result = new OutGoingCBCDeclarations("[dbo].[uspREAD_OutGoingCBCDeclarationsDetails]", new Dictionary <string, object> { { "@CountryCode", countryCode }, { "@ReportingPeriod", reportingPeriod } }); return(result.GetRecord <OutGoingCBCDeclarations>()); }
protected void btnGenerate_Click(object sender, EventArgs e) { Button btnGenerate = (Button)sender; GridViewRow gvRow = (GridViewRow)btnGenerate.Parent.Parent; Guid newUID = new Guid(); var xmldoc = new XmlDocument(); XmlNode messageSpec = xmldoc.CreateNode(XmlNodeType.Element, "MessageSpec", null); var countryCode = gvRow.Cells[0].Text.Split('-')[1].Trim(); var country = gvRow.Cells[0].Text.Split('-')[0].Trim(); var year = int.Parse(gvRow.Cells[1].Text); if (ValidateRequiredFields(year)) { decimal id = 0; var package = Common.GenerateNewPackage(countryCode, dpReportingPeriod.Text, ref messageSpec, id); if (!string.IsNullOrEmpty(package.ToString())) { var outgoingCBC = new OutGoingCBCDeclarations() { Id = id, Country = countryCode, CBCData = package.ToString(), NSCBCData = null, StatusId = 2, Year = year, ReportingPeriod = DateTime.Parse(dpReportingPeriod.Text), CreatedBy = Sars.Systems.Security.ADUser.CurrentSID }; id = DatabaseWriter.SaveOutgoingCBC(outgoingCBC, ref newUID); if (id > 0) { var newPackage = Common.GenerateNewPackage(countryCode, dpReportingPeriod.Text, ref messageSpec, id); var newMessageSpec = messageSpec; var nmPackage = Common.GenerateNMPackage(countryCode, dpReportingPeriod.Text, newMessageSpec); var newPackagedCBC = new OutGoingCBCDeclarations() { Id = id, Country = countryCode, CBCData = newPackage.ToString(), NSCBCData = nmPackage, StatusId = 2, Year = year, CreatedBy = Sars.Systems.Security.ADUser.CurrentSID }; var saved = DatabaseWriter.SaveOutgoingCBC(newPackagedCBC, ref newUID); } DBWriteManager.Insert_OutgoingPackageAuditTrail(newUID, Sars.Systems.Security.ADUser.CurrentSID, string.Format("Package for {0} generated", country)); LoadCBC(); MessageBox.Show(string.Format("Package for {0} was successfully generated", country)); } } }
public static OutGoingCBCDeclarations IncomingCBCDeclaration(int statusId, string countryCode, string ReportingPeriod) { var oParams = new Dictionary <string, object> { { "@CountryCode", countryCode }, { "@ReportingPeriod", ReportingPeriod }, { "@StatusId", statusId } }; var result = new OutGoingCBCDeclarations("[dbo].[uspREAD_IncomingForeignDeclaration]", oParams); return(result.GetRecord <OutGoingCBCDeclarations>()); }
private bool SameApprover(OutGoingCBCDeclarations outCBC) { if (fp.IsUserInRole("Approver")) { if (outCBC.UpdatedBy == ADUser.CurrentSID) { return(true); } return(false); } return(false); }
public static OutGoingCBCDeclarations OutGoingCBCDeclarationsDetails(string countryCode, int year) { var oParams = new DBParamCollection { { "@CountryCode", countryCode }, { "@Year", year } }; var result = new OutGoingCBCDeclarations("[dbo].[uspREAD_OutGoingCBCDeclarationsDetails]", new Dictionary <string, object> { { "@CountryCode", countryCode }, { "@Year", year } }); return(result.GetRecord <OutGoingCBCDeclarations>()); }
private void SavePackage(StringBuilder package, decimal id, string countryCode, int year) { Guid newUid = new Guid(); var outgoingCBC = new OutGoingCBCDeclarations() { Id = id, Country = countryCode, NSCBCData = package.ToString(), StatusId = 3, Year = year, CreatedBy = Sars.Systems.Security.ADUser.CurrentSID }; decimal saved = DatabaseWriter.SaveOutgoingCBC(outgoingCBC, ref newUid); }
public static OutGoingCBCDeclarations GetOutgoingCBCR(string newPackage, string countryCode, int year, DateTime reportingPeriod, string userId, string nmPackage = null, decimal id = 0) { var newPackagedCBC = new OutGoingCBCDeclarations() { Id = id, Country = countryCode, CBCData = newPackage.ToString(), NSCBCData = nmPackage, StatusId = 2, Year = year, ActionId = 1, ReportingPeriod = reportingPeriod, CreatedBy = Sars.Systems.Security.ADUser.CurrentSID }; return(newPackagedCBC); }
public static OutGoingCBCDeclarations OutGoingCBCDeclarationsDetails(string countryCode, string reportingPeriod) { var oParams = new DBParamCollection { { "@CountryCode", countryCode }, { "@ReportingPeriod", reportingPeriod } }; var result = new OutGoingCBCDeclarations("[dbo].[uspREAD_OutGoingCBCDeclarationsDetails]", new Dictionary <string, object> { { "@CountryCode", countryCode }, { "@ReportingPeriod", reportingPeriod } }); if (result.Id > 0) { return(result.GetRecord <OutGoingCBCDeclarations>()); } else { return(null); } }
protected void btnVoid_Click(object sender, EventArgs e) { Guid newUid = new Guid(); Button btnVoid = (Button)sender; GridViewRow gvRow = (GridViewRow)btnVoid.Parent.Parent; var email = ADUser.CurrentUser.Mail; string[] senderEmail = { email }; var countryCode = gvRow.Cells[0].Text.Split('-')[1].Trim(); var reportingPeriod = gvRow.Cells[1].Text; var outCBC = DBReadManager.OutGoingCBCDeclarationsDetails(countryCode, reportingPeriod); var id = string.IsNullOrEmpty(outCBC.Id.ToString()) ? 0 : outCBC.Id; var reportP = DateTime.Parse(reportingPeriod).ToString("yyyy-MM-ddTHH:mm:ss"); Guid uid = new Guid(); if (outCBC != null) { var prepareVoidPackage = PrepareNMVoidPackage(id, countryCode, outCBC.NMCBC, reportingPeriod); var nmPackage = prepareVoidPackage; uid = outCBC.UID; var voidedCBC = new OutGoingCBCDeclarations() { Id = id, Country = countryCode, CBCData = prepareVoidPackage, StatusId = 8, Year = int.Parse(reportingPeriod.Substring(0, 4)), UID = uid, ActionId = 3, NSCBCData = nmPackage, ReportingPeriod = DateTime.Parse(reportP), CreatedBy = Sars.Systems.Security.ADUser.CurrentSID }; decimal saved = DatabaseWriter.SaveOutgoingCBC(voidedCBC, ref uid); DBWriteManager.ApproveOutgoingPackage(id, countryCode, reportingPeriod, 8, ADUser.CurrentSID); DBWriteManager.Insert_OutgoingPackageAuditTrail(outCBC.UID, Sars.Systems.Security.ADUser.CurrentSID, string.Format("Outgoing Package for {0} Pending Void Review", gvRow.Cells[0].Text.Split('-')[0].Trim())); var Subject = "Outgoing Package pending void review "; Common.SendEmailToRole("Reviewer", outCBC.CountryName, Subject, FDRPage.Statuses.Voided, senderEmail); MessageBox.Show("Package pending void review"); LoadCBC(); } }
protected void btnCorrect_Click(object sender, EventArgs e) { if (Request.QueryString["ccode"] != null && Request.QueryString["period"] != null) { FDRPage fPage = new FDRPage(); Guid newUid = new Guid(); var country = Request.QueryString["ccode"].ToString(); var reportingPeriod = Request.QueryString["period"].ToString(); var outCBC = DBReadManager.OutGoingCBCDeclarationsDetails(country, reportingPeriod); decimal id = string.IsNullOrEmpty(outCBC.Id.ToString()) ? 0 : outCBC.Id; var package = Common.GenerateCorrectionPackage(country, reportingPeriod); var email = ADUser.CurrentUser.Mail; string[] senderEmail = { email }; if (!string.IsNullOrEmpty(package.ToString())) { var outgoingCBC = new OutGoingCBCDeclarations() { Id = id, Country = country, CBCData = package.ToString(), StatusId = 7, Year = int.Parse(reportingPeriod.Substring(0, 4)), CreatedBy = Sars.Systems.Security.ADUser.CurrentSID }; decimal saved = DatabaseWriter.SaveOutgoingCBC(outgoingCBC, ref newUid); DBWriteManager.ApproveOutgoingPackage(id, country, reportingPeriod, 7, ADUser.CurrentSID); DBWriteManager.Insert_OutgoingPackageAuditTrail(outCBC.UID, Sars.Systems.Security.ADUser.CurrentSID, string.Format("Outgoing Package for {0} corrected", gvCBC.Rows[0].Cells[0].Text.Split('-')[0].Trim())); var Subject = "Outgoing CBC Report has been corrected "; Common.SendEmailToRole("Reviewer", outCBC.CountryName, Subject, FDRPage.Statuses.Corrected, senderEmail); LoadCBC(country, reportingPeriod); MessageBox.Show("Package has been corrected successfully"); } else { MessageBox.Show("No package was corrected"); } } }
public static decimal SaveOutgoingCBC(OutGoingCBCDeclarations cbcDeclarations, ref Guid newUid) { var oParams = new DBParamCollection { { "@Id", cbcDeclarations.Id }, { "@Country", cbcDeclarations.Country }, { "@StatusId", cbcDeclarations.StatusId }, { "@CBCData", cbcDeclarations.CBCData }, { "@CreatedBy", cbcDeclarations.CreatedBy }, { "@CBCWithNaspace", cbcDeclarations.NSCBCData }, { "@ActionId", cbcDeclarations.ActionId }, { "@Year", cbcDeclarations.Year }, { "@ReportingPeriod", cbcDeclarations.ReportingPeriod }, { "@NewIdentity", null, ParameterDirection.Output }, { "@UID", null, ParameterDirection.Output } }; using (var command = new DBCommand("[dbo].[uspUPSERT_OutGoingCBCDeclarations]", QueryType.StoredProcedure, oParams)) { Hashtable oHashTable; var scopeIdentity = 0L; command.Execute(out oHashTable); if (oHashTable.Count > 0) { if (!string.IsNullOrEmpty(oHashTable["@NewIdentity"].ToString())) { scopeIdentity = long.Parse(oHashTable["@NewIdentity"].ToString()); } if (!string.IsNullOrEmpty(oHashTable["@UID"].ToString())) { newUid = Guid.Parse(oHashTable["@UID"].ToString()); } } return(scopeIdentity); //return command.Execute(); } }