DocumentPrix Table=new DocumentPrix();
Table.SchetF = cSchetF.Text;
Table.DateF=cDateF.Value;

            for (int i = 0; i < dataGridTov.RowCount; i++)
            {
                Skl_DocumentPrixNom n = new Skl_DocumentPrixNom();
                
                n.id_Nomenklatura=(int)dataGridTov.Rows[i].Cells["id_Nomenklatura"].Value ;
                n.CenaPos=(decimal)dataGridTov.Rows[i].Cells["CenaPos"].Value;
                
                Table.Skl_DocumentPrixNom.Add(n);

            }


           CData.Model.Skl_DocumentPrix.AddObject(Table);

            bool err = false;

            try
            {
                CData.Model.SaveChanges();
            }
            catch (Exception ex)
            {
                CMessage.Error("Ошибка:" + ex.Message + "   " + ex.InnerException.Message);
                CData.Model.Detach(Table);
                err = true;
            }
            finally
            {
            }

 try
            {
                CData.Model.SaveChanges();
                CData.Model.Refresh(RefreshMode.ClientWins, CData.Model.Skl_DocumentPrix);
            }
            catch (Exception ex)
            {
                CMessage.Error("Ошибка:" + ex.Message + "   " + ex.InnerException.Message);
                List<Skl_DocumentPrixNom> tt=new List<Skl_DocumentPrixNom>();
                foreach (Skl_DocumentPrixNom i in Table.Skl_DocumentPrixNom)
                {
                    tt.Add(i);
                }
                foreach (Skl_DocumentPrixNom i in tt)
                {
                    CData.Model.Detach(i);
                }
                CData.Model.Detach(Table);
                
                CData.Model.Refresh(RefreshMode.ClientWins, CData.Model.Skl_DocumentPrix);
                CData.Model.Refresh(RefreshMode.ClientWins, CData.Model.Skl_DocumentPrixNom);
                CData.Model.Refresh(RefreshMode.StoreWins, CData.Model.Skl_DocumentPrix);
                CData.Model.Refresh(RefreshMode.StoreWins, CData.Model.Skl_DocumentPrixNom);

                err = true;
            }