public bool DecentralizeToChucWithGiaoVien(int tcID, List<int> gvIDList)
{
DbTransaction dbTransaction = null;
using (WebPortalEntities dataEntities = new WebPortalEntities())
{
try
{
if (dataEntities.Connection.State == System.Data.ConnectionState.Closed)
{
dataEntities.Connection.Open();
}
dbTransaction = dataEntities.Connection.BeginTransaction();
//Delete old data for gv & tc
var oldTC_GVList = dataEntities.ToChuc_GiaoVien;
foreach (var tcgv in oldTC_GVList)
{
if (tcgv.IDToChuc == tcID)
{
dataEntities.ToChuc_GiaoVien.DeleteObject(tcgv);
}
}
//Insert new data for gv & tc
foreach (var id in gvIDList)
{
var newGVTC = new Model.ToChuc_GiaoVien();
newGVTC.IDGiaoVien = id;
newGVTC.IDToChuc = tcID;
dataEntities.ToChuc_GiaoVien.AddObject(newGVTC);
}
if (dataEntities.SaveChanges() != 0)
{
dbTransaction.Commit();
return true;
}
else
{
dbTransaction.Rollback();
return false;
}
}
catch
{
dbTransaction.Rollback();
return false;
}
finally
{
if (dataEntities.Connection.State == System.Data.ConnectionState.Open)
{
dataEntities.Connection.Close();
}
}
}
}
/// <summary>
/// Deprecated Method for adding a new object to the ToChuc_GiaoVien EntitySet. Consider using the .Add method of the associated ObjectSet<T> property instead.
/// </summary>
public void AddToToChuc_GiaoVien(ToChuc_GiaoVien toChuc_GiaoVien)
{
base.AddObject("ToChuc_GiaoVien", toChuc_GiaoVien);
}
/// <summary>
/// Create a new ToChuc_GiaoVien object.
/// </summary>
/// <param name="id">Initial value of the ID property.</param>
public static ToChuc_GiaoVien CreateToChuc_GiaoVien(global::System.Int32 id)
{
ToChuc_GiaoVien toChuc_GiaoVien = new ToChuc_GiaoVien();
toChuc_GiaoVien.ID = id;
return toChuc_GiaoVien;
}