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); } }