JS CODE
function editDetails() {
loadMembers();
$.ajax({
type: "POST",
url: '../personalaccident/paindex.aspx/editDetails',
contentType: "application/json; charset=utf-8",
data: "{'id':'" + $("[id$='hdfGNP_ID']").val() + "','getEditedDataFromTemp':'" + _getEditedDataFromTemp + "'}",
dataType: "json",
async: false,
success: function (result) {
var objdata = $.parseJSON(result.d);
_DataFlg = 'E';
_mobileVerify = 1;
_getEditedDataFromTemp = 0;
$("#txtMobileNo").attr("disabled", "disabled");
document.getElementById('txtConfirmOTP').disabled = true;
document.getElementById('txtOTP').disabled = true;
document.getElementById('chkTandC').checked = true;
//$('#btnSendOTP').addClass('set-readonly');
$('#txtConfirmOTP').addClass('set-readonly');
$('#btnResendOTP').addClass('set-readonly');
var mem = '';
if (objdata.T0.length > 0) {
mem = mem + objdata.T0[0]['Relation'] + '(' + objdata.T0[0]['Age'] + '),';
if (objdata.T0[0]['Salutation'].toString() != '') {
$("#ddlSalutation").val(objdata.T0[0]['Salutation']);
//$("#ddlSalutation").selectpicker('val', objdata.T0[0]['Salutation']);
//$("#ddlSalutation option:" + objdata.T0[0]['Salutation'].toString() + "").attr('selected', 'selected');
}
else {
$("#ddlSalutation").val('Mr');
}
if (objdata.T0[0]['Name'] != '') {
$("#txtName").val(objdata.T0[0]['Name']);
}
else {
$("#txtName").val('');
}
if (objdata.T0[0]['EmailID'] != '') {
$("#txtEmail").val(objdata.T0[0]['EmailID']);
}
else {
$("#txtEmail").val('');
}
if (objdata.T0[0]['Mobile'] != '') {
$("#txtMobileNo").val(objdata.T0[0]['Mobile']);
}
else {
$("#txtMobileNo").val('');
}
if (objdata.T0[0]['SUMINSURE'] != '') {
$("#<%=ddlcoverageAmount.ClientID%> option:contains(" +AmountToINRFormat(objdata.T0[0]['SUMINSURE']) + ")").attr('selected', 'selected');
}
else {
$("#<%=ddlcoverageAmount.ClientID%> option:contains(Select coverage amount)").attr('selected', 'selected');
}
if (objdata.T0[0]['DOB'].toString() != '') {
$('#txtDOB').datetimepicker({
format: 'MM/DD/YYYY'
// maxDate: '01/01/2016',
});
//$("#txtDOB").val(objdata.T0[0]['DOB']);
$("#<%=txtDOB.ClientID%>").val(objdata.T0[0]['DOB'].toString());
}
else {
//$("#txtDOB").val('');
$("#<%=txtDOB.ClientID%>").val('');
}
}
if (objdata.T2.length > 0) {
if (objdata.T2[0]['TEXT'] != '') {
$("#txtCity").val(objdata.T2[0]['TEXT']);
}
else {
$("#txtCity").val('');
}
}
},
error: function (e) {
//alert(JSON.stringify(e));
alert("Something went wrong. Please try after sometime.");
}
});
}
Back End Side
[WebMethod]
public static string editDetails(string id, string getEditedDataFromTemp)
{
try
{
DataTable dtFMPA = (HttpContext.Current.Session["dtFMPA"]) as DataTable;
DataRow drFMDataPA = (HttpContext.Current.Session["drFMDataPA"]) as DataRow;
//DataTable dtOTPDataPA = (HttpContext.Current.Session["dtOTPDataPA"]) as DataTable;
//DataRow drOTPDataPA = (HttpContext.Current.Session["drOTPDataPA"]) as DataRow;
ConnectionDB connectionDB = new ConnectionDB();
DataSet ds = new DataSet();
SqlParameter[] pa = new SqlParameter[1];
pa[0] = new SqlParameter("@ID", Convert.ToInt32(id));
string sp = "GNP_EditInsurerDetails_H";
ds = connectionDB.GetData(sp, pa);
if (id == "0" || id == "")
{
DataRow dr = ds.Tables[0].NewRow();
ds.Tables[0].Rows.Add(dr);
//ds.Tables[0].Rows[0]["SelfID"] = drFMDataPA["selfId"];
//ds.Tables[0].Rows[0]["Age"] = drFMDataPA["selfCAmt"];
//ds.Tables[0].Rows[0]["DOB"] = drFMDataPA["SelfDOB"];
ds.Tables[0].Rows[0]["Scheme"] = drFMDataPA["schemeId"];
string s = drFMDataPA["arrRelId"].ToString().Substring(0, drFMDataPA["arrRelId"].ToString().Length - 1);
string[] words = s.Split(',');
string s1 = drFMDataPA["arrRelCAmt"].ToString().Substring(0, drFMDataPA["arrRelCAmt"].ToString().Length - 1);
string[] words1 = s1.Split(',');
string s2 = drFMDataPA["arrDOB"].ToString().Substring(0, drFMDataPA["arrDOB"].ToString().Length - 1);
string[] words2 = s2.Split(',');
for (int i = 0; i < words.Length; i++)
{
DataRow dr1 = ds.Tables[1].NewRow();
ds.Tables[1].Rows.Add(dr1);
ds.Tables[1].Rows[i]["RelationId"] = words[i];
ds.Tables[1].Rows[i]["Age"] = words1[i];
ds.Tables[1].Rows[i]["DOB"] = words2[i];
}
return CommonHelper.SerielizseDataset(ds).ToString();
}
else
{
if (getEditedDataFromTemp == "1")
{
if (ds.Tables[0] != null)
ds.Tables[0].Clear();
DataRow dr = ds.Tables[0].NewRow();
ds.Tables[0].Rows.Add(dr);
//ds.Tables[0].Rows[0]["SelfID"] = drFMDataPA["selfId"];
//ds.Tables[0].Rows[0]["Age"] = drFMDataPA["selfCAmt"];
//ds.Tables[0].Rows[0]["DOB"] = drFMDataPA["SelfDOB"];
ds.Tables[0].Rows[0]["Scheme"] = drFMDataPA["schemeId"];
string s = "";
string[] words = null;
if (drFMDataPA["arrRelId"].ToString().Length > 0)
{
s = drFMDataPA["arrRelId"].ToString().Substring(0, drFMDataPA["arrRelId"].ToString().Length - 1);
words = s.Split(',');
}
string s1 = "";
string[] words1 = null;
if (drFMDataPA["arrRelCAmt"].ToString().Length > 0)
{
s1 = drFMDataPA["arrRelCAmt"].ToString().Substring(0, drFMDataPA["arrRelCAmt"].ToString().Length - 1);
words1 = s1.Split(',');
}
string s2 = "";
string[] words2 = null;
if (drFMDataPA["arrDOB"].ToString().Length > 0)
{
s2 = drFMDataPA["arrDOB"].ToString().Substring(0, drFMDataPA["arrDOB"].ToString().Length - 1);
words2 = s2.Split(',');
}
if (ds.Tables[1] != null)
ds.Tables[1].Clear();
for (int i = 0; i < words.Length; i++)
{
DataRow dr1 = ds.Tables[1].NewRow();
ds.Tables[1].Rows.Add(dr1);
ds.Tables[1].Rows[i]["RelationId"] = words[i];
ds.Tables[1].Rows[i]["Age"] = words1[i];
ds.Tables[1].Rows[i]["DOB"] = words2[i];
}
}
else
{
if (ds != null)
{
if (dtFMPA != null)
{
dtFMPA.Clear();
}
dtFMPA = new DataTable();
dtFMPA.Columns.Add("selfId", typeof(string));
dtFMPA.Columns.Add("selfCAmt", typeof(string));
dtFMPA.Columns.Add("SelfDOB", typeof(string));
dtFMPA.Columns.Add("arrRelId", typeof(string));
dtFMPA.Columns.Add("arrRelCAmt", typeof(string));
dtFMPA.Columns.Add("arrDOB", typeof(string));
dtFMPA.Columns.Add("schemeId", typeof(string));
drFMDataPA = dtFMPA.NewRow();
//dtOTPDataPA.Clear();
//dtOTPDataPA = new DataTable();
//dtOTPDataPA.Columns.Add("OTP", typeof(string));
//dtOTPDataPA.Columns.Add("OTPTimest", typeof(string));
//dtOTPDataPA.Columns.Add("OTPStatus", typeof(string));
//drOTPDataPA = dtOTPDataPA.NewRow();
if (ds.Tables[0].Rows.Count > 0)
{
drFMDataPA["selfId"] = ds.Tables[0].Rows[0]["SelfID"].ToString();
drFMDataPA["schemeId"] = ds.Tables[0].Rows[0]["Scheme"].ToString();
//drOTPDataPA["OTP"] = ds.Tables[0].Rows[0]["OTP"].ToString();
//drOTPDataPA["OTPTimest"] = ds.Tables[0].Rows[0]["OTPTimest"].ToString();
//drOTPDataPA["OTPStatus"] = ds.Tables[0].Rows[0]["OTPStatus"].ToString();
//dtOTPDataPA.Rows.Add(drOTPDataPA);
}
if (ds.Tables[0].Rows.Count > 0)
{
string arrRelId = "", arrRelAgeId = "", arrRelAge = "";
for (int i = 0; i < ds.Tables[1].Rows.Count; i++)
{
arrRelId = arrRelId + ds.Tables[1].Rows[i]["RelationId"].ToString() + ",";
arrRelAgeId = arrRelAgeId + ds.Tables[1].Rows[i]["Age"].ToString() + ",";
arrRelAge = arrRelAge + ds.Tables[1].Rows[i]["DOB"].ToString() + ",";
}
drFMDataPA["arrRelId"] = arrRelId;
drFMDataPA["arrRelCAmt"] = arrRelAgeId;
drFMDataPA["arrDOB"] = arrRelAge;
}
dtFMPA.Rows.Add(drFMDataPA);
HttpContext.Current.Session["dtFMPA"] = dtFMPA;
HttpContext.Current.Session["drFMDataPA"] = drFMDataPA;
//HttpContext.Current.Session["dtOTPDataPA"] = dtOTPDataPA;
//HttpContext.Current.Session["drOTPDataPA"] = drOTPDataPA;
}
}
return CommonHelper.SerielizseDataset(ds).ToString();
}
}
catch (Exception ex)
{
CommonHelper.InsertErorLog((int)_Enums.Module.PersonalAccident, Convert.ToInt64(id), "personalaccident_paindex : editDetails()", ex.ToString());
return null;
}
}
Serialize Dataset
public static string SerielizseDataset(DataSet ds)
{
System.Web.Script.Serialization.JavaScriptSerializer Serielizse = new System.Web.Script.Serialization.JavaScriptSerializer();
List<Dictionary<string, object>> Rows = new List<Dictionary<string, object>>();
Dictionary<string, object> Row;
string str1 = "{";
for (int i = 0; i < ds.Tables.Count; i++)
{
Rows.Clear();
foreach (DataRow dr in ds.Tables[i].Rows)
{
Row = new Dictionary<string, object>();
foreach (DataColumn col in ds.Tables[i].Columns)
{
Row.Add(col.ColumnName, dr[col]);
}
Rows.Add(Row);
}
str1 = str1 + @"""T" + i + @""":" + Serielizse.Serialize(Rows) + ",";
}
return str1.Remove(str1.LastIndexOf(","), 1) + "}";
}
function editDetails() {
loadMembers();
$.ajax({
type: "POST",
url: '../personalaccident/paindex.aspx/editDetails',
contentType: "application/json; charset=utf-8",
data: "{'id':'" + $("[id$='hdfGNP_ID']").val() + "','getEditedDataFromTemp':'" + _getEditedDataFromTemp + "'}",
dataType: "json",
async: false,
success: function (result) {
var objdata = $.parseJSON(result.d);
_DataFlg = 'E';
_mobileVerify = 1;
_getEditedDataFromTemp = 0;
$("#txtMobileNo").attr("disabled", "disabled");
document.getElementById('txtConfirmOTP').disabled = true;
document.getElementById('txtOTP').disabled = true;
document.getElementById('chkTandC').checked = true;
//$('#btnSendOTP').addClass('set-readonly');
$('#txtConfirmOTP').addClass('set-readonly');
$('#btnResendOTP').addClass('set-readonly');
var mem = '';
if (objdata.T0.length > 0) {
mem = mem + objdata.T0[0]['Relation'] + '(' + objdata.T0[0]['Age'] + '),';
if (objdata.T0[0]['Salutation'].toString() != '') {
$("#ddlSalutation").val(objdata.T0[0]['Salutation']);
//$("#ddlSalutation").selectpicker('val', objdata.T0[0]['Salutation']);
//$("#ddlSalutation option:" + objdata.T0[0]['Salutation'].toString() + "").attr('selected', 'selected');
}
else {
$("#ddlSalutation").val('Mr');
}
if (objdata.T0[0]['Name'] != '') {
$("#txtName").val(objdata.T0[0]['Name']);
}
else {
$("#txtName").val('');
}
if (objdata.T0[0]['EmailID'] != '') {
$("#txtEmail").val(objdata.T0[0]['EmailID']);
}
else {
$("#txtEmail").val('');
}
if (objdata.T0[0]['Mobile'] != '') {
$("#txtMobileNo").val(objdata.T0[0]['Mobile']);
}
else {
$("#txtMobileNo").val('');
}
if (objdata.T0[0]['SUMINSURE'] != '') {
$("#<%=ddlcoverageAmount.ClientID%> option:contains(" +AmountToINRFormat(objdata.T0[0]['SUMINSURE']) + ")").attr('selected', 'selected');
}
else {
$("#<%=ddlcoverageAmount.ClientID%> option:contains(Select coverage amount)").attr('selected', 'selected');
}
if (objdata.T0[0]['DOB'].toString() != '') {
$('#txtDOB').datetimepicker({
format: 'MM/DD/YYYY'
// maxDate: '01/01/2016',
});
//$("#txtDOB").val(objdata.T0[0]['DOB']);
$("#<%=txtDOB.ClientID%>").val(objdata.T0[0]['DOB'].toString());
}
else {
//$("#txtDOB").val('');
$("#<%=txtDOB.ClientID%>").val('');
}
}
if (objdata.T2.length > 0) {
if (objdata.T2[0]['TEXT'] != '') {
$("#txtCity").val(objdata.T2[0]['TEXT']);
}
else {
$("#txtCity").val('');
}
}
},
error: function (e) {
//alert(JSON.stringify(e));
alert("Something went wrong. Please try after sometime.");
}
});
}
Back End Side
[WebMethod]
public static string editDetails(string id, string getEditedDataFromTemp)
{
try
{
DataTable dtFMPA = (HttpContext.Current.Session["dtFMPA"]) as DataTable;
DataRow drFMDataPA = (HttpContext.Current.Session["drFMDataPA"]) as DataRow;
//DataTable dtOTPDataPA = (HttpContext.Current.Session["dtOTPDataPA"]) as DataTable;
//DataRow drOTPDataPA = (HttpContext.Current.Session["drOTPDataPA"]) as DataRow;
ConnectionDB connectionDB = new ConnectionDB();
DataSet ds = new DataSet();
SqlParameter[] pa = new SqlParameter[1];
pa[0] = new SqlParameter("@ID", Convert.ToInt32(id));
string sp = "GNP_EditInsurerDetails_H";
ds = connectionDB.GetData(sp, pa);
if (id == "0" || id == "")
{
DataRow dr = ds.Tables[0].NewRow();
ds.Tables[0].Rows.Add(dr);
//ds.Tables[0].Rows[0]["SelfID"] = drFMDataPA["selfId"];
//ds.Tables[0].Rows[0]["Age"] = drFMDataPA["selfCAmt"];
//ds.Tables[0].Rows[0]["DOB"] = drFMDataPA["SelfDOB"];
ds.Tables[0].Rows[0]["Scheme"] = drFMDataPA["schemeId"];
string s = drFMDataPA["arrRelId"].ToString().Substring(0, drFMDataPA["arrRelId"].ToString().Length - 1);
string[] words = s.Split(',');
string s1 = drFMDataPA["arrRelCAmt"].ToString().Substring(0, drFMDataPA["arrRelCAmt"].ToString().Length - 1);
string[] words1 = s1.Split(',');
string s2 = drFMDataPA["arrDOB"].ToString().Substring(0, drFMDataPA["arrDOB"].ToString().Length - 1);
string[] words2 = s2.Split(',');
for (int i = 0; i < words.Length; i++)
{
DataRow dr1 = ds.Tables[1].NewRow();
ds.Tables[1].Rows.Add(dr1);
ds.Tables[1].Rows[i]["RelationId"] = words[i];
ds.Tables[1].Rows[i]["Age"] = words1[i];
ds.Tables[1].Rows[i]["DOB"] = words2[i];
}
return CommonHelper.SerielizseDataset(ds).ToString();
}
else
{
if (getEditedDataFromTemp == "1")
{
if (ds.Tables[0] != null)
ds.Tables[0].Clear();
DataRow dr = ds.Tables[0].NewRow();
ds.Tables[0].Rows.Add(dr);
//ds.Tables[0].Rows[0]["SelfID"] = drFMDataPA["selfId"];
//ds.Tables[0].Rows[0]["Age"] = drFMDataPA["selfCAmt"];
//ds.Tables[0].Rows[0]["DOB"] = drFMDataPA["SelfDOB"];
ds.Tables[0].Rows[0]["Scheme"] = drFMDataPA["schemeId"];
string s = "";
string[] words = null;
if (drFMDataPA["arrRelId"].ToString().Length > 0)
{
s = drFMDataPA["arrRelId"].ToString().Substring(0, drFMDataPA["arrRelId"].ToString().Length - 1);
words = s.Split(',');
}
string s1 = "";
string[] words1 = null;
if (drFMDataPA["arrRelCAmt"].ToString().Length > 0)
{
s1 = drFMDataPA["arrRelCAmt"].ToString().Substring(0, drFMDataPA["arrRelCAmt"].ToString().Length - 1);
words1 = s1.Split(',');
}
string s2 = "";
string[] words2 = null;
if (drFMDataPA["arrDOB"].ToString().Length > 0)
{
s2 = drFMDataPA["arrDOB"].ToString().Substring(0, drFMDataPA["arrDOB"].ToString().Length - 1);
words2 = s2.Split(',');
}
if (ds.Tables[1] != null)
ds.Tables[1].Clear();
for (int i = 0; i < words.Length; i++)
{
DataRow dr1 = ds.Tables[1].NewRow();
ds.Tables[1].Rows.Add(dr1);
ds.Tables[1].Rows[i]["RelationId"] = words[i];
ds.Tables[1].Rows[i]["Age"] = words1[i];
ds.Tables[1].Rows[i]["DOB"] = words2[i];
}
}
else
{
if (ds != null)
{
if (dtFMPA != null)
{
dtFMPA.Clear();
}
dtFMPA = new DataTable();
dtFMPA.Columns.Add("selfId", typeof(string));
dtFMPA.Columns.Add("selfCAmt", typeof(string));
dtFMPA.Columns.Add("SelfDOB", typeof(string));
dtFMPA.Columns.Add("arrRelId", typeof(string));
dtFMPA.Columns.Add("arrRelCAmt", typeof(string));
dtFMPA.Columns.Add("arrDOB", typeof(string));
dtFMPA.Columns.Add("schemeId", typeof(string));
drFMDataPA = dtFMPA.NewRow();
//dtOTPDataPA.Clear();
//dtOTPDataPA = new DataTable();
//dtOTPDataPA.Columns.Add("OTP", typeof(string));
//dtOTPDataPA.Columns.Add("OTPTimest", typeof(string));
//dtOTPDataPA.Columns.Add("OTPStatus", typeof(string));
//drOTPDataPA = dtOTPDataPA.NewRow();
if (ds.Tables[0].Rows.Count > 0)
{
drFMDataPA["selfId"] = ds.Tables[0].Rows[0]["SelfID"].ToString();
drFMDataPA["schemeId"] = ds.Tables[0].Rows[0]["Scheme"].ToString();
//drOTPDataPA["OTP"] = ds.Tables[0].Rows[0]["OTP"].ToString();
//drOTPDataPA["OTPTimest"] = ds.Tables[0].Rows[0]["OTPTimest"].ToString();
//drOTPDataPA["OTPStatus"] = ds.Tables[0].Rows[0]["OTPStatus"].ToString();
//dtOTPDataPA.Rows.Add(drOTPDataPA);
}
if (ds.Tables[0].Rows.Count > 0)
{
string arrRelId = "", arrRelAgeId = "", arrRelAge = "";
for (int i = 0; i < ds.Tables[1].Rows.Count; i++)
{
arrRelId = arrRelId + ds.Tables[1].Rows[i]["RelationId"].ToString() + ",";
arrRelAgeId = arrRelAgeId + ds.Tables[1].Rows[i]["Age"].ToString() + ",";
arrRelAge = arrRelAge + ds.Tables[1].Rows[i]["DOB"].ToString() + ",";
}
drFMDataPA["arrRelId"] = arrRelId;
drFMDataPA["arrRelCAmt"] = arrRelAgeId;
drFMDataPA["arrDOB"] = arrRelAge;
}
dtFMPA.Rows.Add(drFMDataPA);
HttpContext.Current.Session["dtFMPA"] = dtFMPA;
HttpContext.Current.Session["drFMDataPA"] = drFMDataPA;
//HttpContext.Current.Session["dtOTPDataPA"] = dtOTPDataPA;
//HttpContext.Current.Session["drOTPDataPA"] = drOTPDataPA;
}
}
return CommonHelper.SerielizseDataset(ds).ToString();
}
}
catch (Exception ex)
{
CommonHelper.InsertErorLog((int)_Enums.Module.PersonalAccident, Convert.ToInt64(id), "personalaccident_paindex : editDetails()", ex.ToString());
return null;
}
}
Serialize Dataset
public static string SerielizseDataset(DataSet ds)
{
System.Web.Script.Serialization.JavaScriptSerializer Serielizse = new System.Web.Script.Serialization.JavaScriptSerializer();
List<Dictionary<string, object>> Rows = new List<Dictionary<string, object>>();
Dictionary<string, object> Row;
string str1 = "{";
for (int i = 0; i < ds.Tables.Count; i++)
{
Rows.Clear();
foreach (DataRow dr in ds.Tables[i].Rows)
{
Row = new Dictionary<string, object>();
foreach (DataColumn col in ds.Tables[i].Columns)
{
Row.Add(col.ColumnName, dr[col]);
}
Rows.Add(Row);
}
str1 = str1 + @"""T" + i + @""":" + Serielizse.Serialize(Rows) + ",";
}
return str1.Remove(str1.LastIndexOf(","), 1) + "}";
}
No comments:
Post a Comment