/// <summary>
/// Обновление данных модели лодки в БД
/// </summary>
/// <param name="boatmodel"></param>
public void Update(BoatModel boatmodel)
{
using (TripleBDbContext db = new TripleBDbContext())
{
if (boatmodel != null)
{
db.BoatModels.Update(boatmodel);
db.SaveChanges();
}
}
}
/// <summary>
/// Обновление данных заявки в БД
/// </summary>
/// <param name="recall"></param>
public void Update(Message recall)
{
using (TripleBDbContext db = new TripleBDbContext())
{
if (recall != null)
{
db.Messages.Update(recall);
db.SaveChanges();
}
}
}
/// <summary>
/// Добавление аккаунта в БД
/// </summary>
/// <param name="account"></param>
public void Create(Account account)
{
using (TripleBDbContext db = new TripleBDbContext())
{
if (account != null)
{
db.Accounts.Add(account);
db.SaveChanges();
}
}
}
/// <summary>
/// Добавление изображения в БД
/// </summary>
/// <param name="image"></param>
public void Create(Image image)
{
using (TripleBDbContext db = new TripleBDbContext())
{
if (image != null)
{
db.Images.Add(image);
db.SaveChanges();
}
}
}
/// <summary>
/// Обновление данных договора аренды в БД
/// </summary>
/// <param name="rent"></param>
public void Update(Rent rent)
{
using (TripleBDbContext db = new TripleBDbContext())
{
if (rent != null)
{
db.Rents.Update(rent);
db.SaveChanges();
}
}
}
/// <summary>
/// Обновление данных текстового блока в БД
/// </summary>
/// <param name="textblock"></param>
public void Update(TextBlock textblock)
{
using (TripleBDbContext db = new TripleBDbContext())
{
if (textblock != null)
{
db.NewsTexts.Update(textblock);
db.SaveChanges();
}
}
}
/// <summary>
/// Удаление новости из БД
/// </summary>
/// <param name="id"></param>
public void Delete(int id)
{
using (TripleBDbContext db = new TripleBDbContext())
{
News news = db.News.FirstOrDefault(x => x.Id == id);
if (news != null)
{
db.News.Remove(news);
db.SaveChanges();
}
}
}
/// <summary>
/// Добавление новости в БД
/// </summary>
/// <param name="news"></param>
public int Create(News news)
{
using (TripleBDbContext db = new TripleBDbContext())
{
if (news != null)
{
db.News.Add(news);
db.SaveChanges();
}
}
return(news.Id);
}
/// <summary>
/// Добавление лодки в БД
/// </summary>
/// <param name="boat"></param>
public int Boat_Create(Boat boat)
{
using (TripleBDbContext db = new TripleBDbContext())
{
if (boat != null)
{
db.Boats.Add(boat);
db.SaveChanges();
}
return(boat.Id);
}
}
/// <summary>
/// Удаление лодки из БД
/// </summary>
/// <param name="id"></param>
public void Boat_Delete(int id)
{
using (TripleBDbContext db = new TripleBDbContext())
{
Boat boat = db.Boats.FirstOrDefault(x => x.Id == id);
if (boat != null)
{
db.Boats.Remove(boat);
db.SaveChanges();
}
}
}
/// <summary>
/// Удаление текстового блока из БД
/// </summary>
/// <param name="id"></param>
public void Delete(int id)
{
using (TripleBDbContext db = new TripleBDbContext())
{
TextBlock textblock = db.NewsTexts.FirstOrDefault(x => x.Id == id);
if (textblock != null)
{
db.NewsTexts.Remove(textblock);
db.SaveChanges();
}
}
}
/// <summary>
/// Удаление модели лодки из БД
/// </summary>
/// <param name="id"></param>
public void Delete(int id)
{
using (TripleBDbContext db = new TripleBDbContext())
{
BoatModel boatmodel = db.BoatModels.FirstOrDefault(x => x.Id == id);
if (boatmodel != null)
{
db.BoatModels.Remove(boatmodel);
db.SaveChanges();
}
}
}
/// <summary>
/// Удаление заявки из БД
/// </summary>
/// <param name="id"></param>
public void Delete(int id)
{
using (TripleBDbContext db = new TripleBDbContext())
{
Message recall = db.Messages.FirstOrDefault(x => x.Id == id);
if (recall != null)
{
db.Messages.Remove(recall);
db.SaveChanges();
}
}
}
/// <summary>
/// Добавление заявки в БД
/// </summary>
/// <param name="recall"></param>
public int Create(Message recall)
{
using (TripleBDbContext db = new TripleBDbContext())
{
if (recall != null)
{
db.Messages.Add(recall);
db.SaveChanges();
}
}
return(recall.Id);
}
/// <summary>
/// Удаление изображения из БД
/// </summary>
/// <param name="id"></param>
public void Delete(int id)
{
using (TripleBDbContext db = new TripleBDbContext())
{
Image image = db.Images.FirstOrDefault(x => x.Id == id);
if (image != null)
{
db.Images.Remove(image);
db.SaveChanges();
}
}
}
/// <summary>
/// Удаление договора аренды из БД
/// </summary>
/// <param name="id"></param>
public void Delete(int id)
{
using (TripleBDbContext db = new TripleBDbContext())
{
Rent rent = db.Rents.FirstOrDefault(x => x.Id == id);
if (rent != null)
{
db.Rents.Remove(rent);
db.SaveChanges();
}
}
}
/// <summary>
/// Обновление данных изображения в БД
/// </summary>
/// <param name="image"></param>
public void Update(Image image)
{
using (TripleBDbContext db = new TripleBDbContext())
{
var result = db.Images.FirstOrDefault(x => x.Id == image.Id);
if (image != null && result != null)
{
result.Content = image.Content;
db.SaveChanges();
}
}
}
/// <summary>
/// Удалить все данные по указанному пользователю
/// </summary>
/// <param name="owner_id"></param>
public void DeleteByOwnerId(int owner_id)
{
using (TripleBDbContext db = new TripleBDbContext())
{
foreach (TextBlock textblock in db.NewsTexts.Where(x => x.OwnerId == owner_id))
{
if (textblock != null)
{
db.NewsTexts.Remove(textblock);
}
}
db.SaveChanges();
}
}
/// <summary>
/// Обновление данных аккаунта в БД
/// </summary>
/// <param name="account"></param>
public void Update(Account account)
{
using (TripleBDbContext db = new TripleBDbContext())
{
Account old_account = db.Accounts.FirstOrDefault(x => x.Login == account.Login),
new_account = old_account;
new_account.Password = account.Password;
if (account != null)
{
db.Accounts.Update(new_account);
db.SaveChanges();
}
}
}
public void DeleteByOwnerId(int owner_id)
{
using (TripleBDbContext db = new TripleBDbContext())
{
foreach (Image image in db.Images.Where(x => x.OwnerId == owner_id))
{
if (image != null)
{
db.Images.Remove(image);
}
}
db.SaveChanges();
}
}
/// <summary>
/// Обновление данных новости в БД
/// </summary>
/// <param name="news"></param>
public void Update(News news)
{
using (TripleBDbContext db = new TripleBDbContext())
{
var result = db.News.FirstOrDefault(x => x.Id == news.Id);
if (news != null)
{
result.Preview = news.Preview;
result.Title = news.Title;
result.Date = news.Date;
db.SaveChanges();
}
}
}
/// <summary>
/// Обновление данных лодки в БД
/// </summary>
/// <param name="boat"></param>
public void Boat_Update(Boat boat)
{
using (TripleBDbContext db = new TripleBDbContext())
{
var result = db.Boats.FirstOrDefault(x => x.Id == boat.Id);
if (boat != null && result != null)
{
result.Kind = boat.Kind;
result.Speed = boat.Speed;
result.Status = boat.Status;
result.Description = boat.Description;
result.Cost = boat.Cost;
result.BoatType = boat.BoatType;
db.SaveChanges();
}
}
}