public ActionResult SCNormalInsert([FromBody] CRUDModel <NetCorePSAV.Models.PSAVCrud.ILCrudModel.SubCategoria> value)
{
NetCorePSAV.Models.PSAVCrud.ILCrudModel.SubCategoria val = value.Value;
val.ID = QueryCrud.UpdateSCategories(0, value.Value);
SubCategoriasList.Insert(SubCategoriasList.Count, val);
return(Json(EtiquetasList));
}
public ActionResult SCNormalDelete([FromBody] CRUDModel <NetCorePSAV.Models.PSAVCrud.ILCrudModel.SubCategoria> value)
{
NetCorePSAV.Models.PSAVCrud.ILCrudModel.SubCategoria val = new NetCorePSAV.Models.PSAVCrud.ILCrudModel.SubCategoria();
val.ID = value.Key.ToString();
QueryCrud.UpdateSCategories(2, val);
SubCategoriasList.Remove(SubCategoriasList.Where(or => or.ID == value.Key.ToString()).FirstOrDefault());
return(Json(value));
}
public ActionResult SCNormalUpdate([FromBody] CRUDModel <NetCorePSAV.Models.PSAVCrud.ILCrudModel.SubCategoria> myObject)
{
var ord = myObject.Value;
NetCorePSAV.Models.PSAVCrud.ILCrudModel.SubCategoria val = SubCategoriasList.Where(or => or.ID == ord.ID).FirstOrDefault();
val.ID = ord.ID; val.Nombre = ord.Nombre;
QueryCrud.UpdateSCategories(1, val);
return(Json(myObject.Value));
}
public List <NetCorePSAV.Models.PSAVCrud.ILCrudModel.SubCategoria> GetSubCategories()
{
string TabSQLSens = "SELECT * FROM psav_dev.tc_subcategoria";
List <NetCorePSAV.Models.PSAVCrud.ILCrudModel.SubCategoria> locations = new List <NetCorePSAV.Models.PSAVCrud.ILCrudModel.SubCategoria>();
MySqlConnection conn = new MySqlConnection(con); //estamos estableciendo conexión con mySql
MySqlCommand cmd = new MySqlCommand(TabSQLSens, conn); //estamos ejecutando el código SELECT FROM
conn.Open();
MySqlDataReader sdr = cmd.ExecuteReader();//le estamos diciendo que lea los datos guardados en la base de datos
while (sdr.Read())
{
NetCorePSAV.Models.PSAVCrud.ILCrudModel.SubCategoria location = new NetCorePSAV.Models.PSAVCrud.ILCrudModel.SubCategoria();
location.ID = sdr.GetValue(0).ToString();
location.Nombre = sdr.GetValue(1).ToString();
locations.Add(location);
}
conn.Close();
return(locations);
}
public string UpdateSCategories(int typeUpdate, NetCorePSAV.Models.PSAVCrud.ILCrudModel.SubCategoria locationModel)
{
string queryToInsert = ""; string valor = "";
switch (typeUpdate)
{
case 0:
queryToInsert = "insert into psav_dev.tc_subcategoria (tc_subcategoria,tc_type,tcc_id) values('" + locationModel.Nombre + "',1,1)";
valor = SaveWithIDReturn(queryToInsert);
break;
case 1:
queryToInsert = "update psav_dev.tc_subcategoria set tc_subcategoria='" + locationModel.Nombre + "' where tc_id=" + locationModel.ID;
SaveWithoutValidation(queryToInsert);
break;
case 2:
queryToInsert = "delete from psav_dev.tc_subcategoria where tc_id=" + locationModel.ID;
SaveWithoutValidation(queryToInsert);
break;
}
return(valor);
}
