}// done
public bool RemoveDrop(int id)
{
try
{
using (var db = new Entitys())
{
//var dropToRemove = (from d in db.Drops where d.Id == id select d).First();
// var dropToRemove = ( from d in db.Drops where d.Drop_Id == id select d).FirstOrDefault();
// Load one blogs and its related posts
// var dropToRemove = db.Drops.Single(d => d.Drop_Id == id);
var dropToRemove = db.Drops
.Where(d => d.Drop_Id == id)
.Include(r => r.Reports_list)
.FirstOrDefault();
db.Drops.Remove(dropToRemove);
db.SaveChanges();
}
return(true);
}
catch (Exception)
{
return(false);
}
} // done
public bool AddDrop(Drop drop)
{
try
{
using (var db = new Entitys())
{
var newDropToAdd = new Drop
{
Id = drop.Id,
Drop_Id = drop.Drop_Id,
Drop_Adress = drop.Drop_Adress,
Drop_time = drop.Drop_time,
Reports_list = drop.Reports_list,
Real_lat = drop.Real_lat,
Real_log = drop.Real_log,
Estimeated_lat = drop.Estimeated_lat,
Estimeated_log = drop.Estimeated_log,
};
db.Drops.Add(newDropToAdd);
db.SaveChanges();
}
return(true);
}
catch (Exception)
{
return(false);
}
}// done
public bool AddReport(Report report)
{
try
{
using (var db = new Entitys())
{
var newReportToAdd = new Report
{
Id = report.Id,
Report_Id = report.Report_Id,
Time = report.Time,
Name = report.Name,
Report_Adress = report.Report_Adress,
Boom_count = report.Boom_count,
ImagePath = report.ImagePath,
lat = report.lat,
log = report.log
};
db.Reports.Add(newReportToAdd);
db.SaveChanges();
}
return(true);
}
catch (Exception)
{
return(false);
}
} //done
} // done
public bool UpdateDrop(Drop Drop)
{
try
{
using (var db = new Entitys())
{
var dropToUpdate = (from d in db.Drops
where d.Drop_Id == Drop.Drop_Id
select d).First();
db.SaveChanges();
}
return(true);
}
catch (Exception)
{
return(false);
}
} // done
}// done
public bool RemoveReport(int id)
{
try
{
using (var db = new Entitys())
{
var reportToRemove = (from r in db.Reports where r.Report_Id == id select r).First();
db.Reports.Remove(reportToRemove);
db.SaveChanges();
}
return(true);
}
catch (Exception)
{
return(false);
}
}//done
} //done
public bool UpdateReport(Report Report)
{
try
{
using (var db = new Entitys())
{
var ReportToUpdate = (from r in db.Reports
where r.Report_Id == Report.Report_Id
select r).First();
db.SaveChanges();
}
return(true);
}
catch (Exception)
{
return(false);
}
}// done