public string GetSMSCode(string phone)
{
object obj = new
{
timestamp = (DateTime.Now - DateTime.Parse("1970-01-01 00:00:00")).TotalMilliseconds,
mobile = phone
};
requestModel req = new requestModel()
{
pId = System.Configuration.ConfigurationManager.ConnectionStrings["pid"].ConnectionString,
encryptContent = AESHelper.AESEncrypt(JsonConvert.SerializeObject(obj))
};
try
{
string res = HttpWebResponseUtility.CreatePostDataResponse(System.Configuration.ConfigurationManager.ConnectionStrings["url"].ConnectionString +
System.Configuration.ConfigurationManager.ConnectionStrings["getsmscode"].ConnectionString, JsonConvert.SerializeObject(req));
responseModel response = JsonConvert.DeserializeObject <responseModel>(res);
if (response.status.Equals("success"))
{
AESHelper.AESDecrypt(response.encryptionBody);
SMSModel smsmodel = JsonConvert.DeserializeObject <SMSModel>(AESHelper.AESDecrypt(response.encryptionBody));
return(smsmodel.sms_code);
}
else
{
throw new Exception(response.message);
}
}
catch (Exception ex)
{
throw ex;
}
}
public string getQR(QRModel qr)
{
qr.timestamp = (DateTime.Now - DateTime.Parse("1970-01-01 00:00:00")).TotalMilliseconds;
requestModel req = new requestModel()
{
pId = System.Configuration.ConfigurationManager.ConnectionStrings["pid"].ConnectionString,
encryptContent = AESHelper.AESEncrypt(JsonConvert.SerializeObject(qr))
};
try
{
string res = HttpWebResponseUtility.CreatePostDataResponse(System.Configuration.ConfigurationManager.ConnectionStrings["url"].ConnectionString +
System.Configuration.ConfigurationManager.ConnectionStrings["getqr"].ConnectionString, JsonConvert.SerializeObject(req));
responseModel response = JsonConvert.DeserializeObject <responseModel>(res);
if (response.status.Equals("success"))
{
return(response.qr_image);
}
else
{
throw new Exception(response.message);
}
}
catch (Exception ex)
{
return(null);
}
}
public UserInfo getUserInfo(string openid)
{
var obj = new { timestamp = (DateTime.Now - DateTime.Parse("1970-01-01 00:00:00")).TotalMilliseconds, openId = openid };
requestModel req = new requestModel()
{
pId = System.Configuration.ConfigurationManager.ConnectionStrings["pid"].ConnectionString,
encryptContent = AESHelper.AESEncrypt(JsonConvert.SerializeObject(obj))
};
try
{
string res = HttpWebResponseUtility.CreatePostDataResponse(System.Configuration.ConfigurationManager.ConnectionStrings["url"].ConnectionString +
System.Configuration.ConfigurationManager.ConnectionStrings["userInfo"].ConnectionString, JsonConvert.SerializeObject(req));
log.Debug("获取用户信息：" + res);
responseModel response = JsonConvert.DeserializeObject <responseModel>(res);
if (response.status.Equals("success"))
{
log.Debug("解析用户信息：" + AESHelper.AESDecrypt(response.encryptionBody));
UserInfo userInfo = JsonConvert.DeserializeObject <UserInfo>(AESHelper.AESDecrypt(response.encryptionBody));
return(userInfo);
}
else
{
return(null);
}
}
catch (Exception ex)
{
return(null);
}
}
public bool ChangeEmail(string openId, string email)
{
object obj = new
{
timestamp = (DateTime.Now - DateTime.Parse("1970-01-01 00:00:00")).TotalMilliseconds,
email,
openId
};
requestModel req = new requestModel()
{
pId = System.Configuration.ConfigurationManager.ConnectionStrings["pid"].ConnectionString,
encryptContent = AESHelper.AESEncrypt(JsonConvert.SerializeObject(obj))
};
try
{
string res = HttpWebResponseUtility.CreatePostDataResponse(System.Configuration.ConfigurationManager.ConnectionStrings["url"].ConnectionString +
System.Configuration.ConfigurationManager.ConnectionStrings["changeemail"].ConnectionString, JsonConvert.SerializeObject(req));
responseModel response = JsonConvert.DeserializeObject <responseModel>(res);
if (response.status.Equals("success"))
{
return(true);
}
else
{
throw new Exception(response.message);
}
}
catch (Exception ex)
{
throw ex;
}
}
public static DataTable householdMappingProc(gswsModel obj)
{
try
{
List <inputModel> listInputObj = new List <inputModel>();
inputModel inputObj = new inputModel();
inputObj.paramName = "ptype"; inputObj.value = obj.type; inputObj.dataType = "Varchar2";
listInputObj.Add(inputObj);
inputModel inputObj1 = new inputModel();
inputObj1.paramName = "puid"; inputObj1.value = obj.uid; inputObj1.dataType = "Varchar2";
listInputObj.Add(inputObj1);
inputModel inputObj2 = new inputModel();
inputObj2.paramName = "pration"; inputObj2.value = obj.rationId; inputObj2.dataType = "Varchar2";
listInputObj.Add(inputObj2);
inputModel inputObj3 = new inputModel();
inputObj3.paramName = "phh_id"; inputObj3.value = obj.hhId; inputObj3.dataType = "Varchar2";
listInputObj.Add(inputObj3);
requestModel procObj = new requestModel();
procObj.refcursorName = "p_cur";
procObj.procedureName = "gsws_vv_hh_mapping_proc";
procObj.inputs = listInputObj;
procObj.key = key;
string json = JsonConvert.SerializeObject(procObj);
DataTable dt = dbRouter.POST_Request(gsws_oradb_prod, json);
if (dt != null && dt.Rows.Count > 0)
{
return(dt);
}
else
{
return(new DataTable());
}
}
catch (Exception ex)
{
throw ex;
}
}
public static DataTable unMappedRcHelperProc(pensionModel obj)
{
try
{
List <inputModel> listInputObj = new List <inputModel>();
inputModel inputObj = new inputModel();
inputObj.paramName = "p_type"; inputObj.value = obj.type; inputObj.dataType = "Varchar2";
listInputObj.Add(inputObj);
inputModel inputObj1 = new inputModel();
inputObj1.paramName = "p_cluster_id"; inputObj1.value = obj.cluster_id; inputObj1.dataType = "Varchar2";
listInputObj.Add(inputObj1);
inputModel inputObj2 = new inputModel();
inputObj2.paramName = "p_uid"; inputObj2.value = obj.uid; inputObj2.dataType = "Varchar2";
listInputObj.Add(inputObj2);
inputModel inputObj3 = new inputModel();
inputObj3.paramName = "p_secretariat"; inputObj3.value = obj.gsws_code; inputObj3.dataType = "Varchar2";
listInputObj.Add(inputObj3);
requestModel procObj = new requestModel();
procObj.refcursorName = "pcur";
procObj.procedureName = "GSWS_HH_NON_MAPPED1";
procObj.inputs = listInputObj;
procObj.key = key;
string json = JsonConvert.SerializeObject(procObj);
return(dbRouter.POST_Request(gswsRouterUrl, json));
}
catch (Exception ex)
{
string mappath = HttpContext.Current.Server.MapPath("unMappedRcHelperProc");
string serialized_data = JsonConvert.SerializeObject(obj);
Task WriteTask = Task.Factory.StartNew(() => new Logdatafile().Write_ReportLog_Exception(mappath, serialized_data));
throw ex;
}
}
public static bool citizenSubmissionProc(personList objList)
{
//Log when service failed
string logger = "";
try
{
logger += DateTime.Now.ToString() + " : counter initiated\n";
int count = 0;
string houseImage = "NA";
foreach (ResponseData obj in objList.responseData)
{
try
{
// For ekyc person household id not available so we're assigning tempId as household id in that case
if (string.IsNullOrEmpty(obj.HOUSEHOLD_ID))
{
obj.HOUSEHOLD_ID = objList.responseData[0].TEMP_ID;
logger += DateTime.Now.ToString() + "household id null so assigned temp id as household id : " + obj.HOUSEHOLD_ID + "\n";
}
//Date conversion when date not available or not in a correct format
string date = string.Empty;
if (!string.IsNullOrEmpty(obj.DOB_DT))
{
logger += DateTime.Now.ToString() + "dob is not null for this person : " + obj.UID_NUM + "\n";
if (obj.DOB_DT == "0")
{
date = "";
logger += DateTime.Now.ToString() + "dob is set to empty : " + obj.UID_NUM + "\n";
}
else if (obj.DOB_DT.Length >= 10)
{
date = obj.DOB_DT.Substring(0, 10).Replace('-', '/').ToString();
logger += DateTime.Now.ToString() + "dob is directly assigned changed format to dd-mm-yyyy : " + date + " : " + obj.UID_NUM + "\n";
}
else
{
//addition of zeros for 1-1-2001 to 01-01-2001
string[] dateParts = obj.DOB_DT.Split('-');
if (dateParts[0].Length == 1)
{
dateParts[0] = "0" + dateParts[0];
}
if (dateParts[1].Length == 1)
{
dateParts[1] = "0" + dateParts[1];
}
date = dateParts[0] + "/" + dateParts[1] + "/" + dateParts[2].Substring(0, 4).ToString();
logger += DateTime.Now.ToString() + "dob is changed from d-m-yyyy to dd-mm-yyyy : " + date + " : " + obj.UID_NUM + "\n";
}
}
List <inputModel> listInputObj = new List <inputModel>();
inputModel inputObj = new inputModel();
inputObj.paramName = "ptype"; inputObj.value = "1"; inputObj.dataType = "Varchar2";
listInputObj.Add(inputObj);
inputModel inputObj1 = new inputModel();
inputObj1.paramName = "pCITIZEN_NAME"; inputObj1.value = obj.CITIZEN_NAME; inputObj1.dataType = "Varchar2";
listInputObj.Add(inputObj1);
inputModel inputObj2 = new inputModel();
inputObj2.paramName = "pDISTRICT_CODE"; inputObj2.value = string.IsNullOrEmpty(obj.DISTRICT_CODE) ? "0" : obj.DISTRICT_CODE; inputObj2.dataType = "Varchar2";
listInputObj.Add(inputObj2);
inputModel inputObj29 = new inputModel();
inputObj29.paramName = "pDOB_DT"; inputObj29.value = date; inputObj29.dataType = "Date";
listInputObj.Add(inputObj29);
inputModel inputObj3 = new inputModel();
inputObj3.paramName = "pDOOR_NO"; inputObj3.value = obj.DOOR_NO; inputObj3.dataType = "Varchar2";
listInputObj.Add(inputObj3);
inputModel inputObj4 = new inputModel();
inputObj4.paramName = "pFATHER_AADHAAR"; inputObj4.value = obj.FATHER_AADHAAR; inputObj4.dataType = "Varchar2";
listInputObj.Add(inputObj4);
inputModel inputObj5 = new inputModel();
inputObj5.paramName = "pGENDER"; inputObj5.value = obj.GENDER; inputObj5.dataType = "Varchar2";
listInputObj.Add(inputObj5);
inputModel inputObj6 = new inputModel();
inputObj6.paramName = "pGSWS_CODE"; inputObj6.value = obj.SECRETARIAT_CODE; inputObj6.dataType = "Varchar2";
listInputObj.Add(inputObj6);
inputModel inputObj7 = new inputModel();
inputObj7.paramName = "pHOUSEHOLD_ID"; inputObj7.value = obj.HOUSEHOLD_ID; inputObj7.dataType = "Varchar2";
listInputObj.Add(inputObj7);
inputModel inputObj8 = new inputModel();
inputObj8.paramName = "pINSERTED_BY"; inputObj8.value = objList.insertedBy; inputObj8.dataType = "Varchar2";
listInputObj.Add(inputObj8);
inputModel inputObj9 = new inputModel();
inputObj9.paramName = "pINSERTED_ON"; inputObj9.value = DateTime.Now.ToString(); inputObj9.dataType = "TimeStamp";
listInputObj.Add(inputObj9);
inputModel inputObj10 = new inputModel();
inputObj10.paramName = "pIS_HOFAMILY"; inputObj10.value = obj.IS_HOFAMILY; inputObj10.dataType = "Varchar2";
listInputObj.Add(inputObj10);
inputModel inputObj11 = new inputModel();
inputObj11.paramName = "pIS_LIVING_WITHFAMILY"; inputObj11.value = string.IsNullOrEmpty(obj.IS_LIVING_WITHFAMILY) ? "0" : obj.IS_LIVING_WITHFAMILY; inputObj11.dataType = "Varchar2";
listInputObj.Add(inputObj11);
inputModel inputObj12 = new inputModel();
inputObj12.paramName = "pIS_MARRIED"; inputObj12.value = string.IsNullOrEmpty(obj.IS_MARRIED) ? "0" : obj.IS_MARRIED; inputObj12.dataType = "Varchar2";
listInputObj.Add(inputObj12);
inputModel inputObj13 = new inputModel();
inputObj13.paramName = "pIS_MEMBERADDED"; inputObj13.value = string.IsNullOrEmpty(obj.IS_MEMBERADDED) ? "0" : obj.IS_MEMBERADDED; inputObj13.dataType = "Varchar2";
listInputObj.Add(inputObj13);
inputModel inputObj14 = new inputModel();
inputObj14.paramName = "pIS_MEMBERDELETED"; inputObj14.value = string.IsNullOrEmpty(obj.IS_MEMBERDELETED) ? "0" : obj.IS_MEMBERDELETED; inputObj14.dataType = "Varchar2";
listInputObj.Add(inputObj14);
inputModel inputObj15 = new inputModel();
inputObj15.paramName = "pMANDAL_CODE"; inputObj15.value = string.IsNullOrEmpty(obj.MANDAL_CODE) ? "0" : obj.MANDAL_CODE; inputObj15.dataType = "Varchar2";
listInputObj.Add(inputObj15);
inputModel inputObj16 = new inputModel();
inputObj16.paramName = "pMOBILE_NUMBER"; inputObj16.value = obj.MOBILE_NUMBER; inputObj16.dataType = "Varchar2";
listInputObj.Add(inputObj16);
inputModel inputObj17 = new inputModel();
inputObj17.paramName = "pMOTHER_AADHAAR"; inputObj17.value = obj.MOTHER_AADHAAR; inputObj17.dataType = "Varchar2";
listInputObj.Add(inputObj17);
inputModel inputObj18 = new inputModel();
inputObj18.paramName = "pNEW_HH_ID"; inputObj18.value = ""; inputObj18.dataType = "Varchar2";
listInputObj.Add(inputObj18);
inputModel inputObj19 = new inputModel();
inputObj19.paramName = "pRELATION_WITHHOF"; inputObj19.value = obj.RELATION_WITHHOF; inputObj19.dataType = "Varchar2";
listInputObj.Add(inputObj19);
inputModel inputObj20 = new inputModel();
inputObj20.paramName = "pSPOUSE_AADHAAR"; inputObj20.value = obj.SPOUSE_AADHAAR; inputObj20.dataType = "Varchar2";
listInputObj.Add(inputObj20);
inputModel inputObj21 = new inputModel();
inputObj21.paramName = "pTEMP_ID"; inputObj21.value = objList.responseData[0].TEMP_ID; inputObj21.dataType = "Varchar2";
listInputObj.Add(inputObj21);
inputModel inputObj22 = new inputModel();
inputObj22.paramName = "pUID_NUM"; inputObj22.value = obj.UID_NUM; inputObj22.dataType = "Varchar2";
listInputObj.Add(inputObj22);
inputModel inputObj23 = new inputModel();
inputObj23.paramName = "pUPDATED_BY"; inputObj23.value = ""; inputObj23.dataType = "Varchar2";
listInputObj.Add(inputObj23);
inputModel inputObj24 = new inputModel();
inputObj24.paramName = "pUPDATED_ON"; inputObj24.value = DateTime.Now.ToString(); inputObj24.dataType = "TimeStamp";
listInputObj.Add(inputObj24);
inputModel inputObj25 = new inputModel();
inputObj25.paramName = "pHOUSE_IMAGE_PATH"; inputObj25.value = houseImage; inputObj25.dataType = "Varchar2";
listInputObj.Add(inputObj25);
inputModel inputObj26 = new inputModel();
inputObj26.paramName = "pCLUSTER_ID"; inputObj26.value = obj.CLUSTER_ID; inputObj26.dataType = "Varchar2";
listInputObj.Add(inputObj26);
inputModel inputObj27 = new inputModel();
inputObj27.paramName = "pCLUSTER_NAME"; inputObj27.value = obj.CLUSTER_NAME; inputObj27.dataType = "Varchar2";
listInputObj.Add(inputObj27);
inputModel inputObj28 = new inputModel();
inputObj28.paramName = "pMEMBER_STATUS"; inputObj28.value = obj.MAPPING_STATUS; inputObj28.dataType = "Varchar2";
listInputObj.Add(inputObj28);
requestModel procObj = new requestModel();
procObj.refcursorName = "p_cur";
procObj.procedureName = "GSWS_HH_VV_MAPP_INSERT_PROC";
procObj.inputs = listInputObj;
procObj.key = key;
string json = JsonConvert.SerializeObject(procObj);
logger += DateTime.Now.ToString() + "parameters assigned : " + json + "\n";
Random rd = new Random();
string rdNum = rd.Next(11111, 99999).ToString();
DataTable dt = dbRouter.POST_Request(gsws_oradb_prod, json);
if (dt != null && dt.Rows.Count > 0 && dt.Rows[0][0].ToString() == "1")
{
count++;
logger += DateTime.Now.ToString() + "record submitted successfully : " + json + "\n";
}
else
{
logger += DateTime.Now.ToString() + "record submission failed : " + json + "\n";
}
}
catch (Exception ex)
{
if (ex.Message.ToString().Contains("Object reference"))
{
Logdatafile.store(logger, "ObjectReferenceLogs", objList.responseData[0].TEMP_ID);
}
string serialized_data = JsonConvert.SerializeObject(objList);
string data = "{'exception' : '" + ex.Message.ToString() + "','data': '" + serialized_data + "'}";
Logdatafile.store(data, "citizenSubmissionIndividualExceptionLogs", obj.UID_NUM);
}
}
if (count == objList.responseData.Count)
{
return(true);
}
else
{
return(false);
}
}
catch (Exception ex)
{
if (ex.Message.ToString().Contains("Object reference"))
{
Logdatafile.store(logger, "ObjectReferenceLogs", objList.responseData[0].TEMP_ID);
}
string serialized_data = JsonConvert.SerializeObject(objList);
string data = "{'exception' : '" + ex.Message.ToString() + "','data': '" + serialized_data + "'}";
Logdatafile.store(data, "citizenSubmissionCompleteExceptionLogs", objList.responseData[0].TEMP_ID);
throw ex;
}
}
