public void GetJourneyDetails(RootObjectJourneydetail Journey)
{
ObjCommon.JourneyListDetails = JsonConvert.SerializeObject(Journey);
StrCommonObject = JsonConvert.SerializeObject(ObjCommon);
var context = new DataAccessLayer.AgeasDriverDetails(ClsDBHelper.ClsDBHelper.DBConnectionString);
ObjCommon.ClearLocationRecord();
ObjCommon.JourneySave();
List<JourneyDetails> Journelist = (from a in context.tblJourneyDetails select a).ToList();
List<Journeydetail> databaseJlist = new List<Journeydetail>();
Journeydetail _Journey;
for (int i = 0; i < Journelist.Count; i++)
{
_Journey = new Journeydetail();
_Journey.journey_id = Journelist[i].JourneyId.ToString();
_Journey.distance = Convert.ToDouble(Journelist[i].Last_distance);
_Journey.time = Journelist[i].TimeDuration.ToString();
_Journey.date = Journelist[i].JDate.ToString();
databaseJlist.Add(_Journey);
_Journey = null;
}
Deployment.Current.Dispatcher.BeginInvoke(() =>
{
lstjourneyList.ItemsSource = null;
lstjourneyList.ItemsSource = databaseJlist;
});
if (jlist != null)
{
string number = jlist.journey_id;
ClsJourney objJourney = new ClsJourney();
objJourney.GetJourneyDetails(ObjCommon.DeviceId, jlist.journey_id, this);
}
}
public Boolean DeleteLocation(IQueryable<LocationTable> QryDelLocation, AgeasDriverDetails context)
{
Boolean result = false;
try
{
context.tblLocation.DeleteAllOnSubmit(QryDelLocation);
context.SubmitChanges();
//context.Dispose();
result = true;
}
catch (Exception ex)
{
result = false;
}
return result;
}
public List<JourneyDetails> GetJourneyList(IQueryable<JourneyDetails> JourneyQuery)
{
List<JourneyDetails> Journeylist = null;
try
{
using (var context = new AgeasDriverDetails(DBConnectionString))
{
if (context.DatabaseExists())
{
Journeylist = JourneyQuery.ToList();
}
context.Dispose();
}
}
catch
{
Journeylist = null;
}
return Journeylist;
}
public Boolean CreateDatabase()
{
Boolean result = false;
try
{
using (var context = new AgeasDriverDetails(DBConnectionString))
{
if (!context.DatabaseExists())
{
context.CreateDatabase();
result = true;
}
context.Dispose();
}
}
catch
{
result = false;
}
return result;
}
private void CreteXmlBodyForLocPost(String StrDeviceId)
{
ClsDBHelper.ClsDBHelper objDBHelper = new ClsDBHelper.ClsDBHelper();
var context = new DataAccessLayer.AgeasDriverDetails(ClsDBHelper.ClsDBHelper.DBConnectionString);
var distinctTypeIDs = (from a in context.tblLocation select a.Journeyid).Distinct().ToList();
try
{
envelope = "<?xml version=\"1.0\" encoding=\"utf-8\"?> " +
" <journeydetails> " +
"<deviceid>" + StrDeviceId.ToString() + "</deviceid>\n";
for (int j = 0; j < distinctTypeIDs.Count; j++)
{
List<LocationTable> JourneyLocationlist = (from a in context.tblLocation where a.Journeyid == distinctTypeIDs[j] select a).ToList();
if (JourneyLocationlist.Count > 0)
{
envelope += "<journey id=\"" + distinctTypeIDs[j].ToString() + "\">";
for (int i = 0; i < JourneyLocationlist.Count; i++)
{
envelope += "<latlong> <latitude>" + JourneyLocationlist[i].Lat + "</latitude> <longitude>" + JourneyLocationlist[i].Long + "</longitude> <datetime>" + JourneyLocationlist[i].DateTime+ "</datetime> </latlong>";
}
envelope += " </journey>";
}
}
envelope += " </journeydetails>";
}
catch
{ }
}
public void JourneySave()
{
RootObjectJourneydetail ObjRootJouneyDtls = JsonConvert.DeserializeObject<RootObjectJourneydetail>(this.JourneyListDetails);
if (ObjRootJouneyDtls.complete)
{
ClsDBHelper.ClsDBHelper objDBHelper;
decimal Totaldistance = 0;
var context = new DataAccessLayer.AgeasDriverDetails(ClsDBHelper.ClsDBHelper.DBConnectionString);
objDBHelper = new ClsDBHelper.ClsDBHelper();
IQueryable<DataAccessLayer.JourneyDetails> DeleteJourney = from c in context.tblJourneyDetails select c;
objDBHelper.DeleteJourneyDetails(DeleteJourney, context);
DataAccessLayer.JourneyDetails ObjJourney;
for (int i = 0; i < ObjRootJouneyDtls.user_journey.journeydetails.Count; i++)
{
ObjJourney = new DataAccessLayer.JourneyDetails();
Totaldistance = Totaldistance + Convert.ToDecimal(ObjRootJouneyDtls.user_journey.journeydetails[i].distance);
ObjJourney.Total_distance = Convert.ToDecimal(Totaldistance);
ObjJourney.JourneyId = Convert.ToInt16(ObjRootJouneyDtls.user_journey.journeydetails[i].journey_id);
ObjJourney.Last_distance = Convert.ToDecimal(ObjRootJouneyDtls.user_journey.journeydetails[i].distance);
ObjJourney.TimeDuration = ObjRootJouneyDtls.user_journey.journeydetails[i].time;
ObjJourney.JDate = ObjRootJouneyDtls.user_journey.journeydetails[i].date.ToString();
objDBHelper.InsertJourney(ObjJourney);
ObjJourney = null;
}
}
}
public bool IsRecordHaveForUpload()
{
ClsDBHelper.ClsDBHelper objDBHelper = new ClsDBHelper.ClsDBHelper();
var context = new DataAccessLayer.AgeasDriverDetails(ClsDBHelper.ClsDBHelper.DBConnectionString);
List<LocationTable> JourneyLocationlist = (from a in context.tblLocation select a).ToList();
context = null;
objDBHelper = null;
if (JourneyLocationlist.Count > 0)
{
JourneyLocationlist = null;
return true;
}
else
{
JourneyLocationlist = null;
return false;
}
}
public Double GetFirstLastLatLong(int lastJourneyID)
{
double StartLatitude;
double StartLongitude;
double EndLatitude;
double EndLongitude;
double ActualDistance;
Double Totaldistance=0.0;
var context = new DataAccessLayer.AgeasDriverDetails(ClsDBHelper.ClsDBHelper.DBConnectionString);
List<LocationTable> JourneyLocationlist = (from a in context.tblLocation orderby a.LocationID ascending where a.Journeyid == lastJourneyID select a).ToList();
if (JourneyLocationlist.Count > 1)
{
for (int i = 0; i < JourneyLocationlist.Count - 1; i++)
{
StartLatitude = Convert.ToDouble(JourneyLocationlist[i].Lat.ToString());
StartLongitude = Convert.ToDouble(JourneyLocationlist[i].Long.ToString());
EndLatitude = Convert.ToDouble(JourneyLocationlist[i+1].Lat.ToString());
EndLongitude = Convert.ToDouble(JourneyLocationlist[i+1].Long.ToString());
ActualDistance = Getdistance(StartLatitude, StartLongitude, EndLatitude, EndLongitude);
Totaldistance = Totaldistance + ActualDistance;
}
}
Totaldistance = Totaldistance / 1609.34;
return Totaldistance;
}
public void DeleteLocationRecord()
{
ClsDBHelper.ClsDBHelper objDBHelper = new ClsDBHelper.ClsDBHelper();
var context = new DataAccessLayer.AgeasDriverDetails(ClsDBHelper.ClsDBHelper.DBConnectionString);
Double Totaldistance;
var distinctTypeIDs = (from a in context.tblLocation select a.Journeyid).Distinct().ToList();
for (int j = 0; j < distinctTypeIDs.Count; j++)
{
Totaldistance = GetFirstLastLatLong(distinctTypeIDs[j]);
if (Totaldistance <= 0.5)
{
IQueryable<DataAccessLayer.LocationTable> DeleteLocation = from c in context.tblLocation where c.Journeyid == distinctTypeIDs[j] select c;
objDBHelper.DeleteLocation(DeleteLocation, context);
}
}
context = null;
objDBHelper = null;
}
public void ClearLocationRecord()
{
var context = new DataAccessLayer.AgeasDriverDetails(ClsDBHelper.ClsDBHelper.DBConnectionString);
ClsDBHelper.ClsDBHelper objDBHelper = new ClsDBHelper.ClsDBHelper();
IQueryable<DataAccessLayer.LocationTable> DeleteLocation = from c in context.tblLocation select c;
objDBHelper.DeleteLocation(DeleteLocation, context);
context = null;
objDBHelper = null;
}
public Double GetFirstLastLatLong(int lastJourneyID)
{
double StartLatitude;
double StartLongitude;
double EndLatitude;
double EndLongitude;
Double Totaldistance;
var context = new DataAccessLayer.AgeasDriverDetails(ClsDBHelper.ClsDBHelper.DBConnectionString);
List<LocationTable> JourneyLocationlist = (from a in context.tblLocation orderby a.LocationID ascending where a.Journeyid == lastJourneyID select a).ToList();
if (JourneyLocationlist.Count > 0)
{
StartLatitude = Convert.ToDouble(JourneyLocationlist[0].Lat.ToString());
StartLongitude = Convert.ToDouble(JourneyLocationlist[0].Long.ToString());
}
else
{
StartLatitude = Convert.ToDouble("0.00");
StartLongitude = Convert.ToDouble("0.00");
}
JourneyLocationlist = null;
JourneyLocationlist = (from a in context.tblLocation orderby a.LocationID descending where a.Journeyid == lastJourneyID select a).ToList();
if (JourneyLocationlist.Count > 0)
{
EndLatitude = Convert.ToDouble(JourneyLocationlist[0].Lat.ToString());
EndLongitude = Convert.ToDouble(JourneyLocationlist[0].Long.ToString());
}
else
{
EndLatitude = Convert.ToDouble("0.00");
EndLongitude = Convert.ToDouble("0.00");
}
Totaldistance = Getdistance(StartLatitude, StartLongitude, EndLatitude, EndLongitude) / 1609.34;
return Totaldistance;
}
protected override void OnNavigatedTo(System.Windows.Navigation.NavigationEventArgs e)
{
try
{
StrCommonObject = NavigationContext.QueryString["common"];
ObjCommon = JsonConvert.DeserializeObject<ClsCommon>(StrCommonObject);
base.OnNavigatedTo(e);
ImgHeader.Source = new System.Windows.Media.Imaging.BitmapImage(ClsCommon.GetScaledImageUri("/Images/Progress/upperStrip"));
ImgProgressSelect.Source = new System.Windows.Media.Imaging.BitmapImage(ClsCommon.GetScaledImageUri("/Images/General/progressSelected"));
ImgRecordDeselect.Source = new System.Windows.Media.Imaging.BitmapImage(ClsCommon.GetScaledImageUri("/Images/General/record"));
ImgHelpDeselect.Source = new System.Windows.Media.Imaging.BitmapImage(ClsCommon.GetScaledImageUri("/Images/General/help"));
ImgQuoteDeselect.Source = new System.Windows.Media.Imaging.BitmapImage(ClsCommon.GetScaledImageUri("/Images/General/quote"));
ImgProgress.Source = new System.Windows.Media.Imaging.BitmapImage(ClsCommon.GetScaledImageUri("/Images/Progress/mainBg_progress1"));
ImgProgressButtom.Source = new System.Windows.Media.Imaging.BitmapImage(ClsCommon.GetScaledImageUri("/Images/Progress/mainBg_progress2"));
txtprogressvalue.Text = "0.5";
//ObjCommon.TotalJourney = 152;
if (ObjCommon != null)
{
ObjRootJouneyDtls = JsonConvert.DeserializeObject<RootObjectJourneydetail>(ObjCommon.JourneyListDetails);
if (ObjCommon.TotalJourney < 51)
{
ImageBrush _ImageBrush = new ImageBrush();
_ImageBrush.ImageSource = new System.Windows.Media.Imaging.BitmapImage(ClsCommon.GetScaledImageUri("/Images/Progress/displayUnselected"));
stackprogress.Background = _ImageBrush;
_ImageBrush = null;
}
else if (ObjCommon.TotalJourney < 100)
{
ImageBrush _ImageBrush = new ImageBrush();
_ImageBrush.ImageSource = new System.Windows.Media.Imaging.BitmapImage(ClsCommon.GetScaledImageUri("/Images/Progress/display(50)"));
stackprogress.Background = _ImageBrush;
_ImageBrush = null;
}
else if (ObjCommon.TotalJourney < 150)
{
ImageBrush _ImageBrush = new ImageBrush();
_ImageBrush.ImageSource = new System.Windows.Media.Imaging.BitmapImage(ClsCommon.GetScaledImageUri("/Images/Progress/display(100)"));
stackprogress.Background = _ImageBrush;
_ImageBrush = null;
}
//else if (ObjCommon.TotalJourney >= 150)
//{
// ImageBrush _ImageBrush = new ImageBrush();
// _ImageBrush.ImageSource = new System.Windows.Media.Imaging.BitmapImage(ClsCommon.GetScaledImageUri("/Images/Progress/display(150)"));
// stackprogress.Background = _ImageBrush;
// _ImageBrush = null;
// StrCommonObject = JsonConvert.SerializeObject(ObjCommon);
// NavigationService.Navigate(new Uri("/Pages/FrmScore.xaml?common=" + StrCommonObject, UriKind.Relative));
//}
else
{
ImageBrush _ImageBrush = new ImageBrush();
_ImageBrush.ImageSource = new System.Windows.Media.Imaging.BitmapImage(ClsCommon.GetScaledImageUri("/Images/Progress/displayUnselected"));
stackprogress.Background = _ImageBrush;
_ImageBrush = null;
}
}
TxtBudget.Text = "LATEST BUDGET EARNED!";
TxtBudgetDetails.Text = "Well done,you handle those \n comer safely";
TxtShare.Text = "Share with:";
TxtJourneyCmplt.Text = "JOURNEYS COMPLETED";
Imgfacebk.Source = new System.Windows.Media.Imaging.BitmapImage(ClsCommon.GetScaledImageUri("/Images/Progress/facebookIcon"));
Imgtwitter.Source = new System.Windows.Media.Imaging.BitmapImage(ClsCommon.GetScaledImageUri("/Images/Progress/twitterIcon"));
ImgTblHeader.Source = new System.Windows.Media.Imaging.BitmapImage(ClsCommon.GetScaledImageUri("/Images/Progress/tableHeader"));
objDBHelper = new ClsDBHelper.ClsDBHelper();
var context = new DataAccessLayer.AgeasDriverDetails(ClsDBHelper.ClsDBHelper.DBConnectionString);
List<JourneyDetails> Journelist = (from a in context.tblJourneyDetails select a).ToList();
List<Journeydetail> databaseJlist = new List<Journeydetail>();
Journeydetail _Journey;
for (int i = 0; i < Journelist.Count; i++)
{
_Journey = new Journeydetail();
_Journey.journey_id = Journelist[i].JourneyId.ToString();
_Journey.distance = Convert.ToDouble(Journelist[i].Last_distance.ToString("0.00"));
_Journey.time = Journelist[i].TimeDuration.ToString();
_Journey.date = Journelist[i].JDate.ToString();
databaseJlist.Add(_Journey);
_Journey = null;
}
lstjourneyList.ItemsSource = databaseJlist;
if (Journelist.Count > 0)
{
TxtlatestdisValue.Text = Journelist[Journelist.Count - 1].Last_distance.ToString("0.00");
}
}
catch (Exception ex)
{
}
}
public List<LocationTable> GetlocationList(IQueryable<LocationTable> JourneyQuery)
{
List<LocationTable> Locationlist = null;
try
{
using (var context = new AgeasDriverDetails(DBConnectionString))
{
if (context.DatabaseExists())
{
Locationlist = JourneyQuery.ToList();
}
context.Dispose();
}
}
catch
{
Locationlist = null;
}
return Locationlist;
}
public Boolean InsertLocation(LocationTable LocationDtls)
{
Boolean result = false;
try
{
using (var context = new AgeasDriverDetails(DBConnectionString))
{
if (context.DatabaseExists())
{
context.tblLocation.InsertOnSubmit(LocationDtls);
context.SubmitChanges();
result = true;
}
context.Dispose();
}
}
catch
{
result = false;
}
return result;
}
private void lstSelectJourney(object sender, SelectionChangedEventArgs e)
{
ListBox cmd = (ListBox)sender;
jlist = new Journeydetail();
jlist = (Journeydetail)cmd.SelectedItem;
cnvBackground.Visibility = Visibility.Visible;
progressBar1.Visibility = Visibility.Visible;
if (Microsoft.Phone.Net.NetworkInformation.NetworkInterface.NetworkInterfaceType != Microsoft.Phone.Net.NetworkInformation.NetworkInterfaceType.None)
{
progressBar1.Visibility = Visibility.Visible;
if (ObjCommon.IsRecordHaveForUpload())
{
ObjSubmitJourneyLocation = new ClsSubmitJourneyLocation();
ObjSubmitJourneyLocation.PostJourneyLocationDetails(ObjCommon.DeviceId, this);
var context = new DataAccessLayer.AgeasDriverDetails(ClsDBHelper.ClsDBHelper.DBConnectionString);
objDBHelper = new ClsDBHelper.ClsDBHelper();
IQueryable<DataAccessLayer.LocationTable> DeleteLocation = from c in context.tblLocation select c;
objDBHelper.DeleteLocation(DeleteLocation, context);
}
else
{
if (jlist != null)
{
string number = jlist.journey_id;
ClsJourney objJourney = new ClsJourney();
objJourney.GetJourneyDetails(ObjCommon.DeviceId, jlist.journey_id, this);
//NavigationService.Navigate(new Uri("/Pages/frmDetailMessage.xaml?ph_num=" + number +"&Contact_Header=" + mlist.ContactName, UriKind.Relative));
}
}
}
else
{
MessageBox.Show("Internet connection not available. Please try again later!");
}
}