public bool Rabbit_Send(string message, string queue, string hostname, out string error) { error = string.Empty; try { string strRabbitMQUrl = ""; string strRabbitMQRequestQueue = ""; string strRabbitMQResponseQueue = ""; // Get HostName // Get_Data_Utility objGet = new Get_Data_Utility(); List <tbl_config_value> lstConfig = objGet.Get_Cofig_Details("RABITMQWipro"); foreach (var ob in lstConfig) { strRabbitMQUrl = ob.configstring; strRabbitMQRequestQueue = ob.RequestQueue; strRabbitMQResponseQueue = ob.ResponseQueue; } if (!string.IsNullOrEmpty(strRabbitMQUrl)) { //queue = queue.ToLower() == "response" ? strRabbitMQResponseQueue : strRabbitMQRequestQueue; queue = strRabbitMQRequestQueue;// strRabbitMQRequestQueue; hostname = strRabbitMQUrl; var factory = new ConnectionFactory() { HostName = hostname }; string UserName = ConfigurationManager.AppSettings["r_username"]; string Password = ConfigurationManager.AppSettings["r_password"]; factory.UserName = UserName; factory.Password = Password; using (var connection = factory.CreateConnection()) using (var channel = connection.CreateModel()) { channel.QueueDeclare(queue: queue, durable: true, exclusive: false, autoDelete: false, arguments: null); var body = Encoding.UTF8.GetBytes(message); channel.BasicPublish(exchange: "", routingKey: queue, basicProperties: null, body: body); } return(true); } else { return(false); } } catch (Exception ex) { error = ex.Message.ToString(); //return false; throw ex; } }
public bool Receive1(string queue, out string data, out string error) { error = string.Empty; data = string.Empty; try { string strRabbitMQUrl = ""; string strRabbitMQRequestQueue = ""; string strRabbitMQResponseQueue = ""; // Get HostName // Get_Data_Utility objGet = new Get_Data_Utility(); List <tbl_config_value> lstConfig = objGet.Get_Cofig_Details("RABITMQ"); foreach (var ob in lstConfig) { strRabbitMQUrl = ob.configstring; strRabbitMQRequestQueue = ob.RequestQueue; strRabbitMQResponseQueue = ob.ResponseQueue; } if (!string.IsNullOrEmpty(strRabbitMQUrl)) { queue = strRabbitMQResponseQueue; using (IConnection connection = new ConnectionFactory().CreateConnection()) { using (IModel channel = connection.CreateModel()) { channel.QueueDeclare(queue, true, false, false, null); var consumer = new EventingBasicConsumer(channel); BasicGetResult result = channel.BasicGet(queue, true); if (result != null) { data = Encoding.UTF8.GetString(result.Body); Console.WriteLine(data); } } } return(true); } else { return(false); } } catch (Exception ex) { error = ex.Message.ToString(); throw ex; //return false; } }
public int Execute_Excel_InitialTracker() { int Value = 0; DML_Utility objDML = new DML_Utility(); try { string strFilePath = ""; string strFileName = ""; // Get HostName // Get_Data_Utility objGet = new Get_Data_Utility(); List <tbl_config_value> lstConfig = objGet.Get_Cofig_Details("MISDATA"); foreach (var ob in lstConfig) { strFilePath = ob.configstring; strFileName = ob.FileName; } string path = strFilePath + strFileName; // //FilePath_Container.FilePath + FilePath_Container.FileName_InitationTracker; if (File.Exists(path)) { DataTable dt = Read_Excel("Sheet1", path); if (dt.Rows.Count > 0) { // Add Rows Count into table // long rowcount = dt.Rows.Count; objDML.Add_Rows_Count_Data(path, rowcount); Value = addData(dt); } else { Value = 9; // No data exist } } } catch (Exception ex) { Value = -1; ////// Exception Log /// int iException = objDML.Add_Exception_Log(ex.Message, ""); } return(Value); }
public bool Receive(string queue, out string data, out string error) { error = string.Empty; try { string strRabbitMQUrl = ""; string strRabbitMQRequestQueue = ""; string strRabbitMQResponseQueue = ""; data = string.Empty; // Get HostName // Get_Data_Utility objGet = new Get_Data_Utility(); DML_Utility objDML = new DML_Utility(); List <tbl_config_value> lstConfig = objGet.Get_Cofig_Details("RABITMQWipro"); foreach (var ob in lstConfig) { strRabbitMQUrl = ob.configstring; strRabbitMQRequestQueue = ob.RequestQueue; strRabbitMQResponseQueue = ob.ResponseQueue; } if (!string.IsNullOrEmpty(strRabbitMQUrl)) { //queue = queue.ToLower() == "response" ? strRabbitMQResponseQueue : strRabbitMQRequestQueue; queue = strRabbitMQResponseQueue;// strRabbitMQRequestQueue; //hostname = strRabbitMQUrl; var factory = new ConnectionFactory() { HostName = strRabbitMQUrl }; string UserName = ConfigurationManager.AppSettings["r_username"]; string Password = ConfigurationManager.AppSettings["r_password"]; factory.UserName = UserName; factory.Password = Password; //objDML.Add_Exception_Log(strRabbitMQUrl, ""); using (var connection = factory.CreateConnection()) using (var channel = connection.CreateModel()) { //channel.QueueDeclare(queue: queue, durable: true, exclusive: false, autoDelete: false, arguments: null); //var body = Encoding.UTF8.GetBytes(message); //channel.BasicPublish(exchange: "", routingKey: queue, basicProperties: null, body: body); // objDML.Add_Exception_Log(queue, ""); channel.QueueDeclare(queue, true, false, false, null); var consumer = new EventingBasicConsumer(channel); BasicGetResult result = channel.BasicGet(queue, true); // objDML.Add_Exception_Log(result.Body.ToString(), ""); if (result != null) { data = Encoding.UTF8.GetString(result.Body); //Console.WriteLine(data); } } return(true); } else { return(false); } } catch (Exception ex) { error = ex.Message.ToString(); //return false; throw ex; } }
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); }