public ActionResult UploadImages(PropertyImageUpload imgp) { //create path to store in database string filename = imgp.PropertyID + "-" + imgp.user_image_data.FileName; //img.Save("path"); //store image in folder imgp.user_image_data.SaveAs(Server.MapPath("~/images/PropertyImages") + "/" + filename); WebImage img = new WebImage(Server.MapPath("~/images/PropertyImages") + "/" + filename); if (img.Height > 724) { img.Resize(1000, 724, false); } img.Save(Server.MapPath("~/images/PropertyImages") + "/" + filename); //insert in database SqlCommand cmdfupd = new SqlCommand("Select * from PropertyImage where ImageName='" + filename + "'", conn); if (conn.State == ConnectionState.Closed) { conn.Open(); } SqlDataReader dru = cmdfupd.ExecuteReader(); bool existing = false; if (dru.Read()) { existing = true; } dru.Close(); if (existing == false) { SqlCommand cmdf = new SqlCommand("Select top 1 * from PropertyImage order by ImageId desc", conn); SqlDataReader drf = cmdf.ExecuteReader(); int ImageID = 0; if (drf.Read()) { ImageID = int.Parse(drf["ImageID"].ToString()); } ImageID++; drf.Close(); SqlCommand cmd = new SqlCommand("Insert into PropertyImage (ImageID, PropertyID, ImageName, ActiveView) Values(@ImageID, @PropertyID, @ImageName,0)", conn); cmd.Parameters.Add(new SqlParameter("@ImageID", SqlDbType.Int)).Value = ImageID; cmd.Parameters.Add(new SqlParameter("@PropertyID", SqlDbType.Int)).Value = imgp.PropertyID; cmd.Parameters.Add(new SqlParameter("@ImageName", SqlDbType.NVarChar, filename.Length)).Value = filename; cmd.ExecuteNonQuery(); } PropertyImageUpload imgfile = new PropertyImageUpload(); imgfile.PropertyID = imgp.PropertyID; return(View(imgfile)); }
public ActionResult UploadImages(int id) { SqlCommand cmd = new SqlCommand("Select PTM.PropertyType, PM.ProjectName, LM.location, PM.Builder from PropertyListMaster PLM, PropertyTypeMaster PTM, ProjectMaster PM, LocationMaster LM where PLM.PTID=PTM.PTID and PLM.ProjectID=PM.ProjectID and PM.LocationID=LM.LocationID and PLM.PropertyID=" + id, conn); if (conn.State == ConnectionState.Closed) { conn.Open(); } SqlDataReader drm = cmd.ExecuteReader(); string prop = ""; if (drm.Read()) { prop = drm["PropertyType"].ToString() + " | " + drm["ProjectName"].ToString() + " | " + drm["Location"].ToString() + " By " + drm["Builder"].ToString(); } PropertyImageUpload imgfile = new PropertyImageUpload(); imgfile.PropertyID = id; imgfile.property = prop; return(View(imgfile)); }