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
});
}
}
