protected void Page_Load(object sender, EventArgs e)
{
SqlDataReader drtype;
if (!Page.IsPostBack)
{
string StmtView = "SELECT R.RentID, RT.RentType, O.FName + ' ' + O.MName + ' ' + O.LName AS OwnerName,";
StmtView += "R.Availability, R.Image, R.Furnished, R.BedRooms, R.BathRooms,R.floar,R.fors,R.parking, R.Sqft, R.Amount, R.Negotiable,";
StmtView += " O.Addrs, O.Mobile, O.Landline, O.City, O.State, O.Email FROM Owner_Details AS O INNER JOIN";
StmtView += " Tbl_RentDetails AS R ON O.OwnerID = R.OwnerID INNER JOIN RentTypeDetails AS RT ON R.RentTypeID = RT.RentTypeID";
rptr_View.DataSource = Rent.D_set(StmtView, "RentDetails").Tables[0];
rptr_View.DataBind();
ddl_Type.Items.Add("Select Rent Type");
drtype = Rent.ReadData("Select RentTypeID,RentType from RentTypeDetails");
if (drtype.HasRows)
{
while (drtype.Read())
{
ListItem item = new ListItem();
item.Value = drtype["RentTypeID"].ToString();
item.Text = drtype["RentType"].ToString();
ddl_Type.Items.Add(item);
}
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
rptr_RentType.DataSource = Rent.D_set("select * from Tbl_UserDetails", "UserDetails").Tables[0];
rptr_RentType.DataBind();
}
}
protected void dd_for_SelectedIndexChanged(object sender, EventArgs e)
{
string StmtView = "SELECT R.RentID, RT.RentType, O.FName + ' ' + O.MName + ' ' + O.LName AS OwnerName,";
StmtView += "R.Availability, R.Image, R.Capasity, R.bathroom, R.gender,R.wifi,R.security,R.mess, R.Sqft, R.Amount,";
StmtView += " O.Addrs, O.Mobile, O.Landline, O.City, O.State, O.Email FROM Owner_Details AS O INNER JOIN";
StmtView += " PG AS R ON O.OwnerID = R.OwnerID INNER JOIN RentTypeDetails AS RT ON R.RentTypeID = RT.RentTypeID where RT.RentType='" + ddl_Type.Text + "' and R.gender='" + dd_for.Text + "'";
rptr_View.DataSource = Rent.D_set(StmtView, "RentDetails").Tables[0];
rptr_View.DataBind();
}
protected void lnk_Delete(object sender, EventArgs e)
{
int result = Rent.DeltRec("delete from Tbl_RentDetails where RentID=" + ((LinkButton)(sender)).CommandArgument);
if (result == 1)
{
Response.Write("<script>alert('Rent Deleted Successfully...!');</script>");
rptr_Rent.DataSource = Rent.D_set("SELECT R.RentID, RT.RentType, O.FName + ' ' + O.MName + ' ' + O.LName AS OwnerName, R.Availability, R.Furnished, R.BedRooms, R.BathRooms, R.Sqft, R.Amount, R.Negotiable FROM Owner_Details AS O INNER JOIN Tbl_RentDetails AS R ON O.OwnerID = R.OwnerID INNER JOIN RentTypeDetails AS RT ON R.RentTypeID = RT.RentTypeID", "RentDetails").Tables[0];
rptr_Rent.DataBind();
}
}
protected void lnk_Delete(object sender, EventArgs e)
{
int result = Rent.DeltRec("delete from Tbl_UserDetails where UserID=" + ((LinkButton)(sender)).CommandArgument);
if (result == 1)
{
Response.Write("<script>alert('Feedback Deleted Successfully...!');</script>");
rptr_RentType.DataSource = Rent.D_set("select * from Tbl_UserDetails", "UserDetails").Tables[0];
rptr_RentType.DataBind();
}
}
protected void lnk_Delete(object sender, EventArgs e)
{
int result = Rent.DeltRec("delete from Owner_Details where OwnerID=" + ((LinkButton)(sender)).CommandArgument);
if (result == 1)
{
Response.Write("<script>alert('Owner Deleted Successfully...!');</script>");
rptr_Owner.DataSource = Rent.D_set("SELECT OwnerID, FName + ' ' + MName + ' ' + LName AS [Owner Name], Addrs, Mobile, Landline, City, State,Email FROM Owner_Details", "RentTypeDetails").Tables[0];
rptr_Owner.DataBind();
}
}
protected void lnk_Delete(object sender, EventArgs e)
{
int result = Rent.DeltRec("delete from RentTypeDetails where RentTypeID=" + ((LinkButton)(sender)).CommandArgument);
if (result == 1)
{
//Response.Write("Record Deleted Who's Year ID is : " + ((LinkButton)(sender)).CommandArgument);
Response.Write("<script>alert('RentType Deleted Successfully...!');</script>");
rptr_RentType.DataSource = Rent.D_set("select * from RentTypeDetails", "RentTypeDetails").Tables[0];
rptr_RentType.DataBind();
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
rptr_RentType.DataSource = Rent.D_set("select * from RentTypeDetails", "RentDetails").Tables[0];
rptr_RentType.DataBind();
if (Request.QueryString["msg"] != null)
{
if (Request.QueryString["msg"].ToString() == "0")
{
Response.Write("<script>alert('Rent Type updated Successfully...!');</script>");
}
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
rptr_Rent.DataSource = Rent.D_set("SELECT R.RentID, RT.RentType, O.FName + ' ' + O.MName + ' ' + O.LName AS OwnerName, R.Availability, R.Furnished, R.BedRooms, R.BathRooms, R.Sqft, R.Amount, R.Negotiable FROM Owner_Details AS O INNER JOIN Tbl_RentDetails AS R ON O.OwnerID = R.OwnerID INNER JOIN RentTypeDetails AS RT ON R.RentTypeID = RT.RentTypeID", "RentDetails").Tables[0];
rptr_Rent.DataBind();
if (Request.QueryString["msg"] != null)
{
if (Request.QueryString["msg"].ToString() == "0")
{
Response.Write("<script>alert('Rent Details updated Successfully...!');</script>");
}
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
rptr_Owner.DataSource = Rent.D_set("SELECT OwnerID, FName + ' ' + MName + ' ' + LName AS [Owner Name], Addrs, Mobile, Landline, City, State,Email FROM Owner_Details", "OwnerDetails").Tables[0];
rptr_Owner.DataBind();
if (Request.QueryString["msg"] != null)
{
if (Request.QueryString["msg"].ToString() == "0")
{
Response.Write("<script>alert('Owner Details updated Successfully...!');</script>");
}
}
}
}
protected void ddl_Type_SelectedIndexChanged(object sender, EventArgs e)
{
if (ddl_Type.SelectedIndex > 0)
{
string StmtView = "SELECT R.RentID, RT.RentType, O.FName + ' ' + O.MName + ' ' + O.LName AS OwnerName,";
StmtView += "R.Availability, R.Image, R.Furnished, R.BedRooms, R.BathRooms,R.floar,R.fors,R.parking, R.Sqft, R.Amount, R.Negotiable,";
StmtView += " O.Addrs, O.Mobile, O.Landline, O.City, O.State, O.Email FROM Owner_Details AS O INNER JOIN";
StmtView += " Tbl_RentDetails AS R ON O.OwnerID = R.OwnerID INNER JOIN RentTypeDetails AS RT ON R.RentTypeID = RT.RentTypeID where RT.RentType='" + ddl_Type.SelectedItem + "'";
rptr_View.DataSource = Rent.D_set(StmtView, "RentDetails").Tables[0];
rptr_View.DataBind();
}
else
{
string StmtView = "SELECT R.RentID, RT.RentType, O.FName + ' ' + O.MName + ' ' + O.LName AS OwnerName,";
StmtView += "R.Availability, R.Image, R.Furnished, R.BedRooms, R.BathRooms, R.Sqft, R.Amount, R.Negotiable,";
StmtView += " O.Addrs, O.Mobile, O.Landline, O.City, O.State, O.Email FROM Owner_Details AS O INNER JOIN";
StmtView += " Tbl_RentDetails AS R ON O.OwnerID = R.OwnerID INNER JOIN RentTypeDetails AS RT ON R.RentTypeID = RT.RentTypeID";
rptr_View.DataSource = Rent.D_set(StmtView, "RentDetails").Tables[0];
rptr_View.DataBind();
}
}
