예제 #1
0
 private void btnFind_Click(object sender, EventArgs e)
 {
     try
     {
         List <ContractObject> fill = new List <ContractObject>();
         if (cboType.SelectedIndex == 0)
         {
             //fill = contractObjects.Where(x => x.Customer.Contains(txtFind.Text.Trim())).ToList();
             var query = contractObjects.Where(delegate(ContractObject c)
             {
                 if (VnHelper.ConvertToUnSign(c.Customer).IndexOf(txtFind.Text.Trim(), StringComparison.CurrentCultureIgnoreCase) >= 0)
                 {
                     return(true);
                 }
                 else
                 {
                     return(false);
                 }
             }).AsQueryable();
             fill = query.ToList();
         }
         else if (cboType.SelectedIndex == 1)
         {
             //fill = contractObjects.Where(x => x.License.Contains(txtFind.Text.Trim())).ToList();
             var query = contractObjects.Where(delegate(ContractObject c)
             {
                 if (VnHelper.ConvertToUnSign(c.License).IndexOf(txtFind.Text.Trim(), StringComparison.CurrentCultureIgnoreCase) >= 0)
                 {
                     return(true);
                 }
                 else
                 {
                     return(false);
                 }
             }).AsQueryable();
             fill = query.ToList();
         }
         else if (cboType.SelectedIndex == 2)
         {
             //fill = contractObjects.Where(x => x.ContractNumber.Contains(txtFind.Text.Trim())).ToList();
             var query = contractObjects.Where(delegate(ContractObject c)
             {
                 if (VnHelper.ConvertToUnSign(c.ContractNumber).IndexOf(txtFind.Text.Trim(), StringComparison.CurrentCultureIgnoreCase) >= 0)
                 {
                     return(true);
                 }
                 else
                 {
                     return(false);
                 }
             }).AsQueryable();
             fill = query.ToList();
         }
         dgvMain.DataSource = fill;
     }
     catch (Exception ex)
     {
         MessageBox.Show("Error: " + ex.ToString());
     }
 }
 private void GetDataFromUI()
 {
     if (currenObject == null)
     {
         MessageBox.Show("Data is null, please check again");
         return;
     }
     if (_updataType == UpdataType.Add)
     {
         currenObjectCreate.WK_INT_NO = VnHelper.ConvertToUnSign(txtWK_INT_NO.Text.Trim().ToUpper());
         currenObjectCreate.TTL_ENG   = VnHelper.ConvertToUnSign(txtTTL_ENG.Text.Trim().ToUpper());
         currenObjectCreate.ISWC_NO   = VnHelper.ConvertToUnSign(txtISWC_NO.Text.Trim().ToUpper());
         currenObjectCreate.ISRC      = VnHelper.ConvertToUnSign(txtISRC.Text.Trim().ToUpper());
         currenObjectCreate.WRITER    = VnHelper.ConvertToUnSign(txtWRITER.Text.Trim().ToUpper());
         currenObjectCreate.ARTIST    = VnHelper.ConvertToUnSign(txtARTIST.Text.Trim().ToUpper());
         currenObjectCreate.SOC_NAME  = VnHelper.ConvertToUnSign(txtSOC_NAME.Text.Trim().ToUpper());
     }
     else
     {
         currenObjectUpdate.Id        = currenObject.Id;
         currenObjectUpdate.WK_INT_NO = VnHelper.ConvertToUnSign(txtWK_INT_NO.Text.Trim().ToUpper());
         currenObjectUpdate.TTL_ENG   = VnHelper.ConvertToUnSign(txtTTL_ENG.Text.Trim().ToUpper());
         currenObjectUpdate.ISWC_NO   = VnHelper.ConvertToUnSign(txtISWC_NO.Text.Trim().ToUpper());
         currenObjectUpdate.ISRC      = VnHelper.ConvertToUnSign(txtISRC.Text.Trim().ToUpper());
         currenObjectUpdate.WRITER    = VnHelper.ConvertToUnSign(txtWRITER.Text.Trim().ToUpper());
         currenObjectUpdate.ARTIST    = VnHelper.ConvertToUnSign(txtARTIST.Text.Trim().ToUpper());
         currenObjectUpdate.SOC_NAME  = VnHelper.ConvertToUnSign(txtSOC_NAME.Text.Trim().ToUpper());
     }
 }
