public RestApiResult GetWagonByID(long id) { WagonSettlement wagonSettlement = ClarityDB.Instance.WagonSettlements.FirstOrDefault(x => x.ID == id); if (wagonSettlement == null) { return(new RestApiResult { StatusCode = HttpStatusCode.NotFound }); } return(new RestApiResult { StatusCode = HttpStatusCode.OK, Json = wagonSettlement.ToJson() }); }
public RestApiResult Update(long id, JObject json) { WagonSettlement wagonSettlement = ClarityDB.Instance.WagonSettlements.FirstOrDefault(x => x.ID == id); if (wagonSettlement == null) { return(new RestApiResult { StatusCode = HttpStatusCode.NotFound }); } wagonSettlement.ApplyJson(json); ClarityDB.Instance.SaveChanges(); return(new RestApiResult { StatusCode = HttpStatusCode.OK, Json = json }); }
public RestApiResult Delete(long id) { WagonSettlement wagonSettlement = ClarityDB.Instance.WagonSettlements.FirstOrDefault(x => x.ID == id); if (wagonSettlement == null) { return(new RestApiResult { StatusCode = HttpStatusCode.NotFound }); } ClarityDB.Instance.WagonSettlements.Remove(wagonSettlement); ClarityDB.Instance.SaveChanges(); return(new RestApiResult { StatusCode = HttpStatusCode.OK, Json = wagonSettlement.ToJson() }); }
public RestApiResult Create(JObject json) { if (json == null) { return(new RestApiResult { StatusCode = HttpStatusCode.BadRequest }); } WagonSettlement wagonSettlement = WagonSettlement.FromJson(json); wagonSettlement.CreatedDate = DateTime.Now; ClarityDB.Instance.WagonSettlements.Add(wagonSettlement); ClarityDB.Instance.SaveChanges(); return(new RestApiResult { StatusCode = HttpStatusCode.OK }); }
public RestApiResult Update(long id, JObject json) { WagonSettlement wagonSettlement = ClarityDB.Instance.WagonSettlements.FirstOrDefault(x => x.ID == id); if (wagonSettlement == null) { return(new RestApiResult { StatusCode = HttpStatusCode.NotFound }); } wagonSettlement.ApplyJson(json); if (wagonSettlement.PaymentRemain == 0) { wagonSettlement.PaymentStatus = "Không Nợ"; } var newPayment = json.Value <long>("newPayment"); if (newPayment > 0 && !String.IsNullOrEmpty(wagonSettlement.PaymentDate)) { wagonSettlement.Payment += newPayment; wagonSettlement.PaymentRemain -= newPayment; Payment payment = new Payment(); payment.PaymentDate = wagonSettlement.PaymentDate; payment.PaymentAmount = newPayment; payment.WagonSettlementCode = wagonSettlement.Code; payment.CreatedDate = DateTime.Now; ClarityDB.Instance.Payments.Add(payment); Customer customer = ClarityDB.Instance.Customers.FirstOrDefault(x => x.ID == wagonSettlement.CustomerID); customer.NeedUpdatePayment = true; } ClarityDB.Instance.SaveChanges(); return(new RestApiResult { StatusCode = HttpStatusCode.OK, Json = json }); }
private void AddWagonSettlementsFromJson(long wagonID, JObject json) { Wagon wagon = ClarityDB.Instance.Wagons.FirstOrDefault(x => x.ID == wagonID); var wagonSettlementJsons = json.Value <JArray>("wagonSettlements"); if (wagonSettlementJsons != null) { foreach (JObject wagonSettlementJson in wagonSettlementJsons) { WagonSettlement wagonSettlement = WagonSettlement.FromJson(wagonSettlementJson); wagonSettlement.ID = 0; // prevent wrong order of WagonSettlements in Wagon wagonSettlement.CreatedDate = DateTime.Now; wagonSettlement.PaymentDate = wagon.PaymentDate; wagonSettlement.PaymentPlace = wagon.PaymentPlace; wagonSettlement.WagonID = wagonID; wagonSettlement.Code = wagonSettlement.WagonID + "_" + wagonSettlement.CustomerID; wagon.WagonSetlements.Add(wagonSettlement); } ClarityDB.Instance.SaveChanges(); } }
private void AddWagonSettlementsFromJson(long wagonID, JObject json) { Wagon wagon = ClarityDB.Instance.Wagons.FirstOrDefault(x => x.ID == wagonID); var wagonSettlementJsons = json.Value <JArray>("wagonSettlements"); if (wagonSettlementJsons != null) { foreach (JObject wagonSettlementJson in wagonSettlementJsons) { WagonSettlement wagonSettlement = WagonSettlement.FromJson(wagonSettlementJson); wagonSettlement.CreatedDate = DateTime.Now; wagonSettlement.WagonID = wagonID; wagonSettlement.Code = wagonSettlement.WagonCode + "_" + wagonSettlement.CustomerOrderID; wagon.WagonSetlements.Add(wagonSettlement); Customer customer = ClarityDB.Instance.Customers.FirstOrDefault(x => x.ID == wagonSettlement.CustomerID); customer.NeedUpdatePayment = true; } ClarityDB.Instance.SaveChanges(); } }