Questions regarding the use of the Windows Service

I have the following doubt, I have a windows service, and in it after reading the file I move that file to another folder, however if any barcode that exists inside that file is not registered in my database, I will not insert in another particular table, I am explaining only the process.

Now my doubt: In the log generated, I inform this barcode that was not inserted for this reason, but I would like to know how I could do to inform the responsible person, that the bar code was not inserted in the given table of the bank because it is not registered , is there a way to send an email informing this bar code and asking for it to register the same? how could I do the coding for the email?

// InsertLog Method
private static void InsertLog (string row)
{
// Create Log Folder, if it does not exist
if (! Directory.Exists (LogFileLog))
{
Directory.CreateDirectory (LogFileLog);
}
// Create Log File, if it does not exist
string FullPath = LogFileLog + "\\ Proofing Processing Log.txt";
if (! File.Exists (FullPath))
{
using (File.Create (FullPath));
}
// Write to LOG file
using (StreamWriter file = new StreamWriter (FullPath, true))
{
file.WriteLine (line);
file.Dispose ();
}
}

// Here I look for all proc_inter from the sdpj_proc_interest table
// that has the bar code read in the file, only for you to understand where I want to go.
GetCodProcInter (string CodBar)
{
using (DB db = new DB ())
{
string SQL = string.Format (@ "SELECT T0.cod_proc_inter FROM sdpj_proc_inter T0 WHERE T0.cod_bars_banestes = '{0}'", CodBar);
var data = db.ExecuteCommandCommission (SQL);
if (data.Read ())
{
return data ["cod_proc_inter"]. ToString ();
}
}
return "";
}

// This method, I use to move the read files.
private static void MoveFile (string FileName)
{
try
{
FileFilesImported + = "\\" + FileName;
FileFilesPpendents + = "\\" + FileName;
File.Move (FolderFiles, FileFilesImported);
}
catch (Exception)
{
throw;
}
}

// In this method I go through all the lines, until I find the information that
// I need to read and write.
private static void ProcessesFile (string FullPathFile, string FileName)
{
try
{
bool Move r = true;
string [] StringLine = System.IO.File.ReadAllLines (FullPathFile);
string CodBars = "";
for (int line = 0; line
{
string DateScheduling = "";
string DocumentValue = "";
string Protocol = "";
string Register = "";
string Emission = "";
#regi on Retrieve Bar Code
if (String [line] .Contains ("Bar Cod:"))
{
CodBars + = String [line] .Replace ("BarCode:", "");
ln + = 2;
}
if (CodBar! = "")
{
CodBar + = String [line];
CodBar = CodBar.Replace ("", "");
}
#endregion
if (CodBar == "")
continue;
line + = 6;
#region Scheduling Date
if (String [line] .Contains ("Delay:"))
{
DateScheduling + = String [line] .Replace ("Date.Scheduling:", "").Replace ("", "");
}
#endregion
line + = 2;
#region Document Value
if (StringLine [line] .Contains ("Document.Value:"))
{
DocumentValue + = String [line] .Replace ("Vlr.Documento:", "") .Replace ("", "");
}
#endr?egion
line += 2;
#region Protocol
if (StringLine[line].Contains("Protocol:"))
{
Protocolo += StringLine[line].Replace("Protocol:", "").Replace(" ", "");
}
?
#endr?egion
?
line ?+= 12;
#region Register
if (StringLine[line].Contains("Register:"))
{
Register += StringLine[line].Replace("Register:", "");
}?
#?endregion
l?ine ??+= 2;
#?region Emission
i?f (StringLine[line].Contains("Emission.:"))
{
? E?mission += StringLine[line].Replace("Emission.:", "");
}??
??
#?endr?egion
?
// Search BarCode
string CodProcInter = GetCodProcInter (CodeBarra);
if (! string.IsNullOrEmpty (CodProcInter))
{
if (! CodeBarAlreadyInserted (CodeBar))
{
// Insert Bar Code
bool inserted = BankInfo (CodProcInter, CodeBar, DateScheduling, DocumentValue, Protocol, Register, Emission);
}
{
// Bar Code Already Inserted
InsertLog ("\ n Already Exists ->" + CodBar);
}
}
else
{
// Barcode not available in table -> sdpj_proc_inter
// if it is not available, should I inform the responsible person, sending the barcode number to that person, how to do it?
Move = false;
InsertLog ("\ nCode Bar Not Available ->" + CodeBar);
}
// Clear Variables
CodeBar = "";
}
if
{
MoveFile (FileName);
}
}
catch (Except ion)
{
throw;
}
}

In that part of the code my doubt lives.

if (! string.IsNullOrEmpty (CodProcInter))
{
if (!CodeBarAlreadyinserted(CodeBar))
{
// Insert Bar Code
bool inserted = BankInfo (CodProcInter, CodBar, DateScheduling, DocumentValue, Protocol, Register, Emission);
}
{
// Bar Code Already Inserted
InsertLog ("\ n Already Exists ->" + CodeBar);
}
}
else
{
// Barcode not available in table -> sdpj_proc_inter
// if it is not available, should I inform the responsible person, sending the barcode number to that person, how to do it?
Move = false;
InsertLog ("\ nCode Bar Not Available ->" + CodeBar);
}

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Robson Amaral8y ago
Faisal Pathan, thank you for contributing, I have seen the code of your site reference, but the button click event is used, but I am in need of an email sending code that I could adapt in my functionality, which means that when the barcode read from the file is queried in the database referring to the sdpj_proc_inter table and does not exist and inform in the log, I need to get this barcode that was informed, and send the email of the responsible to do the insertion. The windows service is to read files that have been processed and to insert into another particular table of the bank and then move that file to the processed folder, this I am already doing, I am just detailing the routine for you, however I am needing at that moment something that fits in my problem, I do not know how I could be informing this code via email and how it could be done. I have not solved the problem yet.
0
Faisal Pathan8y ago
Yes you should send mail and below reference will help you.
https://www.c-sharpcorner.com/UploadFile/009464/send-email-to-gmail-using-smtp-in-windows-application/
0