public JsonResult eliminarAvisos(detailAviso detAviso)
{
try
{
SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["DefaultConnection"].ConnectionString);
SqlCommand cmd = new SqlCommand("DELETE_AVISO", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("AVISO_ID", SqlDbType.Int);
cmd.Parameters["AVISO_ID"].Value = detAviso.idAviso;
con.Open();
cmd.ExecuteNonQuery();
con.Close();
return(Json(new { success = true, mensaje = "Borrado correcto" }));
}
catch (Exception X)
{
return(Json(new { success = false, mensaje = X.Message }));
}
}
public JsonResult guardaAviso(detailAviso detAviso)
{
try
{
string filename = "";
if (detAviso.loadImage)
{
filename = "AVISO" + DateTime.Now.Year.ToString("0000") + DateTime.Now.Month.ToString("00") + DateTime.Now.Day.ToString("00") + DateTime.Now.Hour.ToString("00") + DateTime.Now.Minute.ToString("00") + DateTime.Now.Second.ToString("00") + ".png";
string path = Path.Combine(Server.MapPath("~/content/img/avisos"), filename);
using (FileStream fs = new FileStream(path, FileMode.Create))
{
using (BinaryWriter bw = new BinaryWriter(fs))
{
byte[] data = Convert.FromBase64String(detAviso.file);
bw.Write(data);
bw.Close();
}
}
}
SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["DefaultConnection"].ConnectionString);
string strCmd = "";
if (detAviso.idAviso == 0)
{
strCmd = "INSERT_AVISO";
}
else
{
strCmd = "UPDATE_AVISO";
}
SqlCommand cmd = new SqlCommand(strCmd, con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("UNEGOCIO_ID", SqlDbType.Int);
cmd.Parameters.Add("ASUNTO", SqlDbType.Text);
cmd.Parameters.Add("MENSAJE", SqlDbType.Text);
cmd.Parameters.Add("IMAGEN", SqlDbType.Text);
cmd.Parameters.Add("FECHAINI", SqlDbType.DateTime);
cmd.Parameters.Add("FECHAFIN", SqlDbType.DateTime);
cmd.Parameters.Add("FECHA", SqlDbType.DateTime);
cmd.Parameters.Add("REALIZO", SqlDbType.Int);
if (detAviso.idAviso > 0)
{
cmd.Parameters.Add("AVISO_ID", SqlDbType.Int);
cmd.Parameters["AVISO_ID"].Value = detAviso.idAviso;
}
cmd.Parameters["UNEGOCIO_ID"].Value = detAviso.uneg_id;
cmd.Parameters["ASUNTO"].Value = detAviso.asunto;
cmd.Parameters["MENSAJE"].Value = detAviso.mensaje;
cmd.Parameters["IMAGEN"].Value = filename;
cmd.Parameters["FECHAINI"].Value = detAviso.fechaini;
cmd.Parameters["FECHAFIN"].Value = detAviso.fechafin;
cmd.Parameters["FECHA"].Value = DateTime.Now.ToString();
cmd.Parameters["REALIZO"].Value = Session["intID"].ToString();
con.Open();
cmd.ExecuteNonQuery();
con.Close();
return(Json(new { success = true, mensaje = "Se guardo correctamente" }));
}
catch (Exception X)
{
return(Json(new { success = false, mensaje = X.Message }));
}
}
