// Generate a new ID for AGENT_LINK_CLIENT data when insert a new AGENT_LINK_CLIENT data into database.
private int generateAgentLinkClientID()
{
using (var db = new DB_9DB5CF_skylimitcapitalEntities())
{
var last = db.AGENT_LINK_CLIENT.OrderByDescending(r => r.Id).FirstOrDefault();
if (last == null)
{
return 1;
}
else
{
return last.Id + 1;
}
}
}
// Generate a new ID for real_photo data when insert a new real_photo data into database.
private int generatePhotoID()
{
using (var db = new DB_9DB5CF_skylimitcapitalEntities())
{
var last = db.Real_Photos.OrderByDescending(r => r.ID).FirstOrDefault();
if (last == null)
{
return 1;
}
else
{
return last.ID + 1;
}
}
}
// Generate a new ID for Contract data when insert a new Contract data into database.
private int generateContractID()
{
using (var db = new DB_9DB5CF_skylimitcapitalEntities())
{
var last = db.Contracts.OrderByDescending(r => r.id).FirstOrDefault();
if (last == null)
{
return 1;
}
else
{
return last.id + 1;
}
}
}
public ActionResult CreateRealEstate(Real real, string StateType, string CountyName, HttpPostedFileBase[] images)
{
var firm = (Firm)Session["Firm"];
if (firm == null)
{
return RedirectToAction("Index");
}
using (var db = new DB_9DB5CF_skylimitcapitalEntities())
{
var state = db.USAStates.Where(s => s.ShortName == StateType).FirstOrDefault();
real.State = state.StateNameEng;
var county = db.Counties.Where(c => c.Name.Contains(CountyName) && c.State == state.StateNameEng).FirstOrDefault();
real.County = county.id;
real.Image = "default.jpg";//delete
real.ID = generateRealID();
db.Reals.Add(real);
db.SaveChanges();
var firm_real = new Firm_has_Real
{
id = generateFirmHasRealID(),
FirmID = firm.Id,
RealID = real.ID
};
db.Firm_has_Real.Add(firm_real);
db.SaveChanges();
if (images != null)
{
foreach (var image in images)
{
string picName = System.IO.Path.GetFileName(image.FileName);
picName = firm.Name + "_" + DateTime.Now.ToFileTimeUtc().ToString() + "_" + picName;
var photo = new Real_Photos
{
ID = generatePhotoID(),
Name = picName,
RealId = real.ID
};
//real.Image = picName;
string path = System.IO.Path.Combine(Server.MapPath("/Images/RealEstatePictures"), picName);
// file is uploaded
image.SaveAs(path);
db.Real_Photos.Add(photo);
db.SaveChanges();
}
}
ViewBag.PageIndex = SidebarIndex.UPLOAD_PROPERTY;
return RedirectToAction("upLoadedRealsListPage");
}
}