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();
}
}
public static UserMaintEntry GetEntry(Guid entryUid)
{
using (var dc = new DCFactory<StoreDataContext>())
{
return _getEntries(dc.DataContext, entryUid).SingleOrDefault();
}
}
public static SeoShortLink GetSeoShortLink( int id )
{
using (var dc = new DCFactory<CmsDataContext>())
{
return _getSeoShortLink( dc.DataContext, id );
}
}
public static void SaveClientAlertConfig(
string clientId,
int hourOfPeriod,
string statusIds)
{
using (var dc = new DCFactory<StoreDataContext>())
{
var alertConfig = _getAlertConfigByClientId(dc.DataContext, clientId).SingleOrDefault();
if (alertConfig != null)
{
alertConfig.HourOfPeriod = hourOfPeriod;
alertConfig.StatusIDs = statusIds;
}
else
{
alertConfig = new ClientAlertConfig
{
ClientID = clientId,
HourOfPeriod = hourOfPeriod,
StatusIDs = statusIds
};
dc.DataContext.ClientAlertConfigs.InsertOnSubmit(alertConfig);
}
dc.DataContext.SubmitChanges();
}
}
public static int GetDiscountSparePartCount(string brand)
{
using (var dc = new DCFactory<StoreDataContext>())
{
return dc.DataContext.DiscountSpareParts.Where(d => d.Manufacturer == brand).Count();
}
}
public static Reclamation GetReclamation( string clientId, int reclamationId )
{
using (var dc = new DCFactory<StoreDataContext>())
{
return dc.DataContext.Reclamations.Single( r => r.ClientID == clientId && r.ReclamationID == reclamationId );
}
}
public static SeoTecDocTextTemplate[] GetTextTemplates()
{
using (var dc = new DCFactory<CmsDataContext>())
{
return _getSeoTecDocTextTemplates( dc.DataContext ).ToArray();
}
}
protected void _repeater_ItemCommand( object source, RepeaterCommandEventArgs e )
{
try
{
if( e.CommandName == "Delete" )
{
using (var dc = new DCFactory<CmsDataContext>())
{
int id = Convert.ToInt32( e.CommandArgument );
CatalogItem item = dc.DataContext.CatalogItems.Where( c => c.CatalogItemID == id ).SingleOrDefault();
if( item != null )
dc.DataContext.CatalogItems.DeleteOnSubmit( item );
dc.DataContext.SubmitChanges();
Response.Redirect( table.ListActionPath, true );
}
}
}
catch( ThreadAbortException )
{
throw;
}
catch( Exception ex )
{
_errorLabel.Text = ex.Message;
}
}
public static VinRequest GetRequest(int requestId)
{
using (var ctx = new DCFactory<StoreDataContext>())
{
return _getVinRequest(ctx.DataContext, requestId).Single();
}
}
public static void SaveProfile(
int userId,
IDictionary<string, object> propValues,
DateTime activityTime)
{
using (var dc = new DCFactory<StoreDataContext>())
{
var entry = _getEntriesByUserId(dc.DataContext, userId).SingleOrDefault();
if (entry != null)
{
entry.NameObjectMap = propValues;
entry.LastActivityTime = activityTime;
entry.LastUpdateTime = DateTime.Now;
}
else
{
entry = new UserProfileEntry
{
UserID = userId,
NameObjectMap = propValues,
LastActivityTime = activityTime,
LastUpdateTime = DateTime.Now
};
dc.DataContext.UserProfileEntries.InsertOnSubmit(entry);
}
dc.DataContext.SubmitChanges();
}
}
public static FeedbackRecipient GetFeedbackRecipient(int id)
{
using(var dc = new DCFactory<CmsDataContext>())
{
return _getFeedbackRecipient(dc.DataContext, id);
}
}
