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