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);
}
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);
}
public string Write_JSON_TO_Download()
{
bool ret = false;
string output = "";
string error = "";
DML_Utility objDML = new DML_Utility();
Get_Data_Utility objGet = new Get_Data_Utility();
try
{
//objDML.Add_Exception_Log(ts.TotalMinutes.ToString(), "");
// Check Last Request //
int Flag = 1;
List <tbl_request_details> lstObj = new List <tbl_request_details>();
lstObj = objGet.Get_Last_Request();
if (lstObj.Count > 0)
{
double timeMinutes = 0;
DateTime dtReq = (DateTime)lstObj[0].createdOn;
//DateTime dt = System.DateTime.Now;
DateTime dt = System.DateTime.Now.AddMinutes(0);
TimeSpan ts = dt - dtReq;
List <tbl_config_value> lstConfig = objGet.Get_Cofig_Details("DOWNLOADREQUEST");
foreach (var ob in lstConfig)
{
double.TryParse(ob.configstring, out timeMinutes);
}
timeMinutes = timeMinutes <= 0 ? 59 : timeMinutes;
//int iException1 = objDML.Add_Exception_Log(ts.TotalMinutes.ToString(), dt.ToString());
if (ts.TotalMinutes > timeMinutes)
{
Flag = 1;
}
else
{
Flag = 0;
}
}
if (Flag > 0)
{
string MessageId = Guid.NewGuid().ToString();
string ServiceId = FilePath_Container.ServiceId_Download.ToString();// "DOWNLOAD";// Guid.NewGuid().ToString();
///////////////////////// Add Json request into database //////////////
JsonCreater JsonCreater = new Read_File_Processor.JsonCreater();
string json = JsonCreater.getDownload(MessageId, ServiceId);
int iDML = objDML.Add_Request_Json_Detail(MessageId, ServiceId, json); // Add_Request_Json(MessageId, "DOWNLOAD", json);
///////////////////////// Add Json request into Rabbit MQ //////////////
if (iDML == 1)
{
ret = Write_JSON_TO_RABBIT_MQ(json);
output = ret ? "Success" : "Failed";
}
}
else
{
// READ RESPONSE QUEUE //
Read_Response();
}
}
catch (Exception ex)
{
output = "exception : " + ex.Message.ToString();
////// Exception Log ///
//DML_Utility objDML = new DML_Utility();
//int iException = objDML.Add_Exception_Log(ex.Message, "Write_JSON_TO_Download");
}
return(output);
}
public string Execute_Excel_YetToStart_Process_Download()
{
string output = "";
Get_Data_Utility obj = new Get_Data_Utility();
DML_Utility objDML = new DML_Utility();
//objDML.Add_Exception_Log("", "Execute_Excel_YetToStart_Process_Download");
JsonCreater JsonCreater = new Read_File_Processor.JsonCreater();
long ResId = 0;
try
{
string strDateKey = System.DateTime.Now.ToString("yyyyMMddHHmmss");
// GET RESONSE JSON TO BE PROCESSED
List <tbl_response_detail> lstResponse = obj.Get_Response_Data_ToBe_Process(FilePath_Container.ServiceId_Download);
if (lstResponse.Count > 0)
{
string MessageId = "";
string ServiceId = "";
long ReqId = 0;
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;
}
//int iException1 = objDML.Add_Exception_Log(ResJson, "");
if (ResId > 0 && !string.IsNullOrEmpty(ResJson))
{
// Read Json and Excel Process
string responce_MessageId = "";
string responce_Status = "";
string responce_Module = "";
//string RequestType = "DOWNLOAD";
string path = Read_Json(ResJson, out responce_MessageId, out responce_Status, out responce_Module);
//objDML.Add_Exception_Log(path, "");
//objDML.Add_Exception_Log(responce_Status, "");
//objDML.Add_Exception_Log(ResJson, "");
if (responce_Status.ToLower() == "y" || responce_Status.ToLower() == "yes")
{
//objDML.Add_Exception_Log(path, "");
if (File.Exists(path))
{
//string path = FilePath_Container.FilePath + FilePath_Container.FileName_YetToStart;
//objDML.Add_Exception_Log("Before conversion", "");
//string newpath = ConvertToXLSX(path);
//objDML.Add_Exception_Log("afetr conversion", "newpath"+ newpath);
//DataTable dt = Read_Excel(Path.GetFileNameWithoutExtension(path), path);
DataTable dt = ConvertToCSV(path);
//objDML.Add_Exception_Log("Before", "");
//DataTable dt = Import(path);
//objDML.Add_Exception_Log(dt.Rows.Count.ToString(), "");
if (dt.Rows.Count > 0)
{
output = addData_YetToStart(dt, strDateKey);
if (output == "OK")
{
// Get Data after compare for New Request Id
List <tbl_input_request_data> lst = new List <tbl_input_request_data>();
List <YetToStart> lstJson = new List <YetToStart>();
YetToStart objJson = new YetToStart();
lst = obj.Get_New_Request_Id_List(strDateKey);
int iCount = 0;
foreach (var objList in lst)
{
string queueMessageId = Guid.NewGuid().ToString();
string queueServiceId = FilePath_Container.FreshCase;
output = JsonCreater.getDetails_FreshCase(objList.Request_ID, objList.Associate_Id, objList.Candidate_ID, objList.DOJ, queueMessageId, Path.GetFileNameWithoutExtension(path), queueServiceId);
/////////////////////////// Add Json request into database //////////////
int iDML = objDML.Add_Request_Json_Detail(queueMessageId, queueServiceId, output);
if (iDML == 1)
{
bool ret = Write_JSON_TO_RABBIT_MQ(output);
output = ret ? "Success" : "Failed";
}
iCount++;
}
if (iCount == lst.Count)
{
// Update Status of Response //
objDML.Update_Response_Status(ResId);
}
}
}
else
{
output = "not exist";
}
//objDML.Add_Exception_Log(output, "");
}
}
objDML.Update_Response_Status(ResId);
}
}
}
catch (Exception ex)
{
output = "exception : " + ex.Message.ToString();
////// Exception Log ///
//DML_Utility objDML = new DML_Utility();
objDML.Update_Response_Status(ResId);
int iException = objDML.Add_Exception_Log(ex.Message, "Execute_Excel_YetToStart_Process_Download");
}
return(output);
}
