public static FeedbackRecipient[] GetFeedbackRecipients(string locale)
 {
     using( var dc = new DCFactory<CmsDataContext>() )
     {
         if (locale != "ru-RU")
         {
             //TODO получается как-то громоздко, но времени в обрез, а справочник этот небольшой, поэтому оставляем так (главное что работает)
             var recipients = from rpts in dc.DataContext.FeedbackRecipients
                              join
                                 locs in dc.DataContext.FeedbackRecipientsLocs on rpts.RecipientID equals locs.RecipientID
                              where locs.Localization == locale
                              select new
                              {
                                  RecipientID = rpts.RecipientID,
                                  RecipientEmail = rpts.RecipientEmail,
                                  RecipientVisible = rpts.RecipientVisible,
                                  RecipientName = locs.RecipientName
                              };
             var recipients_materialized = recipients.ToArray();
             return recipients_materialized.Select(r => new FeedbackRecipient
             {
                 RecipientID = r.RecipientID,
                 RecipientEmail = r.RecipientEmail,
                 RecipientVisible = r.RecipientVisible,
                 RecipientName = r.RecipientName
             }).ToArray();
         }
         else
         {
             return _getFeedbackRecipients(dc.DataContext).ToArray();
         }
     }
 }

        protected void Page_PreRender( object sender, EventArgs e )
        {
            using( var dc = new DCFactory<CmsDataContext>() )
            {
                var groups = dc.DataContext.CatalogItems.GroupBy( c => c.ParentItemID ).ToDictionary( g => g.Key ?? 0 );

                if( groups.Count != 0 )
                {
                    var list = new List<object>();
                    var stack = new Stack<KeyValuePair<CatalogItem,int>>();

                    foreach( var item in groups[ 0 ].OrderByDescending( c=>c.CatalogItemPriority ) )
                        stack.Push( new KeyValuePair<CatalogItem, int>( item, 0 ) );

                    while( stack.Count != 0 )
                    {
                        var node = stack.Pop();
                        list.Add( new { CatalogItem = node.Key, Level = node.Value } );

                        if( groups.ContainsKey( node.Key.CatalogItemID ) )
                        {
                            foreach( var item in groups[ node.Key.CatalogItemID ].OrderByDescending( c => c.CatalogItemPriority ) )
                                stack.Push( new KeyValuePair<CatalogItem, int>( item, node.Value + 1 ) );
                        }
                    }

                    _repeater.DataSource = list;
                    _repeater.DataBind();
                }

            }
        }

 public static UserProfileEntry GetProfileByUsername(string username)
 {
     using (var dc = new DCFactory<StoreDataContext>())
     {
         return _getEntriesByUsername(dc.DataContext, username).SingleOrDefault();
     }
 }

 //public static UserProfileEntry GetProfileByUserId(int userId)
 //{
 //    using (var dc = new StoreDataContext())
 //    {
 //        return _getEntriesByUserId(dc, userId).SingleOrDefault();
 //    }
 //}
 public static ClientAlertConfig GetAlertConfigByClientId(string clientId)
 {
     using (var dc = new DCFactory<StoreDataContext>())
     {
         return _getAlertConfigByClientId(dc.DataContext, clientId).SingleOrDefault();
     }
 }

 public static SparePartGroup[] GetSparePartGroups()
 {
     using( var dc = new DCFactory<CmsDataContext>() )
     {
         return _getSparePartGroups( dc.DataContext ).ToArray();
     }
 }

 public IEnumerable<ShoppingCartItem> LoadItems()
 {
     using (var context = new DCFactory<StoreDataContext>())
     {
         return LoadItems(context.DataContext);
     }
 }

 public static UserMaintEntry[] GetEntries(string username)
 {
     using (var dc = new DCFactory<StoreDataContext>())
     {
         return _getEntriesByUsername(dc.DataContext, username).ToArray();
     }
 }

 /// <summary>
 /// Возвращает ID файла по его наименованию
 /// </summary>
 /// <param name="fileName">Имя файла</param>
 /// <returns>ID файла</returns>
 public static int GetFileIDByName(string fileName)
 {
     using (var dc = new DCFactory<CmsDataContext>())
     {
         return _getFileIDByFileName(dc.DataContext, fileName);
     }
 }

        public static string GetFolderPath( int folderID )
        {
            using(var dc = new DCFactory<CmsDataContext>())
            {
                Folder folder = _getFolderById( dc.DataContext, folderID );

                if( folder != null )
                {
                    List<Folder> list = new List<Folder>();
                    for( Folder f = folder ; f != null ; f = f.Parent )
                    {
                        list.Add( f );
                    }

                    list.Reverse();

                    StringBuilder sb = new StringBuilder();
                    foreach( Folder f in list )
                    {
                        if( sb.Length != 0 ) sb.Append( " / " );
                        sb.Append( f.FolderName );
                    }
                    return sb.ToString();
                }
                else
                {
                    return null;
                }
            }
        }

        protected void Page_Load( object sender, EventArgs e )
        {
            using (var ctx = new DCFactory<StoreDataContext>())
            {
                this.Mfr = Request.QueryString.TryGet<string>( UrlKeys.StoreAndTecdoc.ManufacturerName, String.Empty );
                _pageTitleLiteral.Text = String.Format( "{0} / {1}", CmsContext.Current.CatalogItem.CatalogItemName, this.Mfr );

                var ids = StocksConfiguration.Current.SupplierIds;
                ctx.DataContext.Log = new RmsAuto.Common.Misc.DebuggerWriter();

                throw new NotImplementedException();

                //TODO: Возможно тут стоит переписать через SparePartsDac
                //var sps = ctx.DataContext.SpareParts.Where( sp => sp.Manufacturer == this.Mfr )
                //            .Where( sp => ids.Contains( sp.SupplierID ) )
                //            .OrderBy( sp => sp.PartDescription )
                //            .ThenBy( sp => sp.InitialPrice );

                //var pageSize = StocksConfiguration.Current.PageSize;

                //var pages = new int[ (int)Math.Ceiling( (decimal)sps.Count() / (decimal)pageSize ) ];
                //for( int j = 0 ; j < pages.Length ; j++ )
                //{
                //    pages[ j ] = j + 1;
                //}

                //rptPaging.DataSource = pages;
                //rptPaging.DataBind();

                //rptParts.DataSource = sps.Skip( ( this.PageNum - 1 ) * pageSize ).Take( pageSize ).ToList();
                //rptParts.DataBind();
            }
        }

 public void InsertMessage(int clientId, int userTo, string msgText)
 {
     using (var ctx = new DCFactory<StoreDataContext>())
     {
         ctx.DataContext.ExecuteCommand("insert into UserMessages (User_From, user_To, Text) values ({0},{1},{2})", clientId, userTo, msgText);
     }
 }

 public static TransferChangesLogEntry Load(int logEntryId)
 {
     using (var context = new DCFactory<StoreDataContext>())
     {
         return context.DataContext.TransferChangesLogEntries.Single(tcle => tcle.LogEntryID == logEntryId);
     }
 }

        protected void Page_Load(object sender, EventArgs e)
        {
            if (!IsPostBack)
            {
                Dictionary<byte, string> dNames = new Dictionary<byte, string>();

                using (var dc = new DCFactory<StoreDataContext>())
                {
                    //deas 30.03.2011 task3586
                    // добавлена сортировка и условие отображения
                    foreach ( var statusElement in dc.DataContext.OrderLineStatuses.OrderBy(t => t.ClientShowOrder))
                    {
                        var status = statusElement.OrderLineStatusID;
                        if (OrderLineStatusUtil.IsShow(status))
                        {
                            dNames.Add( status, OrderLineStatusUtil.DisplayName( status ) );
                        }
                    }
                }

                _listView.DataSource = dNames;
                _listView.DataBind();

                InitControls();
            }
        }

        protected void _btnChangeStatus_Click(object sender, EventArgs e)
        {
            int orderID = -1; int.TryParse(_txtOrderID.Text.Trim(), out orderID); if (orderID < 0) return;
            using (var dc = new DCFactory<StoreDataContext>())
            {
                for (int i = 0; i < _gvOrderLines.Rows.Count; i++)
                {
                    if (!((CheckBox)_gvOrderLines.Rows[i].Cells[0].Controls[0]).Checked) continue;
                    DataControlFieldCell cb = (DataControlFieldCell)_gvOrderLines.Rows[i].Cells[2];
                    int orderLineID; try { orderLineID = Convert.ToInt32(cb.Text); }
                    catch { continue; }
                    OrderLine line = dc.DataContext.OrderLines.FirstOrDefault(l => l.OrderLineID == orderLineID && l.OrderID == orderID);
                    if (line != null && line.CurrentStatus != OrderLineStatusUtil.StatusByte("Rejected"))
                    {
                        byte newStatus = 0;
                        byte.TryParse(_ddlStatuses.SelectedValue, out newStatus);
                        if (newStatus > 0)
                        {
                            //новая дата статуса
                            DateTime orderLineStatusDate;
                            try { orderLineStatusDate = DateTime.ParseExact(_txtStatusDate.Text, "dd.MM.yyyy", CultureInfo.InvariantCulture); }
                            catch { orderLineStatusDate = DateTime.Now; }
                            line.CurrentStatus = newStatus;
                            line.CurrentStatusDate = orderLineStatusDate;
                        }
                    }
                }
                dc.DataContext.SubmitChanges();
            }

            FillData();
        }

 public static IEnumerable<VinRequest> GetRequests(string clientId)
 {
     using (var ctx = new DCFactory<StoreDataContext>())
     {
         return _getClientVinRequests(ctx.DataContext, clientId).ToList();
     }
 }

        public static IEnumerable<BriefClientInfo> Search(
            string clientName, 
            string mainPhone,
            ClientSearchMatching matching)
        {
            using (var dc = new DCFactory<StoreDataContext>())
            {

                List<BriefClientInfo> ret = new List<BriefClientInfo>();
                if (!LightBO.IsLight())
                {
                    var rezSearch = dc.DataContext.spSelUsersByFields(clientName, "", mainPhone);

                    foreach (var oneRez in rezSearch)
                    {
                        ret.Add(new BriefClientInfo()
                        {
                            ClientID = oneRez.AcctgID,
                            ClientName = oneRez.ClientName,
                          //  MainPhone = oneRez.ContactPhone
                        });
                    }
                }
                else
                {
                    dc.DataContext.Log = new DebugTextWriter();
                    string query = @"select a.UserID as UserID,  AcctgID as ClientID,  ManagerId , ClientName as ClientName, ContactPhone as MainPhone, TradingVolume as TradingVolume, CreationTime, ISNULL(b.isAutoOrder, 0) as isAutoOrder,  isChecked from dbo.Users a LEFT JOIN dbo.UserSettings b ON a.UserID = b.UserID LEFT JOIN dbo.orders c ON a.UserId = b.Userid LEFT JOIN dbo.OrderLines d ON c.OrderId = d.OrderId where ClientName like {0} and ContactPhone like {1} and d.InternalFranchName = {2} AND UserRole = 0";

                    return dc.DataContext.ExecuteQuery<BriefClientInfo>(query, "%"+clientName+"%", "%"+mainPhone+"%", SiteContext.Current.InternalFranchName).ToList();
                }
                return ret;
            }
        }

 public void ClearItems()
 {
     using (var context = new DCFactory<StoreDataContext>())
     {
         ClearItems(context.DataContext);
     }
 }

 public static HandyClientSetEntry GetDefaultHandySetEntry(int managerId)
 {
     using (var dc = new DCFactory<StoreDataContext>())
     {
         return _getHandySetEntries(dc.DataContext, managerId).SingleOrDefault(e => e.IsDefault);
     }
 }

        private void PopulateCatalogItems( DropDownList dropDownList )
        {
            using (var dc = new DCFactory<CmsDataContext>())
            {
                var groups = dc.DataContext.CatalogItems.GroupBy( c => c.ParentItemID ).ToDictionary( g => g.Key ?? 0 );

                if( groups.Count != 0 )
                {
                    var stack = new Stack<KeyValuePair<CatalogItem,int>>();

                    foreach( var item in groups[ 0 ].OrderByDescending( c=>c.CatalogItemPriority ) )
                        stack.Push( new KeyValuePair<CatalogItem, int>( item, 0 ) );

                    while( stack.Count != 0 )
                    {
                        var node = stack.Pop();
                        dropDownList.Items.Add(
                            new ListItem(
                                new string( '.', 3*node.Value ) + node.Key.CatalogItemName,
                                node.Key.CatalogItemID.ToString() )
                                );

                        if( groups.ContainsKey( node.Key.CatalogItemID ) )
                        {
                            foreach( var item in groups[ node.Key.CatalogItemID ].OrderByDescending( c => c.CatalogItemPriority ) )
                                stack.Push( new KeyValuePair<CatalogItem, int>( item, node.Value + 1 ) );
                        }
                    }

                }

            }
        }

 public static HandyClientSetEntry[] GetHandySetEntries(int managerId)
 {
     using (var dc = new DCFactory<StoreDataContext>())
     {
         return _getHandySetEntries(dc.DataContext, managerId).ToArray();
     }
 }