Exemplo n.º 1
0
        public static void ManuPeople(people _People)
        {
            peopleDataContext dc = new peopleDataContext();
            {
                // here we have the update or Insert
                //// --  var findPeople = getPeopleID(_People.Id);
                var findPeople = (from gente in dc.GetTable <people>()
                                  where (gente.Id == _People.Id)
                                  select gente).SingleOrDefault <people>();

                if (findPeople == null)
                {
                    try
                    {
                        people people = new people();
                        people.Id    = _People.Id;
                        people.name  = _People.name;
                        people.phone = _People.phone;
                        people.age   = _People.age;

                        Table <people> peopleInsert = GetPeople();
                        peopleInsert.InsertOnSubmit(people);
                        peopleInsert.Context.SubmitChanges();
                    }
                    catch (Exception)
                    {
                        // better way, because you can capture ALL exception and use it as IS
                        throw;
                    }
                }
                else
                {
                    try
                    {
                        //use the findPeople on CONTEXT
                        findPeople.Id    = _People.Id;
                        findPeople.name  = _People.name;
                        findPeople.phone = _People.phone;
                        findPeople.age   = _People.age;
                        dc.SubmitChanges();
                    }
                    catch (Exception)
                    {
                        // better way, because you can capture ALL exception and use it as IS
                        throw;
                    }
                }
            }
        }
Exemplo n.º 2
0
 partial void Updatepeople(people instance);
Exemplo n.º 3
0
 partial void Deletepeople(people instance);
Exemplo n.º 4
0
 partial void Insertpeople(people instance);