public bool RespondQuota(int quotaId, string message)
{
try
{
using (var da = new CourierEntities())
{
var chk = da.Responses.Where(a => a.QuotaID == quotaId).SingleOrDefault();
if (chk == null)
{
da.Responses.Add(new Response()
{
QuotaID = quotaId,
Message = message
});
}
else
{
//update quota
chk.Message = message;
da.Entry(chk).State = System.Data.Entity.EntityState.Modified;
}
da.SaveChanges();
return(true);
}
}
catch (Exception ex)
{
returnMsg = ex.Message;
return(false);
}
}
public bool UpdateSource(int orderID, string address, decimal lat, decimal log)
{
try
{
using (var da = new CourierEntities())
{
//check if orderid exit
if (Orders.CheckOrder(orderID))
{
//ensure no dublicate of an id is found
var CheckOrderID = da.Sources.Where(a => a.OrderID == orderID).SingleOrDefault();
if (CheckOrderID != null)
{
//update track entity with order id
CheckOrderID.address = address;
CheckOrderID.Latitude = lat;
CheckOrderID.Logitude = log;
da.Entry(CheckOrderID).State = System.Data.Entity.EntityState.Modified;
da.SaveChanges();
return(true);
}
}
}
return(false);
}
catch (Exception ex)
{
returnMsg = "This Order has been created you can only update it. " + ex;
value = 1;
return(false);
}
}
//try
// {
// }
// catch (Exception ex)
// {
// returnMsg = ex.Message;
// return false;
// }
public bool createReceipt(int orderID, decimal Amount)
{
try
{
using (var da = new CourierEntities())
{
var chKRec = da.Receipts.Where(a => a.OrderID == orderID).SingleOrDefault();
if (chKRec == null)
{
// add new record
da.Receipts.Add(new Receipt()
{
Amount = Amount,
OrderID = orderID,
DateCreated = DateTime.UtcNow
});
}
else
{
chKRec.Amount = Amount;
da.Entry(chKRec).State = System.Data.Entity.EntityState.Modified;
}
da.SaveChanges();
return(true);
}
}
catch (Exception ex)
{
returnMsg = ex.Message;
return(false);
}
}
public bool UpdateLocation(int LocationID, string currentLocation)
{
try
{
using (var da = new CourierEntities())
{
var query = da.Locations.Find(LocationID);
if (query != null)
{
query.CurrentLocation = currentLocation;
da.Entry(query).State = System.Data.Entity.EntityState.Modified;
da.SaveChanges();
return(true);
}
else
{
returnMsg = "Unable to update record, Record not Found";
return(false);
}
}
}
catch (Exception ex)
{
returnMsg = ex.Message;
return(false);
}
}
public bool EditOrder(int OrderID, string packageName, string des, string weight, string height)
{
try
{
using (var da = new CourierEntities())
{
var query = da.Orders.Find(OrderID);
if (query != null)
{
query.Packagename = packageName;
query.Description = des;
query.height = height;
query.weight = weight;
}
da.Entry(query).State = System.Data.Entity.EntityState.Modified;
da.SaveChanges();
return(true);
}
}
catch (Exception ex)
{
returnMsg = ex.Message;
return(false);
}
}
public bool AddCurrentLocation(int orderID, string address, decimal lat, decimal log)
{
try
{
using (var da = new CourierEntities())
{
//check if orderid exit
if (Orders.CheckOrder(orderID))
{
//ensure no dublicate of an id is found
var CheckOrderID = da.CurrentLocations.Where(a => a.OrderID == orderID).SingleOrDefault();
if (CheckOrderID == null)
{
// add new record
var curr = new Courier.Models.DbModel.CurrentLocation
{
Address = address,
Latitude = lat,
Logitude = log,
OrderID = orderID,
};
da.CurrentLocations.Add(curr);
//update track entity with order id
da.SaveChanges();
//update track entity with order id
var tra = da.Tracks.Where(a => a.OrderID == orderID).SingleOrDefault();
tra.CurrentLocationID = curr.CurrentLocationID;
da.Entry(tra).State = System.Data.Entity.EntityState.Modified;
da.SaveChanges();
return(true);
}
else
{
//Update Current Location
UpdateCurrentLocation(orderID, address, lat, log);
return(true);
}
}
}
return(false);
}
catch (Exception ex)
{
returnMsg = "This Order has been created you can only update it. ";
value = 1;
return(false);
}
}
public bool UpdateQuotaReply(int quotaId, string message)
{
try
{
using (var da = new CourierEntities())
{
var q = da.Responses.Where(a => a.QuotaID == quotaId).SingleOrDefault();
q.Message = message;
da.Entry(q).State = System.Data.Entity.EntityState.Modified;
da.SaveChanges();
return(true);
}
}
catch (Exception ex)
{
returnMsg = ex.Message;
return(false);
}
}
public bool UpdateReceipt(int ReceiptID, decimal amount)
{
try
{
using (var da = new CourierEntities())
{
var query = (from p in da.Receipts where p.ReceiptID == ReceiptID select p).SingleOrDefault();
if (query != null)
{
query.Amount = amount;
}
da.Entry(query).State = System.Data.Entity.EntityState.Modified;
da.SaveChanges();
return(true);
}
}
catch (Exception ex)
{
returnMsg = ex.Message;
return(false);
}
}
