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()); }