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);
}
public string Create_Case_Creation_Json(long reqId, long resId, string fileupload, string clientID, string SBUID, string clientName)
{
string output = "";
DML_Utility objDML = new DML_Utility();
Get_Data_Utility objGet = new Get_Data_Utility();
try
{
string strRequest_Id = "";
string strCandidate_Id = "";
string strAssociate_Id = "";
List <tbl_requests> RequestID = objGet.Get_RequestID();
//objDML.Add_Exception_Log("Before", "");
decimal NewRequestID = RequestID[0].RequestID + 1;
//objDML.Add_Exception_Log("After", "");
// 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;
}
//Code Commented as we need only till download documents
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, fileupload, clientID, SBUID, clientName, ServiceId);
objDML.Add_Exception_Log(jsonFinal, "Json_Data");
string JsonDatRequests = Read_Json_DataForCaseCreation(jsonFinal, "Data", "CaseCreation", "clientSpecificFields");
objDML.Add_Exception_Log(JsonDatRequests, "Json_Data");
/////////////////////////// Add Json request into database //////////////
//objDML.Add_Exception_Log(lstFreshCase.Count().ToString(), Convert.ToString(NewRequestID));
//int ADDRequests = objDML.Insert_data_in_requests(Convert.ToString(NewRequestID), lstFreshCase, JsonDatRequests, clientID, SBUID);
jsonFinal = objFinal.Final_Create_Case_Json(MessageId, lstFreshCase, lstCollege, lstYet2StartData, lstMISLog, fileupload, clientID, SBUID, clientName, ServiceId, Convert.ToString(NewRequestID));
objDML.Insert_Json_in_requestracker(Convert.ToString(NewRequestID), jsonFinal);
int iDML = objDML.Add_Request_Json_Detail(MessageId, "CaseCreation", jsonFinal);
if (iDML == 1)
{
bool ret = objExe.Write_JSON_TO_ServerRABBIT_MQ(jsonFinal);
output = ret ? "Success" : "Failed";
objDML.Add_Exception_Log(output, "");
}
//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);
}
public string Create_Case_Creation_Json(long reqId, long resId, tbl_Wipro_Details CandidateDetails, string package, string Database_Sent, string PONumber, string fileupload, string clientID, string SBUID, string clientName, string sbuName, string PackageName)
{
string output = "";
DML_Utility objDML = new DML_Utility();
Get_Data_Utility objGet = new Get_Data_Utility();
try
{
string strRequest_Id = "";
string strCandidate_Id = "";
string strAssociate_Id = "";
// List<tbl_requests> RequestID = objGet.Get_RequestID();
//objDML.Add_Exception_Log("Before", "");
//decimal NewRequestID = RequestID[0].RequestID + 1;
//objDML.Add_Exception_Log("After", "");
// Get Data
JsonCreater objFinal = new JsonCreater();
string MessageId = Guid.NewGuid().ToString();
string ServiceId = "CaseCreation";// FilePath_Container.CaseCreation;
//fileupload = "";
string jsonFinal = objFinal.Final_Create_Case_Json(MessageId, CandidateDetails, package, Database_Sent, PONumber, fileupload, clientID, SBUID, clientName, ServiceId, sbuName: sbuName);
string jsonFinalForRequests = objFinal.Final_Create_Case_JsonForRequests(MessageId, CandidateDetails, package, Database_Sent, PONumber, fileupload, clientID, SBUID, clientName, ServiceId, sbuName: sbuName);
objDML.Add_Exception_Log("Wipro log : " + jsonFinal, "Json_Data");
string JsonDatRequests = Read_Json_DataForCaseCreation(jsonFinalForRequests, "Data", "CaseCreation", "clientSpecificFields");
objDML.Add_Exception_Log("Wipro log : " + JsonDatRequests, "Json_Data");
/////////////////////////// Add Json request into database //////////////
//objDML.Add_Exception_Log(lstFreshCase.Count().ToString(), Convert.ToString(NewRequestID));
string NewRequestID = "0";
int ADDRequests = objDML.Insert_data_in_requests(ref NewRequestID, CandidateDetails, JsonDatRequests, clientID, SBUID);
jsonFinal = objFinal.Final_Create_Case_Json(MessageId, CandidateDetails, package, Database_Sent, PONumber, fileupload, clientID, SBUID, clientName, ServiceId, RequestID: NewRequestID, sbuName: sbuName);
objDML.Insert_Json_in_requestracker(Convert.ToString(NewRequestID), jsonFinal);
objDML.Insert_Json_in_requesStateInstanse(Convert.ToInt64(NewRequestID), 1, "REQ-0002", 165, "Case Created by Touchless", 1, 5, 0);
//Uploading The downloaded files
string destinationPath = ConfigurationManager.AppSettings["destinationPath"] + "\\" + NewRequestID;
FileUtility fileUtility = new FileUtility();
List <string> copiedFiles = fileUtility.FileUpload(fileupload, destinationPath);
objDML.Add_Exception_Log("Wipro log : " + copiedFiles.Count + "Files Uploaded", "");
objDML.Insert_FilePathIndocument_upload(copiedFiles, Convert.ToInt64(NewRequestID));
objDML.Add_Exception_Log("Wipro log : " + "Files Path Inserted in database", NewRequestID.ToString());
objDML.Add_Exception_Log("Wipro log : " + "RequestInstance Created", NewRequestID.ToString());
objDML.updateWiproDetails(CandidateDetails.Candidte_Id, CandidateDetails.Check_Initiated, Convert.ToInt64(NewRequestID));
string packageID = objGet.getPackageID(PackageName, SBUID);
objDML.InsertPackageDetails(Convert.ToInt64(NewRequestID), packageID);
int iDML = objDML.Add_Request_Json_Detail(MessageId, "CaseCreation", jsonFinal);
ExecuteProcess objExe = new ExecuteProcess();
if (iDML == 1)
{
bool ret = objExe.Write_JSON_TO_ServerRABBIT_MQ(jsonFinal);
output = ret ? "Success" : "Failed";
objDML.Add_Exception_Log("Wipro log : " + output, "");
}
//bool ret = objExe.Write_JSON_TO_RABBIT_MQ(jsonFinal);
//output = ret ? "Success" : "Failed";
}
catch (Exception ex)
{
output = "ex";
//throw ex;
while (ex != null)
{
int iException = objDML.Add_Exception_Log("Wipro exception : " + ex.Message, "Create_Case_Creation_Json");
ex = ex.InnerException;
}
}
return(output);
}
