public ActionResult DeleteConfirmed(int id)
{
gps gps = db.gps.Find(id);
db.gps.Remove(gps);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Edit([Bind(Include = "id,latitud,longitud,imei,animal_id")] gps gps)
{
if (ModelState.IsValid)
{
db.Entry(gps).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.animal_id = new SelectList(db.animal, "id", "codigo_sag", gps.animal_id);
return(View(gps));
}
// GET: Gps/Delete/5
public ActionResult Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
gps gps = db.gps.Find(id);
if (gps == null)
{
return(HttpNotFound());
}
return(View(gps));
}
// GET: Gps/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
gps gps = db.gps.Find(id);
if (gps == null)
{
return(HttpNotFound());
}
ViewBag.animal_id = new SelectList(db.animal.Where(a => a.gps.Count == 0 && a.estado.nombre != "MUERTO" && a.estado.nombre != "VENDIDO"), "id", "codigo_sag", gps.animal_id);
return(View(gps));
}
public ActionResult actualizarUbicacion(int?id, double lat, double lng)
{
if (id != null && lat != null && lng != null)
{
Double latitud = lat;
Double longitud = lng;
gps gpsmod = db.gps.Find(id);
if (gpsmod != null)
{
gpsmod.latitud = Math.Round(latitud, 5);
gpsmod.longitud = Math.Round(longitud, 6);
db.SaveChanges();
}
}
return(null);
}
void Start()
{
gpsObj = GameObject.Find("gps").GetComponent <gps>();
forestObj = GameObject.Find("gps").GetComponent <forest>();
LoadGame();
}
private void NewGspPosition(gps.parser.GpsPosition pos)
{
outFile.WriteLine(pos.x.ToString().Replace(',', '.'));
outFile.WriteLine(pos.y.ToString().Replace(',', '.'));
}
// Use this for initialization
private void Start()
{
Instance = this;
DontDestroyOnLoad(gameObject);
StartCoroutine(StartLocationService());
}
public void loadgps(string block)
{
try
{
//added by naveeen
string token = System.Web.HttpContext.Current.Request.Headers["token"];
string employecode = System.Web.HttpContext.Current.Request.Headers["empcode"];
string huuid = System.Web.HttpContext.Current.Request.Headers["uuid"];
//end
cmd = new SqlCommand("SELECT RowCode, UserID, EmployeeCode, Domain, SessionToken, SessionExpiryTime, LoginTime, LogoutTime, DeviceID, IsActive FROM tbl_TRN_LogInDetail WHERE (EmployeeCode = @empcode) AND (SessionToken = @token) AND (DeviceID=@uuid) AND (IsActive=@IsActive)");
cmd.Parameters.Add("@empcode", employecode);
cmd.Parameters.Add("@token", token);
cmd.Parameters.Add("@uuid", huuid);
cmd.Parameters.Add("@IsActive", true);
DataTable dttoken = vdm.SelectQuery(cmd).Tables[0];
if (dttoken.Rows.Count > 0)
{
foreach (DataRow drt in dttoken.Rows)
{
string sessionexpdate = drt["SessionExpiryTime"].ToString();
DateTime dtsessionexpdate = Convert.ToDateTime(sessionexpdate);
DateTime nowdatetime = DateTime.Now;
if (nowdatetime > dtsessionexpdate)
{
Context.Response.Clear();
Context.Response.StatusCode = 401;
HttpContext.Current.ApplicationInstance.CompleteRequest();
}
else
{
DateTime extendsessionexpdate = nowdatetime.AddHours(1);
cmd = new SqlCommand("UPDATE tbl_TRN_LogInDetail SET SessionExpiryTime=@extenddate WHERE (EmployeeCode = @emplcode) AND (SessionToken = @stoken) AND (DeviceID=@duuid) AND (IsActive=@active)");
cmd.Parameters.Add("@emplcode", employecode);
cmd.Parameters.Add("@stoken", token);
cmd.Parameters.Add("@duuid", huuid);
cmd.Parameters.Add("@active", true);
cmd.Parameters.Add("@extenddate", extendsessionexpdate);
vdm.Update(cmd);
postcmd = new NpgsqlCommand("SELECT panchayat_code, panchayat_name, block_code FROM panchayat_master WHERE block_code='" + block + "'");
DataTable dtblocks = postvdm.SelectQuery(postcmd).Tables[0];
List <gps> gplist = new List <gps>();
foreach (DataRow dr in dtblocks.Rows)
{
gps gpli = new gps();
gpli.gpcode = dr["panchayat_code"].ToString();
gpli.gpname = dr["panchayat_name"].ToString();
gpli.blockcode = dr["block_code"].ToString();
gplist.Add(gpli);
}
JavaScriptSerializer jsonSerializer = new JavaScriptSerializer();
jsonSerializer.MaxJsonLength = Int32.MaxValue;
string response = jsonSerializer.Serialize(gplist);
Context.Response.Clear();
Context.Response.ContentType = "application/json";
Context.Response.AddHeader("content-length", response.Length.ToString());
Context.Response.Flush();
Context.Response.Write(response);
HttpContext.Current.ApplicationInstance.CompleteRequest();
}
}
}
else
{
Context.Response.Clear();
Context.Response.StatusCode = 401;
HttpContext.Current.ApplicationInstance.CompleteRequest();
}
}
catch (Exception ex)
{
Context.Response.Clear();
Context.Response.StatusCode = 401;
HttpContext.Current.ApplicationInstance.CompleteRequest();
}
}
