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