public ActionResult Edit(StallsCreateDTO req) { Response res = new Response(); if (ModelState.IsValid) { try { if (req.Id > 0) { res.Data = _stallsRepository.Update(req); } else { res.Data = _stallsRepository.Create(req); } } catch (Exception ex) { res.Message = ex.InnerException.Message; } } else { res.Data = false; res.Message = string.Join(",", ModelState .SelectMany(ms => ms.Value.Errors) .Select(e => e.ErrorMessage)); } return(Json(res, JsonRequestBehavior.AllowGet)); }
public bool Create(StallsCreateDTO req) { using (var db = new SqlSugarClient(Connection)) { bool result = true; R_Stall model = new R_Stall() { Name = req.Name, Description = req.Description, Print_Id = req.Print_Id }; if (db.Insert(model) == null) { result = false; } return(result); } }
public StallsCreateDTO GetModel(int id, int?billType = null) { using (var db = new SqlSugarClient(Connection)) { StallsCreateDTO result = null; if (id == 0) { return(result); } var data = db.Queryable <R_Stall>().InSingle(id); if (data != null) { result = new StallsCreateDTO() { Id = data.Id, Name = data.Name, Description = data.Description, Print_Id = data.Print_Id, }; if (billType.HasValue) { var cyxmDks = db.Queryable <R_ProjectStall>() .Where(p => p.R_Stall_Id == result.Id && p.BillType == billType.Value) .ToList(); result.ProjectStallList = cyxmDks; } else { var cyxmAllDks = db.Queryable <R_ProjectStall>() .Where(p => p.R_Stall_Id == result.Id) .ToList(); result.ProjectStallList = cyxmAllDks; } } return(result); } }
public bool Update(StallsCreateDTO req) { using (var db = new SqlSugarClient(Connection)) { bool result = true; R_Stall model = new R_Stall() { Id = req.Id, Name = req.Name, Description = req.Description }; //result = db.Update(model); result = db.Update <R_Stall>( new { Name = req.Name, Description = req.Description, Print_Id = req.Print_Id, R_Company_Id = req.R_Company_Id, }, x => x.Id == req.Id); return(result); } }