public static tblNumberGenerate AutoGenerate(int type)
{
var db = new dbTrainEntities(ConnectionController.GetConnection());
tblNumberGenerate number = new tblNumberGenerate();
number.Year = CommonFactory.GetCurrentDate().Year + "";
number.NumberType = type;
tblNumberGenerate max = getMaxValueByType(type);
if (max == null)
{
max = new tblNumberGenerate
{
HandoverNumber = 0,
ReplyReportNumber = 0,
Year = CommonFactory.GetCurrentDate().Year + ""
};
}
if (type == NUMBER_TYPE_HANDOVER)
{
number.HandoverNumber = max.HandoverNumber + 1;
}
if (type == NUMBER_TYPE_REPLY)
{
number.ReplyReportNumber = max.ReplyReportNumber + 1;
}
return(number);
}
public static int Update(tblType typeObj)
{
var db = new dbTrainEntities(ConnectionController.GetConnection());
tblType originType = db.tblTypes.Where(g => g.TypeCode == typeObj.TypeCode).FirstOrDefault();
if (originType == null)
{
return(-1);
}
originType.TypeName = typeObj.TypeName;
originType.Description = typeObj.Description;
originType.ModifiedBy = typeObj.ModifiedBy;
originType.ModifiedDate = CommonFactory.GetCurrentDate();
try
{
return(db.SaveChanges());
}
catch (Exception ex)
{
return(-1);
}
}
public static int UpdateHandover(tblHandover handover)
{
try
{
var db = Instance();
handover.ModifiedDate = CommonFactory.GetCurrentDate();
var originHandover = db.tblHandovers.Include("tblHandoverResources").Where(g => g.ID == handover.ID).FirstOrDefault();
if (originHandover == null)
{
return(0);
}
db.Detach(originHandover);
if (originHandover.EntityState == EntityState.Detached)
{
object original = null;
if (db.TryGetObjectByKey(originHandover.EntityKey, out original))
{
db.ApplyPropertyChanges(originHandover.EntityKey.EntitySetName, handover);
}
}
return(db.SaveChanges());
}
catch (Exception ex)
{
return(0);
}
}
public static int Update(tblCompany companyObj)
{
var db = new dbTrainEntities(ConnectionController.GetConnection());
tblCompany originCompany = db.tblCompanies.Where(g => g.CompanyCode == companyObj.CompanyCode).FirstOrDefault();
if (originCompany == null)
{
return(-1);
}
originCompany.CompanyName = companyObj.CompanyName;
originCompany.Description = companyObj.Description;
originCompany.ModifiedBy = companyObj.ModifiedBy;
originCompany.ModifiedDate = CommonFactory.GetCurrentDate();
try
{
return(db.SaveChanges());
}
catch (Exception ex)
{
return(-1);
}
}
public static int Insert(tblTrain train)
{
var db = new dbTrainEntities(ConnectionController.GetConnection());
train.CreatedDate = CommonFactory.GetCurrentDate();
db.AddTotblTrains(train);
return(db.SaveChanges());
}
public static tblNumberGenerate getMaxValueByType(int type)
{
var db = new dbTrainEntities(ConnectionController.GetConnection());
String year = CommonFactory.GetCurrentDate().Year + "";
return(db.tblNumberGenerates.
Where(x => x.NumberType == type && x.Year == year).
OrderByDescending(x => x.ID).FirstOrDefault());
}
public static int Insert(tblCompany company)
{
var db = new dbTrainEntities(ConnectionController.GetConnection());
company.CreatedDate = CommonFactory.GetCurrentDate();
company.ModifiedDate = CommonFactory.GetCurrentDate();
db.AddTotblCompanies(company);
return(db.SaveChanges());
}
public static int InsertToKhai(tblToKhaiTau tokhai)
{
var db = new dbTrainEntities(ConnectionController.GetConnection());
tokhai.CreatedDate = CommonFactory.GetCurrentDate();
db.AddTotblToKhaiTaus(tokhai);
return(db.SaveChanges());
}
public static int Insert(tblGroup group)
{
var db = new dbTrainEntities(ConnectionController.GetConnection());
group.CreatedDate = CommonFactory.GetCurrentDate();
group.ModifiedDate = CommonFactory.GetCurrentDate();
db.AddTotblGroups(group);
int re = db.SaveChanges();
db.Connection.Close();
return(re);
}
public static int InsertToaTau(List <tblToaTau> listToaTau)
{
var db = new dbTrainEntities(ConnectionController.GetConnection());
foreach (var toaTau in listToaTau)
{
toaTau.CreatedDate = CommonFactory.GetCurrentDate();
db.AddTotblToaTaus(toaTau);
}
return(db.SaveChanges());
}
public static int Update(tblTrain train)
{
var db = new dbTrainEntities(ConnectionController.GetConnection());
train.ModifiedDate = CommonFactory.GetCurrentDate();
var originTrain = db.tblTrains.Where(g => g.TrainID == train.TrainID).FirstOrDefault();
if (originTrain == null)
{
return(-1);
}
db.Attach(originTrain);
db.ApplyPropertyChanges("tblTrains", train);
return(db.SaveChanges());
}
public static int UpdateToKhaiTau(tblToKhaiTau toKhaiTau, List <tblToaTau> listToaTau)
{
try
{
var db = Instance();
//xoa cac toa tau cu thuoc to khai
List <tblToKhaiTauResource> listReource = db.tblToKhaiTauResources.Where(x => x.tblToKhaiTau.ID == toKhaiTau.ID).ToList();
foreach (tblToKhaiTauResource resource in listReource)
{
deleteToKhaiTauResource(resource);
}
//cap nhat thong tin to khai tau
tblToKhaiTau toKhaitauOrigin = db.tblToKhaiTaus.Where(x => x.ID == toKhaiTau.ID).FirstOrDefault();
if (toKhaitauOrigin != null)
{
toKhaitauOrigin.Number = toKhaiTau.Number;
toKhaitauOrigin.DateDeclaration = toKhaiTau.DateDeclaration;
toKhaitauOrigin.TypeCode = toKhaiTau.TypeCode;
toKhaitauOrigin.CustomCode = toKhaiTau.CustomCode;
toKhaitauOrigin.ModifiedBy = toKhaiTau.ModifiedBy;
toKhaitauOrigin.ModifiedDate = CommonFactory.GetCurrentDate();
//them cac toa tau moi cho to khai
foreach (var toaTau in listToaTau)
{
var declarationResource = new tblToKhaiTauResource
{
tblToaTau = toaTau
};
toKhaitauOrigin.tblToKhaiTauResources.Add(declarationResource);
}
db.SaveChanges();
}
return(1);
}
catch (Exception)
{
}
return(0);
}
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());
}
