public void GetDetails()
{
// Arrange
var mockSet = new Mock <DbSet <Appartment> >();
var data = new List <Appartment>
{
new Appartment {
Id = 1
},
}.AsQueryable();
mockSet.As <IQueryable <Appartment> >().Setup(m => m.Provider).Returns(data.Provider);
mockSet.As <IQueryable <Appartment> >().Setup(m => m.Expression).Returns(data.Expression);
mockSet.As <IQueryable <Appartment> >().Setup(m => m.ElementType).Returns(data.ElementType);
mockSet.As <IQueryable <Appartment> >().Setup(m => m.GetEnumerator()).Returns(data.GetEnumerator());
var mockContext = new Mock <ApplicationDbContext>();
mockContext.Setup(m => m.Appartments).Returns(mockSet.Object);
var controller = new EstateController(mockContext.Object);
// Act
var result = controller.Details(1) as ViewResult;
// Assert
var model = result.Model as Appartment;
Assert.Equal(1, model.Id);
}
private void IsSoldEditor_Load(object sender, EventArgs e)
{
// TODO: This line of code loads data into the 'realboligDataSet2.Customers' table. You can move, or remove it, as needed.
this.customersTableAdapter1.Fill(this.realboligDataSet2.Customers);
// TODO: This line of code loads data into the 'realboligDataSet4.Customers' table. You can move, or remove it, as needed.
this.customersTableAdapter.Fill(this.realboligDataSet4.Customers);
List <Estate> estates = EstateController.GetNotSoldEstates();
if (estates == null)
{
MessageBox.Show("");
}
foreach (var item in estates)
{
Adresses.Items.Add(item.Adress + " " + item.Postal.ToString() + " " + item.City);
}
List <Agent> agents = UserController.GetAgentDBAsList();
foreach (Agent a in agents)
{
cBox_agents.Items.Add(a.Name);
}
}
public void TryDelete()
{
// Arrange
var mockSet = new Mock <DbSet <Appartment> >();
var data = new List <Appartment>
{
new Appartment {
Id = 1
},
}.AsQueryable();
mockSet.As <IQueryable <Appartment> >().Setup(m => m.Provider).Returns(data.Provider);
mockSet.As <IQueryable <Appartment> >().Setup(m => m.Expression).Returns(data.Expression);
mockSet.As <IQueryable <Appartment> >().Setup(m => m.ElementType).Returns(data.ElementType);
mockSet.As <IQueryable <Appartment> >().Setup(m => m.GetEnumerator()).Returns(data.GetEnumerator());
var mockContext = new Mock <ApplicationDbContext>();
mockContext.Setup(m => m.Appartments).Returns(mockSet.Object);
var controller = new EstateController(mockContext.Object);
// Act
var result = controller.Delete(1) as RedirectToActionResult;
// Assert
Assert.Equal("Manage", result.ActionName);
}
private void button6_Click(object sender, EventArgs e)
{
try
{
int price = EstateController.GetPrice(txtCityGetPrice.Text, int.Parse(txtSpaceGetPrice.Text));
lblPrice.Text = price.ToString();
}catch
{
MessageBox.Show("Numeric values wasn't numeric, or no simular estates found");
}
}
private void button5_Click(object sender, EventArgs e)
{
var Row = GetDataRow(table_Estate);
Boolean success = EstateController.DeleteEstate(int.Parse(Row.Cells[0].Value.ToString()));
if (!success)
{
MessageBox.Show("Delete failed");
}
else
{
UpdateData();
}
}
private void InitializeComponents()
{
file = null;
id = 1;
estateController = new EstateController();
DeleteButton.Enabled = false;
ChangeButton.Enabled = false;
InfoButton.Enabled = false;
CountryOption.DataSource = Enum.GetValues(typeof(Countries));
LegalFormOption.DataSource = Enum.GetValues(typeof(LegalForm));
TypeOption.DropDownStyle = ComboBoxStyle.DropDownList;
CountryOption.DropDownStyle = ComboBoxStyle.DropDownList;
LegalFormOption.DropDownStyle = ComboBoxStyle.DropDownList;
}
public void TryManage()
{
var fakeHttpContext = new Mock <HttpContext>();
var fakeIdentity = new GenericIdentity("User");
var principal = new GenericPrincipal(fakeIdentity, null);
fakeHttpContext.Setup(t => t.User).Returns(principal);
var controllerContext = new Mock <ControllerContext>();
controllerContext.Setup(t => t.HttpContext).Returns(fakeHttpContext.Object);
var mockSet = new Mock <DbSet <Appartment> >();
var data = new List <Appartment>
{
new Appartment {
Id = 1
},
new Appartment {
Id = 2
},
}.AsQueryable();
mockSet.As <IQueryable <Appartment> >().Setup(m => m.Provider).Returns(data.Provider);
mockSet.As <IQueryable <Appartment> >().Setup(m => m.Expression).Returns(data.Expression);
mockSet.As <IQueryable <Appartment> >().Setup(m => m.ElementType).Returns(data.ElementType);
mockSet.As <IQueryable <Appartment> >().Setup(m => m.GetEnumerator()).Returns(data.GetEnumerator());
var mockContext = new Mock <ApplicationDbContext>();
mockContext.Setup(m => m.Appartments).Returns(mockSet.Object);
var controller = new EstateController(mockContext.Object);
//Set your controller ControllerContext with fake context
controller.ControllerContext = controllerContext.Object;
// Act
var result = controller.Manage() as ViewResult;
// Assert
var model = result.Model as AppartmentsListModel;
Assert.Equal(data.Count(), model.Appartments.Count());
}
private void button4_Click(object sender, EventArgs ev)
{
try
{
Estate e = new Estate();
e.Adress = txtAdressUpdate.Text;
e.Postal = int.Parse(txtPostalUpdate.Text);
e.City = txtCityUpdate.Text;
e.Image = txtImageUpdate.Text;
e.SpaceM2 = int.Parse(txtSpaceUpdate.Text);
e.Price = int.Parse(txtPriceUpdate.Text);
e.isSold = checkIsSold.Checked;
EstateController.UpdateEstate(int.Parse(lblIDUpdate.Text), e);
UpdateData();
}catch
{
MessageBox.Show("Either a DB connection failure or an input value wasn't a whole number");
}
}
private void btnAction_Click(object sender, EventArgs e)
{
Boolean success = false;
if (type == "purchase")
{
success = EstateController.SellEstate(adress, customerID ?? default(int), agentID ?? default(int));
if (success)
{
MessageBox.Show("Estate sold");
}
else
{
MessageBox.Show("Something went wrong");
}
}
else if (type == "view")
{
this.Close();
}
}
private void button3_Click(object sender, EventArgs e)
{
History[,] houses = EstateController.ConvertListTo2DArray(EstateController.GetEstatedFromPeriod(dateTimePicker1.Value, dateTimePicker2.Value));
List <History> histories = new List <History>();
for (int i = 0; i < houses.GetLength(0); i++)
{
for (int j = 0; j < houses.GetLength(1); j++)
{
if (houses[i, j] != null)
{
if (houses[i, j].Paid > Int32.Parse(textBox1.Text))
{
histories.Add(houses[i, j]);
}
}
}
}
dataGridView3.DataSource = histories;
}
private void button1_Click(object sender, EventArgs e)
{
Estate est = new Estate();
est.Adress = txtAdressCreate.Text;
est.City = txtCityCreate.Text;
est.Postal = int.Parse(txtPostalCreate.Text);
est.SpaceM2 = int.Parse(txtSpaceCreate.Text);
est.Price = int.Parse(txtPriceCreate.Text);
est.Image = txtImageCreate.Text;
Boolean success = EstateController.CreateEstate(GetSellerID(comboBox1.Text), GetAgentID(comboBox2.Text), est);
if (!success)
{
MessageBox.Show("An error has occured");
}
else
{
MessageBox.Show("Changes created");
}
UpdateData();
}
private void button1_Click_1(object sender, EventArgs e)
{
if (txtCitySearch.Text == "")
{
MessageBox.Show("No city was given");
return;
}
if (txtSpaceSearch.Text == "")
{
MessageBox.Show("No space was given");
return;
}
if (int.TryParse(txtSpaceSearch.Text, out int x))
{
List <Estate> es = EstateController.Search(txtCitySearch.Text, x);
dataGridView1.DataSource = es;
if (es.Count() == 0)
{
MessageBox.Show("No estates with the given data were found");
return;
}
int totalPriceOfSold = 0;
int totalPriceOfNotSold = 0;
int numOfSold = 0;
int numOfNotSold = 0;
foreach (var item in es)
{
if (item.isSold == true)
{
totalPriceOfSold = totalPriceOfSold + item.Price;
numOfSold++;
}
else
{
totalPriceOfNotSold = totalPriceOfNotSold + item.Price;
numOfNotSold++;
}
}
int avragePriceOfSold = 0;
int avragePriceOfNotSold = 0;
if (numOfNotSold != 0)
{
avragePriceOfNotSold = totalPriceOfNotSold / numOfNotSold;
}
if (numOfSold != 0)
{
avragePriceOfSold = totalPriceOfSold / numOfSold;
}
lblAvrPriceOfNotSold.Text = avragePriceOfNotSold.ToString();
lblAvrPriceOfSold.Text = avragePriceOfSold.ToString();
}
else
{
MessageBox.Show("Please only use whole numbers for the space");
}
}
private void UpdateData()
{
table_Estate.DataSource = EstateController.GetEstatesAsList();
}
