public void Add(int userId, ExpenseDTO expense)
{
var elementToAdd = new Expense(expense.ExpenseDate, expense.Cost, expense.ExpenseCause, userId);
db.Expenses.InsertOnSubmit(elementToAdd);
db.SubmitChanges();
}
public void Add(AccountUserDTO accountUser)
{
var element = new AccountUser(accountUser.Name, accountUser.Surname, accountUser.PositionRole, accountUser.PhoneNumber, accountUser.WorkPlace.Id.Value, accountUser.Password);
element.Expenses = new EntitySet <Expense>();
db.AccountUsers.InsertOnSubmit(element);
db.SubmitChanges();
}
public void Add(CategoryDTO category)
{
Category categoryToinsert = new Category()
{
Code = category.Code,
Name = category.Name
};
db.Categories.InsertOnSubmit(categoryToinsert);
db.SubmitChanges();
}
public void Add(SupplierDTO supplier)
{
var supplierToAdd = new Supplier()
{
Id = supplier.Id,
Name = supplier.Name,
SupplierInfo = supplier.SupplierInfo,
};
db.Suppliers.InsertOnSubmit(supplierToAdd);
db.SubmitChanges();
}
public void Add(InnerMovementDTO dto)
{
var elementToAdd = new InnerMovement(dto.Id, dto.MoveDate, dto.ProductId, dto.Quantity, dto.FromWorkPlaceId,
dto.ToWorkPlaceId)
{
CreatedDate = DateTime.Now.Date,
GroupId = GetRandomGroupId(),
TotalPrice = dto.TotalPrice,
};
db.InnerMovements.InsertOnSubmit(elementToAdd);
db.SubmitChanges();
}
public void Add(DailyBalanceDTO dto)
{
var dailyBalance = new DailyBalance()
{
BalanceDate = dto.BalanceDate.Date,
ProductId = dto.Product.Id.Value,
Quantity = dto.Quantity,
WorkPlaceId = dto.WorkPlaceId,
};
db.DailyBalances.InsertOnSubmit(dailyBalance);
db.SubmitChanges();
}
public void Add(DebtCoverDTO element)
{
var cover = new DebtCover()
{
OrderId = element.OrderId,
CoverDate = element.CoverDate,
PaymentByCard = element.PaymentByCard,
PaymentByTransfer = element.PaymentByTransfer,
PaymentByCash = element.PaymentByCash
};
db.DebtCovers.InsertOnSubmit(cover);
db.SubmitChanges();
}
public void Add(DebtorCreditorDTO dto)
{
var debtorCreditor = new DebtorCreditor()
{
ClientId = dto.ClientId.Value,
Amount = dto.Amount,
CreatedDate = dto.CreatedDate,
UpdatedDate = dto.UpdatedDate,
isDebtor = dto.IsDebtor
};
db.DebtorCreditors.InsertOnSubmit(debtorCreditor);
db.SubmitChanges();
}
public void Add(SaleDTO sale)
{
var element = new Sale(sale.ProductId)
{
ProductName = sale.ProductName,
ProductPrice = sale.ProductPrice,
SalesPrice = sale.SalesPrice,
Quantity = sale.Quantity,
OrderId = sale.OrderId,
CurrencyRate = sale.CurrencyRate
};
db.Sales.InsertOnSubmit(element);
db.SubmitChanges();
}
public void Add(ProductDTO product)
{
var productToAdd = new Product(product.Category.Id, product.Supplier.Id)
{
Code = product.Code,
Name = product.Name,
Price = product.Price,
Currency = product.Currency,
MeasurementUnit = product.MeasurementUnit,
BoxedNumber = product.BoxedNumber
};
db.Products.InsertOnSubmit(productToAdd);
db.SubmitChanges();
}
public void AddIncome(IncomeDTO dto)
{
var income = new Income()
{
UserId = dto.UserId,
FromWorkPlaceId = dto.FromWorkplaceId,
ToWorkplaceId = dto.FromWorkplaceId,
CreatedDate = DateTime.Now,
UpdatedDate = DateTime.Now,
IsProductStock = dto.IsProductStock,
IncomeProducts = new EntitySet <IncomeProduct>()
};
db.Incomes.InsertOnSubmit(income);
db.SubmitChanges();
AddIncomeProducts(income.Id, dto.IncomeProducts);
}
public void Add(ProductStockDTO stock)
{
var stockToUpdate = (from p in db.ProductStocks where p.ProductId == stock.ProductId && p.WorkPlaceId == stock.WorkPlaceId && p.IsDeleted == false select p).FirstOrDefault();
if (stockToUpdate != null)
{
stock.Id = stockToUpdate.Id;
stock.Quantity += stockToUpdate.Quantity;
Update(stock);
}
else
{
var productToAdd = new ProductStock(stock.ProductId, stock.WorkPlaceId);
productToAdd.Quantity = stock.Quantity;
db.ProductStocks.InsertOnSubmit(productToAdd);
db.SubmitChanges();
}
}
public void Add(ReturnedSaleDTO c, int workPlaceId)
{
var element = new ReturnedSale()
{
Id = c.Id,
SaleId = c.SaleId,
ProductId = c.ProductId,
Cause = c.Cause,
DefectedQuantity = c.DefectedQuantity,
Quantity = c.Quantity,
ReturnDate = c.ReturnDate,
ReturnedPrice = c.ReturnedPrice,
ReturnedMoney = c.ReturnedMoney,
WorkplaceId = workPlaceId,
};
db.ReturnedSales.InsertOnSubmit(element);
db.SubmitChanges();
}
public void Add(ClientDTO client)
{
var element = new Client()
{
Name = client.Name,
Address = client.Address,
Phone = client.Phone,
PaymentAccount = client.PaymentAccount,
BankDetails = client.BankDetails,
City = client.City,
MFO = client.MFO,
INN = client.INN,
OKONX = client.OKONX,
NickName = client.NickName,
WorkPlaceId = client.WorkPlaceId,
};
db.Clients.InsertOnSubmit(element);
db.SubmitChanges();
}
public void Add(OrderDTO order)
{
var element = new ClientOrder(order.SalerId, order.ClientId)
{
TransactinoId = order.TransactionId,
OrderDate = order.OrderDate,
PaymentByCard = order.PaymentByCard,
PaymentByTransfer = order.PaymentByTransfer,
PaymentByCash = order.PaymentByCash,
IsDebt = order.IsDebt,
ClientRepresentitive = order.ClientRepresentitive,
OverallPrice = order.OverallPrice
};
element.DebtCovers = new EntitySet <DebtCover>();
element.Sales = new EntitySet <Sale>();
db.ClientOrders.InsertOnSubmit(element);
db.SubmitChanges();
new SaleBL().AddRange(order.Sales, element.Id);
}
public void Add(CompanyInfoDTO c)
{
var compInfo = new CompanyInfo()
{
Accountant = c.Accountant,
Address = c.Address,
BankDetails = c.BankDetails,
City = c.City,
Director = c.Director,
INN = c.INN,
LegalName = c.LegalName,
Id = c.Id,
MFO = c.MFO,
PaymentAccount = c.PaymentAccount,
Phone = c.Phone,
OKONX = c.OKONX
};
db.CompanyInfos.InsertOnSubmit(compInfo);
db.SubmitChanges();
}
public void Add(WorkPlaceDTO c)
{
var element = new WorkPlace()
{
Name = c.Name,
Location = c.Location,
Accountant = c.Accountant,
Address = c.Address,
BankDetails = c.BankDetails,
City = c.City,
Director = c.Director,
INN = c.INN,
LegalName = c.LegalName,
Id = c.Id,
MFO = c.MFO,
PaymentAccount = c.PaymentAccount,
Phone = c.Phone,
OKONX = c.OKONX
};
element.ProductStock = new EntitySet <ProductStock>();
db.WorkPlaces.InsertOnSubmit(element);
db.SubmitChanges();
}
