public long Insert(PROPERTY entytiy)
{
K21T3_Team1_PPC3129Entities model = new K21T3_Team1_PPC3129Entities();
db.PROPERTY.Add(entytiy);
db.SaveChanges();
return(entytiy.ID);
}
public void CleanDatabase()
{
using (var db = new K21T3_Team1_PPC3129Entities())
{
//db.OrderLines.RemoveRange(db.OrderLines);
//db.Orders.RemoveRange(db.Orders);
db.PROPERTY.RemoveRange(db.PROPERTY);
db.SaveChanges();
}
}
public void CleanDatabase()
{
using (var db = new K21T3_Team1_PPC3129Entities())
{
var un = db.USER.Where(x => x.ID > 9).ToList();
db.PROPERTY.RemoveRange(db.PROPERTY);
db.USER.RemoveRange(un);
db.SaveChanges();
}
}
public void Login(string email, string password)
{
agency = new PPCRental_Project.Controllers.AccountController();
db = new K21T3_Team1_PPC3129Entities();
us = db.USER.FirstOrDefault(d => d.Email == email);
var moqContext = new Moq.Mock <ControllerContext>();
var moqSession = new Moq.Mock <HttpSessionStateBase>();
moqContext.Setup(c => c.HttpContext.Session).Returns(moqSession.Object);
agency.ControllerContext = moqContext.Object;
moqSession.Setup(s => s["UserRole"]).Returns("1");
us.Email = email;
us.Password = password;
agency.Login(email, password);
}
public void InsertProjecttoDB(Table givenProjects)
{
using (var db = new K21T3_Team1_PPC3129Entities())
{
foreach (var row in givenProjects.Rows)
{
var property = new PROPERTY
{
PropertyName = row["PropertyName"],
Avatar = row["Avarta"],
Images = row["Images"],
Content = row["Content"],
PropertyType_ID = int.Parse(row["PropertyType"]),
Street_ID = int.Parse(row["Street"]),
Ward_ID = int.Parse(row["Ward"]),
District_ID = int.Parse(row["District"]),
Price = int.Parse(row["Price"]),
UnitPrice = row["UnitPrice"],
Area = row["Area"],
BedRoom = int.Parse(row["BedRoom"]),
BathRoom = int.Parse(row["BathRoom"]),
PackingPlace = int.Parse(row["PackingPlace"]),
UserID = int.Parse(row["UserID"]),
Created_at = Convert.ToDateTime(row["Create_at"]),
Create_post = Convert.ToDateTime(row["Create_post"]),
Status_ID = int.Parse(row["Status"]),
Note = row["Note"],
Updated_at = Convert.ToDateTime(row["Update_at"]),
Sale_ID = int.Parse(row["Sale_ID"])
};
_context.ReferenceProject.Add(
givenProjects.Header.Contains("Id") ? row["Id"] : property.PropertyName,
property);
db.PROPERTY.Add(property);
}
db.SaveChanges();
}
}
public void Search(string district, string PropertyType, int BedRoom, int BathRoom, int Price_Min, int Price_Max)
{
int districtID = 0;
int TypeID = 0;
using (var ab = new K21T3_Team1_PPC3129Entities())
{
if (district != "0")
{
districtID = ab.DISTRICT.FirstOrDefault(x => x.DistrictName == district).ID;
}
if (PropertyType != "0")
{
TypeID = ab.PROPERTY_TYPE.FirstOrDefault(x => x.CodeType == PropertyType).ID;
}
}
var controllerProject = new ProjectController();
_result = controllerProject.Search(districtID, TypeID, BedRoom, BathRoom, Price_Min, Price_Max);
}
public void GetListFromViewListOfProject()
{
K21T3_Team1_PPC3129Entities get = new K21T3_Team1_PPC3129Entities();
AccountController user = new AccountController();
var controller = new PropertyAgencyController();
var moqContext = new Moq.Mock <ControllerContext>();
var moqSession = new Moq.Mock <HttpSessionStateBase>();
moqContext.Setup(c => c.HttpContext.Session).Returns(moqSession.Object);
var us = get.USER.FirstOrDefault(x => x.Email == "*****@*****.**");
//user.ControllerContext = moqContext.Object;
controller.ControllerContext = moqContext.Object;
moqSession.Setup(s => s["UserRole"]).Returns(us.Role);
moqSession.Setup(s => s["UserID"]).Returns(us.ID);
_result = controller.Index();
}
public void ShowPropertyDetails(Table shownPropertyDetails)
{
//Arrange
K21T3_Team1_PPC3129Entities dbt = new K21T3_Team1_PPC3129Entities();
var expectedPropertyDetails = shownPropertyDetails.Rows.Single();
string exPropertyName = expectedPropertyDetails["PropertyName"];
string exAvatar = expectedPropertyDetails["Avatar"];
string exOwner = expectedPropertyDetails["Owner"];
var userID = dbt.USER.FirstOrDefault(d => d.Email == exOwner).ID;
string exContent = expectedPropertyDetails["Content"];
string exPrice = expectedPropertyDetails["Price"];
//Act
var actualPropertyDetails = _result.Model <PROPERTY>();
//Assert
actualPropertyDetails.Should().Match <PROPERTY>(
b => b.PropertyName == exPropertyName &&
b.Avatar == exAvatar &&
b.UserID == userID &&
b.Content == exContent &&
b.Price == int.Parse(exPrice));
}
public void InsertProjecttoDB(Table givenProjects)
{
using (var db = new K21T3_Team1_PPC3129Entities())
{
foreach (var row in givenProjects.Rows)
{
var property = new PROPERTY
{
PropertyName = row["PropertyName"],
Content = row["Content"],
PropertyType_ID = db.PROPERTY_TYPE.ToList().FirstOrDefault(d => d.CodeType == row["PropertyType"]).ID,
Street_ID = db.STREET.ToList().FirstOrDefault(d => d.StreetName == row["Street"]).ID,
Ward_ID = db.WARD.ToList().FirstOrDefault(d => d.WardName == row["Ward"]).ID,
District_ID = db.DISTRICT.ToList().FirstOrDefault(d => d.DistrictName == row["District"]).ID,
Price = int.Parse(row["Price"]),
UnitPrice = row["UnitPrice"],
Area = row["Area"],
BedRoom = int.Parse(row["BedRoom"]),
BathRoom = int.Parse(row["BathRoom"]),
PackingPlace = int.Parse(row["PackingPlace"]),
UserID = int.Parse(row["UserID"]),
Created_at = Convert.ToDateTime(row["Create_at"]),
Create_post = Convert.ToDateTime(row["Create_post"]),
Status_ID = db.PROJECT_STATUS.ToList().FirstOrDefault(x => x.Status_Name == row["Status"]).ID,
Note = row["Note"],
Updated_at = Convert.ToDateTime(row["Update_at"]),
Sale_ID = int.Parse(row["Sale_ID"])
};
_context.ReferenceProject.Add(
givenProjects.Header.Contains("Id") ? row["Id"] : property.PropertyName,
property);
db.PROPERTY.Add(property);
}
db.SaveChanges();
}
}
public void CreateProperty(Table inputproperty)
{
var row = inputproperty.Rows[0];
using (var db = new K21T3_Team1_PPC3129Entities())
{
var property = new PROPERTY
{
PropertyName = row["PropertyName"],
Content = row["Content"],
PropertyType_ID = db.PROPERTY_TYPE.ToList().FirstOrDefault(d => d.CodeType == row["PropertyType"]).ID,
Street_ID = db.STREET.ToList().FirstOrDefault(d => d.StreetName == row["Street"]).ID,
Ward_ID = db.WARD.ToList().FirstOrDefault(d => d.WardName == row["Ward"]).ID,
District_ID = db.DISTRICT.ToList().FirstOrDefault(d => d.DistrictName == row["District"]).ID,
Price = int.Parse(row["Price"]),
UnitPrice = row["UnitPrice"],
Area = row["Area"],
BedRoom = int.Parse(row["BedRoom"]),
BathRoom = int.Parse(row["BathRoom"]),
PackingPlace = int.Parse(row["PackingPlace"]),
UserID = int.Parse(row["UserID"]),
Created_at = Convert.ToDateTime(row["Create_at"]),
Create_post = Convert.ToDateTime(row["Create_post"]),
Status_ID = db.PROJECT_STATUS.ToList().FirstOrDefault(x => x.Status_Name == row["Status"]).ID,
Note = row["Note"],
Updated_at = Convert.ToDateTime(row["Update_at"]),
Sale_ID = int.Parse(row["Sale_ID"])
};
//Save book item into ScenarioContext object so that we can get it in the next step (UploadImage)
ScenarioContext.Current.Add("property", property);
//Save the create action into ScenarioContext object so that we can get it in the next step (UploadImage)
ScenarioContext.Current.Add("isCreated", "Y");
//_result = _controller.Create(book);
}
}
