public static TourLead GetTourLeaderById(int id) { TourLead tourlead = null; using (SqlConnection conn = new SqlConnection(Data.connectionString)) { conn.Open(); string sql = @"SELECT * from TourLeaderDTOes WHERE Id = '" + id + "'"; SqlCommand cmd = new SqlCommand(sql, conn); SqlDataReader reader = cmd.ExecuteReader(); if (reader.Read()) { tourlead = new TourLead() { Id = (int)reader["Id"], Name = (string)reader["Name"], Rank = (string)reader["Rank"] }; } conn.Close(); } return(tourlead); }
public ActionResult Calculate(int Id, int Day) { TourLead lead = TourLeaderData.GetTourLeaderById(Id); string name = lead.Name; string Rank = lead.Rank; int DailyRate = 0; int cost = 0; //if (Id == null) //{ // return View(); //} //else //{ if (Rank == "M1") { DailyRate = 500; } else if (Rank == "M2") { DailyRate = 400; } else if (Rank == "M3") { DailyRate = 300; } //} cost = DailyRate * Day; ViewData["cost"] = cost; ViewData["Id"] = Id; ViewData["Name"] = name; ViewData["Rank"] = Rank; return(View()); }