public ActionResult countLocation() { Db_Connection dbconn = new Db_Connection(); Utility util = new Utility(); try { dbconn.openConnection(); string strSQL = ""; strSQL = @"SELECT LOCATION,CNT FROM vrfid_locationcheckout"; SqlCommand cmd = new SqlCommand(strSQL, dbconn.DbConn); SqlDataReader dr = cmd.ExecuteReader(); List <mdlTrack> record = new List <mdlTrack>(); if (dr.HasRows) { while (dr.Read()) { mdlTrack list = new mdlTrack(); list.LOCATION = dr["LOCATION"].ToString(); list.COUNT = dr["CNT"].ToString(); record.Add(list); } } dr.Dispose(); cmd.Dispose(); dbconn.closeConnection(); return(View(record)); } finally { dbconn.closeConnection(); } }
public ActionResult location_list(string from, string to, string location) { Db_Connection dbconn = new Db_Connection(); Utility util = new Utility(); try { dbconn.openConnection(); string strSQL = ""; string strWHERE = ""; strSQL = @"SELECT TAGS,READTIME,LOCATION,FIREARMTYPE,DEFPIC FROM VRFID_LOGS WHERE READTIME>=@FROM AND READTIME<=DATEADD(day, 1,@TO) AND LOCATIONID=@LOCATION"; SqlCommand cmd = new SqlCommand(strSQL, dbconn.DbConn); cmd.Parameters.Add("FROM", SqlDbType.VarChar).Value = from; cmd.Parameters.Add("TO", SqlDbType.VarChar).Value = to; cmd.Parameters.Add("LOCATION", SqlDbType.VarChar).Value = location; SqlDataReader dr = cmd.ExecuteReader(); List <mdlTrack> record = new List <mdlTrack>(); if (dr.HasRows) { while (dr.Read()) { mdlTrack list = new mdlTrack(); list.TAGS = dr["TAGS"].ToString(); list.READTIME = util.formatLongDateTime(Convert.ToDateTime(dr["READTIME"].ToString())); list.LOCATION = dr["LOCATION"].ToString(); list.LOCATIONID = location; list.FIREARMTYPE = dr["FIREARMTYPE"].ToString(); list.DEFPIC = "/Content/firearms/NoImage.png"; if (!string.IsNullOrEmpty(dr["DEFPIC"].ToString())) { list.DEFPIC = "/" + dr["DEFPIC"].ToString(); } record.Add(list); } } dr.Dispose(); cmd.Dispose(); dbconn.closeConnection(); return(PartialView(record)); } finally { dbconn.closeConnection(); } }
public ActionResult accessdoor_list(string door) { Db_Connection dbconn = new Db_Connection(); Utility util = new Utility(); try { dbconn.openConnection(); string strSQL = ""; strSQL = @"SELECT ID,F_ID,FIREARMTYPE,ACCESS,LOCATION,DOOR,DEFPIC FROM VWEAPON_DOOR_ACCESS WHERE DOORID=@DOOR"; SqlCommand cmd = new SqlCommand(strSQL, dbconn.DbConn); cmd.Parameters.Add("DOOR", SqlDbType.VarChar).Value = door; SqlDataReader dr = cmd.ExecuteReader(); List <mdlTrack> record = new List <mdlTrack>(); if (dr.HasRows) { while (dr.Read()) { mdlTrack list = new mdlTrack(); list.FIREARMTYPE = dr["FIREARMTYPE"].ToString(); list.F_ID = dr["F_ID"].ToString(); list.ACCESS = dr["ACCESS"].ToString(); list.ID = dr["ID"].ToString(); list.LOCATION = dr["LOCATION"].ToString(); list.DOOR = dr["DOOR"].ToString(); list.DEFPIC = dr["DEFPIC"].ToString(); list.DEFPIC = "/Content/firearms/NoImage.png"; if (!string.IsNullOrEmpty(dr["DEFPIC"].ToString())) { list.DEFPIC = "/" + dr["DEFPIC"].ToString(); } record.Add(list); } } dr.Dispose(); cmd.Dispose(); dbconn.closeConnection(); return(PartialView(record)); } finally { dbconn.closeConnection(); } }
public ActionResult AccessDoorEdit(string id) { Populate DropDown = new Populate(); Db_Connection dbconn = new Db_Connection(); List <SelectListItem> allowdeny_combo = new List <SelectListItem>(); allowdeny_combo = DropDown.getAllowDeny(); try { dbconn.openConnection(); string strSQL = @"SELECT LOCATION,DOOR,ACCESS FROM VWEAPON_DOOR_ACCESS WHERE ID=@ID"; SqlCommand cmd = new SqlCommand(strSQL, dbconn.DbConn); cmd.Parameters.Add("ID", SqlDbType.VarChar).Value = id; SqlDataReader dr = cmd.ExecuteReader(); mdlTrack record = new mdlTrack(); record.ID = id; if (dr.HasRows) { dr.Read(); record.ID = id; record.LOCATION = dr["LOCATION"].ToString(); record.DOOR = dr["DOOR"].ToString(); record.ACCESS = dr["ACCESS"].ToString(); } foreach (SelectListItem item in allowdeny_combo) { if (item.Text.ToUpper() == record.ACCESS.ToUpper()) { item.Selected = true; } } ViewData["access"] = allowdeny_combo; return(PartialView(record)); } finally { dbconn.closeConnection(); } }
public ActionResult location_modal(string id) { try { Db_Connection dbconn = new Db_Connection(); dbconn.openConnection(); string strSQL = ""; strSQL = @"SELECT X,Y,LOCATION,IMAGE,MAPTITLE,DESCRIPTION FROM VMAP_LOCATION WHERE LOCATIONID=@ID"; SqlCommand cmd = new SqlCommand(strSQL, dbconn.DbConn); cmd.Parameters.Add("ID", SqlDbType.VarChar).Value = id; SqlDataReader dr = cmd.ExecuteReader(); mdlTrack location = new mdlTrack(); if (dr.HasRows) { dr.Read(); location.X = dr["X"].ToString(); location.Y = dr["Y"].ToString(); location.LOCATION = dr["LOCATION"].ToString(); location.MAPIMAGE = dr["IMAGE"].ToString(); location.MAPTITLE = dr["MAPTITLE"].ToString(); location.DESCRIPTION = dr["DESCRIPTION"].ToString(); } dr.Dispose(); cmd.Dispose(); mdlMapModel maprecord = new mdlMapModel(); maprecord.mapheight = "2000"; maprecord.mapwidth = "2000"; List <mdlMapCategories> categories_list = new List <mdlMapCategories>(); mdlMapCategories categories = new mdlMapCategories(); List <mdlMapLocations> locations_list = new List <mdlMapLocations>(); mdlMapLocations locations = new mdlMapLocations(); locations.id = id; locations.title = location.LOCATION; locations.pin = "pin-pulse"; locations.category = "location"; locations.description = location.DESCRIPTION; locations.x = location.X; locations.y = location.Y; locations.zoom = "1"; locations_list.Add(locations); categories.id = "location"; categories.title = location.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 = "/" + location.MAPIMAGE; level.locations = locations_list; level_list.Add(level); maprecord.levels = level_list; maprecord.categories = categories_list; ViewData["maprecord"] = JsonConvert.SerializeObject(maprecord); ViewData["maptitle"] = location.MAPTITLE; dbconn.closeConnection(); return(PartialView()); } finally { } }