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 Boolean InsertJourney(JourneyDetails JourneyDtls)
{
Boolean result = false;
try
{
using (var context = new AgeasDriverDetails(DBConnectionString))
{
if (context.DatabaseExists())
{
context.tblJourneyDetails.InsertOnSubmit(JourneyDtls);
context.SubmitChanges();
result = true;
}
context.Dispose();
}
}
catch
{
result = false;
}
return result;
}
