public List <DC_SchedulerServicesTasks> Get_Scheduled_Tasks(DC_SchedulerServicesTasks RqDC_SchedulerServices) { using (BL_SchedulerServices obj = new BL_SchedulerServices()) { return(obj.Get_Scheduled_Tasks(RqDC_SchedulerServices)); } }
public DC_Message Delete_Scheduled_Tasks(DC_SchedulerServicesTasks RqDC_SchedulerServices) { using (BL_SchedulerServices obj = new BL_SchedulerServices()) { return(obj.Delete_Scheduled_Tasks(RqDC_SchedulerServices)); } }
public DC_Message Update_Scheduled_Tasks(DC_SchedulerServicesTasks RqDC_SchedulerServices) { using (DL_SchedulerServices obj = new DL_SchedulerServices()) { return(obj.Update_Scheduled_Tasks(RqDC_SchedulerServices)); } }
/// <summary> /// This service will return All Scheduled Tasks. /// </summary> /// <param name="RqDC_SchedulerServices"></param> /// /// RqDC_SchedulerServices.Operation ==> Will decide which Set of data needs to return through service. /// /// ==> ALL stands for specific Columns with All Data will return. /// /// <param name="JsonRequest">{"Operation":"ALL"}</param> /// <returns>Json Response Below</returns> ///[{"Api_Call_Log_Id": "GUID/NEWID","Create_User": "******","IsActive": true,"Operation": null,"Schedule_Datetime": "SomeDate","Schedule_Id": ""GUID/NEWID"","Status": "Pendsdfing","Task_Id": ""GUID/NEWID""}, ///{"Api_Call_Log_Id": "GUID/NEWID","Create_User": "******","IsActive": true,"Operation": null,"Schedule_Datetime": "SomeDate","Schedule_Id": ""GUID/NEWID"","Status": "Pendsdfing","Task_Id": ""GUID/NEWID""}] public List <DC_SchedulerServicesTasks> Get_Scheduled_Tasks(DC_SchedulerServicesTasks RqDC_SchedulerServices) { try { List <DC_SchedulerServicesTasks> List = new List <DC_SchedulerServicesTasks>(); IQueryable <DC_SchedulerServicesTasks> search; using (ConsumerEntities context = new ConsumerEntities()) { switch (RqDC_SchedulerServices.Operation) { case "ALL": search = from s in context.Supplier_Scheduled_Task select new DC_SchedulerServicesTasks { Task_Id = s.Task_Id, Schedule_Id = (Guid)s.Schedule_Id, Schedule_Datetime = (DateTime)s.Schedule_Datetime, Api_Call_Log_Id = (Guid)s.Api_Call_Log_Id, Status = s.Status, Create_User = s.Create_User, IsActive = (bool)s.IsActive }; return(search.ToList()); case "SCHEDULEID": search = from s in context.Supplier_Scheduled_Task where s.Schedule_Id == RqDC_SchedulerServices.Schedule_Id select new DC_SchedulerServicesTasks { Task_Id = s.Task_Id, Schedule_Id = (Guid)s.Schedule_Id, Schedule_Datetime = (DateTime)s.Schedule_Datetime, Api_Call_Log_Id = (Guid)s.Api_Call_Log_Id, Status = s.Status, Create_User = s.Create_User, IsActive = (bool)s.IsActive }; return(search.ToList()); case "TASKID": search = from s in context.Supplier_Scheduled_Task where s.Task_Id == RqDC_SchedulerServices.Task_Id select new DC_SchedulerServicesTasks { Task_Id = s.Task_Id, Schedule_Id = (Guid)s.Schedule_Id, Schedule_Datetime = (DateTime)s.Schedule_Datetime, Api_Call_Log_Id = (Guid)s.Api_Call_Log_Id, Status = s.Status, Create_User = s.Create_User, IsActive = (bool)s.IsActive }; return(search.ToList()); default: return(new List <DC_SchedulerServicesTasks>()); } } } catch { throw new FaultException <DataContracts.DC_ErrorStatus>(new DataContracts.DC_ErrorStatus { ErrorMessage = "Error while fetching Scheduled Tasks", 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 }); } }