protected void Button2_Click(object sender, EventArgs e)
{
try
{
SqlParameter[] parameter =
{
new SqlParameter("@Name", txtName.Text),
new SqlParameter("@Email", txtEmail.Text),
new SqlParameter("@Contact", txtContact.Text)
};
int i = db.ExecuteNonQueryByProc("contact_info", parameter);
if (i > 0)
{
Label2.Visible = true;
Label2.ForeColor = System.Drawing.Color.Red;
Label2.Text = "Your contact details Send Successfull.. Thank you!!";
}
else
{
Label2.ForeColor = System.Drawing.Color.Red;
Label2.Text = "There is some Problem in registration, Please try again..!!";
}
}
catch (SqlException ex)
{
Label2.ForeColor = System.Drawing.Color.Red;
Label2.Text = ex.Message;
}
catch (Exception ex)
{
Label2.ForeColor = System.Drawing.Color.Red;
Label2.Text = ex.Message;
}
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
if (RadioButton1.Checked)
{
gender = RadioButton1.Text;
}
else if (RadioButton2.Checked)
{
gender = RadioButton2.Text;
}
try
{
SqlParameter[] parameter =
{
new SqlParameter("@Name", txtName.Text),
new SqlParameter("@User_Name", txtUserName.Text),
new SqlParameter("@Gender", gender),
new SqlParameter("@Phone", txtPhone.Text),
new SqlParameter("@Address", txtAddress.Text),
new SqlParameter("@Password", txtPassword.Text),
new SqlParameter("@Email", txtEmail.Text),
new SqlParameter("@Age", txtAge.Text),
new SqlParameter("@Aadhar_no", txtAadhar.Text)
};
int i = db.ExecuteNonQueryByProc("insert_User'sProfile", parameter);
if (i > 0)
{
linkbtn.ForeColor = System.Drawing.Color.Red;
linkbtn.Text = "Registration Successfull..!!";
Button1.Visible = true;
}
else
{
linkbtn.ForeColor = System.Drawing.Color.Red;
linkbtn.Text = "There is some Problem in registration, Please try again..!!";
}
}
catch (SqlException ex)
{
linkbtn.ForeColor = System.Drawing.Color.Red;
linkbtn.Text = ex.Message;
}
catch (Exception ex)
{
linkbtn.ForeColor = System.Drawing.Color.Red;
linkbtn.Text = ex.Message;
}
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
string filepath = "~/Seller/Uploads/" + FileUpload1.FileName;
try
{
FileInfo fileinfo = new FileInfo(FileUpload1.FileName);
if (fileinfo.Extension == ".JPEG" || fileinfo.Extension == ".jpeg" || fileinfo.Extension == ".JPG" || fileinfo.Extension == ".jpg" || fileinfo.Extension == ".jpeg" || fileinfo.Extension == ".GIF" || fileinfo.Extension == ".gif")
{
FileUpload1.PostedFile.SaveAs(Server.MapPath(filepath));
}
}
catch (Exception) { }
try
{
SqlParameter[] parameter =
{
new SqlParameter("@Name", txtName.Text),
new SqlParameter("@User_Name", txtusername.Text),
new SqlParameter("@Email", txtEmail.Text),
new SqlParameter("@Phone", txtPhone.Text),
new SqlParameter("@Age", txtAge.Text),
new SqlParameter("@Password", txtPassword.Text),
new SqlParameter("@Image", filepath)
};
int i = db.ExecuteNonQueryByProc("Insert_SellerInfo", parameter);
if (i > 0)
{
lblerrorMessage.Text = "You are Become a Seller Successfull..!!";
//lnkbtnUploadProperty.Visible = true;
//lnkbtnViewProfile.Visible = true;
}
else
{
lblerrorMessage.Text = "There is some Problem in registration, Please try again..!!";
}
}
catch (SqlException ex)
{
lblerrorMessage.ForeColor = System.Drawing.Color.Red;
lblerrorMessage.Text = ex.Message;
}
catch (Exception ex)
{
lblerrorMessage.ForeColor = System.Drawing.Color.Red;
lblerrorMessage.Text = ex.Message;
}
}
protected void Button1_Click(object sender, EventArgs e)
{
if (RadioButtonBank.Checked)
{
choice = RadioButtonBank.Text;
}
else if (RadioButtonCredit.Checked)
{
choice = RadioButtonCredit.Text;
}
else if (RadioButtonDebit.Checked)
{
choice = RadioButtonDebit.Text;
}
else if (RadioButtonGoogleWallet.Checked)
{
choice = RadioButtonGoogleWallet.Text;
}
else if (RadioButtonPaytm.Checked)
{
choice = RadioButtonPaytm.Text;
}
else if (RadioButtonVisa.Checked)
{
choice = RadioButtonVisa.Text;
}
try
{
SqlParameter[] parameter =
{
new SqlParameter("@pro_Id", Convert.ToInt32(lblProperty.Text)),
new SqlParameter("@UserId", Session["User"].ToString()),
new SqlParameter("@Rent_amount", lblRentAmount.Text),
new SqlParameter("@Expiry_date", txtExpiry.Text),
new SqlParameter("@Created_date", txtCreated.Text),
new SqlParameter("@Debit", choice),
new SqlParameter("@Credit", choice),
new SqlParameter("@cvv", txtCVV.Text),
new SqlParameter("@Visa_Master", choice),
new SqlParameter("@GoogleWallet", choice),
new SqlParameter("@Paytm", choice),
new SqlParameter("@Bank_payment", choice),
new SqlParameter("@CardNumber", txtCardNumber.Text),
new SqlParameter("@AccNumber", txtAccountNo.Text),
new SqlParameter("@Mobile", txtNumberDetails.Text)
};
int i = db.ExecuteNonQueryByProc("Insert_RentPayment", parameter);
if (i > 0)
{
lblMessage.ForeColor = System.Drawing.Color.Red;
lblMessage.Text = "Congratulations you are become a Tenant..!!";
}
else
{
lblMessage.ForeColor = System.Drawing.Color.Red;
lblMessage.Text = "There is some Problem in registration, Please try again..!!";
}
}
catch (SqlException ex)
{
lblMessage.ForeColor = System.Drawing.Color.Red;
lblMessage.Text = ex.Message;
}
catch (Exception ex)
{
lblMessage.ForeColor = System.Drawing.Color.Red;
lblMessage.Text = ex.Message;
}
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
if (Request.QueryString["pid"] != null)
{
string quer = "select * from BookingPayment where Prop_id='" + Request.QueryString["pid"].ToString() + "'";
DataTable dt = new DataTable();
dt = db.GetDataTableByQuery(quer);
if (dt.Rows.Count > 0)
{
Response.Write("<script>alert('This Property is already booked try another Property for Booking')</script>");
return;
}
}
if (RadioButtonBankPayment.Checked)
{
choice = RadioButtonBankPayment.Text;
}
else if (RadioButtonCredit.Checked)
{
choice = RadioButtonCredit.Text;
}
else if (RadioButtonDebit.Checked)
{
choice = RadioButtonDebit.Text;
}
else if (RadioButtonGoogleWallet.Checked)
{
choice = RadioButtonGoogleWallet.Text;
}
else if (RadioButtonPaytm.Checked)
{
choice = RadioButtonPaytm.Text;
}
else if (RadioButtonvisa.Checked)
{
choice = RadioButtonvisa.Text;
}
try
{
SqlParameter[] parameter =
{
new SqlParameter("@pro_Id", Convert.ToInt32(lblPropertyId.Text)),
new SqlParameter("@UserId", Session["User"].ToString()),
new SqlParameter("@Book_amount", lblBooking.Text),
new SqlParameter("@Expiry_date", txtExpiry.Text),
new SqlParameter("@Created_date", txtCreated.Text),
new SqlParameter("@Debit", choice),
new SqlParameter("@Credit", choice),
new SqlParameter("@cvv", txtCVV.Text),
new SqlParameter("@Visa_Master", choice),
new SqlParameter("@GoogleWallet", choice),
new SqlParameter("@Paytm", choice),
new SqlParameter("@Bank_payment", choice),
new SqlParameter("@CardNumber", txtCard.Text),
new SqlParameter("@AccNumber", txtAccount.Text),
new SqlParameter("@Mobile", txtmobile.Text),
};
int i = db.ExecuteNonQueryByProc("Booking_Payment", parameter);
if (i > 0)
{
lblMessage.ForeColor = System.Drawing.Color.Red;
lblMessage.Text = "Congratulations You Booked this Property!!";
}
else
{
lblMessage.ForeColor = System.Drawing.Color.Red;
lblMessage.Text = "There is some Problem in registration, Please try again..!!";
}
}
catch (SqlException ex)
{
lblMessage.ForeColor = System.Drawing.Color.Red;
lblMessage.Text = ex.Message;
}
catch (Exception ex)
{
lblMessage.ForeColor = System.Drawing.Color.Red;
lblMessage.Text = ex.Message;
}
}
protected void btnPropSubmit_Click(object sender, EventArgs e)
{
if (RadioButton1.Checked)
{
Rent = RadioButton1.Text;
}
else if (RadioButton2.Checked)
{
Rent = RadioButton2.Text;
}
if (RadioButtonCommercial.Checked)
{
category = RadioButtonCommercial.Text;
}
else if (RadioButtonResidential.Checked)
{
category = RadioButtonResidential.Text;
}
string filePath1 = string.Empty;
string filepath2 = string.Empty;
string filepath3 = string.Empty;
string filepath4 = string.Empty;
FileInfo fileinfo1 = null;
FileInfo fileinfo2 = null;
FileInfo fileinfo3 = null;
FileInfo fileinfo4 = null;
if (FileUpload1.FileName.Length > 0)
{
filePath1 = "~\\Uploads\\" + FileUpload1.FileName;
fileinfo1 = new FileInfo(FileUpload1.FileName);
}
if (fileinfo1 != null)
{
if (fileinfo1.Extension == ".JPEG" || fileinfo1.Extension == ".jpeg" || fileinfo1.Extension == ".JPG" || fileinfo1.Extension == ".jpg" || fileinfo1.Extension == ".jpeg" || fileinfo1.Extension == ".GIF" || fileinfo1.Extension == ".gif")
{
filePath1 = "~\\Uploads\\" + FileUpload1.FileName;
FileUpload1.PostedFile.SaveAs(Server.MapPath(filePath1));
}
}
if (FileUpload2.FileName.Length > 0)
{
filepath2 = "~\\Uploads\\" + FileUpload2.FileName;
fileinfo2 = new FileInfo(FileUpload2.FileName);
}
if (fileinfo2 != null)
{
if (fileinfo2.Extension == ".JPEG" || fileinfo2.Extension == ".jpeg" || fileinfo2.Extension == ".JPG" || fileinfo2.Extension == ".jpg" || fileinfo2.Extension == ".jpeg" || fileinfo2.Extension == ".GIF" || fileinfo2.Extension == ".gif")
{
FileUpload2.PostedFile.SaveAs(Server.MapPath(filepath2));
}
}
if (FileUpload3.FileName.Length > 0)
{
filepath3 = "~\\Uploads\\" + FileUpload3.FileName;
fileinfo3 = new FileInfo(FileUpload3.FileName);
}
if (fileinfo3 != null)
{
if (fileinfo3.Extension == ".JPEG" || fileinfo3.Extension == ".jpeg" || fileinfo3.Extension == ".JPG" || fileinfo3.Extension == ".jpg" || fileinfo3.Extension == ".jpeg" || fileinfo3.Extension == ".GIF" || fileinfo3.Extension == ".gif")
{
FileUpload3.PostedFile.SaveAs(Server.MapPath(filepath3));
}
}
if (FileUpload4.FileName.Length > 0)
{
filepath4 = "~\\Uploads\\" + FileUpload4.FileName;
fileinfo4 = new FileInfo(FileUpload4.FileName);
}
if (fileinfo4 != null)
{
if (fileinfo4.Extension == ".JPEG" || fileinfo4.Extension == ".jpeg" || fileinfo4.Extension == ".JPG" || fileinfo4.Extension == ".jpg" || fileinfo4.Extension == ".jpeg" || fileinfo4.Extension == ".GIF" || fileinfo4.Extension == ".gif")
{
FileUpload4.PostedFile.SaveAs(Server.MapPath(filepath4));
}
}
try
{
SqlParameter[] parameter =
{
new SqlParameter("@Property_Name", txtPropertyName.Text),
new SqlParameter("@Address", txtPropAddress.Text),
new SqlParameter("@Image1", filePath1),
new SqlParameter("@Image2", filepath2),
new SqlParameter("@Image3", filepath3),
new SqlParameter("@Image4", filepath4),
new SqlParameter("@BHK", txtPropBHK.Text),
new SqlParameter("@Floor", txtPropFloor.Text),
new SqlParameter("@Washroom", txtPropWashroom.Text),
new SqlParameter("@Bedroom", PropBedroom.Text),
new SqlParameter("@Hall", txtPropHall.Text),
new SqlParameter("@Kitchen", txtPropKitchen.Text),
new SqlParameter("@Description", txtDescription.Text),
new SqlParameter("@Price", txtPrice.Text),
new SqlParameter("@Booking_Price", txtBook.Text),
new SqlParameter("@Rent", Rent),
new SqlParameter("@Rent_amount", ttxtRentAmount.Text),
new SqlParameter("@Duration", txtDuration.Text),
new SqlParameter("@Agreement", txtAgreemnet.Text),
new SqlParameter("@category", category),
new SqlParameter("@Locality", txtLocality.Text),
new SqlParameter("@Pin", txtArea.Text)
};
int i = db.ExecuteNonQueryByProc("insert_PropertyInfo", parameter);
if (i > 0)
{
lnkButton.ForeColor = System.Drawing.Color.Red;
lnkButton.Text = "Property Details are submitted Successfully..!!";
//Button1.Visible = true;
}
else
{
lnkButton.ForeColor = System.Drawing.Color.Red;
lnkButton.Text = "There is some Problem in Submission, Please try again..!!";
}
}
catch (SqlException ex)
{
lnkButton.ForeColor = System.Drawing.Color.Red;
lnkButton.Text = ex.Message;
}
catch (Exception ex)
{
lnkButton.ForeColor = System.Drawing.Color.Red;
lnkButton.Text = ex.Message;
}
}