public long Insert(PROPERTY entytiy)
{
K21T3_Team1_PPC3129Entities model = new K21T3_Team1_PPC3129Entities();
db.PROPERTY.Add(entytiy);
db.SaveChanges();
return(entytiy.ID);
}
public ActionResult ChangePassword(string oldpass, string newpass, string conpass)
{
int id = (int)Session["UserID"];
var userdetail = model.USER.FirstOrDefault(x => x.ID == id);
if (userdetail.Password == oldpass)
{
if (newpass == conpass)
{
userdetail.Password = newpass;
model.SaveChanges();
return(RedirectToAction("ViewDetail", "Account"));
}
}
return(View());
}
public ActionResult Create(PROPERTY p)
{
var property = new PROPERTY();
property.PropertyName = p.PropertyName;
property.Avatar = p.Avatar;
property.PropertyType_ID = p.PropertyType_ID;
property.Content = p.Content;
property.Street_ID = p.Street_ID;
property.Ward_ID = p.Ward_ID;
property.District_ID = p.District_ID;
property.UnitPrice = p.UnitPrice;
property.Area = p.Area;
property.BedRoom = p.BedRoom;
property.BathRoom = p.BathRoom;
property.PackingPlace = p.PackingPlace;
property.UserID = p.UserID;
property.Created_at = p.Created_at;
property.Create_post = p.Create_post;
property.Status_ID = p.Status_ID;
property.Note = p.Note;
property.Updated_at = p.Updated_at;
property.Sale_ID = p.Sale_ID;
db.PROPERTY.Add(property);
db.SaveChanges();
return(RedirectToAction("Index"));
}
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 ActionResult createPropertyType(PROPERTY_TYPE p)
{
var testcodetype = db.PROPERTY_TYPE.Where(x => x.CodeType == p.CodeType);
var testDescription = db.PROPERTY_TYPE.Where(x => x.Description == p.Description);
p.Status = true;
if (testcodetype.Count() == 0)
{
if (testDescription.Count() == 0)
{
db.PROPERTY_TYPE.Add(p);
db.SaveChanges();
TempData["create"] = "Loại dự án mới đã được tạo thành công";
return(RedirectToAction("Index", "PropertyType"));
}
}
ViewBag.mess = "Loại dự án bị trùng vui lòng nhập lại loại dự án";
return(View());
}
public ActionResult Edit(ABOUT_US about_us)
{
var content = db.ABOUT_US.FirstOrDefault(x => x.ID == 2);
content.Contents = about_us.Contents;
content.Adress = about_us.Adress;
content.Sale_ID = 3;
content.Update_day = DateTime.Parse(DateTime.Now.ToShortDateString());
db.SaveChanges();
return(View());
}
public ActionResult ChangePassword(string oldpass, string newpass, string conpass)
{
int id = (int)Session["UserID"];
var userdetail = model.USER.FirstOrDefault(x => x.ID == id);
if (userdetail.Password == oldpass)
{
if (newpass == conpass)
{
userdetail.Password = newpass;
model.SaveChanges();
TempData["changepassword"] = "******";
Session["FullName"] = null;
Session["UserID"] = null;
Session["UserRole"] = null;
return(RedirectToAction("Login", "Account"));
}
}
return(View());
}
public void InsertPropertyToDB(Table Property)
{
using (db)
{
foreach (var row in Property.Rows)
{
string propertyID = row["Property Type"];
string userID = row["Owner"];
string wardID = row["Ward"];
string districtID = row["District"];
string streetID = row["Street"];
string statusID = row["Status"];
var property = new PROPERTY
{
PropertyName = row["PropertyName"],
Price = int.Parse(row["Price"]),
Avatar = row["Avatar"],
Images = row["Images"],
UnitPrice = row["UnitPrice"],
Ward_ID = db.WARD.FirstOrDefault(d => d.WardName == wardID).ID,
UserID = db.USER.FirstOrDefault(d => d.Email == userID).ID,
Street_ID = db.STREET.FirstOrDefault(d => d.StreetName == streetID).ID,
District_ID = db.DISTRICT.FirstOrDefault(d => d.DistrictName == districtID).ID,
Area = row["Area"],
BedRoom = int.Parse(row["BedRoom"]),
BathRoom = int.Parse(row["BathRoom"]),
PackingPlace = int.Parse(row["ParkingPlace"]),
Created_at = DateTime.Parse(row["Created_at"]),
Create_post = DateTime.Parse(row["Created_post"]),
Note = row["Note"],
Updated_at = DateTime.Parse(row["Updated_at"]),
Status_ID = db.PROJECT_STATUS.FirstOrDefault(d => d.Status_Name == statusID).ID,
//Property_ID = row["Property_ID"],
Content = row["Content"],
PropertyType_ID = db.PROPERTY_TYPE.FirstOrDefault(d => d.CodeType == propertyID).ID,
};
_context.ReferenceProject.Add(
Property.Header.Contains("ID") ? row["ID"] : property.PropertyName,
property);
db.PROPERTY.Add(property);
}
//db.Entry(Property).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
}
}
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 InserttoDB(Table us)
{
using (db)
{
foreach (var row in us.Rows)
{
var user = new USER
{
Email = row["email"],
Password = row["password"],
FullName = row["fullname"],
Phone = row["phone"],
Address = row["address"],
Role = row["role"],
Status = true,
};
_content.ReferenceUsers.Add(us.Header.Contains("ID") ? row["ID"] : user.Email, user);
db.USER.Add(user);
}
db.SaveChanges();
}
}
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();
}
}