private void ConvertToUnicode(List <PreclaimMatchingViewModel> dataLoad)
{
try
{
if (dataLoad == null || dataLoad.Count == 0)
{
return;
}
foreach (var item in dataLoad)
{
//if(item.SerialNo ==9997)
//{
// int a = 1;
//}
if (item.TITLE != string.Empty)
{
item.TITLE = ConvertAllToUnicode.ConvertFromComposite(item.TITLE);
}
if (item.ARTIST != string.Empty)
{
item.ARTIST = ConvertAllToUnicode.ConvertFromComposite(item.ARTIST);
}
if (item.ALBUM != string.Empty)
{
item.ALBUM = ConvertAllToUnicode.ConvertFromComposite(item.ALBUM);
}
if (item.LABEL != string.Empty)
{
item.LABEL = ConvertAllToUnicode.ConvertFromComposite(item.LABEL);
}
if (item.COMP_TITLE != string.Empty)
{
item.COMP_TITLE = ConvertAllToUnicode.ConvertFromComposite(item.COMP_TITLE);
}
if (item.COMP_WRITERS != string.Empty)
{
item.COMP_WRITERS = ConvertAllToUnicode.ConvertFromComposite(item.COMP_WRITERS);
}
}
}
catch (Exception)
{
}
}
/// <summary>
/// Nạp file json preclaim
/// </summary>
/// <param name="path"></param>
/// <param name="year"></param>
/// <param name="month"></param>
/// <returns></returns>
public static List <PreclaimViewModel> JsonToPreclaim(string path)
{
string line;
List <string> subJsonList = new List <string>();
StreamReader r = new StreamReader(path);
bool isFirst = false;
string subJson = "";
while ((line = r.ReadLine()) != null)
{
subJson += line;
if (line.Trim() == "{")
{
isFirst = true;
}
else if (line.Trim() == "}")
{
if (isFirst)
{
subJsonList.Add(subJson);
}
isFirst = false;
subJson = "";
}
}
List <PreclaimViewModel> objects = new List <PreclaimViewModel>();
BsonDocument doctem = null;
PreclaimJson preJson = null;
PreclaimViewModel preVM = null;
int serial = 1;
for (int i = 0; i < subJsonList.Count; i++)
{
doctem = BsonSerializer.Deserialize <BsonDocument>(subJsonList[i]);
preJson = BsonSerializer.Deserialize <PreclaimJson>(doctem);
preVM = new PreclaimViewModel
{
SerialNo = serial,
Asset_ID = preJson.Asset_ID,
ISRC = preJson.ISRC == null ? string.Empty: VnHelper.ConvertToUnSign(ConvertAllToUnicode.ConvertFromComposite(preJson.ISRC.ToUpper())),
Comp_Asset_ID = preJson.Comp_Asset_ID,
C_Title = preJson.C_Title == null ? string.Empty : VnHelper.ConvertToUnSign(ConvertAllToUnicode.ConvertFromComposite(preJson.C_Title.ToUpper())),
C_ISWC = preJson.C_ISWC == null ? string.Empty : VnHelper.ConvertToUnSign(ConvertAllToUnicode.ConvertFromComposite(preJson.C_ISWC.ToUpper())),
C_Workcode = preJson.C_Workcode == null ? string.Empty : VnHelper.ConvertToUnSign(ConvertAllToUnicode.ConvertFromComposite(preJson.C_Workcode.ToUpper())),
C_Writers = preJson.C_Writers == null ? string.Empty : VnHelper.ConvertToUnSign(ConvertAllToUnicode.ConvertFromComposite(preJson.C_Writers.ToUpper())),
Combined_Claim = preJson.Combined_Claim == null ? "0": VnHelper.ConvertToUnSign(preJson.Combined_Claim),
Mechanical = preJson.Mechanical == null ? "0" : VnHelper.ConvertToUnSign(preJson.Mechanical),
Performance = preJson.Performance == null ? "0" : VnHelper.ConvertToUnSign(preJson.Performance),
//MONTH = month,// preJson.MONTH,
//Year = year
};
//if (preJson.CREATED_AT != null)
//{
preVM.DtCREATED_AT = TimeTicks.ConvertTicksMongoToC(preJson.CREATED_AT);
//}
if (preJson.UPDATED_AT != null)
{
preVM.DtUPDATED_AT = TimeTicks.ConvertTicksMongoToC((long)preJson.UPDATED_AT);
}
objects.Add(preVM);
serial++;
}
return(objects);
}
private void LoadDataFreClaimJsonfile()
{
try
{
currentDataImView = new List <WorkTrackingViewModel>();
dataImport = new List <WorkTrackingViewModel>();
dgvImport.Invoke(new MethodInvoker(delegate
{
dgvImport.DataSource = currentDataImView;
}));
countImportFromFile = 0;
DateTime startTime = DateTime.Now;
totalPageIm = 0;
DirectionNarrowDisable();
#region Read file
string[] files = Directory.GetFiles(path);
int serical = 0;
foreach (var item in files)
{
string[] list_name = item.Split('\\');
string name = "";
if (list_name.Length > 0)
{
name = list_name.Last();
}
string data = JsonHelper.LoadJson(item);
WorkRetrievalViewModel source = JsonHelper.JsonToWorkRetrieval(data);
for (int i = 0; i < source._object.retrevalList.Count; i++)
{
serical++;
WorkTrackingViewModel preVM = new WorkTrackingViewModel();
preVM.SerialNo = serical;
preVM.WK_INT_NO = source._object.retrevalList[i].wkIntNo == null? string.Empty: VnHelper.ConvertToUnSign(ConvertAllToUnicode.ConvertFromComposite(source._object.retrevalList[i].wkIntNo.ToUpper()));
preVM.TTL_ENG = source._object.retrevalList[i].engTitle == null ? string.Empty : VnHelper.ConvertToUnSign(ConvertAllToUnicode.ConvertFromComposite(source._object.retrevalList[i].engTitle.ToUpper()));
preVM.ISWC_NO = source._object.retrevalList[i].iswcNo == null ? string.Empty : VnHelper.ConvertToUnSign(ConvertAllToUnicode.ConvertFromComposite(source._object.retrevalList[i].iswcNo.ToUpper()));
preVM.ISRC = source._object.retrevalList[i].isrcNo == null ? string.Empty : VnHelper.ConvertToUnSign(ConvertAllToUnicode.ConvertFromComposite(source._object.retrevalList[i].isrcNo.ToUpper()));
preVM.WRITER = source._object.retrevalList[i].composer == null ? string.Empty : VnHelper.ConvertToUnSign(ConvertAllToUnicode.ConvertFromComposite(source._object.retrevalList[i].composer.ToUpper()));
for (int j = 0; j < source._object.retrevalList[i].artiste.Length; j++)
{
if (preVM.ARTIST.Length > 0)
{
preVM.ARTIST += ",";
}
preVM.ARTIST += source._object.retrevalList[i].artiste[j];
}
preVM.ARTIST = VnHelper.ConvertToUnSign(ConvertAllToUnicode.ConvertFromComposite(preVM.ARTIST));
// preVM.SOC_NAME = dataxxx2._object.retrevalList[i].wkIntNo;
preVM.Type = type;
preVM.Year = year;
preVM.MONTH = month;
#region bo tac gia tieng viet
//VIET HO HUU VIỆTHỒ HỮU
//NGUYEN THI SONG NGUYEN = NGUYENXETHISONG NGUYỄN
//NGUYEN THI SONG NGUYEN = NGUYENTHISONG NGUYEN
if (preVM.WRITER.Length > 0)
{
//if (preVM.WRITER.Trim() == "VIET HO HUU VIỆTHỒ HỮU")
//{
// int a = 1;
//}
//preVM.WRITER = VnHelper.ConvertToUnSign(preVM.WRITER);
string[] ilistWriter = preVM.WRITER.Trim().Split(',');
string[] arrayIwriter = null;
string s1 = "";
string s2 = "";
bool isCorrect = false;
int pos = 0;
preVM.WRITER = "";
string iWriterSub = "";
foreach (var iWriter in ilistWriter)
{
isCorrect = false;
arrayIwriter = iWriter.Trim().Split(' ');
if (arrayIwriter.Length > 1)
{
string ho = arrayIwriter[arrayIwriter.Length - 1];
pos = iWriter.LastIndexOf(ho);
iWriterSub = iWriter.Substring(0, pos);
pos = iWriterSub.LastIndexOf(ho);
if (pos > 0)
{
s1 = iWriter.Substring(0, pos + ho.Length);
s2 = iWriter.Substring(pos + ho.Length, iWriter.Length - (pos + ho.Length));
if (s1.Replace(" ", "") == s2.Replace(" ", ""))
{
isCorrect = true;
}
}
}
if (isCorrect)
{
preVM.WRITER += $",{s1}";
}
else
{
preVM.WRITER += $",{iWriter}";
}
}
if (preVM.WRITER.Length > 1)
{
preVM.WRITER = preVM.WRITER.Substring(1, preVM.WRITER.Length - 1);
}
}
#endregion
dataImport.Add(preVM);
}
}
#endregion
if (dataImport != null && dataImport.Count > 0)
{
countImportFromFile = dataImport.Count;
if (countImportFromFile % limitIm == 0)
{
totalPageIm = countImportFromFile / limitIm;
}
else
{
totalPageIm = countImportFromFile / limitIm + 1;
}
lbTotalPage.Invoke(new MethodInvoker(delegate
{
lbTotalPage.Text = totalPageIm.ToString();
}));
GotoPage(currentPageIm, totalPageIm);
mainStatus.Invoke(new MethodInvoker(delegate
{
lbInfo.Text = $"Total records load: {countImportFromFile}";
}));
}
else
{
mainStatus.Invoke(new MethodInvoker(delegate
{
lbInfo.Text = "Load data from json file be error!";
}));
}
DateTime endTime = DateTime.Now;
lbInfoImport.Invoke(new MethodInvoker(delegate
{
lbInfoImport.Text = $"Time load(second(s)): {(endTime - startTime).TotalSeconds.ToString("##0.##")}, ";
lbInfoImport.Text += $"total record(s): {countImportFromFile}, total page(s): {totalPageIm}, ";
lbInfoImport.Text += $"total records/page: {limitIm}";
}));
}
catch (Exception)
{
pcloader.Invoke(new MethodInvoker(delegate
{
pcloader.Visible = false;
}));
}
}
private void LoadDtaFromExcel()
{
try
{
dataLoad = new List <ConvertyToUnsign>();
dgvEditFileImport.Invoke(new MethodInvoker(delegate
{
dgvEditFileImport.DataSource = new List <ConvertyToUnsign>();
}));
statusMain.Invoke(new MethodInvoker(delegate
{
lbOperation.Text = "Starting load data...";
}));
#region init
ExcelHelper excelHelper = new ExcelHelper();
#endregion
//du lieu doc file
dataLoad = excelHelper.ReadExcelConvertyToUnsign(tstxtPath.Text);
//var orderByDescendingResult = (from s in ediFilesItems
// //orderby s.seqNo ascending, s.NoOfPerf ascending
// select s).ToList();
#region 1.Loai bo dong trong
if (dataLoad != null)
{
for (int i = 0; i < dataLoad.Count; i++)
{
dataLoad[i].c1 = VnHelper.ConvertToUnSign(ConvertAllToUnicode.ConvertFromComposite(dataLoad[i].c1.Trim().ToUpper()));
dataLoad[i].c2 = VnHelper.ConvertToUnSign(ConvertAllToUnicode.ConvertFromComposite(dataLoad[i].c2.Trim().ToUpper()));
dataLoad[i].c3 = VnHelper.ConvertToUnSign(ConvertAllToUnicode.ConvertFromComposite(dataLoad[i].c3.Trim().ToUpper()));
dataLoad[i].c4 = VnHelper.ConvertToUnSign(ConvertAllToUnicode.ConvertFromComposite(dataLoad[i].c4.Trim().ToUpper()));
dataLoad[i].c5 = VnHelper.ConvertToUnSign(ConvertAllToUnicode.ConvertFromComposite(dataLoad[i].c5.Trim().ToUpper()));
dataLoad[i].c6 = VnHelper.ConvertToUnSign(ConvertAllToUnicode.ConvertFromComposite(dataLoad[i].c6.Trim().ToUpper()));
dataLoad[i].c7 = VnHelper.ConvertToUnSign(ConvertAllToUnicode.ConvertFromComposite(dataLoad[i].c7.Trim().ToUpper()));
dataLoad[i].c8 = VnHelper.ConvertToUnSign(ConvertAllToUnicode.ConvertFromComposite(dataLoad[i].c8.Trim().ToUpper()));
dataLoad[i].c9 = VnHelper.ConvertToUnSign(ConvertAllToUnicode.ConvertFromComposite(dataLoad[i].c9.Trim().ToUpper()));
dataLoad[i].c10 = VnHelper.ConvertToUnSign(ConvertAllToUnicode.ConvertFromComposite(dataLoad[i].c10.Trim().ToUpper()));
}
}
#endregion
#region Hien thi du lieu goc
if (dataLoad != null)
{
dgvEditFileImport.Invoke(new MethodInvoker(delegate
{
dgvEditFileImport.DataSource = dataLoad;
}));
}
else
{
statusMain.Invoke(new MethodInvoker(delegate
{
lbInfo.Text = "Load data from Excel file be error!";
}));
}
#endregion
statusMain.Invoke(new MethodInvoker(delegate
{
lbOperation.Text = "Load data is finish";
}));
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
}
