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