public List <AlbumMaster> GetAlbums()
{
SqlConnection scon = new SqlConnection(conn);
List <AlbumMaster> objAlbumList = new List <AlbumMaster>();
using (SqlCommand scmd = new SqlCommand())
{
scmd.Connection = scon;
scmd.CommandType = CommandType.Text;
scmd.CommandText = "SELECT * FROM BeautyGallery";
scon.Open();
SqlDataReader sdr = scmd.ExecuteReader();
while (sdr.Read())
{
AlbumMaster objAlbumMaster = new AlbumMaster();
objAlbumMaster.ImageId = Convert.ToInt32(sdr["ImageId"]);
objAlbumMaster.ImageName = sdr["ImageName"].ToString();
objAlbumMaster.Image = (byte[])sdr["Photo"];
objAlbumMaster.Userid = Convert.ToInt32(sdr["userid"]);
objAlbumList.Add(objAlbumMaster);
}
if (sdr != null)
{
sdr.Dispose();
sdr.Close();
}
scon.Close();
return(objAlbumList.ToList());;
}
}
public ActionResult Index(FormCollection collection)
{
HttpPostedFileBase file = Request.Files["ImageData"];
AlbumMaster objAlbumMaster = new AlbumMaster();
objAlbumMaster.ImageName = collection["ImageName"].ToString();
objAlbumMaster.Image = ConvertToBytes(file);
objAlbumModelService.UploadAlbums(objAlbumMaster);
return(View(objAlbumModelService.GetAlbums().ToList()));
}
public ActionResult AddImage(FormCollection collection)
{
HttpPostedFileBase file = Request.Files["ImageData"];
AlbumMaster objAlbumMaster = new AlbumMaster();
objAlbumMaster.ImageName = collection["ImageName"].ToString();
objAlbumMaster.SubServiceID = Convert.ToInt32(collection["subservicelist"].ToString());
objAlbumMaster.Image = ConvertToBytes(file);
objAlbumModelService.UploadAlbums(objAlbumMaster);
return(RedirectToAction("Index"));
}
public int UploadAlbums(AlbumMaster objAlbumMaster)
{
SqlConnection con = new SqlConnection(conn);
using (SqlCommand scmd = new SqlCommand())
{
scmd.Connection = con;
scmd.CommandType = CommandType.Text;
scmd.CommandText = "INSERT INTO BeautyGallery(ImageName,Photo,userid,SubServiceId) VALUES(@ImageName,@Photo,@userid,@SubServviceID)";
scmd.Parameters.AddWithValue("@ImageName", objAlbumMaster.ImageName);
scmd.Parameters.AddWithValue("@Photo", objAlbumMaster.Image);
scmd.Parameters.AddWithValue("@userid", objAlbumMaster.Userid);
scmd.Parameters.AddWithValue("@SubServviceID", objAlbumMaster.SubServiceID);
con.Open();
int status = scmd.ExecuteNonQuery();
con.Close();
return(status);
}
}
public byte[] GetImageFromDataBase(int id)
{
SqlConnection scon = new SqlConnection(conn);
using (SqlCommand scmd = new SqlCommand())
{
scmd.Connection = scon;
scmd.CommandType = CommandType.Text;
scmd.CommandText = "SELECT Photo FROM BeautyGallery where ImageId=@ImageId";
scmd.Parameters.AddWithValue("@ImageId", id);
scon.Open();
SqlDataReader sdr = scmd.ExecuteReader();
AlbumMaster objAlbum = new AlbumMaster();
while (sdr.Read())
{
objAlbum.Image = (byte[])sdr["Photo"];
}
return(objAlbum.Image);
}
}
