|
Following is the code for jqgrid -
html page-
<!DOCTYPE html>
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<script src="Scripts/JQGridReq/jquery-1.9.0.min.js"></script>
<link href="Scripts/JQGridReq/jquery-ui-1.9.2.custom.css" rel="stylesheet" />
<script src="Scripts/JQGridReq/jquery.jqGrid.js"></script>
<link href="Scripts/JQGridReq/ui.jqgrid.css" rel="stylesheet" />
<script src="Scripts/JQGridReq/grid.locale-en.js"></script>
<title>
jQuery("#jqGrid").jqGrid({
url: 'Handler1.ashx',
datatype: "json",
colNames: ['S_Course_Name', 'S_Course_Desc'],
colModel: [
{ name: 'S_Course_Name', index: 'S_Course_Name', width: 50, stype: 'text', editable: true },
{ name: 'S_Course_Desc', index: 'S_Course_Desc', width: 80, stype: 'text', sortable: true, editable: true }
],
rowNum: 10,
mtype: 'GET',
loadonce: true,
rowList: [10, 20, 30],
pager: '#Pager',
sortname: 'S_Course_Name',
viewrecords: true,
sortorder: 'desc',
caption: "Course Detail",
width: 500,
editurl: 'Handler1.ashx'
});
$('#jqGrid').jqGrid('navGrid', '#Pager',
{
edit: true,
add: false,
del: true,
search: true,
searchtext: "Search",
addtext: "Add",
edittext: "Edit",
deltext: "Delete"
},
{ //EDIT
// height: 300,
// width: 400,
// top: 50,
// left: 100,
// dataheight: 280,
closeOnEscape: true, //Closes the popup on pressing escape key
reloadAfterSubmit: true,
drag: true,
afterSubmit: function (response, postdata) {
if (response.responseText == "") {
$(this).jqGrid('setGridParam', { datatype: 'json' }).trigger('reloadGrid'); //Reloads the grid after edit
return [true, '']
}
else {
$(this).jqGrid('setGridParam', { datatype: 'json' }).trigger('reloadGrid'); //Reloads the grid after edit
return [false, response.responseText]//Captures and displays the response text on th Edit window
}
},
editData: {
EmpId: function () {
var sel_id = $('#jqGrid').jqGrid('getGridParam', 'selrow');
var value = $('#jqGrid').jqGrid('getCell', sel_id, 'S_Course_Name');
return value;
}
}
},
{
closeAfterAdd: true, //Closes the add window after add
afterSubmit: function (response, postdata) {
if (response.responseText == "") {
$(this).jqGrid('setGridParam', { datatype: 'json' }).trigger('reloadGrid')//Reloads the grid after Add
return [true, '']
}
else {
$(this).jqGrid('setGridParam', { datatype: 'json' }).trigger('reloadGrid')//Reloads the grid after Add
return [false, response.responseText]
}
}
},
{ //DELETE
closeOnEscape: true,
closeAfterDelete: true,
reloadAfterSubmit: true,
closeOnEscape: true,
drag: true,
afterSubmit: function (response, postdata) {
if (response.responseText == "") {
$("#jqGrid").trigger("reloadGrid", [{ current: true }]);
return [false, response.responseText]
}
else {
$(this).jqGrid('setGridParam', { datatype: 'json' }).trigger('reloadGrid');
return [true, response.responseText]
}
},
delData: {
EmpId: function () {
var sel_id = $('#jqGrid').jqGrid('getGridParam', 'selrow');
var value = $('#jqGrid').jqGrid('getCell', sel_id, 'S_Course_Name');
return value;
}
}
},
{//SEARCH
closeOnEscape: true
}
);
Handler1.ashx.cs-
public class Handler1 : IHttpHandler
{
public void ProcessRequest(HttpContext context)
{
context.Response.ContentType = "application/json";
System.Collections.Specialized.NameValueCollection forms = context.Request.Form;
string strOperation = forms.Get("oper");
string strResponse = string.Empty;
if (strOperation == null)
{
DataTable dt = getCourseDetail();
var jsonSerializer = new JavaScriptSerializer();
context.Response.Write(jsonSerializer.Serialize(GetCourseDetailListFromDataTable(dt)));
}
else if (strOperation == "del")
{
//var query = Query.EQ("_id", forms.Get("EmpId").ToString());
//collectionEmployee.Remove(query);
//strResponse = "Employee record successfully removed";
//context.Response.Write(strResponse);
}
else
{
//string strOut = string.Empty;
//AddEdit(forms, collectionEmployee, out strOut);
//context.Response.Write(strOut);
}
}
public bool IsReusable
{
get
{
return false;
}
}
public static DataTable getCourseDetail()
{
string strConnection = System.Configuration.ConfigurationManager.ConnectionStrings["connectionstring"].ToString();
using (SqlConnection con = new SqlConnection(strConnection))
{
con.Open();
SqlCommand sqlcomm = new SqlCommand("SELECT TOP 5 S_Course_Name,S_Course_Desc FROM T_Course_Master", con);
//SqlCommand sqlcomm = new SqlCommand("SELECT TOP 10 I_Course_ID,I_CourseFamily_ID,S_Course_Code,S_Course_Name,S_Course_Desc FROM T_Course_Master", con);
SqlDataAdapter da = new SqlDataAdapter(sqlcomm);
DataTable table = new DataTable();
da.Fill(table);
//string data = GetJson(table);
//return data;
return table;
}
}
public static string GetJson(DataTable dt)
{
System.Web.Script.Serialization.JavaScriptSerializer serializer = new System.Web.Script.Serialization.JavaScriptSerializer();
List> rows = new List>();
Dictionary row;
foreach (DataRow dr in dt.Rows)
{
row = new Dictionary();
foreach (DataColumn col in dt.Columns)
{
row.Add(col.ColumnName, dr[col]);
}
rows.Add(row);
}
return serializer.Serialize(rows);
}
private List GetCourseDetailListFromDataTable(DataTable dt)
{
//List type object of the property class
List courseDetailClass = new List();
foreach (DataRow dr in dt.Rows)
{
//Object of the propery class
CourseDetail objCourseDetail = new CourseDetail();
//asign values
objCourseDetail.S_Course_Name = dr["S_Course_Name"].ToString();
objCourseDetail.S_Course_Desc = dr["S_Course_Desc"].ToString();
//add one row to the list
courseDetailClass.Add(objCourseDetail);
}
//return final list
return courseDetailClass;
}
method is getting called but data is not displayed in the grid.I m getting the json string also proper format. kindly some help on this.
|
|
|
|
|
Please edit this, remove all the code not relevant to the problem, and explain where the problem occurs. Also ensure all your code is within <pre></pre> tags so it is readable.
|
|
|
|
|
Hello Guys,
Any urgent help on this would be highly appreciated. am about to start working on a project which involves retrieving data from a remote API. its gonna be a web-project whereby a user already registered on a desktop application would be able to view their basic and other information on a website.
i understand i need to make API calls to be able to make the information saved on the desktop database available for the user on the web. but i dont how to start.
Please i need guidelines/tutorials/help to kick-off.
thanks in advance.
IsoftTech
|
|
|
|
|
The database for your website will not be saved on the desktop, instead it will be present on the server of your hosting provider (or if you're hosting it yourself, then on your own hosting system). Secondly, API calls, and the simple website has a difference. API calls are used, when you allow third-party applications to use your own framework and let them use the data of the user. Since it is your own application why do you need to create an API?
If you're going to create a desktop application for your website, then yes, you will need an API because now your desktop application would be as a third-party client accessing the data.
The sh*t I complain about
It's like there ain't a cloud in the sky and it's raining out - Eminem
~! Firewall !~
|
|
|
|
|
Hi,
I am trying to use OUT parameter with PDO and PHP to return an email address from my stored pocedure but getting this error:
Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[42000]: Syntax error or access violation: 1414 OUT or INOUT argument 13 for routine hrms.sp_web_add_new_employee_leave is not a variable or NEW pseudo-variable in BEFORE trigger' in /home/jassimuser/mybluefile.com/submit_leave.php:37 Stack trace: #0 /home/jassimuser/mybluefile.com/submit_leave.php(37): PDOStatement->execute() #1 {main} thrown in /home/jassimuser/mybluefile.com/submit_leave.php on line 37
this is my code:
$mysql_query = $mysql_connection->prepare('CALL sp_web_add_new_employee_leave(:param_employee_id, :param_is_paid, :param_category, :param_payment, :param_date_from, :param_date_to, :param_total_days, :param_flight_entitlement, :param_flight_destination, :param_address_while_traveling, :param_leave_remarks, :param_created_user, :reporting_to_email)');
$mysql_query->bindParam(':param_employee_id', $_SESSION["employee_number"], PDO::PARAM_STR);
$mysql_query->bindParam(':param_is_paid', $leave_paid, PDO::PARAM_BOOL);
$mysql_query->bindParam(':param_category', $leave_category, PDO::PARAM_STR);
$mysql_query->bindParam(':param_payment', $leave_payment, PDO::PARAM_STR);
$mysql_query->bindParam(':param_date_from', $leave_from, PDO::PARAM_STR);
$mysql_query->bindParam(':param_date_to', $leave_to, PDO::PARAM_STR);
$mysql_query->bindParam(':param_total_days', $leave_days, PDO::PARAM_STR);
$mysql_query->bindParam(':param_flight_entitlement', $flight_entitlement, PDO::PARAM_STR);
$mysql_query->bindParam(':param_flight_destination', $flight_destination, PDO::PARAM_STR);
$mysql_query->bindParam(':param_address_while_traveling', $address_while_traveling, PDO::PARAM_STR);
$mysql_query->bindParam(':param_leave_remarks', $leave_comment, PDO::PARAM_STR);
$mysql_query->bindParam(':param_created_user', $_SESSION["employee_number"], PDO::PARAM_STR);
$mysql_query->bindParam(':reporting_to_email', $reporting_to_email, PDO::PARAM_STR|PDO::PARAM_INPUT_OUTPUT, 255);
$mysql_query->execute();
and line 37 is the ->execute()
How can I fix this please?
Technology News @ www.JassimRahma.com
|
|
|
|
|
Do you understand the error?
There are only 10 types of people in the world, those who understand binary and those who don't.
|
|
|
|
|
What if my take over the world project involve people partaking of their money for my benefit?!
I'd like to provide payment options on my website (no evil paypal please) and I have no idea how!
Any tip about which payment broker I could use please?
|
|
|
|
|
PayPal would be a good choice (Google Wallet can also be taken into considerations), but since you're having "take over the world", there won't be anything left and thus you would have to write your own. 
The sh*t I complain about
It's like there ain't a cloud in the sky and it's raining out - Eminem
~! Firewall !~
|
|
|
|
|
Google Wallet, interesting...
Though it's for a Windows Desktop app, not sure it will help much...
|
|
|
|
|
Oh, then don't you know about System.Net namespace collection? You can use these namespaces in your applications to create HttpRequests to the internet applications such as Google Wallet API.
System.Net namespaces are very helpful in working with networks and ports, you can read more on this at MSDN[^].
The sh*t I complain about
It's like there ain't a cloud in the sky and it's raining out - Eminem
~! Firewall !~
|
|
|
|
|
How about a link to Google Wallet API page instead!? 
|
|
|
|
|
That would consume the WebClient by you, or you would need to include a WebBrowser control. Which also would make the HTTP requests to your desired web page (which is the Google Wallet API web page). You know this is a cycle that starts and ends at the very same point, the System.Net namespace.
I would go with programming my own control and getting the response from the server using either a WebClient, or by downloading the response stream. 
The sh*t I complain about
It's like there ain't a cloud in the sky and it's raining out - Eminem
~! Firewall !~
|
|
|
|
|
Super Lloyd wrote: people partaking of their money for my benefit
"Partaking[^]" is the wrong word - you're suggesting that they either participate in, or take a share of their money, neither of which would involve them handing any money over to you.
Either "people parting with their money" or "people being relieved of their money" would work.
"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer
|
|
|
|
|
While it doesn't address my issue, I have t o admit you are indeed write!
Thanks for the correction!
Me trying to chew more English than I yet understand!   
|
|
|
|
|
Hi,
I am getting the following error after uploading the file to the host:
Warning: session_start(): Cannot send session cookie - headers already sent by (output started at /home/jassimuser/mybluefile.com/login_user.php:1) in /home/jassimuser/mybluefile.com/includes/php_header.php on line 3
Warning: session_start(): Cannot send session cache limiter - headers already sent (output started at /home/jassimuser/mybluefile.com/login_user.php:1) in /home/jassimuser/mybluefile.com/includes/php_header.php on line 3
Warning: Cannot modify header information - headers already sent by (output started at /home/jassimuser/mybluefile.com/login_user.php:1) in /home/jassimuser/mybluefile.com/login_user.php on line 52
but it's working fine on my localhost.
login_user start like this:
include('includes/php_header.php');
include($_SESSION["bluefile_absolute_path"] . '/includes/Mobile_Detect.php');
include($_SESSION["bluefile_absolute_path"] . '/includes/password_hash.php');
include($_SESSION["bluefile_absolute_path"] . '/includes/connect2db.php');
and my php_header is:
ob_start();
if(!isset($_SESSION)) { session_start(); }
$_SESSION["bluefile_absolute_path"] = $_SERVER["DOCUMENT_ROOT"];
$_SESSION["bluefile_domain_name"] = "http://www.mybluefile.com/";
$_SESSION["div_max_width"] = "700";
ini_set('max_execution_time', 300);
ini_set("session.cookie_lifetime","3600");
ini_set('display_errors', 1);
ini_set('display_startup_errors', 1);
error_reporting(E_ALL & ~E_NOTICE);
Technology News @ www.JassimRahma.com
|
|
|
|
|
Dunno which forum to ask, so I thought I would ask here...
Warning this question contains and requires 0 code and requires 0 code answer! 
I am working a super secret take over the world desktop application!
I created an installer for it as well as a WebSite.
I just bought a SSL certificate for my website and I can access it with HTTPS
Shouldn't there be some way for me to use that SSL certification to sign my MSI/Installer for the app?
I dunno what exactly is the SSL certificate... my website now accept HTTPS without security prompt but I didn't get any particular file...
Any clues?
Thanks!
|
|
|
|
|
An SSL certificate will usually have the "key usage" restricted to "server authentication" (and possibly "client authentication"). That means you can't use it for code-signing, email protection, time-stamping or OCSP signing.
RFC5280 Section 4.2.1.12 - Extended Key Usage[^]
"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer
|
|
|
|
|
|
In theory a SSL certificate can be used to digitally sign files/code, however it depends on the properties of that SSL certificate...
The SSL have to have keyUsage.digitalSignature flag to set to use it for file signing, and extendedKeyUsage.codeSigning for code signing...
As you bought the SSL for web site (probably via your host) you will not have these flags set...
You may ask to extend the certificate or get a new one for file/code signing...
Skipper: We'll fix it.
Alex: Fix it? How you gonna fix this?
Skipper: Grit, spit and a whole lotta duct tape.
|
|
|
|
|
Oh, they told me they are gonna send me the CERT file and private key, will see if it helps!
|
|
|
|
|
Then a zero-level confusing answer for you. No you cannot use that SSL certificate to digitally sign your emails etc.
The sh*t I complain about
It's like there ain't a cloud in the sky and it's raining out - Eminem
~! Firewall !~
|
|
|
|
|
No worries! My hosting provider helped! :P
|
|
|
|
|
On my website I am using bootstrap tabs[^].
It's a lot of verbose HTML to write...
(not to mention the need to write unique id by hand)
Really what I would like to, is torture KnockoutJS[^] or VueJS[^] (please, no AngularJS... unless you have a fully working sample! ) so that I can create some sort of component that I can initialize like that (i.e. data binding optional! i.e. not mandatory! inline html in my sample!)
<rs-tabpanel>
<rs-tabheader> Header 1 </rs-tabheader>
<rs-tabitem> <b>Content</b> 1 </rs-tabitem>
<rs-tabheader> Header 2 </rs-tabheader>
<rs-tabitem> <b>Content</b> 2 </rs-tabitem>
</rs-tabpanel>
And it will output the right HTML for me!
Any tips? suggestions? links? code sample?
Thanks! 
[EDIT] My question is about how to implement this markup syntax!
I know I could probably do it with some almost not clucky databinding...
I already know how!
Today I want to go further... And implement a nice markup syntax!
modified 25-Jan-15 5:19am.
|
|
|
|
|
I found a way!!!
Say I want to render that:
<rs-tabpanel>
<tab>
<header>01</header>
<content>tab 01</content>
</tab>
<tab>
<header>02 <i>hehe</i></header>
<content>no worries!</content>
</tab>
<tab>
<header>hah</header>
<content><b>uit's alive</b></content>
</tab>
<tab>
<header>foo</header>
<content>snafu!</content>
</tab>
</rs-tabpanel>
I used the following TypeScript VueJS component
function guid(): string {
var d = Date.now();
var uuid = 'xxxxxxxx-xxxx-4xxx-yxxx-xxxxxxxxxxxx'.replace(/[xy]/g, function (c) {
var r = (d + Math.random() * 16) % 16 | 0;
d = Math.floor(d / 16);
return (c == 'x' ? r : (r & 0x3 | 0x8)).toString(16);
});
return uuid;
}
function createHTML(name: string, attributes: any): HTMLElement {
var res = document.createElement(name);
for (var k in attributes) {
res.setAttribute(k, attributes[k]);
}
return res;
}
module RSComponents {
export class RSTabPanel extends Vue {
constructor(options: any) {
var init = {
template: '#RSTabPanel',
};
$.extend(options, init);
var el: HTMLElement = options.el;
if (el.children.length > 0) {
var panel = createHTML('div', { role: 'tabpanel', class: 'panel panel-default' });
var headers = createHTML('ul', { role: 'tablist', class: 'nav nav-tabs' });
var contents = createHTML('div', { class: 'tab-content panel-body' });
for (var i = 0; i < el.children.length; i++) {
var item: HTMLUnknownElement = <HTMLUnknownElement>el.children[i];
var h: HTMLUnknownElement = <HTMLUnknownElement>item.children.item(0);
var c: HTMLUnknownElement = <HTMLUnknownElement>item.children.item(1);
var uid = guid();
var attrs: any = { role: 'presentation' };
if (i == 0) attrs['class'] = 'active';
var he = createHTML('li', attrs);
var heLink = createHTML('a', { href: '#' + uid, role: "tab", 'data-toggle': 'tab' });
heLink.innerHTML = h.innerHTML;
he.appendChild(heLink);
attrs = { role: 'tabpanel', class: 'tab-pane', id: uid };
if (i == 0) attrs['class'] += ' active';
var ce = createHTML('li', attrs);
ce.innerHTML = c.innerHTML;
headers.appendChild(he);
contents.appendChild(ce);
}
panel.appendChild(headers);
panel.appendChild(contents);
options.template = panel.outerHTML;
}
super(options);
}
}
Vue.component('rs-tabpanel', RSTabPanel);
}
The important bit here, I replace the template option is there are children in my component!
modified 25-Jan-15 5:13am.
|
|
|
|
|
Did you realized that you wrote like 50 lines of code to create a 10 line HTML?
That's hardly 'templating' ...
Anyway it works for you so it is good!!!
You may missed this however: http://knockoutjs.com/documentation/template-binding.html[^]
Skipper: We'll fix it.
Alex: Fix it? How you gonna fix this?
Skipper: Grit, spit and a whole lotta duct tape.
|
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