예제 #3
0
        private void btnOk_Click(object sender, EventArgs e)
        {
            inPar = null;
            //int countItem = 0;
            if (inparlist != null && inparlist.Count > 0)
            {
                foreach (var item in inparlist)
                {
                    if (txtIP_INT_NO.Text.Trim() == item.IP_INT_NO)
                    {
                        //countItem++;
                        if (_updataType == UpdataType.Add)
                        {
                            lbInfo.Text = $"IP_INT_NO ({item.IP_INT_NO}) is exist, please input again";
                            return;
                        }
                        else
                        {
                            if (IP_INT_NO_old != txtIP_INT_NO.Text.Trim())
                            {
                                lbInfo.Text = $"IP_INT_NO ({item.IP_INT_NO}) is exist, please input again";
                                return;
                            }
                        }
                    }
                }
            }
            if (txtIP_NAME.Text.Trim() == string.Empty)
            {
                lbInfo.Text = "IP_NAME is empty, please input title";
                return;
            }
            inPar           = new InterestedParty();
            inPar.No        = (maxNo + 1);
            inPar.IP_INT_NO = txtIP_INT_NO.Text.Trim().ToUpper();
            inPar.IP_NAME   = VnHelper.ConvertToUnSign(txtIP_NAME.Text.Trim()).ToUpper();

            inPar.IP_NAMETYPE = cboIP_NAMETYPE.Text.Trim();
            inPar.IP_WK_ROLE  = cboIP_WK_ROLE.Text.Trim();
            //inPar.WK_STATUS = cboWK_STATUS.Text.Trim();

            inPar.PER_OWN_SHR = numPER_OWN_SHR.Value;
            inPar.PER_COL_SHR = numPER_COL_SHR.Value;

            inPar.MEC_OWN_SHR = numMEC_OWN_SHR.Value;
            inPar.MEC_COL_SHR = numMEC_COL_SHR.Value;

            inPar.SP_SHR        = numSP_SHR.Value;
            inPar.TOTAL_MEC_SHR = numTOTAL_MEC_SHR.Value;

            inPar.SYN_OWN_SHR   = numSYN_OWN_SHR.Value;
            inPar.SYN_COL_SHR   = numSYN_COL_SHR.Value;
            inPar.Society       = txtSociety.Text.Trim().ToUpper();
            inPar.IP_NAME_LOCAL = txtIP_NAME_LOCAL.Text.Trim().ToUpper();
            inPar.CountUpdate++;
            inPar.LastUpdateAt = DateTime.Now;
            this.Close();
        }
 private void btnOk_Click(object sender, EventArgs e)
 {
     otherTitle = null;
     if (txtTitle.Text.Trim() == string.Empty)
     {
         lbInfo.Text = "Title is empty, please input title";
         return;
     }
     otherTitle           = new OtherTitle();
     otherTitle.No        = (maxNo + 1);
     otherTitle.Title     = VnHelper.ConvertToUnSign(txtTitle.Text.Trim()).ToUpper();
     otherTitle.TTL_LOCAL = txtTTL_LOCAL.Text.Trim().ToUpper();
     //otherTitle.TitleType = txtTitleType.Text.Trim();
     //otherTitle.Language = txtLanguage.Text.Trim();
     this.Close();
 }
        private void GetDataFromUI()
        {
            if (currenObject == null)
            {
                MessageBox.Show("Data is null, please check again");
                return;
            }
            if (_updataType == UpdataType.Add)
            {
                currenObjectCreate.Asset_ID      = VnHelper.ConvertToUnSign(txtAsset_ID.Text.Trim());
                currenObjectCreate.ISRC          = VnHelper.ConvertToUnSign(txtISRC.Text.Trim().ToUpper());
                currenObjectCreate.Comp_Asset_ID = VnHelper.ConvertToUnSign(txtComp_Asset_ID.Text.Trim().ToUpper());
                currenObjectCreate.C_Title       = VnHelper.ConvertToUnSign(txtC_Title.Text.Trim().ToUpper());
                currenObjectCreate.C_ISWC        = VnHelper.ConvertToUnSign(txtC_ISWC.Text.Trim().ToUpper());
                currenObjectCreate.C_Workcode    = VnHelper.ConvertToUnSign(txtC_Workcode.Text.Trim().ToUpper());
                currenObjectCreate.C_Writers     = VnHelper.ConvertToUnSign(txtC_Writers.Text.Trim().ToUpper());

                currenObjectCreate.Combined_Claim = numCombined_Claim.Text.Trim().ToUpper();
                currenObjectCreate.Mechanical     = numMechanical.Text.Trim().ToUpper();
                currenObjectCreate.Performance    = numPerformance.Text.Trim().ToUpper();

                //currenObjectCreate.MONTH = (int)numMONTH.Value;
                currenObjectCreate.DtCREATED_AT = dtCreate_at.Value;
                currenObjectCreate.DtUPDATED_AT = null;
                //currenObjectCreate.Year = (int)numYear.Value;
            }
            else
            {
                currenObjectUpdate.Id            = currenObject.Id;
                currenObjectUpdate.Asset_ID      = VnHelper.ConvertToUnSign(txtAsset_ID.Text.Trim());
                currenObjectUpdate.ISRC          = VnHelper.ConvertToUnSign(txtISRC.Text.Trim().ToUpper());
                currenObjectUpdate.Comp_Asset_ID = VnHelper.ConvertToUnSign(txtComp_Asset_ID.Text.Trim().ToUpper());
                currenObjectUpdate.C_Title       = VnHelper.ConvertToUnSign(txtC_Title.Text.Trim().ToUpper());
                currenObjectUpdate.C_ISWC        = VnHelper.ConvertToUnSign(txtC_ISWC.Text.Trim().ToUpper());
                currenObjectUpdate.C_Workcode    = VnHelper.ConvertToUnSign(txtC_Workcode.Text.Trim().ToUpper());
                currenObjectUpdate.C_Writers     = VnHelper.ConvertToUnSign(txtC_Writers.Text.Trim().ToUpper());

                currenObjectUpdate.Combined_Claim = numCombined_Claim.Text.Trim().ToUpper();
                currenObjectUpdate.Mechanical     = numMechanical.Text.Trim().ToUpper();
                currenObjectUpdate.Performance    = numPerformance.Text.Trim().ToUpper();

                //currenObjectUpdate.MONTH = (int)numMONTH.Value;
                currenObjectUpdate.DtCREATED_AT = dtCreate_at.Value;
                currenObjectUpdate.DtUPDATED_AT = dtUpdate_at.Value;
                //currenObjectUpdate.Year = (int)numYear.Value;
            }
        }
