public string Create_Case_Creation_JsonOld(long reqId, long resId)
{
string output = "";
DML_Utility objDML = new DML_Utility();
try
{
string strRequest_Id = "";
string strCandidate_Id = "";
string strAssociate_Id = "";
// Get Data
ExecuteProcess objExe = new ExecuteProcess();
fadv_touchlessEntities entit = new fadv_touchlessEntities();
//tbl_yettostart_casecreation_data tbl = new tbl_yettostart_casecreation_data();
List <tbl_yettostart_casecreation_data> lstFreshCase = entit.tbl_yettostart_casecreation_data.Where(x => x.responseId == resId && x.queue_request_id == reqId).ToList <tbl_yettostart_casecreation_data>();
List <tbl_college_details> lstCollege = entit.tbl_college_details.Where(x => x.active == 1 && x.resid == resId && x.reqid == reqId).ToList <tbl_college_details>();
foreach (var obj in lstFreshCase)
{
strRequest_Id = obj.request_id;
strAssociate_Id = obj.associate_id;
strCandidate_Id = obj.candidate_id;
}
List <tbl_input_request_data> lstYet2StartData = entit.tbl_input_request_data.Where(x => x.Request_ID == strRequest_Id && x.Associate_Id == strAssociate_Id && x.Candidate_ID == strCandidate_Id).ToList <tbl_input_request_data>();
List <tbl_initiation_tracker> lstMISLog = entit.tbl_initiation_tracker.Where(x => x.request_id == strRequest_Id && x.associate_id == strAssociate_Id && x.candidate_id == strCandidate_Id).ToList <tbl_initiation_tracker>();
JsonCreater objFinal = new JsonCreater();
string MessageId = Guid.NewGuid().ToString();
string ServiceId = FilePath_Container.CaseCreation;
string jsonFinal = objFinal.Final_Create_Case_Json(MessageId, lstFreshCase, lstCollege, lstYet2StartData, lstMISLog, ServiceId, "", "", "");
/////////////////////////// Add Json request into database //////////////
int iDML = objDML.Add_Request_Json_Detail(MessageId, "CaseCreation", jsonFinal);
if (iDML == 1)
{
bool ret = objExe.Write_JSON_TO_RABBIT_MQ(jsonFinal);
output = ret ? "Success" : "Failed";
}
//bool ret = objExe.Write_JSON_TO_RABBIT_MQ(jsonFinal);
//output = ret ? "Success" : "Failed";
}
catch (Exception ex)
{
output = "ex";
//throw ex;
int iException = objDML.Add_Exception_Log(ex.Message, "");
}
return(output);
}
