public ActionResult AddOrder(FormCollection frm)
{
NewOrderViewModel objNewOrderViewModel = new NewOrderViewModel();
var currentUser = UserManager.Current();
var companylstModel = new List<CompanyModel>();
if (currentUser != null && currentUser.OrgId != null)
{
int usertype = currentUser.UserType.HasValue ? currentUser.UserType.Value : default(int);
objNewOrderViewModel.UserType = usertype;
if ((objNewOrderViewModel.UserType == 1) || (objNewOrderViewModel.UserType == 2)) // admin -1 , internal user/staff 2; external User/Client 3
{
// var CurrentUserComName = currentUser.Company.ToString();
var companylist = _companyrepository.SelectAll().Where(cm => cm.Org_Id == currentUser.OrgId);
companylstModel = Mapper.Map<IEnumerable<Company>, List<CompanyModel>>(companylist);
objNewOrderViewModel.Companylist = _companyrepository.SelectAll().Where(cm => cm.Org_Id == currentUser.OrgId).ToList();
}
else if (objNewOrderViewModel.UserType == 3)
{
objNewOrderViewModel.CompanyID = currentUser.CompanyId.HasValue ? currentUser.CompanyId.Value : default(int);
objNewOrderViewModel.CompanyName = _companyrepository.GetById(currentUser.CompanyId.ToString()).XeroName;
}
}
// objNewOrderViewModel.PropTypeID = Convert.ToInt32(frm["rd_proptype"].ToString());
SaveProperties(objNewOrderViewModel, frm);
//int value = objNewOrderViewModel.PropTypeID;
//switch (value)
//{
// case 1:
// SaveProperties(objNewOrderViewModel, frm);
// break;
// case 2:
// SaveProperties(objNewOrderViewModel, frm);
// break;
// case 3:
// SaveCommertialProperty(objNewOrderViewModel, frm);
// break;
//}
// return RedirectToAction("ReloadOrder");
return PartialView("Controls/Order/_AddOrder", objNewOrderViewModel);
}
public ActionResult AddOrder()
{
NewOrderViewModel objNewOrderViewModel = new NewOrderViewModel();
var currentUser = UserManager.Current();
var companylstModel = new List<CompanyModel>();
if (currentUser != null && currentUser.OrgId != null)
{
int usertype = currentUser.UserType.HasValue ? currentUser.UserType.Value : default(int);
objNewOrderViewModel.UserType = usertype;
if (usertype != 3) // usertype 1= "internal" " 2 for Staff 3 = External user
{
var companylist = _companyrepository.SelectAll().Where(cm => cm.Org_Id == currentUser.OrgId);
companylstModel = Mapper.Map<IEnumerable<Company>, List<CompanyModel>>(companylist);
objNewOrderViewModel.Companylist = _companyrepository.SelectAll().Where(cm => cm.Org_Id == currentUser.OrgId).ToList();
}
}
return PartialView("Controls/Order/_AddOrder", objNewOrderViewModel);
}
/// <summary>
///
/// </summary>
/// <param name="objNewOrderViewModel"></param>
/// <param name="frm"></param>
private void SaveProperties(NewOrderViewModel objNewOrderViewModel,FormCollection frm)
{
StringBuilder sb = new StringBuilder();
#region Saving Residential Property
if ((objNewOrderViewModel.UserType == 1) || (objNewOrderViewModel.UserType == 2))
{
objNewOrderViewModel.CompanyID = Convert.ToInt32(frm["ddlCompany"].ToString());
}
objNewOrderViewModel.PropertyAddrs = (frm["PropertyAddress"].ToString());
objNewOrderViewModel.SpecialInstruction = (frm["txt_SpecialInsruction"].ToString());
DateTime dtPropReq;
if (string.IsNullOrEmpty(frm["Dt_PropertyReady"].ToString()))
{
dtPropReq = Convert.ToDateTime(frm["Dt_PropertyReady"].ToString());
}
else
{
dtPropReq = DateTime.Now.AddMonths(1);
}
objNewOrderViewModel.PropertyReady = dtPropReq;
#region Keys in safe/Office
string strKeys = string.Empty;
if (frm["chk_KeyinsafeProp"] != null)
{
string strUAVDrone = (frm["chk_KeyinsafeProp"].ToString());
sb = null;
if (frm["chk_KeyinsafeProp"] != null)
{
strKeys = frm["chk_KeyinsafeProp"].ToString();
// sb.Append(frm["chk_KeyinsafeProp"].ToString());
}
}
if (frm["chk_KeyinOffice"] != null)
{
strKeys = strKeys + frm["chk_KeyinOffice"].ToString();
// sb.Append(frm["chk_KeyinOffice"].ToString());
}
// sb.ToString();
#endregion
using (var OrderMangtDB = new OrderMgntEntities())
{
using (var transaction = new TransactionScope())
{
var EntityProperties = new Property
{
Company_Id = objNewOrderViewModel.CompanyID,
Name = objNewOrderViewModel.PropertyAddrs,
Created = DateTime.Now,
};
// Add the Properties entity
OrderMangtDB.Properties.Add(EntityProperties);
OrderMangtDB.SaveChanges();
// Update the entity in the database
// Get the Row_Id generated by the database
objNewOrderViewModel.PropRowID = EntityProperties.Row_Id;
var EnityOrder = new Order
{
Property_Id = objNewOrderViewModel.PropRowID,
SpecialInstructions = objNewOrderViewModel.SpecialInstruction,
OrderId = "DPI-" + DateTime.Now.ToString("yyyyMMddHHmmssf"),
Keys = strKeys.ToString(),
RequiredDate = objNewOrderViewModel.PropertyReady,
Created = DateTime.Now,
};
// Add the Orders entity
OrderMangtDB.Orders.Add(EnityOrder);
OrderMangtDB.SaveChanges();
// Update the entity in the database
// Get the Row_Id generated by the database
objNewOrderViewModel.OrderRowID = EnityOrder.Row_Id;
#region PhotoGrphy
if (frm["Chk_PR_photography"] != null)
{
string Photography = (frm["Chk_PR_photography"].ToString());
#region day PhotoGrphy Section
if (frm["Rd_day_photography"] != null)
{
string DayphotographyType = frm["Rd_day_photography"].ToString();
StringBuilder sbPhotoGraphy = new StringBuilder();
sbPhotoGraphy.Append("Day Photography:");
switch (DayphotographyType)
{
case "2ExternalImages":
if (frm["chk_img_2_FR1"] != null)
{
sbPhotoGraphy.Append(frm["chk_img_2_FR1"].ToString());
sbPhotoGraphy.Append(",");
}
if (frm["chk_img_2_FR2"] != null)
{
sbPhotoGraphy.Append(frm["chk_img_2_FR2"].ToString());
sbPhotoGraphy.Append(",");
}
if (frm["chk_img_2_RE1"] != null)
{
sbPhotoGraphy.Append(frm["chk_img_2_FR2"].ToString());
sbPhotoGraphy.Append(",");
}
if (frm["chk_img_2_RE2"] != null)
{
sbPhotoGraphy.Append(frm["chk_img_2_FR2"].ToString());
sbPhotoGraphy.Append(",");
}
break;
case "5FinalImages":
if (frm["chk_img_5_FR1"] != null)
{
sbPhotoGraphy.Append(frm["chk_img_5_FR1"].ToString());
sbPhotoGraphy.Append(",");
}
if (frm["chk_img_5_FR2"] != null)
{
sbPhotoGraphy.Append(frm["chk_img_5_FR2"].ToString());
sbPhotoGraphy.Append(",");
}
if (frm["chk_img_5_Living"] != null)
{
sbPhotoGraphy.Append(frm["chk_img_5_Living"].ToString());
sbPhotoGraphy.Append(",");
}
if (frm["chk_img_5_Dining"] != null)
{
sbPhotoGraphy.Append(frm["chk_img_5_Dining"].ToString());
sbPhotoGraphy.Append(",");
}
/////////////
if (frm["chk_img_5_Family"] != null)
{
sbPhotoGraphy.Append(frm["chk_img_5_Family"].ToString());
sbPhotoGraphy.Append(",");
}
if (frm["chk_img_5_Kitchen"] != null)
{
sbPhotoGraphy.Append(frm["chk_img_5_Kitchen"].ToString());
sbPhotoGraphy.Append(",");
}
if (frm["chk_img_5_Bathroom"] != null)
{
sbPhotoGraphy.Append(frm["chk_img_5_Bathroom"].ToString());
sbPhotoGraphy.Append(",");
}
if (frm["chk_img_5_Ensuite"] != null)
{
sbPhotoGraphy.Append(frm["chk_img_5_Ensuite"].ToString());
sbPhotoGraphy.Append(",");
}
///////////////////////
if (frm["chk_img_5_MasterBed"] != null)
{
sbPhotoGraphy.Append(frm["chk_img_5_MasterBed"].ToString());
sbPhotoGraphy.Append(",");
}
if (frm["chk_img_5_2Bedroom"] != null)
{
sbPhotoGraphy.Append(frm["chk_img_5_2Bedroom"].ToString());
sbPhotoGraphy.Append(",");
}
if (frm["chk_img_5_Rumpus"] != null)
{
sbPhotoGraphy.Append(frm["chk_img_5_Rumpus"].ToString());
sbPhotoGraphy.Append(",");
}
if (frm["chk_img_5_HomeTheatre"] != null)
{
sbPhotoGraphy.Append(frm["chk_img_5_HomeTheatre"].ToString());
sbPhotoGraphy.Append(",");
}
///////////////////////
if (frm["chk_img_5_Pool"] != null)
{
sbPhotoGraphy.Append(frm["chk_img_5_Pool"].ToString());
sbPhotoGraphy.Append(",");
}
if (frm["chk_img_5_RE1"] != null)
{
sbPhotoGraphy.Append(frm["chk_img_5_RE1"].ToString());
sbPhotoGraphy.Append(",");
}
if (frm["chk_img_5_RE2"] != null)
{
sbPhotoGraphy.Append(frm["chk_img_5_RE2"].ToString());
sbPhotoGraphy.Append(",");
}
if (frm["chk_img_5_Lifestyle"] != null)
{
sbPhotoGraphy.Append(frm["chk_img_5_Lifestyle"].ToString());
sbPhotoGraphy.Append(",");
}
break;
case "8FinalImages":
if (frm["chk_img_8_FR1"] != null)
{
sbPhotoGraphy.Append(frm["chk_img_8_FR1"].ToString());
sbPhotoGraphy.Append(",");
}
if (frm["chk_img_8_FR2"] != null)
{
sbPhotoGraphy.Append(frm["chk_img_8_FR2"].ToString());
sbPhotoGraphy.Append(",");
}
if (frm["chk_img_8_Living"] != null)
{
sbPhotoGraphy.Append(frm["chk_img_8_Living"].ToString());
sbPhotoGraphy.Append(",");
}
if (frm["chk_img_8_Dining"] != null)
{
sbPhotoGraphy.Append(frm["chk_img_8_Dining"].ToString());
sbPhotoGraphy.Append(",");
}
/////////////
if (frm["chk_img_8_Family"] != null)
{
sbPhotoGraphy.Append(frm["chk_img_8_Family"].ToString());
sbPhotoGraphy.Append(",");
}
if (frm["chk_img_8_Kitchen"] != null)
{
sbPhotoGraphy.Append(frm["chk_img_8_Kitchen"].ToString());
sbPhotoGraphy.Append(",");
}
if (frm["chk_img_8_Bathroom"] != null)
{
sbPhotoGraphy.Append(frm["chk_img_8_Bathroom"].ToString());
sbPhotoGraphy.Append(",");
}
if (frm["chk_img_8_Ensuite"] != null)
{
sbPhotoGraphy.Append(frm["chk_img_8_Ensuite"].ToString());
sbPhotoGraphy.Append(",");
}
///////////////////////
if (frm["chk_img_8_MasterBed"] != null)
{
sbPhotoGraphy.Append(frm["chk_img_8_MasterBed"].ToString());
sbPhotoGraphy.Append(",");
}
if (frm["chk_img_8_2Bedroom"] != null)
{
sbPhotoGraphy.Append(frm["chk_img_8_2Bedroom"].ToString());
sbPhotoGraphy.Append(",");
}
if (frm["chk_img_8_Rumpus"] != null)
{
sbPhotoGraphy.Append(frm["chk_img_8_Rumpus"].ToString());
sbPhotoGraphy.Append(",");
}
if (frm["chk_img_8_HomeTheatre"] != null)
{
sbPhotoGraphy.Append(frm["chk_img_8_HomeTheatre"].ToString());
sbPhotoGraphy.Append(",");
}
///////////////////////
if (frm["chk_img_8_Pool"] != null)
{
sbPhotoGraphy.Append(frm["chk_img_8_Pool"].ToString());
sbPhotoGraphy.Append(",");
}
if (frm["chk_img_8_RE1"] != null)
{
sbPhotoGraphy.Append(frm["chk_img_8_RE1"].ToString());
sbPhotoGraphy.Append(",");
}
if (frm["chk_img_8_RE2"] != null)
{
sbPhotoGraphy.Append(frm["chk_img_8_RE2"].ToString());
sbPhotoGraphy.Append(",");
}
if (frm["chk_img_8_Lifestyle"] != null)
{
sbPhotoGraphy.Append(frm["chk_img_8_Lifestyle"].ToString());
sbPhotoGraphy.Append(",");
}
// remove last ,
break;
}
SaveDatainOrderSubItem(OrderMangtDB, objNewOrderViewModel.OrderRowID, sbPhotoGraphy.ToString().Remove(sbPhotoGraphy.ToString().Length - 1), 2);
}
#endregion Day Photo
#region Dusk PhotoGrphy Section
if (frm["chk_dusk_8final_img"] != null)
{
StringBuilder sbPhotoGraphy = new StringBuilder();
sbPhotoGraphy.Append(" Dusk Photography:");
if (frm["chk_dusk_8final_FR1"] != null)
{
sbPhotoGraphy.Append(frm["chk_dusk_8final_FR1"].ToString());
sbPhotoGraphy.Append(",");
}
if (frm["chk_dusk_8final_FR2"] != null)
{
sbPhotoGraphy.Append(frm["chk_dusk_8final_FR2"].ToString());
sbPhotoGraphy.Append(",");
}
if (frm["chk_dusk_8final_Living"] != null)
{
sbPhotoGraphy.Append(frm["chk_dusk_8final_Living"].ToString());
sbPhotoGraphy.Append(",");
}
if (frm["chk_dusk_8final_Dining"] != null)
{
sbPhotoGraphy.Append(frm["chk_dusk_8final_Dining"].ToString());
sbPhotoGraphy.Append(",");
}
if (frm["chk_dusk_8final_Family"] != null)
{
sbPhotoGraphy.Append(frm["chk_dusk_8final_Family"].ToString());
sbPhotoGraphy.Append(",");
}
if (frm["chk_dusk_8final_Kitchen"] != null)
{
sbPhotoGraphy.Append(frm["chk_dusk_8final_Kitchen"].ToString());
sbPhotoGraphy.Append(",");
}
if (frm["chk_dusk_8final_Bathroom"] != null)
{
sbPhotoGraphy.Append(frm["chk_dusk_8final_Bathroom"].ToString());
sbPhotoGraphy.Append(",");
}
if (frm["chk_dusk_8final_Ensuite"] != null)
{
sbPhotoGraphy.Append(frm["chk_dusk_8final_Ensuite"].ToString());
sbPhotoGraphy.Append(",");
}
///////////////////////
if (frm["chk_dusk_8final_MasterBed"] != null)
{
sbPhotoGraphy.Append(frm["chk_dusk_8final_MasterBed"].ToString());
sbPhotoGraphy.Append(",");
}
if (frm["chk_dusk_8final_2Bedroom"] != null)
{
sbPhotoGraphy.Append(frm["chk_dusk_8final_2Bedroom"].ToString());
sbPhotoGraphy.Append(",");
}
if (frm["chk_dusk_8final_Rumpus"] != null)
{
sbPhotoGraphy.Append(frm["chk_dusk_8final_Rumpus"].ToString());
sbPhotoGraphy.Append(",");
}
if (frm["chk_dusk_8final_HomeTheatre"] != null)
{
sbPhotoGraphy.Append(frm["chk_dusk_8final_HomeTheatre"].ToString());
sbPhotoGraphy.Append(",");
}
///////////////////////
if (frm["chk_dusk_8final_Pool"] != null)
{
sbPhotoGraphy.Append(frm["chk_dusk_8final_Pool"].ToString());
sbPhotoGraphy.Append(",");
}
if (frm["chk_dusk_8final_RE1"] != null)
{
sbPhotoGraphy.Append(frm["chk_dusk_8final_RE1"].ToString());
sbPhotoGraphy.Append(",");
}
if (frm["chk_dusk_8final_RE2"] != null)
{
sbPhotoGraphy.Append(frm["chk_dusk_8final_RE2"].ToString());
sbPhotoGraphy.Append(",");
}
if (frm["chk_dusk_8final_Lifestyle"] != null)
{
sbPhotoGraphy.Append(frm["chk_dusk_8final_Lifestyle"].ToString());
sbPhotoGraphy.Append(",");
}
// remove last ,
SaveDatainOrderSubItem(OrderMangtDB, objNewOrderViewModel.OrderRowID, sbPhotoGraphy.ToString().Remove(sbPhotoGraphy.ToString().Length - 1), 2);
}
#endregion Dusk Photo
#region Prestige PhotoGrphy Section
if (frm["Rd_day_presphotography"] != null)
{
string PrestigePhotographyType = frm["Rd_day_presphotography"].ToString();
StringBuilder sbPhotoGraphy = new StringBuilder();
sbPhotoGraphy.Append("Prestige Photography:");
switch (PrestigePhotographyType)
{
case "12DayFinalImages":
if (frm["chk_Prestige_Day_FR1"] != null)
{
sbPhotoGraphy.Append(frm["chk_Prestige_Day_FR1"].ToString());
sbPhotoGraphy.Append(",");
}
if (frm["chk_Prestige_Day_FR2"] != null)
{
sbPhotoGraphy.Append(frm["chk_Prestige_Day_FR2"].ToString());
sbPhotoGraphy.Append(",");
}
if (frm["chk_Prestige_Day_Living"] != null)
{
sbPhotoGraphy.Append(frm["chk_Prestige_Day_Living"].ToString());
sbPhotoGraphy.Append(",");
}
if (frm["chk_Prestige_Day_Dining"] != null)
{
sbPhotoGraphy.Append(frm["chk_Prestige_Day_Dining"].ToString());
sbPhotoGraphy.Append(",");
}
if (frm["chk_Prestige_Day_Family"] != null)
{
sbPhotoGraphy.Append(frm["chk_Prestige_Day_Family"].ToString());
sbPhotoGraphy.Append(",");
}
if (frm["chk_Prestige_Day_Kitchen"] != null)
{
sbPhotoGraphy.Append(frm["chk_Prestige_Day_Kitchen"].ToString());
sbPhotoGraphy.Append(",");
}
if (frm["chk_Prestige_Day_Bathroom"] != null)
{
sbPhotoGraphy.Append(frm["chk_Prestige_Day_Bathroom"].ToString());
sbPhotoGraphy.Append(",");
}
if (frm["chk_Prestige_Day_Ensuite"] != null)
{
sbPhotoGraphy.Append(frm["chk_Prestige_Day_Ensuite"].ToString());
sbPhotoGraphy.Append(",");
}
///////////////////////
if (frm["chk_Prestige_Day_MasterBed"] != null)
{
sbPhotoGraphy.Append(frm["chk_Prestige_Day_MasterBed"].ToString());
sbPhotoGraphy.Append(",");
}
if (frm["chk_Prestige_Day_2Bedroom"] != null)
{
sbPhotoGraphy.Append(frm["chk_Prestige_Day_2Bedroom"].ToString());
sbPhotoGraphy.Append(",");
}
if (frm["chk_Prestige_Day_Rumpus"] != null)
{
sbPhotoGraphy.Append(frm["chk_Prestige_Day_Rumpus"].ToString());
sbPhotoGraphy.Append(",");
}
if (frm["chk_dusk_8final_HomeTheatre"] != null)
{
sbPhotoGraphy.Append(frm["chk_Prestige_Day_HomeTheatre"].ToString());
sbPhotoGraphy.Append(",");
}
///////////////////////
if (frm["chk_Prestige_Day_Pool"] != null)
{
sbPhotoGraphy.Append(frm["chk_Prestige_Day_Pool"].ToString());
sbPhotoGraphy.Append(",");
}
if (frm["chk_Prestige_Day_RE1"] != null)
{
sbPhotoGraphy.Append(frm["chk_Prestige_Day_RE1"].ToString());
sbPhotoGraphy.Append(",");
}
if (frm["chk_Prestige_Day_RE2"] != null)
{
sbPhotoGraphy.Append(frm["chk_Prestige_Day_RE2"].ToString());
sbPhotoGraphy.Append(",");
}
if (frm["chk_Prestige_Day_Lifestyle"] != null)
{
sbPhotoGraphy.Append(frm["chk_Prestige_Day_Lifestyle"].ToString());
sbPhotoGraphy.Append(",");
}
// remove last ,
sbPhotoGraphy.ToString().Remove(sbPhotoGraphy.ToString().Length - 1);
////////////////////////
break;
case "Dusk12FinalImages":
if (frm["chk_Prestige_dusk_FR1"] != null)
{
sbPhotoGraphy.Append(frm["chk_Prestige_dusk_FR1"].ToString());
sbPhotoGraphy.Append(",");
}
if (frm["chk_Prestige_dusk_FR2"] != null)
{
sbPhotoGraphy.Append(frm["chk_Prestige_dusk_FR2"].ToString());
sbPhotoGraphy.Append(",");
}
if (frm["chk_Prestige_dusk_Living"] != null)
{
sbPhotoGraphy.Append(frm["chk_Prestige_dusk_Living"].ToString());
sbPhotoGraphy.Append(",");
}
if (frm["chk_Prestige_dusk_Dining"] != null)
{
sbPhotoGraphy.Append(frm["chk_Prestige_dusk_Dining"].ToString());
sbPhotoGraphy.Append(",");
}
if (frm["chk_Prestige_dusk_Family"] != null)
{
sbPhotoGraphy.Append(frm["chk_Prestige_dusk_Family"].ToString());
sbPhotoGraphy.Append(",");
}
if (frm["chk_Prestige_dusk_Kitchen"] != null)
{
sbPhotoGraphy.Append(frm["chk_Prestige_dusk_Kitchen"].ToString());
sbPhotoGraphy.Append(",");
}
if (frm["chk_Prestige_dusk_Bathroom"] != null)
{
sbPhotoGraphy.Append(frm["chk_Prestige_dusk_Bathroom"].ToString());
sbPhotoGraphy.Append(",");
}
if (frm["chk_Prestige_dusk_Ensuite"] != null)
{
sbPhotoGraphy.Append(frm["chk_Prestige_dusk_Ensuite"].ToString());
sbPhotoGraphy.Append(",");
}
///////////////////////
if (frm["chk_Prestige_dusk_MasterBed"] != null)
{
sbPhotoGraphy.Append(frm["chk_Prestige_dusk_MasterBed"].ToString());
sbPhotoGraphy.Append(",");
}
if (frm["chk_Prestige_dusk_2Bedroom"] != null)
{
sbPhotoGraphy.Append(frm["chk_Prestige_dusk_2Bedroom"].ToString());
sbPhotoGraphy.Append(",");
}
if (frm["chk_Prestige_dusk_Rumpus"] != null)
{
sbPhotoGraphy.Append(frm["chk_Prestige_dusk_Rumpus"].ToString());
sbPhotoGraphy.Append(",");
}
if (frm["chk_Prestige_dusk_HomeTheatre"] != null)
{
sbPhotoGraphy.Append(frm["chk_Prestige_dusk_HomeTheatre"].ToString());
sbPhotoGraphy.Append(",");
}
///////////////////////
if (frm["chk_Prestige_dusk_Pool"] != null)
{
sbPhotoGraphy.Append(frm["chk_Prestige_dusk_Pool"].ToString());
sbPhotoGraphy.Append(",");
}
if (frm["chk_Prestige_dusk_RE1"] != null)
{
sbPhotoGraphy.Append(frm["chk_Prestige_dusk_RE1"].ToString());
sbPhotoGraphy.Append(",");
}
if (frm["chk_Prestige_dusk_RE2"] != null)
{
sbPhotoGraphy.Append(frm["chk_Prestige_dusk_RE2"].ToString());
sbPhotoGraphy.Append(",");
}
if (frm["chk_Prestige_dusk_Lifestyle"] != null)
{
sbPhotoGraphy.Append(frm["chk_Prestige_dusk_Lifestyle"].ToString());
sbPhotoGraphy.Append(",");
}
break;
}
SaveDatainOrderSubItem(OrderMangtDB, objNewOrderViewModel.OrderRowID, sbPhotoGraphy.ToString().Remove(sbPhotoGraphy.ToString().Length - 1), 3);
}
#endregion Prestisge day Photo
#region Rental Photography Section
if (frm["rd_day_Rental_photography"] != null)
{
string RentalPhotographyType = frm["rd_day_Rental_photography"].ToString();
StringBuilder sbPhotoGraphy = new StringBuilder();
sbPhotoGraphy.Append("Rental Photography:");
switch (RentalPhotographyType)
{
case "5FinalRentalPhotography":
if (frm["chk_RentalOption5_FR1"] != null)
{
sbPhotoGraphy.Append(frm["chk_RentalOption5_FR1"].ToString());
sbPhotoGraphy.Append(",");
}
if (frm["chk_RentalOption5_FR2"] != null)
{
sbPhotoGraphy.Append(frm["chk_RentalOption5_FR2"].ToString());
sbPhotoGraphy.Append(",");
}
if (frm["chk_RentalOption5_Living"] != null)
{
sbPhotoGraphy.Append(frm["chk_RentalOption5_Living"].ToString());
sbPhotoGraphy.Append(",");
}
if (frm["chk_RentalOption5_Dining"] != null)
{
sbPhotoGraphy.Append(frm["chk_RentalOption5_Dining"].ToString());
sbPhotoGraphy.Append(",");
}
if (frm["chk_RentalOption5_Family"] != null)
{
sbPhotoGraphy.Append(frm["chk_RentalOption5_Family"].ToString());
sbPhotoGraphy.Append(",");
}
if (frm["chk_RentalOption5_Kitchen"] != null)
{
sbPhotoGraphy.Append(frm["chk_RentalOption5_Kitchen"].ToString());
sbPhotoGraphy.Append(",");
}
if (frm["chk_RentalOption5_Bathroom"] != null)
{
sbPhotoGraphy.Append(frm["chk_RentalOption5_Bathroom"].ToString());
sbPhotoGraphy.Append(",");
}
if (frm["chk_RentalOption5_Ensuite"] != null)
{
sbPhotoGraphy.Append(frm["chk_RentalOption5_Ensuite"].ToString());
sbPhotoGraphy.Append(",");
}
///////////////////////
if (frm["chk_RentalOption5_MasterBed"] != null)
{
sbPhotoGraphy.Append(frm["chk_RentalOption5_MasterBed"].ToString());
sbPhotoGraphy.Append(",");
}
if (frm["chk_RentalOption5_2Bedroom"] != null)
{
sbPhotoGraphy.Append(frm["chk_RentalOption5_2Bedroom"].ToString());
sbPhotoGraphy.Append(",");
}
if (frm["chk_RentalOption5_Rumpus"] != null)
{
sbPhotoGraphy.Append(frm["chk_RentalOption5_Rumpus"].ToString());
sbPhotoGraphy.Append(",");
}
if (frm["chk_RentalOption5_HomeTheatre"] != null)
{
sbPhotoGraphy.Append(frm["chk_RentalOption5_HomeTheatre"].ToString());
sbPhotoGraphy.Append(",");
}
///////////////////////
if (frm["chk_RentalOption5_Pool"] != null)
{
sbPhotoGraphy.Append(frm["chk_RentalOption5_Pool"].ToString());
sbPhotoGraphy.Append(",");
}
if (frm["chk_RentalOption5_RE1"] != null)
{
sbPhotoGraphy.Append(frm["chk_RentalOption5_RE1"].ToString());
sbPhotoGraphy.Append(",");
}
if (frm["chk_RentalOption5_RE2"] != null)
{
sbPhotoGraphy.Append(frm["chk_RentalOption5_RE2"].ToString());
sbPhotoGraphy.Append(",");
}
if (frm["chk_RentalOption5_Lifestyle"] != null)
{
sbPhotoGraphy.Append(frm["chk_RentalOption5_Lifestyle"].ToString());
sbPhotoGraphy.Append(",");
}
// remove last ,
sbPhotoGraphy.ToString().Remove(sbPhotoGraphy.ToString().Length - 1);
////////////////////////
break;
case "10FinalRentalPhotography":
if (frm["chk_RentalOption10_FR1"] != null)
{
sbPhotoGraphy.Append(frm["chk_RentalOption10_FR1"].ToString());
sbPhotoGraphy.Append(",");
}
if (frm["chk_RentalOption10_FR2"] != null)
{
sbPhotoGraphy.Append(frm["chk_RentalOption10_FR2"].ToString());
sbPhotoGraphy.Append(",");
}
if (frm["chk_RentalOption10_Living"] != null)
{
sbPhotoGraphy.Append(frm["chk_RentalOption10_Living"].ToString());
sbPhotoGraphy.Append(",");
}
if (frm["chk_RentalOption10_Dining"] != null)
{
sbPhotoGraphy.Append(frm["chk_RentalOption10_Dining"].ToString());
sbPhotoGraphy.Append(",");
}
if (frm["chk_RentalOption10_Family"] != null)
{
sbPhotoGraphy.Append(frm["chk_RentalOption10_Family"].ToString());
sbPhotoGraphy.Append(",");
}
if (frm["chk_RentalOption10_Kitchen"] != null)
{
sbPhotoGraphy.Append(frm["chk_RentalOption10_Kitchen"].ToString());
sbPhotoGraphy.Append(",");
}
if (frm["chk_RentalOption10_Bathroom"] != null)
{
sbPhotoGraphy.Append(frm["chk_RentalOption10_Bathroom"].ToString());
sbPhotoGraphy.Append(",");
}
if (frm["chk_RentalOption10_Ensuite"] != null)
{
sbPhotoGraphy.Append(frm["chk_RentalOption10_Ensuite"].ToString());
sbPhotoGraphy.Append(",");
}
///////////////////////
if (frm["chk_RentalOption10_MasterBed"] != null)
{
sbPhotoGraphy.Append(frm["chk_RentalOption10_MasterBed"].ToString());
sbPhotoGraphy.Append(",");
}
if (frm["chk_RentalOption10_2Bedroom"] != null)
{
sbPhotoGraphy.Append(frm["chk_RentalOption10_2Bedroom"].ToString());
sbPhotoGraphy.Append(",");
}
if (frm["chk_RentalOption10_Rumpus"] != null)
{
sbPhotoGraphy.Append(frm["chk_RentalOption10_Rumpus"].ToString());
sbPhotoGraphy.Append(",");
}
if (frm["chk_RentalOption10_HomeTheatre"] != null)
{
sbPhotoGraphy.Append(frm["chk_RentalOption10_HomeTheatre"].ToString());
sbPhotoGraphy.Append(",");
}
///////////////////////
if (frm["chk_RentalOption10_Pool"] != null)
{
sbPhotoGraphy.Append(frm["chk_RentalOption10_Pool"].ToString());
sbPhotoGraphy.Append(",");
}
if (frm["chk_RentalOption10_RE1"] != null)
{
sbPhotoGraphy.Append(frm["chk_RentalOption10_RE1"].ToString());
sbPhotoGraphy.Append(",");
}
if (frm["chk_RentalOption10_RE2"] != null)
{
sbPhotoGraphy.Append(frm["chk_RentalOption10_RE2"].ToString());
sbPhotoGraphy.Append(",");
}
if (frm["chk_RentalOption10_Lifestyle"] != null)
{
sbPhotoGraphy.Append(frm["chk_RentalOption10_Lifestyle"].ToString());
sbPhotoGraphy.Append(",");
}
// remove last ,
sbPhotoGraphy.ToString().Remove(sbPhotoGraphy.ToString().Length - 1);
break;
}
SaveDatainOrderSubItem(OrderMangtDB, objNewOrderViewModel.OrderRowID, sbPhotoGraphy.ToString().Remove(sbPhotoGraphy.ToString().Length - 1), 4);
}
#endregion Rental Photography
}
#endregion Photography
#region UAV Drone/Aerial Photography
if (frm["Chk_PR_UAVDrone"] != null)
{
string strUAVDrone = (frm["Chk_PR_UAVDrone"].ToString());
StringBuilder sbUAV_Drone = new StringBuilder();
string strHead = "UAV Drone/Aerial Photography:";
if (frm["chk_UAVDroneUP3"] != null)
{
sbUAV_Drone.Append(strHead);
sbUAV_Drone.Append(frm["chk_UAVDroneUP3"].ToString());
sbUAV_Drone.Append(",");
SaveDatainOrderSubItem(OrderMangtDB, objNewOrderViewModel.OrderRowID, sbUAV_Drone.ToString().Remove(sbUAV_Drone.ToString().Length - 1), 3);
sbUAV_Drone.Length = 0;
}
if (frm["chk_UAVDroneUP5"] != null)
{
sbUAV_Drone.Append(strHead);
sbUAV_Drone.Append(frm["chk_UAVDroneUP5"].ToString());
sbUAV_Drone.Append(",");
SaveDatainOrderSubItem(OrderMangtDB, objNewOrderViewModel.OrderRowID, sbUAV_Drone.ToString().Remove(sbUAV_Drone.ToString().Length - 1), 15);
sbUAV_Drone.Length = 0;
}
if (frm["chk_UAVDrone_Helicop"] != null)
{
sbUAV_Drone.Append(strHead);
sbUAV_Drone.Append(frm["chk_UAVDrone_Helicop"].ToString());
sbUAV_Drone.Append(",");
SaveDatainOrderSubItem(OrderMangtDB, objNewOrderViewModel.OrderRowID, sbUAV_Drone.ToString().Remove(sbUAV_Drone.ToString().Length - 1), 16);
sbUAV_Drone.Length = 0;
}
if (frm["chk_UAVDrone_Elevated"] != null)
{
sbUAV_Drone.Append(strHead);
sbUAV_Drone.Append(frm["chk_UAVDrone_Elevated"].ToString());
sbUAV_Drone.Append(",");
SaveDatainOrderSubItem(OrderMangtDB, objNewOrderViewModel.OrderRowID, sbUAV_Drone.ToString().Remove(sbUAV_Drone.ToString().Length - 1), 17);
sbUAV_Drone.Length = 0;
}
}
#endregion UAV Drone/Aerial Photography
#region Floor Plans/Land-boxes Photography
if (frm["Chk_PR_FloorPlan"] != null)
{
string strUAVDrone = (frm["Chk_PR_FloorPlan"].ToString());
StringBuilder sbFloorPlan = new StringBuilder();
string strHead = "Floor Plans/Land-boxes:";
if ((frm["Rd_day_Floorphotography"] != null))
{
string FloorphotographyType = frm["Rd_day_Floorphotography"].ToString();
switch (FloorphotographyType)
{
case "FloorPlan":
if (frm["chk_OnsiteColor"] != null)
{
sbFloorPlan.Append(strHead);
sbFloorPlan.Append(frm["chk_OnsiteColor"].ToString());
}
SaveDatainOrderSubItem(OrderMangtDB, objNewOrderViewModel.OrderRowID, sbFloorPlan.ToString(), 6);
break;
case "FloorPlanandSite":
if (frm["chk_OnsiteColor"] != null)
{
sbFloorPlan.Append(strHead);
sbFloorPlan.Append(frm["chk_OnsiteColor"].ToString());
}
SaveDatainOrderSubItem(OrderMangtDB, objNewOrderViewModel.OrderRowID, sbFloorPlan.ToString(), 6);
break;
}
}
////////////////////////
if ((frm["RedrawFloorSiteRadio"] != null))
{
string FloorphotographyType = frm["RedrawFloorSiteRadio"].ToString();
switch (FloorphotographyType)
{
case "FloorPlan":
if (frm["chk_RedrawColor"] != null)
{
sbFloorPlan.Append(strHead);
sbFloorPlan.Append(frm["chk_RedrawColor"].ToString());
}
SaveDatainOrderSubItem(OrderMangtDB, objNewOrderViewModel.OrderRowID, sbFloorPlan.ToString(), 7);
break;
case "FloorPlanSitePlan":
if (frm["chk_RedrawColor"] != null)
{
sbFloorPlan.Append(strHead);
sbFloorPlan.Append(frm["chk_RedrawColor"].ToString());
}
SaveDatainOrderSubItem(OrderMangtDB, objNewOrderViewModel.OrderRowID, sbFloorPlan.ToString(), 7);
break;
}
}
//Saving Landbox value
sbFloorPlan.Append(strHead + " Landbox:");
sbFloorPlan.Append(frm["ddlLandbox"].ToString());
SaveDatainOrderSubItem(OrderMangtDB, objNewOrderViewModel.OrderRowID, sbFloorPlan.ToString(), 8);
///////////////////
}
#endregion Floor Plans/Land-boxes Photography
#region Copy Writing
if (frm["Chk_PR_CopyWriting"] != null)
{
string strUAVDrone = (frm["Chk_PR_CopyWriting"].ToString());
sb = new StringBuilder();
string strHead = "Copy Writing:";
if (frm["chk_copywrite_Onsite"] != null)
{
sb.Append(strHead);
sb.Append(frm["chk_copywrite_Onsite"].ToString());
SaveDatainOrderSubItem(OrderMangtDB, objNewOrderViewModel.OrderRowID, sb.ToString(), 9);
sb.Length = 0;
}
if (frm["chk_copywrite_Offsite"] != null)
{
sb.Append(strHead);
sb.Append(frm["chk_copywrite_Offsite"].ToString());
SaveDatainOrderSubItem(OrderMangtDB, objNewOrderViewModel.OrderRowID, sb.ToString(), 10);
sb.Length = 0;
}
if (frm["chk_Rewrite_agent"] != null)
{
sb.Append(strHead);
sb.Append(frm["chk_Rewrite_agent"].ToString());
SaveDatainOrderSubItem(OrderMangtDB, objNewOrderViewModel.OrderRowID, sb.ToString(), 11);
sb.Length = 0;
}
}
#endregion Copy Writing
#region Video and Image tours
if (frm["Chk_PR_VideoImageTour"] != null)
{
string strUAVDrone = (frm["Chk_PR_VideoImageTour"].ToString());
sb = new StringBuilder();
string strHead = "Video and Image tours:";
if (frm["chk_video_propvideo"] != null)
{
sb.Append(strHead);
sb.Append(frm["chk_video_propvideo"].ToString());
SaveDatainOrderSubItem(OrderMangtDB, objNewOrderViewModel.OrderRowID, sb.ToString(), 12);
sb.Length = 0;
}
if (frm["chk_video_profile"] != null)
{
sb.Append(strHead);
sb.Append(frm["chk_video_profile"].ToString());
SaveDatainOrderSubItem(OrderMangtDB, objNewOrderViewModel.OrderRowID, sb.ToString(), 13);
sb.Length = 0;
}
if (frm["chk_ImageTours_stillImg"] != null)
{
sb.Append(strHead);
sb.Append(frm["chk_ImageTours_stillImg"].ToString());
SaveDatainOrderSubItem(OrderMangtDB, objNewOrderViewModel.OrderRowID, sb.ToString(), 14);
sb.Length = 0;
}
}
#endregion Copy Writing
// End Logic for Copy Writing selected items
#region Agent Check
if (frm["chkAgent"] != null)
{
string ContactType = (frm["chkAgent"].ToString());
objNewOrderViewModel.AgentName = (frm["txtAgentName"].ToString());
string AgentPhoneEmail = string.Empty;
if (!string.IsNullOrEmpty(frm["txtAgentPhone"]))
{
objNewOrderViewModel.AgentPhone = (frm["txtAgentPhone"].ToString());
AgentPhoneEmail = "Phone:" + objNewOrderViewModel.AgentPhone;
}
if (!string.IsNullOrEmpty(frm["txtAgentPhone"]))
{
objNewOrderViewModel.AgentEmail = (frm["txtAgentEmail"].ToString());
AgentPhoneEmail = AgentPhoneEmail + " E-Mail:" + objNewOrderViewModel.AgentEmail;
}
var EntityContacts = new Contact
{
CompanyId = objNewOrderViewModel.CompanyID,
Name = objNewOrderViewModel.AgentName,
Value = AgentPhoneEmail,
ContactType = ContactType,
Created = DateTime.Now,
};
OrderMangtDB.Contacts.Add(EntityContacts);
OrderMangtDB.SaveChanges();
objNewOrderViewModel.ContactRowID = EntityContacts.Row_Id;
var EntityOrderContacts = new OrderContact
{
ContactId = objNewOrderViewModel.ContactRowID,
OrderId = objNewOrderViewModel.OrderRowID,
Created = DateTime.Now,
};
OrderMangtDB.OrderContacts.Add(EntityOrderContacts);
OrderMangtDB.SaveChanges();
objNewOrderViewModel.OrderContactID = EntityOrderContacts.Row_Id;
}
#endregion Agent
#region Owner Section
if (frm["chkOwner"] != null)
{
string ContactType = (frm["chkOwner"].ToString());
objNewOrderViewModel.AgentName = (frm["txt_OwnerName"].ToString());
string OwnerPhoneEmail = string.Empty;
if (!string.IsNullOrEmpty(frm["txt_OwnerPhone"]))
{
objNewOrderViewModel.OwnerPhone = (frm["txt_OwnerPhone"].ToString());
OwnerPhoneEmail = "Phone:" + objNewOrderViewModel.OwnerPhone;
}
var EntityContacts = new Contact
{
CompanyId = objNewOrderViewModel.CompanyID,
Name = objNewOrderViewModel.OwnerName,
Value = OwnerPhoneEmail,
ContactType = ContactType,
Created = DateTime.Now,
};
OrderMangtDB.Contacts.Add(EntityContacts);
OrderMangtDB.SaveChanges();
objNewOrderViewModel.ContactRowID = EntityContacts.Row_Id;
var EntityOrderContacts = new OrderContact
{
ContactId = objNewOrderViewModel.ContactRowID,
OrderId = objNewOrderViewModel.OrderRowID,
Created = DateTime.Now,
};
OrderMangtDB.OrderContacts.Add(EntityOrderContacts);
OrderMangtDB.SaveChanges();
objNewOrderViewModel.OrderContactID = EntityOrderContacts.Row_Id;
}
#endregion Owner
#region Tenant Section
if (frm["chkTenant"] != null)
{
string ContactType = (frm["chkTenant"].ToString());
if (!string.IsNullOrEmpty(frm["txt_TenantName"]))
{
objNewOrderViewModel.TanantName = (frm["txt_TenantName"].ToString());
}
if (!string.IsNullOrEmpty(frm["txt_TenantPhone"]))
{
objNewOrderViewModel.TanantPhone = "Phone:" + (frm["txt_TenantPhone"].ToString());
}
var EntityContacts = new Contact
{
CompanyId = objNewOrderViewModel.CompanyID,
Name = objNewOrderViewModel.TanantName,
Value = objNewOrderViewModel.TanantPhone,
ContactType = ContactType,
Created = DateTime.Now,
};
OrderMangtDB.Contacts.Add(EntityContacts);
OrderMangtDB.SaveChanges();
objNewOrderViewModel.ContactRowID = EntityContacts.Row_Id;
var EntityOrderContacts = new OrderContact
{
ContactId = objNewOrderViewModel.ContactRowID,
OrderId = objNewOrderViewModel.OrderRowID,
Created = DateTime.Now,
};
OrderMangtDB.OrderContacts.Add(EntityOrderContacts);
OrderMangtDB.SaveChanges();
objNewOrderViewModel.OrderContactID = EntityOrderContacts.Row_Id;
}
#endregion Tenant
transaction.Complete();
}
}
#endregion
}
/// <summary>
///
/// </summary>
/// <param name="objNewOrderViewModel"></param>
/// <param name="frm"></param>
private void SaveCommertialProperty(NewOrderViewModel objNewOrderViewModel,FormCollection frm)
{
#region Saving Commercial Photography
if ((objNewOrderViewModel.UserType == 1) || (objNewOrderViewModel.UserType == 2))
{
objNewOrderViewModel.CompanyID = Convert.ToInt32(frm["ddlCompanyCom"].ToString());
}
objNewOrderViewModel.OfficeContactName = (frm["txtOfficeContactNameCom"].ToString());
objNewOrderViewModel.Phone = (frm["txtPhone"].ToString());
objNewOrderViewModel.Email = (frm["txtEmailIdCom"].ToString());
objNewOrderViewModel.ProjectAddress = (frm["txtProjectAddress"].ToString());
objNewOrderViewModel.DetailedBrief = (frm["txtDetailedBrief"].ToString());
using (var OrderMangtDB = new OrderMgntEntities())
{
using (var transaction = new TransactionScope())
{
var EntityProperties = new Property
{
Company_Id = objNewOrderViewModel.CompanyID,
Name = objNewOrderViewModel.ProjectAddress,
Created = DateTime.Now,
};
// Add the Properties entity
OrderMangtDB.Properties.Add(EntityProperties);
OrderMangtDB.SaveChanges();
// Update the entity in the database
// Get the Row_Id generated by the database
objNewOrderViewModel.PropRowID = EntityProperties.Row_Id;
var EnityOrder = new Order
{
Property_Id = objNewOrderViewModel.PropRowID,
Description = objNewOrderViewModel.DetailedBrief,
OrderId = "DPI-" + DateTime.Now.ToString("yyyyMMddHHmmssf"),
Created = DateTime.Now,
};
// Add the Orders entity
OrderMangtDB.Orders.Add(EnityOrder);
OrderMangtDB.SaveChanges();
// Update the entity in the database
// Get the Row_Id generated by the database
objNewOrderViewModel.OrderRowID = EnityOrder.Row_Id;
// Logic for PhotoGrphy selected items
// End Logic for PhotoGrphy selected items
var EntityOrderItems = new OrderItem
{
Order_Id = objNewOrderViewModel.OrderRowID,
//Name = "Options Premium Package 2.1 Photography up to 8 day/dusk images Property Video /Floorplan + Siteplan",
Created = DateTime.Now,
};
// Add the OrderItems entity
OrderMangtDB.OrderItems.Add(EntityOrderItems);
// Update the entity in the database
OrderMangtDB.SaveChanges();
// Get the Row_Id generated by the database
objNewOrderViewModel.OrderItemRowID = EntityOrderItems.Row_Id;
// add entry in the CompanyOrdertable
var EntityCompanyOrder = new CompanyOrder
{
CompanyId = objNewOrderViewModel.CompanyID,
OrderId = objNewOrderViewModel.OrderRowID,
Created = DateTime.Now,
};
// Add the CompanyOrders entity
OrderMangtDB.CompanyOrders.Add(EntityCompanyOrder);
// Update the entity in the database
OrderMangtDB.SaveChanges();
// Get the Row_Id generated by the database
objNewOrderViewModel.CompanyOrderRowID = EntityCompanyOrder.Row_Id;
transaction.Complete();
}
}
#endregion
}