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();
}
