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(); }