private static void TestDeleteDatabase()
{
using (var db = new RealEstateModel())
{
db.Database.Delete();
}
}
protected void Button1_Click1(object sender, EventArgs e)
{
RealEstateModel db = new RealEstateModel();
Agent a = new Agent();
a.CEANumber = txtCEANumber.Text;
a.Email = txtEmail.Text;
a.AgencyID = int.Parse(ddlAgencyID.SelectedItem.Value);
a.SalesPersonName = txtSalesPersonName.Text;
a.SalesPersonMobileNumber = txtSalesPersonMobileNumber.Text;
db.Agents.Add(a);
db.SaveChanges();
if (FileUpload1.HasFile)
{
try
{
FileUpload1.SaveAs(Server.MapPath("~/Images/Agents/") + a.AgentID + ".jpg");
Label3.Text = "Upload Status:File Uploaded Successfully.";
}
catch (Exception ex)
{
Label3.Text = "Upload Status:File could not be uploaded." +
"The following error occured:" + ex.Message;
}
}
a.ProfilePicture = a.AgentID + ".jpg";
db.SaveChanges();
GridView1.DataBind();
// SqlDataSource1.Insert();
}
public RealEstateFullMonthlyReport(RealEstateModel realEstateModel) : this()
{
aServicesDataTable = connection.getRealEstateAppartmentsServices(realEstateModel.RealEstateID);
aServicesPaymentsDataTable = connection.getMonthlyAppartmentServicesPaymentsReport(realEstateModel.RealEstateID);
rServicesDataTable = connection.getRealestateServicesExpencesReport();
this.realEstateModel = realEstateModel;
realEstate.Text = realEstateModel.RealEstateNumber;
ownerID.Text = realEstateModel.Owner;
getYears();
rServicesDataTable = connection.Table(rServicesDataTable, rServicesDataTable.Select("realestateID = " + realEstateModel.RealEstateID));
aServices.DataSource = aServicesDataTable;
aServicesPayments.DataSource = aServicesPaymentsDataTable;
rServices.DataSource = rServicesDataTable;
double payments_total = checkNull(aServicesDataTable.Compute("SUM(total)", "").ToString());
dues1.Text = payments_total + "";
double to_be_paid = checkNull(aServicesPaymentsDataTable.Compute("SUM(total)", "").ToString());
payments1.Text += to_be_paid;
appartmentsResult.Text = (payments_total - to_be_paid) + "";
double total_real_estate = checkNull(rServicesDataTable.Compute("SUM(total)", "").ToString());
totalRealEstate.Text = total_real_estate + "";
getServices();
}
internal void CreateAdmin()
{
RealEstateModel db = new RealEstateModel();
IdentityResult IdRoleResult;
IdentityResult IdUserResult;
var roleStore = new RoleStore <IdentityRole>(db);
var roleMgr = new RoleManager <IdentityRole>(roleStore);
if (!roleMgr.RoleExists("Administrator"))
{
IdRoleResult = roleMgr.Create(new IdentityRole("Administrator"));
}
var userMgr = new UserManager <ApplicationUser>(new UserStore <ApplicationUser>(db));
var appUser = new ApplicationUser()
{
UserName = "******",
};
IdUserResult = userMgr.Create(appUser, "admin");
if (IdUserResult.Succeeded)
{
IdUserResult = userMgr.AddToRole(appUser.Id, "Administrator");
}
}
public RealEstateRow(RealEstateModel realEstateModel) : this()
{
btn.Visible = true;
this.realEstateModel = realEstateModel;
estateNumber.Text = realEstateModel.RealEstateNumber;
owner.Text = realEstateModel.Owner;
address.Text = realEstateModel.Address;
}
public RentersList(RealEstateModel realEstateModel) : this()
{
try
{
this.realEstateModel = realEstateModel;
estate.Text += realEstateModel.ToString();
}
catch { }
}
/**
* Self made event Handler
* It is called from the child component
* giving all needed information about the real estate class
*/
public void handledForm(AddNewRealEstate realEstateFrom)
{
if (realEstateFrom.isHandled)
{
RealEstateInterface buffer = new RealEstateModel(realEstateFrom.realEstateComponents);
this.addInternalStorage(buffer);
this.addToDataGrid(buffer);
}
}
public IQueryable <PropertyType> GetPropertyTypes()
{
RealEstateModel ct = new RealEstateModel();
IQueryable <PropertyType> q;
q = ct.PropertyTypes;
List <PropertyType> types = q.ToList();
return(q);
}
public IEnumerable <TEAM11REALESTATE.Models.PropertyImage> RepeaterPropertyImages_GetData()
{
var db = new RealEstateModel();
IQueryable <PropertyImage> q = null;
if (propertyID.HasValue)
{
// int temp = (int)propertyID;
q = db.PropertyImages.Where(i => i.PropertyID == (int)propertyID);
}
return(q);
}
private static void TestDatabase(bool insertData = false)
{
try
{
Console.Write("Creating context . . .");
using (var db = new RealEstateModel())
{
Console.WriteLine(" Done!");
if (insertData)
{
Console.WriteLine();
Console.Write("Inserting data . . .");
var prop = new Property {
Name = "Broj soba", Value = "5"
};
db.Properties.Add(prop);
db.SaveChanges();
Console.WriteLine(" Done!");
}
Console.WriteLine();
Console.WriteLine("Printing data:");
Console.WriteLine();
var query = from p in db.Properties select p;
foreach (var item in query)
{
Console.WriteLine($"{item.Name}: {item.Value}");
}
Console.WriteLine();
Console.WriteLine("Done!");
}
}
catch (Exception ex)
{
Console.WriteLine();
Console.WriteLine(ex.GetType().FullName);
Console.WriteLine();
Console.WriteLine(ex.Message);
if (ex.InnerException != null)
{
Console.WriteLine();
Console.Write("Inner exception: ");
Console.WriteLine(ex.InnerException.GetType().FullName);
Console.WriteLine();
Console.WriteLine(ex.InnerException.Message);
}
}
}
public AppartmentList(RealEstateModel realEstateModel) : this()
{
try
{
this.realEstateModel = realEstateModel;
estate.Text += realEstateModel.ToString();
NOA.Text += Connection.getAppartments().Select("buildingID=" + realEstateModel.RealEstateID).CopyToDataTable().Rows.Count;
getAppartments();
NOAA.Text += Connection.getAppartments().Select("buildingID=" + realEstateModel.RealEstateID + " AND rented = 0").CopyToDataTable().Rows.Count;
}
catch { }
}
protected void btnInsert_Click(object sender, EventArgs e)
{
//con.Open();
//SqlCommand cmd = con.CreateCommand();
//cmd.CommandType = CommandType.Text;
//cmd.CommandText = ("INSERT INTO Addresses (UnitNumber,BlockNumber,StreetName,PostalCode,Email,Mobile,Phone) values('"
// + tbUnitnum.Text.ToString()
// + "','" + tbblknum.Text.ToString()
// + "','" + tbStreet.Text.ToString()
// + "','" + tbPostcode.Text.ToString()
// + "','" + tbEmail.Text.ToString()
// + "','" + tbMobile.Text.ToString()
// + "','" + tbPhone.Text.ToString() + "')");
//cmd.ExecuteNonQuery();
//con.Close();
RealEstateModel ctx = new RealEstateModel();
Address addr = new Address();
addr.UnitNumber = tbUnitnum.Text.ToString();
addr.BlockNumber = tbblknum.Text.ToString();
addr.StreetName = tbStreet.Text.ToString();
addr.PostalCode = tbPostcode.Text.ToString();
addr.Email = tbEmail.Text.ToString();
addr.Mobile = tbMobile.Text.ToString();
addr.Phone = tbPhone.Text.ToString();
ctx.Addresses.Add(addr);
ctx.SaveChanges();
List <Address> AddrList = ctx.Addresses.ToList();
AddrList.Count().ToString();
Address LastAddr = new Address();
LastAddr = AddrList.Last();
con.Open();
SqlCommand cmd1 = con.CreateCommand();
cmd1.CommandType = CommandType.Text;
cmd1.CommandText = ("INSERT INTO Sellers (SellerName, AddressID) VALUES ('" + tbName.Text.ToString() + "'," + LastAddr.AddressID.ToString() + ")");
cmd1.ExecuteNonQuery();
con.Close();
Response.Redirect("SellerMainPage.aspx");
}
public void getRealEstates()
{
DataRow[] rows = connection.getRealEstates().Select();
RealEstateModel realEstateModel;
foreach (var item in rows)
{
//string address = item["country"].ToString() + " / " + item["state"].ToString() + " / " + item["city"].ToString() + " / " + item["address"].ToString();
realEstateModel = new RealEstateModel(item["Owner"].ToString(), item["ID"].ToString(), item["Location"].ToString(), item["estateNumber"].ToString());
new RealEstateRow(realEstateModel).Parent = flowLayoutPanel1;
}
}
// The id parameter should match the DataKeyNames value set on the control
// or be decorated with a value provider attribute, e.g. [QueryString]int id
public IQueryable <Property> GetProduct([QueryString("PropertyID")] int?id)
{
var db = new RealEstateModel();
IQueryable <Property> q = db.Properties;
if (id.HasValue && id > 0)
{
propertyID = id;
q = q.Where(p => p.PropertyID == id);
}
else
{
q = null;
}
return(q);
}
protected void btn_Save_Click(object sender, EventArgs e)
{
RealEstateModel context = new RealEstateModel();
Address addss = new Address();
addss.UnitNumber = tbx_UnitNumber.Text;
addss.BlockNumber = tbx_BlockNumber.Text;
addss.StreetName = tbx_StreetName.Text;
addss.PostalCode = tbx_PostalCode.Text;
addss.Email = tbx_Email.Text;
addss.Mobile = tbx_Mobile.Text;
addss.Phone = tbx_OfficePh.Text;
addss.Website = tbx_Website.Text;
context.Addresses.Add(addss);
context.SaveChanges();
Agency agenc = new Agency();
agenc.AgencyName = tbx_AgencyName.Text;
agenc.AddressID = addss.AddressID;
//tried
//string v = context.Addresses.Where(x => x.PostalCode.Equals(tbx_PostalCode.Text)).Select(x => x.AddressID).ToString();
//agenc.AddressID = Convert.ToInt32(v);
//agenc.Address.UnitNumber = addss.UnitNumber;
//agenc.Address.BlockNumber = addss.BlockNumber;
//agenc.Address.StreetName = addss.StreetName;
//agenc.Address.PostalCode = addss.PostalCode;
//agenc.Address.Email = addss.Email;
//agenc.Address.Mobile = addss.Mobile;
//agenc.Address.Phone = addss.Phone;
//agenc.Address.Website = addss.Website;
context.Agencies.Add(agenc);
context.SaveChanges();
Response.Redirect("AgencyMain.aspx");
}
protected void btnSubmitPropery_Click(object sender, EventArgs e)
{
RealEstateModel db = new RealEstateModel();
Property p = new Property();
Address a = new Address();
a.PostalCode = txtPostCode.Text;
a.BlockNumber = txtBlockNumber.Text;
a.StreetName = txtStreetName.Text;
a.UnitNumber = txtUnitNumber.Text;
db.Addresses.Add(a);
db.SaveChanges();
p.ProperName = txtPropertyName.Text;
p.Description = txtaDescription.Text;
p.PricePSF = int.Parse(txtPricePSF.Text);
p.Rooms = txtRooms.Text;
p.SizePSF = int.Parse(txtSizePSF.Text);
p.SellerID = int.Parse(ddlSeller.SelectedValue);
p.AgentID = int.Parse(ddlAgent.SelectedValue);
p.DistrictID = int.Parse(ddlDistrict.SelectedValue);
p.PropertyTopDate = DateTime.Today;
p.LeaseStartDate = DateTime.Today;
p.PropertyTypeID = int.Parse(ddlPropertyType.SelectedValue);
p.AddressID = a.AddressID;
db.Properties.Add(p);
db.SaveChanges();
PropertyImage image = new PropertyImage();
image.PropertyID = p.PropertyID;
db.PropertyImages.Add(image);
db.SaveChanges();
image.PropertyImageName = image.PropertyImageID + ".jpg";
FileUpload1.SaveAs(Server.MapPath("~/Images/Properties/") + image.PropertyImageName);
Util.ShowMessage("Address ID: " + p.AddressID + " " + image.PropertyImageID, this.GetType(), this);
db.SaveChanges();
}
public IQueryable<RealEstateModel> Add(RealEstateDetailsRequestModel model)
{
var list = new List<RealEstateModel>();
var newRealEstate = new RealEstateModel
{
Title = model.Title,
Description = model.Description,
Address = model.Address,
Contact = model.Contact,
SellingPrice = model.SellingPrice,
RentingPrice = model.RentingPrice,
Type = model.Type
};
this.realEstateModel.Add(newRealEstate);
list.Add(newRealEstate);
this.realEstateModel.SaveChanges();
return list.AsQueryable();
}
static App()
{
var options = new ChromeOptions();
options.AddArguments("--disable-gpu");
options.AddArguments("--headless");
options.AddArguments("--silent");
options.AddArguments("--log-level=3");
var service = ChromeDriverService.CreateDefaultService();
service.HideCommandPromptWindow = true;
var driver = new ChromeDriver(service, options);
AppContext.Inject(driver);
var db = new RealEstateModel();
db.Database.CommandTimeout = 180;
AppContext.Inject(db);
}
// The return type can be changed to IEnumerable, however to support
// paging and sorting, the following parameters must be added:
// int maximumRows
// int startRowIndex
// out int totalRowCount
// string sortByExpression
public IQueryable <Property> GetProperties([Control("DDPropertyType")] string type,
[Control("DropDownMinPrice")] string minPrice,
[Control("DropDownMaxPrice")] string maxPrice,
[Control("DropDownRoom")] string rooms)
{
IQueryable <Property> q;
RealEstateModel ct = new RealEstateModel();
q = ct.Properties;
if (DDPropertyType.Text != null && !DDPropertyType.Text.Equals("Any Type") && type != null)
{
// ct.PropertyTypes.Where(t=>t.)
q = q.Where(p => p.PropertyType.TypeName == type);
}
if (DropDownMinPrice.Text != null && !DropDownMinPrice.Text.Equals("Any Price") && minPrice != null)
{
// ct.PropertyTypes.Where(t=>t.)
int price = int.Parse(minPrice, NumberStyles.Currency);
q = q.Where(p => p.PricePSF * p.SizePSF > price);
}
if (DropDownMaxPrice.Text != null && !DropDownMaxPrice.Text.Equals("Any Price") && maxPrice != null)
{
// ct.PropertyTypes.Where(t=>t.)
int price = int.Parse(maxPrice, NumberStyles.Currency);
q = q.Where(p => p.PricePSF * p.SizePSF < price);
}
if (DropDownRoom.Text != null && !DropDownRoom.Text.Equals("Any") && rooms != null)
{
q = q.Where(p => p.Rooms.Equals(rooms));
}
return(q);
}
/**
* Load entries from given txt file with right structer
*/
private void loadEntries_Click(object sender, EventArgs e)
{
string line;
OpenFileDialog entriesFileOpen = new OpenFileDialog();
entriesFileOpen.DefaultExt = FILE_DEFAULT_EXTENSION;
entriesFileOpen.Filter = FILE_FILTER;
if (entriesFileOpen.ShowDialog() == System.Windows.Forms.DialogResult.OK)
{
StreamReader file = new StreamReader(entriesFileOpen.FileName);
while ((line = file.ReadLine()) != null)
{
List <string> realEstateParameters = line.Split('\t').ToList();
RealEstateInterface buffer = new RealEstateModel(realEstateParameters);
this.addInternalStorage(buffer);
this.addToDataGrid(buffer);
}
file.Close();
}
}
public IQueryable <District> GetDistricts()
{
RealEstateModel db = new RealEstateModel();
return(db.Districts);
}
public IQueryable <Agent> GetAgents()
{
RealEstateModel db = new RealEstateModel();
return(db.Agents);
}
public IQueryable <TEAM11REALESTATE.Models.Seller> GetSellers()
{
RealEstateModel db = new RealEstateModel();
return(db.Sellers);
}
public IQueryable <PropertyType> GetPropertyTypes()
{
RealEstateModel db = new RealEstateModel();
return(db.PropertyTypes);
}
public RealEsateDialog(RealEstateModel realEstateModel) : this()
{
this.realEstateModel = realEstateModel;
realEstate.Text = realEstateModel.ToString();
}
