private long DownloadFile()
{
if (!this.ftpLoggedIn_flag)
{
return(-2);
}
if (string.IsNullOrEmpty(this.downFile_name))
{
return(-1);
}
MemoryStream ms = new MemoryStream();
long len = this.remoteSource.DownloadFile(this.downFile_name, ms);
if (len < 0)
{
return(-2);
}
else
{
ms.Seek(0, SeekOrigin.Begin);
}
byte[] fileData_bytes = new byte[len];
ms.Read(fileData_bytes, 0, fileData_bytes.Length);
//split and save file to DB
List <SPR_file> sf_list = SPR_fileControl.SplitRawFile(fileData_bytes);
foreach (SPR_file sf in sf_list)
{
sf.FileName.Value = this.downFile_name;
this.errLog.Add("CUSIP: " + sf.CUSIP.Value + " " + (sf.Insert_to_DB() ? "Saved" : "Fail in saving"));
}
if (sf_list.Count < 1)//save no result file as rejected
{
SPR_file sf = new SPR_file();
sf.SetStatus(HssStatus.Rejected);
sf.FileName.Value = this.downFile_name;
sf.FileBinary = fileData_bytes;
this.errLog.Add("No Data file saved", sf.Insert_to_DB().ToString());
}
return(len);
}
/// <summary>
/// Insert DTC Position using SPR file from DTCC
/// </summary>
/// <param name="sf">SPR file</param>
/// <param name="createNew_flag">append or create new</param>
public bool Insert_DTC_position(SPR_file sf, bool createNew_flag = true)
{
if (sf == null || sf.FileBinary == null)
{
MessageBox.Show("Dividend_func4 error 0: No SPR data");
return(false);
}
MemoryStream ms = new MemoryStream(sf.FileBinary);
StreamReader sr = new StreamReader(ms);
if (createNew_flag)
{
this.Delete_DTC_position();
}
List <Position> posList = new List <Position>();
string str = null;
while ((str = sr.ReadLine()) != null)
{
if (str.Length <= 37)
{
continue;
}
char recordType_char = str[SPR_fileControl.RecordTypeChar_index];
if (recordType_char != '2')
{
continue; //'2' stands for detail records
}
if (str.StartsWith("HDR", StringComparison.OrdinalIgnoreCase))
{
continue;
}
if (str.StartsWith("TRL", StringComparison.OrdinalIgnoreCase))
{
break;
}
Position dtcPos = new Position();
dtcPos.DividendIndex = this.DividendIndex;
dtcPos.DTC_Number = str.Substring(19, 8).TrimStart('0');
dtcPos.Company_Name = str.Substring(27, 10).Trim();
string totalPos_str = str.Substring(37).Trim();
decimal tempDecimal = -1;
if (decimal.TryParse(totalPos_str, out tempDecimal))
{
dtcPos.Total_RecDate_Position = tempDecimal;
}
posList.Add(dtcPos);
}
ParticipantMaster pcMaster = new ParticipantMaster();
pcMaster.Init_from_dtcPosList(posList);
Bulk_DBcmd buk_ins = new Bulk_DBcmd();
List <DTC_Participants> missing_DCTpart_list = new List <DTC_Participants>();
foreach (Position pos in posList)
{
Participant pt = pcMaster.GetParticipant(pos.DTC_Number);
if (pt == null)
{
DTC_Participants dtcPart = new DTC_Participants();
int tempInt = -1;
if (!int.TryParse(pos.DTC_Number, out tempInt))
{
continue;
}
dtcPart.DTC = tempInt;
dtcPart.DTC_Number.Value = pos.DTC_Number;
dtcPart.Company_Name.Value = pos.Company_Name;
missing_DCTpart_list.Add(dtcPart);
}
else
{
pos.Company_Name = pt.Company_Name; //if exist, change the name to what we have in [DTC_Participants]
}
buk_ins.Add_DBcmd(pos.Get_DBinsert());
}
int count0 = buk_ins.SaveToDB(Utility.Get_DRWIN_hDB());
int count1 = DTC_Participants_master.Insert_DTC_Participants(missing_DCTpart_list);
return(true);
}
