public ActionResult Index() { //Repetitition need to find a way to extract #region Repeated Page validation and navigation controll bool MyCookie = IsCookiePresentAndSessionValid("HIWSSettings"); ViewBag.TodaysDate = DateTime.Today.ToString("yyyy-MM-dd"); if (MyCookie == false) { return(RedirectToAction("Index", "Home")); } HttpCookie aCookie = Request.Cookies["HIWSSettings"]; List <string> somelist = new LogOnController().GenerateMenuForSession(aCookie["SessionGui"]); if (somelist != null) { StringBuilder astring = new StringBuilder(); foreach (string buttonString in somelist) { astring.Append(buttonString); } ViewBag.MenuHtml = astring.ToString(); } #endregion //End Repetition return(View()); }
public ActionResult MetaDataInput() { //Repetitition need to find a way to extract #region Repeated Page validation and navigation controll bool MyCookie = IsCookiePresentAndSessionValid("HIWSSettings"); if (MyCookie == false) { return(View("index")); } HttpCookie aCookie = Request.Cookies["HIWSSettings"]; List <string> somelist = new LogOnController().GenerateMenuForSession(aCookie["SessionGui"]); if (somelist != null) { StringBuilder astring = new StringBuilder(); foreach (string buttonString in somelist) { astring.Append(buttonString); } ViewBag.MenuHtml = astring.ToString(); } #endregion //End Repetition List <SelectListItem> obj = new List <SelectListItem>(); string connectionString = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString; using (SqlConnection connection = new SqlConnection(connectionString)) { using (SqlCommand command = new SqlCommand("SPU_HT_CMS_SelectMetadataTypes")) { command.CommandType = CommandType.StoredProcedure; command.Connection = connection; connection.Open(); SqlDataReader myReader = command.ExecuteReader(); while (myReader.Read()) { obj.Add(new SelectListItem { Text = myReader["MetadataCatagoryName"].ToString(), Value = myReader["MetadataCatagoryId"].ToString() }); } connection.Close(); } } obj.Insert(0, new SelectListItem { Text = "Please Select type..", Value = "0" }); ViewBag.MetadataType = obj; ViewBag.languageSelector = new SelectListItem { Text = "Please Select Language..", Value = "0" }; return(View()); }
public ActionResult Index() { //Repetitition need to find a way to extract #region Repeated Page validation and navigation controll bool MyCookie = IsCookiePresentAndSessionValid("HIWSSettings"); ViewBag.TodaysDate = DateTime.Today.ToString("yyyy-MM-dd"); if (MyCookie == false) { return(RedirectToAction("Index", "Home")); } HttpCookie aCookie = Request.Cookies["HIWSSettings"]; List <string> somelist = new LogOnController().GenerateMenuForSession(aCookie["SessionGui"]); if (somelist != null) { StringBuilder astring = new StringBuilder(); foreach (string buttonString in somelist) { astring.Append(buttonString); } ViewBag.MenuHtml = astring.ToString(); } #endregion //End Repetition var cookieValue = "0-0"; var myCookie = Request.Cookies["HIWSSettings"]; if (myCookie != null) { cookieValue = myCookie.Value; } var obj = ""; string connectionString = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString; using (SqlConnection connection = new SqlConnection(connectionString)) { using (SqlCommand command = new SqlCommand("SPU_HT_RetrivePermisionLevel")) { command.CommandType = CommandType.StoredProcedure; command.Parameters.AddWithValue("@Guid", cookieValue.Split('=')[1]); command.Connection = connection; connection.Open(); SqlDataReader myReader = command.ExecuteReader(); while (myReader.Read()) { obj = myReader["permisionLevel"].ToString(); } connection.Close(); } } ViewBag.Permision = obj; return(View()); }
public ActionResult Main() { //Repetitition need to find a way to extract #region Repeated Page validation and navigation controll bool MyCookie = IsCookiePresentAndSessionValid("HIWSSettings"); if (MyCookie == false) { return(View("index")); } HttpCookie aCookie = Request.Cookies["HIWSSettings"]; List <string> somelist = new LogOnController().GenerateMenuForSession(aCookie["SessionGui"]); if (somelist != null) { StringBuilder astring = new StringBuilder(); foreach (string buttonString in somelist) { astring.Append(buttonString); } ViewBag.MenuHtml = astring.ToString(); } #endregion //End Repetition string connectionString = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString; using (SqlConnection connection = new SqlConnection(connectionString)) { using (SqlCommand command = new SqlCommand("[dbo].[SPU_HT_Dashboard_Overview]")) { command.CommandType = CommandType.StoredProcedure; command.Parameters.AddWithValue("@Variable", aCookie["SessionGui"]); command.Connection = connection; connection.Open(); SqlDataReader myReader = command.ExecuteReader(); while (myReader.Read()) { ViewBag.FirstName = myReader["firstname"].ToString(); ViewBag.Surname = myReader["surname"].ToString(); ViewBag.PermisionLevel = Int32.Parse(myReader["permisionlevel"].ToString()); } connection.Close(); } } ViewBag.Title = "Main"; ViewBag.Header = "Welcome to hope.tools"; return(View()); }
public ActionResult ResendComformation(bool?error, bool?sucess) { //Repetitition need to find a way to extract #region Repeated Page validation and navigation controll bool MyCookie = IsCookiePresentAndSessionValid("HIWSSettings"); if (MyCookie == false) { return(RedirectToAction("Index", "Home")); } HttpCookie aCookie = Request.Cookies["HIWSSettings"]; List <string> somelist = new LogOnController().GenerateMenuForSession(aCookie["SessionGui"]); if (somelist != null) { StringBuilder astring = new StringBuilder(); foreach (string buttonString in somelist) { astring.Append(buttonString); } ViewBag.MenuHtml = astring.ToString(); } #endregion //End Repetition if (error != null) { ViewBag.HtmlStr = "<Div id=\"failureDiv\">The supplied OrderId was not valid.</div>"; } if (sucess != null) { ViewBag.HtmlStr = "<Div id=\"successDiv\">Confirmation Email Sent.</div>"; } return(View()); }
//Minuets public ActionResult Minutes() { //Repetitition need to find a way to extract #region Repeated Page validation and navigation controll bool MyCookie = IsCookiePresentAndSessionValid("HIWSSettings"); ViewBag.TodaysDate = DateTime.Today.ToString("yyyy-MM-dd"); if (MyCookie == false) { return(RedirectToAction("Index", "Home")); } HttpCookie aCookie = Request.Cookies["HIWSSettings"]; ViewBag.Gui = aCookie.Value; List <string> somelist = new LogOnController().GenerateMenuForSession(aCookie["SessionGui"]); if (somelist != null) { StringBuilder astring = new StringBuilder(); foreach (string buttonString in somelist) { astring.Append(buttonString); } ViewBag.MenuHtml = astring.ToString(); } #endregion //End Repetition List <SelectListItem> obj = new List <SelectListItem>(); List <SelectListItem> obj2 = new List <SelectListItem>(); List <SelectListItem> obj3 = new List <SelectListItem>(); obj.Add(new SelectListItem { Text = "Please Select One...", Value = "0" }); string connectionString = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString; #region Generate Active Channels dropdown using (SqlConnection connection = new SqlConnection(connectionString)) { using (SqlCommand command = new SqlCommand("SPU_HT_Get_Active_Channel")) { command.CommandType = CommandType.StoredProcedure; command.Connection = connection; connection.Open(); SqlDataReader myReader = command.ExecuteReader(); while (myReader.Read()) { obj.Add(new SelectListItem { Text = myReader["channelname"].ToString(), Value = myReader["channelid"].ToString() }); } connection.Close(); } } #endregion #region Generate Active Producers dropdown using (SqlConnection connection = new SqlConnection(connectionString)) { using (SqlCommand command = new SqlCommand("SPU_HT_Get_Active_Producers")) { command.CommandType = CommandType.StoredProcedure; command.Connection = connection; connection.Open(); SqlDataReader myReader = command.ExecuteReader(); while (myReader.Read()) { obj2.Add(new SelectListItem { Text = myReader["firstname"].ToString() + " " + myReader["lastname"].ToString(), Value = myReader["firstname"].ToString() + " " + myReader["lastname"].ToString() }); } connection.Close(); } } #endregion #region Generate Active Presenter dropdown using (SqlConnection connection = new SqlConnection(connectionString)) { using (SqlCommand command = new SqlCommand("SPU_HT_Get_Active_Presenter")) { command.CommandType = CommandType.StoredProcedure; command.Connection = connection; connection.Open(); SqlDataReader myReader = command.ExecuteReader(); while (myReader.Read()) { obj3.Add(new SelectListItem { Text = myReader["firstname"].ToString() + " " + myReader["lastname"].ToString(), Value = myReader["firstname"].ToString() + " " + myReader["lastname"].ToString() }); } connection.Close(); } } #endregion ViewBag.ActiveChannels = obj; ViewBag.ActiveProducers = obj2.OrderBy(o => o.Text).ToList();; ViewBag.ActivePresenters = obj3.OrderBy(o => o.Text).ToList();; return(View()); } //Done
public ActionResult FavoredBrandSelector(bool?compleate, FormCollection formCollection, int languageIdFromNonForm = 0) { //Repetitition need to find a way to extract #region Repeated Page validation and navigation controll bool MyCookie = IsCookiePresentAndSessionValid("HIWSSettings"); if (MyCookie == false) { return(View("index")); } HttpCookie aCookie = Request.Cookies["HIWSSettings"]; List <string> somelist = new LogOnController().GenerateMenuForSession(aCookie["SessionGui"]); if (somelist != null) { StringBuilder astring = new StringBuilder(); foreach (string buttonString in somelist) { astring.Append(buttonString); } ViewBag.MenuHtml = astring.ToString(); } #endregion //End Repetition var languageId = ""; if (languageIdFromNonForm == 0) { languageId = formCollection["ActiveLanguage"].ToString(); } else { languageId = languageIdFromNonForm.ToString(); } List <SelectListItem> obj = new List <SelectListItem>(); string connectionString = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString; using (SqlConnection connection = new SqlConnection(connectionString)) { using (SqlCommand command = new SqlCommand("SPU_HT_CMS_Retrieve_Brands")) { command.CommandType = CommandType.StoredProcedure; command.Parameters.AddWithValue("@LanguageId", languageId); command.Connection = connection; connection.Open(); SqlDataReader myReader = command.ExecuteReader(); while (myReader.Read()) { obj.Add(new SelectListItem { Text = myReader["name"].ToString(), Value = myReader["id"].ToString() + '-' + myReader["bareference"].ToString() }); } connection.Close(); } } ViewBag.FavoredBrand1 = obj; ViewBag.FavoredBrand2 = generateDropDownOrder(obj, 1); ViewBag.FavoredBrand3 = generateDropDownOrder(obj, 2); ViewBag.FavoredBrand4 = generateDropDownOrder(obj, 3); ViewBag.FavoredBrand5 = generateDropDownOrder(obj, 4); ViewBag.FavoredBrand6 = generateDropDownOrder(obj, 5); ViewBag.FavoredBrand7 = generateDropDownOrder(obj, 6); ViewBag.FavoredBrand8 = generateDropDownOrder(obj, 7); ViewBag.FavoredBrand9 = generateDropDownOrder(obj, 8); ViewBag.FavoredBrand0 = generateDropDownOrder(obj, 9); List <SelectListItem> hiddenObject = new List <SelectListItem>(); hiddenObject.Add(new SelectListItem { Text = languageId, Value = languageId }); ViewBag.ActiveLanguage = hiddenObject; if (compleate == true) { ViewBag.HtmlStr = "<Div id=\"CompleateDiv\">The Featured Brands have been updated.</div>"; } if (compleate == false) { ViewBag.HtmlStr = "<Div id=\"CompleateDiv\">The Featured Brands have NOT been updated, please select brands that are unique.</div>"; } return(View()); }