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>");
}
}
protected void btn_Download_Click(object sender, EventArgs e)
{
// 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=PbHealthReport " + 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 - HEALTH 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();
}
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 + "");
}
}
//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 btn_Search_by_serial_no_Click(object sender, EventArgs e)
{
try
{
Reply objRes = new Reply();
// send request
using (WebClient client = new WebClient())
{
if (Session["Role"].ToString().ToLower().Contains("admin"))
{
perameter = "all##" + txt_SerialNo_searching.Text.Trim();
}
else
{
perameter = Session["Role"].ToString() + "#" + Session["Location"].ToString() + "#" + txt_SerialNo_searching.Text.Trim();
}
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 + "/GetRecentHealthReportSerialNumber", "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;
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;
}
}
