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
{
}
}
