public ActionResult Edit(int id, PROPERTY p, List <string> feature)
{
PROPERTY proper = model.PROPERTies.Find(p.ID);
var property = model.PROPERTies.FirstOrDefault(x => x.ID == id);
var feat = model.PROPERTY_FEATURE.Where(x => x.Property_ID == p.ID).ToList();
model.PROPERTY_FEATURE.RemoveRange(feat);
property.PropertyName = p.PropertyName;
property.UnitPrice = p.UnitPrice;
property.Price = p.Price;
property.BathRoom = p.BathRoom;
property.BedRoom = p.BedRoom;
property.Content = p.Content;
property.Create_post = p.Create_post;
property.Created_at = p.Created_at;
property.DISTRICT = p.DISTRICT;
property.STREET = p.STREET;
property.WARD = p.WARD;
property.Area = p.Area;
property.Status_ID = p.Status_ID;
foreach (var featu in feature)
{
PROPERTY_FEATURE proferty_fea = new PROPERTY_FEATURE();
proferty_fea.Feature_ID = model.FEATUREs.SingleOrDefault(x => x.FeatureName == featu).ID;
proferty_fea.Property_ID = p.ID;
model.PROPERTY_FEATURE.Add(proferty_fea);
}
model.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Create(PROPERTY prop, HttpPostedFileBase Avatar, List <HttpPostedFileBase> Image, List <int> chkfeature)//?
{
string path1 = "";
if (Avatar != null)
{
string ava = "";
if (Avatar.ContentLength > 0)
{
var filename = Path.GetFileName(Avatar.FileName);
path1 = Path.Combine(Server.MapPath("/Images/"), filename);
Avatar.SaveAs(path1);
ava = filename;
}
prop.Avatar = ava;
}
string path2 = "";
foreach (var item in Image)
{
if (item != null)
{
try
{
var filename2 = Path.GetFileName(item.FileName);
path2 = Path.Combine(Server.MapPath("~/Images/"), filename2);
item.SaveAs(path2);
prop.Images += filename2 + ",";
}
catch
{
ViewBag.mgs = "error";
return(View("IndexAgency"));
}
}
}
foreach (int fe in chkfeature)
{
PROPERTY_FEATURE fea = new PROPERTY_FEATURE();
fea.Feature_ID = db.FEATUREs.SingleOrDefault(x => x.ID == fe).ID;
fea.Property_ID = prop.ID;
db.PROPERTY_FEATURE.Add(fea);
}
prop.Created_at = DateTime.Now;
prop.Status_ID = 1;
prop.UserID = int.Parse(Session["UserID"].ToString());
db.PROPERTies.Add(prop);
db.SaveChanges();
return(RedirectToAction("IndexAgency"));
}
public ActionResult AddProject(PROPERTY model, HttpPostedFileBase Avatar, List <string> chk1, List <HttpPostedFileBase> images)
{
if (Avatar != null)
{
string avatar = "";
if (Avatar.ContentLength > 0)
{
var filename = Path.GetFileName(Avatar.FileName);
var path = Path.Combine(Server.MapPath("~/Images/"), filename);
Avatar.SaveAs(path);
avatar = filename;
}
model.Avatar = avatar;
}
foreach (var fe in chk1)
{
PROPERTY_FEATURE profe = new PROPERTY_FEATURE();
profe.Feature_ID = db.FEATUREs.SingleOrDefault(x => x.FeatureName == fe).ID;
profe.Property_ID = model.ID;
db.PROPERTY_FEATURE.Add(profe);
}
foreach (HttpPostedFileBase img in images)
{
if (img != null)
{
if (img.ContentLength > 0)
{
var filename = Path.GetFileName(img.FileName);
var path = Path.Combine(Server.MapPath("~/Images/"), filename);
img.SaveAs(path);
PROPERTY_IMAGE ppti = new PROPERTY_IMAGE();
ppti.Image = filename;
ppti.Property_ID = model.ID;
db.PROPERTY_IMAGE.Add(ppti);
}
}
else
{
break;
}
}
model.Created_at = DateTime.Now;
model.Create_post = DateTime.Now;
model.UserID = int.Parse(Session["UserID"].ToString());
model.Status_ID = 1;
db.PROPERTies.Add(model);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult PostProject(HttpPostedFileBase Avatar, PROPERTY property, List <HttpPostedFileBase> Images, PostModel model, List <string> feature)
{
if (ModelState.IsValid)
{
string avatar = "";
if (Avatar.ContentLength > 0)
{
var filename = Path.GetFileName(Avatar.FileName);
var path = Path.Combine(Server.MapPath("~/img"), filename);
Avatar.SaveAs(path);
avatar = filename;
}
//add picture
foreach (HttpPostedFileBase img in Images)
{
if (img != null)
{
if (img.ContentLength > 0)
{
var filename = Path.GetFileName(img.FileName);
var path = Path.Combine(Server.MapPath("~/img/"), filename);
img.SaveAs(path);
PICTURE pic = new PICTURE();
pic.Name_Image = filename;
pic.Property_id = property.ID;
db.PICTUREs.Add(pic);
}
}
else
{
break;
}
}
//string image = "";
//if (Image.ContentLength > 0)
//{
// var filename = Path.GetFileName(Image.FileName);
// var path = Path.Combine(Server.MapPath("~/img"), filename);
// Image.SaveAs(path);
// image = filename;
//}
var pro = new PROPERTY();
pro.PropertyName = model.PropertyName;
pro.PropertyType_ID = model.PropertyType_ID;
pro.Avatar = avatar;
//pro.Images = image;
//pro.DISTRICT = model.DISTRICT;
pro.District_ID = model.District_ID;
pro.Street_ID = model.Street_ID;
pro.Ward_ID = model.Ward_ID;
//pro.STREET = model.STREET;
pro.Price = model.Price;
pro.Area = model.Area;
pro.BathRoom = model.BathRoom;
pro.BedRoom = model.BedRoom;
pro.PackingPlace = model.PackingPlace;
pro.Content = model.Content;
pro.UnitPrice = model.UnitPrice;
//add feature
var fetur = new PROPERTY_FEATURE();
if (feature != null)
{
foreach (string fetus in feature)
{
//PROPERTY_FEATURE profeature = new PROPERTY_FEATURE();
// fetur.Property_ID = qqq.ID;
fetur.Feature_ID = db.FEATUREs.SingleOrDefault(x => x.FeatureName == fetus).ID;
fetur.Property_ID = property.ID;
//fetur.Feature_ID = 1;
db.PROPERTY_FEATURE.Add(fetur);
}
}
pro.Status_ID = model.Status_ID;
pro.Updated_at = DateTime.Now;
pro.Created_at = DateTime.Now;
pro.UserID = (int)Session["UserID"];
db.PROPERTies.Add(pro);
db.SaveChanges();
//ViewBag.Success = "Đăng ký thành công";
model = new PostModel();
return(RedirectToAction("List", "Project"));
}
else
{
ModelState.AddModelError("", "Đăng bài không thành công, vui lòng kiểm tra lại các trường thông tin của bạn");
}
return(View(model));
}
public ActionResult saveDraftPost(PROPERTY e, HttpPostedFileBase Avatar, List <string> chk1, List <HttpPostedFileBase> images)
{
if (Session["UserID"] == null)
{
return(View("Login"));
}
//Avatar save file on webserver and sign value for model
if (Avatar != null)
{
string avatar = "";
if (Avatar.ContentLength > 0)
{
var filename = Path.GetFileName(Avatar.FileName);
var path = Path.Combine(Server.MapPath("~/Images/"), filename);
Avatar.SaveAs(path);
avatar = filename;
}
e.Avatar = avatar;
}
//Image save file on webserver and add new PROPERTY_IMAGE into table PROPERTY_IMAGE
foreach (HttpPostedFileBase img in images)
{
if (img != null)
{
if (img.ContentLength > 0)
{
var filename = Path.GetFileName(img.FileName);
var path = Path.Combine(Server.MapPath("~/Images/"), filename);
img.SaveAs(path);
PROPERTY_IMAGE ppti = new PROPERTY_IMAGE();
ppti.Image = filename;
ppti.Property_ID = e.ID;
m.PROPERTY_IMAGE.Add(ppti);
}
}
else
{
break;
}
}
//save PROPERTY_FEATURE into PROPERTY_FEATURE table foreach Feature
if (chk1 != null)
{
foreach (string fe in chk1)
{
PROPERTY_FEATURE profe = new PROPERTY_FEATURE();
profe.Feature_ID = m.FEATUREs.SingleOrDefault(x => x.FeatureName == fe).ID;
profe.Property_ID = e.ID;
m.PROPERTY_FEATURE.Add(profe);
}
}
e.Created_at = DateTime.Now;
e.Create_post = DateTime.Now;
e.UserID = int.Parse(Session["UserID"].ToString());
e.Status_ID = 2;
if (e.PropertyName == null)
{
e.PropertyName = "NULL";
}
if (e.Content == null)
{
e.Content = "NULL";
}
if (e.Price == null)
{
e.Price = 0;
}
if (e.Area == null)
{
e.Area = "NULL";
}
m.PROPERTies.Add(e);
m.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult EditProject1(PROPERTY model, HttpPostedFileBase Avatar, List <string> chk1, List <HttpPostedFileBase> images)
{
PROPERTY pro = db.PROPERTies.Find(model.ID);
var ftpr = db.PROPERTY_FEATURE.Where(x => x.Property_ID == model.ID).ToList();
var imag = db.PROPERTY_IMAGE.Where(x => x.Property_ID == model.ID);
db.PROPERTY_FEATURE.RemoveRange(ftpr);
db.PROPERTY_IMAGE.RemoveRange(imag);
if (Avatar != null)
{
string avatar = "";
if (Avatar.ContentLength > 0)
{
var filename = Path.GetFileName(Avatar.FileName);
var path = Path.Combine(Server.MapPath("~/Images/"), filename);
Avatar.SaveAs(path);
avatar = filename;
}
pro.Avatar = avatar;
}
foreach (HttpPostedFileBase img in images)
{
if (img != null)
{
if (img.ContentLength > 0)
{
var filename = Path.GetFileName(img.FileName);
var path = Path.Combine(Server.MapPath("~/Images/"), filename);
img.SaveAs(path);
PROPERTY_IMAGE ppti = new PROPERTY_IMAGE();
ppti.Image = filename;
ppti.Property_ID = model.ID;
db.PROPERTY_IMAGE.Add(ppti);
}
else
{
db.SaveChanges();
}
}
else
{
db.SaveChanges();
}
}
foreach (var fe in chk1)
{
PROPERTY_FEATURE profe = new PROPERTY_FEATURE();
profe.Feature_ID = db.FEATUREs.SingleOrDefault(x => x.FeatureName == fe).ID;
profe.Property_ID = pro.ID;
db.PROPERTY_FEATURE.Add(profe);
}
pro.PropertyName = model.PropertyName;
pro.PropertyType_ID = model.PropertyType_ID;
pro.Content = model.Content;
pro.Street_ID = model.Street_ID;
pro.Ward_ID = model.Ward_ID;
pro.District_ID = model.District_ID;
pro.Price = model.Price;
pro.UnitPrice = model.UnitPrice;
pro.Area = model.Area;
pro.BedRoom = model.BedRoom;
pro.BathRoom = model.BathRoom;
pro.PackingPlace = model.PackingPlace;
pro.Status_ID = model.Status_ID;
pro.Note = model.Note;
pro.Updated_at = DateTime.Now;
pro.Sale_ID = int.Parse(Session["UserID"].ToString());
db.Entry(pro).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Create(PROPERTY property, string submit)
{
try
{
property.Avatar = AvatarU(property);
property.Images = ImagesU(property);
property.Created_at = DateTime.Now;
property.Create_post = DateTime.Now; // sua lai sau
property.UnitPrice = "VND";
if (submit == "Post")
{
property.Status_ID = 1;
}
else
{
property.Status_ID = 2;
}
property.UserID = (int)Session["UserID"];
if (ModelState.IsValid)
{
long idd = insertproperty(property);
PROPERTY_FEATURE pf = new PROPERTY_FEATURE();
if (property.listfeature != null)
{
foreach (string x in property.listfeature)
{
pf.Property_ID = (int)idd;
pf.Feature_ID = int.Parse(x);
db.PROPERTY_FEATURE.Add(pf);
db.SaveChanges();
}
}
else
{
db.SaveChanges();
}
TempData["create"] = "Dự án đã được thêm thành công";
return(RedirectToAction("Index"));
}
}
catch (Exception)
{
try
{
property.Avatar = "~/Images/NullImage.jpg";
property.Images = ImagesU(property);
property.Created_at = DateTime.Now;
property.Create_post = DateTime.Now; // sua lai sau
property.UnitPrice = "VND";
if (submit == "Post")
{
property.Status_ID = 1;
}
else
{
property.Status_ID = 2;
}
property.UserID = (int)Session["UserID"];
if (ModelState.IsValid)
{
long idd = insertproperty(property);
PROPERTY_FEATURE pf = new PROPERTY_FEATURE();
if (property.listfeature != null)
{
foreach (string x in property.listfeature)
{
pf.Property_ID = (int)idd;
pf.Feature_ID = int.Parse(x);
db.PROPERTY_FEATURE.Add(pf);
db.SaveChanges();
}
}
else
{
db.SaveChanges();
}
TempData["create"] = "Dự án đã được thêm thành công";
return(RedirectToAction("Index"));
}
}
catch (Exception)
{
try
{
property.Avatar = AvatarU(property);
property.Created_at = DateTime.Now;
property.Create_post = DateTime.Now; // sua lai sau
property.UnitPrice = "VND";
if (submit == "Post")
{
property.Status_ID = 1;
}
else
{
property.Status_ID = 2;
}
property.UserID = (int)Session["UserID"];
if (ModelState.IsValid)
{
long idd = insertproperty(property);
PROPERTY_FEATURE pf = new PROPERTY_FEATURE();
if (property.listfeature != null)
{
foreach (string x in property.listfeature)
{
pf.Property_ID = (int)idd;
pf.Feature_ID = int.Parse(x);
db.PROPERTY_FEATURE.Add(pf);
db.SaveChanges();
}
}
else
{
db.SaveChanges();
}
TempData["create"] = "Dự án đã được thêm thành công";
return(RedirectToAction("Index"));
}
}
catch (Exception)
{
property.Created_at = DateTime.Now;
property.Create_post = DateTime.Now; // sua lai sau
property.UnitPrice = "VND";
if (submit == "Post")
{
property.Status_ID = 1;
}
else
{
property.Status_ID = 2;
}
property.UserID = (int)Session["UserID"];
if (ModelState.IsValid)
{
long idd = insertproperty(property);
PROPERTY_FEATURE pf = new PROPERTY_FEATURE();
if (property.listfeature != null)
{
foreach (string x in property.listfeature)
{
pf.Property_ID = (int)idd;
pf.Feature_ID = int.Parse(x);
db.PROPERTY_FEATURE.Add(pf);
db.SaveChanges();
}
}
else
{
db.SaveChanges();
}
TempData["create"] = "Dự án đã được thêm thành công";
return(RedirectToAction("Index"));
}
}
}
}
ViewBag.District_ID = new SelectList(db.DISTRICT, "ID", "DistrictName", property.District_ID);
ViewBag.Status_ID = new SelectList(db.PROJECT_STATUS, "ID", "Status_Name", property.Status_ID);
ViewBag.PropertyType_ID = new SelectList(db.PROPERTY_TYPE, "ID", "CodeType", property.PropertyType_ID);
ViewBag.Street_ID = new SelectList(db.STREET, "ID", "StreetName", property.Street_ID);
ViewBag.UserID = new SelectList(db.USER, "ID", "Email", property.UserID);
ViewBag.Sale_ID = new SelectList(db.USER, "ID", "Email", property.Sale_ID);
ViewBag.Ward_ID = new SelectList(db.WARD, "ID", "WardName", property.Ward_ID);
ViewBag.feature = new SelectList(db.FEATURE, "ID", "FeatureName");
return(View(property));
}
