public DataTable ExportNotificationList(Search_Notification obj) { NotificationList objR = new NotificationList(); NotificationListDataManager objDM = new NotificationListDataManager(); DataSet ds = objDM.ExportNotificationList(obj); DataTable dt = new DataTable(); if (ds != null && ds.Tables.Count > 0) { int tblIndx = -1; #region "Notification List" tblIndx++; if (ds.Tables.Count > tblIndx && ds.Tables[tblIndx] != null && ds.Tables[tblIndx].Rows.Count > 0) { dt = ds.Tables[tblIndx]; //dt.Columns.Remove("ItemNumber"); //dt.Columns.Remove("NotificationId"); //dt.Columns.Remove("Actions"); //dt.Columns.Remove("StatusFlag"); //dt.Columns.Remove("StatusName"); } #endregion } return(dt); }
public ActionResult NotificationExport(string NotificationNumber, int CountryId, DateTime?FinalDateOfComments_From, DateTime?FinalDateOfComments_To, int NotificationType, int StatusId, int ActionId, string ActionStatus, DateTime?MeetingDate, string PendingFrom) { Search_Notification obj = new Search_Notification(); obj.NotificationNumber = NotificationNumber; obj.CountryId = CountryId; obj.FinalDateOfComments_From = FinalDateOfComments_From; obj.FinalDateOfComments_To = FinalDateOfComments_To; obj.NotificationType = NotificationType; obj.StatusId = StatusId; obj.ActionId = ActionId; obj.ActionStatus = ActionStatus; obj.MeetingDate = MeetingDate; obj.PendingFrom = PendingFrom; NotificationListBusinessService objBS = new NotificationListBusinessService(); using (DataTable dt = objBS.ExportNotificationList(obj)) { try { ExportToExcel(dt, "Notification-List", "Notification-List", "Notification-List"); } catch (Exception ex) { string str = ex.Message; } } return(View()); }
// GET: NotificationList public ActionResult Index(Search_Notification obj) { if (Convert.ToString(Session["UserId"]).Trim().Length > 0) { NotificationListBusinessService objBS = new NotificationListBusinessService(); return(View("~/Views/WTO/NotificationList.cshtml", objBS.PageLoad_NotificationsList(obj))); } else { return(RedirectToAction("Index", "Login")); } }
public IHttpActionResult GetNotificationsList(Search_Notification obj) { if (obj.PageIndex == 0) { obj.PageIndex = 1; } if (obj.PageSize == 0) { obj.PageSize = 10; } NotificationListBusinessService objBS = new NotificationListBusinessService(); return(Ok(objBS.GetNotifications(obj))); }
public DataSet ExportNotificationList(Search_Notification obj) { using (SqlCommand sqlCommand = new SqlCommand()) { sqlCommand.CommandType = CommandType.StoredProcedure; sqlCommand.CommandText = Procedures.ExportNotificationList; // sqlCommand.Parameters.AddWithValue("@PageIndex", obj.PageIndex); // sqlCommand.Parameters.AddWithValue("@PageSize", obj.PageSize); sqlCommand.Parameters.AddWithValue("@NotificationNumber", obj.NotificationNumber); sqlCommand.Parameters.AddWithValue("@CountryId", obj.CountryId); sqlCommand.Parameters.AddWithValue("@FinalDateOfComment_From", obj.FinalDateOfComments_From); sqlCommand.Parameters.AddWithValue("@FinalDateOfComment_To", obj.FinalDateOfComments_To); sqlCommand.Parameters.AddWithValue("@NotificationType", obj.NotificationType); sqlCommand.Parameters.AddWithValue("@Status", obj.StatusId); sqlCommand.Parameters.AddWithValue("@Action", obj.ActionId); sqlCommand.Parameters.AddWithValue("@ActionStatus", obj.ActionStatus); sqlCommand.Parameters.AddWithValue("@MeetingDate", obj.MeetingDate); sqlCommand.Parameters.AddWithValue("@PendingStatusFrom", obj.PendingFrom); return(DAL.GetDataSet(ConfigurationHelper.connectionString, sqlCommand)); } }
public Notifications GetNotifications(Search_Notification obj) { Notifications objR = new Notifications(); NotificationListDataManager objDM = new NotificationListDataManager(); DataSet ds = objDM.Notifications(obj); if (ds != null && ds.Tables.Count > 0) { int tblIndx = -1; tblIndx++; if (ds.Tables.Count > tblIndx && ds.Tables[tblIndx] != null && ds.Tables[tblIndx].Rows.Count > 0) { List <BusinessObjects.Notification.Notification> ItemsList = new List <BusinessObjects.Notification.Notification>(); foreach (DataRow dr in ds.Tables[tblIndx].Rows) { BusinessObjects.Notification.Notification objItems = new BusinessObjects.Notification.Notification(); objItems.NotificationId = Convert.ToInt64(dr["NotificationId"]); objItems.ItemNumber = Convert.ToInt64(dr["ItemNumber"]); objItems.NotificationNumber = Convert.ToString(dr["NotificationNumber"]); objItems.NotificationDate = Convert.ToString(dr["DateOfNotification"]); objItems.FinalDateOfComments = Convert.ToString(dr["FinalDateOfComment"]); objItems.Country = Convert.ToString(dr["Country"]); objItems.Title = Convert.ToString(dr["Title"]); objItems.MailCount = Convert.ToInt32(dr["MailCount"]); objItems.ResponseCount = Convert.ToInt32(dr["ResponseCount"]); objItems.Actions = Convert.ToString(dr["Actions"]); objItems.MeetingDate = Convert.ToString(dr["MeetingDate"]); objItems.IsInMeeting = Convert.ToBoolean(dr["IsInMeeting"]); ItemsList.Add(objItems); } objR.ItemsList = ItemsList; } #region "Paging" tblIndx++; if (ds.Tables.Count > tblIndx && ds.Tables[tblIndx] != null && ds.Tables[tblIndx].Rows.Count > 0) { objR.TotalCount = Convert.ToString(ds.Tables[tblIndx].Rows[0]["TotalCount"]); objR.Pager = new Pager(Convert.ToInt32(objR.TotalCount), Convert.ToInt16(obj.PageIndex)); } #endregion #region "Notification Process Dots Color & Tooltip Text" tblIndx++; if (ds.Tables.Count > tblIndx && ds.Tables[tblIndx] != null && ds.Tables[tblIndx].Rows.Count > 0) { List <NotificationProcessDot> NPSList = new List <NotificationProcessDot>(); foreach (DataRow dr in ds.Tables[tblIndx].Rows) { NotificationProcessDot objNPS = new NotificationProcessDot(); objNPS.NotificationId = Convert.ToInt64(dr["NotificationId"]); objNPS.ColorCode = Convert.ToString(dr["ColorCode"]); objNPS.TooltipText = Convert.ToString(dr["TooltipText"]); objNPS.Sequence = Convert.ToInt32(dr["Sequence"]); NPSList.Add(objNPS); } objR.NotificationProcessDots = NPSList; } #endregion #region "Notification Action Dots Color & Tooltip Text" tblIndx++; if (ds.Tables.Count > tblIndx && ds.Tables[tblIndx] != null && ds.Tables[tblIndx].Rows.Count > 0) { List <NotificationActionDot> NASList = new List <NotificationActionDot>(); foreach (DataRow dr in ds.Tables[tblIndx].Rows) { NotificationActionDot objNAS = new NotificationActionDot(); objNAS.NotificationId = Convert.ToInt64(dr["NotificationId"]); objNAS.ColorCode = Convert.ToString(dr["ColorCode"]); objNAS.TooltipText = Convert.ToString(dr["TooltipText"]); objNAS.Sequence = Convert.ToInt32(dr["Sequence"]); NASList.Add(objNAS); } objR.NotificationActionDots = NASList; } #endregion } return(objR); }
public NotificationList PageLoad_NotificationsList(Search_Notification obj) { NotificationList objR = new NotificationList(); NotificationListDataManager objDM = new NotificationListDataManager(); DataSet ds = objDM.GetPageLoad_NotificationsList(obj); if (ds != null && ds.Tables.Count > 0) { int tblIndx = -1; #region "Country List" tblIndx++; if (ds.Tables.Count > tblIndx && ds.Tables[tblIndx] != null && ds.Tables[tblIndx].Rows.Count > 0) { List <Country> CountryList = new List <Country>(); foreach (DataRow dr in ds.Tables[tblIndx].Rows) { Country objCountry = new Country(); objCountry.CountryId = Convert.ToInt64(dr["CountryId"]); objCountry.CountryCode = Convert.ToString(dr["CountryCode"]); objCountry.Name = Convert.ToString(dr["Country"]); CountryList.Add(objCountry); } objR.CountryList = CountryList; } #endregion #region "Status List" tblIndx++; if (ds.Tables.Count > tblIndx && ds.Tables[tblIndx] != null && ds.Tables[tblIndx].Rows.Count > 0) { List <StatusMaster> StatusList = new List <StatusMaster>(); foreach (DataRow dr in ds.Tables[tblIndx].Rows) { StatusMaster objStatus = new StatusMaster(); objStatus.StatusId = Convert.ToInt32(dr["StatusId"]); objStatus.Status = Convert.ToString(dr["Status"]); StatusList.Add(objStatus); } objR.StatusList = StatusList; } #endregion #region "Action List" tblIndx++; if (ds.Tables.Count > tblIndx && ds.Tables[tblIndx] != null && ds.Tables[tblIndx].Rows.Count > 0) { List <ActionMaster> ActionList = new List <ActionMaster>(); foreach (DataRow dr in ds.Tables[tblIndx].Rows) { ActionMaster objAction = new ActionMaster(); objAction.ActionId = Convert.ToInt32(dr["ActionId"]); objAction.Action = Convert.ToString(dr["Action"]); ActionList.Add(objAction); } objR.ActionList = ActionList; } #endregion #region "Action Status List" tblIndx++; if (ds.Tables.Count > tblIndx && ds.Tables[tblIndx] != null && ds.Tables[tblIndx].Rows.Count > 0) { List <Status> StatusList = new List <Status>(); foreach (DataRow dr in ds.Tables[tblIndx].Rows) { Status objStatus = new Status(); objStatus.StatusId = Convert.ToInt32(dr["StatusId"]); objStatus.StatusName = Convert.ToString(dr["Status"]); StatusList.Add(objStatus); } objR.ActionStatusList = StatusList; } #endregion #region "Notification List" tblIndx++; if (ds.Tables.Count > tblIndx && ds.Tables[tblIndx] != null && ds.Tables[tblIndx].Rows.Count > 0) { List <BusinessObjects.Notification.Notification> ItemsList = new List <BusinessObjects.Notification.Notification>(); foreach (DataRow dr in ds.Tables[tblIndx].Rows) { BusinessObjects.Notification.Notification objItems = new BusinessObjects.Notification.Notification(); objItems.NotificationId = Convert.ToInt64(dr["NotificationId"]); objItems.ItemNumber = Convert.ToInt64(dr["ItemNumber"]); objItems.NotificationNumber = Convert.ToString(dr["NotificationNumber"]); objItems.NotificationDate = Convert.ToString(dr["DateOfNotification"]); objItems.FinalDateOfComments = Convert.ToString(dr["FinalDateOfComment"]); objItems.Country = Convert.ToString(dr["Country"]); objItems.Title = Convert.ToString(dr["Title"]); objItems.MailCount = Convert.ToInt32(dr["MailCount"]); objItems.ResponseCount = Convert.ToInt32(dr["ResponseCount"]); objItems.Actions = Convert.ToString(dr["Actions"]); objItems.MeetingDate = Convert.ToString(dr["MeetingDate"]); objItems.IsInMeeting = Convert.ToBoolean(dr["IsInMeeting"]); ItemsList.Add(objItems); } objR.Notifications = ItemsList; } #endregion #region "Notification Count" tblIndx++; if (ds.Tables.Count > tblIndx && ds.Tables[tblIndx] != null && ds.Tables[tblIndx].Rows.Count > 0) { objR.TotalCount = Convert.ToInt64(ds.Tables[tblIndx].Rows[0]["TotalCount"]); } #endregion #region "Notification Process Dots Color & Tooltip Text" tblIndx++; if (ds.Tables.Count > tblIndx && ds.Tables[tblIndx] != null && ds.Tables[tblIndx].Rows.Count > 0) { List <NotificationProcessDot> NPSList = new List <NotificationProcessDot>(); foreach (DataRow dr in ds.Tables[tblIndx].Rows) { NotificationProcessDot objNPS = new NotificationProcessDot(); objNPS.NotificationId = Convert.ToInt64(dr["NotificationId"]); objNPS.ColorCode = Convert.ToString(dr["ColorCode"]); objNPS.TooltipText = Convert.ToString(dr["TooltipText"]); objNPS.Sequence = Convert.ToInt32(dr["Sequence"]); NPSList.Add(objNPS); } objR.NotificationProcessDots = NPSList; } #endregion #region "Notification Action Dots Color & Tooltip Text" tblIndx++; if (ds.Tables.Count > tblIndx && ds.Tables[tblIndx] != null && ds.Tables[tblIndx].Rows.Count > 0) { List <NotificationActionDot> NASList = new List <NotificationActionDot>(); foreach (DataRow dr in ds.Tables[tblIndx].Rows) { NotificationActionDot objNAS = new NotificationActionDot(); objNAS.NotificationId = Convert.ToInt64(dr["NotificationId"]); objNAS.ColorCode = Convert.ToString(dr["ColorCode"]); objNAS.TooltipText = Convert.ToString(dr["TooltipText"]); objNAS.Sequence = Convert.ToInt32(dr["Sequence"]); NASList.Add(objNAS); } objR.NotificationActionDots = NASList; } #endregion } return(objR); }