public frmThemChuyenTau(UserInfo userInfo, short type, tblChuyenTau train, short mode = (short)1)
{
InitializeComponent();
_userInfo = userInfo;
_type = type;
_mode = mode;
_train = train;
}
//New Flow
public static int InsertChuyenTau(tblChuyenTau train)
{
var db = Instance();
db.AddTotblChuyenTaus(train);
return(db.SaveChanges());
}
private void btnAddNew_Click(object sender, EventArgs e)
{
var dr = MessageBox.Show(ConstantInfo.CONFIRM_ADD_NEW, "Confirm", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (dr != DialogResult.Yes)
{
return;
}
try
{
if (!ValidateChuyenTau())
{
return;
}
var train = new tblChuyenTau
{
Ma_Chuyen_Tau = txtNumberTrain.Text.Trim(),
Type = _type,
Ngay_XNC = dtpDateXNC.Value,
IsPassengerTrain = false,
CreatedDate = CommonFactory.GetCurrentDate(),
CreatedBy = _userInfo.UserID
};
foreach (var toaTau in listToaTau)
{
train.tblToaTaus.Add(toaTau);
}
var result = TrainFactory.InsertChuyenTau(train);
if (result > 0)
{
MessageBox.Show("Thêm mới chuyến tàu thành công!");
ResetChuyenTau();
}
else
{
MessageBox.Show("Thêm mới chuyến không thành công!");
}
}
catch (Exception ex)
{
if (GlobalInfo.IsDebug)
{
MessageBox.Show(ex.ToString());
}
}
}
private void InitData()
{
if (_train == null)
{
return;
}
_train = TrainFactory.GetById(_train.TrainID);
txtNumberTrain.Text = _train.Ma_Chuyen_Tau;
if (_train.Ngay_XNC != null)
{
dtpDateXNC.Value = (DateTime)_train.Ngay_XNC;
}
if (!_train.tblToaTaus.IsLoaded)
{
_train.tblToaTaus.Load();
}
listToaTau = _train.tblToaTaus.ToList();
BindToaTau();
}
public static int UpdateChuyenTau(tblChuyenTau train, List <tblToaTau> listToaTau)
{
var db = Instance();
train.ModifiedDate = CommonFactory.GetCurrentDate();
var originChuyenTau = db.tblChuyenTaus.Include("tblToaTaus").Where(g => g.TrainID == train.TrainID).FirstOrDefault();
foreach (var toaTau in listToaTau)
{
//var originalToaTau = originChuyenTau.tblToaTaus
// .Where(c => c.ToaTauID == toaTau.ToaTauID)
// .FirstOrDefault();
var originalToaTau = db.tblToaTaus.Where(c => c.ToaTauID == toaTau.ToaTauID).FirstOrDefault();
if (originalToaTau != null)
{
toaTau.ModifiedDate = train.ModifiedDate;
db.Detach(originalToaTau);
if (originalToaTau.EntityState == EntityState.Detached)
{
object original = null;
if (db.TryGetObjectByKey(originalToaTau.EntityKey, out original))
{
db.ApplyPropertyChanges(originalToaTau.EntityKey.EntitySetName, toaTau);
}
}
}
else
{
originChuyenTau.tblToaTaus.Add(toaTau);
}
}
foreach (var originalToaTau in originChuyenTau.tblToaTaus.Where(c => c.ToaTauID != 0).ToList())
{
if (!listToaTau.Any(c => c.ToaTauID == originalToaTau.ToaTauID))
{
//xoa lien ket cua toa tau cu voi BBBG
List <tblHandoverResource> listHandoverResource = db.tblHandoverResources.Where(x => x.tblToaTau.ToaTauID == originalToaTau.ToaTauID).ToList();
foreach (tblHandoverResource obj in listHandoverResource)
{
db.DeleteObject(obj);
}
//xoa lien ket cua toa tau cu voi to khai
List <tblToKhaiTauResource> listToKhaiTauResource = db.tblToKhaiTauResources.Where(x => x.tblToaTau.ToaTauID == originalToaTau.ToaTauID).ToList();
foreach (tblToKhaiTauResource obj in listToKhaiTauResource)
{
db.DeleteObject(obj);
}
//xoa toa tau
db.DeleteObject(originalToaTau);
}
}
db.Detach(originChuyenTau);
if (originChuyenTau.EntityState == EntityState.Detached)
{
object original = null;
if (db.TryGetObjectByKey(originChuyenTau.EntityKey, out original))
{
db.ApplyPropertyChanges(originChuyenTau.EntityKey.EntitySetName, train);
}
}
return(db.SaveChanges());
}
