public JobsGuidResponse EditJob(Guid guid, [FromBody] Job oJob)
{
JobsGuidResponse oJobsGuidResponse = new JobsGuidResponse();
Guid gJobGuid = new Guid();
ServerResponse.ResponseCodes eResponse = oJobsBL.EditJob(out gJobGuid, guid, oJob);
oJobsGuidResponse.data = new singlejobguid {
guid = gJobGuid
};
oJobsGuidResponse.meta.code = Convert.ToInt32(eResponse);
oJobsGuidResponse.meta.error_message = ServerResponse.GetResponse(eResponse);
return(oJobsGuidResponse);
}
// [Route("{guid}")]
public JobsResponse GetJobByGuid(Guid guid)
{
JobsResponse oMultipleJobResponse = new JobsResponse();
{
List <Jobs> liJobs = new List <Jobs>();
ServerResponse.ResponseCodes eResponse = oJobsBL.GetJobByJobId(out liJobs, guid);
oMultipleJobResponse.data = new multiplejobresponse {
jobs = liJobs
};
oMultipleJobResponse.meta.error_message = ServerResponse.GetResponse(eResponse);
oMultipleJobResponse.meta.code = Convert.ToInt32(eResponse);
return(oMultipleJobResponse);
}
}
public ServerResponse.ResponseCodes GetTemplates(out List <Templates> liTemplates, bool?ActiveOnly = true, long?lCreatedFor = null, bool?bAutoGenerateOnly = null, int?iCategoryId = null, double?dMaxDuration = null, string SearchTerm = null, bool bCleanObject = true, [CallerMemberName] string callingMethod = "", [CallerLineNumber] int callingFileLineNumber = 0, int pageNo = 0, int pageSize = 9, string sortColumn = "created", string sortOrder = "DESC", string siteType = "web", int jobid = 0)
{
liTemplates = null;
ServerResponse.ResponseCodes eResponse = ServerResponse.ResponseCodes.Internal_Error;
liTemplates = GetTemplates(null, ActiveOnly, null, null, lCreatedFor, null, false, false, bAutoGenerateOnly, iCategoryId, null, dMaxDuration, SearchTerm, bCleanObject, callingMethod, callingFileLineNumber, pageNo, pageSize, sortColumn, sortOrder, siteType);
if (liTemplates != null && liTemplates.Count > 0)
{
eResponse = ServerResponse.ResponseCodes.Success;
}
else
{
eResponse = ServerResponse.ResponseCodes.NoResultFound;
}
return(eResponse);
}
public JobElementsResponse GetJobElementsByJobGuid(Guid guid)
{
JobElementsResponse oJobElementsResponse = new JobElementsResponse();
{
JobElementsBL oTemplateElementsBL = new JobElementsBL();
List <JobElements> liJobElements = new List <JobElements>();
ServerResponse.ResponseCodes eResponse = oTemplateElementsBL.GetJobElementsByJobGuid(out liJobElements, guid);
oJobElementsResponse.data = new multiplejobelementsresponse {
JobElements = liJobElements
};
oJobElementsResponse.meta.error_message = ServerResponse.GetResponse(eResponse);
oJobElementsResponse.meta.code = Convert.ToInt32(eResponse);
}
return(oJobElementsResponse);
}
public TemplateElementsResponse GetTemplateElementsByTemplateGuid(Guid guid)
{
TemplateElementsResponse oTemplateElementsResponse = new TemplateElementsResponse();
{
TemplatesBL oTemplateElementsBL = new TemplatesBL();
List <TemplateElements> liTemplateElements = new List <TemplateElements>();
ServerResponse.ResponseCodes eResponse = oTemplateElementsBL.GetTemplateElementsByTemplateGuid(out liTemplateElements, guid);
oTemplateElementsResponse.data = new multipletemplateelementsresponse {
TemplateElements = liTemplateElements
};
oTemplateElementsResponse.meta.error_message = ServerResponse.GetResponse(eResponse);
oTemplateElementsResponse.meta.code = Convert.ToInt32(eResponse);
}
return(oTemplateElementsResponse);
}
public TemplateResponse GetTemplateByGuid(Guid id)
{
TemplateResponse oSingleTemplateResponse = new TemplateResponse();
{
TemplatesBL oTemplatesBL = new TemplatesBL();
Templates oTemplates = new Templates();
ServerResponse.ResponseCodes eResponse = oTemplatesBL.GetTemplateByTemplateGuid(out oTemplates, id);
oSingleTemplateResponse.data = new singleTemplateresponse {
Template = oTemplates
};
oSingleTemplateResponse.meta.error_message = ServerResponse.GetResponse(eResponse);
oSingleTemplateResponse.meta.code = Convert.ToInt32(eResponse);
}
return(oSingleTemplateResponse);
}
public ServerResponse.ResponseCodes EditJob(out Guid gJobGuid, Guid guid, Job oJob)
{
ServerResponse.ResponseCodes eResponse = ServerResponse.ResponseCodes.Internal_Error;
gJobGuid = Guid.Empty;
try
{
using (SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["DemoVideoBurstConnection"].ConnectionString))
{
using (SqlCommand cmd = new SqlCommand())
{
cmd.Connection = conn;
cmd.CommandType = CommandType.Text;
cmd.CommandText = @"Update [tblJobs] set [title]= @Title,[callback]=@CallBack,[clickurl]=@ClickUrl,[templateguid]=@templateguid where guid=@jobguid IF(@@ROWCOUNT>0)
BEGIN
SELECT [guid] FROM [tblJobs] WHERE guid=@jobguid
END
";
cmd.Parameters.AddWithValue("@Title", oJob.title);
cmd.Parameters.AddWithValue("@CallBack", oJob.callback.ToString());
cmd.Parameters.AddWithValue("@ClickUrl", oJob.clickurl);
cmd.Parameters.AddWithValue("@templateguid", oJob.templateguid);
cmd.Parameters.AddWithValue("@jobguid", guid);
conn.Open();
object oReturnValue = cmd.ExecuteScalar();
JobElementsBL oJobElementsBL = new JobElementsBL();
// Newly Added Code
if (oReturnValue != null && !String.IsNullOrEmpty(Convert.ToString(oReturnValue)) && oJobElementsBL.EditJobElements(oJob.elements, guid))
{
gJobGuid = new Guid(Convert.ToString(oReturnValue));
eResponse = ServerResponse.ResponseCodes.Success;
}
else
{
eResponse = ServerResponse.ResponseCodes.DatabaseInsertionError;
}
}
}
}
catch (Exception ex)
{
eResponse = ServerResponse.ResponseCodes.Internal_Error;
}
return(eResponse);
}
public TemplatesResponse GetTemplates()
{
TemplatesResponse oTemplatesResponse = new TemplatesResponse();
{
TemplatesBL oTemplatesBL = new TemplatesBL();
List <Templates> liTemplates = new List <Templates>();
ServerResponse.ResponseCodes eResponse = ServerResponse.ResponseCodes.Internal_Error;
eResponse = oTemplatesBL.GetAllTemplates(out liTemplates);
oTemplatesResponse.data = new multipleTemplateresponse {
Templates = liTemplates
};
oTemplatesResponse.meta.error_message = ServerResponse.GetResponse(eResponse);
oTemplatesResponse.meta.code = Convert.ToInt32(eResponse);
}
return(oTemplatesResponse);
}
public ServerResponse.ResponseCodes GetAllTemplates(out List <Templates> pTemplates)
{
pTemplates = null;
ServerResponse.ResponseCodes eResponse = ServerResponse.ResponseCodes.Internal_Error;
List <Templates> liTemplates = GetAllTemplates();
if (liTemplates != null && liTemplates.Count > 0)
{
pTemplates = liTemplates;
eResponse = ServerResponse.ResponseCodes.Success;
}
else
{
eResponse = ServerResponse.ResponseCodes.NoResultFound;
}
return(eResponse);
}
public ServerResponse.ResponseCodes GetTemplateByTemplateGuid(out Templates pTemplates, Guid id)
{
pTemplates = null;
ServerResponse.ResponseCodes eResponse = ServerResponse.ResponseCodes.Internal_Error;
List <Templates> liTemplates = GetTemplates(id);
if (liTemplates != null && liTemplates.Count > 0)
{
pTemplates = liTemplates[0];
eResponse = ServerResponse.ResponseCodes.Success;
}
else
{
eResponse = ServerResponse.ResponseCodes.NoResultFound;
}
return(eResponse);
}
public ServerResponse.ResponseCodes GetTemplateElementsByTemplateGuid(out List <TemplateElements> liTemplateElements, Guid?gTemplateGuid)
{
liTemplateElements = null;
ServerResponse.ResponseCodes eResponse = ServerResponse.ResponseCodes.Internal_Error;
if (gTemplateGuid != null)
{
liTemplateElements = GetTemplatesElements(gTemplateGuid);
if (liTemplateElements != null && liTemplateElements.Count > 0)
{
eResponse = ServerResponse.ResponseCodes.Success;
}
else
{
eResponse = ServerResponse.ResponseCodes.NoResultFound;
}
}
else
{
eResponse = ServerResponse.ResponseCodes.InvalidParams;
}
return(eResponse);
}
public ServerResponse.ResponseCodes GetJobByJobId(out List <Jobs> oJob, Guid lJobId)
{
ServerResponse.ResponseCodes eResponse = ServerResponse.ResponseCodes.Internal_Error;
oJob = null;
if (lJobId != null)
{
oJob = GetJobs(lJobId);
if (oJob != null && oJob.Count > 0)
{
eResponse = ServerResponse.ResponseCodes.Success;
//oJob = liJobs[0];
}
else
{
eResponse = ServerResponse.ResponseCodes.NoResultFound;
}
}
else
{
eResponse = ServerResponse.ResponseCodes.InvalidParams;
}
return(eResponse);
}
public ServerResponse.ResponseCodes GetTemplateByTemplateGuid(out Templates pTemplates, Guid?gTemplateGuid, bool?ActiveOnly = true, int?iStatus = null, bool bCleanObject = true, [CallerMemberName] string callingMethod = "", [CallerLineNumber] int callingFileLineNumber = 0, long jobid = 0, string jobStatus = "")
{
pTemplates = null;
ServerResponse.ResponseCodes eResponse = ServerResponse.ResponseCodes.Internal_Error;
if (gTemplateGuid != null)
{
if (oStats != null && oStats.contentid == null)
{
Templates oTemplatesTemp = null;
ServerResponse.ResponseCodes eResponseCode = GetTemplateByTemplateGuid(out oTemplatesTemp, null, lUserId, gTemplateGuid, ActiveOnly, iStatus);
if (eResponseCode == ServerResponse.ResponseCodes.Success && oTemplatesTemp != null)
{
oStats.contentid = oTemplatesTemp.id;
}
}
if (oStats != null && oStats.details != null)
{
oStats.details.jsonobjectname = "gTemplateGuid";
oStats.details.json = Newtonsoft.Json.JsonConvert.SerializeObject(gTemplateGuid);
}
List <Templates> liTemplates = GetTemplates(oStats, lUserId, iStatus, ActiveOnly, gTemplateGuid, null, null, null, false, false, null, null, null, null, null, bCleanObject, callingMethod, callingFileLineNumber, 0, 9, "created", "DESC", "web", jobid, jobStatus);
if (liTemplates != null && liTemplates.Count > 0)
{
pTemplates = liTemplates[0];
eResponse = ServerResponse.ResponseCodes.Success;
}
else
{
eResponse = ServerResponse.ResponseCodes.NoResultFound;
}
}
else
{
eResponse = ServerResponse.ResponseCodes.InvalidParams;
}
return(eResponse);
}
public ServerResponse.ResponseCodes AddJob(out Guid gJobGuid, Job oJob)
{
ServerResponse.ResponseCodes eResponse = ServerResponse.ResponseCodes.Internal_Error;
gJobGuid = Guid.Empty;
try
{
using (SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["DemoVideoBurstConnection"].ConnectionString))
{
using (SqlCommand cmd = new SqlCommand())
{
cmd.Connection = conn;
cmd.CommandType = CommandType.Text;
cmd.CommandText = @"INSERT INTO [tblJobs] ( [title],[callback],[clickurl],[callbackformat],[templateguid],[companyid],[createdby]) VALUES (@Title, @CallBack, @ClickUrl, 'JSON', @templateguid, 817, 10721) IF(@@ROWCOUNT>0)
BEGIN
SELECT [guid] FROM [tblJobs] WHERE id=SCOPE_IDENTITY()
END
";
cmd.Parameters.AddWithValue("@Title", oJob.title);
cmd.Parameters.AddWithValue("@CallBack", oJob.callback.ToString());
cmd.Parameters.AddWithValue("@ClickUrl", oJob.clickurl);
cmd.Parameters.AddWithValue("@templateguid", oJob.templateguid);
conn.Open();
object oReturnValue = cmd.ExecuteScalar();
JobElementsBL oJobElementsBL = new JobElementsBL();
// Newly Added Code
if (oReturnValue != null && !String.IsNullOrEmpty(Convert.ToString(oReturnValue)) && oJobElementsBL.AddJobElements(oJob.elements, oJob.templateguid, new Guid(oReturnValue.ToString())))
{
//oJobElementsBL.AddJobElements(oJob.elements, oJob.templateguid, new Guid(oReturnValue.ToString()));
gJobGuid = new Guid(Convert.ToString(oReturnValue));
eResponse = ServerResponse.ResponseCodes.Success;
}
else
{
eResponse = ServerResponse.ResponseCodes.DatabaseInsertionError;
}
//Previous Code
//if (oReturnValue != null
// && !String.IsNullOrEmpty(Convert.ToString(oReturnValue))
// && oJobElementsBL.EditJobElements(oJob.elements, new Guid(oReturnValue.ToString())))
//{
// gJobGuid = new Guid(Convert.ToString(oReturnValue));
// eResponse = ServerResponse.ResponseCodes.Success;
// ServerResponse.ResponseCodes eResponseCode = GetJobByJobGuid(out oJob, null, lUserId, gJobGuid);
// //Add Stats
// if (oStats != null && oStats.contentid == null)
// {
// if (eResponseCode == ServerResponse.ResponseCodes.Success && oJob != null)
// oStats.contentid = oJob.id;
// }
//}
//else
//{
// eResponse = ServerResponse.ResponseCodes.DatabaseInsertionError;
// if (oStats != null && oStats.details != null)
// {
// oStats.details.message = "Failed to add the job.";
// }
//}
}
}
}
catch (Exception ex)
{
}
return(eResponse);
}