protected void btnsub_Click(object sender, EventArgs e)
{
cn.Open();
if (drptype.SelectedValue == "3")
{
dealid = Session["bid"].ToString();
ownType = "Builder";
qry = "insert into PropertyOwner(Pname,Pdesc,Ptype,PCat,Bedroom,Bathroom,Kitchen,HouseNo,TotalSquareFeet,PerFeetPrice,TotalPrice,Paddress,OwnerType,OwnerId,Pimg,Cid,sid,Ciid,status) values('" + txtpname.Text + "','" + txtdi.Text + "','" + drptype.SelectedItem.Text + "','" + drsr.SelectedItem.Text + "','" + drbed.SelectedItem.Text + "','" + drbat.SelectedItem.Text + "','" + drkit.SelectedItem.Text + "','" + txthouseno.Text + "','" + txtfeet.Text + "','" + txtfeetprice.Text + "','" + txttotprice.Text + "','" + txtadd.Text + "','" + ownType + "','" + dealid + "','" + fl1.FileName + "','" + "1" + "','" + drst.SelectedItem.Value + "','" + drct.SelectedItem.Value + "','" + 0 + "')";
SqlCommand cmd = new SqlCommand(qry, cn);
cmd.ExecuteNonQuery();
string path = Path.GetFileName(fl1.FileName);
path = path.Replace(" ", "");
String filename1 = path;
fl1.SaveAs(Server.MapPath("~/Admin/img/") + path);
}
else if (drptype.SelectedValue == "4")
{
dealid = Session["bid"].ToString();
ownType = "Builder";
qry = "insert into PropertyOwner(Pname,Pdesc,Ptype,PCat,Bedroom,Bathroom,Kitchen,HouseNo,TotalFlore,TotalSquareFeet,PerFeetPrice,TotalPrice,Paddress,OwnerType,OwnerId,Pimg,Cid,sid,Ciid,status) values('" + txtpname.Text + "','" + txtdi.Text + "','" + drptype.SelectedItem.Text + "','" + drsr.SelectedItem.Text + "','" + drbed.SelectedItem.Text + "','" + drbat.SelectedItem.Text + "','" + drkit.SelectedItem.Text + "','" + txthouseno.Text + "','" + txtflore.Text + "','" + txtfeet.Text + "','" + txtfeetprice.Text + "','" + txttotprice.Text + "','" + txtadd.Text + "','" + ownType + "','" + dealid + "','" + fl1.FileName + "','" + "1" + "','" + drst.SelectedItem.Value + "','" + drct.SelectedItem.Value + "','" + 0 + "')";
SqlCommand cmd = new SqlCommand(qry, cn);
cmd.ExecuteNonQuery();
string path = Path.GetFileName(fl1.FileName);
path = path.Replace(" ", "");
String filename1 = path;
fl1.SaveAs(Server.MapPath("~/Admin/img/") + path);
}
else
{
dealid = Session["bid"].ToString();
ownType = "Builder";
qry = "insert into PropertyOwner(Pname,Pdesc,Ptype,PCat,Bedroom,Bathroom,Kitchen,TotalSquareFeet,PerFeetPrice,TotalPrice,Paddress,OwnerType,OwnerId,Pimg,Cid,sid,Ciid,status) values('" + txtpname.Text + "','" + txtdi.Text + "','" + drptype.SelectedItem.Text + "','" + drsr.SelectedItem.Text + "','" + drbed.SelectedItem.Text + "','" + drbat.SelectedItem.Text + "','" + drkit.SelectedItem.Text + "','" + txtfeet.Text + "','" + txtfeetprice.Text + "','" + txttotprice.Text + "','" + txtadd.Text + "','" + ownType + "','" + dealid + "','" + fl1.FileName + "','" + "1" + "','" + drst.SelectedItem.Value + "','" + drct.SelectedItem.Value + "','" + 0 + "')";
SqlCommand cmd = new SqlCommand(qry, cn);
cmd.ExecuteNonQuery();
string path = Path.GetFileName(fl1.FileName);
path = path.Replace(" ", "");
String filename1 = path;
fl1.SaveAs(Server.MapPath("~/Admin/img/") + path);
}
string q;
q = "select Max(pid) from PropertyOwner";
SqlCommand c = new SqlCommand(q, cn);
int max = Convert.ToInt32(c.ExecuteScalar());
//max += 1;
if (FileUploadImg1.HasFile == false)
{
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "key", "<script>alert('No File Uploaded.')</script>", false);
}
else
{
foreach (var file in FileUploadImg1.PostedFiles)
{
string filename = Path.GetFileName(file.FileName);
qr = "insert into gallry values('" + max + "','" + filename + "')";
cmd = new SqlCommand(qr, cn);
cmd.ExecuteNonQuery();
path = Path.GetFileName(FileUploadImg1.FileName);
path = path.Replace(" ", "");
String filename2 = path;
FileUploadImg1.SaveAs(Server.MapPath("~/Admin/img/PropGal/") + path);
//path = path.Replace(" ", "");
//String filename2 = path;
//fl1.SaveAs(Server.MapPath("~/Admin/img/") + path);
//int width = 370;
//int height = 330;
//Stream stream = file.InputStream;
//Bitmap image = new Bitmap(stream);
//Bitmap target = new Bitmap(width, height);
//Graphics graphic = Graphics.FromImage(target);
//graphic.DrawImage(image, 0, 0, width, height);
//target.Save(Server.MapPath("~/car_images/") + filename);
//file.SaveAs(Server.MapPath("../car_images/" + filename));
//SqlCommand cmd = new SqlCommand("Insert into
//EventPageView(Event_name, Event_Text, Image_Path)
//values(@EventName, @EventText, @ImagePath)", conn);
//cmd.Parameters.AddWithValue("@ImagePath", filename);
//cmd.Parameters.AddWithValue("@EventName", txtEventName.Text);
//cmd.Parameters.AddWithValue("@EventText", txtEnterDesc.Text);
//conn.Open();
//cmd.ExecuteNonQuery();
//conn.Close();
//BindDataList();
}
}
cn.Close();
string query;
if (ch1.Checked)
{
cn.Open();
query = "insert into Amenities values('" + max + "','" + ch1.Text + "')";
SqlCommand cm = new SqlCommand(query, cn);
cm.ExecuteNonQuery();
cn.Close();
}
if (ch2.Checked)
{
cn.Open();
query = "insert into Amenities values('" + max + "','" + ch2.Text + "')";
SqlCommand cm = new SqlCommand(query, cn);
cm.ExecuteNonQuery();
cn.Close();
}
if (ch3.Checked)
{
cn.Open();
query = "insert into Amenities values('" + max + "','" + ch3.Text + "')";
SqlCommand cm = new SqlCommand(query, cn);
cm.ExecuteNonQuery();
cn.Close();
}
if (ch4.Checked)
{
cn.Open();
query = "insert into Amenities values('" + max + "','" + ch4.Text + "')";
SqlCommand cm = new SqlCommand(query, cn);
cm.ExecuteNonQuery();
cn.Close();
}
if (ch5.Checked)
{
cn.Open();
query = "insert into Amenities values('" + max + "','" + ch5.Text + "')";
SqlCommand cm = new SqlCommand(query, cn);
cm.ExecuteNonQuery();
cn.Close();
}
if (ch6.Checked)
{
cn.Open();
query = "insert into Amenities values('" + max + "','" + ch6.Text + "')";
SqlCommand cm = new SqlCommand(query, cn);
cm.ExecuteNonQuery();
cn.Close();
}
if (ch7.Checked)
{
cn.Open();
query = "insert into Amenities values('" + max + "','" + ch7.Text + "')";
SqlCommand cm = new SqlCommand(query, cn);
cm.ExecuteNonQuery();
cn.Close();
}
if (ch8.Checked)
{
cn.Open();
query = "insert into Amenities values('" + max + "','" + ch8.Text + "')";
SqlCommand cm = new SqlCommand(query, cn);
cm.ExecuteNonQuery();
cn.Close();
}
if (ch9.Checked)
{
cn.Open();
query = "insert into Amenities values('" + max + "','" + ch9.Text + "')";
SqlCommand cm = new SqlCommand(query, cn);
cm.ExecuteNonQuery();
cn.Close();
}
if (ch10.Checked)
{
cn.Open();
query = "insert into Amenities values('" + max + "','" + ch10.Text + "')";
SqlCommand cm = new SqlCommand(query, cn);
cm.ExecuteNonQuery();
cn.Close();
}
if (ch11.Checked)
{
cn.Open();
query = "insert into Amenities values('" + max + "','" + ch11.Text + "')";
SqlCommand cm = new SqlCommand(query, cn);
cm.ExecuteNonQuery();
cn.Close();
}
if (ch12.Checked)
{
cn.Open();
query = "insert into Amenities values('" + max + "','" + ch12.Text + "')";
SqlCommand cm = new SqlCommand(query, cn);
cm.ExecuteNonQuery();
cn.Close();
}
Response.Redirect("Property.aspx");
}
protected void btnsub_Click(object sender, EventArgs e)
{
if (txtpname.Text == "" || txtadd.Text == "" || txtdi.Text == "" || txtfeet.Text == "" || txtpin.Text == "" || drptype.SelectedValue == "1" || FileUploadImg1.FileName == "" || fl1.FileName == "" || drbed.SelectedValue == "Bed Room" || drkit.SelectedValue == "Kitchen" || drbat.SelectedValue == "Bathroom")
{
Label1.Visible = true;
}
else
{
string fileExt = System.IO.Path.GetExtension(fl1.FileName);
//if (fileExt == ".jpg" || fileExt == ".png")
//{
Label1.Visible = false;
cn.Open();
//userid = Session["uid"].ToString();
//ownType = "Owner";
qry = "insert into AuctionProp (pnam,Pdesc,Ptype,Bedroom,Bathroom,Kitchen,TotalSquareFeet,StartBid,Paddress,Pimg,coid,sid,Ciid,status) values('" + txtpname.Text + "','" + txtdi.Text + "','" + drptype.SelectedItem.Text + "','" + drbed.SelectedItem.Text + "','" + drbat.SelectedItem.Text + "','" + drkit.SelectedItem.Text + "','" + txtfeet.Text + "','" + txtbid.Text + "','" + txtadd.Text + "','" + fl1.FileName + "','" + dsrcnt.SelectedValue + "','" + drst.SelectedValue + "','" + drct.SelectedValue + "','" + 0 + "')";
SqlCommand cmd = new SqlCommand(qry, cn);
cmd.ExecuteNonQuery();
string path = Path.GetFileName(fl1.FileName);
path = path.Replace(" ", "");
String filename1 = path;
fl1.SaveAs(Server.MapPath("~/Admin/img/") + path);
string q;
q = "select Max(paid) from AuctionProp";
SqlCommand c = new SqlCommand(q, cn);
max = Convert.ToInt32(c.ExecuteScalar());
//max += 1;
if (FileUploadImg1.HasFile == false)
{
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "key", "<script>alert('No File Uploaded.')</script>", false);
}
else
{
foreach (var file in FileUploadImg1.PostedFiles)
{
string qr;
string filename = Path.GetFileName(file.FileName);
qr = "insert into gallry values('" + max + "','" + filename + "')";
cmd = new SqlCommand(qr, cn);
cmd.ExecuteNonQuery();
path = Path.GetFileName(FileUploadImg1.FileName);
path = path.Replace(" ", "");
String filename2 = path;
FileUploadImg1.SaveAs(Server.MapPath("~/Admin/img/PropGal/") + path);
//path = path.Replace(" ", "");
//String filename2 = path;
//fl1.SaveAs(Server.MapPath("~/Admin/img/") + path);
//int width = 370;
//int height = 330;
//Stream stream = file.InputStream;
//Bitmap image = new Bitmap(stream);
//Bitmap target = new Bitmap(width, height);
//Graphics graphic = Graphics.FromImage(target);
//graphic.DrawImage(image, 0, 0, width, height);
//target.Save(Server.MapPath("~/car_images/") + filename);
//file.SaveAs(Server.MapPath("../car_images/" + filename));
//SqlCommand cmd = new SqlCommand("Insert into
//EventPageView(Event_name, Event_Text, Image_Path)
//values(@EventName, @EventText, @ImagePath)", conn);
//cmd.Parameters.AddWithValue("@ImagePath", filename);
//cmd.Parameters.AddWithValue("@EventName", txtEventName.Text);
//cmd.Parameters.AddWithValue("@EventText", txtEnterDesc.Text);
//conn.Open();
//cmd.ExecuteNonQuery();
//conn.Close();
//BindDataList();
}
}
cn.Close();
cn.Open();
string s = "insert into Bidprop (paid,bidamt,status) values('" + max + "','" + txtbid.Text + "','" + "','" + 0 + "'";
SqlCommand co = new SqlCommand(s, cn);
co.ExecuteNonQuery();
cn.Close();
string query;
if (ch1.Checked)
{
cn.Open();
query = "insert into Amenities values('" + max + "','" + ch1.Text + "')";
SqlCommand cm = new SqlCommand(query, cn);
cm.ExecuteNonQuery();
cn.Close();
}
if (ch2.Checked)
{
cn.Open();
query = "insert into Amenities values('" + max + "','" + ch2.Text + "')";
SqlCommand cm = new SqlCommand(query, cn);
cm.ExecuteNonQuery();
cn.Close();
}
if (ch3.Checked)
{
cn.Open();
query = "insert into Amenities values('" + max + "','" + ch3.Text + "')";
SqlCommand cm = new SqlCommand(query, cn);
cm.ExecuteNonQuery();
cn.Close();
}
if (ch4.Checked)
{
cn.Open();
query = "insert into Amenities values('" + max + "','" + ch4.Text + "')";
SqlCommand cm = new SqlCommand(query, cn);
cm.ExecuteNonQuery();
cn.Close();
}
if (ch5.Checked)
{
cn.Open();
query = "insert into Amenities values('" + max + "','" + ch5.Text + "')";
SqlCommand cm = new SqlCommand(query, cn);
cm.ExecuteNonQuery();
cn.Close();
}
if (ch6.Checked)
{
cn.Open();
query = "insert into Amenities values('" + max + "','" + ch6.Text + "')";
SqlCommand cm = new SqlCommand(query, cn);
cm.ExecuteNonQuery();
cn.Close();
}
if (ch7.Checked)
{
cn.Open();
query = "insert into Amenities values('" + max + "','" + ch7.Text + "')";
SqlCommand cm = new SqlCommand(query, cn);
cm.ExecuteNonQuery();
cn.Close();
}
if (ch8.Checked)
{
cn.Open();
query = "insert into Amenities values('" + max + "','" + ch8.Text + "')";
SqlCommand cm = new SqlCommand(query, cn);
cm.ExecuteNonQuery();
cn.Close();
}
if (ch9.Checked)
{
cn.Open();
query = "insert into Amenities values('" + max + "','" + ch9.Text + "')";
SqlCommand cm = new SqlCommand(query, cn);
cm.ExecuteNonQuery();
cn.Close();
}
if (ch10.Checked)
{
cn.Open();
query = "insert into Amenities values('" + max + "','" + ch10.Text + "')";
SqlCommand cm = new SqlCommand(query, cn);
cm.ExecuteNonQuery();
cn.Close();
}
if (ch11.Checked)
{
cn.Open();
query = "insert into Amenities values('" + max + "','" + ch11.Text + "')";
SqlCommand cm = new SqlCommand(query, cn);
cm.ExecuteNonQuery();
cn.Close();
}
if (ch12.Checked)
{
cn.Open();
query = "insert into Amenities values('" + max + "','" + ch12.Text + "')";
SqlCommand cm = new SqlCommand(query, cn);
cm.ExecuteNonQuery();
cn.Close();
}
}
}
