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();
}
