protected void FileOpenCommand(object sender, CommandEventArgs e)
{
if (e.CommandArgument != null)
{
var btn = sender as LinkButton;
if (btn == null)
{
return;
}
var row = btn.NamingContainer as GridViewRow;
if (row == null)
{
return;
}
var gv = row.NamingContainer as GridView;
if (gv == null)
{
return;
}
gv.SelectedIndex = row.RowIndex;
if (gv.SelectedDataKey != null)
{
if (_fileSubmission == null)
{
_fileSubmission = DBReadManager.GeFileSubmissionById(Convert.ToDecimal(SubmissionId));
}
var fileId = gv.SelectedDataKey.Value;
Response.Redirect(string.Format("outgoingfiledetails.aspx?oId={0}&fId={1}&submissionId={2}&refNo={3}", e.CommandArgument, fileId, SubmissionId, _fileSubmission.TaxRefNo));
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (string.IsNullOrEmpty(SubmissionId))
{
MessageBox.Show("Could not retrieve documents - Submission ID is missing");
return;
}
if (!IsPostBack)
{
_fileSubmission = DBReadManager.GeFileSubmissionById(Convert.ToDecimal(SubmissionId));
LoadFiles();
if (_fileSubmission != null)
{
if (_fileSubmission.SubmissionStatusId == 3 ||
_fileSubmission.SubmissionStatusId == 4 ||
_fileSubmission.SubmissionStatusId == 5)
{
btnSave.Enabled = false;
btnSubmit.Enabled = false;
}
else
{
btnSave.Enabled = true;
btnSubmit.Enabled = true;
}
}
if (gvLocalFiles.Rows.Count == 0 && gvMasterFiles.Rows.Count == 0)
{
btnSave.Enabled = false;
btnSubmit.Enabled = false;
}
}
}
private static void SendNotification(decimal submissionId)
{
var submission = DBReadManager.GeFileSubmissionById(submissionId);
if (submission == null)
{
return;
}
var files = DBReadManager.GetFilesPerSubmission(submissionId.ToString(CultureInfo.InvariantCulture));
var roles = DbReader.GetRolesToNotify();
if (roles.HasRows)
{
var x = (from s in roles.Tables[0].Rows.OfType <DataRow>()
select s["EmailAddress"].ToString()).ToArray();
var fileList = new StringBuilder();
//fileList.Append("<ul>");
foreach (DataRow file in files.Tables[0].Rows)
{
fileList.AppendFormat("<li>{0} - {1}</li>", file["Category"], file["Classification"]);
}
//fileList.Append("</ul>");
var messageBody = string.Format(
File.ReadAllText("FileArrivalNotification.htm")
, submission.TaxRefNo
, submission.Year
, fileList
, SARSDataSettings.Settings.ApplicationName);
FdrCommon.SendEmail(x, messageBody, "CBC Declaration");
}
}
protected void gvMasterFiles_RowDataBound(object sender, GridViewRowEventArgs e)
{
if (e.Row.RowType != DataControlRowType.DataRow)
{
return;
}
var ddlOutcome = e.Row.FindControl("ddlOutcome") as DropDownList;
var txtOutcomeReason = e.Row.FindControl("txtOutcomeReason") as TextBox;
if (ddlOutcome != null && txtOutcomeReason != null)
{
ddlOutcome.Bind(DBReadManager.GetFileValidationOutcomes(), "Description", "ID");
var fileId = DataBinder.Eval(e.Row.DataItem, "FileId");
if (fileId != null)
{
var details = DBReadManager.GeFileValidationOutcomeDetailsByFileId(Convert.ToDecimal(fileId));
if (details != null)
{
ddlOutcome.SelectItemByValue(details.ValidationOutcomeId);
txtOutcomeReason.SetValue(details.OutcomeReason);
}
}
if (_fileSubmission == null)
{
_fileSubmission = DBReadManager.GeFileSubmissionById(Convert.ToDecimal(SubmissionId));
}
if (_fileSubmission.SubmissionStatusId == 3 ||
_fileSubmission.SubmissionStatusId == 4 ||
_fileSubmission.SubmissionStatusId == 5)
{
ddlOutcome.Enabled = false;
}
else
{
ddlOutcome.Enabled = true;
}
}
var category = DataBinder.Eval(e.Row.DataItem, "Category").ToString();
var fileName = DataBinder.Eval(e.Row.DataItem, "FileName").ToString();
var body = new StringBuilder();
body.Append("<table style='width:100%;padding:5px'><tr style='background:khaki;'>");
body.Append("<td><b>Category:</b></td>");
body.AppendFormat("<td>{0}</td>", category);
body.Append("</tr>");
body.Append("<tr style='background:khaki;'>");
body.Append("<td><b>File Name:</b></td>");
body.AppendFormat("<td>{0}</td>", fileName);
body.Append("</tr>");
body.Append("</table>");
e.Row.Attributes.Add("title", "cssbody=[dvbdy1] cssheader=[dvhdr1] header=[<b><font color='blue'>More Details</font></b>] body=[" + body + "]");
}
protected void Page_Load(object sender, EventArgs e)
{
if (IsPostBack)
{
return;
}
if (string.IsNullOrEmpty(Request["fId"]))
{
MessageBox.Show("File ID parameter is missing");
return;
}
if (string.IsNullOrEmpty(Request["oId"]))
{
MessageBox.Show("Object ID parameter is missing");
return;
}
if (string.IsNullOrEmpty(Request["submissionId"]))
{
MessageBox.Show("Submission ID parameter is missing");
return;
}
_fileSubmission = DBReadManager.GeFileSubmissionById(Convert.ToDecimal(SubmissionId));
if (_fileSubmission != null)
{
if (_fileSubmission.SubmissionStatusId == 3 ||
_fileSubmission.SubmissionStatusId == 4 ||
_fileSubmission.SubmissionStatusId == 5)
{
Toolbar1.Items[0].Visible = false;
}
else
{
Toolbar1.Items[0].Visible = true;
}
}
var fileId = Convert.ToDecimal(Request["fId"]);
using (var data = DBReadManager.GetFileById(fileId))
{
if (data.HasRows)
{
gvDetails.Bind(data);
}
}
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
int j = 0, k = 0;
var listOfFiles = new List <FileValidationOutcomeDetails>();
foreach (GridViewRow row in gvMasterFiles.Rows)
{
var ddlOutcome = row.FindControl("ddlOutcome") as DropDownList;
var txtOutcomeReason = row.FindControl("txtOutcomeReason") as TextBox;
if (ddlOutcome != null && txtOutcomeReason != null)
{
ddlOutcome.BackColor = Color.Transparent;
if (ddlOutcome.SelectedIndex <= 0)
{
ddlOutcome.BackColor = Color.Red;
k++;
break;
}
var dataKey = gvMasterFiles.DataKeys[row.RowIndex];
if (dataKey != null)
{
var fileId = Convert.ToDecimal(dataKey.Value);
listOfFiles.Add(new FileValidationOutcomeDetails {
Id = 0,
SubmissionId = Convert.ToDecimal(SubmissionId),
FileId = fileId,
ValidationOutcomeId = Convert.ToInt32(ddlOutcome.SelectedValue),
SID = Sars.Systems.Security.ADUser.CurrentSID,
OutcomeReason = string.IsNullOrEmpty(txtOutcomeReason.Text) ? null : txtOutcomeReason.Text
}
);
}
}
}
foreach (GridViewRow row in gvLocalFiles.Rows)
{
var ddlOutcome = row.FindControl("ddlOutcome") as DropDownList;
var txtOutcomeReason = row.FindControl("txtOutcomeReason") as TextBox;
if (ddlOutcome != null && txtOutcomeReason != null)
{
ddlOutcome.BackColor = Color.Transparent;
if (ddlOutcome.SelectedIndex <= 0)
{
ddlOutcome.BackColor = Color.Red;
j++;
break;
}
var dataKey = gvLocalFiles.DataKeys[row.RowIndex];
if (dataKey != null)
{
var fileId = Convert.ToDecimal(dataKey.Value);
listOfFiles.Add(
new FileValidationOutcomeDetails {
Id = 0,
SubmissionId = Convert.ToDecimal(SubmissionId),
FileId = fileId,
ValidationOutcomeId = Convert.ToInt32(ddlOutcome.SelectedValue),
SID = Sars.Systems.Security.ADUser.CurrentSID,
OutcomeReason = string.IsNullOrEmpty(txtOutcomeReason.Text) ? null : txtOutcomeReason.Text
}
);
}
}
}
if (k > 0)
{
tbMain.ActiveTabIndex = 0;
MessageBox.Show("Please select validation outcome for all the files.");
return;
}
if (j > 0)
{
tbMain.ActiveTabIndex = 1;
MessageBox.Show("Please select validation outcome for all the files.");
return;
}
if (listOfFiles.Any())
{
var numSaved = 0;
foreach (var detailse in listOfFiles)
{
numSaved += DBWriteManager.SaveFileValidationOutcome(detailse);
}
if (_fileSubmission == null)
{
_fileSubmission = DBReadManager.GeFileSubmissionById(Convert.ToDecimal(SubmissionId));
}
if (numSaved == (gvLocalFiles.Rows.Count + gvMasterFiles.Rows.Count))
{
btnSave.Enabled = false;
btnSubmit.Enabled = false;
MessageBox.Show("Validation submitted successfully");
}
var status = 0;
var accepted = listOfFiles.Count(a => a.ValidationOutcomeId == 1);
var rejected = listOfFiles.Count(a => a.ValidationOutcomeId == 2);
if (accepted == listOfFiles.Count())
{
// accepted = 3
status = 3;
try{
if (!string.IsNullOrEmpty(_fileSubmission.ContactMobileNumber) && _fileSubmission.ContactMobileNumber.IsValid(StringValidationType.CellularNumber))
{
var smsBody = DBReadManager.GetMasterLocalFileNotificationSmsBodyTemplate(2);
if (!string.IsNullOrEmpty(smsBody))
{
var service = new FDRQueueService();
service.SendSms(
_fileSubmission.ContactMobileNumber
, _fileSubmission.TaxRefNo
, string.Format(smsBody, _fileSubmission.TaxRefNo)
, _fileSubmission.Year
);
DBWriteManager.SaveSentSmsCommunications(
_fileSubmission.TaxRefNo
, string.Format(smsBody, _fileSubmission.TaxRefNo)
, _fileSubmission.Year
);
}
}
}
catch (Exception) {
;
}
try{
if (!string.IsNullOrEmpty(_fileSubmission.ContactEmail))
{
byte[] attachment = null;//FdrCommon.GetFileAcceptenceLetter(SubmissionId);
var service = new FDRQueueService();
var messageBody = string.Format(DBReadManager.GetMasterLocalFileNotificationEmailBodyTemplate(2), _fileSubmission.TaxRefNo);
service.SendEmail
(
messageBody
, "CBC File validation outcome"
, _fileSubmission.ContactEmail
, null
, "CBC File validation outcome"
, _fileSubmission.TaxRefNo
, _fileSubmission.Year
);
}
}
catch (Exception) {
;
}
try{
var attachment = FdrCommon.GetEfilingAcceptanceLetter(_fileSubmission.Year);
if (!string.IsNullOrEmpty(attachment))
{
var service = new FDRQueueService();
service.SendLetter
(
_fileSubmission.SubmissionId
, _fileSubmission.TaxRefNo
, _fileSubmission.Year
, attachment
, "Acceptance of Master Files and Local Files"
, true
, Sars.Systems.Security.ADUser.CurrentSID
);
}
}
catch (Exception)
{
;
}
}
else if (rejected == listOfFiles.Count())
{
//rejected = 4
status = 4;
try{
if (!string.IsNullOrEmpty(_fileSubmission.ContactMobileNumber) && _fileSubmission.ContactMobileNumber.IsValid(StringValidationType.CellularNumber))
{
var smsBody = DBReadManager.GetMasterLocalFileNotificationSmsBodyTemplate(3);
if (!string.IsNullOrEmpty(smsBody))
{
var service = new FDRQueueService();
service.SendSms
(
_fileSubmission.ContactMobileNumber
, _fileSubmission.TaxRefNo
, string.Format(smsBody, _fileSubmission.TaxRefNo)
, _fileSubmission.Year
);
DBWriteManager.SaveSentSmsCommunications(
_fileSubmission.TaxRefNo
, string.Format(smsBody, _fileSubmission.TaxRefNo)
, _fileSubmission.Year
);
}
}
}
catch (Exception) {
;
}
try{
if (!string.IsNullOrEmpty(_fileSubmission.ContactEmail))
{
//var attachment = FdrCommon.GetFileRejectionLetter(SubmissionId);
var service = new FDRQueueService();
var messageBody = string.Format(
DBReadManager.GetMasterLocalFileNotificationEmailBodyTemplate(3),
_fileSubmission.TaxRefNo);
service.SendEmail(
messageBody
, "CBC File validation outcome"
, _fileSubmission.ContactEmail
, null
, "CBC File validation outcome"
, _fileSubmission.TaxRefNo
, _fileSubmission.Year
);
}
}
catch (Exception) {
;
}
//SEND EFILING REJECTION LETTERS
try{
var attachment = FdrCommon.GetEfilingRejectionLetter(_fileSubmission.TaxRefNo, _fileSubmission.Year, Convert.ToDecimal(SubmissionId));
if (!string.IsNullOrEmpty(attachment))
{
var service = new FDRQueueService();
service.SendLetter
(
_fileSubmission.SubmissionId
, _fileSubmission.TaxRefNo
, _fileSubmission.Year
, attachment
, "Rejection of Master Files and Local Files"
, false
, Sars.Systems.Security.ADUser.CurrentSID
);
}
}
catch (Exception exception) {
MessageBox.Show(exception.ToString());
}
}
else
{
try
{
if (!string.IsNullOrEmpty(_fileSubmission.ContactMobileNumber) && _fileSubmission.ContactMobileNumber.IsValid(StringValidationType.CellularNumber))
{
var smsBody = DBReadManager.GetMasterLocalFileNotificationSmsBodyTemplate(4);
if (!string.IsNullOrEmpty(smsBody))
{
var service = new FDRQueueService();
service.SendSms
(
_fileSubmission.ContactMobileNumber
, _fileSubmission.TaxRefNo
, string.Format(smsBody, _fileSubmission.TaxRefNo)
, _fileSubmission.Year
);
DBWriteManager.SaveSentSmsCommunications(
_fileSubmission.TaxRefNo
, string.Format(smsBody, _fileSubmission.TaxRefNo)
, _fileSubmission.Year
);
}
}
}
catch (Exception)
{
;
}
try
{
if (!string.IsNullOrEmpty(_fileSubmission.ContactEmail))
{
//var attachment = FdrCommon.GetFileRejectionLetter(SubmissionId);
var service = new FDRQueueService();
var messageBody = string.Format(
DBReadManager.GetMasterLocalFileNotificationEmailBodyTemplate(4),
_fileSubmission.TaxRefNo);
service.SendEmail(
messageBody
, "CBC File validation outcome"
, _fileSubmission.ContactEmail
, null
, "CBC File validation outcome"
, _fileSubmission.TaxRefNo
, _fileSubmission.Year
);
}
}
catch (Exception)
{
;
}
//SEND EFILING ACCEPTANCE LETTERS
try
{
var attachment = FdrCommon.GetEfilingRejectionLetter(_fileSubmission.TaxRefNo, _fileSubmission.Year, Convert.ToDecimal(SubmissionId));
if (!string.IsNullOrEmpty(attachment))
{
var service = new FDRQueueService();
service.SendLetter
(
_fileSubmission.SubmissionId
, _fileSubmission.TaxRefNo
, _fileSubmission.Year
, attachment
, "Rejection of Master Files and Local Files"
, false
, Sars.Systems.Security.ADUser.CurrentSID
);
}
}
catch (Exception)
{
;
}
//Accepted With Warnings = 5
status = 5;
}
if (status != 0)
{
DBWriteManager.ChangeSubmissionStatus(Convert.ToDecimal(SubmissionId), status);
}
}
else
{
MessageBox.Show("No validation was submitted");
}
}