private async Task MigrateRecord(int RecordCount, string ObjectId, CorrModel corrModel, List <Attachment> attachments, List <Corrdetail> corrdetails, int corrtype)
{
Console.WriteLine("SrNo." + (RecordCount++) + " - " + JsonConvert.SerializeObject(corrModel) + Environment.NewLine + Environment.NewLine);
decimal result = 0;
if (corrtype == 2)
{
result = await CreateInCorr(corrModel);
}
if (corrtype == 1)
{
result = await CreateOutCorr(corrModel);
}
DataRow dataRow = ObjectWithCorrID.NewRow();
dataRow.SetField("RowId", RecordCount);
dataRow.SetField("ObjectId", ObjectId);
dataRow.SetField("RidCorr", result);
dataRow.SetField("CreateCorrJSONMessage", JsonConvert.SerializeObject(corrModel));
//dataRow.SetField("AttachmentIDs", typeof(string));
// dataRow.SetField("CorrDetailIDs", typeof(string));
dataRow.SetField("ErrorMessage", "Corr Created Successfully");
if (result > 0 && dataRow != null)
{
string attachIds = "";
int AttachSeq = 0;
foreach (var item in attachments)
{
item.RidCorr = (decimal)result;
item.Attachedfilename = "Attachment" + AttachSeq + ".pdf";
item.Attachsequence = AttachSeq++;
decimal attachId = await CreateAttachment(item);
if (attachId > 0)
{
attachIds += attachId.ToString() + ",";
}
}
dataRow.SetField("AttachmentIDs", attachIds);
string CorrDetailIDs = "";
foreach (var item in corrdetails)
{
item.RidCorr = (decimal)result;
decimal CorrDetailId = await CreateCorrDetail(item);
if (CorrDetailId > 0)
{
CorrDetailIDs += CorrDetailId.ToString() + ",";
}
}
dataRow.SetField("CorrDetailIDs", CorrDetailIDs);
}
ObjectWithCorrID.Rows.Add(dataRow);
}
public void processFile(string Filename)
{
//string[] Headers = "r_object_id||object_name/Correspondence Reference Number||Subject||Corr_Category||eif_project_ref||eif_type_of_doc||From_Code||eif_from||To_Code||eif_to||ecs_lc_state||eif_originator||folder_name||File Path||Rendition/Attachments||Rendition object ID||Confidential-YES/NO||Permissions/Confidentiality ||Relationship/Link||Created Date||Contract Number||Creator Name".Split("||");
StreamReader sr = new StreamReader(Filename);
TempFileName = Filename;
sw = new StreamWriter(TempFileName.Replace(".txt", "_result.txt"), true);
Tasks = new List <Task>();
string[] Headers = sr.ReadLine().Split("||");
int RecordCount = 1;
int counter = 0;
string objectID = "";
while (!sr.EndOfStream)
{
try
{
string RowData = sr.ReadLine();
string[] Fields = RowData.Split("||");
CorrModel corrModel = new CorrModel();
List <Attachment> attachments = new List <Attachment>();
List <Corrdetail> corrdetails = new List <Corrdetail>();
for (int i = 0; i < Headers.Length; i++)
{
try
{
if (Headers[i].Trim() == "object_name/Correspondence Reference Number")
{
if (corrtype == 2)
{
corrModel.SendersReferencenumber = Fields[i];
corrModel.Referencenumber = "E0000-ERL-JBS-CL-XXXXX";
}
else
{
//corrModel.SendersReferencenumber = "";
corrModel.Referencenumber = Fields[i];
}
}
if (Headers[i].Trim() == "r_object_id")
{
objectID = Fields[i].Trim();
}
if (Headers[i].Trim() == "Subject")
{
corrModel.Subject = Fields[i];
}
if (Headers[i].Trim() == "Corr_Category")
{
corrModel.RidCorrCategory = corrtype; // incoming correspondence
}
if (Headers[i].Trim() == "eif_type_of_doc")
{
//CL-1
//CC-2
//CM-3
if (Fields[i].Trim().Contains("CL-"))
{
corrModel.RidDocumenttype = 1;
}
else if (Fields[i].Trim().Contains("CC-"))
{
corrModel.RidDocumenttype = 2;
}
else if (Fields[i].Trim().Contains("CM-"))
{
corrModel.RidDocumenttype = 3;
}
else
{
//ignore this record
continue;
}
}
if (Headers[i].Trim() == "From_Code")
{
corrModel.SenderRidEntityList = EntityLists.Where(x => x.EntityCode == Fields[i]).First().RidEntityList;
}
if (Headers[i].Trim() == "To_Code")
{
corrModel.RecipientRidEntityList = EntityLists.Where(x => x.EntityCode == Fields[i]).First().RidEntityList;
}
if (Headers[i].Trim() == "ecs_lc_state")
{
corrModel.Status = "MIGRATED";
}
if (Headers[i].Trim() == "Created Date")
{
corrModel.CorrespondenceDate = DateTime.Parse(Fields[i]);
}
if (Headers[i].Trim() == "Confidential-YES/NO")
{
if (Fields[i].Trim().Contains("Y"))
{
string[] users = Fields[i + 1].Split(",");
foreach (var item in users)
{
try
{
Usermaster usermaster = Usermasters.Where(x => (x.Username) == item.Replace(" ", "")).FirstOrDefault();
if (usermaster != null)
{
corrdetails.Add(new Corrdetail()
{
Duedate = null, Include = "Y", Isactive = "Y", Ismandatory = "N", RidCommunicationtype = 1, RidCommunicationDetail = null, SignatureRequired = "N", RidWorkflowstep = (corrtype == 2 ? 2 : 4), RidUsermaster = usermaster.RidUsermaster
});
}
else if (item.Contains("DCC"))
{
corrdetails.Add(new Corrdetail()
{
Duedate = null, Include = "Y", Isactive = "Y", Ismandatory = "N", RidCommunicationtype = 1, RidCommunicationDetail = null, SignatureRequired = "N", RidWorkflowstep = (corrtype == 2 ? 2 : 4), RidUsermaster = Usermasters.Where(x => (x.Username) == "svc.cmsadmintest").FirstOrDefault().RidUsermaster
});
}
}
catch (Exception)
{
Console.WriteLine("Error at Record Index(" + RecordCount + ") at Column Index while finding Condidential user in Userlist:" + item);
throw;
}
}
}
else
{
}
}
if (Headers[i].Trim() == "Contract Number")
{
string[] temparr = Fields[i].Split("-");
Decimal tempContract = Contracts.Where(x => x.Contractcode == temparr[0].Trim()).First().RidContract;
corrModel.RidContractlist = Convert.ToDecimal(tempContract);
}
if (Headers[i].Trim() == "Creator Name")
{
//corrModel.RidUsermaster = 81;
Usermaster usermaster = Usermasters.Where(x => (x.Username) == Fields[i].Trim()).FirstOrDefault();
if (usermaster != null)
{
corrModel.RidUsermaster = usermaster.RidUsermaster;
}
else
{
corrModel.RidUsermaster = Usermasters.Where(x => (x.Username) == "svc.cmsadmintest").FirstOrDefault().RidUsermaster;
}
corrdetails.Add(new Corrdetail()
{
Duedate = null, Include = "Y", Isactive = "Y", Ismandatory = "N", RidCommunicationtype = 1, RidCommunicationDetail = null, SignatureRequired = "N", RidWorkflowstep = 1, RidUsermaster = corrModel.RidUsermaster
});
}
if (Headers[i].Trim() == "r_object_id")
{
objectID = Fields[i].Trim();
if (Fields[i].Trim().Length > 0)
{
attachments.Add(new Attachment()
{
ObjectID = Fields[i], Isactive = "Y"
});
}
}
if (Headers[i].Trim() == "Rendition object ID")
{
if (Fields[i].Trim().Length > 0)
{
attachments.Add(new Attachment()
{
ObjectID = Fields[i], Isactive = "Y"
});
}
}
}
catch (Exception)
{
string logMessage = "Error at Record Index(" + RecordCount + ") at Column Index" + i;
Console.WriteLine(logMessage);
DataRow dataRowError = ObjectWithCorrID.NewRow();
dataRowError.SetField("RowId", RecordCount);
dataRowError.SetField("ObjectId", Fields[0]);
//dataRowError.SetField("RidCorr", typeof(decimal));
// dataRowError.SetField("CreateCorrJSONMessage", typeof(string));
//dataRowError.SetField("AttachmentIDs", typeof(string));
//dataRowError.SetField("CorrDetailIDs", typeof(string));
dataRowError.SetField("ErrorMessage", logMessage);
ObjectWithCorrID.Rows.Add(dataRowError);
RecordCount++;
throw;
}
}
corrModel.Isactive = "Y";
corrModel.Isconfidential = "N";
corrModel.Isreplyrequired = "N";
corrModel.ApprovalsRequired = "N";
if (corrtype == 2)
{
corrModel.RidCommunicationType = 2;
}
else
{
corrModel.RidCommunicationType = 1;
}
corrModel.RidGroupType = 1;
corrModel.RelationRidCorr = new int[0];
Task temp = null;
try
{
temp = Task.Run(() => MigrateRecord(RecordCount++, Fields[0], corrModel, attachments, corrdetails, corrtype));
Tasks.Add(temp);
counter++;
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
try
{
if (counter == 5)
{
Task.WaitAll(Tasks.ToArray());
Tasks.Clear();
counter = 0;
foreach (DataRow e in ObjectWithCorrID.Rows)
{
try
{
sw.WriteLine(e[0] + "||" + e[1] + "||" + e[2] + "||" + e[3] + "||" + e[4] + "||" + e[5] + "||" + e[6]);
sw.Flush();
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
}
ObjectWithCorrID.Rows.Clear();
}
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
Tasks.Clear();
counter = 0;
foreach (DataRow e in ObjectWithCorrID.Rows)
{
try
{
sw.WriteLine(e[0] + "||" + e[1] + "||" + e[2] + "||" + e[3] + "||" + e[4] + "||" + e[5] + "||" + e[6]);
sw.Flush();
}
catch (Exception ex2)
{
Console.WriteLine(ex2.Message);
}
}
ObjectWithCorrID.Rows.Clear();
}
finally
{
}
}
catch (Exception)
{
Console.WriteLine(objectID + ": Skipping record");
}
}
sr.Close();
sw.Close();
}