public JsonResult Action(AccommodationsActionModel formModel) { bool result = false; var picsIds = string.IsNullOrEmpty(formModel.PictureIds) ? new List <int>() : formModel.PictureIds.Split(',').Select(int.Parse).ToList(); var pictures = DBServices.GetPicturesByIds(picsIds); if (formModel.Id == 0) //create { //make instance of accommodation then fill it with the new data Accommodation accommodation = new Accommodation(); accommodation.Name = formModel.Name; accommodation.Description = formModel.Description; accommodation.AccommodationPackageId = formModel.AccommodationPackageId; accommodation.AccommodationPictures = new List <AccommodationPicture>(); accommodation.AccommodationPictures.AddRange(pictures.Select(p => new AccommodationPicture() { PictureId = p.Id })); result = AServices.SaveAccommodation(accommodation); } else //edit { //get accommodation from db then modified it var accommodation = AServices.GetAccommodationById(formModel.Id); accommodation.Name = formModel.Name; accommodation.Description = formModel.Description; accommodation.AccommodationPackageId = formModel.AccommodationPackageId; //delete existing accommodation pics to add new one after editing AServices.DeleteAccommodationPictures(accommodation.Id); accommodation.AccommodationPictures.AddRange(pictures.Select(p => new AccommodationPicture() { PictureId = p.Id, AccommodationId = accommodation.Id })); result = AServices.UpdateAccommodation(accommodation); } return(JsonDataResult.Result(result)); }
private void HandleUnauthorizedRequest(AuthorizationContext filterContext) { if (AjaxRequestExtensions.IsAjaxRequest(filterContext.HttpContext.Request)) { JsonDataResult jsonDataResult = new JsonDataResult(); jsonDataResult.StatusCode = 401; jsonDataResult.ErrorMessages.Add(new Error { Message = "Tài Khoản của Bạn không có quyền thực hiện hành động này." }); jsonDataResult.Message = "Tài Khoản của Bạn không có quyền thực hiện hành động này."; JsonResult jsonResult = new JsonResult(); jsonResult.Data = (jsonDataResult); filterContext.Result = (jsonResult); } else { ViewResult viewResult = new ViewResult(); viewResult.ViewName = ("_Unauthorized"); filterContext.Result = (viewResult); } }
/// <summary> /// Retorna un datatable, recibe el sql a ejecutar /// </summary> /// <param name="pSelect"></param> /// <returns></returns> public static JsonDataResult TNS_QTConsulta(string Sql, List <object> parametros, string ConexionString = "") { JsonDataResult JsonResult = new JsonDataResult() { CONTENIDO = null }; ConexionString = string.IsNullOrEmpty(ConexionString) ? GlobalVariables.ConexionMySql : ConexionString; MySqlConnection conexion = new MySqlConnection(ConexionString); MySqlCommand command = new MySqlCommand(Sql, conexion); try { int i = 0; foreach (object value in parametros) { string param = string.Concat("@param", i); command.Parameters.AddWithValue(param, value); i++; } conexion.Open(); DataTable vDataTable = new DataTable(); vDataTable.Load(command.ExecuteReader()); JsonResult.CONTENIDO = JsonConvert.SerializeObject(vDataTable); JsonResult.SUCCESS = true; } catch (Exception e) { JsonResult.CONTENIDO = HelperWs.getMessageException(e); JsonResult.SUCCESS = false; } finally { conexion.Close(); conexion.Dispose(); } return(JsonResult); }
public static string GetDataCRUD(string User, string Sucursal, string Terminal, string datajson) { try { dynamic jsond = JsonConvert.DeserializeObject(datajson); string vquery = "CALL TNS_WF_" + jsond.sp + "('" + jsond.json + "'," + Sucursal + ",'" + User + "','" + Terminal + "'')"; JsonDataResult json = DBWs.TNS_QTConsulta(vquery); GlobalVariables.Mensaje = ""; if (json.SUCCESS) { DataTable tabla = (DataTable)JsonConvert.DeserializeObject(json.CONTENIDO.ToString(), typeof(DataTable)); try { int success = Convert.ToInt32(tabla.Rows[0]["OSUCCESS"].ToString()); if (success.Equals(0)) { GlobalVariables.Mensaje = tabla.Rows[0]["OMENSAJE"].ToString(); return(null); } } catch (Exception e) { } return(json.CONTENIDO.ToString()); } else { GlobalVariables.Mensaje = json.CONTENIDO.ToString(); return(null); } } catch (Exception ex) { return(Helper.Envoltorio(HelperWs.getMessageException(ex), false)); } }
public BaseController() { JsonDataResult = new JsonDataResult(); }