public static int Insert(tblTrain train) { var _db = new dbEcustomEntities(Common.Decrypt(ConfigurationManager.ConnectionStrings["dbEcustomEntities"].ConnectionString, true)); _db.Connection.Open(); train.CreatedDate = CommonFactory.GetCurrentDate(); train.BranchId= FDHelper.RgCodeOfUnit(); _db.AddTotblTrains(train); try { if (_db.Connection.State == ConnectionState.Closed) _db.Connection.Open(); return _db.SaveChanges(); } catch (Exception ex) { return -1; } finally { _db.Connection.Close(); } }