public ContractMark GetContractMarkByContract(int contractId)
{
using (var db = new LogistoDb())
{
return(db.ContractMarks.FirstOrDefault(w => w.ContractId == contractId));
}
}
public PriceKind GetPriceKind(int id)
{
using (var db = new LogistoDb())
{
return(db.PriceKinds.FirstOrDefault(w => w.ID == id));
}
}
public void DeletePricelist(int id)
{
using (var db = new LogistoDb())
{
db.Pricelists.Delete(w => w.ID == id);
}
}
public IEnumerable <CrmManager> GetAllManagers()
{
using (var db = new LogistoDb())
{
return(db.CrmManagers.ToList());
}
}
public int CreatePricelist(Pricelist entity)
{
using (var db = new LogistoDb())
{
return(Convert.ToInt32(db.InsertWithIdentity(entity)));
}
}
public IEnumerable <TemplatedDocument> GetTemplatedDocumentsByAccounting(int accountingId)
{
using (var db = new LogistoDb())
{
return(db.TemplatedDocuments.Where(w => w.AccountingId == accountingId).ToList());
}
}
public int GetDeclarationDocumentsCount(ListFilter filter)
{
using (var db = new LogistoDb())
{
var query = from d in db.Documents
from a in db.Accountings.Where(w => w.ID == d.AccountingId).DefaultIfEmpty()
from o in db.Orders.Where(w => w.ID == a.OrderId).DefaultIfEmpty()
from c in db.Contracts.Where(w => w.ID == o.ContractId).DefaultIfEmpty()
from l in db.Legals.Where(w => w.ID == c.LegalId).DefaultIfEmpty()
from o2 in db.Orders.Where(w => w.ID == d.OrderId).DefaultIfEmpty()
from w in db.Participants.Where(w => w.OrderId == o.ID).DefaultIfEmpty()
from w2 in db.Participants.Where(w => w.OrderId == o2.ID).DefaultIfEmpty()
where (w.UserId == filter.UserId ||
w2.UserId == filter.UserId) &&
d.DocumentTypeId == 20 // ДТ
select new { d, l };
// условия поиска
if (!string.IsNullOrWhiteSpace(filter.Context))
{
query = query.Where(w => w.d.Number.Contains(filter.Context) ||
w.l.DisplayName.Contains(filter.Context)
);
}
query = query.GroupBy(g => g.d.Number).Select(s => s.First());
return(query.Count());
}
}
public Request GetRequest(int id)
{
using (var db = new LogistoDb())
{
return(db.Requests.FirstOrDefault(w => w.ID == id));
}
}
public int CreateRequest(Request request)
{
using (var db = new LogistoDb())
{
return(Convert.ToInt32(db.InsertWithIdentity(request)));
}
}
public Contractor GetContractor(int id)
{
using (var db = new LogistoDb())
{
return(db.Contractors.FirstOrDefault(w => w.ID == id));
}
}
public ContractorEmployeeSettings GetContractorEmployeeSettings(int employeeId)
{
using (var db = new LogistoDb())
{
return(db.ContractorEmployeeSettings.FirstOrDefault(w => w.EmployeeId == employeeId));
}
}
public int CreateContractor(Contractor contractor)
{
using (var db = new LogistoDb())
{
return(Convert.ToInt32(db.InsertWithIdentity(contractor)));
}
}
public IEnumerable <ContractMarksHistory> GetContractMarksHistory(int contractId)
{
using (var db = new LogistoDb())
{
return(db.ContractMarksHistory.Where(w => w.ContractId == contractId).OrderBy(o => o.ID).ToList());
}
}
public int CreateContractMarksHistory(ContractMarksHistory entity)
{
using (var db = new LogistoDb())
{
return(Convert.ToInt32(db.InsertWithIdentity(entity)));
}
}
public TemplatedDocument GetTemplatedDocument(int fileId)
{
using (var db = new LogistoDb())
{
return(db.TemplatedDocuments.FirstOrDefault(w => w.ID == fileId));
}
}
public void DeleteRequest(int id)
{
using (var db = new LogistoDb())
{
db.Requests.Delete(w => w.ID == id);
}
}
public IEnumerable <TemplatedDocument> GetTemplatedDocuments(ListFilter filter)
{
using (var db = new LogistoDb())
{
var query = db.TemplatedDocuments.AsQueryable();
// условия поиска
if (!string.IsNullOrWhiteSpace(filter.Context))
{
query = query.Where(w => w.ReceivedNumber.Contains(filter.Context));
}
// TODO: sort
// пейджинг
if (filter.PageNumber > 0)
{
query = query.Skip(filter.PageNumber * filter.PageSize);
}
if (filter.PageSize > 0)
{
query = query.Take(filter.PageSize);
}
return(query.ToList());
}
}
public User GetUser(int id)
{
using (var db = new LogistoDb())
{
return(db.Users.First(w => w.ID == id));
}
}
public IEnumerable <TemplatedDocument> GetTemplatedDocumentsByOrder(int orderId)
{
using (var db = new LogistoDb())
{
return(db.TemplatedDocuments.Where(w => w.OrderId == orderId).ToList());
}
}
public string GetSetting(int userId, string key)
{
using (var db = new LogistoDb())
{
return(db.UserSettings.Where(w => w.UserId == userId && w.Key == key).Select(s => s.Value).FirstOrDefault());
}
}
public bool IsFirstCall(CrmCall call)
{
using (var db = new LogistoDb())
{
return(db.CrmCalls.Any(w => w.ID_COMPANY == call.ID_COMPANY && w.ID < call.ID));
}
}
public int CreateDocument(Document document)
{
using (var db = new LogistoDb())
{
return(Convert.ToInt32(db.InsertWithIdentity(document)));
}
}
public IEnumerable <CrmLegal> GetLegals(ListFilter filter)
{
using (var db = new LogistoDb())
{
var query = db.CrmLegals.AsQueryable();
// условия поиска
if (!string.IsNullOrWhiteSpace(filter.Context))
{
query = query.Where(w => w.CompanyName.Contains(filter.Context)
);
}
// TODO: sort
// пейджинг
if (filter.PageNumber > 0)
{
query = query.Skip(filter.PageNumber * filter.PageSize);
}
if (filter.PageSize > 0)
{
query = query.Take(filter.PageSize);
}
return(query.ToList());
}
}
public IEnumerable <Document> GetDocumentsByContract(int contractId)
{
using (var db = new LogistoDb())
{
return(db.Documents.Where(w => w.ContractId == contractId).ToList());
}
}
public void ClearPricelist(int id)
{
using (var db = new LogistoDb())
{
db.Prices.Delete(w => w.PricelistId == id);
}
}
public Document GetDocument(int documentId)
{
using (var db = new LogistoDb())
{
return(db.Documents.FirstOrDefault(w => w.ID == documentId));
}
}
public IEnumerable <PriceKind> GetPriceKinds(int pricelistId)
{
using (var db = new LogistoDb())
{
return(db.PriceKinds.Where(w => w.PricelistId == pricelistId).ToList());
}
}
public int CreateTemplatedDocument(TemplatedDocument file)
{
using (var db = new LogistoDb())
{
return(Convert.ToInt32(db.InsertWithIdentity(file)));
}
}
public int GetPricelistsCount(ListFilter filter)
{
using (var db = new LogistoDb())
{
var query = db.Pricelists.AsQueryable();
// условия поиска
if (!string.IsNullOrWhiteSpace(filter.Context))
{
query = query.Where(w => w.Name.Contains(filter.Context) ||
w.Comment.Contains(filter.Context));
}
if (filter.Type == "Standart")
{
query = query.Where(w => w.ContractId == null);
}
if (filter.Type == "NonStandart")
{
query = query.Where(w => w.ContractId != null);
}
return(query.Count());
}
}
public ContractMark GetContractMark(int id)
{
using (var db = new LogistoDb())
{
return(db.ContractMarks.First(w => w.ID == id));
}
}
