public ActionResult DeleteConfirmed(int id)
{
Portfolio_Customer portfolio_Customer = db.Portfolio_Customer.Find(id);
db.Portfolio_Customer.Remove(portfolio_Customer);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Edit(Portfolio_Customer portfolio_Customer)
{
if (ModelState.IsValid)
{
db.Entry(portfolio_Customer).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(portfolio_Customer));
}
public ActionResult Create(Portfolio_Customer portfolio_Customer)
{
if (ModelState.IsValid)
{
db.Portfolio_Customer.Add(portfolio_Customer);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(portfolio_Customer));
}
// GET: Portfolio_Customer/Delete/5
public ActionResult Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Portfolio_Customer portfolio_Customer = db.Portfolio_Customer.Find(id);
if (portfolio_Customer == null)
{
return(HttpNotFound());
}
return(View(portfolio_Customer));
}
public ActionResult CustomerProcess(CustomerModelView customer)
{
if (ModelState.IsValid)
{
if (customer.Id == null)
{
if (customer.c_Name == null && customer.c_Surname == null)
{
Portfolio_CustomerRequest pcus = new Portfolio_CustomerRequest();
pcus.City = customer.cr_City;
pcus.Country = customer.cr_Country;
pcus.FinishDate = customer.cr_FinishDate;
pcus.C_Id = customer.c_Id;
pcus.FloorChange = customer.cr_FloorChange;
pcus.Housing = customer.cr_Housing;
pcus.Land = customer.cr_Land;
pcus.MaxArea = customer.cr_MaxArea;
pcus.MinArea = customer.cr_MinArea;
pcus.MaxPrice = customer.cr_MaxPrice;
pcus.MinPrice = customer.cr_MinPrice;
pcus.Note = customer.cr_Note;
pcus.Status = customer.cr_Status;
pcus.Office = customer.cr_Office;
pcus.Transformation = customer.cr_Transformation;
db.Portfilio_CustomerRequest.Add(pcus);
db.SaveChanges();
return(RedirectToAction("Index"));
}
else
{
Portfolio_Customer cus = new Portfolio_Customer();
cus.Name = customer.c_Name;
cus.Surname = customer.c_Surname;
cus.EMail = customer.c_EMail;
cus.Phone2 = customer.c_Phone2;
cus.Phone1 = customer.c_Phone1;
db.Portfolio_Customer.Add(cus);
db.SaveChanges();
var customerId =
db.Portfolio_Customer.Where(x => x.EMail == customer.c_EMail && x.Name == customer.c_Name &&
x.Surname == customer.c_Surname)
.Select(x => x.Id)
.FirstOrDefault();
Portfolio_CustomerRequest pcus = new Portfolio_CustomerRequest();
pcus.City = customer.cr_City;
pcus.Country = customer.cr_Country;
pcus.FinishDate = customer.cr_FinishDate;
pcus.C_Id = customerId;
pcus.FloorChange = customer.cr_FloorChange;
pcus.Housing = customer.cr_Housing;
pcus.Land = customer.cr_Land;
pcus.MaxArea = customer.cr_MaxArea;
pcus.MinArea = customer.cr_MinArea;
pcus.MaxPrice = customer.cr_MaxPrice;
pcus.MinPrice = customer.cr_MinPrice;
pcus.Note = customer.cr_Note;
pcus.Status = customer.cr_Status;
pcus.Office = customer.cr_Office;
pcus.Transformation = customer.cr_Transformation;
db.Portfilio_CustomerRequest.Add(pcus);
db.SaveChanges();
return(RedirectToAction("Index"));
}
}
else
{
Portfolio_CustomerRequest pcus =
db.Portfilio_CustomerRequest.Where(x => x.Id == customer.Id).FirstOrDefault();
pcus.City = customer.cr_City;
pcus.Country = customer.cr_Country;
pcus.FinishDate = customer.cr_FinishDate;
pcus.C_Id = customer.c_Id;
pcus.FloorChange = customer.cr_FloorChange;
pcus.Housing = customer.cr_Housing;
pcus.Land = customer.cr_Land;
pcus.MaxArea = customer.cr_MaxArea;
pcus.MinArea = customer.cr_MinArea;
pcus.MaxPrice = customer.cr_MaxPrice;
pcus.MinPrice = customer.cr_MinPrice;
pcus.Note = customer.cr_Note;
pcus.Status = customer.cr_Status;
pcus.Office = customer.cr_Office;
pcus.Transformation = customer.cr_Transformation;
db.SaveChanges();
return(RedirectToAction("Index"));
}
}
AddItemDropDownList();
return(View(customer));
}
public ActionResult PortfolioProcess(PortfolioModelView portfoliomodel, IEnumerable <HttpPostedFileBase> pd_Image, IEnumerable <HttpPostedFileBase> pc_AuthorityDocument)//Veriler list şeklinde gonderilecek alınırken bölüm bölüm alınıp ilgili tabloya kayıt yapılacak
{
if (ModelState.IsValid)
{
if (portfoliomodel.Id == null)
{
//var personal_id =
// db.Portfolio_Personal.Where(
// x => x.Name == portfoliomodel.pp_Source)
// .Select(x => x.Id)
// .FirstOrDefault();
//Yeni portföy kayıdı
if (portfoliomodel.pcus_Surname != null && portfoliomodel.pcus_Name != null)
{
Portfolio_Customer pcus = new Portfolio_Customer();
pcus.EMail = portfoliomodel.pcus_EMail;
pcus.Name = portfoliomodel.pcus_Name;
pcus.Surname = portfoliomodel.pcus_Surname;
pcus.Phone1 = portfoliomodel.pcus_Phone1;
pcus.Seller = true;
db.Portfolio_Customer.Add(pcus);
db.SaveChanges();
var sorgu =
db.Portfolio_Customer.FirstOrDefault(
x => x.Name == portfoliomodel.pcus_Name && x.EMail == portfoliomodel.pcus_EMail).Id;
portfoliomodel.pg_Customer_Id = sorgu;
}
Portfolio_Contract pc = new Portfolio_Contract();
//pc.Pg_Id = pg_Id;
pc.StartDate = portfoliomodel.pc_StartDate;
pc.FinishDate = portfoliomodel.pc_FinishDate;
pc.Buyer_Rate = portfoliomodel.pc_Buyer_Rate;
pc.Seller_Rate = portfoliomodel.pc_Seller_Rate;
pc.MinPrice = portfoliomodel.pc_MinPrice;
pc.MaxPrice = portfoliomodel.pc_MaxPrice;
pc.Buyer_ServicePrice = portfoliomodel.pc_Buyer_ServicePrice;
pc.Seller_ServicePrice = portfoliomodel.pc_Seller_ServicePrice;
pc.ContractNumber = portfoliomodel.pc_ContractNumber;
string path = Server.MapPath("~/UploadImage/" + portfoliomodel.pg_Header);
Directory.CreateDirectory(path);
if (portfoliomodel.pc_AuthorityDocument != null)
{
foreach (var file in pc_AuthorityDocument)
{
if (file.ContentLength > 0)
{
var filename = Path.GetFileName(file.FileName);
var kayityeri = Path.Combine(path, filename);
pc.AuthorityDocument += "/UploadImage/" + portfoliomodel.pg_Header + " " + filename + ", ";
file.SaveAs(kayityeri);
}
}
}
db.Portfolio_Contract.Add(pc);
db.SaveChanges();
var contractId = db.Portfolio_Contract.Where(
x => x.ContractNumber == pc.ContractNumber && x.Buyer_ServicePrice == pc.Buyer_ServicePrice &&
x.FinishDate == pc.FinishDate).Select(x => x.Id).FirstOrDefault();
portfoliomodel.pg_Contract_Id = contractId;
Portfolio_General pg = new Portfolio_General();
pg.Type_State = portfoliomodel.pg_Type_State;
pg.Area_Brut = portfoliomodel.pg_Area_Brut;
pg.Status = 0;
pg.Contract_Id = portfoliomodel.pg_Contract_Id;
pg.Area_Net = portfoliomodel.pg_Area_Net;
pg.Comment = portfoliomodel.pg_Comment;
pg.Credit = portfoliomodel.pg_Credit;
pg.Description = portfoliomodel.pg_Description;
pg.Header = portfoliomodel.pg_Header;
pg.Personal_Id = User.Identity.GetUserId();
pg.Price = portfoliomodel.pg_Price;
pg.Date = portfoliomodel.pg_Date;
pg.Type = portfoliomodel.pg_Type;
pg.Subscription = portfoliomodel.pg_Subscription;
pg.Price_Type = portfoliomodel.pg_Price_Type;
pg.Customer_Id = portfoliomodel.pg_Customer_Id;
db.Portfolio_General.Add(pg);
db.SaveChanges();
var pg_Id =
db.Portfolio_General.Where(
x => x.Comment == portfoliomodel.pg_Comment && x.Header == portfoliomodel.pg_Header)
.Select(x => x.Id).FirstOrDefault();
Portfolio_Detail pd = new Portfolio_Detail();
pd.Balcony_Number = portfoliomodel.pd_Balcony_Number;
pd.Bathroom_Number = portfoliomodel.pd_Bathroom_Number;
pd.Building_Age = portfoliomodel.pd_Building_Age;
pd.Building_Floor = portfoliomodel.pd_Building_Floor;
pd.Floor = portfoliomodel.pd_Floor;
pd.Floor_Change = portfoliomodel.pd_Floor_Change;
pd.Heating = portfoliomodel.pd_Heating;
pd.Room_Number = portfoliomodel.pd_Room_Number;
pd.Saloon_Number = portfoliomodel.pd_Saloon_Number;
pd.Status = portfoliomodel.pd_Status;
pd.Pg_Id = pg_Id;
path = Server.MapPath("~/UploadImage/" + portfoliomodel.pg_Header);
Directory.CreateDirectory(path);
if (portfoliomodel.pd_Image != null)
{
foreach (var file in pd_Image)
{
if (file.ContentLength > 0)
{
var filename = Path.GetFileName(file.FileName);
var kayityeri = Path.Combine(path, filename);
pd.Image += "/UploadImage/" + portfoliomodel.pg_Header + " " + filename + ", ";
file.SaveAs(kayityeri);
}
}
}
db.Portfolio_Detail.Add(pd);
db.SaveChanges();
Portfolio_Address pa = new Portfolio_Address();
pa.Address = portfoliomodel.pa_Address;
pa.City = portfoliomodel.pa_City;
pa.Country = portfoliomodel.pa_Country;
pa.District = portfoliomodel.pa_District;
pa.Latitude = portfoliomodel.pa_Latitude;
pa.Longitude = portfoliomodel.pa_Longitude;
pa.Pg_Id = pg_Id;
pa.Site_Name = portfoliomodel.pa_Site_Name;
db.Portfolio_Address.Add(pa);
db.SaveChanges();
Portfolio_ExtraDetail pe = new Portfolio_ExtraDetail();
pe.Pg_Id = pg_Id;
pe.North = portfoliomodel.pe_North;
pe.Sourth = portfoliomodel.pe_Sourth;
pe.East = portfoliomodel.pe_East;
pe.West = portfoliomodel.pe_West;
pe.Fiber = portfoliomodel.pe_Fiber;
pe.Satellite = portfoliomodel.pe_Satellite;
pe.Cable_tv = portfoliomodel.pe_Cable_tv;
pe.Adsl = portfoliomodel.pe_Adsl;
pe.Fax = portfoliomodel.pe_Fax;
pe.Phone = portfoliomodel.pe_Phone;
pe.WiFi = portfoliomodel.pe_WiFi;
pe.Elevator = portfoliomodel.pe_Elevator;
pe.Pool = portfoliomodel.pe_Pool;
pe.Child_Park = portfoliomodel.pe_Child_Park;
pe.Garage = portfoliomodel.pe_Garage;
pe.Garden = portfoliomodel.pe_Garden;
pe.Fire_Stairs = portfoliomodel.pe_Fire_Stairs;
pe.Securityman = portfoliomodel.pe_Securityman;
pe.Generator = portfoliomodel.pe_Generator;
pe.Camera = portfoliomodel.pe_Camera;
pe.Fire_Alarm = portfoliomodel.pe_Fire_Alarm;
pe.Thief_Alarm = portfoliomodel.pe_Thief_Alarm;
pe.Sea = portfoliomodel.pe_Sea;
pe.Throat = portfoliomodel.pe_Throat;
pe.Mountain = portfoliomodel.pe_Mountain;
pe.City = portfoliomodel.pe_City;
pe.Nature = portfoliomodel.pe_Nature;
pe.Lake = portfoliomodel.pe_Lake;
db.Portfolio_ExtraDetail.Add(pe);
db.SaveChanges();
return(RedirectToAction("Index", "Portfolio"));
}
else
{
//Bu kısım güncelleme kısmı olacak
if (portfoliomodel.pcus_Surname != null && portfoliomodel.pcus_Name != null)
{
Portfolio_Customer pcus = new Portfolio_Customer();
pcus.EMail = portfoliomodel.pcus_EMail;
pcus.Name = portfoliomodel.pcus_Name;
pcus.Surname = portfoliomodel.pcus_Surname;
pcus.Phone1 = portfoliomodel.pcus_Phone1;
pcus.Seller = true;
db.Portfolio_Customer.Add(pcus);
db.SaveChanges();
var sorgu =
db.Portfolio_Customer.Where(
x => x.Name == portfoliomodel.pcus_Name && x.EMail == portfoliomodel.pcus_EMail).Select(x => x.Id).FirstOrDefault();
portfoliomodel.pg_Customer_Id = sorgu;
}
Portfolio_General pg = db.Portfolio_General.FirstOrDefault(x => x.Id == portfoliomodel.Id);
pg.Type_State = portfoliomodel.pg_Type_State;
pg.Area_Brut = portfoliomodel.pg_Area_Brut;
pg.Area_Net = portfoliomodel.pg_Area_Net;
pg.Comment = portfoliomodel.pg_Comment;
pg.Credit = portfoliomodel.pg_Credit;
pg.Description = portfoliomodel.pg_Description;
pg.Header = portfoliomodel.pg_Header;
pg.Personal_Id = portfoliomodel.pg_Personal_Id;
pg.Price = portfoliomodel.pg_Price;
pg.Type = portfoliomodel.pg_Type;
pg.Customer_Id = portfoliomodel.pg_Customer_Id;
pg.Subscription = portfoliomodel.pg_Subscription;
pg.Price_Type = portfoliomodel.pg_Price_Type;
db.SaveChanges();
//var pg_Id =
// db.Portfolio_General.Where(
// x => x.Comment == portfoliomodel.pg_Comment && x.Header == portfoliomodel.pg_Header)
// .Select(x => x.Id).FirstOrDefault();
Portfolio_Detail pd = db.Portfolio_Detail.Where(x => x.Pg_Id == portfoliomodel.Id).FirstOrDefault();
pd.Balcony_Number = portfoliomodel.pd_Balcony_Number;
pd.Bathroom_Number = portfoliomodel.pd_Bathroom_Number;
pd.Building_Age = portfoliomodel.pd_Building_Age;
pd.Building_Floor = portfoliomodel.pd_Building_Floor;
pd.Floor = portfoliomodel.pd_Floor;
pd.Floor_Change = portfoliomodel.pd_Floor_Change;
pd.Heating = portfoliomodel.pd_Heating;
pd.Room_Number = portfoliomodel.pd_Room_Number;
pd.Saloon_Number = portfoliomodel.pd_Saloon_Number;
pd.Status = portfoliomodel.pd_Status;
string path = Server.MapPath("~/UploadImage/" + portfoliomodel.pg_Header);
Directory.CreateDirectory(path);
if (portfoliomodel.pd_Image != null)
{
foreach (var file in pd_Image)
{
if (file.ContentLength > 0)
{
var filename = Path.GetFileName(file.FileName);
var kayityeri = Path.Combine(path, filename);
pd.Image += "/UploadImage/" + portfoliomodel.pg_Header + "/" + filename + ";";
file.SaveAs(kayityeri);
}
}
}
//pd.Pg_Id = portfoliomodel.Id;
db.SaveChanges();
Portfolio_Address pa = db.Portfolio_Address.Where(x => x.Pg_Id == portfoliomodel.Id).FirstOrDefault();
pa.Address = portfoliomodel.pa_Address;
pa.City = portfoliomodel.pa_City;
pa.Country = portfoliomodel.pa_Country;
pa.District = portfoliomodel.pa_District;
pa.Latitude = portfoliomodel.pa_Latitude;
pa.Longitude = portfoliomodel.pa_Longitude;
//pa.Pg_Id = portfoliomodel.pa_Id;
pa.Site_Name = portfoliomodel.pa_Site_Name;
db.SaveChanges();
Portfolio_ExtraDetail pe = db.Portfolio_ExtraDetail.Where(x => x.Pg_Id == portfoliomodel.Id).FirstOrDefault();
// pe.Pg_Id = portfoliomodel.pe_Id;
pe.North = portfoliomodel.pe_North;
pe.Sourth = portfoliomodel.pe_Sourth;
pe.East = portfoliomodel.pe_East;
pe.West = portfoliomodel.pe_West;
pe.Fiber = portfoliomodel.pe_Fiber;
pe.Satellite = portfoliomodel.pe_Satellite;
pe.Cable_tv = portfoliomodel.pe_Cable_tv;
pe.Adsl = portfoliomodel.pe_Adsl;
pe.Fax = portfoliomodel.pe_Fax;
pe.Phone = portfoliomodel.pe_Phone;
pe.WiFi = portfoliomodel.pe_WiFi;
pe.Elevator = portfoliomodel.pe_Elevator;
pe.Pool = portfoliomodel.pe_Pool;
pe.Child_Park = portfoliomodel.pe_Child_Park;
pe.Garage = portfoliomodel.pe_Garage;
pe.Garden = portfoliomodel.pe_Garden;
pe.Fire_Stairs = portfoliomodel.pe_Fire_Stairs;
pe.Securityman = portfoliomodel.pe_Securityman;
pe.Generator = portfoliomodel.pe_Generator;
pe.Camera = portfoliomodel.pe_Camera;
pe.Fire_Alarm = portfoliomodel.pe_Fire_Alarm;
pe.Thief_Alarm = portfoliomodel.pe_Thief_Alarm;
pe.Sea = portfoliomodel.pe_Sea;
pe.Throat = portfoliomodel.pe_Throat;
pe.Mountain = portfoliomodel.pe_Mountain;
pe.City = portfoliomodel.pe_City;
pe.Nature = portfoliomodel.pe_Nature;
pe.Lake = portfoliomodel.pe_Lake;
db.SaveChanges();
Portfolio_Contract pc = db.Portfolio_Contract.FirstOrDefault(x => x.Id == portfoliomodel.pg_Contract_Id);
pc.StartDate = portfoliomodel.pc_StartDate;
pc.FinishDate = portfoliomodel.pc_FinishDate;
pc.Buyer_Rate = portfoliomodel.pc_Buyer_Rate;
pc.Seller_Rate = portfoliomodel.pc_Seller_Rate;
pc.MinPrice = portfoliomodel.pc_MinPrice;
pc.MaxPrice = portfoliomodel.pc_MaxPrice;
pc.Buyer_ServicePrice = portfoliomodel.pc_Buyer_ServicePrice;
pc.Seller_ServicePrice = portfoliomodel.pc_Seller_ServicePrice;
pc.ContractNumber = portfoliomodel.pc_ContractNumber;
path = Server.MapPath("~/UploadImage/" + portfoliomodel.pg_Header);
Directory.CreateDirectory(path);
if (portfoliomodel.pc_AuthorityDocument != null)
{
foreach (var file in pc_AuthorityDocument)
{
if (file.ContentLength > 0)
{
var filename = Path.GetFileName(file.FileName);
var kayityeri = Path.Combine(path, filename);
pc.AuthorityDocument += "/UploadImage/" + portfoliomodel.pg_Header + " " + filename + ", ";
file.SaveAs(kayityeri);
}
}
}
db.SaveChanges();
return(RedirectToAction("Index", "Portfolio"));
}
}
return(View(portfoliomodel));
}
