public void InsertProjectToDB(Table projects)
{
using (var db = new K21T1_Team4Entities1())
{
var oStreets = db.STREETs.ToList();
foreach (var item in projects.Rows)
{
var tPropertyType = item["PropertyType"].ToString();
var tStreet_ID = item["Street"].ToString();
var tDistrict_ID = item["District"].ToString();
var tPropertyName = item["PropertyName"].ToString();
var a = db.PROPERTY_TYPE.FirstOrDefault(d1 => d1.CodeType == tPropertyType);
var b = db.STREETs.FirstOrDefault(s => s.StreetName == tStreet_ID);
var c = db.DISTRICTs.FirstOrDefault(d2 => d2.DistrictName == tDistrict_ID);
PROPERTY project = new PROPERTY()
{
PropertyName = item["PropertyName"].ToString(),
PropertyType_ID = a.ID,
Street_ID = db.STREETs.FirstOrDefault(s => s.StreetName == tStreet_ID).ID,
District_ID = db.DISTRICTs.FirstOrDefault(d => d.DistrictName == tDistrict_ID).ID
};
_context.ReferenceDetails.Add(projects.Header.Contains("ID") ? item["ID"] : project.PropertyName, project);
db.PROPERTies.Add(project);
}
}
}
public void Showlistapproved()
{
var db = new K21T1_Team4Entities1();
var viewlist = db.PROPERTies.OrderByDescending(m => m.Create_post).Where(p => p.PROJECT_STATUS.Status_Name == "Đã duyệt" || p.PROJECT_STATUS.Status_Name == "Hết hạn").ToList();
using (var controller = new SaleController())
{
_result = controller.Index();
}
}
public void CleanDatabase()
{
using (var db = new K21T1_Team4Entities1())
{
db.PROPERTY_IMAGE.RemoveRange(db.PROPERTY_IMAGE);
db.PROPERTY_FEATURE.RemoveRange(db.PROPERTY_FEATURE);
db.PROPERTies.RemoveRange(db.PROPERTies);
db.SaveChanges();
}
}
public void ClickDetail(string propertyName)
{
var db = new K21T1_Team4Entities1();
int id = db.PROPERTies.FirstOrDefault(r => r.PropertyName == propertyName).ID;
using (var controller = new HomeController())
{
_result = controller.Viewlistofproject();
}
}
public void OpenPropertyDetails(string PropertyName)
{
var db = new K21T1_Team4Entities1();
int _Id = db.PROPERTies.FirstOrDefault(r => r.PropertyName == PropertyName).ID;
using (var controller = new viewDetailController())
{
_result = controller.Index(_Id);
}
}
public void InsertProjectToDB(Table projects)
{
using (var db = new K21T1_Team4Entities1())
{
var oStreets = db.STREETs.ToList();
foreach (var item in projects.Rows)
{
var tPropertyType = item["PropertyType"].ToString();
var tStreet_ID = item["Street"].ToString();
var tDistrict_ID = item["District"].ToString();
var tWard_ID = item["Ward"].ToString();
var tPropertyName = item["PropertyName"].ToString();
var tUnitPrice = item["UnitPrice"].ToString();
var tContent = item["Content"].ToString();
var a = db.PROPERTY_TYPE.FirstOrDefault(d1 => d1.CodeType == tPropertyType);
var b = db.STREETs.FirstOrDefault(s => s.StreetName == tStreet_ID);
var c = db.DISTRICTs.FirstOrDefault(d2 => d2.DistrictName == tDistrict_ID);
var d3 = db.WARDs.FirstOrDefault(d2 => d2.WardName == tWard_ID);
PROPERTY project = new PROPERTY()
{
PropertyName = item["PropertyName"].ToString(),
PropertyType_ID = a.ID,
Street_ID = db.STREETs.FirstOrDefault(s => s.StreetName == tStreet_ID).ID,
District_ID = db.DISTRICTs.FirstOrDefault(d => d.DistrictName == tDistrict_ID).ID,
Ward_ID = db.WARDs.FirstOrDefault(d => d.WardName == tWard_ID).ID,
UnitPrice = item["UnitPrice"].ToString(),
Price = int.Parse(item["Price"].ToString()),
BathRoom = int.Parse(item["Bathroom"].ToString()),
BedRoom = int.Parse(item["Bedroom"].ToString()),
PackingPlace = int.Parse(item["PackingPlace"].ToString()),
Content = item["Content"].ToString(),
Area = "20m2",
};
//project.STREET = db.STREETs.Find(project.Street_ID);
// project.STREET.StreetName
_context.ReferenceDetails.Add(projects.Header.Contains("ID") ? item["ID"] : project.PropertyName, project);
db.PROPERTies.Add(project);
}
db.SaveChanges();
}
}
internal void ShouldShowAbout(object showAbout)
{
var db = new K21T1_Team4Entities1();
var viewlist = db.ABOUTs.ToList();
}
public void ShouldShowNews(object shownews)
{
var db = new K21T1_Team4Entities1();
var viewlist = db.NEWs.OrderByDescending(m => m.Created_at).ToList();
}
