internal List <NewsImages> getImagesByNewsId(int newsId) { using (SqlConnection sqlConnection = new SqlConnection(connectionString)) { using (SqlCommand command = new SqlCommand("sp_GetNewsImagesByNewsId", sqlConnection)) { try { sqlConnection.Open(); command.CommandType = CommandType.StoredProcedure; command.Parameters.AddWithValue("@NewsId", newsId); SqlDataReader rdr = command.ExecuteReader(); List <NewsImages> newsList = new List <NewsImages>(); while (rdr.Read()) { NewsImages news = new NewsImages(); news.Id = Convert.ToInt32(rdr["Id"]); news.ImageSource = rdr["ImageSource"].ToString(); news.NewsId = Convert.ToInt32(rdr["NewsId"]); newsList.Add(news); } return(newsList); } catch (Exception ex) { throw ex; } } } }
public ActionResult NewsImageUpload(int id) { try { HttpPostedFile file = null; if (System.Web.HttpContext.Current.Request.Files.AllKeys.Any()) { file = System.Web.HttpContext.Current.Request.Files["HttpPostedFileBase"]; } string stamp = string.Format("{0:yyyy-MM-dd_hh-mm-ss-tt}", DateTime.Now); string filename = file.FileName.Split('.')[0] + stamp + "." + file.FileName.Split('.')[1]; string pic = System.IO.Path.GetFileName(filename); string path = System.IO.Path.Combine( Server.MapPath("~/images/news"), pic); // file is uploaded file.SaveAs(path); NewsImages images = new NewsImages(); images.ImageSource = "/images/news/" + pic; images.NewsId = id; images.Id = images.Save(); // after successfully uploading redirect the user return(PartialView("NewsImagePartial", images)); } catch (Exception ex) { return(Json("Error occured")); } }
public JsonResult DeleteNewsImage(int id) { try { NewsImages.Delete(id); return(Json("Նկարը հաջողությամբ ջբջված է", JsonRequestBehavior.AllowGet)); } catch (Exception ex) { return(Json("Ձախողում! չի հաջողվել ջնջել:", JsonRequestBehavior.AllowGet)); } }
internal int saveNewsImages(NewsImages newsImages) { using (SqlConnection sqlConnection = new SqlConnection(connectionString)) { using (SqlCommand command = new SqlCommand("sp_SaveNewsImage", sqlConnection)) { try { sqlConnection.Open(); command.CommandType = CommandType.StoredProcedure; command.Parameters.AddWithValue("@ImageSource", newsImages.ImageSource); command.Parameters.AddWithValue("@NewsId", newsImages.NewsId); return(Convert.ToInt32(command.ExecuteScalar())); } catch (Exception ex) { throw ex; } } } }