public DC_Message SyncSupplierStaticHotel(Guid log_id, Guid supplier_Id, string CreatedBy) { try { Guid LogId; using (ConsumerEntities context = new ConsumerEntities()) { var iScheduledCount = (from dlr in context.DistributionLayerRefresh_Log where (dlr.Status == "Scheduled" || dlr.Status == "Running") && dlr.Element == "Hotels" && dlr.Type == "Static" select true).Count(); if (iScheduledCount > 0) { return(new DC_Message { StatusMessage = "Supplier Static Hotel sync has already been scheduled.", StatusCode = ReadOnlyMessage.StatusCode.Information }); } else { LogId = Guid.NewGuid(); DataLayer.DistributionLayerRefresh_Log objNew = new DistributionLayerRefresh_Log(); objNew.Id = LogId; objNew.Element = "Hotels"; objNew.Type = "Static"; objNew.Create_Date = DateTime.Now; objNew.Create_User = CreatedBy;// System.Web.HttpContext.Current.User.Identity.Name; objNew.Status = "Scheduled"; objNew.Supplier_Id = supplier_Id; objNew.Edit_Date = DateTime.Now; objNew.Edit_User = CreatedBy; context.DistributionLayerRefresh_Log.Add(objNew); context.SaveChanges(); } if (log_id == Guid.Empty) { using (DHSVCProxyAsync DHP = new DHSVCProxyAsync()) { string strURI = string.Format(System.Configuration.ConfigurationManager.AppSettings["Load_SupplierStaticHotels"], LogId.ToString(), supplier_Id.ToString()); DHP.GetAsync(ProxyFor.SqlToMongo, strURI); } } else { //Code goes here for Indert Update or Delete of a specific country } return(new DC_Message { StatusMessage = "Supplier Static Hotel sync has been scheduled successfully.", StatusCode = ReadOnlyMessage.StatusCode.Success }); } } catch (Exception ex) { return(new DC_Message { StatusMessage = ex.Message, StatusCode = ReadOnlyMessage.StatusCode.Failed }); } }
private DC_Message InsertDistributionLogNewEntryForMLDataAPI(DC_Distribution_MLDataRQ obj) { DC_Message msg = new DC_Message(); try { using (ConsumerEntities context = new ConsumerEntities()) { IncomingWebRequestContext woc = WebOperationContext.Current.IncomingRequest; string CallingAgent = woc.Headers["CallingAgent"]; string CallingUser = woc.Headers["CallingUser"]; DataLayer.DistributionLayerRefresh_Log objNew = new DistributionLayerRefresh_Log(); objNew.Id = (obj.Logid ?? Guid.NewGuid()); objNew.Element = obj.Element.Trim(); objNew.Type = obj.Type.Trim(); objNew.Create_Date = DateTime.Now; objNew.Create_User = CallingUser; objNew.Status = obj.Status; context.DistributionLayerRefresh_Log.Add(objNew); context.SaveChanges(); msg.StatusCode = ReadOnlyMessage.StatusCode.Success; msg.StatusMessage = "Sync has been scheduled successfully."; } } catch (Exception) { throw; } return(msg); }
public DC_Message Update_Scheduled_Logs(DC_SchedulerServicesLogs param) { DataContracts.DC_Message _msg = new DataContracts.DC_Message(); bool IsExist = false; try { using (ConsumerEntities context = new ConsumerEntities()) { //To check dupicate state DC_SchedulerServicesLogs RQ = new DC_SchedulerServicesLogs(); RQ.Log_Id = param.Log_Id; RQ.Operation = "LOGID"; var result = Get_Scheduled_Logs(RQ); if (result != null) { if (result.Count > 0) { var search = context.Supplier_Scheduled_Task_Log.Find(param.Log_Id); if (search != null) { search.Status_Message = param.Status_Message; search.Log_Type = param.Log_Type; search.Remarks = param.Remarks; search.Edit_User = param.Create_User; search.Edit_Date = DateTime.Now; context.SaveChanges(); } _msg.StatusCode = DataContracts.ReadOnlyMessage.StatusCode.Success; _msg.StatusMessage = param.Task_Id + DataContracts.ReadOnlyMessage.strUpdatedSuccessfully; return(_msg); } else { _msg.StatusCode = DataContracts.ReadOnlyMessage.StatusCode.Warning; _msg.StatusMessage = param.Task_Id + DataContracts.ReadOnlyMessage.strnotExist; return(_msg); } } else { _msg.StatusCode = DataContracts.ReadOnlyMessage.StatusCode.Warning; _msg.StatusMessage = param.Task_Id + DataContracts.ReadOnlyMessage.strnotExist; return(_msg); } } } catch { throw new FaultException <DataContracts.DC_ErrorStatus>(new DataContracts.DC_ErrorStatus { ErrorMessage = "Error while updating Supplier Scheduled Logs.", ErrorStatusCode = System.Net.HttpStatusCode.InternalServerError }); } }
public DC_Message InsertKafkaInfo(DataContracts.STG.DC_Stg_Kafka KafkaInfo) { DC_Message _msg = new DC_Message(); using (ConsumerEntities context = new ConsumerEntities()) { try { if (KafkaInfo != null) { Stg_Kafka sk = new Stg_Kafka() { Row_Id = KafkaInfo.Row_Id, Status = KafkaInfo.Status, Topic = KafkaInfo.Topic, PayLoad = KafkaInfo.PayLoad, Error = KafkaInfo.Error, Key = KafkaInfo.Key, Offset = KafkaInfo.Offset, Partion = KafkaInfo.Partion, //TimeStamp = KafkaInfo.TimeStamp.get, TopicPartion = KafkaInfo.TopicPartion, TopicPartionOffset = KafkaInfo.TopicPartionOffset, Create_User = KafkaInfo.Create_User, Create_Date = KafkaInfo.Create_Date, Process_User = KafkaInfo.Process_User, Process_Date = KafkaInfo.Process_Date, }; context.Stg_Kafka.Add(sk); if (context.SaveChanges() == 1) { _msg.StatusMessage = ReadOnlyMessage.strAddedSuccessfully; _msg.StatusCode = ReadOnlyMessage.StatusCode.Success; } else { _msg.StatusMessage = ReadOnlyMessage.strFailed; _msg.StatusCode = ReadOnlyMessage.StatusCode.Failed; } } else { _msg.StatusMessage = ReadOnlyMessage.strFailed; _msg.StatusCode = ReadOnlyMessage.StatusCode.Failed; } return(_msg); } catch (Exception ex) { throw new FaultException <DataContracts.DC_ErrorStatus>(new DataContracts.DC_ErrorStatus { ErrorMessage = "Error while inserting Kafka details", ErrorStatusCode = System.Net.HttpStatusCode.InternalServerError }); } } }
public bool UpdateSupplierSchedule(DataContracts.Schedulers.DC_Supplier_Schedule_RQ RQ) { try { using (ConsumerEntities context = new ConsumerEntities()) { var search = (from ac in context.Supplier_Schedule where ac.SupplierScheduleID == RQ.SupplierScheduleID select ac).First(); if (RQ.IsActive == true) { var Activecount = (from a in context.Supplier_Schedule where a.Supplier_ID == RQ.Suppllier_ID && a.Entity == RQ.Enitity && a.IsActive == true select a).Count(); if (Activecount == 0) { search.IsActive = RQ.IsActive; search.Edit_Date = RQ.Edit_Date; search.Edit_User = RQ.Edit_User; context.SaveChanges(); } } else if (search != null) { search.IsActive = RQ.IsActive; search.Edit_Date = RQ.Edit_Date; search.Edit_User = RQ.Edit_User; context.SaveChanges(); } return(true); } } catch { throw new FaultException <DataContracts.DC_ErrorStatus>(new DataContracts.DC_ErrorStatus { ErrorMessage = "Error while updating accomodation contacts", ErrorStatusCode = System.Net.HttpStatusCode.InternalServerError }); } }
public DataContracts.DC_Message UpdateTaskLog(DataContracts.Schedulers.DC_SupplierScheduledTaskRQ obj) { try { DC_Message _msg = new DC_Message(); using (ConsumerEntities context = new ConsumerEntities()) { if (obj.TaskId != Guid.Empty) { //var result = (from a in context.Supplier_Scheduled_Task_Log // join b in context.Supplier_Scheduled_Task on a.Task_Id equals b.Task_Id // where a.Log_Id == obj.LogId // select b).FirstOrDefault(); var result = (from a in context.Supplier_Scheduled_Task where a.Task_Id == obj.TaskId select a).FirstOrDefault(); if (result != null) { var unprocessedtask = from a in context.SupplierImportFileDetails where a.Supplier_Id == obj.Supplier_Id && a.Entity == obj.Entity && a.STATUS != "PROCESSED" && result.Schedule_Datetime < a.CREATE_DATE select a; if (unprocessedtask.Count() == 0) { result.Edit_Date = obj.Edit_Date; result.Edit_User = obj.Edit_User; result.Status = "Completed"; if (context.SaveChanges() == 1) { _msg.StatusMessage = ReadOnlyMessage.strUpdatedSuccessfully; _msg.StatusCode = ReadOnlyMessage.StatusCode.Success; } else { _msg.StatusMessage = ReadOnlyMessage.strFailed; _msg.StatusCode = ReadOnlyMessage.StatusCode.Failed; } } } } } return(_msg); } catch (Exception ex) { throw new FaultException <DC_ErrorStatus>(new DataContracts.DC_ErrorStatus { ErrorMessage = "Error while saving Supplier Schedule", ErrorStatusCode = System.Net.HttpStatusCode.InternalServerError }); } }
public DC_Message Pentaho_SupplierApiCall_Remove(Guid PentahoCall_Id, string CalledBy) { try { DC_Message dc = new DataContracts.DC_Message(); if (PentahoCall_Id != Guid.Empty) { string endpointurl = "removeTrans?id=" + PentahoCall_Id.ToString(); object result; DHSVCProxy.GetData(ProxyFor.Pentaho, endpointurl, typeof(void), out result); using (ConsumerEntities context = new ConsumerEntities()) { List <Supplier_ApiCallLog> results = (from p in context.Supplier_ApiCallLog where p.PentahoCall_Id == PentahoCall_Id select p).ToList(); foreach (Supplier_ApiCallLog p in results) { p.Status = "REMOVED"; p.Edit_User = CalledBy; p.Edit_Date = DateTime.Now; p.Message = "Transformation Queue has been removed from Server."; } context.SaveChanges(); } dc.StatusMessage = "The transformation was removed successfully."; dc.StatusCode = ReadOnlyMessage.StatusCode.Success; } else { dc.StatusMessage = "Invalid Transformation Call Id !"; dc.StatusCode = ReadOnlyMessage.StatusCode.Danger; } return(dc); } catch (Exception e) { return(new DC_Message { StatusCode = ReadOnlyMessage.StatusCode.Danger, StatusMessage = e.Message }); } }
public DC_Message UpdateKafkaInfo(DataContracts.STG.DC_Stg_Kafka KafkaInfo) { DC_Message _msg = new DC_Message(); try { using (ConsumerEntities context = new ConsumerEntities()) { var search = context.Stg_Kafka.Find(KafkaInfo.Row_Id); if (search != null) { if (search.Status != KafkaInfo.Status && KafkaInfo.Status != "") { search.Status = KafkaInfo.Status; } ; search.Key = KafkaInfo.Key; search.Offset = KafkaInfo.Offset; //search.TimeStamp = KafkaInfo.TimeStamp; search.Partion = KafkaInfo.Partion; search.TopicPartion = KafkaInfo.TopicPartion; search.TopicPartionOffset = KafkaInfo.TopicPartionOffset; search.Process_User = KafkaInfo.Process_User; search.Process_Date = DateTime.Now; context.SaveChanges(); } return(_msg); } } catch (Exception ex) { throw new FaultException <DataContracts.DC_ErrorStatus>(new DataContracts.DC_ErrorStatus { ErrorMessage = "Error while updating Kafka details", ErrorStatusCode = System.Net.HttpStatusCode.InternalServerError }); } }
private DC_Message InsertDistributionLogNewEntry(Guid LogId, string elementName, string Type, string status, string CreatedBy) { DC_Message msg = new DC_Message(); DataLayer.DistributionLayerRefresh_Log objNew = new DistributionLayerRefresh_Log(); objNew.Id = LogId; objNew.Element = elementName; objNew.Type = Type; objNew.Create_Date = DateTime.Now; objNew.Create_User = CreatedBy; objNew.Status = status; using (ConsumerEntities context = new ConsumerEntities()) { context.DistributionLayerRefresh_Log.Add(objNew); context.SaveChanges(); } msg.StatusCode = ReadOnlyMessage.StatusCode.Success; msg.StatusMessage = elementName + " " + Type + "Sync has been scheduled successfully."; return(msg); }
public DataContracts.DC_GeoLocation GetGeoLocationByAddress(DataContracts.DC_Address.DC_Address_Physical PA) { try { string Address = String.Empty; if (!string.IsNullOrEmpty(PA.Street)) { Address = Address + PA.Street.Trim().TrimEnd(',').Replace(" ", "+") + ","; } if (!string.IsNullOrEmpty(PA.CityAreaOrDistrict)) { Address = Address + PA.CityAreaOrDistrict.Trim().TrimEnd(',').Replace(" ", "+") + ","; } if (!string.IsNullOrEmpty(PA.CityOrTownOrVillage)) { Address = Address + PA.CityOrTownOrVillage.Trim().TrimEnd(',').Replace(" ", "+") + ","; } if (!string.IsNullOrEmpty(PA.CountyOrState)) { Address = Address + PA.CountyOrState.Trim().TrimEnd(',').Replace(" ", "+") + ","; } if (!string.IsNullOrEmpty(PA.PostalCode)) { Address = Address + PA.PostalCode.Trim().TrimEnd(',').Replace(" ", "+") + ","; } if (!string.IsNullOrEmpty(PA.Country)) { Address = Address + PA.Country.Trim().TrimEnd(',').Replace(" ", "+") + ","; } Address = Address.TrimEnd(',').Trim(); DataContracts.DC_GeoLocation mapdata = null; if (!string.IsNullOrEmpty(Address)) { var request = (HttpWebRequest)WebRequest.Create("https://maps.googleapis.com/maps/api/geocode/json?address=" + Address + "&key=" + System.Configuration.ConfigurationManager.AppSettings["GoogleKey"].ToString()); var proxyAddress = System.Configuration.ConfigurationManager.AppSettings["ProxyUri"]; if (System.Configuration.ConfigurationManager.AppSettings["ProxyUri"] != null) { WebProxy myProxy = new WebProxy(); Uri newUri = new Uri(proxyAddress); // Associate the newUri object to 'myProxy' object so that new myProxy settings can be set. myProxy.Address = newUri; // Create a NetworkCredential object and associate it with the // Proxy property of request object. //myProxy.Credentials = new NetworkCredential(username, password); request.Proxy = myProxy; } request.KeepAlive = false; //request.Credentials = CredentialCache.DefaultCredentials; HttpWebResponse response = request.GetResponse() as HttpWebResponse; if (response.StatusCode == HttpStatusCode.OK) //response.StatusDescription { Stream dataStream = response.GetResponseStream(); StreamReader reader = new StreamReader(dataStream); string responseFromServer = reader.ReadToEnd(); reader.Close(); mapdata = JsonConvert.DeserializeObject <DataContracts.DC_GeoLocation>(responseFromServer); if (mapdata != null) { using (ConsumerEntities context = new ConsumerEntities()) { GoogleGeoCode GC = new GoogleGeoCode(); GC.GoogleGeoCode_Id = Guid.NewGuid(); GC.Product_Id = PA.Product_Id; GC.JobType = "ProductGeoLookup_ByAddress"; GC.Input = request.Address.AbsoluteUri; GC.OutPut = responseFromServer; context.GoogleGeoCodes.Add(GC); context.SaveChanges(); } } } //DataContractJsonSerializer obj = new DataContractJsonSerializer(typeof(DataContracts.DC_GeoLocation)); //var result = obj.ReadObject(dataStream) as DataContracts.DC_GeoLocation; response.Close(); } return(mapdata); } catch (WebException ex) { throw new FaultException <DataContracts.DC_ErrorStatus>(new DataContracts.DC_ErrorStatus { ErrorMessage = ex.Message, ErrorStatusCode = System.Net.HttpStatusCode.InternalServerError }); } }
public DataContracts.DC_GeoLocation GetGeoLocationByLatLng(DataContracts.DC_Address.DC_Address_GeoCode AG) { try { string LatLng = String.Empty; LatLng = AG.Latitude.ToString() + "," + AG.Longitude.ToString(); DataContracts.DC_GeoLocation mapdata = null; var request = (HttpWebRequest)WebRequest.Create("https://maps.googleapis.com/maps/api/geocode/json?latlng=" + LatLng + "&key=" + System.Configuration.ConfigurationManager.AppSettings["GoogleKey"].ToString()); var proxyAddress = System.Configuration.ConfigurationManager.AppSettings["ProxyUri"]; if (System.Configuration.ConfigurationManager.AppSettings["ProxyUri"] != null) { WebProxy myProxy = new WebProxy(); Uri newUri = new Uri(proxyAddress); // Associate the newUri object to 'myProxy' object so that new myProxy settings can be set. myProxy.Address = newUri; // Create a NetworkCredential object and associate it with the // Proxy property of request object. //myProxy.Credentials = new NetworkCredential(username, password); request.Proxy = myProxy; } request.KeepAlive = false; HttpWebResponse response = request.GetResponse() as HttpWebResponse; if (response.StatusCode == HttpStatusCode.OK) //response.StatusDescription { Stream dataStream = response.GetResponseStream(); StreamReader reader = new StreamReader(dataStream); string responseFromServer = reader.ReadToEnd(); reader.Close(); mapdata = JsonConvert.DeserializeObject <DataContracts.DC_GeoLocation>(responseFromServer); if (mapdata != null) { using (ConsumerEntities context = new ConsumerEntities()) { GoogleGeoCode GC = new GoogleGeoCode(); GC.GoogleGeoCode_Id = Guid.NewGuid(); GC.Product_Id = AG.Product_Id; GC.JobType = "ProductGeoLookup_ByLatLng"; GC.Input = request.Address.AbsoluteUri; GC.OutPut = responseFromServer; context.GoogleGeoCodes.Add(GC); context.SaveChanges(); } } } //DataContractJsonSerializer obj = new DataContractJsonSerializer(typeof(DataContracts.DC_GeoLocation)); //var result = obj.ReadObject(dataStream) as DataContracts.DC_GeoLocation; response.Close(); return(mapdata); } catch { throw new FaultException <DataContracts.DC_ErrorStatus>(new DataContracts.DC_ErrorStatus { ErrorMessage = "Error while searching address", ErrorStatusCode = System.Net.HttpStatusCode.InternalServerError }); } }
public DC_Message Add_Scheduled_Tasklog(DC_SchedulerServicesLogs RQ) { DC_Message _msg = new DC_Message(); bool isExist = false; if (RQ.Task_Id == Guid.Empty || RQ.Task_Id == null || RQ.Log_Id == null || RQ.Log_Id == null) { _msg.StatusCode = DataContracts.ReadOnlyMessage.StatusCode.Warning; _msg.StatusMessage = DataContracts.ReadOnlyMessage.strFailed; return(_msg); } try { DC_SchedulerServicesLogs Req = new DC_SchedulerServicesLogs(); Req.Task_Id = RQ.Task_Id; Req.Operation = "TASKID"; List <DC_SchedulerServicesLogs> existScheduleId = Get_Scheduled_Logs(RQ).ToList(); if (existScheduleId != null) { if (existScheduleId.Count > 0) { _msg.StatusCode = DataContracts.ReadOnlyMessage.StatusCode.Duplicate; _msg.StatusMessage = RQ.Task_Id.ToString() + DataContracts.ReadOnlyMessage.strAlreadyExist; return(_msg); } else { isExist = false; } } else { isExist = false; } if (!isExist) { using (ConsumerEntities context = new ConsumerEntities()) { Supplier_Scheduled_Task_Log objNew = new Supplier_Scheduled_Task_Log(); objNew.Log_Id = RQ.Log_Id; objNew.Task_Id = RQ.Task_Id; objNew.Status_Message = RQ.Status_Message; objNew.Log_Type = RQ.Log_Type; objNew.Remarks = RQ.Remarks; objNew.Create_Date = DateTime.Now; objNew.Create_User = RQ.Create_User; objNew.IsActive = RQ.IsActive; context.Supplier_Scheduled_Task_Log.Add(objNew); context.SaveChanges(); objNew = null; _msg.StatusCode = DataContracts.ReadOnlyMessage.StatusCode.Success; _msg.StatusMessage = RQ.Task_Id + DataContracts.ReadOnlyMessage.strAddedSuccessfully; return(_msg); } } else { _msg.StatusCode = DataContracts.ReadOnlyMessage.StatusCode.Duplicate; _msg.StatusMessage = RQ.Task_Id + DataContracts.ReadOnlyMessage.strAlreadyExist; return(_msg); } } catch (Exception ex) { throw new FaultException <DataContracts.DC_ErrorStatus>(new DataContracts.DC_ErrorStatus { ErrorMessage = "Error while adding Task log", ErrorStatusCode = System.Net.HttpStatusCode.InternalServerError }); } }
public DC_Message Delete_Scheduled_Tasks(DC_SchedulerServicesTasks param) { DataContracts.DC_Message _msg = new DataContracts.DC_Message(); bool IsExist = false; try { using (ConsumerEntities context = new ConsumerEntities()) { //To check dupicate state DC_SchedulerServicesTasks RQ = new DC_SchedulerServicesTasks(); RQ.Task_Id = param.Task_Id; RQ.Operation = "TASKID"; var result = Get_Scheduled_Tasks(RQ); if (result != null) { if (result.Count > 0) { var search = context.Supplier_Scheduled_Task.Find(param.Task_Id); if (search != null) { if (param.Operation.ToLower() == "softdelete") { using (var trn = context.Database.BeginTransaction(System.Data.IsolationLevel.ReadCommitted)) { search.Edit_User = param.Create_User; search.Edit_Date = DateTime.Now; search.IsActive = param.IsActive; context.SaveChanges(); trn.Commit(); } } _msg.StatusCode = DataContracts.ReadOnlyMessage.StatusCode.Success; _msg.StatusMessage = param.Task_Id + DataContracts.ReadOnlyMessage.strDeleted.Replace("deleted", (param.IsActive ? "restored" : "deleted")); return(_msg); } else { _msg.StatusCode = DataContracts.ReadOnlyMessage.StatusCode.Warning; _msg.StatusMessage = param.Task_Id + DataContracts.ReadOnlyMessage.strnotExist; return(_msg); } } else { _msg.StatusCode = DataContracts.ReadOnlyMessage.StatusCode.Warning; _msg.StatusMessage = param.Task_Id + DataContracts.ReadOnlyMessage.strnotExist; return(_msg); } } else { _msg.StatusCode = DataContracts.ReadOnlyMessage.StatusCode.Warning; _msg.StatusMessage = param.Task_Id + DataContracts.ReadOnlyMessage.strnotExist; return(_msg); } } } catch { throw new FaultException <DataContracts.DC_ErrorStatus>(new DataContracts.DC_ErrorStatus { ErrorMessage = "Error while updating Supplier Scheduled Task.", ErrorStatusCode = System.Net.HttpStatusCode.InternalServerError }); } }
public DC_Message Update_Scheduled_Tasks(DC_SchedulerServicesTasks param) { DataContracts.DC_Message _msg = new DataContracts.DC_Message(); bool IsExist = false; try { using (ConsumerEntities context = new ConsumerEntities()) { //To check dupicate state DC_SchedulerServicesTasks RQ = new DC_SchedulerServicesTasks(); RQ.Task_Id = param.Task_Id; RQ.Operation = "TASKID"; var result = Get_Scheduled_Tasks(RQ); if (result != null) { if (result.Count > 0) { var search = context.Supplier_Scheduled_Task.Find(param.Task_Id); if (search != null) { using (var trn = context.Database.BeginTransaction(System.Data.IsolationLevel.ReadCommitted)) { search.Status = param.Status; // Condition for Change Running Status to completed. if (param.Api_Call_Log_Id != null) { search.Api_Call_Log_Id = param.Api_Call_Log_Id; } search.Edit_User = param.Create_User; search.Edit_Date = DateTime.Now; context.SaveChanges(); trn.Commit(); } } _msg.StatusCode = DataContracts.ReadOnlyMessage.StatusCode.Success; _msg.StatusMessage = param.Task_Id + DataContracts.ReadOnlyMessage.strUpdatedSuccessfully; return(_msg); } else { _msg.StatusCode = DataContracts.ReadOnlyMessage.StatusCode.Warning; _msg.StatusMessage = param.Task_Id + DataContracts.ReadOnlyMessage.strnotExist; return(_msg); } } else { _msg.StatusCode = DataContracts.ReadOnlyMessage.StatusCode.Warning; _msg.StatusMessage = param.Task_Id + DataContracts.ReadOnlyMessage.strnotExist; return(_msg); } } } catch (Exception ex) { throw new FaultException <DataContracts.DC_ErrorStatus>(new DataContracts.DC_ErrorStatus { ErrorMessage = "Error while updating Supplier Scheduled Task.", ErrorStatusCode = System.Net.HttpStatusCode.InternalServerError }); } }
/// <summary></summary> /// <param name="Json Request"> /// {"Api_Call_Log_Id":"29D2EEAA-3252-45AA-9D5F-1A9BF6EFD5F2","Create_User":"******","IsActive":true,"Schedule_Id":"5EFDE08C-95A2-4449-8D1B-044FA5C981EB", /// "Status":"Pending","Schedule_Datetime":"\/Date(928129800000+0530)\/","Task_Id":"AAEF6E0B-C8AB-4BC7-985F-A3D9BC6799B4"}</param> /// <returns - Json Response> /// { "StatusCode": 1, "StatusMessage": "5efde08c-95a2-4449-8d1b-044fa5c981eb has been added successfully."} /// </returns> public DC_Message Add_Scheduled_Tasks(DC_SchedulerServicesTasks RqDC_SchedulerServices) { DC_Message _msg = new DC_Message(); bool isExist = false; if (RqDC_SchedulerServices.Task_Id == Guid.Empty || RqDC_SchedulerServices.Task_Id == null || RqDC_SchedulerServices.Schedule_Id == null || RqDC_SchedulerServices.Schedule_Id == null) { _msg.StatusCode = DataContracts.ReadOnlyMessage.StatusCode.Warning; _msg.StatusMessage = DataContracts.ReadOnlyMessage.strFailed; return(_msg); } try { DC_SchedulerServicesTasks RQ = new DC_SchedulerServicesTasks(); RQ.Schedule_Id = RqDC_SchedulerServices.Schedule_Id; RQ.Operation = RqDC_SchedulerServices.Operation ?? "SCHEDULEID"; List <DC_SchedulerServicesTasks> existScheduleId = Get_Scheduled_Tasks(RQ).ToList(); if (existScheduleId != null) { if (existScheduleId.Count > 0) { _msg.StatusCode = DataContracts.ReadOnlyMessage.StatusCode.Duplicate; _msg.StatusMessage = RqDC_SchedulerServices.Schedule_Id.ToString() + DataContracts.ReadOnlyMessage.strAlreadyExist; return(_msg); } else { isExist = false; } } else { isExist = false; } if (!isExist) { using (ConsumerEntities context = new ConsumerEntities()) { Supplier_Scheduled_Task objNew = new Supplier_Scheduled_Task(); objNew.Task_Id = RqDC_SchedulerServices.Task_Id; objNew.Schedule_Id = RqDC_SchedulerServices.Schedule_Id; objNew.Schedule_Datetime = RqDC_SchedulerServices.Schedule_Datetime; if (RqDC_SchedulerServices.Api_Call_Log_Id != null) { objNew.Api_Call_Log_Id = RqDC_SchedulerServices.Api_Call_Log_Id; } objNew.Status = RqDC_SchedulerServices.Status; objNew.Create_Date = (System.DateTime)DateTime.Now; objNew.Create_User = RqDC_SchedulerServices.Create_User; objNew.IsActive = RqDC_SchedulerServices.IsActive; context.Supplier_Scheduled_Task.Add(objNew); context.SaveChanges(); objNew = null; _msg.StatusCode = DataContracts.ReadOnlyMessage.StatusCode.Success; _msg.StatusMessage = RqDC_SchedulerServices.Schedule_Id + DataContracts.ReadOnlyMessage.strAddedSuccessfully; return(_msg); } } else { _msg.StatusCode = DataContracts.ReadOnlyMessage.StatusCode.Duplicate; _msg.StatusMessage = RqDC_SchedulerServices.Schedule_Id + DataContracts.ReadOnlyMessage.strAlreadyExist; return(_msg); } } catch (Exception ex) { throw new FaultException <DataContracts.DC_ErrorStatus>(new DataContracts.DC_ErrorStatus { ErrorMessage = "Error while adding state master", ErrorStatusCode = System.Net.HttpStatusCode.InternalServerError }); } }
public DataContracts.DC_Message AddUpdateSchedule(DataContracts.Schedulers.DC_Supplier_Schedule obj) { try { DC_Message _msg = new DC_Message(); using (ConsumerEntities context = new ConsumerEntities()) { foreach (string strentity in obj.lstEnity) { if (obj.SupplierScheduleID != Guid.Empty) { var result = (from sup in context.Supplier_Schedule where sup.Supplier_ID == obj.Suppllier_ID && sup.Entity == strentity select sup).FirstOrDefault(); if (result != null) { result.Supplier_ID = obj.Suppllier_ID; result.ISXMLSupplier = obj.ISXMLSupplier; result.ISUpdateFrequence = obj.ISUpdateFrequence; result.Recur_No = obj.Recur_No; result.MonthOfYear = obj.MonthOfYear; result.FrequencyTypeCode = obj.FrequencyTypeCode; result.DateOfMonth = obj.DateOfMonth; result.DayOfWeek = obj.DayOfWeek; result.WeekOfMonth = obj.WeekOfMonth; result.StartTime = obj.StartTime; result.EndTime = obj.EndTime; result.Status = obj.Status; result.Edit_User = obj.Edit_User; result.Edit_Date = obj.Edit_Date; result.Entity = strentity; result.CronExpression = obj.CronExpression; result.IsActive = true; result.User_Role_Id = obj.User_Role_Id; if (context.SaveChanges() == 1) { _msg.StatusMessage = ReadOnlyMessage.strUpdatedSuccessfully; _msg.StatusCode = ReadOnlyMessage.StatusCode.Success; } else { _msg.StatusMessage = ReadOnlyMessage.strFailed; _msg.StatusCode = ReadOnlyMessage.StatusCode.Failed; } } return(_msg); } else { Supplier_Schedule _obj = new Supplier_Schedule { SupplierScheduleID = Guid.NewGuid(), Supplier_ID = obj.Suppllier_ID, ISXMLSupplier = obj.ISXMLSupplier, ISUpdateFrequence = obj.ISUpdateFrequence, FrequencyTypeCode = obj.FrequencyTypeCode, Recur_No = obj.Recur_No, MonthOfYear = obj.MonthOfYear, DayOfWeek = obj.DayOfWeek, DateOfMonth = obj.DateOfMonth, WeekOfMonth = obj.WeekOfMonth, StartTime = obj.StartTime, EndTime = obj.EndTime, Create_Date = obj.Create_Date, Create_User = obj.Create_User, Entity = strentity, CronExpression = obj.CronExpression, Status = obj.Status, IsActive = true, User_Role_Id = obj.User_Role_Id, }; context.Supplier_Schedule.Add(_obj); if (context.SaveChanges() == 1) { _msg.StatusMessage = ReadOnlyMessage.strUpdatedSuccessfully; _msg.StatusCode = ReadOnlyMessage.StatusCode.Success; } else { _msg.StatusMessage = ReadOnlyMessage.strFailed; _msg.StatusCode = ReadOnlyMessage.StatusCode.Failed; } } } } return(_msg); } catch (Exception ex) { throw new FaultException <DataContracts.DC_ErrorStatus>(new DataContracts.DC_ErrorStatus { ErrorMessage = "Error while saving Supplier Schedule", ErrorStatusCode = System.Net.HttpStatusCode.InternalServerError }); } }
public DC_Message Pentaho_SupplierApi_Call(Guid ApiLocationId, string CalledBy) { DC_Message dc = new DataContracts.DC_Message(); try { using (ConsumerEntities context = new ConsumerEntities()) { var iCount = (from dlr in context.Supplier_ApiCallLog where dlr.Status == "RUNNING" && dlr.SupplierApiCallLog_Id == ApiLocationId select true).Count(); if (iCount > 0) { return(new DC_Message { StatusMessage = "Transformation for GeoCode is already running.", StatusCode = ReadOnlyMessage.StatusCode.Information }); } else { var apilocation = (from a in context.Supplier_APILocation where a.Supplier_APILocation_Id == ApiLocationId && a.STATUS.ToUpper() == "ACTIVE" select a.API_Path).FirstOrDefault(); if (!string.IsNullOrWhiteSpace(apilocation)) { var ApiCallId = Guid.NewGuid(); Guid PentahoCallId = Guid.Empty; context.Supplier_ApiCallLog.Add(new Supplier_ApiCallLog { SupplierApiCallLog_Id = ApiCallId, SupplierApiLocation_Id = ApiLocationId, PentahoCall_Id = PentahoCallId, Create_Date = DateTime.Now, Create_User = CalledBy, Message = "Transformation Called.", Status = "SENT TO CARTE" }); context.SaveChanges(); var getInsertedRow = context.Supplier_ApiCallLog.Find(ApiCallId); string endpointurl = "runTrans/?trans=" + apilocation + "&api_call_id=" + ApiCallId.ToString(); object result; DHSVCProxy.GetData(ProxyFor.Pentaho, endpointurl, typeof(DataContracts.Pentaho.DC_PentahoApiCallResult), out result); DataContracts.Pentaho.DC_PentahoApiCallResult callResult = result as DataContracts.Pentaho.DC_PentahoApiCallResult; if (callResult != null) { if (callResult.result.ToUpper() == "OK") { dc.StatusMessage = callResult.message; dc.StatusCode = ReadOnlyMessage.StatusCode.Success; } else { dc.StatusMessage = callResult.message; dc.StatusCode = ReadOnlyMessage.StatusCode.Danger; } Guid.TryParse(callResult.id, out PentahoCallId); getInsertedRow.PentahoCall_Id = PentahoCallId; getInsertedRow.Message = callResult.message; if (PentahoCallId == Guid.Empty) { getInsertedRow.Status = "ERROR"; } context.SaveChanges(); return(dc); } else { getInsertedRow.PentahoCall_Id = Guid.Empty; getInsertedRow.Message = "Api Call failed."; getInsertedRow.Status = "FAILED"; context.SaveChanges(); return(new DC_Message { StatusMessage = "Api Call failed.", StatusCode = ReadOnlyMessage.StatusCode.Failed }); } } else { context.Supplier_ApiCallLog.Add(new Supplier_ApiCallLog { SupplierApiCallLog_Id = Guid.NewGuid(), SupplierApiLocation_Id = ApiLocationId, PentahoCall_Id = null, Create_Date = DateTime.Now, Create_User = CalledBy, Message = "Api Location is not found.", Status = "INVALID" }); context.SaveChanges(); return(new DC_Message { StatusMessage = "Api Location is not found.", StatusCode = ReadOnlyMessage.StatusCode.Warning }); } } } } catch (Exception ex) { return(new DC_Message { StatusMessage = ex.Message, StatusCode = ReadOnlyMessage.StatusCode.Danger }); } }