private void LoadProductDatabaseButton_Click(object sender, EventArgs e) { Wait.Show("Load all product in database!"); try { DBWebPartnerTableAdapters.ProductTableAdapter productAdapter = new DBWebPartnerTableAdapters.ProductTableAdapter(); productAdapter.Connection.ConnectionString = Server.ConnectionString; long idwss = Common.Obj2Int64(companyIdWSSSpinEdit.Text); productAdapter.FillBy_CompanyId(dBWebPartner.Product, idwss); } catch (Exception) { //MessageBox.Show("Lỗi!"); } Wait.Close(); }
private void toolTaiLai_Click(object sender, EventArgs e) { Wait.Show("Đang tải dữ liệu!"); try { this.productTableAdapter.FillBy_AllProductID(this.dBPMan.Product); this.gridView1.ExpandAllGroups(); this.xtraTabControl1.SelectedTabPageIndex = 1; LogJobAdapter.SaveLog(JobName.FrmManagerProduct_Load_All, "Click nút Load All nên ko có ID...", 0, (int)JobTypeData.KhongXacDinh); } catch (Exception) { throw; } Wait.Close(); }
private void simpleButtonViewLog_Click(object sender, EventArgs e) { Wait.Show("Đang tải dữ liệu..."); long iddata = Common.Obj2Int64(textEditIDData.Text); if (iddata != 0) { LoadData(iddata); } else { MessageBox.Show("ID = 0......."); textEditIDData.Focus(); } Wait.Close(); }
private void LoadAllSPGocButton_Click(object sender, EventArgs e) { Wait.Show("Đang tải dữ liệu!"); try { //this.productTableAdapter.FillBy_CategoryID(this.dBPMan.Product, Common.Obj2Int(this.iDCategoryTextBox.Text.Trim())); this.dBPMan.Product.Rows.Clear(); this.productTableAdapter.FillBy_SPGoc_TrungTen(this.dBPMan.Product); this.gridView1.ExpandAllGroups(); this.xtraTabControl1.SelectedTabPageIndex = 1; } catch (Exception) { } Wait.Close(); }
private void simpleButtonLoadProductInSql_Click(object sender, EventArgs e) { Wait.Show("Load all product in database!"); try { DBBizwebTableAdapters.ProductTableAdapter productAdapter = new DBBizwebTableAdapters.ProductTableAdapter(); productAdapter.Connection.ConnectionString = Server.ConnectionString; long idwss = Common.Obj2Int64(companyIdWSSTextEdit.Text); productAdapter.FillBy_CompanyId(dBBizweb.Product, idwss); } catch (Exception) { MessageBox.Show("ERROR! Load Product from Database fails!"); } Wait.Close(); }
private void btnUnActiveAll_Click(object sender, EventArgs e) { Wait.Show("..."); try { foreach (var item in dBIndi.RootProducts) { item.IsActive = false; } this.rootProductsBindingSource.EndEdit(); } catch (Exception exception) { MessageBox.Show(exception.Message); } Wait.Close(); }
private void btnGetProductImage_Click(object sender, EventArgs e) { Wait.Show("Get product from SQL..."); string querry = @"SELECT ID,Name, DetailUrl,ImageUrls,ImageId,LastUpdate,Valid,Status FROM Product WHERE (Company = 6619858476258121218) AND (Valid = 1) AND (ImageId IS NULL OR ImageId = '') OR (Company = 6619858476258121218) AND (Valid = 0) AND (Status = 11)"; SqlDb sqldb = new SqlDb(Server.ConnectionString); DataTable productTable = new DataTable(); try { productTable = sqldb.GetTblData(querry, CommandType.Text, null); } catch (Exception ex) { MessageBox.Show("ERROR " + ex.Message); } grdProductImage.DataSource = productTable; Wait.Close(); }
private void TestProductButton_Click(object sender, EventArgs e) { Wait.Show("Đang tải sản phẩm từ Haravan"); long idcompany = Common.Obj2Int64(companyIdWSSSpinEdit.Text); QT.Entities.Company company = new QT.Entities.Company(idcompany); if (company.Name.ToLower() == "not in database") { MessageBox.Show("Không tồn tại công ty này trong database! Ấn Check Company để kiểm tra"); } else { string shopname = shopNameTextEdit.Text; string accesstoken = accessTokenTextEdit.Text; gridControlProduct.DataSource = GetProductFromHaravan(shopname, accesstoken, company); } Wait.Close(); }
private void simpleButtonTestProduct_Click(object sender, EventArgs e) { Wait.Show("Đang tải dữ liệu..."); long idcompany = Common.Obj2Int64(companyIdWSSTextEdit.Text); QT.Entities.Company company = new QT.Entities.Company(idcompany); if (company.Name.ToLower() == "not in database") { MessageBox.Show("ERROR! Không tồn tại công ty này trong database!"); } else { string shopname = shopNameTextEdit.Text; string accesstoken = accessTokenTextEdit.Text; gridControlProduct.DataSource = GetProductFromBizweb(shopname, accesstoken, company); } Wait.Close(); }
private void btnUpdatePromotionListProduct_Click(object sender, EventArgs e) { Wait.Show("Cập nhật Promotion!"); var listProductId = GetListIdProductSelectedInGrid(); if (listProductId.Count > 0) { for (int i = 0; i < listProductId.Count; i++) { productTableAdapter.UpdatePromotion(rbPromotionListProduct.Text, listProductId[i]); SendMessageUpdateProductSolrAndRedisService(listProductId[i]); Wait.Show(string.Format("{0}/{1} Updated productId = {2}", i + 1, listProductId.Count, listProductId[i])); } } else { MessageBox.Show("Chưa chọn sản phẩm để cập nhật Promotion"); } Wait.Close(); }
private void searchLookUpEditUser_EditValueChanged(object sender, EventArgs e) { Wait.Show("Đang tải dữ liệu..."); if (searchLookUpEditUser.EditValue != null) { DateTime fromDate = ctrDateRanger1.FromDate; DateTime toDate = ctrDateRanger1.ToDate; int iduser = 0; int.TryParse(searchLookUpEditUser.EditValue.ToString(), out iduser); if (iduser != 0) { iDTextEdit.Text = iduser.ToString(); string expression; expression = "ID = " + iduser; var x = dBLogJob.tblUser.Select(expression).FirstOrDefault(); departmentTextEdit.Text = x["Department"].ToString(); //LoadLogUser(iduser, fromDate, toDate); } } Wait.Close(); }
private void barLoadT_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) { Wait.CreateWaitDialog(); try { this.dB.Company.Rows.Clear(); Wait.Show("Đang tải dữ liệu"); this.companyTableAdapter1.FillBy_KyTu(this.dBCom.Company); foreach (Company.DBCom.CompanyRow dr in this.dBCom.Company) { dr.Check = true; } companyBindingSource.EndEdit(); Wait.Close(); } catch (Exception ex) { MessageBox.Show("Errorr: " + ex.ToString()); } Wait.Close(); }
private void ViewDetailProductWithCategoryToolStripMenuItem_Click(object sender, EventArgs e) { Wait.Show("Loading..."); _listSolrProductItemsTemp.Clear(); var listkeywords = txtKeyword.Text.Split(new string[] { "\n" }, StringSplitOptions.RemoveEmptyEntries).ToList(); var listKeywordsBlock = rbKeywordBlock.Text.Replace('\n', ',').Trim().Split(new char[] { ',' }, StringSplitOptions.RemoveEmptyEntries).ToList(); var listIdBlock = rbListIdBlock.Text.Replace('\n', ',').Trim().Split(new char[] { ',' }, StringSplitOptions.RemoveEmptyEntries).ToList(); long minPrice = Common.Obj2Int64(spinEditMinPrice.Value); long maxPrice = Common.Obj2Int64(spinEditMaxPrice.Value); int categoryId = Common.Obj2Int(txtCategoryId.Text); int numberFound; _listSolrProductItemsTemp = solrProductClient.GetProductByProductIdentityRequestAndCategory(listkeywords, listKeywordsBlock, listIdBlock, categoryId, minPrice, maxPrice, 0, Common.Obj2Int(txtNumberFound.Text), out numberFound); foreach (var product in _listSolrProductItemsTemp) { product.WebsiteId = _websiteId; } grdProduct.DataSource = _listSolrProductItemsTemp; Wait.Close(); }
private void btnLoadErrorConfig_Click(object sender, EventArgs e) { xtraTabControl1.SelectedTabPage = xtraTabPage2; loadByType = false; loadByStatus = false; //LoadData(); Wait.Show("Đang tải dữ liệu"); DataTable temp = new DataTable(); Company.DBCom.Company1DataTable Com1Table = new Company.DBCom.Company1DataTable(); SqlDataAdapter da = new SqlDataAdapter(); SqlConnection conn = new SqlConnection(Server.ConnectionString); conn.Open(); SqlCommand cmd = new SqlCommand(); cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "CMS_Company_SelectErrorConfig"; cmd.Connection = conn; da.SelectCommand = cmd; da.Fill(temp); for (int i = 0; i < temp.Rows.Count; i++) { int result = 0; int.TryParse(temp.Rows[i]["TheoDoi"].ToString(), out result); if ((!string.IsNullOrEmpty(temp.Rows[i]["TheoDoi"].ToString())) && (result != 0)) { int TheoDoi = int.Parse(temp.Rows[i]["TheoDoi"].ToString()); company1TableAdapter.FillBy_ErrorConfig(Com1Table, _pageIndex, _pageCount, TheoDoi); dBCom.Company1.Merge(Com1Table); } } //Wait.Show("Đang tải dữ liệu"); //this.company1TableAdapter.FillBy_ErrorConfig(this.dBCom.Company1, _pageIndex, _pageCount); //company1BindingSource.EndEdit(); Wait.Close(); }
private void btDay_Click(object sender, EventArgs e) { //int idClassification = QT.Entities.Common.Obj2Int(this.iDClassificationTextBox.Text); int idUser = Common.Obj2Int(this.iDUserSelectTextBox.Text); Wait.Show("Đẩy dữ liệu"); for (int x = gridView1.GetSelectedRows().Length - 1; x >= 0; x--) { try { int i = gridView1.GetSelectedRows()[x]; long idProduct = Common.Obj2Int64(gridView1.GetDataRow(i)["ID"].ToString()); if (idProduct != 0) { int idClassification = Common.Obj2Int(gridView1.GetDataRow(i)["CategoryID"].ToString()); string keysearch = GetFilterCategory(idClassification); this.job_SPGocNhapLieuTableAdapter.InsertQuery( idProduct, idUser, idClassification, QT.Entities.Common.JobNhapLieuStatus.Job_TaoMoi, DateTime.Now, keysearch); //Wait.Show(String.Format("Đẩy dữ liệu {0}/{1}", i + 1, dBPhanSP.Product.Count)); DataRow[] drr = dBPhanSP.Product.Select("ID=' " + idProduct + " ' "); foreach (var row in drr) { row.Delete(); } } } catch (Exception) { } } Wait.Close(); //PhanTichLai(); dBPhanSP.Product.AcceptChanges(); }
private void btChonCheck_Click(object sender, EventArgs e) { this.viewListValueOfCatFTBindingSource.EndEdit(); string txt1 = "Chuyển toàn bộ id đã chọn thành id: " + this.txtValueCurrent.Text; if (MessageBox.Show(this, txt1, "Thông báo", MessageBoxButtons.YesNo, MessageBoxIcon.Question, MessageBoxDefaultButton.Button1) == DialogResult.Yes) { for (int i = 0; i < dBProperties.ViewListValueOfCatFT.Rows.Count; i++) { bool check = false; check = Common.Obj2Bool(dBProperties.ViewListValueOfCatFT.Rows[i]["Check"].ToString()); if (check) { int PropertiesID = Common.Obj2Int(dBProperties.ViewListValueOfCatFT.Rows[i]["PropertiesID"].ToString()); int PropertiesValueID = Common.Obj2Int(dBProperties.ViewListValueOfCatFT.Rows[i]["PropertiesValueID"].ToString()); Wait.Show("Đang chuyển ID: " + PropertiesValueID.ToString()); adt.UpdateQuery_NhapValueGiongNhau(Common.Obj2Int(this.txtValueCurrent.Text), PropertiesID, PropertiesValueID); } } } Wait.Close(); RefreshData(); }
public void Sound(int Type) //語音 { //需要備份的檔案 //string[] fsbFile = { "VOBank_zh_TW.fsb", "VOBank_zh_CN.fsb", "VOBank_en_US.fsb", "VOBank_ko_KR.fsb", "LoL_Audio_zh_TW.fev", "LoL_Audio_zh_CN.fev", "LoL_Audio_en_US.fev", "LoL_Audio_ko_KR.fev" }; if (Type == 1) //備份 { wait.Show(); wait.progressBar1.Value = 0; //foreach (string file in fsbFile) //{ //try //{ //File.Copy(installPath + @"\Game\DATA\Sounds\FMOD\" + file, Application.StartupPath + @"\bak\sound\FMOD\" + file, true); //wait.progressBar1.Value = wait.progressBar1.Value + 5; //} //catch { } //} try { My.Computer.FileSystem.CopyDirectory(installPath + "\\Game\\DATA\\Sounds\\Wwise\\VO\\zh_TW", Application.StartupPath + "\\bak\\sound\\zh_TW", true); } catch { } try { My.Computer.FileSystem.CopyDirectory(installPath + "\\Game\\DATA\\Sounds\\Wwise\\VO\\en_US", Application.StartupPath + "\\bak\\sound\\en_US", true); } catch { } try { Directory.CreateDirectory(Application.StartupPath + @"\bak\sound\air"); foreach (string newPath in Directory.GetFiles(installPath + @"\Air\assets\sounds\en_US\champions", "*.*", SearchOption.AllDirectories)) { File.Copy(newPath, newPath.Replace(installPath + @"\Air\assets\sounds\en_US\champions", Application.StartupPath + @"\bak\sound\air"), true); } wait.progressBar1.Value = 60; foreach (string newPath in Directory.GetFiles(installPath + @"\Air\assets\sounds\zh_TW\champions", "*.*", SearchOption.AllDirectories)) { File.Copy(newPath, newPath.Replace(installPath + @"\Air\assets\sounds\zh_TW\champions", Application.StartupPath + @"\bak\sound\air"), true); } wait.progressBar1.Value = 100; wait.progressBar1.Value = 0; wait.Close(); MessageBox.Show("備份成功", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); Logger.log("語音檔 備份成功!", Logger.LogType.Info); } catch (Exception e) { wait.Close(); Logger.log("語音檔 備份失敗!", Logger.LogType.Error); Logger.log(e); MessageBox.Show("備份失敗 \r\n 錯誤信息: " + e, "錯誤", MessageBoxButtons.OK, MessageBoxIcon.Error); } } if (Type == 2) //還原 { wait.Show(); wait.progressBar1.Value = 0; //foreach (string file in fsbFile) //{ //try //{ //File.Copy(Application.StartupPath + @"\bak\sound\FMOD\" + file, installPath + @"\Game\DATA\Sounds\FMOD\" + file, true); //wait.progressBar1.Value = wait.progressBar1.Value + 15; //} //catch { } //} string[] folder = { "ko_KR", "zh_CN" }; foreach (string f in folder) { if (Directory.Exists(installPath + "\\Game\\DATA\\Sounds\\Wwise\\VO\\" + f)) { Directory.Delete(installPath + "\\Game\\DATA\\Sounds\\Wwise\\VO\\" + f); } } try { My.Computer.FileSystem.CopyDirectory(Application.StartupPath + "\\bak\\sound\\zh_TW", installPath + "\\Game\\DATA\\Sounds\\Wwise\\VO\\zh_TW", true); } catch { } try { My.Computer.FileSystem.CopyDirectory(Application.StartupPath + "\\bak\\sound\\en_US", installPath + "\\Game\\DATA\\Sounds\\Wwise\\VO\\en_US", true); } catch { } try { foreach (string newPath in Directory.GetFiles(Application.StartupPath + @"\bak\sound\air", "*.*", SearchOption.AllDirectories)) { File.Copy(newPath, newPath.Replace(Application.StartupPath + @"\bak\sound\air", installPath + @"\Air\assets\sounds\en_US\champions"), true); } wait.progressBar1.Value = 50; foreach (string newPath in Directory.GetFiles(Application.StartupPath + @"\bak\sound\air", "*.*", SearchOption.AllDirectories)) { File.Copy(newPath, newPath.Replace(Application.StartupPath + @"\bak\sound\air", installPath + @"\Air\assets\sounds\zh_TW\champions"), true); } wait.progressBar1.Value = 100; wait.progressBar1.Value = 0; wait.Close(); MessageBox.Show("還原成功", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); Logger.log("語音檔 還原成功!", Logger.LogType.Info); } catch (System.IO.DirectoryNotFoundException err) { wait.Close(); Logger.log("語音檔 還原失敗 : 沒有還原檔可供還原", Logger.LogType.Error); Logger.log(err); MessageBox.Show("沒有還原檔可供還原", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); } catch (Exception e) { wait.Close(); Logger.log("語音檔 還原失敗!", Logger.LogType.Error); Logger.log(e); MessageBox.Show("還原失敗 \r\n 錯誤信息: " + e, "錯誤", MessageBoxButtons.OK, MessageBoxIcon.Error); } } if (Type == 3) //刪除備份 { //foreach (string files in fsbFile) //{ //try //{ //File.Delete(Application.StartupPath + @"\bak\sound\FMOD\" + files); //} //catch { } //} try { Directory.Delete(Application.StartupPath + @"\bak\sound\zh_TW", true); } catch { } try { Directory.Delete(Application.StartupPath + @"\bak\sound\zh_CN", true); } catch { } try { Directory.Delete(Application.StartupPath + @"\bak\sound\en_US", true); } catch { } try { Directory.Delete(Application.StartupPath + @"\bak\sound\ko_KR", true); } catch { } try { Directory.Delete(Application.StartupPath + @"\bak\sound\Air", true); Logger.log("語音檔 刪除備份成功!", Logger.LogType.Error); MessageBox.Show("備份刪除成功", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); } catch { } } }
private void CheckCompanyButton_Click(object sender, EventArgs e) { Wait.Show("Đang kiểm tra công ty!"); //idcomnay này có thể là idharavan hoặc id mới đc sinh ra theo domain chính xác long idcompany = Common.Obj2Int64(companyIdWSSSpinEdit.Text); //QT.Entities.Company company = new QT.Entities.Company(idcompany); #region CheckCompany try { DBWebPartnerTableAdapters.CompanyTableAdapter companyAdapter = new DBWebPartnerTableAdapters.CompanyTableAdapter(); companyAdapter.Connection.ConnectionString = Server.ConnectionString; DBWebPartner.CompanyDataTable _companyTable = new DBWebPartner.CompanyDataTable(); companyAdapter.FillBy_ID(_companyTable, idcompany); //Trường hợp cài app thành công nhưng lúc tạo ra company xảy ra lỗi (api.websosanh.vn). // Lấy dữ liệu company từ haravan và thêm mới vào database. if (_companyTable.Rows.Count == 0) { string shopname = shopNameTextEdit.Text; string accesstoken = accessTokenTextEdit.Text; HaravanAuthorizationState authorizeState = new HaravanAuthorizationState(); authorizeState.ShopName = shopname; authorizeState.AccessToken = accesstoken; var client = new HaravanAPIClient(authorizeState); object obj = client.Get("/admin/shop.json"); if (obj != null) { ShopHaravanInfo shopharavanInfo = JsonConvert.DeserializeObject <ShopHaravanInfo>(obj.ToString()); //domain và website lấy theo domain chính xác được config (hoặc mặc định là shopname.myharavan.com) string website = string.Format("http://{0}/", domainChinhXacTextEdit.Text); Uri uri = new Uri(website); String domain = uri.Host.ToLower(); domain = domain.Replace("www.", ""); TimeSpan timestartup = new TimeSpan(0, 1, 1, 0); TimeSpan timeSleep = new TimeSpan(0, 1, 1, 0); Alexa a = new Alexa(); a = Common.GetRankAlexa(uri.Host); #region Insert try { companyAdapter.Insert( Common.GetIDCompany(domain), authorizeState.ShopName, "Shop in Haravan install App", website, domain, DateTime.Now, shopharavanInfo.shop.phone, shopharavanInfo.shop.email, shopharavanInfo.shop.customer_email, shopharavanInfo.shop.address1, Common.CompanyStatus.WEB_HARAVAN, "", a.AlexaRankContries, a.AlexaRank, timestartup, timeSleep, 0, 0, DateTime.Now, DateTime.Now, 30, 0, 0, 0, "", DateTime.Now, 0); Log.InfoFormat("HARAVAN : Insert Company Success With ShopName = {0}", authorizeState.ShopName); MessageBox.Show("Thêm mới công ty thành công!"); } catch (Exception ex) { Log.ErrorFormat("HARAVAN : Error Insert Company {0}", ex); } #endregion } } else { MessageBox.Show("Có công ty này!"); } } catch (Exception exx) { Log.ErrorFormat("HARAVAN : CheckCompany {0}", exx); } #endregion Wait.Close(); }
public void Dispose() { this.CleanMemoryFootprints(); Wait.Close(); }
private void DownloadAllImageButton_Click(object sender, EventArgs e) { Wait.Show("Đang download ảnh"); try { long idcompany = Common.Obj2Int64(companyIdWSSSpinEdit.Text); string _domain = domainChinhXacTextEdit.Text; DBWebPartnerTableAdapters.ProductTableAdapter productAdapter = new DBWebPartnerTableAdapters.ProductTableAdapter(); productAdapter.Connection.ConnectionString = Server.ConnectionString; DBWebPartner.ProductDataTable productTable = new DBWebPartner.ProductDataTable(); productAdapter.FillBy_CompanyAndValid1(productTable, idcompany); if (productTable.Rows.Count == 0) { MessageBox.Show("Shop không có sản phẩm! Vui lòng kiểm tra lại!"); } else { int count = productTable.Rows.Count; int countproduct = 0; int countproductimagesuccess = 0; for (int i = 0; i < count; i++) { Wait.Show(string.Format("Download ảnh {0}/{1}", i.ToString(), count.ToString())); long idProduct = long.Parse(productTable.Rows[i]["ID"].ToString()); string imageurls = productTable.Rows[i]["ImageUrls"].ToString(); string nameproduct = productTable.Rows[i]["Name"].ToString(); if (!string.IsNullOrEmpty(imageurls)) { countproduct++; string imagepath = string.Empty; imagepath = Common.UploadImageProductStore(nameproduct, _domain, imageurls); if (imagepath != "") { countproductimagesuccess++; try { productTableAdapter.UpdateImagePath(imagepath, idProduct); } catch (Exception ex) { richTextBoxMessage.Text += ex.Message; } } else { richTextBoxMessage.Text += idProduct.ToString() + "Upload fails\r\n"; } } else { richTextBoxMessage.Text += idProduct.ToString() + "Url null or Empty\r\n"; } } labelControlMessageImage.Text = string.Format("Upload ảnh {0} sản phẩm. Thành công {1}/{2}", count, countproductimagesuccess, countproduct); } } catch (Exception ex) { richTextBoxMessage.Text += ex.Message; } Wait.Close(); }
private void Window_Closing(object sender, CancelEventArgs e) { waitWindow.Close(); }
private void simpleButton2_Click(object sender, EventArgs e) { DBLogJobTableAdapters.CompanyTableAdapter companyAdapter = new DBLogJobTableAdapters.CompanyTableAdapter(); DBLogJob.CompanyDataTable companyTable = new DBLogJob.CompanyDataTable(); DBLogJob.ConfigurationDataTable configTable = new DBLogJob.ConfigurationDataTable(); companyAdapter.Connection.ConnectionString = Server.ConnectionString; for (int i = 0; i < dBLogJob.CompanyVATStatus.Rows.Count; i++) { Wait.Show(string.Format("{0}/{1}", i, dBLogJob.CompanyVATStatus.Rows.Count)); string domain = dBLogJob.CompanyVATStatus.Rows[i]["Domain"].ToString(); long idcompany = Common.GetIDCompany(domain); if (idcompany != 0) { try { companyTable.Rows.Clear(); companyAdapter.FillBy_ID(companyTable, idcompany); if (companyTable.Rows.Count > 0) { configTable.Rows.Clear(); if (dBLogJob.CompanyVATStatus.Rows[i]["VATStatus"] == DBNull.Value) { Log.Error("VATSTatus NULL + ID =" + idcompany + " Domain = " + domain); continue; } int status = Common.Obj2Int(dBLogJob.CompanyVATStatus.Rows[i]["VATStatus"].ToString()); try { configurationTableAdapter.FillBy_CompanyID(configTable, idcompany); if (configTable.Rows.Count > 0) { try { configurationTableAdapter.UpdateVATStatus(status, idcompany); } catch (Exception ex1) { Log.Error("ERROR UPDATE + ID =" + idcompany + " Domain = " + domain, ex1); } } else { try { configurationTableAdapter.Insert("", "", "", "", "", "", "", "", null, "", "", idcompany, "", null, 0, 0, 0, 0, "", "", "", "", "", "", "", "", null, "", "", "", "", "", "", "", "", "", null, "", null, "", "", null, null, null, null, 0, status); } catch (Exception ex2) { Log.Error("ERROR INSERT + ID =" + idcompany + " Domain = " + domain, ex2); } } } catch (Exception exx) { Log.Error("ERROR fill by id configuration ", exx); } } else { Log.Error("Không có Cong ty nay ID =" + idcompany + " Domain " + domain); } } catch (Exception ex) { Log.Error("ERROR fill by id COmpany ", ex); } } else { Log.Error("ID = 0 " + domain); } } Wait.Close(); }