private void LoadGrid() { DataSet ds; ds = new HouseDAO().SelectAllDataset(); ds.Tables[0].PrimaryKey = new DataColumn[] { ds.Tables[0].Columns["HouseId"] }; gvPropertyList.SettingsText.ConfirmDelete = Messages.Delete_Confirm; gvPropertyList.DataSource = ds.Tables[0]; gvPropertyList.DataBind(); }
public bool Save() { bool result = false; Database db = DatabaseFactory.CreateDatabase(Constants.CONNECTIONSTRING); DbConnection connection = db.CreateConnection(); connection.Open(); DbTransaction transaction = connection.BeginTransaction(); try { HouseDAO houseDAO = new HouseDAO(); //If landlord user is a partial user, this logic might need to change if (!new LandlordDAO().IsLandlordExist(new Landlord() { LandlordId = this.LandlordId })) { new Landlord() { LandlordId = this.LandlordId, LandlordTypeId = (int)Enums.LandlordType.SimpleLandlord, CreatedBy = this.CreatedBy }.Save(); } if (houseDAO.IsHouseExist(this)) { result = houseDAO.Update(this, db, transaction); } else { result = houseDAO.Insert(this, db, transaction); } if (result) { transaction.Commit(); } else { transaction.Rollback(); } } catch (System.Exception ex) { transaction.Rollback(); result = false; throw ex; } finally { connection.Close(); } return(result); }
public bool Save(House house) { bool result = false; Database db = DatabaseFactory.CreateDatabase(Constants.CONNECTIONSTRING); DbConnection connection = db.CreateConnection(); connection.Open(); DbTransaction transaction = connection.BeginTransaction(); try { HouseDAO houseDAO = new HouseDAO(); // House house = new House(); if (houseDAO.IsHouseExist(house)) { result = new HouseOptionDAO().Delete(new HouseOption() { HouseId = house.HouseId.Value }, db, transaction); if (house.HouseOptionList != null) { foreach (HouseOption item in house.HouseOptionList) { new HouseOptionDAO().Insert(item, db, transaction); } } } if (result) { transaction.Commit(); } else { transaction.Rollback(); } } catch (System.Exception ex) { transaction.Rollback(); result = false; throw ex; } finally { connection.Close(); } return(result); }
public bool Save(House house) { bool result = false; Database db = DatabaseFactory.CreateDatabase(Constants.CONNECTIONSTRING); DbConnection connection = db.CreateConnection(); connection.Open(); DbTransaction transaction = connection.BeginTransaction(); try { HouseDAO houseDAO = new HouseDAO(); // House house = new House(); if (houseDAO.IsHouseExist(house)) { result = new HouseOptionDAO().Delete(new HouseOption() { HouseId = house.HouseId.Value }, db, transaction); if (house.HouseOptionList != null) { foreach (HouseOption item in house.HouseOptionList) { new HouseOptionDAO().Insert(item, db, transaction); } } } if (result) { transaction.Commit(); } else { transaction.Rollback(); } } catch (System.Exception ex) { transaction.Rollback(); result = false; throw ex; } finally { connection.Close(); } return result; }
protected void FindHome_Click(object sender, EventArgs e) { StudentSearchresults.Visible = false; HouseSearch house = new HouseSearch(); HouseDAO houseDAO = new HouseDAO(); house.Zip = string.IsNullOrEmpty(Zipcode.Text.Trim()) ? null : Zipcode.Text.Trim(); if (DrpBedRooms.SelectedItem.Value != "-1") { house.BedRooms = int.Parse(DrpBedRooms.SelectedItem.Value); } else { house.BedRooms = null; } if (DrpBathRooms.SelectedItem.Value != "-1") { house.BathRooms = int.Parse(DrpBathRooms.SelectedItem.Value); } else { house.BathRooms = null; } DataSet ds; ds = houseDAO.Search(house); if (ds != null) { DataListHouseSearchresults.DataSource = ds.Tables[0]; DataListHouseSearchresults.DataBind(); HouseSearchresults.Visible = true; } else { Searchresults.Visible = true; } }
public void loadHouseDatadata(User user_) { if (user_.HouseId != null && user_.HouseId != Guid.Empty) { UserDAO userDAO = new UserDAO(); DataSet LandlordData = userDAO.SelectLandlordByHouseId(user_.HouseId.Value); if (LandlordData != null && LandlordData.Tables[0].Rows.Count > 0) { hdLandloadId.Value = string.IsNullOrEmpty(LandlordData.Tables[0].Rows[0]["LandlordId"].ToString().Trim()) ? string.Empty : LandlordData.Tables[0].Rows[0]["LandlordId"].ToString().Trim(); } DataSet ds = new DataSet(); ds = new HouseDAO().SelectAllDataset(Guid.Parse(hdLandloadId.Value)); ds.Tables[0].PrimaryKey = new DataColumn[] { ds.Tables[0].Columns["HouseId"] }; if (DrpHouse.Items.Count < 1) { DrpHouse.DataSource = ds; DrpHouse.DataTextField = "StreetAddress"; DrpHouse.DataValueField = "HouseId"; DrpHouse.DataBind(); DrpHouse.Items.Insert(0, new ListItem(Constants.DROPDOWN_EMPTY_ITEM_TEXT, Constants.DROPDOWN_EMPTY_ITEM_VALUE)); } HouseEdit.Visible = true; // set selected house if (user_.HouseId.HasValue) { for (int i = 0; i < DrpHouse.Items.Count; i++) { if (DrpHouse.Items[i].Value.ToString().ToLower() == user_.HouseId.ToString().ToLower()) { DrpHouse.ClearSelection(); DrpHouse.Items[i].Selected = true; } } } House houseData = House.Select(user_.HouseId.Value); if (houseData != null) { if (houseData.IsPartialHouse == true) { // HouseSearch.Visible = true; chknotavailable.Visible = true; DrpHouse.Enabled = true; EnableEdit(); if (houseData.StateId.HasValue) { for (int i = 0; i < Drpstate.Items.Count; i++) { if (Drpstate.Items[i].Value.ToString().ToLower() == houseData.StateId.ToString().ToLower()) { Drpstate.ClearSelection(); Drpstate.Items[i].Selected = true; } } State state; state = Generic.Get<State>(houseData.StateId.Value); if (state != null) { State.Text = state.StateName; } } Address.Text = houseData.StreetAddress; City.Text = houseData.City; Zip.Text = houseData.Zip; RentalAddress.Text = houseData.StreetAddress; RentalCity.Text = houseData.City; RentalZip.Text = houseData.Zip; } else { Page.ClientScript.RegisterStartupScript(this.GetType(), "Redirect", "window.onload = function(){ alert('" + Messages.CurrentHouseNotPartialHouse + "'); window.location = '/Student/Student_Profile_Current_House_Details.aspx';}", true); } } } else { Page.ClientScript.RegisterStartupScript(this.GetType(), "Redirect", "window.onload = function(){ alert('" + Messages.CurrentHouseNoRecords + "'); window.location = '/Student/Student_Profile_Current_House.aspx';}", true); } }
public static House SelectByRoomId(Guid baseHouseRoomId) { House house = new HouseDAO().SelectByRoomId(baseHouseRoomId); return(house); }
public DataSet SelectAllDataset(Guid LandlordId) { HouseDAO house = new HouseDAO(); return(house.SelectAllDataset(LandlordId)); }
public void loadHouseDatadata() { House_Search.Visible = false; DrpHouse.Visible = false; DrpHouse.Items.Clear(); DataSet ds = new DataSet(); ds = new HouseDAO().SelectAllDataset(Guid.Parse(hdLandloadId.Value)); ds.Tables[0].PrimaryKey = new DataColumn[] { ds.Tables[0].Columns["HouseId"] }; if (ds.Tables[0].Rows.Count > 0) { LabelRentalAddressMessage.Text = ""; House_Search.Visible = true; DrpHouse.Visible = true; showHouseDetails(); if (DrpHouse.Items.Count < 1) { DrpHouse.DataSource = ds; DrpHouse.DataTextField = "StreetAddress"; DrpHouse.DataValueField = "HouseId"; DrpHouse.DataBind(); DrpHouse.Items.Insert(0, new ListItem(Constants.DROPDOWN_EMPTY_ITEM_TEXT, Constants.DROPDOWN_EMPTY_ITEM_VALUE)); } else { } } else { LabelRentalAddressMessage.Text = "No House Registerd for Landlord, Please Contact Landlord to Add a New House."; LabelRentalAddressMessage.Visible = true; ButtonLandload.Visible = false; ClearHouse(); } }
public void CreateHouse() { if (Page.IsValid == true) { try { house.LandlordId = Guid.Parse(Membership.GetUser().ProviderUserKey.ToString()); house.StreetAddress = Address.Text.Trim(); house.City = City.Text.Trim(); house.StateId = Int32.Parse(Drpstate.SelectedValue.Trim()); house.Zip = Zip.Text.Trim(); house.YearHomeBuild = int.Parse(DRPYear.SelectedValue.Trim()); house.BedRooms = int.Parse(DrpBedRooms.SelectedValue.Trim()); house.BathRooms = int.Parse(DrpBathRooms.SelectedValue.Trim()); house.LotSquareFootage = LotSQFootage.Text.Trim() == string.Empty ? 0 : Int32.Parse(LotSQFootage.Text.Trim()); house.TotalSquareFootage = TotalSQFootage.Text.Trim() == string.Empty ? 0 : Int32.Parse(TotalSQFootage.Text.Trim()); house.UtilitiesIncludedInRent = Utilities.Text.Trim(); house.Price = Convert.ToDecimal(Price.Text.ToString().Trim()); house.UpdatedBy = Guid.Parse(Membership.GetUser().ProviderUserKey.ToString());// user.UserId.Value; house.CreatedBy = Guid.Parse(Membership.GetUser().ProviderUserKey.ToString());// user.UserId.Value; if (house.Save()) { DataSet ds; ds = new HouseDAO().SelectAllDataset(house.LandlordId); ds.Tables[0].PrimaryKey = new DataColumn[] { ds.Tables[0].Columns["HouseId"] }; Session[Constants.SESSION_HOUSELIST] = ds; string houseid = house.HouseId.ToString(); //This can be used everywhere to call java script and parameters. Page.ClientScript.RegisterStartupScript(this.GetType(), "Redirect", "window.onload = function(){ alert('" + Messages.Save_Success + "'); window.location = '/Land_load/Land_Load_House_Option_Add.aspx?HouseId=" + house.HouseId.ToString() + "'; }", true); } else { Page.ClientScript.RegisterStartupScript(this.GetType(), "Redirect", "window.onload = function(){ alert('" + Messages.Save_Unsuccess + "'); }", true); //Save error } } catch (Exception ex) { Page.ClientScript.RegisterStartupScript(this.GetType(), "Redirect", "window.onload = function(){ alert('" + Messages.Save_Unsuccess + "'); }", true); } } }
public DataSet SelectAllDataset(Guid LandlordId) { HouseDAO house = new HouseDAO(); return house.SelectAllDataset(LandlordId); }
public bool Save() { bool result = false; Database db = DatabaseFactory.CreateDatabase(Constants.CONNECTIONSTRING); DbConnection connection = db.CreateConnection(); connection.Open(); DbTransaction transaction = connection.BeginTransaction(); try { HouseDAO houseDAO = new HouseDAO(); //If landlord user is a partial user, this logic might need to change if (!new LandlordDAO().IsLandlordExist(new Landlord() { LandlordId = this.LandlordId })) { new Landlord() { LandlordId = this.LandlordId, LandlordTypeId = (int)Enums.LandlordType.SimpleLandlord, CreatedBy = this.CreatedBy }.Save(); } if (houseDAO.IsHouseExist(this)) { result = houseDAO.Update(this, db, transaction); } else { result = houseDAO.Insert(this, db, transaction); } if (result) { transaction.Commit(); } else { transaction.Rollback(); } } catch (System.Exception ex) { transaction.Rollback(); result = false; throw ex; } finally { connection.Close(); } return result; }
public static House SelectByRoomId(Guid baseHouseRoomId) { House house = new HouseDAO().SelectByRoomId(baseHouseRoomId); return house; }