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