public ActionResult Index() { Db_Connection dbconn = new Db_Connection(); Utility util = new Utility(); try { dbconn.openConnection(); string strSQL = ""; strSQL = @"SELECT ID,GID,MAP,IMAGE,DESCRIPTION FROM MAP ORDER BY MAP ASC"; SqlCommand cmd = new SqlCommand(strSQL, dbconn.DbConn); SqlDataReader dr = cmd.ExecuteReader(); List <mdlMap> record = new List <mdlMap>(); if (dr.HasRows) { while (dr.Read()) { mdlMap list = new mdlMap(); list.ID = dr["ID"].ToString(); list.GID = dr["GID"].ToString(); list.MAP = dr["MAP"].ToString(); list.DESCRIPTION = dr["DESCRIPTION"].ToString(); list.IMAGE = "/" + dr["IMAGE"].ToString(); record.Add(list); } } dr.Dispose(); cmd.Dispose(); dbconn.closeConnection(); return(View(record)); } finally { dbconn.closeConnection(); } }
public ActionResult edit(string id, string gid) { Populate DropDown = new Populate(); Db_Connection dbconn = new Db_Connection(); try { dbconn.openConnection(); string strSQL = @"SELECT MAP,DESCRIPTION FROM MAP WHERE ID=@ID AND GID=@GID"; SqlCommand cmd = new SqlCommand(strSQL, dbconn.DbConn); cmd.Parameters.Add("ID", SqlDbType.VarChar).Value = id; cmd.Parameters.Add("GID", SqlDbType.VarChar).Value = gid; SqlDataReader dr = cmd.ExecuteReader(); mdlMap record = new mdlMap(); record.ID = id; record.GID = gid; if (dr.HasRows) { dr.Read(); record.ID = id; record.GID = gid; record.MAP = dr["MAP"].ToString(); record.DESCRIPTION = dr["DESCRIPTION"].ToString(); } return(PartialView(record)); } finally { dbconn.closeConnection(); } }
public ActionResult definelocation() { string maptitle = ""; string mapimage = ""; Populate DropDown = new Populate(); string map = ""; if (!string.IsNullOrEmpty(Request.QueryString["map"])) { map = Request.QueryString["map"].ToString(); } Db_Connection dbconn = new Db_Connection(); Utility util = new Utility(); try { dbconn.openConnection(); string strSQL = ""; strSQL = @"SELECT ID,MAP,LOCATIONS FROM VMAP ORDER BY MAP ASC"; SqlCommand cmd = new SqlCommand(strSQL, dbconn.DbConn); SqlDataReader dr = cmd.ExecuteReader(); List <mdlMap> record = new List <mdlMap>(); if (dr.HasRows) { while (dr.Read()) { mdlMap list = new mdlMap(); list.ID = dr["ID"].ToString(); list.MAP = dr["MAP"].ToString(); list.LOCATIONS = dr["LOCATIONS"].ToString(); record.Add(list); if (map == "") { map = list.ID; } } } dr.Dispose(); cmd.Dispose(); strSQL = @"SELECT MAP,IMAGE FROM MAP WHERE ID=@ID"; cmd = new SqlCommand(strSQL, dbconn.DbConn); cmd.Parameters.Add("ID", SqlDbType.VarChar).Value = map; dr = cmd.ExecuteReader(); if (dr.HasRows) { dr.Read(); maptitle = dr["MAP"].ToString(); mapimage = dr["IMAGE"].ToString(); } dr.Dispose(); cmd.Dispose(); mdlMapModel maprecord = new mdlMapModel(); maprecord.mapheight = "2000"; maprecord.mapwidth = "2000"; strSQL = @"SELECT MAPTITLE,LOCATIONID,ID,MAP,LOCATION,X,Y FROM VMAP_LOCATION WHERE MAP=@MAP ORDER BY LOCATION ASC"; cmd = new SqlCommand(strSQL, dbconn.DbConn); cmd.Parameters.Add("MAP", SqlDbType.VarChar).Value = map; dr = cmd.ExecuteReader(); List <mdlMapCategories> categories_list = new List <mdlMapCategories>(); mdlMapCategories categories = new mdlMapCategories(); List <mdlMapLocations> locations_list = new List <mdlMapLocations>(); while (dr.Read()) { mdlMapLocations locations = new mdlMapLocations(); locations.id = dr["LOCATIONID"].ToString(); locations.title = dr["LOCATION"].ToString(); locations.category = "location"; locations.x = dr["X"].ToString(); locations.y = dr["Y"].ToString(); locations_list.Add(locations); } categories.id = "location"; categories.title = maptitle; categories.color = "#4cd3b8"; categories.show = "true"; categories_list.Add(categories); List <mdlMapLevels> level_list = new List <mdlMapLevels>(); mdlMapLevels level = new mdlMapLevels(); level.id = "lower"; level.title = "Lower floor"; level.map = "/" + mapimage; level.locations = locations_list; level_list.Add(level); maprecord.levels = level_list; maprecord.categories = categories_list; ViewData["maprecord"] = JsonConvert.SerializeObject(maprecord); List <SelectListItem> location_combo = new List <SelectListItem>(); dr.Dispose(); cmd.Dispose(); strSQL = "SELECT LOCATIONID,LOCATION FROM VMAP_LOCATION WHERE MAP=@MAP ORDER BY LOCATION ASC"; cmd = new SqlCommand(strSQL, dbconn.DbConn); cmd.Parameters.Add("MAP", SqlDbType.VarChar).Value = map; dr = cmd.ExecuteReader(); location_combo.Add(new SelectListItem { Text = "", Value = "" }); while (dr.Read()) { location_combo.Add(new SelectListItem { Text = dr[1].ToString(), Value = dr[0].ToString() }); } ViewData["location"] = location_combo; ViewData["mapid"] = map; dr.Dispose(); cmd.Dispose(); dbconn.closeConnection(); return(View(record)); } finally { dbconn.closeConnection(); } }