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