/// <summary>
/// To update record about stand in database
/// </summary>
/// <param name="stand"></param>
/// <returns></returns>
public int UpdateStand(Stand stand)
{
using (var db = new StandCommercialContext())
{
db.Entry(stand).State = EntityState.Modified;
db.SaveChanges();
return(stand.Id);
}
}
/// <summary>
/// To add record about stand in database
/// </summary>
/// <param name="stand"></param>
/// <returns></returns>
public int AddStand(Stand stand)
{
using (var db = new StandCommercialContext())
{
db.Stands.Add(stand);
db.SaveChanges();
db.Entry(stand).GetDatabaseValues();
return(stand.Id);
}
}
/// <summary>
/// Add record about commercial, and records abot mapping comercial and stands, in databases
/// </summary>
/// <param name="commercial"></param>
/// <param name="standId"></param>
/// <returns></returns>
public int AddCommercialCurrentStand(Commercial commercial, List <int> standId)
{
using (var db = new StandCommercialContext())
{
db.Commercials.Add(commercial);
db.SaveChanges();
var stand = new Stand();
foreach (var id in standId)
{
stand = db.Stands.Find(id);
commercial.StandCommercials.Add(new StandCommercial {
CommercialId = commercial.Id, StandId = stand.Id
});
db.SaveChanges();
}
db.Entry(commercial).GetDatabaseValues(); // потом попробывать без этого
return(commercial.Id);
}
}
