public IActionResult GetInfo([FromBody] SearchPictureInfoInputModel model) { if (ModelState.IsValid) { var res = repo.SearchPictureInfo(model); if (res != null) { return(Ok(res)); } } return(BadRequest()); }
public SearchPictureInfoOutputModel SearchPictureInfo(SearchPictureInfoInputModel input) { var res = repo.SearchPictureInfo(input); if (res != null) { res.AdditionalImages = repo.GetAllAdditionalPictures(input); res.Prc_ID = input.Prc_ID; int difference = (DateTime.Now - Convert.ToDateTime(res.gdate)).Days; res.isActive = difference > 30 ? false : true; return(res); } return(null); }
public SearchPictureInfoOutputModel SearchPictureInfo(SearchPictureInfoInputModel input) { var res = new SearchPictureInfoOutputModel(); using (IDbConnection db = new SqlConnection(Global.Connection)) { res = db.Query <SearchPictureInfoOutputModel>("sp_SearchPictureInfo", new { Prc_ID = input.Prc_ID, Cust_ID = input.Cust_ID, AppCode = input.AppCode }, commandType: CommandType.StoredProcedure).FirstOrDefault(); } return(res); }
private List <Picture> GetAllAdditionalPictures(SearchPictureInfoInputModel input) { var list = new List <Picture>(); using (IDbConnection db = new SqlConnection(Global.Connection)) { list = db.Query <Picture>("sp_SearchGetAvitoAddImage", new { Prc_ID = input.Prc_ID, Cust_ID = input.Cust_ID, AppCode = input.AppCode }, commandType: CommandType.StoredProcedure).ToList(); } return(list); }