C# DataClasses1DataContext.SubmitChanges方法代码示例

 // Update Account <acc> in database
 public static bool update(Account acc)
 {
     using (DataClasses1DataContext database = new DataClasses1DataContext(Globals.connectionString))
     {
         var query = from a in database.Accounts
                     // Assuming the accountNumber is enough of an identifier.
                     // Additional 'where' clauses can be added if necessary.
                     where (a.AccountID == acc.AccountID)
                     select a;
         // It seems to me that a single account renders the foreach unnecessary. However, I can't
         // find another way to get the variable 'a' from 'query'.
         foreach (var a in query)
         {
             a.AccountAddress = acc.AccountAddress;
             a.AccountFirstName = acc.AccountFirstName;
             a.AccountLastName = acc.AccountLastName;
             a.AccountNum = acc.AccountNum;
             a.AccountPhoneNum = acc.AccountPhoneNum;
             a.AccountRoutingNum = acc.AccountRoutingNum;
             a.BankID = acc.BankID;
         }
         try
         {
             database.SubmitChanges();
             return true;
         }
         catch (Exception e)
         {
             return false;
         }
     }
 }

 // Update Store <store>
 public static bool update(Store store)
 {
     using (DataClasses1DataContext database = new DataClasses1DataContext(Globals.connectionString))
     {
         var query = from a in database.Stores
                     where (a.StoreID == store.StoreID)
                     select a;
         foreach (var a in query)
         {
             a.StoreNum = store.StoreNum;
             a.StoreName = store.StoreName;
             a.StoreAddress = store.StoreAddress;
             a.StoreServiceCharge = store.StoreServiceCharge;
         }
         try
         {
             database.SubmitChanges();
             return true;
         }
         catch (Exception e)
         {
             return false;
         }
     }
 }

 // Update Check <check>
 public static bool update(Check check)
 {
     using (DataClasses1DataContext database = new DataClasses1DataContext(Globals.connectionString))
     {
         var query = from a in database.Checks
                     where (a.CheckID == check.CheckID)
                     select a;
         foreach (var a in query)
         {
             a.CheckAmount = check.CheckAmount;
             a.CheckAmountOwed = check.CheckAmountOwed;
             a.CheckCashierID = check.CheckCashierID;
             a.CheckDate = check.CheckDate;
             a.CheckDeleted = check.CheckDeleted;
             a.CheckNum = check.CheckNum;
             a.CheckPaidDate = check.CheckPaidDate;
         }
         try
         {
             database.SubmitChanges();
             return true;
         }
         catch (Exception e)
         {
             return false;
         }
     }
 }

        private void button1_Click(object sender, EventArgs e)
        {
            try
            {
                if(!String.IsNullOrWhiteSpace(textBox1.Text) &&
                    !String.IsNullOrWhiteSpace(textBox2.Text) &&
                    !String.IsNullOrWhiteSpace(textBox3.Text))
                {
                    DataClasses1DataContext doctorContext= new DataClasses1DataContext();
                    Doctor doctor = new Doctor();
                    doctor.doctorName = textBox1.Text;
                    doctor.doctorID = textBox2.Text;
                    doctor.gloveSize = Decimal.Parse(textBox3.Text);
                    doctorContext.Doctors.InsertOnSubmit(doctor);

                    doctorContext.SubmitChanges();
                    textBox1.Text = "";
                    textBox2.Text = "";
                    textBox3.Text = "";
                    Form1.GetDoctors();
                    loadDoctors();
                }
                else
                {
                    MessageBox.Show("Cannot be empty...", "Error",
                        MessageBoxButtons.OK, MessageBoxIcon.Error);
                }

            }
            catch
            {
                MessageBox.Show("Something went wrong, does the doctor already exist? Please try again...", "Error",
                    MessageBoxButtons.OK, MessageBoxIcon.Error);
            }
        }

        //public bool advanceUserInStudy(DataClasses1DataContext database, int SID, int UID)
        public bool advanceUserInStudy(int SID, int UID)
        {
            DataClasses1DataContext database = new DataClasses1DataContext();
            StudiesUser u = (from user in database.StudiesUsers
                             where user.StudyID == SID && user.UserID == UID
                             select user).Single();
            //database.Refresh(refresh_mode, new Object[] {u, database.WordSublists, database.TrialTypes});
            StudyUserGroup g = u.StudyUserGroup;
            //database.Refresh(refresh_mode, g);

            var subkeys = (from s in database.WordSublists
                           select s.ID);
            var typekeys = (from s in database.TrialTypes
                            select s.ID);

            int firstSublist = subkeys.Min();
            int lastSublist = subkeys.Max();
            int firstType = typekeys.Min();
            int lastType = typekeys.Max();

            if ((u.WordSublistID < lastSublist) && u.Mix)
            {
                u.WordSublistID++;
                u.Mix = false;
            }
            else if (!u.Mix)
            {
                if (u.WordSublistID == firstSublist) //nothing to mix at the beginning
                {
                    u.WordSublistID++;
                }
                else
                {
                    u.Mix = true;
                }
            }
            else if (u.TrialTypeID < lastType)
            {
                u.WordSublistID = firstSublist;
                u.TrialTypeID++;
                u.Mix = false;
            }
            else if (u.WordListID == g.FirstListID)
            {
                u.WordListID = g.SecondListID;
                u.WordSublistID = firstSublist;
                u.TrialTypeID = firstType;
            }
            else
            {
                u.Complete = true;
            }
            database.SubmitChanges();
            return u.Complete;
        }

        public ActionResult Index(_Habitacion a)
        {
            DataClasses1DataContext db = new DataClasses1DataContext();
            var id = db.habitacions.Where(b => b.numero == a.numero).First();
            id.disponibilidad = a.disponibilidad;
            id.precio = a.precio;
            id.tipo = a.tipo;
            db.SubmitChanges();

            ViewBag.gg = -1;
            ViewBag.t = new SelectListItem[] { new SelectListItem { Selected = true, Text = "0", Value = "0" } };

            return View();
        }

 public static bool InsertZast(ZAST z)
 {
     DataClasses1DataContext dc = new DataClasses1DataContext();
     try
     {
         dc.AddNewZast(z.FName, z.LName, z.CarNum, z.CarBrand, z.CarModel, (Int16)z.CarType, z.CarAddinfo, (Int16)z.ExpireDateDay, (Int16)z.ExpireDateMonth, (int)z.ExpireDateYear, (int)z.employee, z.Price, (Int16)z.City);
         dc.SubmitChanges();
     }
     catch (Exception)
     {
         return false;
     }
     return true;
 }

        public ActionResult Index(StructUser u)
        {
            DataClasses1DataContext db = new DataClasses1DataContext();
            var id = db.Users.Where(b => b.UserId == u.id).First();
            id.UserName = u.nombre;
            id.Membership.Email = u.email;
            //            id.cliente.nit = u.nit;
            db.SubmitChanges();

            ViewBag.gg = Guid.Parse("00000000-0000-0000-0000-000000000000");
            ViewBag.t = new SelectListItem[] { new SelectListItem { Selected = true, Text = "0", Value = "0" } };

            return View();
        }

 // Create Check <check>
 public static bool create(Check check)
 {
     using (DataClasses1DataContext database = new DataClasses1DataContext(Globals.connectionString))
     {
         database.Checks.InsertOnSubmit(check);
         try
         {
             database.SubmitChanges();
             return true;
         }
         catch (Exception e)
         {
             return false;
         }
     }
 }

        private void submitEditDoctorButton_Click(object sender, EventArgs e)
        {
            try
            {
                DoctorProcedureClassDataContext editDocSetupContext = new DoctorProcedureClassDataContext();
                DataClasses1DataContext editDocContext = new DataClasses1DataContext();

                var doctorSetups = (from setups in editDocSetupContext.DoctorsProcedures
                                    where setups.doctorName == oldDoctorName.Text
                                    select setups);

                var doctor = (from docs in editDocContext.Doctors
                              where docs.doctorName == oldDoctorName.Text
                              select docs).First();

                if (!String.IsNullOrWhiteSpace(newDoctorName.Text) &&
                    !String.IsNullOrWhiteSpace(newInitials.Text) &&
                    !String.IsNullOrWhiteSpace(newGloves.Text))
                {
                    foreach (DoctorsProcedure setup in doctorSetups)
                    {
                        setup.doctorName = newDoctorName.Text;
                        setup.gloveSize = Decimal.Parse(newGloves.Text);
                    }

                    doctor.doctorName = newDoctorName.Text;
                    doctor.gloveSize = Decimal.Parse(newGloves.Text);

                    editDocSetupContext.SubmitChanges();
                    editDocContext.SubmitChanges();
                    this.DialogResult = System.Windows.Forms.DialogResult.OK;

                    MessageBox.Show("Updated", "Setup",
                        MessageBoxButtons.OK, MessageBoxIcon.Information);
                }
                else
                {
                    MessageBox.Show("Please fill out all data", "Error",
                        MessageBoxButtons.OK, MessageBoxIcon.Error);
                }
            }
            catch
            {
                MessageBox.Show("Something went wrong, try again", "Error",
                    MessageBoxButtons.OK, MessageBoxIcon.Error);
            }
        }

        protected void Create_Click(object sender, EventArgs e)
        {
            using (var db = new DataClasses1DataContext())
            {

                ShippingRestriction rest = new ShippingRestriction();
                rest.Code = Code.Text;
                rest.Caption = Caption.Text;
                rest.Comment = Comment.Text;
                rest.CityFilterMode = Convert.ToInt32(CityFilterMode.SelectedValue);
                rest.ProductFilterMode = Convert.ToInt32(ProductFilterMode.SelectedValue);
                rest.PrefName = PrefName.Text;
                DateTime dt;
                if (DateTime.TryParse(BeginDate.Text, out dt))
                {
                    rest.BeginDate = dt;
                }
                if (DateTime.TryParse(EndDate.Text, out dt))
                {
                    rest.EndDate = dt;
                }

                var products = new List<ShippingRestrictedProduct>();
                foreach (var item in Products.Text.Split(new char[] { ' ', '\t', ',', '、' }).Select(x => x.Trim()))
                {
                    products.Add(new ShippingRestrictedProduct() { ProductName = item, ShippingRestrictionCode = rest.Code });
                }

                var cities = new List<ShippingRestrictedCity>();
                foreach (var item in Cities.Text.Split(new char[] { ' ', '\t', ',', '、' }).Select(x => x.Trim()))
                {
                    cities.Add(new ShippingRestrictedCity() { CityName = item, ShippingRestrictionCode = rest.Code });
                }

                db.ShippingRestriction.InsertOnSubmit(rest);
                db.ShippingRestrictedProduct.InsertAllOnSubmit(products);
                db.ShippingRestrictedCity.InsertAllOnSubmit(cities);

                db.SubmitChanges();

                ClientScript.RegisterStartupScript(typeof(String), "msg", "alert('追加しました。')", true);
            }
        }

 public static bool markAsVoid(Check check)
 {
     using (DataClasses1DataContext database = new DataClasses1DataContext(Globals.connectionString))
     {
         var query = from a in database.Checks
                     where (a.CheckID == check.CheckID)
                     select a;
         foreach (var a in query)
         {
             a.CheckDeleted = true;
         }
         try
         {
             database.SubmitChanges();
             return true;
         }
         catch (Exception e)
         {
             return false;
         }
     }
 }

        public void SaveCoordinates(String modelPath, String imageStorage)
        {
            // loads from disk, saves to DB.
            var db = new DataClasses1DataContext(_connectionString);
            var aModel = db.TrainingRuns.Where(x => x.Name.Equals(_modelName)).Single();

            _dimensions = CAPI.TrainModel(modelPath + _modelName, true, -1, aModel.Rows, aModel.Cols, (int)CAPI.ImageMode.Undefined, (int)_modelType);
            if (aModel.Dimensions != _dimensions) throw new ApplicationException("Number of dimensions in db dont match number of dimensions in model flat file.");

            var faceCoords = new Dictionary<int, List<double>>();
            double[] coords = new double[_dimensions];
            System.Diagnostics.Debug.WriteLine("Start saving coords");
            var ic = new ImageCache(imageStorage);      // non S3 version
            foreach (String file in Directory.GetFiles(imageStorage, "*.jpg"))
            {
                CAPI.GetCoordinates(file, coords, aModel.Rows, aModel.Cols, (int) CAPI.ImageMode.Histogram);
                int ukey = int.Parse(Path.GetFileNameWithoutExtension(file));

                // store the greyscale for later upload to S3 and display in the carousel
                String histFacePath = ic.GetNormFacePath(ukey, aModel.Rows*2, aModel.Cols*2);     // TODO: maybe we can store larger versions?

                for (int i = 0; i < _dimensions; i++)
                {
                    db.Coordinates.InsertOnSubmit(new Coordinate()
                    {
                        TrainingRunID = aModel.TrainingRunID,
                        Dimension = i,
                        FaceUKey = ukey,
                        Coordinate1 = coords[i]
                    });
                }
                db.SubmitChanges();
                System.Diagnostics.Debug.WriteLine("Storing " + ukey);
            }
            System.Diagnostics.Debug.WriteLine("Done saving coords");

        }

 // Update Bank <bank>
 public static bool update(Bank bank)
 {
     using (DataClasses1DataContext database = new DataClasses1DataContext(Globals.connectionString))
     {
         var query = from a in database.Banks
                     where (a.BankID == bank.BankID)
                     select a;
         foreach (var a in query)
         {
             a.BankRoutingNum = bank.BankRoutingNum;
             a.BankName = bank.BankName;
             a.BankAddress = bank.BankAddress;
         }
         try
         {
             database.SubmitChanges();
             return true;
         }
         catch (Exception e)
         {
             return false;
         }
     }
 }

 public bool recordTrialBlock(TrialBlockData results)
 {
     DataClasses1DataContext database = new DataClasses1DataContext();
     StudiesUser x = (from su in database.StudiesUsers
                      where su.StudyID == results.studyID && su.UserID == results.userID
                      select su).Single();
     TrialBlock newBlock = new TrialBlock();
     newBlock.StudyID = results.studyID;
     newBlock.StartTime = results.taken;
     newBlock.UserID = results.userID;
     newBlock.TrialTypeID = results.typeID;
     newBlock.WordListID = x.WordListID;
     newBlock.WordSublistID = x.WordSublistID;
     database.TrialBlocks.InsertOnSubmit(newBlock);
     database.SubmitChanges();
     int trialcount = results.clickID1s.Length;
     for (int i = 0; i < trialcount; i++)
     {
         Trial newTrial = new Trial();
         newTrial.TrialBlockID = newBlock.ID;
         newTrial.WordID = results.words[i];
         newTrial.TimeFirstIDpresented = results.showID1s[i];
         newTrial.TimeFirstIDclicked = results.clickID1s[i];
         newTrial.TimeSecondIDpresented = results.showID2s[i];
         newTrial.TimeSecondIDclicked = results.clickID2s[i];
         newTrial.TimeOptionsPresented = results.optionsShown[i];
         newTrial.Option1ID = results.optionIDs[i][0];
         newTrial.Option2ID = results.optionIDs[i][1];
         newTrial.Option3ID = results.optionIDs[i][2];
         newTrial.TimeOptionClicked = results.clickOptionTimes[i];
         newTrial.OptionIDClicked = results.optionIDsClicked[i];
         database.Trials.InsertOnSubmit(newTrial);
         database.SubmitChanges();
     }
     return evalPerformance(database, newBlock.ID, newBlock.Study.TargetWordsPerMinute, results.studyID, results.userID);
 }