C# dbEcustomEntities.SaveChanges方法代码示例

 public static int Update(tblVehicleType vehicletype)
 {
     var _db = new dbEcustomEntities(Common.Decrypt(ConfigurationManager.ConnectionStrings["dbEcustomEntities"].ConnectionString, true));
     _db.Connection.Open();
     var _vehicletype = (from vt in _db.tblVehicleTypes
                         where vt.VehicleTypeID == vehicletype.VehicleTypeID
                         select vt).First();
     _vehicletype.Name = vehicletype.Name;
     _vehicletype.Capacity = vehicletype.Capacity;
     _vehicletype.Description = vehicletype.Description;
     vehicletype.UpdatedDate = CommonFactory.GetCurrentDate();
     try
     {
         if (_db.Connection.State == ConnectionState.Closed) _db.Connection.Open();
         _db.SaveChanges();
     }
     catch (Exception ex)
     {
         return 1;
     }
     finally
     {
         if (_db.Connection.State == ConnectionState.Closed) _db.Connection.Open();
         _db.Connection.Close();
     }
     return 0;
 }

 /// <summary>
 /// Delete Decleration by ID
 /// </summary>
 /// <param name="declerationID">DeclerationID</param>
 /// <returns>Number of rows are effected</returns>
 public static int DeleteByID(int declerationID)
 {
     var db = new dbEcustomEntities(Utilities.Common.Decrypt(ConfigurationManager.ConnectionStrings["dbEcustomEntities"].ConnectionString, true));
     var declaration = db.tblDeclarations.Where(g => g.DeclarationID == declerationID).FirstOrDefault();
     db.DeleteObject(declaration);
     return db.SaveChanges();
 }

 /// <summary>
 /// Delete vehicle by ID
 /// </summary>
 /// <param name="vehicleID">Vehicle ID</param>
 /// <returns>Number of rows are effected</returns>
 public static int DeleteByID(int vehicleID)
 {
     var db = new dbEcustomEntities(Utilities.Common.Decrypt(ConfigurationManager.ConnectionStrings["dbEcustomEntities"].ConnectionString, true));
     var vehicle = db.tblVehicles.Where(g => g.VehicleID == vehicleID).FirstOrDefault();
     db.DeleteObject(vehicle);
     return db.SaveChanges();
 }

        public bool DeleteItem(string[] itemParams)
        {
            if (itemParams.Length < 2) return false;

            string id = itemParams[0];
            string branchId = itemParams[1];

            var _db = new dbEcustomEntities(Common.Decrypt(ConfigurationManager.ConnectionStrings["dbEcustomEntities"].ConnectionString, true));

            try
            {
                var deleteItem =
                    _db.tblPermissionTypes.FirstOrDefault(
                        item => item.TypeCode == id && item.BranchId == branchId);
                if (deleteItem != null)
                {
                    _db.DeleteDirectly(deleteItem);
                    _db.SaveChanges();
                }

                return true;
            }
            catch (Exception exception)
            {
                LogManager.GetLogger("ECustoms.PermissionTypeFactory").Error(exception.ToString());
                throw;
            }
            finally
            {
                _db.Connection.Close();
            }
        }

        public bool DeleteItem(string[] itemParams)
        {
            if (itemParams.Length < 3) return false;

            int id = itemParams[0].StringToInt();
            int verhiceId = itemParams[1].StringToInt();
            string branchId = itemParams[2];

            var _db = new dbEcustomEntities(Common.Decrypt(ConfigurationManager.ConnectionStrings["dbEcustomEntities"].ConnectionString, true));

            try
            {
                var deleteItem =
                    _db.tblDeclarationVehicles.FirstOrDefault(
                        item => item.DeclarationID == id && item.VehicleID == verhiceId && item.BranchId == branchId);
                if (deleteItem != null)
                {
                    _db.DeleteDirectly(deleteItem);
                    _db.SaveChanges();
                }

                return true;
            }
            catch (Exception exception)
            {
                LogManager.GetLogger("ECustoms.DeclarationVehicleFactory").Error(exception.ToString());
                throw;
            }
            finally
            {
                _db.Connection.Close();
            }
        }

        public bool BatchInsert(object[] items)
        {
            var _db = new dbEcustomEntities(Common.Decrypt(ConfigurationManager.ConnectionStrings["dbEcustomEntities"].ConnectionString, true));

            try
            {
                _db.Connection.Open();
                foreach (object item in items)
                {
                    _db.AddObjectDirectly("tblProfileConfigs", item);
                }

                _db.SaveChanges();
                return true;
            }
            catch (Exception ex)
            {
                LogManager.GetLogger("ECustoms.AllFactory").Error(ex.ToString());
                throw;
            }
            finally
            {
                _db.Connection.Close();
            }

            return false;
        }

 public static int Insert(tblUserInGroup userGroup)
 {
   var db = new dbEcustomEntities(Common.Decrypt(ConfigurationManager.ConnectionStrings["dbEcustomEntities"].ConnectionString, true));
   db.AddTotblUserInGroups(userGroup);
   int re= db.SaveChanges();
   db.Connection.Close();
   return re;
 }

 /// <summary>
 /// Update Vehicle
 /// </summary>
 /// <param name="vehicle"></param>
 /// <returns></returns>
 public static int UpdateVehicle(tblVehicle vehicle )
 {
     var db = new dbEcustomEntities(Utilities.Common.Decrypt(ConfigurationManager.ConnectionStrings["dbEcustomEntities"].ConnectionString, true));
     // Get orgin vehicle
     var vehicleOrgin = db.tblVehicles.Where(g => g.VehicleID == vehicle.VehicleID).FirstOrDefault();
     db.Attach(vehicleOrgin);
     db.ApplyPropertyChanges("tblVehicles", vehicle);
     return db.SaveChanges();
 }

 public  static int Insert(tblVehicleCheck tblVehicleCheck)
 {
     var db = new dbEcustomEntities(Common.Decrypt(ConfigurationManager.ConnectionStrings["dbEcustomEntities"].ConnectionString, true));
     tblVehicleCheck.CreatedDate = CommonFactory.GetCurrentDate();
     db.AddTotblVehicleChecks(tblVehicleCheck);
     int re = db.SaveChanges();
     db.Connection.Close();
     return re;
 }

 public static int DeleteUserInGroup(int groupID, int userID)
 {
   var db = new dbEcustomEntities(Common.Decrypt(ConfigurationManager.ConnectionStrings["dbEcustomEntities"].ConnectionString, true));
   tblUserInGroup tblUserInGroup = db.tblUserInGroups.Where(g => g.GroupID == groupID && g.UserID == userID).FirstOrDefault();
   if(tblUserInGroup != null)
     db.DeleteObject(tblUserInGroup);
   int re = db.SaveChanges();
   db.Connection.Close();
   return re;
 }

 public static int Insert(tblGroup group)
 {
     var db = new dbEcustomEntities(Common.Decrypt(ConfigurationManager.ConnectionStrings["dbEcustomEntities"].ConnectionString, true));
     group.CreatedDate = CommonFactory.GetCurrentDate();
     group.ModifiedDate = CommonFactory.GetCurrentDate();
     db.AddTotblGroups(group);
     int re = db.SaveChanges();
     db.Connection.Close();
     return re;
 }

 public static int Delete(long checkID)
 {
     var db = new dbEcustomEntities(Common.Decrypt(ConfigurationManager.ConnectionStrings["dbEcustomEntities"].ConnectionString, true));
     var check = db.tblChecks.Where(g => g.CheckID == checkID).FirstOrDefault();
     if (check == null) return -1;
     db.DeleteObject(check);
     int re = db.SaveChanges();
     db.Connection.Close();
     return re;
 }

 /// <summary>
 /// update declaration
 /// </summary>
 /// <param name="declaration"></param>
 /// <param name="modifiedByID"></param>
 /// <returns></returns>
 public static int Update(tblDeclaration declaration)
 {
     var db = new dbEcustomEntities(Utilities.Common.Decrypt(ConfigurationManager.ConnectionStrings["dbEcustomEntities"].ConnectionString, true));
     declaration.ModifiedDate = DateTime.Now;
     // Get orgin object
     var objOrginDeclaration = db.tblDeclarations.Where(g => g.DeclarationID.Equals(declaration.DeclarationID)).FirstOrDefault();
     db.Attach(objOrginDeclaration);
     db.ApplyPropertyChanges("tblDeclarations", declaration);
     return db.SaveChanges();
 }

 /// <summary>
 /// Insert User
 /// </summary>
 /// <param name="userInfo">UserInfo object</param>
 /// <returns>Number of rows are effected</returns>
 public static int Insert(tblUser userInfo)
 {
     // Encode password & username
     userInfo.Password = Common.Encode(userInfo.Password);
     var db = new dbEcustomEntities(Common.Decrypt(ConfigurationManager.ConnectionStrings["dbEcustomEntities"].ConnectionString, true));
     db.AddTotblUsers(userInfo);
     int re = db.SaveChanges();
     db.Connection.Close();
     return re;
 }

        public static bool UpdateSettings(string  version, DateTime lastSync, int interval, string  syncTime, bool  isStartSync)
        {
            dbEcustomEntities _db = new dbEcustomEntities(Common.Decrypt(ConfigurationManager.ConnectionStrings["dbEcustomEntities"].ConnectionString, true));
            try
            {
                if (_db.Connection.State == ConnectionState.Closed) _db.Connection.Open();

                var existing = _db.tblSettings.FirstOrDefault(p => p.Version == version);
                if(existing==null)
                {
                    tblSetting setting = new tblSetting();
                    setting.Version = version;
                    setting.LastSync = lastSync;
                    setting.SyncInterval = interval;
                    setting.SyncTime = syncTime;
                    setting.IsStartingSync = isStartSync;
                    _db.AddTotblSettings(setting);

                    return _db.SaveChanges() > 0;
                }
                else
                {
                    //existing.Version = version;
                    existing.LastSync = lastSync;
                    existing.SyncInterval = interval;
                    existing.SyncTime = syncTime;
                    existing.IsStartingSync = isStartSync;

                    return _db.SaveChanges() > 0;
                }
            }
            catch(Exception e)
            {
                return false;
            }
            finally
            {
                _db.Connection.Close();
            }

            return false;
        }