public static String GetUserPreference(int userID, int siteID, int programID, string preferenceType)
{
String _result = string.Empty;
using (var db = new Data.DBMEdition01Context())
{
ExceptionLogServices exceptionLog = new ExceptionLogServices();
try
{
var _ret = db.ApiGetUserPreference(userID, siteID, programID, preferenceType);
if (_ret.Count > 0)
{
_result = _ret.FirstOrDefault().PreferenceValue;
}
}
catch (Exception ex)
{
string sqlParam = "ApiMobileSaveTracerResponse(" + userID + "," + siteID + "," + programID + "," + preferenceType + ")";
string methodName = "JCRAPI/Business/UserServices/MenuStateInit";
exceptionLog.ExceptionLogInsert(ex.Message.ToString(), "", methodName, userID, siteID, sqlParam, string.Empty);
return(null);
}
}
return(_result);
}
public static void ReAssignTask(ReAssignTasks raTasks)
{
using (var db = new Data.DBMEdition01Context())
{
db.ApiReAssignTask(raTasks.LstTaskIDs, raTasks.AssignedToUserID, raTasks.CCUserIDs, raTasks.DueDate, raTasks.UpdatedByUserID);
}
}
public static void DeleteTasks(string taskIDs)
{
using (var db = new Data.DBMEdition01Context())
{
db.ApiDeleteTask(taskIDs);
}
}
public static void UpdateSiteEmailNotificationSettings(int?siteId, bool?sendEmailOnTaskCreation, bool?sendEmailBeforeTaskDue, int?daysBeforeTaskDue, bool?sendEmailsAfterTaskDue, int?daysAfterTaskDue, bool?sendRemainderEmailAfterTaskDue, bool?sendTaskReportToCC, int?taskReportToCCScheduleTypeId, bool?sendTaskReportToUsers, int?taskReportToUsersScheduleTypeId, string taskReportRecipients, bool?sendEmailOnAssigningEp, int?taskDueRecipientType, int?updatedByUserId)
{
using (var db = new Data.DBMEdition01Context())
{
db.ApiUpdateSiteEmailNotificationSettings(siteId, sendEmailOnTaskCreation, sendEmailBeforeTaskDue, daysBeforeTaskDue, sendEmailsAfterTaskDue, daysAfterTaskDue, sendRemainderEmailAfterTaskDue, sendTaskReportToCC, taskReportToCCScheduleTypeId, sendTaskReportToUsers, taskReportToUsersScheduleTypeId, taskReportRecipients, sendEmailOnAssigningEp, taskDueRecipientType, updatedByUserId);
}
}
public static void UpdateTaskObservationAssoc(int?tracerResponseId, string taskIDs)
{
using (var db = new Data.DBMEdition01Context())
{
db.ApiUpdateTaskObservationAssoc(tracerResponseId, taskIDs);
}
}
public static List <UserTaskEmail> GetTaskDetailsForSendingEmail(string taskIDs, int siteId, int programId, int userId, bool skipItemAssociated = false)
{
List <UserTaskEmail> _result;
string tracersTaskUrl = ConfigurationManager.AppSettings["TracersTaskUrl"].ToString();
using (var db = new Data.DBMEdition01Context())
{
_result = (from l in db.ApiGetTaskDetailsForSendingEmail(taskIDs, siteId, programId, userId, tracersTaskUrl, skipItemAssociated)
select new UserTaskEmail()
{
AssignedByEmail = l.AssignedByEmail,
AssignedByFirstName = l.AssignedByFirstName,
AssignedByLastName = l.AssignedByLastName,
AssignedOn = l.AssignedOn,
AssignedToEmail = l.AssignedToEmail,
AssignedToFirstName = l.AssignedToFirstName,
AssignedToLastName = l.AssignedToLastName,
CCUserIDs = l.CCUserIDs,
CompletionDetails = l.CompletionDetails,
CreateDate = l.CreateDate,
CreatedByEmail = l.CreatedByEmail,
CreatedByFirstName = l.CreatedByFirstName,
CreatedByLastName = l.CreatedByLastName,
DueDate = l.DueDate,
HCOID = l.HCOID,
ItemAssociated = l.ItemAssociated,
UpdatedByEmail = l.UpdatedByEmail,
UpdatedByFirstName = l.UpdatedByFirstName,
UpdatedByLastName = l.UpdatedByLastName,
ProgramID = l.ProgramID,
SiteID = l.SiteID,
SiteName = l.SiteName,
TaskDetails = l.TaskDetails,
TaskID = l.TaskID,
TaskLinkUrl = l.TaskLinkUrl,
TaskName = l.TaskName,
TaskStatus = l.TaskStatus,
TaskTypeID = l.TaskTypeID,
UpdateDate = l.UpdateDate,
AssignedByUserID = l.AssignedByUserID,
AssignedToUserID = l.AssignedToUserID,
CompletionDate = l.CompletionDate,
CreatedByUserID = l.CreatedByUserID,
UpdatedByUserID = l.UpdatedByUserID,
TaskStatusName = l.TaskStatusName,
CMSStandardID = l.CMSStandardID,
EPTextID = l.EPTextID,
TracerCustomID = l.TracerCustomID,
TracerQuestionAnswerID = l.TracerQuestionAnswerID,
TracerQuestionID = l.TracerQuestionID,
TracerResponseID = l.TracerResponseID,
ProgramName = l.ProgramName
}).ToList();
}
return(_result);
}
public static List <ApiGetTaskListReturnModel> GetTaskList(string standardEffDate, int?siteId, int?programId, int?assignedToUserId, int?assignedByUserId)
{
List <ApiGetTaskListReturnModel> _result;
using (var db = new Data.DBMEdition01Context())
{
_result = db.ApiGetTaskList(standardEffDate, siteId, programId, assignedToUserId, assignedByUserId);
}
return(_result);
}
public static List <ApiGetAmpTaskListByEpTextIdReturnModel> GetAMPTaskListByEPTextID(string standardEffDate, int siteId, int programId, int epTextId)
{
List <ApiGetAmpTaskListByEpTextIdReturnModel> _result;
using (var db = new Data.DBMEdition01Context())
{
_result = db.ApiGetAmpTaskListByEpTextId(standardEffDate, siteId, programId, epTextId);
}
return(_result);
}
public static List <ApiGetCmsTaskListByCmsStandardIdReturnModel> GetCMSTaskListByCMSStandardID(string standardEffDate, int siteId, int programId, int cmsStandardId)
{
List <ApiGetCmsTaskListByCmsStandardIdReturnModel> _result;
using (var db = new Data.DBMEdition01Context())
{
_result = db.ApiGetCmsTaskListByCmsStandardId(standardEffDate, siteId, programId, cmsStandardId);
}
return(_result);
}
public static ApiGetSiteEmailNotificationSettingsReturnModel GetSiteEmailNotificationSettings(int siteId)
{
ApiGetSiteEmailNotificationSettingsReturnModel _result;
using (var db = new Data.DBMEdition01Context())
{
_result = db.ApiGetSiteEmailNotificationSettings(siteId).FirstOrDefault();
}
return(_result);
}
public static ApiGetTaskFollowUpRemainderSettingsReturnModel GetTaskFollowUpRemainderSettings(int siteId)
{
ApiGetTaskFollowUpRemainderSettingsReturnModel _result;
using (var db = new Data.DBMEdition01Context())
{
_result = db.ApiGetTaskFollowUpRemainderSettings(siteId).FirstOrDefault();
}
return(_result);
}
public static string GetMaxTaskAssignedDate(string taskIds)
{
string MaxAssignedDate;
using (var db = new Data.DBMEdition01Context())
{
MaxAssignedDate = ((DateTime)db.ApiGetMaxTaskAssignedDate(taskIds).FirstOrDefault().AssignedDate).ToShortDateString();
}
return(MaxAssignedDate);
}
public static string UpdateUserTask(int?taskId, string taskName, int?taskTypeId, int?siteId, int?programId, string assignedDate, int?assignedToUserId, int?assignedByUserId, string taskDetails, string ccUserIDs, string dueDate, int?taskStatus, int?updatedByUserId, int?createdByUserId, int?tracerCustomId, int?tracerResponseId, int?tracerQuestionId, int?tracerQuestionAnswerId, int?epTextId, int?cmsStandardId, bool?ReminderEmailRequired, string taskresolution, string completeDate, string lstUsers)
{
ApiUpdateUserTaskReturnModel _dbResult;
using (var db = new Data.DBMEdition01Context())
{
_dbResult = db.ApiUpdateUserTask(taskId, taskName, taskTypeId, siteId, programId, assignedDate, assignedToUserId, assignedByUserId, taskDetails, ccUserIDs, dueDate, taskStatus, updatedByUserId, createdByUserId, tracerCustomId, tracerResponseId, tracerQuestionId, tracerQuestionAnswerId, epTextId, cmsStandardId, ReminderEmailRequired, taskresolution, completeDate, lstUsers).FirstOrDefault();
}
return(_dbResult.tasklist);
}
public static List <ApiGetStdDetailsByTracerQuestionReturnModel> GetStdDetailsByTracerQuestion(int?tracerCustomId, int?tracerResponseId, int?tracerQuestionId, bool?isGuestAccess)
{
List <ApiGetStdDetailsByTracerQuestionReturnModel> _result;
using (var db = new Data.DBMEdition01Context())
{
_result = db.ApiGetStdDetailsByTracerQuestion(tracerCustomId, tracerResponseId, tracerQuestionId, isGuestAccess);
}
return(_result);
}
public static ApiGetTracerQuestionInfoReturnModel GetTracerQuestionInfo(int?tracerCustomID, int?tracerQuestionId)
{
ApiGetTracerQuestionInfoReturnModel _result;
using (var db = new Data.DBMEdition01Context())
{
_result = db.ApiGetTracerQuestionInfo(tracerCustomID, tracerQuestionId).FirstOrDefault();
}
return(_result);
}
public static ApiGetTaskDetailsReturnModel GetTaskDetails(int?taskId, string standardEffBeginDate, int?programId)
{
ApiGetTaskDetailsReturnModel _dbResult;
using (var db = new Data.DBMEdition01Context())
{
_dbResult = db.ApiGetTaskDetails(taskId, Convert.ToDateTime(standardEffBeginDate), programId).FirstOrDefault();
}
return(_dbResult);
}
public static void DisableTaskNotificationScheduleType(Enums.DisableTaskNotificationScheduleType taskChangedType, int siteId, int userId, string lstTaskIDs = "")
{
try
{
using (var db = new Data.DBMEdition01Context())
{
db.ApiDisableTaskNotificationSchedules((int)taskChangedType, siteId, userId, lstTaskIDs);
}
}
catch (Exception ex)
{
string sqlParam = "";
string methodName = "SendTaskEmail";
new ExceptionLogServices().ExceptionLogInsert(ex.Message.ToString(), "", methodName, userId, null, sqlParam, string.Empty);
}
}
public void MultisiteAuditLogAction(int tracerID, int siteID, int userID, string msg)
{
int _result = 0;
try {
using (var db = new Data.DBMEdition01Context()) {
_result = db.ApiMultisiteAuditInsert(tracerID, siteID, userID, msg);
}
}
catch (Exception ex) {
StringBuilder sb = new StringBuilder();
sb.AppendFormat("EXEC dbo.ApiMultisiteAuditInsert @TracerCustomID='{0}', @SiteID='{1}', @UserID={2}, @Msg='{3}'", tracerID, siteID, userID, msg);
string sqlParam = sb.ToString();
string methodName = "JCRAPI/Business/TracerService/MultisiteAuditLogAction";
exceptionLog.ExceptionLogInsert(ex.Message.ToString(), "", methodName, null, tracerID, sqlParam, string.Empty);
}
}
public static void UpdateUserPreference(UserPreference userPref)
{
using (var db = new Data.DBMEdition01Context())
{
ExceptionLogServices exceptionLog = new ExceptionLogServices();
try
{
db.ApiUpdateUserPreference(userPref.UserID, userPref.SiteID, userPref.ProgramID, userPref.preferenceType, userPref.PreferenceValue);
}
catch (Exception ex)
{
string sqlParam = "ApiUpdateUserPreference(" + userPref.UserID + "," + userPref.SiteID + "," + userPref.ProgramID + "," + userPref.preferenceType + "," + userPref.PreferenceValue + ")";
string methodName = "JCRAPI/Business/UserServices/UpdateUserPreference";
exceptionLog.ExceptionLogInsert(ex.Message.ToString(), "", methodName, userPref.UserID, userPref.SiteID, sqlParam, string.Empty);
}
}
}
public static string GetAllsStdsByTracerQuestion(int?tracerCustomId, int?tracerResponseId, int?tracerQuestionId, bool?isGuestAccess)
{
List <ApiGetStdDetailsByTracerQuestionReturnModel> _dbResult;
string _result = string.Empty;
using (var db = new Data.DBMEdition01Context())
{
_dbResult = db.ApiGetStdDetailsByTracerQuestion(tracerCustomId, tracerResponseId, tracerQuestionId, isGuestAccess);
}
foreach (var item in _dbResult)
{
_result = _result.Length > 0 ? _result + ", " + item.StandardLabel : item.StandardLabel;
}
return(_result);
}
public List <ApiGetTargetSitesForDeleteReturnModel> GetTargetSitesForDelete(int tracerID, int userID)
{
List <ApiGetTargetSitesForDeleteReturnModel> _result;
try {
using (var db = new Data.DBMEdition01Context()) {
_result = db.ApiGetTargetSitesForDelete(tracerID, userID);
}
return(_result);
}
catch (Exception ex) {
StringBuilder sb = new StringBuilder();
sb.AppendFormat("EXEC dbo.apiGetTargetSitesForDelete @TracerCustomID='{0}', @UserID={1}", tracerID, userID);
string sqlParam = sb.ToString();
string methodName = "JCRAPI/Business/TracerService/GetTracersThatCanBeDeleted";
exceptionLog.ExceptionLogInsert(ex.Message.ToString(), "", methodName, null, tracerID, sqlParam, string.Empty);
return(null);
}
}
public List <ApiGetTracerQuestionsReturnModel> GetTracerQuestions(int tracerID)
{
List <ApiGetTracerQuestionsReturnModel> _result;
try {
using (var db = new Data.DBMEdition01Context()) {
_result = db.ApiGetTracerQuestions(tracerID);
}
return(_result);
}
catch (Exception ex) {
StringBuilder sb = new StringBuilder();
sb.AppendFormat("EXEC dbo.apiGetTracerQuestions @TracerID={0}", tracerID);
string sqlParam = sb.ToString();
string methodName = "JCRAPI/Business/TracerService/GetTracerQuestions";
exceptionLog.ExceptionLogInsert(ex.Message.ToString(), "", methodName, null, tracerID, sqlParam, string.Empty);
return(null);
}
}
public List <ApiSitesNoLongerAuthorizedToAccessReturnModel> SitesNoLongerAuthorizedToAccess(int tracerID, int userID)
{
List <ApiSitesNoLongerAuthorizedToAccessReturnModel> _result;
try {
using (var db = new Data.DBMEdition01Context()) {
_result = db.ApiSitesNoLongerAuthorizedToAccess(tracerID, userID);
}
return(_result);
}
catch (Exception ex) {
StringBuilder sb = new StringBuilder();
sb.AppendFormat("EXEC dbo.apiSitesNoLongerAuthorizedToAccess @TracerID='{0}', @UserID={1}", tracerID, userID);
string sqlParam = sb.ToString();
string methodName = "JCRAPI/Business/TracerService/SitesNoLongerAuthorizedToAccess";
exceptionLog.ExceptionLogInsert(ex.Message.ToString(), "", methodName, null, tracerID, sqlParam, string.Empty);
return(null);
}
}
public int OptOutOfSystemTracers(int tracerID, int userID)
{
int _result;
try {
using (var db = new Data.DBMEdition01Context()) {
_result = db.ApiOptOutOfSystemTracers(tracerID, userID);
}
return(_result);
}
catch (Exception ex) {
StringBuilder sb = new StringBuilder();
sb.AppendFormat("EXEC dbo.apiOptOutOfSystemTracers @TracerID='{0}', @UserID={1}", tracerID, userID);
string sqlParam = sb.ToString();
string methodName = "JCRAPI/Business/TracerService/OptOutOfSystemTracers";
exceptionLog.ExceptionLogInsert(ex.Message.ToString(), "", methodName, null, tracerID, sqlParam, string.Empty);
return(0);
}
}
public List <ApiUnlockedMasterValidationReturnModel> UnlockedMasterValidation(int tracerID, int userID)
{
List <ApiUnlockedMasterValidationReturnModel> _result;
try {
using (var db = new Data.DBMEdition01Context()) {
_result = db.ApiUnlockedMasterValidation(tracerID, userID);
}
return(_result);
}
catch (Exception ex) {
StringBuilder sb = new StringBuilder();
sb.AppendFormat("EXEC dbo.apiUnlockedMasterValidation @TracerID={0}, @UserID={1}", tracerID, userID);
string sqlParam = sb.ToString();
string methodName = "JCRAPI/Business/TracerService/UnlockedMasterValidation";
exceptionLog.ExceptionLogInsert(ex.Message.ToString(), "", methodName, null, tracerID, sqlParam, string.Empty);
return(null);
}
}
public bool UpdateTracerCategoryForTracer(int tracerCategoryId, int tracerCustomId, int updatedById)
{
try
{
using (var db = new Data.DBMEdition01Context())
{
db.ApiUpdateTracerCategoryForTracer(tracerCategoryId, tracerCustomId, updatedById);
}
return(true);
}
catch (Exception ex)
{
StringBuilder sb = new StringBuilder();
sb.AppendFormat("EXEC dbo.apiUpdateTracerCategoryForTracer @tracerCategoryId={0}, @tracerCustomId={1}, @updatedById={2}", tracerCategoryId, tracerCustomId, updatedById);
string sqlParam = sb.ToString();
string methodName = "JCRAPI/Business/TracerService/UpdateTracerCategoryForTracer";
exceptionLog.ExceptionLogInsert(ex.Message.ToString(), "", methodName, null, tracerCustomId, sqlParam, string.Empty);
return(false);
}
}
public List <ApiTracersBySiteProgramStatusReturnModel> GetTracersBySiteProgramStatus(int?programID, int?siteID, int?statusID, int?userID)
{
List <ApiTracersBySiteProgramStatusReturnModel> _result;
try {
using (var db = new Data.DBMEdition01Context()) {
_result = db.ApiTracersBySiteProgramStatus(siteID, programID, statusID, userID);
}
return(_result);
}
catch (Exception ex) {
StringBuilder sb = new StringBuilder();
// Fix for Bug 55857. Previous code had programID and siteID variables in reverse order.
sb.AppendFormat("EXEC dbo.apiTracersBySiteProgramStatus @ProgramID='{0}', @SiteID={1}, @StatusID={2}, @UserID={3}", programID, siteID, statusID, userID);
string sqlParam = sb.ToString();
string methodName = "JCRAPI/Business/TracerService/GetTracersBySiteProgramStatus";
exceptionLog.ExceptionLogInsert(ex.Message.ToString(), "", methodName, null, siteID, sqlParam, string.Empty);
return(null);
}
}
public List <ApiGetTracersThatCanBeCopiedReturnModel> GetTracersThatCanBeCopied(int siteID, int programID, int userID)
{
List <ApiGetTracersThatCanBeCopiedReturnModel> _result;
try {
using (var db = new Data.DBMEdition01Context()) {
_result = db.ApiGetTracersThatCanBeCopied(siteID, programID, userID);
}
return(_result);
}
catch (Exception ex) {
StringBuilder sb = new StringBuilder();
sb.AppendFormat("EXEC dbo.apiMultisiteCopy @SiteID='{0}', @ProgramID={1}, @UserID={2}", siteID, programID, userID);
string sqlParam = sb.ToString();
string methodName = "JCRAPI/Business/TracerService/GetTracersThatCanBeCopied";
exceptionLog.ExceptionLogInsert(ex.Message.ToString(), "", methodName, null, siteID, sqlParam, string.Empty);
return(null);
}
}
public List <ApiChangeMasterSiteReturnModel> ChangeMasterSite(int tracerID, int siteID, int userID)
{
List <ApiChangeMasterSiteReturnModel> _result;
try {
using (var db = new Data.DBMEdition01Context()) {
_result = db.ApiChangeMasterSite(tracerID, siteID, userID);
}
MultisiteAuditLogAction(tracerID, siteID, userID, _result[0].AuditMsg);
return(_result);
}
catch (Exception ex) {
StringBuilder sb = new StringBuilder();
sb.AppendFormat("EXEC dbo.apiChangeMasterSite @TracerID='{0}', @SiteID='{1}', @UserID={2}", tracerID, siteID, userID);
string sqlParam = sb.ToString();
string methodName = "JCRAPI/Business/TracerService/ChangeMasterSite";
exceptionLog.ExceptionLogInsert(ex.Message.ToString(), "", methodName, null, tracerID, sqlParam, string.Empty);
return(null);
}
}
public List <ApiMultisiteCopyReturnModel> MultisiteCopy(string selectedSites, int tracerID, bool isLocked, int userID)
{
List <ApiMultisiteCopyReturnModel> _result;
try {
using (var db = new Data.DBMEdition01Context()) {
db.Database.CommandTimeout = 360;
_result = db.ApiMultisiteCopy(selectedSites, tracerID, isLocked, userID);
}
return(_result);
}
catch (Exception ex) {
int trueFalse = isLocked ? 1 : 0;
StringBuilder sb = new StringBuilder();
sb.AppendFormat("EXEC dbo.apiMultisiteCopy @SelectedSites='{0}', @TracerID={1}, @UserID={2}, @IsLocked={3}",
selectedSites, tracerID, userID, trueFalse);
string sqlParam = sb.ToString();
string methodName = "JCRAPI/Business/TracerService/MultisiteCopy";
exceptionLog.ExceptionLogInsert(ex.Message.ToString(), "", methodName, userID, tracerID, sqlParam, string.Empty);
return(null);
}
}
