public List<PushPinModel> GetAddressList()
{
FreeQ_DBEntities context = new FreeQ_DBEntities();
FreeQ_WS.Classes.FreeQ_DataContext db = new Classes.FreeQ_DataContext();
List<PushPinModel> ppl = new List<PushPinModel>();
geoloc l;
List<string> la = (from a in context.Queue.Where("1 == 1")
where a.Queue_Address.Length != 0
select a.Queue_Address).ToList<string>();
foreach (string a in la)
{
l = this.GeocodeAddress(a);
//add the pushpin info
ppl.Add(new PushPinModel
{
Description = a,
Latitude = l.lat,
Longitude = l.lon,
Title = ""
});
}
db.Dispose();
context.Dispose();
return ppl;
}
public Classes.Queue CreateQueue(string queueName, long firstTicketNumber, string physicalAddress, bool isActive, Guid userID)
{
if (String.IsNullOrEmpty(queueName)) throw new ArgumentException("Value cannot be null or empty.", "queueName");
if (firstTicketNumber <= 0) throw new ArgumentException("Value can't be <= to 0.", "firstTicketNumber");
FreeQ_WS.Classes.FreeQ_DataContext db = new Classes.FreeQ_DataContext();
Classes.Queue newQueue = new Classes.Queue();
newQueue.Queue_Address = physicalAddress;
newQueue.Queue_CreationDate = DateTime.Now;
newQueue.Queue_IsActive = isActive;
newQueue.Queue_Name = queueName;
newQueue.Queue_Current_Ticket_ID = null;
newQueue.Queue_Next_Increment = firstTicketNumber;
newQueue.Queue_UserID = userID;
newQueue.Queue_ID = System.Guid.NewGuid();
db.Queues.InsertOnSubmit(newQueue);
db.SubmitChanges();
return newQueue;
}
public bool UpdateQueue(Guid queueID, string queueName, long nextTicketNumber, string physicalAddress, bool isActive)
{
if (String.IsNullOrEmpty(queueName)) throw new ArgumentException("Value cannot be null or empty.", "userName");
if (nextTicketNumber <= 0) throw new ArgumentException("Value can't be <= to 0.", "nextTicketNumber");
FreeQ_WS.Classes.FreeQ_DataContext db = new Classes.FreeQ_DataContext();
try
{
Classes.Queue queue = db.Queues.Single<Classes.Queue>(p => p.Queue_ID == queueID);
queue.Queue_Name = queueName;
queue.Queue_Next_Increment = nextTicketNumber;
queue.Queue_Address = physicalAddress;
queue.Queue_IsActive = isActive;
db.SubmitChanges();
return true;
}
catch
{
return false;
}
}
public List<Classes.Queue> GetQueues(Guid userID)
{
FreeQ_WS.Classes.FreeQ_DataContext db = new Classes.FreeQ_DataContext();
List<Classes.Queue> queues = new List<Classes.Queue>();
return (from q in db.Queues
where q.Queue_UserID == userID
select q).ToList<Classes.Queue>();
}
public Classes.Queue GetQueue(Guid queueID)
{
Classes.Queue queue = null;
try
{
FreeQ_WS.Classes.FreeQ_DataContext db = new Classes.FreeQ_DataContext();
queue = (from q in db.Queues
where q.Queue_ID == queueID
select q).First<Classes.Queue>();
}
catch { }
return queue;
}
