public string AddPbcnetRecords(dbData3060DataContext p_dbData3060, string delsystem, int leveranceid, int pbsfilesid)
{
int antal;
int pbcnetrecords;
DateTime transmisionsdato;
int idlev;
string filename;
string rec;
pbcnetrecords = (from h in p_dbData3060.Tblpbsfile
where h.Pbsfilesid == pbsfilesid & (h.Seqnr == 0 | h.Seqnr == 9999)
select h).Count();
if (pbcnetrecords == 0)
{
// Find antal records
antal = (from h in p_dbData3060.Tblpbsfile
where h.Pbsfilesid == pbsfilesid & h.Seqnr != 0 & h.Seqnr != 9999
select h).Count();
transmisionsdato = DateTime.Now;
idlev = p_dbData3060.nextval_v2("idlev");
Tblpbsfilename rec_pbsfiles = (from h in p_dbData3060.Tblpbsfilename where h.Id == pbsfilesid select h).First();
rec = write00(delsystem, transmisionsdato, idlev, leveranceid);
Tblpbsfile rec_pbsfile = new Tblpbsfile {
Seqnr = 0, Data = rec
};
rec_pbsfiles.Tblpbsfile.Add(rec_pbsfile);
rec = write90(delsystem, transmisionsdato, idlev, leveranceid, antal);
rec_pbsfile = new Tblpbsfile {
Seqnr = 9999, Data = rec
};
rec_pbsfiles.Tblpbsfile.Add(rec_pbsfile);
p_dbData3060.SaveChanges();
filename = "D";
filename += lpad(String.Format("{0:yyMMdd}", transmisionsdato), 6, '?');
filename += lpad(idlev, 2, '0');
filename += ".";
filename += rpad(delsystem, 3, '_');
}
else
{
filename = "Unknown";
}
return(filename);
}
public int ReadFromLocalFile(dbData3060DataContext p_dbData3060, string FilePath)
{
FileInfo file;
try
{
file = new FileInfo(FilePath);
if (!(file.Exists))
{
return(0);
}
}
catch (Exception)
{
return(0);
}
//***********************************************************************
// Open a local file:
string fullpath = file.FullName;
int numBytes = (int)file.Length;
byte[] b_data = new byte[numBytes];
Console.WriteLine(string.Format("Start Reading of {0}", fullpath));
using (FileStream ts = file.Open(FileMode.Open, FileAccess.Read, FileShare.None))
{
ts.Read(b_data, 0, numBytes);
}
Console.WriteLine(string.Format("{0} Reading Completed", fullpath));
//clsAzure objAzure = new clsAzure();
//objAzure.uploadBlob(file.Name, b_data, false);
imapSaveAttachedFile(p_dbData3060, file.Name, b_data, false);
char[] c_data = System.Text.Encoding.GetEncoding("windows-1252").GetString(b_data).ToCharArray();
string filecontens = new string(c_data);
string filecontens2 = filecontens.TrimEnd('\n');
string filecontens3 = filecontens2.TrimEnd('\r');
string filecontens4 = filecontens3.TrimEnd('\n');
string[] lines = filecontens4.Split('\n');
string ln = null;
int seqnr = 0;
string ln0_6;
Tblpbsfilename m_rec_pbsfilename = new Tblpbsfilename
{
Type = 8,
Path = file.Directory.FullName,
Filename = file.Name,
Size = (int)file.Length,
Atime = file.LastAccessTime,
Mtime = file.LastWriteTime
};
for (int idx = 0; idx < lines.Count(); idx++)
{
ln = lines[idx].TrimEnd('\r');
try { ln0_6 = ln.Substring(0, 6); }
catch { ln0_6 = ""; }
if (((seqnr == 0) && !(ln0_6 == "PBCNET")) || (seqnr > 0))
{
seqnr++;
}
if (ln.Length > 0)
{
m_rec_pbsfile = new Tblpbsfile
{
Seqnr = seqnr,
Data = ln
};
m_rec_pbsfilename.Tblpbsfile.Add(m_rec_pbsfile);
}
}
m_rec_pbsfilename.Transmittime = DateTime.Now;
p_dbData3060.Tblpbsfilename.Add(m_rec_pbsfilename);
//var cb = new SqlConnectionStringBuilder(p_dbData3060.Connection.ConnectionString);
Console.WriteLine(string.Format("Start Write {0} to SQL Database {1} on {2}", file.Name, "cb.InitialCatalog", "cb.DataSource"));
try
{
p_dbData3060.SaveChanges();
}
catch (Exception e)
{
Console.WriteLine(string.Format("p_dbData3060.SaveChanges() failed with message: {0}", e.Message));
throw;
}
Console.WriteLine(string.Format("{0} Write to SQL Database Completed", file.Name));
return(1);
}
public int ReadFraSFtp(dbData3060DataContext p_dbData3060)
{
m_memPbsnetdir = new MemPbsnetdir(); //opret ny memPbsnetdir
// Iterate over the files.
foreach (SftpFile fileObj in m_sftp.ListDirectory(m_rec_sftp.Outbound))
{
if (fileObj.Name != "." && fileObj.Name != "..")
{
recPbsnetdir rec = new recPbsnetdir
{
Type = 8,
Path = m_rec_sftp.Outbound,
Filename = fileObj.Name,
Size = (int)fileObj.Length,
Atime = fileObj.LastAccessTime,
Mtime = fileObj.LastWriteTime,
Gid = fileObj.GroupId,
Uid = fileObj.UserId,
Perm = ""
};
m_memPbsnetdir.Add(rec);
}
}
var leftqry_pbsnetdir =
from h in m_memPbsnetdir
//join d1 in p_dbData3060.Tblpbsfiles on new { h.Path, h.Filename } equals new { d1.Path, d1.Filename } into details
//from d1 in details.DefaultIfEmpty(new Tblpbsfiles { Id = -1, Type = (int?)null, Path = null, Filename = null, Size = (int?)null, Atime = (DateTime?)null, Mtime = (DateTime?)null, Perm = null, Uid = (int?)null, Gid = (int?)null })
//where d1.Path == null && d1.Filename == null
select h;
int AntalFiler = leftqry_pbsnetdir.Count();
if (leftqry_pbsnetdir.Count() > 0)
{
foreach (var rec_pbsnetdir in leftqry_pbsnetdir)
{
Tblpbsfilename m_rec_pbsfiles = new Tblpbsfilename
{
Type = rec_pbsnetdir.Type,
Path = rec_pbsnetdir.Path,
Filename = rec_pbsnetdir.Filename,
Size = rec_pbsnetdir.Size,
Atime = rec_pbsnetdir.Atime,
Mtime = rec_pbsnetdir.Mtime,
Perm = rec_pbsnetdir.Perm,
Uid = rec_pbsnetdir.Uid,
Gid = rec_pbsnetdir.Gid
};
p_dbData3060.Tblpbsfilename.Add(m_rec_pbsfiles);
//***********************************************************************
// Open a file on the server:
string fullpath = rec_pbsnetdir.Path + "/" + rec_pbsnetdir.Filename;
int numBytes = (int)rec_pbsnetdir.Size;
byte[] b_data = new byte[numBytes];
MemoryStream stream = new MemoryStream(b_data, true);
Console.WriteLine(string.Format("Start Download of {0}", fullpath));
m_sftp.DownloadFile(fullpath, stream);
Console.WriteLine(string.Format("{0} Download Completed", fullpath));
//clsAzure objAzure = new clsAzure();
//objAzure.uploadBlob(rec_pbsnetdir.Filename, b_data, false);
imapSaveAttachedFile(p_dbData3060, rec_pbsnetdir.Filename, b_data, false);
char[] c_data = System.Text.Encoding.GetEncoding("windows-1252").GetString(b_data).ToCharArray();
string filecontens = new string(c_data);
string filecontens2 = filecontens.TrimEnd('\n');
string filecontens3 = filecontens2.TrimEnd('\r');
string filecontens4 = filecontens3.TrimEnd('\n');
string[] lines = filecontens4.Split('\n');
string ln = null;
int seqnr = 0;
string ln0_6;
for (int idx = 0; idx < lines.Count(); idx++)
{
ln = lines[idx].TrimEnd('\r');
try { ln0_6 = ln.Substring(0, 6); }
catch { ln0_6 = ""; }
if (((seqnr == 0) && !(ln0_6 == "PBCNET")) || (seqnr > 0))
{
seqnr++;
}
if (ln.Length > 0)
{
m_rec_pbsfile = new Tblpbsfile
{
Seqnr = seqnr,
Data = ln
};
m_rec_pbsfiles.Tblpbsfile.Add(m_rec_pbsfile);
}
}
//this.Database.GetDbConnection()
m_rec_pbsfiles.Transmittime = DateTime.Now;
//var cb = new SqlConnectionStringBuilder(p_dbData3060.Connection.ConnectionString);
Console.WriteLine(string.Format("Start Write {0} to SQL Database {1} on {2}", rec_pbsnetdir.Filename, "cb.InitialCatalog", "cb.DataSource"));
try
{
p_dbData3060.SaveChanges();
}
catch (Exception e)
{
Console.WriteLine(string.Format("p_dbData3060.SaveChanges() failed with message: {0}", e.Message));
throw;
}
Console.WriteLine(string.Format("{0} Write to SQL Database Completed", rec_pbsnetdir.Filename));
}
}
p_dbData3060.SaveChanges();
return(AntalFiler);
}