public List <Visit> GetVisitByID(int clientID)
{
var query = new List <Visit>();
using (var context = new VisitsDatabaseEntities())
{
query = context.Visits.Where(x => x.ClientID == clientID).ToList();
}
return(query);
}
public Client GetClientByDocument(string documento, int docType)
{
var query = new Client();
using (var context = new VisitsDatabaseEntities())
{
query = (from c in context.Clients
where c.Document == documento && c.DocumentType == docType
select c).FirstOrDefault();
}
return(query);
}
public List <DocumentType> GetDocumentTypes()
{
var query = new List <DocumentType>();
using (var context = new VisitsDatabaseEntities())
{
query = (from dt in context.DocumentTypes
orderby dt.DocumentTypeID ascending
select dt).ToList();
}
return(query);
}
public Seller GetSellerByDocument(string documento, int docType)
{
var query = new Seller();
using (var context = new VisitsDatabaseEntities())
{
query = (from s in context.Sellers
where s.Document == documento && s.DocumentType == docType
select s).FirstOrDefault();
}
return(query);
}
public List <Seller> GetSellers()
{
var query = new List <Seller>();
using (var context = new VisitsDatabaseEntities())
{
context.Database.Connection.Open();
query = (from s in context.Sellers
orderby s.SellerName ascending
select s).ToList();
}
return(query);
}
public Client SaveClient(Client client)
{
var cl = new Client();
using (var context = new VisitsDatabaseEntities())
{
var cc = context.Clients.FirstOrDefault(x => x.Document == client.Document && x.DocumentType == client.DocumentType);
if (cc == null)
{
var c = new Client();
c = new Client();
c.Document = client.Document;
c.DocumentType = client.DocumentType;
c.ClientName = client.ClientName;
c.ContactName = client.ContactName;
c.Email = client.Email;
c.Phone = client.Phone;
c.Address = client.Address;
c.Position = client.Position;
c.Consumption = client.Consumption;
c.Fabric = client.Fabric;
context.Clients.Add(c);
context.SaveChanges();
cl = c;
}
else
{
cc.ClientName = client.ClientName;
cc.ContactName = client.ContactName;
cc.Email = client.Email;
cc.Phone = client.Phone;
cc.Address = client.Address;
cc.Position = client.Position;
cc.Consumption = client.Consumption;
cc.Fabric = client.Fabric;
context.SaveChanges();
cl = cc;
}
}
return(cl);
}
public int SaveVisit(Visit saveVisit)
{
int id = 0;
using (var context = new VisitsDatabaseEntities())
{
var visit = new Visit();
visit = new Visit();
visit.ClientID = saveVisit.ClientID;
visit.SellerID = saveVisit.SellerID;
visit.Observations = saveVisit.Observations;
visit.VistDate = saveVisit.VistDate;
context.Visits.Add(visit);
context.SaveChanges();
id = visit.VisitsID;
}
return(id);
}