internal string ReportAccident(string AccLoc) { string Response = "Failed"; using (SqlConnection con = new SqlConnection(SqlConnect.GetConnectionString())) { try { con.Open(); SqlCommand cmd = new SqlCommand("INSERT Into Accident (Location,DriverName,DriverId,VehicleId,VehicleNO) Values (@Location,'Varun',1,1,'KL-0167')", con); cmd.Parameters.AddWithValue("@Location", AccLoc); cmd.ExecuteNonQuery(); Response = "Accident reported successfully"; } catch (Exception ex) { Response = ex.Message; } finally { con.Close(); } } return(Response); }
internal string ReportAccident(string Longitude, string Latitude) { string Response = "Failed"; string AccLoc = "Thiruvanathapuram";//Default set to Trivandrum,We are not considering location here ,we use latitude and longtitude //So we basically not want to leave the location as blank using (SqlConnection con = new SqlConnection(SqlConnect.GetConnectionString())) { try { con.Open(); SqlCommand cmd = new SqlCommand("INSERT Into Accident (Location,Latitude,Longitude,DriverName,DriverId,VehicleId,VehicleNO) Values (@Location,@Latitude,@Longitude,'Varun',1,1,'KL-0167')", con); cmd.Parameters.AddWithValue("@Latitude", Latitude); cmd.Parameters.AddWithValue("@Longitude", Longitude); cmd.Parameters.AddWithValue("@Location", AccLoc); cmd.ExecuteNonQuery(); Response = "Accident reported successfully"; } catch (Exception ex) { Response = ex.Message; } finally { con.Close(); } } return(Response); }
public Location Get() { string localLoc = "NIL"; int AccidentId = 0; string GetLongitude = "NIL"; string GetLatitude = "NIL"; using (SqlConnection con = new SqlConnection(SqlConnect.GetConnectionString())) { try { con.Open(); //currently we are taking top 1 but later we will take particular driver location accidents only SqlCommand cmd = new SqlCommand("select TOP 1 Location,Accident,Longitude,Latitude from Accident WHERE IsExpired=0 order by 1 desc", con); SqlDataReader rdr = cmd.ExecuteReader(); if (rdr.HasRows) { while (rdr.Read()) { localLoc = rdr["Location"].ToString(); AccidentId = Convert.ToInt32(rdr["Accident"]); GetLongitude = rdr["Longitude"].ToString(); GetLatitude = rdr["Latitude"].ToString(); } } rdr.Close(); rdr.Dispose(); DeleteAfterPLot(AccidentId, con); } catch (Exception) { throw; } finally { con.Close(); } } Location objLocation = new Location { Latitude = GetLatitude, Longitude = GetLongitude, Address = localLoc }; return(objLocation); }
public string Get() { string Location = "NIL"; int AccidentId = 0; using (SqlConnection con = new SqlConnection(SqlConnect.GetConnectionString())) { try { con.Open(); //currently we are taking top 1 but later we will take particular driver location accidents only SqlCommand cmd = new SqlCommand("select TOP 1 Location,Accident from Accident order by 1 desc", con); SqlDataReader rdr = cmd.ExecuteReader(); if (rdr.HasRows) { while (rdr.Read()) { Location = rdr["Location"].ToString(); AccidentId = Convert.ToInt32(rdr["Accident"]); } } rdr.Close(); rdr.Dispose(); //Delete once we plot the location var cmdDelete = new SqlCommand("Delete from Accident Where Accident=@Accident ", con); cmdDelete.Parameters.AddWithValue("@Accident", AccidentId); cmdDelete.ExecuteNonQuery(); } catch (Exception) { throw; } finally { con.Close(); } } return(Location); }
public bool UserAuthenticate(string Username, string Password) { using (SqlConnection con = new SqlConnection(SqlConnect.GetConnectionString())) { try { con.Open(); SqlCommand cmd = new SqlCommand("Select * from AddDriver Where DriverName=@Username and Password=@Password", con); cmd.Parameters.AddWithValue("@Username", Username); cmd.Parameters.AddWithValue("@Password", Password); SqlDataReader rdr = cmd.ExecuteReader(); return(rdr.HasRows); } catch (Exception) { throw; } finally { con.Close(); } } }