public string addData_YetToStart(DataTable dt, string strDateKey) { string Msg = ""; DML_Utility objDML = new DML_Utility(); fadv_touchlessEntities entit = new fadv_touchlessEntities(); tbl_input_request_data tbl = new tbl_input_request_data(); List <tbl_input_request_data> lst = new List <tbl_input_request_data>(); try { foreach (DataRow dr in dt.Rows) { tbl = new tbl_input_request_data(); tbl.Account = dr["Account"].ToString().Trim(); tbl.Account_Group = dr["Account Group"].ToString().Trim(); tbl.Additional_Payment_Status = dr["Additional Payment Status"].ToString().Trim(); tbl.Associate_Id = dr["AssociateId"].ToString().Trim(); tbl.BGV_Type = dr["BGV Type"].ToString().Trim(); tbl.BU = dr["BU"].ToString().Trim(); tbl.Candidate_ID = dr["CandidateId"].ToString().Trim(); tbl.CE_Available = dr["CE Available(Yes/No)"].ToString().Trim(); tbl.CE_BGV_Initiated_Date = dr["CE-BGV Initiated date"].ToString().Trim(); tbl.Components = dr["Components"].ToString().Trim(); tbl.Department = dr["Department"].ToString().Trim(); tbl.DOJ = dr["DOJ"].ToString().Trim(); tbl.HR_POC = dr["HR POC"].ToString().Trim(); tbl.Last_Updated_On = dr["Last Updated On"].ToString().Trim(); tbl.Name = dr["Name"].ToString().Trim(); tbl.Pre_BGV_Initiated_Date = dr["Pre-BGV Initiated Date"].ToString().Trim(); tbl.Project = dr["Project"].ToString().Trim(); tbl.Report_uploaded_date = dr["Report uploaded date"].ToString().Trim(); //tbl.Request_Date = dr["Date1"].ToString().Trim(); tbl.Request_ID = dr["RequestId"].ToString().Trim(); tbl.Vendor_Status = dr["Vendor Status"].ToString().Trim(); tbl.Work_Location = dr["Work Location"].ToString().Trim(); tbl.ImportKey = Convert.ToInt64(strDateKey.ToString()); lst.Add(tbl); } entit.tbl_input_request_data.AddRange(lst); entit.SaveChanges(); Msg = "OK"; } catch (Exception ex) { Msg = "ex"; objDML.Add_Exception_Log(ex.Message, ""); throw ex; } return(Msg); }
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 int addData(DataTable dt) { int intValue = 0; fadv_touchlessEntities entit = new fadv_touchlessEntities(); tbl_initiation_tracker tbl = new tbl_initiation_tracker(); List <tbl_initiation_tracker> lst = new List <tbl_initiation_tracker>(); try { foreach (DataRow dr in dt.Rows) { tbl = new tbl_initiation_tracker(); tbl.request_id = dr["Request ID"].ToString().Trim(); tbl.req_date = dr["Date"].ToString().Trim(); tbl.candidate_id = dr["Candidate ID"].ToString().Trim(); tbl.associate_id = dr["AssociateId"].ToString().Trim(); tbl.bgv_type = dr["BGV Type"].ToString().Trim(); tbl.package = dr["Package"].ToString().Trim(); tbl.account = dr["Account"].ToString().Trim(); tbl.name = dr["Name"].ToString().Trim(); tbl.allocated_to = dr["Allocated To"].ToString().Trim(); tbl.docs_download = dr["Docs Downloaded"].ToString().Trim(); tbl.status = dr["Status"].ToString().Trim(); tbl.crn = dr["CRN"].ToString().Trim(); tbl.creation_date = dr["Creation Date"].ToString().Trim(); tbl.drug_panel = dr["drug panel"].ToString().Trim(); tbl.req_date1 = dr["Date1"].ToString().Trim(); lst.Add(tbl); } entit.tbl_initiation_tracker.AddRange(lst); entit.SaveChanges(); intValue = 1; } catch (Exception ex) { intValue = -1; throw ex; } return(intValue); }
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_For_FreshCase() { string output = ""; long ResId = 0; long ReqId = 0; DML_Utility objDML = new DML_Utility(); Get_Data_Utility obj = new Get_Data_Utility(); try { List <tbl_response_detail> lstResponse = obj.Get_Response_Data_ToBe_Process(FilePath_Container.FreshCase); if (lstResponse.Count > 0) { //objDML.Add_Exception_Log(lstResponse.Count.ToString(), ""); string MessageId = ""; //MessageId.Split('a').Distinct; string ServiceId = ""; string ResJson = ""; foreach (var res in lstResponse) { MessageId = res.message_id; ServiceId = res.service_id; ResId = res.id; ReqId = (long)res.request_id; ResJson = res.response_json; } // objDML.Add_Exception_Log("Before API Call", ""); string responce_MessageId = ""; string responce_ServiceId = ""; string Response_Data = ""; string path = Read_Json_Case_Creation(ResJson, out responce_MessageId, out responce_ServiceId); //objDML.Add_Exception_Log(responce_MessageId, responce_ServiceId); string status = Read_Json_Case_Creation_TagValue(ResJson, "Status", "Value"); //objDML.Add_Exception_Log(responce_MessageId, responce_ServiceId); //objDML.Add_Exception_Log(status, ""); //objDML.Add_Exception_Log(responce_ServiceId, ""); fadv_touchlessEntities entit = new fadv_touchlessEntities(); if (status == "0000") { if (responce_ServiceId.ToLower() == "freshcase") { //objDML.Add_Exception_Log("Before API Call", ResJson); string reqID = Read_Json_Case_Creation_TagValue(Response_Data, "Data", "request_id"); List <tbl_input_request_data> InputData = entit.tbl_input_request_data.Where(x => x.Request_ID == reqID).ToList <tbl_input_request_data>(); //List<tbl_input_request_data> InputData = entit.tbl_input_request_data.Where(x => x.Request_ID == reqID).ToList<tbl_input_request_data>(); List <tbl_yettostart_casecreation_data> lst = new List <tbl_yettostart_casecreation_data>(); tbl_yettostart_casecreation_data tbl = new tbl_yettostart_casecreation_data(); string College_CVT = ""; string College_UT = ""; string Degree_CVT = ""; string Degree_UT = ""; Response_Data = ResJson; //objDML.Add_Exception_Log("Before API Call", InputData.Count.ToString()); string Account = (Read_Json_Case_Creation_TagValue(Response_Data, "Data", "account_name") == "") ? InputData[0].Account : Read_Json_Case_Creation_TagValue(Response_Data, "Data", "account_name"); string AccountGroup = InputData[0].Account_Group; string vbgType = Read_Json_Case_Creation_TagValue(Response_Data, "Data", "bvg_type"); string bvgsubtype = Read_Json_Case_Creation_TagValue(Response_Data, "Data", "bvg_sub_type"); string bu = Read_Json_Case_Creation_TagValue(Response_Data, "Data", "BU"); string labelName = Read_Json_Case_Creation_TagValue(Response_Data, "Data", "candidate_name"); string sbu = ""; string outputParametrs = ConfigurationManager.AppSettings["outputParametrs"]; Dictionary <string, string> paravalues = getPackageName(Account, vbgType, bu, bvgsubtype, outputParametrs, labelName); string PackageName = (paravalues.Keys.Contains("package")) ? paravalues["package"] : ""; sbu = (paravalues.Keys.Contains("sbu")) ? paravalues["sbu"] : ""; objDML.Add_Exception_Log(PackageName, ""); tbl.queue_request_id = ReqId; tbl.responseId = ResId; tbl.cognizent_tech_solution = Read_Json_Case_Creation_TagValue(Response_Data, "Data", "cognizent_tech_solution"); tbl.clientcode = Read_Json_Case_Creation_TagValue(Response_Data, "Data", "clientcode"); tbl.candidate_name = Read_Json_Case_Creation_TagValue(Response_Data, "Data", "candidate_name"); tbl.client_ref_no = Read_Json_Case_Creation_TagValue(Response_Data, "Data", "client_ref_no"); tbl.bvg_type = Read_Json_Case_Creation_TagValue(Response_Data, "Data", "bvg_type"); tbl.package = PackageName;// Read_Json_Case_Creation_TagValue(Response_Data, "Data", "package"); tbl.specification = Read_Json_Case_Creation_TagValue(Response_Data, "Data", "specification"); tbl.project_id = Read_Json_Case_Creation_TagValue(Response_Data, "Data", "project_id"); tbl.project_name = Read_Json_Case_Creation_TagValue(Response_Data, "Data", "project_name"); tbl.doj = Read_Json_Case_Creation_TagValue(Response_Data, "Data", "doj"); tbl.request_id = Read_Json_Case_Creation_TagValue(Response_Data, "Data", "request_id"); tbl.associate_id = Read_Json_Case_Creation_TagValue(Response_Data, "Data", "associate_id"); tbl.candidate_id = Read_Json_Case_Creation_TagValue(Response_Data, "Data", "candidate_id"); tbl.employee_id = Read_Json_Case_Creation_TagValue(Response_Data, "Data", "employee_id"); tbl.account_name = Read_Json_Case_Creation_TagValue(Response_Data, "Data", "account_name"); tbl.tensse = Read_Json_Case_Creation_TagValue(Response_Data, "Data", "tensse"); tbl.actual_case_created = Read_Json_Case_Creation_TagValue(Response_Data, "Data", "actual_case_created"); tbl.first_name = Read_Json_Case_Creation_TagValue(Response_Data, "Data", "First_Name"); tbl.last_name = Read_Json_Case_Creation_TagValue(Response_Data, "Data", "Last_Name"); tbl.date_of_birth = Read_Json_Case_Creation_TagValue(Response_Data, "Data", "Date_Of_Birth"); tbl.father_name = Read_Json_Case_Creation_TagValue(Response_Data, "Data", "Father_Name"); tbl.nationality = Read_Json_Case_Creation_TagValue(Response_Data, "Data", "Nationality"); tbl.mobile_number = Read_Json_Case_Creation_TagValue(Response_Data, "Data", "Mobile_Number"); tbl.current_address = Read_Json_Case_Creation_TagValue(Response_Data, "Data", "Current_Address"); tbl.permanent_address = Read_Json_Case_Creation_TagValue(Response_Data, "Data", "Permanent_Address"); tbl.longest_stay_address = Read_Json_Case_Creation_TagValue(Response_Data, "Data", "Longest_Stay_Address"); tbl.LOA_Status = Read_Json_Case_Creation_TagValue(Response_Data, "Data", "LOA_Status"); College_CVT = Read_Json_Case_Creation_TagValue(Response_Data, "Data", "College_CVT_UG"); College_UT = Read_Json_Case_Creation_TagValue(Response_Data, "Data", "College_UT_UG"); Degree_CVT = ""; // Read_Json_Case_Creation_TagValue(Response_Data, "Data", "Degree_Type_CVT"); Degree_UT = ""; // Read_Json_Case_Creation_TagValue(Response_Data, "Data", "Degree_Type_UT"); tbl.college_cvt = College_CVT; tbl.college_ut = College_UT; tbl.degree_type_cvt = Degree_CVT; tbl.degree_type_ut = Degree_UT; tbl.reference_type_cvt = ""; // Read_Json_Case_Creation_TagValue(Response_Data, "Data", "Reference_Type_CVT"); tbl.reference_type_ut = ""; //Read_Json_Case_Creation_TagValue(Response_Data, "Data", "Reference_Type_UT"); tbl.company_name_cvt = Read_Json_Case_Creation_TagValue(Response_Data, "Data", "Company_Name_CVT_Previous"); tbl.company_name_ut = Read_Json_Case_Creation_TagValue(Response_Data, "Data", "Company_Name_UT_Previous"); tbl.id_cvt = ""; // Read_Json_Case_Creation_TagValue(Response_Data, "Data", "ID_CVT"); tbl.id_ut = ""; //Read_Json_Case_Creation_TagValue(Response_Data, "Data", "ID_UT"); tbl.employment_type_cvt = ""; // Read_Json_Case_Creation_TagValue(Response_Data, "Data", "Employment_Type_CVT"); tbl.employment_type_ut = ""; // Read_Json_Case_Creation_TagValue(Response_Data, "Data", "Employment_Type_UT"); string College_UT_PG = Read_Json_Case_Creation_TagValue(Response_Data, "Data", "College_UT_PG"); string College_CVT_PG = Read_Json_Case_Creation_TagValue(Response_Data, "Data", "College_CVT_PG"); string BU = Read_Json_Case_Creation_TagValue(Response_Data, "Data", "BU"); string Company_Name_UT_Current = Read_Json_Case_Creation_TagValue(Response_Data, "Data", "Company_Name_UT_Current"); string Company_Name_CVT_Current = Read_Json_Case_Creation_TagValue(Response_Data, "Data", "Company_Name_CVT_Current"); string FilePath = Read_Json_Case_Creation_TagValue(Response_Data, "Data", "FilePath").Replace(@"\", @"\\"); string LOA_Present = Read_Json_Case_Creation_TagValue(Response_Data, "Data", "LOA_Present"); string clientID = (Read_Json_Case_Creation_TagValue(Response_Data, "Data", "Client_ID") == "") ? "1400000003" : Read_Json_Case_Creation_TagValue(Response_Data, "Data", "Client_ID"); string clientName = (Read_Json_Case_Creation_TagValue(Response_Data, "Data", "Client_Name") == "") ? "Cognizant Technology Solutions (IT)" : Read_Json_Case_Creation_TagValue(Response_Data, "Data", "Client_Name"); string SBUIID = (Read_Json_Case_Creation_TagValue(Response_Data, "Data", "SBU_ID") == "") ? "Cognizant Technology Solutions (IT)" : Read_Json_Case_Creation_TagValue(Response_Data, "Data", "SBU_ID");; tbl.active = 1; lst.Add(tbl); int intValue = objDML.Add_Response_Json_FreshCase_Update(ReqId, ResId, lst, Response_Data); //objDML.Add_Exception_Log("After Yet", ""); if (intValue > 0) { // Update college detail // List <Yet2Start_College> lstCollege = new List <Yet2Start_College>(); Yet2Start_College objCollege = new Yet2Start_College(); string[] strCollegeCVT = College_CVT.Split(new char[] { '+' }); string[] strCollegeUT = College_UT.Split(new char[] { '+' }); string[] strDegreeCVT = Degree_CVT.Split(new char[] { '+' }); string[] strDegreeUT = Degree_UT.Split(new char[] { '+' }); for (int i = 0; i < strCollegeCVT.Length; i++) { objCollege = new Yet2Start_College(); objCollege.college = strCollegeCVT[i].ToString().Trim(); objCollege.degree = strDegreeCVT[i].ToString().Trim(); objCollege.field_source = "CVT"; lstCollege.Add(objCollege); } //objDML.Add_Exception_Log("After strCollegeCVT", ""); for (int i = 0; i < strCollegeUT.Length; i++) { objCollege = new Yet2Start_College(); objCollege.college = strCollegeUT[i].ToString().Trim(); objCollege.degree = strDegreeUT[i].ToString().Trim(); objCollege.field_source = "UT"; lstCollege.Add(objCollege); } //objDML.Add_Exception_Log("After strCollegeUT", ""); // Add this into database Table // intValue = objDML.Add_Response_Json(ReqId, ResId, lstCollege); if (intValue > 0) { //////////////////////////////// CASE CREATION JSON FINAL //////////////////// output = Create_Case_Creation_Json(ReqId, ResId, FilePath, clientID, SBUIID, clientName); if (output.ToLower() == "success") { // Update Status in Response Table // objDML.Update_Response_Status(ResId); } } //objDML.Add_Exception_Log("After success", ""); } } } else if (status == "0001") { using (fadv_touchlessEntities entities = new fadv_touchlessEntities()) { string ReqMsg = Read_Json_Case_Creation_TagValue(ResJson, "Data", "Request_Id"); //objDML.Add_Exception_Log(ReqMsg, ""); tbl_initiation_tracker processData = entities.tbl_initiation_tracker.Where(x => x.request_id == ReqMsg.Trim()).First(); processData.active = 0; entities.SaveChanges(); //objDML.Add_Exception_Log("After FailedJson", ""); } } objDML.Update_Response_Status(ResId); } } catch (Exception ex) { output = "ex"; objDML.Update_Response_Status(ResId); //throw ex; int iException = objDML.Add_Exception_Log(ex.Message, "Create_Case_Creation_Json_For_FreshCase"); } return(output); }
public string Create_Case_Creation_Json_For_FreshCase() { string output = ""; long ResId = 0; long ReqId = 0; DML_Utility objDML = new DML_Utility(); Get_Data_Utility obj = new Get_Data_Utility(); try { List <tbl_response_detail> lstResponse = obj.Get_Response_Data_ToBe_Process(FilePath_Container.FreshCase); if (lstResponse.Count > 0) { //objDML.Add_Exception_Log(lstResponse.Count.ToString(), ""); string MessageId = ""; //MessageId.Split('a').Distinct; string ServiceId = ""; string ResJson = ""; foreach (var res in lstResponse) { MessageId = res.message_id; ServiceId = res.service_id; ResId = res.id; ReqId = (long)res.request_id; ResJson = res.response_json; } // objDML.Add_Exception_Log("Before API Call", ""); string responce_MessageId = ""; string responce_ServiceId = ""; string Response_Data = ""; //string path = Read_Json_Case_Creation(ResJson, out responce_MessageId, out responce_ServiceId); //objDML.Add_Exception_Log(responce_MessageId, responce_ServiceId); string result = Read_Json_DataForCaseCreation(ResJson, "metadata", "status", "success"); string requestId = Read_Json_TagWise(ResJson, "metadata", "requestId"); //string details = Read_Json_TagWise(result, "success" ); //string status = Read_Json_Case_Creation_TagValue(ResJson, "Status", "Value"); //objDML.Add_Exception_Log(responce_MessageId, responce_ServiceId); //objDML.Add_Exception_Log(status, ""); //objDML.Add_Exception_Log(responce_ServiceId, ""); fadv_touchlessEntities entit = new fadv_touchlessEntities(); if (result.ToLower() == "true") { //if (responce_ServiceId.ToLower() == "Wiprofreshcase") //{ // string Candidte_Id = Read_Json_Case_Creation_TagValue(ResJson, "Data", "Candidte_Id"); // string Check_Initiated = Read_Json_Case_Creation_TagValue(ResJson, "Data", "Check_Initiated"); // tbl_Wipro_Details CandidateDetails = obj.Get_WiproCandiateDetails(Candidte_Id, Check_Initiated); // string outputParametrs = ConfigurationManager.AppSettings["outputParametrs"]; // Dictionary<string, string> paravalues = getWiproPackageName(Check_Initiated, Candidte_Id, CandidateDetails.Employee_Name, outputParametrs); // string PackageName = (paravalues.Keys.Contains("package")) ? paravalues["package"] : ""; // string sbu = (paravalues.Keys.Contains("sbu")) ? paravalues["sbu"] : ""; // string clientID = Read_Json_Case_Creation_TagValue(ResJson, "Data", "Client_ID"); // string clientName = Read_Json_Case_Creation_TagValue(ResJson, "Data", "Client_Name"); // string FilePath = Read_Json_Case_Creation_TagValue(ResJson, "Data", "FilePath").Replace("\\", "\\\\")+"\\\\"; // string PONumber = Read_Json_Case_Creation_TagValue(ResJson, "Data", "PO_Number"); // string Database_Sent = Read_Json_Case_Creation_TagValue(ResJson, "Data", "Database_Sent"); // long longClID = Convert.ToInt32(clientID); // List<tbl_sbu_master> SBUList = entit.tbl_sbu_master.Where(x => x.SBU_Name == sbu && x.ClientID == longClID).ToList<tbl_sbu_master>(); // string SBUIID = "0"; // if (SBUList.Count > 0) // SBUIID = SBUList[0].SBUID.ToString(); // if (Convert.ToInt64(SBUIID) > 0) // output = Create_Case_Creation_Json(ReqId, ResId, CandidateDetails, PackageName, Database_Sent, PONumber, FilePath, clientID, SBUIID, clientName, sbuName: sbu, PackageName: PackageName); // } } else { using (fadv_touchlessEntities entities = new fadv_touchlessEntities()) { //string ReqMsg = Read_Json_Case_Creation_TagValue(ResJson, "Data", "Request_Id"); ////objDML.Add_Exception_Log(ReqMsg, ""); tbl_request_details processData = entities.tbl_request_details.Where(x => x.json_text.Contains(requestId)).First(); string json = processData.json_text; string attempt = Read_Json_TagWise(json, "metadata", "attempt"); if (attempt == "1") { JObject rss = JObject.Parse(json); string queueMessageId = Guid.NewGuid().ToString(); rss["metadata"]["attempt"] = "2"; rss["metadata"]["requestId"] = queueMessageId; string updatedJson = rss.ToString(); string queueServiceId = FilePath_Container.FreshCase; output = updatedJson; int iDML = objDML.Add_Request_Json_Detail(queueMessageId, queueServiceId, output); if (iDML == 1) { string resumeno = (string)rss["data"][0]["taskSpecs"]["downloadData"]["resumeNumber"]; string sublogin = (string)rss["data"][0]["taskSpecs"]["downloadData"]["subLogin"]; RabbitMQ_Utility objQueue = new RabbitMQ_Utility(); string error; //ret = objQueue.Rabbit_Send(json, "Request", "localhost", out error); objDML.Add_Exception_Log("Wipro: 2st attempt for Resume No : : " + resumeno + " Sub- Login : "******" has been sent to rabbitMQ ", resumeno); objQueue.Rabbit_Send(updatedJson, RabbitMQ_Utility.RabbitMQRequestQueue, RabbitMQ_Utility.RabbitMQUrl, out error); } } //processData.active = 0; //entities.SaveChanges(); //objDML.Add_Exception_Log("After FailedJson", ""); } } objDML.Update_Response_Status(ResId); } } catch (Exception ex) { output = "ex"; objDML.Update_Response_Status(ResId); //throw ex; int iException = objDML.Add_Exception_Log("Wipro exception : " + ex.Message, "Create_Case_Creation_Json_For_FreshCase"); } return(output); }