예제 #6
0
 private void FilterData()
 {
     try
     {
         isFilter = true;
         List <RoleViewModel> fill = new List <RoleViewModel>();
         if (cboTypeChoise == 0)
         {
             var query = data.ResultObj.Items.Where(delegate(RoleViewModel c)
             {
                 if (VnHelper.ConvertToUnSign(c.Name).IndexOf(txtFind.Text.Trim(), StringComparison.CurrentCultureIgnoreCase) >= 0)
                 {
                     return(true);
                 }
                 else
                 {
                     return(false);
                 }
             }).AsQueryable();
             fill = query.ToList();
         }
         dgvMain.Invoke(new MethodInvoker(delegate
         {
             dgvMain.DataSource = fill;
         }));
         statusMain.Invoke(new MethodInvoker(delegate
         {
             lbOperation.Text = $"Filter data, total record(s): {fill.Count}";
         }));
         isFilter = false;
     }
     catch (Exception)
     {
         isFilter = false;
         pcloader.Invoke(new MethodInvoker(delegate
         {
             pcloader.Visible = false;
         }));
     }
 }
        private void GetDataFromUI()
        {
            if (currenObject == null)
            {
                MessageBox.Show("Data is null, please check again");
                return;
            }
            if (_updataType == UpdataType.Add)
            {
                currenObjectCreate.Group    = _group;
                currenObjectCreate.CodeOld  = VnHelper.ConvertToUnSign(txtCodeOld.Text.Trim().ToUpper());
                currenObjectCreate.CodeNew  = VnHelper.ConvertToUnSign(txtCodeNew.Text.Trim().ToUpper());
                currenObjectCreate.Name     = txtName.Text.Trim().ToUpper();
                currenObjectCreate.Name2    = VnHelper.ConvertToUnSign(txtName.Text.Trim().ToUpper());
                currenObjectCreate.Own      = txtOwn.Text.Trim().ToUpper();
                currenObjectCreate.Own2     = VnHelper.ConvertToUnSign(txtOwn.Text.Trim().ToUpper());
                currenObjectCreate.NameType = VnHelper.ConvertToUnSign(txtNameType.Text.Trim().ToUpper());

                currenObjectCreate.NoteMono  = txtNoteMono.Text.Trim().ToUpper();
                currenObjectCreate.Note2     = txtNote2.Text.Trim().ToUpper();
                currenObjectCreate.Note3     = txtNote3.Text.Trim().ToUpper();
                currenObjectCreate.IsExpired = cheIsExpired.Checked;

                currenObjectCreate.StartTime   = dtStartTime.Value;
                currenObjectCreate.EndTime     = dtEndTime.Value;
                currenObjectCreate.UpdateTime  = dtUpdateTime.Value;
                currenObjectCreate.ReceiveTime = dtReceiveTime.Value;

                currenObjectCreate.Tone            = cheTone.Checked;
                currenObjectCreate.Web             = cheWeb.Checked;
                currenObjectCreate.Performances    = chePerformances.Checked;
                currenObjectCreate.PerformancesHCM = chePerformancesHCM.Checked;
                currenObjectCreate.Cddvd           = cheCddvd.Checked;
                currenObjectCreate.Kok             = cheKok.Checked;
                currenObjectCreate.Broadcasting    = cheBroadCasting.Checked;

                currenObjectCreate.Entertaiment = cheEntertaiment.Checked;

                currenObjectCreate.Film          = cheFilm.Checked;
                currenObjectCreate.Advertisement = cheAdvertisement.Checked;
                currenObjectCreate.PubMusicBook  = chePubMusicBook.Checked;
                currenObjectCreate.Youtube       = cheYoutube.Checked;
                currenObjectCreate.Other         = cheOther.Checked;
            }
            else
            {
                currenObjectUpdate.Group    = _group;
                currenObjectUpdate.Id       = currenObject.Id;
                currenObjectUpdate.CodeOld  = VnHelper.ConvertToUnSign(txtCodeOld.Text.Trim().ToUpper());
                currenObjectUpdate.CodeNew  = VnHelper.ConvertToUnSign(txtCodeNew.Text.Trim().ToUpper());
                currenObjectUpdate.Name     = txtName.Text.Trim().ToUpper();
                currenObjectUpdate.Name2    = VnHelper.ConvertToUnSign(txtName.Text.Trim().ToUpper());
                currenObjectUpdate.Own      = txtOwn.Text.Trim().ToUpper();
                currenObjectUpdate.Own2     = VnHelper.ConvertToUnSign(txtOwn.Text.Trim().ToUpper());
                currenObjectUpdate.NameType = VnHelper.ConvertToUnSign(txtNameType.Text.Trim().ToUpper());

                currenObjectUpdate.NoteMono  = txtNoteMono.Text.Trim().ToUpper();
                currenObjectUpdate.Note2     = txtNote2.Text.Trim().ToUpper();
                currenObjectUpdate.Note3     = txtNote3.Text.Trim().ToUpper();
                currenObjectUpdate.IsExpired = cheIsExpired.Checked;

                currenObjectUpdate.StartTime   = dtStartTime.Value;
                currenObjectUpdate.EndTime     = dtEndTime.Value;
                currenObjectUpdate.UpdateTime  = dtUpdateTime.Value;
                currenObjectUpdate.ReceiveTime = dtReceiveTime.Value;

                currenObjectUpdate.Tone            = cheTone.Checked;
                currenObjectUpdate.Web             = cheWeb.Checked;
                currenObjectUpdate.Performances    = chePerformances.Checked;
                currenObjectUpdate.PerformancesHCM = chePerformancesHCM.Checked;
                currenObjectUpdate.Cddvd           = cheCddvd.Checked;
                currenObjectUpdate.Kok             = cheKok.Checked;
                currenObjectUpdate.Broadcasting    = cheBroadCasting.Checked;

                currenObjectUpdate.Entertaiment = cheEntertaiment.Checked;

                currenObjectUpdate.Film          = cheFilm.Checked;
                currenObjectUpdate.Advertisement = cheAdvertisement.Checked;
                currenObjectUpdate.PubMusicBook  = chePubMusicBook.Checked;
                currenObjectUpdate.Youtube       = cheYoutube.Checked;
                currenObjectUpdate.Other         = cheOther.Checked;
            }
        }
        private void GetDataFromUI()
        {
            if (currenObject == null)
            {
                MessageBox.Show("Data is null, please check again");
                return;
            }
            if (_updataType == UpdataType.Add)
            {
                currenObjectCreate.WK_INT_NO = VnHelper.ConvertToUnSign(txtWK_INT_NO.Text.Trim().ToUpper());
                currenObjectCreate.TTL_ENG   = VnHelper.ConvertToUnSign(txtTTL_ENG.Text.Trim().ToUpper());
                currenObjectCreate.TTL_LOCAL = txtTTL_ENG.Text.Trim().ToUpper();
                currenObjectCreate.ISWC_NO   = VnHelper.ConvertToUnSign(txtISWC_NO.Text.Trim().ToUpper());
                currenObjectCreate.ISRC      = txtISRC.Text.Trim();

                currenObjectCreate.WRITER       = string.Empty;
                currenObjectCreate.WRITER_LOCAL = string.Empty;
                //bool isCOMPLETE = true;
                for (int i = 0; i < currenObjectCreate.InterestedParties.Count; i++)
                {
                    if (currenObjectCreate.WRITER != string.Empty)
                    {
                        currenObjectCreate.WRITER += ",";
                    }
                    currenObjectCreate.WRITER += currenObjectCreate.InterestedParties[i].IP_NAME;

                    if (currenObjectCreate.InterestedParties[i].IP_NAME_LOCAL != string.Empty)
                    {
                        if (currenObjectCreate.WRITER_LOCAL != string.Empty)
                        {
                            currenObjectCreate.WRITER_LOCAL += ",";
                        }
                        currenObjectCreate.WRITER_LOCAL += currenObjectCreate.InterestedParties[i].IP_NAME_LOCAL;
                        //TODO 2020-10-02
                        //
                        //if(isCOMPLETE && currenObjectCreate.InterestedParties[i].WK_STATUS != "COMPLETE")
                        //{
                        //    isCOMPLETE = false;
                        //}
                    }
                }
                currenObjectCreate.ARTIST     = VnHelper.ConvertToUnSign(txtARTIST.Text.Trim().ToUpper());
                currenObjectCreate.SOC_NAME   = VnHelper.ConvertToUnSign(txtSOC_NAME.Text.Trim().ToUpper());
                currenObjectCreate.WK_STATUS  = cboWK_STATUS.Text;
                currenObjectCreate.StarRating = (int)numStarRating.Value;
            }
            else
            {
                //bool isCOMPLETE = true;
                currenObjectUpdate.Id        = currenObject.Id;
                currenObjectUpdate.WK_INT_NO = VnHelper.ConvertToUnSign(txtWK_INT_NO.Text.Trim().ToUpper());
                currenObjectUpdate.TTL_ENG   = VnHelper.ConvertToUnSign(txtTTL_ENG.Text.Trim().ToUpper());
                currenObjectUpdate.TTL_LOCAL = txtTTL_LOCAL.Text.Trim().ToUpper();
                currenObjectUpdate.ISWC_NO   = VnHelper.ConvertToUnSign(txtISWC_NO.Text.Trim().ToUpper());
                currenObjectUpdate.ISRC      = VnHelper.ConvertToUnSign(txtISRC.Text.Trim().ToUpper());

                currenObjectUpdate.WRITER       = string.Empty;
                currenObjectUpdate.WRITER_LOCAL = string.Empty;

                for (int i = 0; i < currenObjectUpdate.InterestedParties.Count; i++)
                {
                    if (currenObjectUpdate.WRITER != string.Empty)
                    {
                        currenObjectUpdate.WRITER += ",";
                    }
                    currenObjectUpdate.WRITER += currenObjectUpdate.InterestedParties[i].IP_NAME;

                    if (currenObjectUpdate.InterestedParties[i].IP_NAME_LOCAL != string.Empty)
                    {
                        if (currenObjectUpdate.WRITER_LOCAL != string.Empty)
                        {
                            currenObjectUpdate.WRITER_LOCAL += ",";
                        }
                        currenObjectUpdate.WRITER_LOCAL += currenObjectUpdate.InterestedParties[i].IP_NAME_LOCAL;
                        //TODO 2020-10-02
                        //
                        //if (isCOMPLETE && currenObjectUpdate.InterestedParties[i].WK_STATUS != "COMPLETE")
                        //{
                        //    isCOMPLETE = false;
                        //}
                    }
                }
                currenObjectUpdate.ARTIST     = VnHelper.ConvertToUnSign(txtARTIST.Text.Trim().ToUpper());
                currenObjectUpdate.SOC_NAME   = VnHelper.ConvertToUnSign(txtSOC_NAME.Text.Trim().ToUpper());
                currenObjectUpdate.WK_STATUS  = cboWK_STATUS.Text;
                currenObjectUpdate.StarRating = (int)numStarRating.Value;
            }
        }
        /// <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 FilterData()
 {
     try
     {
         isFilter = true;
         List <MemberWorkList> fill = new List <MemberWorkList>();
         if (cboTypeChoise == 0)
         {
             //var query = ediFilesItemsClone.Where(delegate (WorkViewModel c)
             //{
             //    if (VnHelper.ConvertToUnSign(c.WK_INT_NO).IndexOf(txtFind.Text.Trim(), StringComparison.CurrentCultureIgnoreCase) >= 0)
             //        return true;
             //    else
             //        return false;
             //}).AsQueryable();
             var query = ediFilesItemsClone.Where(c => c.INTERNAL_NO.IndexOf(txtFind.Text.Trim(), StringComparison.CurrentCultureIgnoreCase) >= 0);
             fill = query.ToList();
         }
         else if (cboTypeChoise == 1)
         {
             var query = ediFilesItemsClone.Where(delegate(MemberWorkList c)
             {
                 if (VnHelper.ConvertToUnSign(c.TITLE).IndexOf(txtFind.Text.Trim(), StringComparison.CurrentCultureIgnoreCase) >= 0)
                 {
                     return(true);
                 }
                 else
                 {
                     return(false);
                 }
             }).AsQueryable();
             //var query = ediFilesItemsClone.Where(c => c.GroupWriter.IndexOf(txtFind.Text.Trim(), StringComparison.CurrentCultureIgnoreCase) >= 0);
             fill = query.ToList();
         }
         else if (cboTypeChoise == 2)
         {
             var query = ediFilesItemsClone.Where(delegate(MemberWorkList c)
             {
                 if (VnHelper.ConvertToUnSign(c.NAME).IndexOf(txtFind.Text.Trim(), StringComparison.CurrentCultureIgnoreCase) >= 0)
                 {
                     return(true);
                 }
                 else
                 {
                     return(false);
                 }
             }).AsQueryable();
             //var query = ediFilesItemsClone.Where(c => c.GroupWriter.IndexOf(txtFind.Text.Trim(), StringComparison.CurrentCultureIgnoreCase) >= 0);
             fill = query.ToList();
         }
         dgvEditCalcXXX.Invoke(new MethodInvoker(delegate
         {
             dgvEditCalcXXX.DataSource = fill;
         }));
         statusMain.Invoke(new MethodInvoker(delegate
         {
             lbOperation.Text = $"Filter data, total record(s): {fill.Count}";
         }));
         isFilter = false;
     }
     catch (Exception)
     {
         pcloader.Invoke(new MethodInvoker(delegate
         {
             pcloader.Visible = false;
         }));
         isFilter = false;
     }
 }
        private async void LoadDtaFromExcel()
        {
            try
            {
                #region init
                isLoad = true;
                ExcelHelper excelHelper = new ExcelHelper();
                #endregion

                #region reset
                totalLoad        = 0;
                totalRest        = 0;
                totalRestAffCalc = 0;
                totalDuplicate   = 0;
                lbTotalLoad.Invoke(new MethodInvoker(delegate
                {
                    lbTotalLoad.Text = totalLoad.ToString();
                }));
                lbTotalrest.Invoke(new MethodInvoker(delegate
                {
                    lbTotalrest.Text = totalRest.ToString();
                }));
                lbTotalAftercalc.Invoke(new MethodInvoker(delegate
                {
                    lbTotalAftercalc.Text = totalRestAffCalc.ToString();
                }));
                lbTotalDuplicate.Invoke(new MethodInvoker(delegate
                {
                    lbTotalDuplicate.Text = totalDuplicate.ToString();
                }));
                ediFilesItems      = new List <MemberWorkList>();
                ediFilesItemsClone = new List <MemberWorkList>();
                dgvEditFileImport.Invoke(new MethodInvoker(delegate
                {
                    dgvEditFileImport.DataSource = ediFilesItems;
                }));
                dgvEditCalcXXX.Invoke(new MethodInvoker(delegate
                {
                    dgvEditCalcXXX.DataSource = ediFilesItemsClone;
                }));
                #endregion

                //du lieu doc file
                ediFilesItems = excelHelper.ReadExcelMemberEorkList(tstxtPath.Text);

                #region 1.Loai bo dong trong
                List <MemberWorkList> editFiles = new List <MemberWorkList>();
                if (ediFilesItems != null)
                {
                    ediFilesItemsClone.Clear();
                    string WorkInternalNo = string.Empty;
                    string INTERNAL_NO    = string.Empty;
                    int    pos            = 0;
                    string TITLE2         = string.Empty;
                    string TITLE3         = string.Empty;

                    string   name = string.Empty;
                    string   name3 = string.Empty;
                    string[] arrayname = null;
                    string   text, text2;
                    string[] arrWriterReal;
                    for (int i = 0; i < ediFilesItems.Count; i++)
                    {
                        name      = ediFilesItems[i].NAME;
                        arrayname = name.Split(',');
                        if (arrayname.Length != 2)
                        {
                            continue;
                        }
                        if (arrayname[1].Trim() == string.Empty)
                        {
                            name  = arrayname[0].Trim();
                            name3 = name;
                        }
                        else
                        {
                            if (name == "TRAN THIEN, THANH TRẦN THIỆNTHANH")
                            {
                                int a = 1;
                            }
                            //TRAN THIEN, THANH TRẦN THIỆNTHANH
                            //TRAN THIEN
                            arrayname[0] = arrayname[0].Trim();
                            name         = $"{arrayname[0]} ";
                            //THANH TRẦN THIỆNTHANH
                            arrayname[1] = arrayname[1].Trim();
                            name3        = arrayname[1];
                            //THANH:TRẦN:THIỆNTHANH
                            arrayname    = arrayname[1].Split(' ');
                            arrayname[0] = arrayname[0].Trim();
                            //TRAN THIEN THANH
                            name += arrayname[0];
                            //TRẦN THIỆNTHANH
                            pos = name3.IndexOf(arrayname[0]);
                            if (pos >= 0)
                            {
                                name3 = name3.Substring(pos + arrayname[0].Length, name3.Length - arrayname[0].Length - pos).Trim();
                            }
                            #region nếu là tác giả việt
                            if (name3.Length > 0)
                            {
                                text          = name3.Replace(" ", "");
                                text2         = VnHelper.ConvertToUnSign(text);
                                arrWriterReal = name.Split(' ');
                                name3         = string.Empty;
                                for (int k = 0; k < arrWriterReal.Length; k++)
                                {
                                    pos = text2.IndexOf(arrWriterReal[k]);
                                    if (pos >= 0)
                                    {
                                        int x  = text.Length;
                                        int x1 = text2.Length;
                                        name3 += text.Substring(pos, arrWriterReal[k].Length) + " ";
                                        text   = text.Substring(arrWriterReal[k].Length, text.Length - arrWriterReal[k].Length);
                                        text2  = text2.Substring(arrWriterReal[k].Length, text2.Length - arrWriterReal[k].Length);
                                    }
                                }
                            }
                            #endregion
                        }
                        #region general report: thuong dung
                        if (ediFilesItems[i].INTERNAL_NO != string.Empty)
                        {
                            INTERNAL_NO = ediFilesItems[i].INTERNAL_NO;
                            var x = (MemberWorkList)ediFilesItems[i].Clone();
                            pos    = x.TITLE.Length / 2;
                            TITLE2 = x.TITLE.Substring(0, pos).Trim();
                            TITLE3 = x.TITLE.Substring(pos, x.TITLE.Length - pos).Trim();
                            if (VnHelper.Detect(TITLE3) && TITLE2 == VnHelper.ConvertToUnSign(TITLE3))
                            {
                                x.TITLE2 = TITLE2;
                                x.TITLE3 = TITLE3;
                            }
                            else
                            {
                                x.TITLE2 = x.TITLE;
                                x.TITLE3 = x.TITLE;
                            }
                            x.NAME2 = name;
                            x.NAME3 = name3.Trim();
                            ediFilesItemsClone.Add(x);
                        }
                        else
                        {
                            var x = ediFilesItemsClone.Where(p => p.INTERNAL_NO == INTERNAL_NO).FirstOrDefault();
                            if (x != null)
                            {
                                if (x.NAME_TYPE != string.Empty)
                                {
                                    x.NAME_TYPE += ", ";
                                }
                                x.NAME_TYPE += ediFilesItems[i].NAME_TYPE;

                                if (x.ROLE != string.Empty)
                                {
                                    x.ROLE += ", ";
                                }
                                x.ROLE += ediFilesItems[i].ROLE;

                                if (x.SOCIETY != string.Empty)
                                {
                                    x.SOCIETY += ", ";
                                }
                                x.SOCIETY += ediFilesItems[i].SOCIETY;

                                if (x.NAME2 != string.Empty)
                                {
                                    x.NAME2 += ", ";
                                }
                                x.NAME2 += name;

                                if (x.NAME3 != string.Empty)
                                {
                                    x.NAME3 += ", ";
                                }
                                x.NAME3 += name3.Trim();
                            }
                        }
                        #endregion
                    }
                    totalRest = ediFilesItemsClone.Count;
                    lbTotalrest.Invoke(new MethodInvoker(delegate
                    {
                        lbTotalrest.Text = totalRest.ToString();
                    }));
                }
                else
                {
                    ediFilesItemsClone.Clear();
                }
                #endregion

                #region Hien thi du lieu goc
                //bindingSourceImport.DataSource = ediFilesItems;
                //bindingSourceEdit.DataSource = ediFilesItemsClone;
                if (ediFilesItems != null)
                {
                    totalLoad = ediFilesItems.Count;
                    lbTotalLoad.Invoke(new MethodInvoker(delegate
                    {
                        lbTotalLoad.Text = totalLoad.ToString();
                    }));

                    dgvEditFileImport.Invoke(new MethodInvoker(delegate
                    {
                        dgvEditFileImport.DataSource = ediFilesItems;
                    }));
                    dgvEditCalcXXX.Invoke(new MethodInvoker(delegate
                    {
                        dgvEditCalcXXX.DataSource = ediFilesItemsClone;
                    }));
                    FilterData();
                    totalRestAffCalc = ediFilesItemsClone.Count;
                    totalDuplicate   = totalRest - totalRestAffCalc;

                    lbTotalAftercalc.Invoke(new MethodInvoker(delegate
                    {
                        lbTotalAftercalc.Text = totalRestAffCalc.ToString();
                    }));
                    lbTotalDuplicate.Invoke(new MethodInvoker(delegate
                    {
                        lbTotalDuplicate.Text = totalDuplicate.ToString();
                    }));
                }
                else
                {
                    lbTotalLoad.Text = "0";
                    statusMain.Invoke(new MethodInvoker(delegate
                    {
                        lbInfo.Text = "Load data from Excel file be error!";
                    }));
                }
                #endregion
                isLoad = false;
            }
            catch (Exception ex)
            {
                isLoad = false;
                MessageBox.Show(ex.ToString());
            }
        }
        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());
            }
        }
        private async void SysnData()
        {
            try
            {
                if (dataMaster == null || dataMaster.Items == null || dataMaster.Items.Count == 0)
                {
                    return;
                }
                isSync = true;
                int totalSuccess = 0;
                int total        = 0;
                for (int i = 0; i < dataMaster.Items.Count; i++)
                {
                    total += dataMaster.Items[i].Items.Count();
                }
                if (total == 0)
                {
                    statusMain.Invoke(new MethodInvoker(delegate
                    {
                        lbInfo.Text      = $"Proccessing sync is finish";
                        lbOperation.Text = "Data is empty, so not sync to work";
                    }));
                    isSync = false;
                    return;
                }
                statusMain.Invoke(new MethodInvoker(delegate
                {
                    lbOperation.Text = "Sync...";
                }));
                DateTime TheFiestTime = DateTime.Now;
                statusMain.Invoke(new MethodInvoker(delegate
                {
                    progressBarImport.Value = 0;
                    lbPercent.Text          = "0%";
                }));

                statusMain.Invoke(new MethodInvoker(delegate
                {
                    lbInfo.Text = $"Proccessing sync...";
                }));
                btnSysToWork.Invoke(new MethodInvoker(delegate
                {
                    btnSysToWork.Enabled = false;
                }));
                btnMatch.Invoke(new MethodInvoker(delegate
                {
                    btnMatch.Enabled = false;
                }));
                btnLoadMasterList.Invoke(new MethodInvoker(delegate
                {
                    btnLoadMasterList.Enabled = false;
                }));
                //btnLoadDetails.Invoke(new MethodInvoker(delegate
                //{
                //    btnLoadDetails.Enabled = false;
                //}));
                btnExportExcel.Invoke(new MethodInvoker(delegate
                {
                    btnExportExcel.Enabled = false;
                }));

                DateTime startTime = DateTime.Now;


                for (int i = 0; i < dataMaster.Items.Count; i++)
                {
                    WorkChangeListRequest request = new WorkChangeListRequest();
                    string codeWriter             = VnHelper.ConvertToUnSign(dataMaster.Items[i].IntNo.ToUpper());
                    string nameWriter             = VnHelper.ConvertToUnSign(dataMaster.Items[i].Member.ToUpper());
                    foreach (var item in dataMaster.Items[i].Items)
                    {
                        if (!request.Items.Where(p => p.WK_INT_NO == item.WorkIntNo.ToUpper()).Any())
                        {
                            WorkCreateRequest itmUpdate = new WorkCreateRequest();
                            itmUpdate.WK_INT_NO = VnHelper.ConvertToUnSign(item.WorkIntNo.ToUpper());
                            itmUpdate.TTL_ENG   = VnHelper.ConvertToUnSign(item.Title.Trim().ToUpper());
                            //vi other title giong voi title nen khong can them
                            //itmUpdate.OtherTitles.Add(new Shared.Mis.Works.OtherTitle
                            //{
                            //    No = 1,
                            //    Title = itmUpdate.TTL_ENG
                            //}) ;
                            itmUpdate.InterestedParties.Add(new Shared.Mis.Works.InterestedParty
                            {
                                No         = 1,
                                IP_INT_NO  = codeWriter,
                                IP_NAME    = nameWriter,
                                IP_WK_ROLE = item.Role,
                                //TODO 2020-10-02
                                //WK_STATUS = "COMPLETE",

                                PER_OWN_SHR = item.Share,
                                PER_COL_SHR = item.Share,

                                MEC_OWN_SHR = item.Share,
                                MEC_COL_SHR = item.Share,

                                SP_SHR        = item.Share,
                                TOTAL_MEC_SHR = item.Share,

                                SYN_OWN_SHR   = item.Share,
                                SYN_COL_SHR   = item.Share,
                                Society       = "",//rong se khong cap nhat
                                CountUpdate   = 1,
                                LastUpdateAt  = DateTime.Now,
                                LastChoiseAt  = DateTime.Now,
                                IP_NUMBER     = dataMaster.Items[i].IPINameNo,
                                IP_NAME_LOCAL = "", //rong se khong cap nhat
                                IP_NAMETYPE   = "", //rong se khong cap nhat
                            });
                            itmUpdate.WRITER    = nameWriter;
                            itmUpdate.ARTIST    = string.Empty;
                            itmUpdate.SOC_NAME  = string.Empty;
                            itmUpdate.WK_STATUS = "COMPLETE";
                            request.Items.Add(itmUpdate);
                        }
                    }
                    //request.Items
                    var data = await controller.ChangeList(request);

                    statusMain.Invoke(new MethodInvoker(delegate
                    {
                        float values            = (float)(i + 1) / (float)dataMaster.Items.Count * 100;
                        progressBarImport.Value = (int)values;
                        lbPercent.Text          = $"{((int)values).ToString()}%";
                    }));
                    totalSuccess += data.Items.Where(p => p.Status == Utilities.Common.UpdateStatus.Successfull).ToList().Count;
                    statusMain.Invoke(new MethodInvoker(delegate
                    {
                        lbOperation.Text = $"Sync..., total sync success/total: {totalSuccess}/{total}";
                    }));
                }
                #region update Ui when finish
                btnSysToWork.Invoke(new MethodInvoker(delegate
                {
                    btnSysToWork.Enabled = true;
                }));
                btnMatch.Invoke(new MethodInvoker(delegate
                {
                    btnMatch.Enabled = true;
                }));
                btnLoadMasterList.Invoke(new MethodInvoker(delegate
                {
                    btnLoadMasterList.Enabled = true;
                }));
                //btnLoadDetails.Invoke(new MethodInvoker(delegate
                //{
                //    btnLoadDetails.Enabled = true;
                //}));

                btnExportExcel.Invoke(new MethodInvoker(delegate
                {
                    btnExportExcel.Enabled = true;
                }));
                statusMain.Invoke(new MethodInvoker(delegate
                {
                    lbInfo.Text  = $"sync tracking work to work be finish, total time {(DateTime.Now - TheFiestTime).TotalSeconds}(s)";
                    lbInfo.Text += $", total sync success/total: {totalSuccess}/{total}";
                }));

                statusMain.Invoke(new MethodInvoker(delegate
                {
                    lbOperation.Text = "Sync is finish";
                }));
                #endregion
                isSync = false;
            }
            catch (Exception)
            {
                isSync = false;
                if (btnMatch != null && !btnMatch.IsDisposed)
                {
                    btnMatch.Invoke(new MethodInvoker(delegate
                    {
                        btnMatch.Enabled = true;
                    }));
                }
                if (btnLoadMasterList != null && !btnLoadMasterList.IsDisposed)
                {
                    btnLoadMasterList.Invoke(new MethodInvoker(delegate
                    {
                        btnLoadMasterList.Enabled = true;
                    }));
                }
                //if (btnLoadDetails != null && !btnLoadDetails.IsDisposed)
                //{
                //    btnLoadDetails.Invoke(new MethodInvoker(delegate
                //    {
                //        btnLoadDetails.Enabled = true;
                //    }));
                //}
                if (btnExportExcel != null && !btnExportExcel.IsDisposed)
                {
                    btnExportExcel.Invoke(new MethodInvoker(delegate
                    {
                        btnExportExcel.Enabled = true;
                    }));
                }
                if (btnSysToWork != null && !btnSysToWork.IsDisposed)
                {
                    btnSysToWork.Invoke(new MethodInvoker(delegate
                    {
                        btnSysToWork.Enabled = true;
                    }));
                }
                if (lbOperation != null && !lbInfo.IsDisposed)
                {
                    statusMain.Invoke(new MethodInvoker(delegate
                    {
                        lbOperation.Text = $"Sync tracking work to work be failure";
                    }));
                }
            }
        }
        private async void SysnData()
        {
            try
            {
                if (dataLoad == null || dataLoad.Count == 0)
                {
                    return;
                }
                int totalSuccess = 0;
                int total        = dataLoad.Count;

                if (total == 0)
                {
                    statusMain.Invoke(new MethodInvoker(delegate
                    {
                        lbInfo.Text      = $"Proccessing sync is finish";
                        lbOperation.Text = "Data is empty, so not sync to work";
                    }));
                    return;
                }
                statusMain.Invoke(new MethodInvoker(delegate
                {
                    lbOperation.Text = "Sync...";
                }));
                DateTime TheFiestTime = DateTime.Now;
                statusMain.Invoke(new MethodInvoker(delegate
                {
                    progressBarImport.Value = 0;
                    lbPercent.Text          = "0%";
                }));

                statusMain.Invoke(new MethodInvoker(delegate
                {
                    lbInfo.Text = $"Proccessing sync...";
                }));
                btnSysToWork.Invoke(new MethodInvoker(delegate
                {
                    btnSysToWork.Enabled = false;
                }));
                statusMain.Invoke(new MethodInvoker(delegate
                {
                    btnLoad.Enabled = false;
                }));

                DateTime startTime = DateTime.Now;

                WorkChangeListRequest request = new WorkChangeListRequest();
                string   status;
                string[] writer;
                string[] writer1;
                string[] writer2;
                for (int i = 0; i < dataLoad.Count; i++)
                {
                    if (reportType == 2)
                    {
                        #region Add
                        if (!request.Items.Where(p => p.WK_INT_NO == dataLoad[i].WK_INT_NO.ToUpper()).Any())
                        {
                            WorkCreateRequest itmUpdate = new WorkCreateRequest();
                            itmUpdate.WK_INT_NO = VnHelper.ConvertToUnSign(dataLoad[i].WK_INT_NO.ToUpper());
                            itmUpdate.TTL_ENG   = VnHelper.ConvertToUnSign(dataLoad[i].TTL_ENG.Trim().ToUpper());
                            itmUpdate.TTL_LOCAL = dataLoad[i].TTL_LOCAL.Trim().ToUpper();
                            itmUpdate.WK_STATUS = dataLoad[i].STATUS;
                            #region Tac gia
                            itmUpdate.InterestedParties.Add(new Shared.Mis.Works.InterestedParty
                            {
                                No         = itmUpdate.InterestedParties.Count + 1,
                                IP_INT_NO  = dataLoad[i].InternalNo,
                                IP_NAME    = dataLoad[i].WRITER,
                                IP_WK_ROLE = dataLoad[i].WK_ROLE,

                                PER_OWN_SHR = dataLoad[i].PER_OWN_SHR,
                                PER_COL_SHR = dataLoad[i].PER_OWN_SHR,

                                MEC_OWN_SHR = dataLoad[i].MEC_COL_SHR,
                                MEC_COL_SHR = dataLoad[i].MEC_COL_SHR,

                                SP_SHR        = dataLoad[i].PER_OWN_SHR,
                                TOTAL_MEC_SHR = dataLoad[i].MEC_COL_SHR,

                                SYN_OWN_SHR   = 0,
                                SYN_COL_SHR   = 0,
                                Society       = dataLoad[i].Society,
                                CountUpdate   = 1,
                                LastUpdateAt  = DateTime.Now,
                                LastChoiseAt  = DateTime.Now,
                                IP_NUMBER     = dataLoad[i].IpNumber,
                                IP_NAME_LOCAL = dataLoad[i].WRITER_LOCAL,
                                IP_NAMETYPE   = dataLoad[i].IP_NAME_TYPE,
                            });
                            #endregion
                            itmUpdate.WRITER       = dataLoad[i].WRITER;
                            itmUpdate.WRITER_LOCAL = dataLoad[i].WRITER_LOCAL;
                            itmUpdate.ARTIST       = dataLoad[i].ARTIST;
                            itmUpdate.SOC_NAME     = dataLoad[i].SOC_NAME;
                            itmUpdate.ISWC_NO      = dataLoad[i].ISWC_NO;
                            itmUpdate.ISRC         = dataLoad[i].ISRC;
                            request.Items.Add(itmUpdate);
                        }
                        else
                        {
                            var item = request.Items.Where(p => p.WK_INT_NO == dataLoad[i].WK_INT_NO).FirstOrDefault();
                            if (item != null)
                            {
                                #region tac gia
                                if (!item.InterestedParties.Where(p => p.IP_INT_NO == dataLoad[i].WK_INT_NO).Any())
                                {
                                    item.InterestedParties.Add(new Shared.Mis.Works.InterestedParty
                                    {
                                        No         = item.InterestedParties.Count + 1,
                                        IP_INT_NO  = dataLoad[i].InternalNo,
                                        IP_NAME    = dataLoad[i].WRITER,
                                        IP_WK_ROLE = dataLoad[i].WK_ROLE,

                                        //TODO 2020-10-02
                                        //WK_STATUS = dataLoad[i].STATUS,

                                        PER_OWN_SHR = dataLoad[i].PER_OWN_SHR,
                                        PER_COL_SHR = dataLoad[i].PER_OWN_SHR,

                                        MEC_OWN_SHR = dataLoad[i].MEC_COL_SHR,
                                        MEC_COL_SHR = dataLoad[i].MEC_COL_SHR,

                                        SP_SHR        = dataLoad[i].PER_OWN_SHR,
                                        TOTAL_MEC_SHR = dataLoad[i].MEC_COL_SHR,

                                        SYN_OWN_SHR   = 0,
                                        SYN_COL_SHR   = 0,
                                        Society       = dataLoad[i].Society,
                                        CountUpdate   = 1,
                                        LastUpdateAt  = DateTime.Now,
                                        LastChoiseAt  = DateTime.Now,
                                        IP_NUMBER     = dataLoad[i].IpNumber,
                                        IP_NAME_LOCAL = dataLoad[i].WRITER_LOCAL,
                                        IP_NAMETYPE   = dataLoad[i].IP_NAME_TYPE,
                                    });

                                    if (item.WRITER != string.Empty)
                                    {
                                        item.WRITER += ",";
                                    }
                                    item.WRITER += dataLoad[i].WRITER;
                                    if (item.WRITER_LOCAL != string.Empty)
                                    {
                                        item.WRITER_LOCAL += ",";
                                    }
                                    item.WRITER_LOCAL += dataLoad[i].WRITER_LOCAL;
                                }
                                else
                                {
                                    //int a = 1;
                                }
                                #endregion

                                #region Other title
                                if ((item.TTL_ENG != dataLoad[i].TTL_ENG) && (!item.OtherTitles.Where(p => p.Title == dataLoad[i].TTL_ENG).Any()))
                                {
                                    item.OtherTitles.Add(new Shared.Mis.Works.OtherTitle
                                    {
                                        No        = item.OtherTitles.Count + 1,
                                        Title     = dataLoad[i].TTL_ENG,
                                        TTL_LOCAL = dataLoad[i].TTL_LOCAL,
                                    });
                                }
                                else
                                {
                                    //int a = 1;
                                }
                                #endregion
                            }
                        }
                        #endregion
                    }
                    else
                    {
                        #region Add
                        if (!request.Items.Where(p => p.WK_INT_NO == dataLoad[i].WK_INT_NO.ToUpper()).Any())
                        {
                            WorkCreateRequest itmUpdate = new WorkCreateRequest();
                            itmUpdate.WK_INT_NO = VnHelper.ConvertToUnSign(dataLoad[i].WK_INT_NO.ToUpper());
                            itmUpdate.TTL_ENG   = VnHelper.ConvertToUnSign(dataLoad[i].TTL_ENG.Trim().ToUpper());
                            itmUpdate.TTL_LOCAL = dataLoad[i].TTL_LOCAL.Trim().ToUpper();
                            itmUpdate.WK_STATUS = dataLoad[i].STATUS;
                            if (dataLoad[i].WK_INT_NO == "17615461")
                            {
                                //int a = 1;
                            }
                            //HUNSAKER JASON BRADLEY,MARCKS WILLIAM DANIEL,WILCOX JAMES STEVEN,WOOD JEREMY M
                            writer = dataLoad[i].WRITER.Split(',');
                            //nhac
                            writer1 = dataLoad[i].WRITER2.Split(',');
                            //loi
                            writer2 = dataLoad[i].WRITER3.Split(',');

                            string role = string.Empty;
                            for (int k = 0; k < writer.Length; k++)
                            {
                                #region role
                                if (dataLoad[i].WRITER2.Length > 0 || dataLoad[i].WRITER3.Length > 0)
                                {
                                    //loi trong=> CA
                                    if (dataLoad[i].WRITER3.Length == 0)
                                    {
                                        role = "CA";
                                    }
                                    //nam trong loi
                                    else if (writer2.Contains(writer[k].Trim()))
                                    {
                                        role = "A";
                                    }
                                    else
                                    {
                                        //nhac
                                        role = "C";
                                    }
                                }
                                #endregion

                                #region Tac gia
                                if (writer[k] != string.Empty)
                                {
                                    itmUpdate.InterestedParties.Add(new Shared.Mis.Works.InterestedParty
                                    {
                                        No = itmUpdate.InterestedParties.Count + 1,
                                        //CHo nay neu danh sach co ma thi phai xu ly khac
                                        IP_INT_NO  = dataLoad[i].InternalNo,
                                        IP_NAME    = writer[k].Trim(),
                                        IP_WK_ROLE = role,

                                        PER_OWN_SHR = 0,
                                        PER_COL_SHR = 0,

                                        MEC_OWN_SHR = 0,
                                        MEC_COL_SHR = 0,

                                        SP_SHR        = 0,
                                        TOTAL_MEC_SHR = 0,

                                        SYN_OWN_SHR   = 0,
                                        SYN_COL_SHR   = 0,
                                        Society       = dataLoad[i].Society,
                                        CountUpdate   = 1,
                                        LastUpdateAt  = DateTime.Now,
                                        LastChoiseAt  = DateTime.Now,
                                        IP_NUMBER     = dataLoad[i].IpNumber,
                                        IP_NAME_LOCAL = dataLoad[i].WRITER_LOCAL,
                                        IP_NAMETYPE   = dataLoad[i].IP_NAME_TYPE,
                                    });
                                }
                                #endregion
                            }
                            itmUpdate.WRITER       = dataLoad[i].WRITER;
                            itmUpdate.WRITER_LOCAL = dataLoad[i].WRITER_LOCAL;
                            itmUpdate.ARTIST       = dataLoad[i].ARTIST;
                            itmUpdate.SOC_NAME     = dataLoad[i].SOC_NAME;
                            itmUpdate.ISWC_NO      = dataLoad[i].ISWC_NO;
                            itmUpdate.ISRC         = dataLoad[i].ISRC;
                            request.Items.Add(itmUpdate);
                        }
                        else
                        {
                            int a    = 1;
                            var item = request.Items.Where(p => p.WK_INT_NO == dataLoad[i].WK_INT_NO).FirstOrDefault();
                            writer = dataLoad[i].WRITER.Split(',');
                            //nhac
                            writer1 = dataLoad[i].WRITER2.Split(',');
                            //loi
                            writer2 = dataLoad[i].WRITER3.Split(',');

                            string role = string.Empty;
                            for (int k = 0; k < writer.Length; k++)
                            {
                                #region role
                                if (dataLoad[i].WRITER2.Length > 0 || dataLoad[i].WRITER3.Length > 0)
                                {
                                    //loi trong=> CA
                                    if (dataLoad[i].WRITER3.Length == 0)
                                    {
                                        role = "CA";
                                    }
                                    //nam trong loi
                                    else if (writer2.Contains(writer[k].Trim()))
                                    {
                                        role = "A";
                                    }
                                    else
                                    {
                                        //nhac
                                        role = "C";
                                    }
                                }
                                #endregion

                                if (item != null)
                                {
                                    #region tac gia
                                    if (!item.InterestedParties.Where(p => p.IP_INT_NO == dataLoad[i].WK_INT_NO).Any())
                                    {
                                        item.InterestedParties.Add(new Shared.Mis.Works.InterestedParty
                                        {
                                            No = item.InterestedParties.Count + 1,
                                            //cho nay co ma thi phai xu ly khac
                                            IP_INT_NO  = dataLoad[i].InternalNo,
                                            IP_NAME    = writer[k].Trim(),
                                            IP_WK_ROLE = dataLoad[i].WK_ROLE,

                                            //TODO 2020-10-02
                                            //WK_STATUS = dataLoad[i].STATUS,

                                            PER_OWN_SHR = dataLoad[i].PER_OWN_SHR,
                                            PER_COL_SHR = dataLoad[i].PER_OWN_SHR,

                                            MEC_OWN_SHR = dataLoad[i].MEC_COL_SHR,
                                            MEC_COL_SHR = dataLoad[i].MEC_COL_SHR,

                                            SP_SHR        = dataLoad[i].PER_OWN_SHR,
                                            TOTAL_MEC_SHR = dataLoad[i].MEC_COL_SHR,

                                            SYN_OWN_SHR = 0,
                                            SYN_COL_SHR = 0,
                                            //cho nay co ma, chac chan socity se khac
                                            Society       = dataLoad[i].Society,
                                            CountUpdate   = 1,
                                            LastUpdateAt  = DateTime.Now,
                                            LastChoiseAt  = DateTime.Now,
                                            IP_NUMBER     = dataLoad[i].IpNumber,
                                            IP_NAME_LOCAL = dataLoad[i].WRITER_LOCAL,
                                            IP_NAMETYPE   = dataLoad[i].IP_NAME_TYPE,
                                        });

                                        if (item.WRITER != string.Empty)
                                        {
                                            item.WRITER += ",";
                                        }
                                        item.WRITER += dataLoad[i].WRITER;
                                        if (item.WRITER_LOCAL != string.Empty)
                                        {
                                            item.WRITER_LOCAL += ",";
                                        }
                                        item.WRITER_LOCAL += dataLoad[i].WRITER_LOCAL;
                                    }
                                    else
                                    {
                                        //int a = 1;
                                    }
                                    #endregion

                                    #region Other title
                                    if ((item.TTL_ENG != dataLoad[i].TTL_ENG) && (!item.OtherTitles.Where(p => p.Title == dataLoad[i].TTL_ENG).Any()))
                                    {
                                        item.OtherTitles.Add(new Shared.Mis.Works.OtherTitle
                                        {
                                            No        = item.OtherTitles.Count + 1,
                                            Title     = dataLoad[i].TTL_ENG,
                                            TTL_LOCAL = dataLoad[i].TTL_LOCAL,
                                        });
                                    }
                                    else
                                    {
                                        //int a = 1;
                                    }
                                    #endregion
                                }
                            }
                        }
                        #endregion
                    }

                    #region Update
                    if (request.Items.Count >= Core.LimitRequestUpdate || i == dataLoad.Count - 1)
                    {
                        UpdateStatusViewModelList reponse = null;
                        //request.Items
                        reponse = await controller.ChangeList(request);

                        if (reponse == null)
                        {
                            reponse = new UpdateStatusViewModelList
                            {
                                Items = new List <UpdateStatusViewModel>()
                            };
                        }
                        request.Items.Clear();
                        #region UI
                        statusMain.Invoke(new MethodInvoker(delegate
                        {
                            float values            = (float)(i + 1) / (float)dataLoad.Count * 100;
                            progressBarImport.Value = (int)values;
                            lbPercent.Text          = $"{((int)values).ToString()}%";
                        }));
                        totalSuccess += reponse.Items.Where(p => p.Status == Utilities.Common.UpdateStatus.Successfull).ToList().Count;
                        statusMain.Invoke(new MethodInvoker(delegate
                        {
                            lbOperation.Text = $"Sync..., total sync success/total: {totalSuccess}/{total}";
                        }));
                        #endregion
                    }
                    #endregion
                }
                #region update Ui when finish

                if (request.Items.Count > 0)
                {
                    //int a = 1;
                }
                btnSysToWork.Invoke(new MethodInvoker(delegate
                {
                    btnSysToWork.Enabled = true;
                }));
                statusMain.Invoke(new MethodInvoker(delegate
                {
                    btnLoad.Enabled = true;
                }));
                statusMain.Invoke(new MethodInvoker(delegate
                {
                    lbInfo.Text  = $"sync tracking work to work be finish, total time {(DateTime.Now - TheFiestTime).TotalSeconds}(s)";
                    lbInfo.Text += $", total sync success/total: {totalSuccess}/{total}";
                }));

                statusMain.Invoke(new MethodInvoker(delegate
                {
                    lbOperation.Text = "Sync is finish";
                }));
                #endregion
            }
            catch (Exception)
            {
                if (statusMain != null && !statusMain.IsDisposed)
                {
                    statusMain.Invoke(new MethodInvoker(delegate
                    {
                        btnLoad.Enabled = true;
                    }));
                }
                if (btnSysToWork != null && !btnSysToWork.IsDisposed)
                {
                    btnSysToWork.Invoke(new MethodInvoker(delegate
                    {
                        btnSysToWork.Enabled = true;
                    }));
                }
                if (lbOperation != null && !lbInfo.IsDisposed)
                {
                    statusMain.Invoke(new MethodInvoker(delegate
                    {
                        lbOperation.Text = $"Sync tracking work to work be failure";
                    }));
                }
            }
        }