public IExternStorage CreateExternStorage(string name, string companyName, string street, string number, string zipCode, string city, string companyId, string taxId)
{
GetLock();
Storage storage;
using (StoreKeeperDataContext dataContext = new StoreKeeperDataContext())
{
storage = new Storage();
storage.Id = ObjectId.NewId();
storage.Name = name;
storage.IsExtern = true;
storage.CompanyName = companyName;
storage.Street = street ?? String.Empty;
storage.Number = number;
storage.ZipCode = zipCode;
storage.City = city;
storage.CompanyId = companyId ?? String.Empty;
storage.TaxId = taxId ?? String.Empty;
dataContext.Storages.Add(storage);
dataContext.SaveChanges();
}
ExternStorage externStorage = new ExternStorage(new ExternStorageDataProxy(this, storage.Id));
_externStorages.Add(externStorage);
return(externStorage);
}
public void RefreshProductOrdersPriorities(int oldPriority, int newPriority, ObjectId changedOrderId)
{
int value = 1;
if (newPriority > oldPriority)
{
value = -1;
}
int min = Math.Min(oldPriority, newPriority);
int max = Math.Max(oldPriority, newPriority);
using (StoreKeeperDataContext dataContext = new StoreKeeperDataContext())
{
foreach (ProductArticleOrder order in dataContext.ProductArticleOrders.Where(o => o.Priority >= min && o.Priority <= max))
{
if (order.Id != (Guid)changedOrderId)
{
order.Priority += value;
}
}
dataContext.SaveChanges();
}
}
public void SetStorageMappingAsync(ObjectId productId, ObjectId storageId, Action reloadAction)
{
Task.Factory.StartNew(() =>
{
GetLock();
_longOperationHandler.Start("SettingStorageOperation");
Guid articleId = productId;
using (StoreKeeperDataContext dataContext = new StoreKeeperDataContext())
{
ProductArticle productArticle = dataContext.ProductArticles.FirstOrDefault(pa => pa.ArticleId == articleId);
if (productArticle == null)
{
throw new ProductArticleNotFoundException(GetType(), productId);
}
foreach (
ProductArticleItem item in
productArticle.ProductArticleItems.Where(
i => i.Article.Type == (int)ArticleType.Card && !i.SkipCalculation))
{
item.StorageId = storageId;
}
dataContext.SaveChanges();
}
_longOperationHandler.End(new LongOperationResult
{
CustomAction = reloadAction
});
});
}
private void ChangeValue(Action <ProductArticleOrder> changeAction)
{
DataChange.GetLock();
using (StoreKeeperDataContext dataContext = new StoreKeeperDataContext())
{
Guid id = OrderId;
ProductArticleOrder order = dataContext.ProductArticleOrders.Find(id);
changeAction(order);
dataContext.SaveChanges();
}
}
private void ChangeValue(Action <ProductArticleItem> changeAction)
{
DataChange.GetLock();
using (StoreKeeperDataContext dataContext = new StoreKeeperDataContext())
{
Guid id = ArticleItemId;
ProductArticleItem articleItem = dataContext.ProductArticleItems.Find(id);
changeAction(articleItem);
dataContext.SaveChanges();
}
}
public bool RemoveExternStorage(IExternStorage externStorage)
{
Guid storageId = externStorage.StorageId;
using (StoreKeeperDataContext dataContext = new StoreKeeperDataContext())
{
Storage storage = dataContext.Storages.FirstOrDefault(es => es.Id == storageId);
if (storage != null)
{
dataContext.Storages.Remove(storage);
_externStorages.Remove(externStorage);
dataContext.SaveChanges();
return(true);
}
}
return(false);
}
internal void Save()
{
using (StoreKeeperDataContext dataContext = new StoreKeeperDataContext())
{
dataContext.SetStringConstant("DN_Parlor", Parlor);
dataContext.SetStringConstant("DN_Street", Street);
dataContext.SetStringConstant("DN_Number", Number);
dataContext.SetStringConstant("DN_Zip", ZipCode);
dataContext.SetStringConstant("DN_City", City);
dataContext.SetStringConstant("DN_Phone", Phone);
dataContext.SetStringConstant("DN_CellPhone", CellPhone);
dataContext.SetStringConstant("DN_Email", Email);
dataContext.SetStringConstant("DN_Web", Web);
dataContext.SaveChanges();
}
}
public void IndexDatabase(bool filePrepared)
{
AccountingDataSync globalDataSync = ProcessAccountingData(filePrepared, false);
using (StoreKeeperDataContext context = new StoreKeeperDataContext())
{
SqlParameter userIdParam = new SqlParameter("@UserId", new Guid("F2024637-2251-479A-8ED9-940E4354F37B"));
SqlParameter unlockParam = new SqlParameter("@Unlock", SqlDbType.Bit)
{
Value = 0
};
context.Database.ExecuteSqlCommand("exec LockDatabase @UserId, @Unlock", userIdParam, unlockParam);
context.SaveLoadedData(globalDataSync);
context.LastUpdate = DateTime.Now;
context.ResponsibleUser = "******";
context.SaveChanges();
}
}
internal void Save()
{
DataChange.GetLock();
using (StoreKeeperDataContext dataContext = new StoreKeeperDataContext())
{
Guid id = StorageId;
Storage storage = dataContext.Storages.Find(id);
storage.Name = Name;
storage.Prefix = id != Constants.CentralStorageId ? Prefix : null;
storage.IsExtern = IsExtern;
storage.CompanyName = CompanyName;
storage.Street = Street;
storage.Number = Number;
storage.ZipCode = ZipCode;
storage.City = City;
storage.CompanyId = CompanyId;
storage.TaxId = TaxId;
dataContext.SaveChanges();
}
}
public IProductOrder CreateProductOrder(string code, double count = 0)
{
GetLock();
ProductArticleOrder order;
using (StoreKeeperDataContext dataContext = new StoreKeeperDataContext())
{
Article article = dataContext.Articles.FirstOrDefault(a => a.Code.ToUpper() == code.ToUpper());
if (article == null || (article.ArticleType != ArticleType.Product))
{
throw new ProductArticleNotFoundException(GetType(), code);
}
ProductArticle productArticle =
dataContext.ProductArticles.FirstOrDefault(pa => pa.ArticleId == article.Id);
if (productArticle == null)
{
throw new ProductArticleNotFoundException(GetType(), code);
}
order = new ProductArticleOrder();
order.Id = ObjectId.NewId();
order.ProductArticleId = productArticle.Id;
order.Count = count;
order.Priority = dataContext.ProductArticleOrders.Count() + 1;
order.UserId = UserContext.UserId;
dataContext.ProductArticleOrders.Add(order);
dataContext.SaveChanges();
}
IProductOrder productOrder = new ProductOrder(new ProductOrderDataProxy(this, order.Id));
_productOrders.Add(productOrder);
RequestForCalculation();
return(productOrder);
}
