private IHttpActionResult doUpdate(Customers model) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } db.Entry(model).State = EntityState.Modified; try { db.SaveChanges(); } catch (DbUpdateConcurrencyException ex) { ReturnFail respFail = new ReturnFail { success = false, error_code = "500", message = ex.Message }; return(this.Json(respFail)); } ReturnSuccess respSucc = new ReturnSuccess { success = true }; return(this.Json(respSucc)); }
public void Returns_success_on_child_failure() { var returnSuccess = new ReturnSuccess(); returnSuccess.AddChild(A.TaskStub().WithUpdateStatus(TaskStatus.Failure).Build()); Assert.AreEqual(TaskStatus.Success, returnSuccess.Update()); }
public void Returns_continue_on_child_continue() { var returnSuccess = new ReturnSuccess(); returnSuccess.AddChild(A.TaskStub().WithUpdateStatus(TaskStatus.Continue).Build()); Assert.AreEqual(TaskStatus.Continue, returnSuccess.Update()); }
private IHttpActionResult doDelete(string idList) { ReturnFail respFail = new ReturnFail { success = false, error_code = "500", message = "驗證失敗" }; var dataSource = new List <Customers>(); try { if (idList.Contains(",")) { List <string> foo = idList.Split(',').ToList(); dataSource = db.Customers.Where(x => foo.Contains(x.CustomerID)).ToList(); } else { dataSource = db.Customers.Where(x => x.CustomerID == idList).ToList(); } if (dataSource.Count < 1) { return(this.Json(respFail)); } //與order 連動.有可能刪除失敗 db.Customers.RemoveRange(dataSource); db.SaveChanges(); } catch (Exception ex) { respFail.message = ex.Message; return(this.Json(respFail)); } ReturnSuccess respSucc = new ReturnSuccess { success = true }; return(this.Json(respSucc)); }
private IHttpActionResult doCreate(Customers model) { ReturnFail respFail = new ReturnFail { success = false, error_code = "500", message = "驗證失敗" }; if (!ModelState.IsValid) { return(this.Json(respFail)); } db.Customers.Add(model); try { db.SaveChanges(); } catch (DbUpdateException ex) { if (CustomersExists(model.CustomerID)) { return(this.Json(respFail)); } else { return(this.Json(respFail)); } } // CreatedAtRoute("DefaultApi", new { id = model.CustomerID }, model); ReturnSuccess respSucc = new ReturnSuccess { success = true }; return(this.Json(respSucc)); }
private IHttpActionResult queryData(SearchModel model, int rtnType = 0) { if (model == null) { model = new SearchModel() { limit = 10, offset = 0, orderby = "asc", sortby = "CustomerID" }; } // query case if (!model.offset.HasValue) { model.offset = 0; } if (!model.limit.HasValue) { model.limit = 10; } if (string.IsNullOrEmpty(model.orderby)) { model.orderby = "asc"; } if (string.IsNullOrEmpty(model.sortby)) { model.sortby = "CustomerID"; } var data = db.Customers.AsQueryable().OrderBy(o => model.orderby).SortBy(model.sortby); //通用寫法 if (!string.IsNullOrEmpty(model.name)) { data = data.Where(x => x.CompanyName == model.name); } //查詢條件包在 JSON filters 中 if (!string.IsNullOrEmpty(model.filters)) { Customers qryCase = JsonConvert.DeserializeObject <Customers>(model.filters); // 多個欄位 if (!string.IsNullOrEmpty(qryCase.CustomerID)) { data = data.Where(x => x.CustomerID == qryCase.CustomerID); } if (!string.IsNullOrEmpty(qryCase.CompanyName)) { data = data.Where(x => x.CompanyName == qryCase.CompanyName); } if (!string.IsNullOrEmpty(qryCase.City)) { data = data.Where(x => x.City == qryCase.City); } if (!string.IsNullOrEmpty(qryCase.Phone)) { data = data.Where(x => x.Phone == qryCase.Phone); } } var dataSource = data.Skip(model.offset.Value).Take(model.limit.Value).ToList(); if (dataSource.Count > 0) { if (rtnType == 1) { return(this.Json(dataSource)); } else { ReturnSuccess respSucc = new ReturnSuccess { success = true, totalRowCount = data.Count(), totalPage = (int)Math.Ceiling((double)data.Count() / model.limit.Value), result = dataSource }; return(this.Json(respSucc)); } } else { if (rtnType == 1) { return(null); } ReturnFail respFail = new ReturnFail { success = false, error_code = "404", message = "查無資料" }; return(this.Json(respFail)); } }