public void ApplyRule(RewriteContext context) { var request = context.HttpContext.Request; // Add null company //var emptyCompany = new Company(); //emptyCompany.CompanyCode = ""; //emptyCompany.CompanyName = ""; //context.HttpContext.Session.SetObjectAsJson("CompanyName", emptyCompany); //context.HttpContext.Session.SetString("CompanyName", ""); // store byte array // if already redirected, skip if (request.Path.StartsWithSegments(new PathString(this.newPath))) { return; } var aCompany = new List <string>(); var resultTable = new RawSQLDataProvider().Execute("SELECT [CompanyCode] FROM [Companies]"); foreach (DataRow row in resultTable.Rows) { aCompany.Add(row["CompanyCode"].ToString()); } if (aCompany.Contains(request.Path.Value.Replace("/", ""))) { var newLocation = $"{this.newPath}{request.Path.Value.Replace("/", "")}"; var response = context.HttpContext.Response; response.StatusCode = StatusCodes.Status302Found; context.Result = RuleResult.EndResponse; response.Headers[HeaderNames.Location] = newLocation; } }
// GET: GeneralSurveys public async Task <IActionResult> Index() { var gsList = new List <GeneralSurvey>(); var resultTable = new RawSQLDataProvider().Execute("SELECT * FROM [dbo].[GeneralSurveyReport]"); foreach (DataRow row in resultTable.Rows) { GeneralSurvey gs = new GeneralSurvey(); gs.Action = row["Action"].ToString(); gs.AmbienceComment = row["AmbienceComment"].ToString(); gs.AmbienceRate = int.Parse(row["AmbienceRate"].ToString()); gs.CheckNo = row["CheckNo"].ToString(); gs.CompanyId = int.Parse(row["CompanyId"].ToString()); gs.CountryId = int.Parse(row["CountryId"].ToString()); gs.Customer = row["Customer"].ToString(); gs.DateTime = DateTime.Parse(row["DateTime"].ToString()); gs.Email = row["Email"].ToString(); gs.MemberEmail = row["MemberEmail"].ToString(); gs.MemberFirstName = row["MemberFirstName"].ToString(); gs.MemberId = int.Parse(row["MemberId"].ToString()); gs.MemberLastName = row["MemberLastName"].ToString(); gs.ManagerEmail = row["ManagerEmail"].ToString(); gs.ManagerFirstName = row["ManagerFirstName"].ToString(); gs.ManagerId = int.Parse(row["ManagerId"].ToString()); gs.ManagerLastName = row["ManagerLastName"].ToString(); gs.LastVisit = row["LastVisit"].ToString(); gs.LastVisitComment = row["LastVisitComment"].ToString(); gs.ManagerId = int.Parse(row["ManagerId"].ToString()); gs.MobileNo = row["MobileNo"].ToString(); gs.OutletAddress = row["OutletAddress"].ToString(); gs.OutletId = int.Parse(row["OutletId"].ToString()); gs.OutletName = row["OutletName"].ToString(); gs.QualityComment = row["QualityComment"].ToString(); gs.QualityRate = int.Parse(row["QualityRate"].ToString()); gs.RecommendImprovements = row["RecommendImprovements"].ToString(); gs.RecommendPoorArea = row["RecommendPoorArea"].ToString(); gs.RecommendRate = int.Parse(row["RecommendRate"].ToString()); gs.RecommendSuggestions = row["RecommendSuggestions"].ToString(); int rsolutionLogId = 0; int.TryParse(row["ResolutionLogId"].ToString(), out rsolutionLogId); gs.ResolutionLogId = rsolutionLogId; gs.ServiceComment = row["ServiceComment"].ToString(); gs.ServiceRate = int.Parse(row["ServiceRate"].ToString()); gs.StaffId = row["StaffId"].ToString(); gs.Status = row["Status"].ToString(); string status2 = ""; if (row["Status2"] != null) { status2 = row["Status2"].ToString(); } gs.Status2 = status2; gs.SurveyId = int.Parse(row["SurveyId"].ToString()); gs.TableNo = row["TableNo"].ToString(); gs.ValueComment = row["ValueComment"].ToString(); gs.ValueRate = int.Parse(row["ValueRate"].ToString()); float tmpAverage = 0; float.TryParse(row["Average"].ToString(), out tmpAverage); gs.Average = tmpAverage; gs.Complaint = int.Parse(row["Complaint"].ToString()); gs.Feedback = int.Parse(row["Feedback"].ToString()); gs.Compliment = int.Parse(row["Compliment"].ToString()); gs.Country = row["Country"].ToString(); gsList.Add(gs); } return(View(gsList)); }