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