public IHttpActionResult dataSubmission(dynamic data)
{
dynamic objdata = new ExpandoObject();
try
{
string serialized_data = token_gen.Authorize_aesdecrpty(data);
Logdatafile.store(serialized_data, "dataSubmissionnLogs");
personList rootobj = JsonConvert.DeserializeObject <personList>(serialized_data);
return(Ok(householdMappingHelper.dataSubmission(rootobj)));
}
catch (Exception ex)
{
string serialized_log_data = JsonConvert.SerializeObject(data);
string logData = "{'exception' : '" + ex.Message.ToString() + "','data': '" + serialized_log_data + "'}";
Logdatafile.store(logData, "OuterdataSubmissionLogs");
objdata.status = 500;
objdata.result = ex.Message.ToString();
}
return(Ok(objdata));
}
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 = string.IsNullOrEmpty(obj.IS_HOFAMILY) ? "0" : 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;
}
}