public dynamic GetNotifications([FromBody] GetNCallsRequestData noti_post) { GetNotificationCallsResponseData noti_response = new GetNotificationCallsResponseData(); string userName; if (HttpContext.Current.Request.UrlReferrer.Host.Contains("localhost") && HttpContext.Current.Request.UrlReferrer.Port == 51268) { userName = "******";// HttpContext.Current.User.Identity.Name; } else { userName = HttpContext.Current.User.Identity.Name; } using (SqlConnection sqlCon = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["CC_ProdConn"].ConnectionString)) { SqlCommand sq = new NotificationLayer().PrepareParams("[getNotificationsReportByUser]", userName, noti_post); sq.CommandType = CommandType.StoredProcedure; sq.Connection = sqlCon; sq.CommandTimeout = int.MaxValue; SqlDataAdapter adapter = new SqlDataAdapter(sq); DataSet ds = new DataSet(); adapter.Fill(ds); List <NotificationByUser> usernot = new List <NotificationByUser>(); foreach (DataRow dr in ds.Tables[0].Rows) { NotificationByUser not = new NotificationByUser(); UserInformation ui = new UserInformation(); ui.userData = new User(); ui.userRole = new Role(); not.scorecard = new Scorecard() { scorecardName = dr.Field <string>("short_name"), scorecardId = dr.Field <int>("scorecard") }; ui.userData.userName = dr.Field <string>("userName"); ui.userData.userId = dr.Field <string>("userName"); ui.userRole.userRoleName = dr.Field <string>("user_role"); ui.userRole.userRoleId = dr.Field <string>("user_role"); not.app = new UserApp() { appName = dr.Field <string>("appname"), appId = dr.Field <string>("appname") }; not.user = ui; not.canWork = dr.Field <int>("canWork"); not.created = dr.Field <int>("created"); not.closed = dr.Field <int>("closed");; not.avgDaysOpen = dr.Field <double?>("avgDaysOpen"); usernot.Add(not); } return(usernot); } }
public dynamic GetNotificationCallss([FromBody] GetNCallsRequestData noti_post) { GetNotificationCallsResponseData noti_response = new GetNotificationCallsResponseData(); string userName; if (HttpContext.Current.Request.UrlReferrer.Host.Contains("localhost") && HttpContext.Current.Request.UrlReferrer.Port == 51268) { userName = "******";// HttpContext.Current.User.Identity.Name; } else { userName = HttpContext.Current.User.Identity.Name; } using (SqlConnection sqlCon = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["CC_ProdConn"].ConnectionString)) { SqlCommand sq = new NotificationLayer().PrepareParams("[getNotificationsReportByScorecard]", userName, noti_post); sq.CommandType = CommandType.StoredProcedure; sq.CommandTimeout = int.MaxValue; sq.Connection = sqlCon; SqlDataAdapter adapter = new SqlDataAdapter(sq); DataSet ds = new DataSet(); adapter.Fill(ds); List <NotificationByScorecard> scnot = new List <NotificationByScorecard>(); foreach (DataRow dr in ds.Tables[0].Rows) { NotificationByScorecard not = new NotificationByScorecard(); Scorecard sc = new Scorecard(); UserApp app = new UserApp(); sc.scorecardId = dr.Field <int>("scorecard"); sc.scorecardName = dr.Field <string>("scorecardName").ToString(); not.scorecard = sc; not.app = app; not.totalCount = dr.Field <int>("totalNotifications"); not.openedByCC = dr.Field <int>("openNotificationsByCC"); not.openedByClient = dr.Field <int>("openNotificationsByClient"); not.closedWithDisp = dr.Field <int>("closedWithDisp"); not.closedWithoutDisp = dr.Field <int>("closedWithoutDisp"); not.nonbillableTime = dr.Field <int>("nonbillableTime"); not.billableTime = dr.Field <int>("billableTime"); not.avgDaysOpen = dr.Field <int>("avgDaysOpen"); scnot.Add(not); } return(scnot); } }
public dynamic GetNotificationCalls([FromBody] GetNCallsRequestData noti_post) { GetNotificationCallsResponseData noti_response = new GetNotificationCallsResponseData(); string userName; if (HttpContext.Current.Request.UrlReferrer.Host.Contains("localhost") && HttpContext.Current.Request.UrlReferrer.Port == 51268) { userName = "******";// HttpContext.Current.User.Identity.Name; } else { userName = HttpContext.Current.User.Identity.Name; } using (SqlConnection sqlCon = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["CC_ProdConn"].ConnectionString)) { SqlCommand sq = new NotificationLayer().PrepareParams("[getNotificationsReportAllCals]", userName, noti_post); sq.CommandType = CommandType.StoredProcedure; sq.CommandTimeout = int.MaxValue; sq.Connection = sqlCon; SqlDataAdapter adapter = new SqlDataAdapter(sq); DataSet ds = new DataSet(); adapter.Fill(ds); DataTable notify_dt = ds.Tables[1]; int total = notify_dt.Rows[0].Field <int>("total"); List <Notification> notifications = new List <Notification>(); foreach (DataRow dr in ds.Tables[0].Rows) { Notification not = new Notification { app = new UserApp() { appId = dr.Field <string>("appname").ToString(), appName = dr.Field <string>("appname").ToString() } }; UserInformation ui = new UserInformation { userData = new User() }; ui.userData.userName = dr.Field <string>("assigned_to") == null ? "" : dr.Field <string>("assigned_to"); ui.userData.userId = dr.Field <string>("assigned_to") == null ? "" : dr.Field <string>("assigned_to"); ui.userRole = new Role { userRoleName = dr.Field <string>("role") == null ? "" : dr.Field <string>("role"), userRoleId = dr.Field <string>("role") == null ? "" : dr.Field <string>("role") }; not.assignTo = ui; not.calibratorName = ""; not.callType = dr.Field <string>("review_type") == null ? "" : dr.Field <string>("review_type"); not.closedDate = dr.Field <DateTime?>("date_closed"); not.notificationId = dr.Field <int>("FN_ID"); not.callId = dr.Field <int>("F_ID"); not.phone = dr.Field <string>("phone"); not.openDate = dr.Field <DateTime?>("date_created"); //not.questionInfo = not.reviewedDate = dr.Field <DateTime?>("review_date"); not.reviewerName = dr.Field <string>("reviewer") == null ? "" : dr.Field <string>("reviewer"); not.agentName = dr.Field <string>("agent") == null ? "" : dr.Field <string>("agent"); Scorecard sc = new Scorecard(); sc.scorecardId = dr.Field <int>("scorecard"); sc.scorecardName = dr.Field <string>("scorecard_name") == null ? "" : dr.Field <string>("scorecard_name"); not.scorecard = sc; //not.supervisor = ""; not.teamLeadName = dr.Field <string>("team_lead") == null ? "" : dr.Field <string>("team_lead"); not.notificationStatus = dr.Field <string>("notificationStatus") == null ? "" : dr.Field <string>("notificationStatus"); notifications.Add(not); } return(new { notifications, total }); } }