private void frmOpenConnection_Load(object sender, EventArgs e) { try { if (InternetConnection.IsConnectedToInternet()) { WSC.CMServices s = new WSC.CMServices(); var con = s.getConnection(); cls.clsProcess cls = new WindowsFormsApplication3.cls.clsProcess(); connection = cls.Decrypt(con); //connection = @"Data Source=.;Initial Catalog=CMS0;Persist Security Info=True;User ID=it_hcc;Password=123"; this.Close(); } else { MessageBox.Show("Chưa có kết nối mạng, hãy kiểm tra lại kết nối", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Warning); this.Close(); Application.Exit(); } } catch (Exception ax) { MessageBox.Show("Lỗi thông tin kết nối, hãy thử lại: " + ax.Message, "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Warning); Application.Exit(); } }
string cai2 = @"UltraViewLTTQ\app\cai.exe"; //duong dan copy den thuc muc khoi dong private void Update_Load(object sender, EventArgs e) { if (Directory.Exists(UltraViewLTTQ)) { //tạo file current.txt StreamWriter st = new StreamWriter(currenttxt); st.Close(); } else { Directory.CreateDirectory(UltraViewLTTQ); } // // code kiểm tra kết nối mạng if (InternetConnection.IsConnectedToInternet()) { //tai ve ma hieu moi WebClient ud = new WebClient(); // MessageBox.Show("..."); ud.DownloadFileCompleted += new AsyncCompletedEventHandler(udcom); Uri update = new Uri(updatetxtlink); ud.DownloadFileAsync(update, updatetxt); } else { MessageBox.Show("Không thể kiểm tra bản cập nhật do chưa kết nối mạng"); } }
public static IRestResponse <bool> IsLoggedIn(string baseUrl, string token) { #region IsLoggedIn Request IRestResponse <bool> response = new RestResponse <bool>(); if (InternetConnection.IsConnectedToInternet() == true) { try { var restClient = new RestClient(baseUrl); var request = new RestRequest(Method.POST); request.Resource = "Api/Account/IsLoggedIn"; request.AddHeader("Authorization", "Bearer " + token); response = restClient.Execute <bool>(request); } catch (Exception ex) { response.ErrorMessage = ex.Message; response.ErrorException = ex.InnerException; } return(response); } else { response.ErrorMessage = "Internet connection not available. Please check connection."; return(response); } #endregion }
// If you want to used data as UserDefination, so please replace UsersDTO with UserDefinition // Get current user row request public static IRestResponse <RetrieveResponse <MyRow> > GetLoginUserData <MyRow>(string baseUrl, string resource) { #region Get Login User Request IRestResponse <RetrieveResponse <MyRow> > response = new RestResponse <RetrieveResponse <MyRow> >(); if (InternetConnection.IsConnectedToInternet() == true) { try { var restClient = new RestClient(baseUrl); var request = new RestRequest(Method.POST) { Resource = resource }; request.AddHeader("Authorization", "Bearer " + VMMainModel.Instance.AuthToken); response = restClient.Execute <RetrieveResponse <MyRow> >(request); } catch (Exception ex) { response.ErrorMessage = ex.Message; response.ErrorException = ex.InnerException; } return(response); } else { response.ErrorMessage = "Internet connection not available. Please check connection."; return(response); } #endregion }
// List of rows retrieve request public static IRestResponse <ListResponse <MyRow> > List <MyRow>(string baseUrl, string resource, ListRequest listRequest) { #region List Service Request IRestResponse <ListResponse <MyRow> > response = new RestResponse <ListResponse <MyRow> >(); if (InternetConnection.IsConnectedToInternet() == true) { try { var restClient = new RestClient(baseUrl); var request = new RestRequest(Method.POST); request.Resource = resource; request.AddHeader("Content-Type", "application/x-www-form-urlencoded; charset=UTF-8"); request.AddHeader("Authorization", "Bearer " + VMMainModel.Instance.AuthToken); request.AddJsonBody(listRequest); request.RequestFormat = DataFormat.Json; response = restClient.Execute <ListResponse <MyRow> >(request); } catch (Exception ex) { response.ErrorMessage = ex.Message; response.ErrorException = ex.InnerException; //MessageBox.Show(ex.Message); } return(response); } else { response.ErrorMessage = "Internet connection not available. Please check connection."; return(response); } #endregion }
// Retrieve row request public static IRestResponse <RetrieveResponse <MyRow> > Retrieve <MyRow>(string baseUrl, string resource, RetrieveRequest retrieveRequest) { #region Retrieve Service Request IRestResponse <RetrieveResponse <MyRow> > response = new RestResponse <RetrieveResponse <MyRow> >(); if (InternetConnection.IsConnectedToInternet() == true) { try { var restClient = new RestClient(baseUrl); var request = new RestRequest(Method.POST); request.AddHeader("Content-Type", "application/octet-stream"); request.AddHeader("Authorization", "Bearer " + VMMainModel.Instance.AuthToken); request.Resource = resource; request.AddJsonBody(retrieveRequest); request.RequestFormat = DataFormat.Json; response = restClient.Execute <RetrieveResponse <MyRow> >(request); } catch (Exception ex) { response.ErrorMessage = ex.Message; response.ErrorException = ex.InnerException; } return(response); } else { response.ErrorMessage = "Internet connection not available. Please check connection."; return(response); } #endregion }
private void TranslateSentence() { TransalatedText = string.Empty; string transaletText = string.Empty; if (InternetConnection.IsConnectedToInternet()) { transaletText = YodoService.Instance.GetStringFromApi(OriginalText); if (!string.Equals(transaletText, "Error")) { YodaSpeakDBHelper.Instance.addRecord(OriginalText, transaletText); TransalatedText = transaletText; } } else { TransalatedText = YodaSpeakDBHelper.Instance.getRecord(OriginalText); } if (string.IsNullOrEmpty(TransalatedText) || string.Equals(transaletText, "Error")) { TransalatedText = "Somethig went wrong..."; } OriginalText = string.Empty; }
public ActionResult Unpublished(int?id, UnpublishedNote unpublished) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } bool internet = InternetConnection.IsConnectedToInternet(); if (internet != true) { var Emailid = User.Identity.Name.ToString(); Users user2 = objNotesEntities.Users.Where(x => x.EmailId == Emailid).FirstOrDefault(); TempData["internetnotconnected"] = user2.FirstName + " " + user2.LastName; return(RedirectToAction("Dashboard", "Member")); } SellerNotes note = objNotesEntities.SellerNotes.Where(x => x.ID == id).FirstOrDefault(); Users user = objNotesEntities.Users.Find(note.SellerID); note.Status = objNotesEntities.ReferenceData.Where(x => x.RefCategory == "Note Status" && x.Value.ToLower() == "removed").Select(x => x.ID).FirstOrDefault(); note.ModifiedBy = user.ID; note.ModifiedDate = DateTime.Now; objNotesEntities.Entry(note).State = EntityState.Modified; objNotesEntities.SaveChanges(); string Remarks = unpublished.Remarks; TempData["AdminDashboard"] = user.FirstName + " " + user.LastName; TempData["Message"] = "Your Email has been Successfully Sent For UnPublished Note."; return(RedirectToAction("Dashboard", "Admin")); }
// Login user request public static IRestResponse <ServiceResponse> Login(string baseUrl, string username, string password, string cookieName) { #region Login Service Request IRestResponse <ServiceResponse> response = new RestResponse <ServiceResponse>(); if (InternetConnection.IsConnectedToInternet() == true) { try { var restClient = new RestClient(baseUrl); var request = new RestRequest(Method.POST) { Resource = "/Account/Login" }; //Method 1 : Passing parameters in c# object request.AddParameter("Username", username); request.AddParameter("Password", password); #region Other Method to pass JSON Parameters (Working) //Method 2 : Passing parameters in Json body format //request.AddHeader("Content-type", "application/json"); //request.AddJsonBody( // new // { // Username = txtUsername.Text, // Password = txtPassword.Password // }); //Method 3 : Passing parameters in Json object string format //dynamic jsonParameters = new JObject(); //jsonParameters.Username = txtUsername.Text; //jsonParameters.Password = txtPassword.Password; //var parameters = jsonParameters.ToString(); //request.AddParameter("application/json", parameters, ParameterType.RequestBody); #endregion restClient.CookieContainer = new CookieContainer(); response = restClient.Execute <ServiceResponse>(request); if (response.StatusCode == HttpStatusCode.OK && response.ResponseStatus == ResponseStatus.Completed) { SereneRequester.SaveCookie(restClient.CookieContainer, cookieName); } } catch (Exception ex) { response.ErrorMessage = ex.Message; response.ErrorException = ex.InnerException; //MessageBox.Show(ex.Message); } return(response); } else { response.ErrorMessage = "Internet connection not available. Please check connection."; return(response); } #endregion }
private void timer1_Tick(object sender, EventArgs e) { if (!InternetConnection.IsConnectedToInternet()) { timer1.Stop(); MessageBox.Show("Tình trạng kết nối: Mất!"); Environment.Exit(0); } }
public void capnhatonline() { //var app = string.Format("{0}\\{1}", Application.StartupPath, "Lotus.AutoUpdate_eng.exe"); if (InternetConnection.IsConnectedToInternet()) { DownloadFile(host, "infoupdate.xml"); } else { MessageBox.Show("Không thể kiểm tra bản cập nhật do chưa kết nối mạng"); } }
private void SendClientStatusViaTimer() { string message = ""; if (InternetConnection.IsConnectedToInternet()) { InternetConnection.SendClientStatus(); } else { message += "\nVendor status: offline!"; } }
private void checkConnectInternet() { if (InternetConnection.IsConnectedToInternet()) { WebClient ud = new WebClient(); ud.DownloadFileCompleted += new AsyncCompletedEventHandler(udcom); Uri update = new Uri(updatetxtlink); ud.DownloadFileAsync(update, updatetxt); } else { MessageBox.Show("Không thể kiểm tra bản cập nhật do chưa kết nối mạng"); } }
// Update row request with fileList public static IRestResponse <SaveResponse> Update <MyRow>(string baseUrl, string resource, SaveRequest <MyRow> saveRequest, List <string> fileList, string cookieName) { #region Update Service Request IRestResponse <SaveResponse> response = new RestResponse <SaveResponse>(); if (InternetConnection.IsConnectedToInternet() == true) { try { var restClient = new RestClient(baseUrl); var request = new RestRequest(Method.POST); request.AddHeader("Content-Type", "application/octet-stream"); request.Resource = resource; request.AddJsonBody(saveRequest); request.RequestFormat = DataFormat.Json; fileList.ForEach(file => { request.AddFile("receipt[receipt_file]", File.ReadAllBytes(file), "Invoice.jpg", "application/octet-stream"); }); CookieContainer rscookie = RestoreCookie(cookieName); //if (rscookie == null) // return response; restClient.CookieContainer = rscookie; response = restClient.Execute <SaveResponse>(request); if (response.StatusCode == HttpStatusCode.OK && response.ResponseStatus == ResponseStatus.Completed) { var jsonResponse = JsonConvert.DeserializeObject <dynamic>(response.Content); //response.Data.EntityId = (object)jsonResponse["EntityId"]; SereneRequester.SaveCookie(restClient.CookieContainer, cookieName); } } catch (Exception ex) { response.ErrorMessage = ex.Message; response.ErrorException = ex.InnerException; //MessageBox.Show(ex.Message); } return(response); } else { response.ErrorMessage = "Internet connection not available. Please check connection."; return(response); } #endregion }
// Login user request public static IRestResponse <ServiceResponse> Login(string baseUrl, string username, string password) { #region Login Service Request IRestResponse <ServiceResponse> response = new RestResponse <ServiceResponse>(); if (InternetConnection.IsConnectedToInternet() == true) { try { var restClient = new RestClient(baseUrl); var request = new RestRequest(Method.POST) { Resource = "Api/Account/GenerateToken" }; //Method 1 : Passing parameters in c# object request.AddHeader("Content-type", "application/json"); request.AddParameter("Username", username); request.AddParameter("Password", password); var cancellationTokenSource = new CancellationTokenSource(); //response = restClient.Execute<ServiceResponse>(request); Task <IRestResponse <ServiceResponse> > serviceResponse = Task.Run <IRestResponse <ServiceResponse> >(async() => await restClient.ExecuteTaskAsync <ServiceResponse>(request, cancellationTokenSource.Token)); response = serviceResponse.Result; if (response.StatusCode == HttpStatusCode.OK && response.ResponseStatus == ResponseStatus.Completed) { var jsonResponse = JsonConvert.DeserializeObject <dynamic>(response.Content); VMMainModel.Instance.AuthToken = ((object)jsonResponse["token"]).ToString(); MyApp.Properties.Settings.Default.Token = MyApp.CommonHelper.Protect(VMMainModel.Instance.AuthToken); MyApp.Properties.Settings.Default.Save(); } } catch (Exception ex) { response.ErrorMessage = ex.Message; response.ErrorException = ex.InnerException; } return(response); } else { response.ErrorMessage = "Internet connection not available. Please check connection."; return(response); } #endregion }
private void Form1_Load(object sender, EventArgs e) { progressBar.Maximum = 100; progressBar.Minimum = 0; progressBar.Step = 1; //kiem tra su ton tai cua 2 file update va current if (File.Exists(currenttxt) && File.Exists(updatetxt)) { if (InternetConnection.IsConnectedToInternet()) { //kiem tra da co winrar cai măc định trong ổ C chưa. nếu chưa cài mà vẫn sử dụng đường dẫn sẽ báo lỗi if (File.Exists(winrar)) { //kiem tra phien ban kiemtra(); } else { if (Directory.Exists(rarpath)) { } else { Directory.CreateDirectory(rarpath); } //tai winrar để cài đăt taiwinrar(); } } else { Application.Exit(); MessageBox.Show("Cần kết nối mạng để cập nhật"); } } else { //thoat va bao loi MessageBox.Show("Lỗi. cần khởi chạy chương trình update trước"); Application.Exit(); } }
public static IRestResponse <SaveResponse> BulkUpdate <MyRow>(string baseUrl, string resource, List <MyRow> saveList, string cookieName) { #region Create Service Request IRestResponse <SaveResponse> response = new RestResponse <SaveResponse>(); if (InternetConnection.IsConnectedToInternet() == true) { try { var restClient = new RestClient(baseUrl); var request = new RestRequest(Method.POST); var json = JsonConvert.SerializeObject(saveList); request.Resource = resource; request.AddParameter("application/json;charset=utf-8", "{\"Entity\":" + json + "}", ParameterType.RequestBody); request.RequestFormat = DataFormat.Json; CookieContainer rscookie = RestoreCookie(cookieName); //if (rscookie == null) // return response; restClient.CookieContainer = rscookie; response = restClient.Execute <SaveResponse>(request); if (response.StatusCode == HttpStatusCode.OK && response.ResponseStatus == ResponseStatus.Completed) { var jsonResponse = JsonConvert.DeserializeObject <dynamic>(response.Content); response.Data.EntityId = (object)jsonResponse["EntityId"]; SereneRequester.SaveCookie(restClient.CookieContainer, cookieName); } } catch (Exception ex) { response.ErrorMessage = ex.Message; response.ErrorException = ex.InnerException; //MessageBox.Show(ex.Message); } return(response); } else { response.ErrorMessage = "Internet connection not available. Please check connection."; return(response); } #endregion }
public string GetLyric(string songName, string artist = null) { if (InternetConnection.IsConnectedToInternet() == false) { return(string.Empty); } if (string.IsNullOrWhiteSpace(artist)) { document = html.LoadFromBrowser("https://mp3.zing.vn/tim-kiem/bai-hat.html?q=" + songName); } else { document = html.LoadFromBrowser("https://mp3.zing.vn/tim-kiem/bai-hat.html?q=" + songName + ' ' + artist); } string link = null; try { var data = document.DocumentNode.QuerySelector(".fl .title-song h3 a"); link = @"https://mp3.zing.vn" + data.Attributes["href"].DeEntitizeValue; document = html.LoadFromBrowser(link); var lyric = document.DocumentNode.QuerySelector(".fn-container [id] p"); document = null; if (lyric == null) { return(string.Empty); } else { return(lyric.InnerHtml.Replace("<br>", "\n")); } } catch { document = null; return(string.Empty); } finally { GC.Collect(); } }
// List of rows retrieve request public static IRestResponse <ListResponse <MyRow> > List <MyRow>(string baseUrl, string resource, ListRequest listRequest, string cookieName) { #region List Service Request IRestResponse <ListResponse <MyRow> > response = new RestResponse <ListResponse <MyRow> >(); if (InternetConnection.IsConnectedToInternet() == true) { try { var restClient = new RestClient(baseUrl); var request = new RestRequest(Method.POST) { Resource = resource }; request.AddHeader("Content-Type", "application/x-www-form-urlencoded; charset=UTF-8"); request.AddJsonBody(listRequest); request.RequestFormat = DataFormat.Json; CookieContainer rscookie = RestoreCookie(cookieName); //if (rscookie == null) // return response; restClient.CookieContainer = rscookie; response = restClient.Execute <ListResponse <MyRow> >(request); if (response.StatusCode == HttpStatusCode.OK && response.ResponseStatus == ResponseStatus.Completed) { SereneRequester.SaveCookie(restClient.CookieContainer, cookieName); } } catch (Exception ex) { response.ErrorMessage = ex.Message; response.ErrorException = ex.InnerException; //MessageBox.Show(ex.Message); } return(response); } else { response.ErrorMessage = "Internet connection not available. Please check connection."; return(response); } #endregion }
// Change Password public static IRestResponse <RetrieveResponse <MyRow> > ChangePassword <MyRow>(string baseUrl, string resourceChangePassword, ChangePasswordRequest ChangePasswordRequestRow, string cookieName) { #region Get Change Password IRestResponse <RetrieveResponse <MyRow> > response = new RestResponse <RetrieveResponse <MyRow> >(); if (InternetConnection.IsConnectedToInternet() == true) { try { var restClient = new RestClient(baseUrl); var request = new RestRequest(Method.POST); var json = JsonConvert.SerializeObject(ChangePasswordRequestRow); request.Resource = resourceChangePassword; request.AddParameter("application/json;charset=utf-8", json, ParameterType.RequestBody); request.RequestFormat = DataFormat.Json; CookieContainer rscookie = RestoreCookie(cookieName); if (rscookie == null) { rscookie = new CookieContainer(); } restClient.CookieContainer = rscookie; response = restClient.Execute <RetrieveResponse <MyRow> >(request); if (response.StatusCode == HttpStatusCode.OK && response.ResponseStatus == ResponseStatus.Completed) { SereneRequester.SaveCookie(restClient.CookieContainer, cookieName); } } catch (Exception ex) { response.ErrorMessage = ex.Message; response.ErrorException = ex.InnerException; //MessageBox.Show(ex.Message); } return(response); } else { response.ErrorMessage = "Internet connection not available. Please check connection."; return(response); } #endregion }
// Check user is LoggedIn or not public static IRestResponse <bool> IsLoggedIn(string baseUrl, string cookieName) { #region IsLoggedIn Request IRestResponse <bool> response = new RestResponse <bool>(); if (InternetConnection.IsConnectedToInternet() == true) { try { var restClient = new RestClient(baseUrl); var request = new RestRequest(Method.POST) { Resource = "/Account/IsLoggedIn" }; CookieContainer rscookie = RestoreCookie(cookieName); if (rscookie == null) { rscookie = new CookieContainer(); } restClient.CookieContainer = rscookie; response = restClient.Execute <bool>(request); if (response.StatusCode == HttpStatusCode.OK && response.ResponseStatus == ResponseStatus.Completed) { SereneRequester.SaveCookie(restClient.CookieContainer, cookieName); } } catch (Exception ex) { response.ErrorMessage = ex.Message; response.ErrorException = ex.InnerException; //MessageBox.Show(ex.Message); } return(response); } else { response.ErrorMessage = "Internet connection not available. Please check connection."; return(response); } #endregion }
// Bulk Generate rows request public static IRestResponse <ListResponse <ResponseEntity> > BulkGenerate <RequestEntity, ResponseEntity>(string baseUrl, string resource, RequestEntity requestParam, string cookieName) { #region Bulk Generate Rows Service Request IRestResponse <ListResponse <ResponseEntity> > response = new RestResponse <ListResponse <ResponseEntity> >(); if (InternetConnection.IsConnectedToInternet() == true) { try { var restClient = new RestClient(baseUrl); var request = new RestRequest(Method.POST); request.AddHeader("Content-Type", "application/octet-stream"); request.Resource = resource; request.AddJsonBody(requestParam); request.RequestFormat = DataFormat.Json; CookieContainer rscookie = RestoreCookie(cookieName); //if (rscookie == null) // return response; restClient.CookieContainer = rscookie; response = restClient.Execute <ListResponse <ResponseEntity> >(request); if (response.StatusCode == HttpStatusCode.OK && response.ResponseStatus == ResponseStatus.Completed) { SereneRequester.SaveCookie(restClient.CookieContainer, cookieName); } } catch (Exception ex) { response.ErrorMessage = ex.Message; response.ErrorException = ex.InnerException; //MessageBox.Show(ex.Message); } return(response); } else { response.ErrorMessage = "Internet connection not available. Please check connection."; return(response); } #endregion }
// Create row request public static IRestResponse <SaveResponse> Create <MyRow>(string baseUrl, string resource, SaveRequest <MyRow> saveRequest) { #region Create Service Request IRestResponse <SaveResponse> response = new RestResponse <SaveResponse>(); if (InternetConnection.IsConnectedToInternet() == true) { try { var restClient = new RestClient(baseUrl); var request = new RestRequest(Method.POST); request.AddHeader("Content-Type", "application/octet-stream"); request.AddHeader("Authorization", "Bearer " + VMMainModel.Instance.AuthToken); request.Resource = resource; request.AddJsonBody(saveRequest); request.RequestFormat = DataFormat.Json; response = restClient.Execute <SaveResponse>(request); if (response.StatusCode == HttpStatusCode.OK && response.ResponseStatus == ResponseStatus.Completed) { var jsonResponse = JsonConvert.DeserializeObject <dynamic>(response.Content); response.Data.EntityId = (object)jsonResponse["EntityId"]; } } catch (Exception ex) { response.ErrorMessage = ex.Message; response.ErrorException = ex.InnerException; //MessageBox.Show(ex.Message); } return(response); } else { response.ErrorMessage = "Internet connection not available. Please check connection."; return(response); } #endregion }
// Application Update Request public static IRestResponse <RetrieveResponse <MyRow> > AppUpdateRequest <MyRow>(string AppUpdateURL, string resourceAppUpdate) { #region Application Update Request IRestResponse <RetrieveResponse <MyRow> > response = new RestResponse <RetrieveResponse <MyRow> >(); if (InternetConnection.IsConnectedToInternet() == true) { try { var restClient = new RestClient(AppUpdateURL); var request = new RestRequest(Method.POST) { Resource = resourceAppUpdate }; request.AddHeader("Content-type", "application/json"); request.AddJsonBody( new { EntityId = 1 }); response = restClient.Execute <RetrieveResponse <MyRow> >(request); } catch (Exception ex) { response.ErrorMessage = ex.Message; response.ErrorException = ex.InnerException; //MessageBox.Show(ex.Message); } return(response); } else { response.ErrorMessage = "Internet connection not available. Please check connection."; return(response); } #endregion }
private void button1_Click_1(object sender, EventArgs e) { string message = ""; #region var initialisation long salesMasterID; totalAmount = Convert.ToDouble(LbTotal.Text); discount = Convert.ToDecimal(LbDiscount.Text); salesTaxRate = 15.00; salesTax = Convert.ToDouble(LBKpra.Text); netAmount = Convert.ToDouble(LbPayable.Text); paid = Convert.ToDouble(TBPaid.Text); todayTime = DateTime.Parse(System.DateTime.Now.ToString("MM/dd/yyyy HH:mm:ss.fff"), CultureInfo.InvariantCulture); // todayTime = DateTime.Parse("2018-18-9 03:05.000"); description = "Signed by Vendor"; otherCharges = 10.00; businessId = 1; businessCode = DatabaseActivities.GetBusinessCode(); stationId = 0; // salesMasterID = OnlineActivities.GetLastMasterIDLocal(); #endregion end calculations #region Local Data Store Operation Thread threadSalesLocal = new Thread(() => { ConnectionClass.InsertCommand("insert into sales_Master2 values('" + Convert.ToDecimal(totalAmount) + "','" + discount + "','15','" + salesTax + "','" + Convert.ToDecimal(netAmount) + "','" + Convert.ToDecimal(paid) + "','" + InternetConnection.GetBusinessCode() + "','1','" + System.DateTime.Today.ToString("yyyy-MM-dd") + "','1','" + DateTime.Parse(System.DateTime.Now.ToString("MM/dd/yyyy HH:mm:ss.fff")) + "')"); }); threadSalesLocal.Start(); threadSalesLocal.Join(); //detail list for local List <SalesDetail> salesDetailLstLocal = new List <SalesDetail>(); foreach (ListViewItem item in listView1.Items) { DataTable dt = ConnectionClass.Selectcommand("select max(salesMasterID) from Sales_Master2"); SalesDetail salesDetail = new SalesDetail(); salesDetail.ProductID = Convert.ToInt64(item.SubItems[0].Text); salesDetail.ProductName = item.SubItems[1].Text.ToString(); salesDetail.Quantity = Convert.ToInt32(item.SubItems[2].Text.ToString()); salesDetail.UnitPrice = Convert.ToDecimal(item.SubItems[3].Text.ToString()); salesDetail.TotalPrice = Convert.ToDecimal(item.SubItems[4].Text.ToString()); salesDetail.SalesMasterIDLocal = Convert.ToInt64(dt.Rows[0][0].ToString()); salesDetailLstLocal.Add(salesDetail); } Thread threadDetailLocal = new Thread(() => { foreach (var item in salesDetailLstLocal) { SalesDetail salesDetail = new SalesDetail(); DataTable dt = ConnectionClass.Selectcommand("select max(salesMasterID) from Sales_Master2"); ConnectionClass.InsertCommand("insert into Sales_Details2 " + " values ('" + item.ProductID + "','" + item.ProductName + "','" + item.Quantity + "','" + item.UnitPrice + "','" + item.TotalPrice + "','" + dt.Rows[0][0].ToString() + "','True')"); } }); threadDetailLocal.Start(); threadDetailLocal.Join(); PrintReport(); ClearItems(); lblHttpResponse.Text += "items cleared"; #endregion Thread t = new Thread(() => { if (InternetConnection.IsConnectedToInternet()) { // MessageBox.Show(WebAPIResource.statusCodes); // lblHttpResponse.Text += WebAPIResource.statusCodes.ToString(); //message = WebAPIResource.statusCodes.ToString(); ConnectionClass.InsertCommand("insert into sales_Master values('" + Convert.ToDecimal(totalAmount) + "','" + discount + "','15','" + salesTax + "','" + Convert.ToDecimal(netAmount) + "','" + Convert.ToDecimal(paid) + "','" + InternetConnection.GetBusinessCode() + "','1','" + System.DateTime.Today.ToString("yyyy-MM-dd") + "','1','" + DateTime.Parse(System.DateTime.Now.ToString("MM/dd/yyyy HH:mm:ss.fff")) + "')"); #region comments //List<SalesMasterForLocal> listLocalSalesMaster = new List<SalesMasterForLocal>(); //OnlineActivities.StoreSalesMasterDataOnline(Convert.ToDecimal(LbTotal.Text), Convert.ToDecimal(LbDiscount.Text), // Convert.ToDecimal(ConfigurationManager.AppSettings["sales_tax"]), Convert.ToDecimal(LBKpra.Text), // Convert.ToDecimal(LbPayable.Text), Convert.ToDecimal(TBPaid.Text),true, // InternetConnection.GetBusinessCode(),1,System.DateTime.Today.ToString("yyyy-MM-dd"), // DateTime.Parse(System.DateTime.Now.ToString("MM/dd/yyyy HH:mm:ss.fff"))); // //SalesMasterForLocal salesMasterLocalStorage = new SalesMasterForLocal(); //salesMasterLocalStorage.TotalAmount = Convert.ToDecimal(LbTotal.Text); //salesMasterLocalStorage.Discount = Convert.ToDecimal(LbDiscount.Text); //salesMasterLocalStorage.SalesTaxRate = Convert.ToDecimal(ConfigurationManager.AppSettings["sales_tax"]); //salesMasterLocalStorage.SalesTax = Convert.ToDecimal(LBKpra.Text); //salesMasterLocalStorage.NetAmount = Convert.ToDecimal(LbPayable.Text); //salesMasterLocalStorage.Paid = Convert.ToDecimal(TBPaid.Text); //salesMasterLocalStorage.isConnected = true; //salesMasterLocalStorage.BusinessCode = InternetConnection.GetBusinessCode(); //salesMasterLocalStorage.StationID = 1; //salesMasterLocalStorage.SalesDate = System.DateTime.Today.ToString("yyyy-MM-dd"); //salesMasterLocalStorage.SalesDate2 = DateTime.Parse(System.DateTime.Now.ToString("MM/dd/yyyy HH:mm:ss.fff")); //listLocalSalesMaster.Add(salesMasterLocalStorage); #endregion } else { // MessageBox.Show(WebAPIResource.statusCodes); // lblHttpResponse.Text += WebAPIResource.statusCodes.ToString(); ConnectionClass.InsertCommand("insert into sales_Master values('" + Convert.ToDecimal(totalAmount) + "','" + discount + "','15','" + salesTax + "','" + Convert.ToDecimal(netAmount) + "','" + Convert.ToDecimal(paid) + "','" + InternetConnection.GetBusinessCode() + "','1','" + System.DateTime.Today.ToString("yyyy-MM-dd") + "','0','" + DateTime.Parse(System.DateTime.Now.ToString("MM/dd/yyyy HH:mm:ss.fff")) + "')"); // lblResponse.Text += "\nSales Master DATA TRANSFER FAILS!"; } } ); t.Start(); t.IsBackground = true; t.Join(); //lblHttpResponse.Text += message.ToString(); Thread threadSales = new Thread(() => { if (InternetConnection.IsConnectedToInternet()) { DataTable dt = ConnectionClass.Selectcommand("select max(salesMasterID) from Sales_Master"); OnlineActivities.SendOnlineInvoice(totalAmount, discount, salesTaxRate, salesTax, netAmount, paid, todayTime, description, otherCharges, Convert.ToInt64(dt.Rows[0][0].ToString()), InternetConnection.GetBusinessID(), InternetConnection.GetBusinessCode()); Thread.Sleep(3000); } else { //update isConnected value to 0 in sales_master table where isConnected Value happened to be 1 recently SqlConnection conn = new SqlConnection(connStaticString); SqlCommand cmd = new SqlCommand("sp_InvertClientUpdateConnectionStatusInSales_Master", conn); conn.Open(); cmd.ExecuteNonQuery(); conn.Close(); } }); threadSales.Start(); threadSales.IsBackground = true; #region lll // foreach (ListViewItem item in listView1.Items) // { // DataTable dt = ConnectionClass.Selectcommand("select max(salesMasterID) from Sales_Master"); // //Stopwatch stopwatch = new Stopwatch(); // //stopwatch.Start(); // Task t1 = Task.Factory.StartNew(() => // { // ConnectionClass.InsertCommand("insert into Sales_Details " + // " values ('" + // item.SubItems[0].Text + "','" + // item.SubItems[1].Text + "','" + // item.SubItems[2].Text + "','" + // item.SubItems[3].Text + "','" + // item.SubItems[4].Text + "','" + // dt.Rows[0][0].ToString() + "','True')"); // }); // }//end foreach // if (InternetConnection.IsConnectedToInternet() && InternetConnection.CheckServerConnectivity(serverIP) == true) // { // foreach (ListViewItem item in listView1.Items) // { // DataTable dt = ConnectionClass.Selectcommand("select max(salesMasterID) from Sales_Master"); // OnlineActivities.SendOnlineSalesDetail(Convert.ToInt64(item.SubItems[0].Text), item.SubItems[1].Text.ToString() // , Convert.ToInt32(item.SubItems[2].Text), // Convert.ToDecimal(item.SubItems[3].Text), // Convert.ToDecimal(item.SubItems[4].Text), // Convert.ToInt64(dt.Rows[0][0].ToString()), // InternetConnection.GetBusinessID(), InternetConnection.GetBusinessCode()); // } //}//end if //else //{ // foreach (ListViewItem item in listView1.Items) // { // DataTable dt = ConnectionClass.Selectcommand("select max(salesMasterID) from Sales_Master"); // ConnectionClass.InsertCommand("insert into Sales_Details " + // " values ('" + // item.SubItems[0].Text + "','" + // item.SubItems[1].Text + "','" + // item.SubItems[2].Text + "','" + // item.SubItems[3].Text + "','" + // item.SubItems[4].Text + "','" + // dt.Rows[0][0].ToString() + "','True')"); // lblResponse.Text += "\nSales Detial Data Transfer Fails!"; // }//end foreach // PrintReport(); //}//end else #endregion #region internet status check was checked per item //detail list for transfer List <SalesDetail> salesDetailLst = new List <SalesDetail>(); foreach (var item in salesDetailLstLocal) { DataTable dt = ConnectionClass.Selectcommand("select max(salesMasterID) from Sales_Master"); SalesDetail salesDetail = new SalesDetail(); salesDetail.ProductID = item.ProductID; salesDetail.ProductName = item.ProductName; salesDetail.Quantity = item.Quantity; salesDetail.UnitPrice = item.UnitPrice; salesDetail.TotalPrice = item.TotalPrice; salesDetail.SalesMasterIDLocal = Convert.ToInt64(dt.Rows[0][0].ToString()); salesDetailLst.Add(salesDetail); } // MessageBox.Show(WebAPIResource.statusCodes); // lblHttpResponse.Text += WebAPIResource.statusCodes.ToString(); // List<SalesDetail> salesDetailList = new List<SalesDetail>(); Thread t1 = new Thread(() => { if (InternetConnection.IsConnectedToInternet()) { foreach (var item in salesDetailLst) { SalesDetail salesDetail = new SalesDetail(); DataTable dt = ConnectionClass.Selectcommand("select max(salesMasterID) from Sales_Master"); ConnectionClass.InsertCommand("insert into Sales_Details " + " values ('" + item.ProductID + "','" + item.ProductName + "','" + item.Quantity + "','" + item.UnitPrice + "','" + item.TotalPrice + "','" + dt.Rows[0][0].ToString() + "','True')"); } } else { foreach (var item in salesDetailLst) { SalesDetail salesDetail = new SalesDetail(); DataTable dt = ConnectionClass.Selectcommand("select max(salesMasterID) from Sales_Master"); ConnectionClass.InsertCommand("insert into Sales_Details " + " values ('" + item.ProductID + "','" + item.ProductName + "','" + item.Quantity + "','" + item.UnitPrice + "','" + item.TotalPrice + "','" + dt.Rows[0][0].ToString() + "','False')"); } /// PrintReport(); ////ClearItems(); // lblHttpResponse.Text += "not connected!"; } }); t1.Start(); t1.IsBackground = true; t1.Join(); //PrintReport(); ////Thread t2 = new Thread(() => ////{ //// PrintReport(); ////}); ////t2.Start(); ////t2.Join(); Thread t3 = new Thread(() => { if (InternetConnection.IsConnectedToInternet()) { foreach (var item in salesDetailLst) { OnlineActivities.SendOnlineSalesDetail(item.ProductID, item.ProductName, Convert.ToInt32(item.Quantity), item.UnitPrice, item.TotalPrice, item.SalesMasterIDLocal, InternetConnection.GetBusinessID(), InternetConnection.GetBusinessCode()); } } else { //update isconnected value to 0 in sales_details table where isConnected is equal to 1 recently SqlConnection conn = new SqlConnection(connStaticString); SqlCommand cmd = new SqlCommand("sp_InvertClientUpdateConnectionStatusInSales_Details", conn); conn.Open(); cmd.ExecuteNonQuery(); conn.Close(); // lblHttpResponse.Text += "not connected to internet"; } }); t3.Start(); t3.IsBackground = true; #endregion #region original //foreach (ListViewItem item in listView1.Items) //{ // if (InternetConnection.IsConnectedToInternet() && InternetConnection.CheckServerConnectivity(serverIP) == true) // { // DataTable dt = ConnectionClass.Selectcommand("select max(salesMasterID) from Sales_Master"); // //Stopwatch stopwatch = new Stopwatch(); // //stopwatch.Start(); // Task t1 = Task.Factory.StartNew(() => // { // ConnectionClass.InsertCommand("insert into Sales_Details " + // " values ('" + // item.SubItems[0].Text + "','" + // item.SubItems[1].Text + "','" + // item.SubItems[2].Text + "','" + // item.SubItems[3].Text + "','" + // item.SubItems[4].Text + "','" + // dt.Rows[0][0].ToString() + "','True')"); // }); // //stopwatch.Stop(); // ////long ts = stopwatch.Elapsed.Seconds; // ////lblTimeElapsed.Text = ts.ToString(); // Task t2 = t1.ContinueWith(antTask => // { // OnlineActivities.SendOnlineSalesDetail(Convert.ToInt64(item.SubItems[0].Text), item.SubItems[1].Text.ToString() // , Convert.ToInt32(item.SubItems[2].Text), // Convert.ToDecimal(item.SubItems[3].Text), // Convert.ToDecimal(item.SubItems[4].Text), // Convert.ToInt64(dt.Rows[0][0].ToString()), // InternetConnection.GetBusinessID(), InternetConnection.GetBusinessCode() // ); // }); // } // else // { // DataTable dt = ConnectionClass.Selectcommand("select max(salesMasterID) from Sales_Master"); // ConnectionClass.InsertCommand("insert into Sales_Details " + // " values ('" + // item.SubItems[0].Text + "','" + // item.SubItems[1].Text + "','" + // item.SubItems[2].Text + "','" + // item.SubItems[3].Text + "','" + // item.SubItems[4].Text + "','" + // dt.Rows[0][0].ToString() + "','True')"); // lblResponse.Text += "\nSales Detial Data Transfer Fails!"; // } //} #endregion }
private void Sale_Invoice_Activated(object sender, EventArgs e) { string httpResponseMessage = ""; Thread thSalesOffline = new Thread(() => { if (InternetConnection.IsConnectedToInternet() ) { //lblResponse.Text += "\n" + string s = OfflineActivities.SendVendorOfflineSalesDetail(); } else { // httpResponseMessage = "not connected to internet! No offline sale invoice upload!"; } }); thSalesOffline.Start(); thSalesOffline.Name = "SalesDetailThread"; thSalesOffline.IsBackground = true; //Task task1 = Task.Factory.StartNew(() => //{ // if(!InternetConnection.IsConnectedToInternet() // && WebAPIResource.CheckHttpStatusCode()==true) // { // //lblResponse.Text += "\n" + // string s = OfflineActivities.SendVendorOfflineSalesDetail(); // } // else // { // httpResponseMessage = "not connected to internet! No offline sale invoice upload!"; // } //}); Thread thDetailOffline = new Thread(() => { if (InternetConnection.IsConnectedToInternet() ) { // lblResponse.Text += "\n" + string s2 = OfflineActivities.SendVendorOfflineInvoices(); } else { // httpResponseMessage += "not connected to internet! No offline sale detail upload!"; } }); thDetailOffline.Start(); thDetailOffline.Name = "SalesInvoiceThread"; thDetailOffline.IsBackground = true; //Task task2 = task1.ContinueWith(antTask => // { // if (!InternetConnection.IsConnectedToInternet() // && WebAPIResource.CheckHttpStatusCode() == true) // { // // lblResponse.Text += "\n" + // string s2 = OfflineActivities.SendVendorOfflineInvoices(); // } // else // { // httpResponseMessage += "not connected to internet! No offline sale detail upload!"; // } // }); // lblHttpResponse.Text += httpResponseMessage.ToString(); }