public ActionResult ForgotPassword(ForgotPassword model)
{
if (ModelState.ContainsKey("NewPassword"))
ModelState["NewPassword"].Errors.Clear();
if (ModelState.IsValid)
{
string EmailAddress = model.EmailAddress.ToString();
User user = _userService.RegistrantUser(EmailAddress);
if (user != null)
{
ForgotPwd ForgotPassword = EmailClient.SendResetEmail(EmailAddress, "OMSTeam");
if (ForgotPassword != null)
{
using (var OrderMangtDB = new OrderMgntEntities())
{
// var userDetails = OrderMangtDB.ForgotPwds.ToList().Where(x => x.ResetURL.Equals(OMS)).FirstOrDefault();
OrderMangtDB.ForgotPwds.Add(ForgotPassword);
OrderMangtDB.SaveChanges();
ForgotPassword objForgotPassword = new Models.ForgotPassword();
objForgotPassword.EmailAddress = ForgotPassword.UserID;
objForgotPassword.Msgtype = 0;
return PartialView("_EmailConfirmation", objForgotPassword);
}
}
}
else
{
ViewBag.EmailNotExistMessage = "User with this Email does not exist.";
return View("ForgotPassword");
}
}
return View("ForgotPassword");
}
//using (var OrderMangtDB = new OrderMgntEntities())
// {
// var currentUser = UserManager.Current();
// int calendarUserId;
// if (currentUser != null && currentUser.UserType == 1)
// {
// IList<OrderViewModel> order = _orderService.GetAll();
// foreach (var item in order)
// {
// item.PropertyName = item.Property_Id != null ? getPropertyNameById((int)item.Property_Id) : "";
// item.CompanyName = item.Property_Id != null ? getCompanyNameByPropertyId((int)item.Property_Id) : "";
// }
// return PartialView("Controls/Order/_OrderList", order);
// }
public static MvcHtmlString GetFiles(this HtmlHelper helper,string orderid)
{
string fileCount = string.Empty;
using (var orderMangtDb = new OrderMgntEntities())
{
var currentUser = UserManager.Current();
var orderlst = orderMangtDb.Orders.Where(m => m.OrderId == orderid).ToList();
if (orderlst.Count > 0)
{
foreach (var item in orderlst)
{
var orderAttach =
orderMangtDb.OrderAttachments.Where(
m => m.Org_Id == currentUser.OrgId && m.Order_Id == item.Row_Id).ToList();
fileCount = orderAttach.Count.ToString();
}
if (fileCount != "0" && fileCount!="")
return MvcHtmlString.Create(fileCount);
}
}
return null;
}
public IndexViewModel()
{
this._repository = new CompanyRepository();
this._productRepository = new ProductRepository();
this._productCompanyRepo = new ProductCompanyRepository();
this._db = new OrderMgntEntities();
this.Companylist = new List<Company>();
this.ProductGrouplist = new List<ProductGroup>();
}
public EventModel()
{
this.CalenderResources = new List<ScheduleResources>();
using (var OrderMangtDB = new OrderMgntEntities())
{
var calenderUsers = OrderMangtDB.CalendarUsers.ToList();
List<ScheduleResources> lstresources = new List<ScheduleResources>();
foreach (var item in calenderUsers)
{
ScheduleResources scheduleResources = new ScheduleResources();
scheduleResources.Text = GetUserNameById((int)item.UserId);
scheduleResources.Value = item.CalendarId.ToString();
scheduleResources.Color = item.Color;
lstresources.Add(scheduleResources);
}
this.CalenderResources = lstresources;
}
}
private CachedSchedulerRepository()
{
this.db = new OrderMgntEntities();
}
public UserRepository()
{
this.db = new OrderMgntEntities();
}
/// <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
}
public ActionResult Index(string id)
{
var AllGalleryFoldersData = _orderService.SelectOrderableProducts().ToList();
List<OrderableProducts> lstOrderableProductsInfo = new List<OrderableProducts>();
for (int i = 0; i < 5; i++)
{
OrderableProducts objOrderableProducts = new OrderableProducts();
objOrderableProducts.Row_Id = i;
objOrderableProducts.WebName = "Photography " + i.ToString();
lstOrderableProductsInfo.Add(objOrderableProducts);
}
var lstOrderableProd = lstOrderableProductsInfo.Select(p => new
{
Row_Id = p.Row_Id,
productDes = p.WebName
});
using (var OrderMangtDB = new OrderMgntEntities())
{
var currentUser = UserManager.Current();
int calendarUserId;
if (currentUser != null && currentUser.UserType == 1)
{
IList<OrderViewModel> order = _orderService.GetAll();
foreach (var item in order)
{
item.PropertyName = item.Property_Id != null ? getPropertyNameById((int)item.Property_Id) : "";
item.CompanyName = item.Property_Id != null ? getCompanyNameByPropertyId((int)item.Property_Id) : "";
}
return PartialView("Controls/Order/_OrderList", order);
}
else
{
var calendarUser = OrderMangtDB.CalendarUsers.ToList().Where(x => x.UserId.Equals(currentUser.Row_Id)).FirstOrDefault();
calendarUserId = (int)calendarUser.CalendarId;
var orderIdList = OrderMangtDB.EventTrackings.ToList().Where(x => x.CalendarId.Equals(calendarUserId)).Select(x => x.OrderId).ToArray();
var orders = OrderMangtDB.Orders.ToList().Where(x => orderIdList.Contains(x.OrderId));
var orderlstModel = Mapper.Map<IEnumerable<Order>, List<OrderViewModel>>(orders);
foreach (var item in orderlstModel)
{
item.PropertyName = item.Property_Id != null ? getPropertyNameById((int)item.Property_Id) : "";
item.CompanyName = item.Property_Id != null ? getCompanyNameByPropertyId((int)item.Property_Id) : "";
// item.RequiredDate.Value = item.RequiredDate.Value != null ? item.RequiredDate: "";//Convert.ToDateTime(item.RequiredDate) : "";
if (item.RequiredDate.Value != null)
{
item.RequiredDate = item.RequiredDate;
}
}
return PartialView("Controls/Order/_OrderList", orderlstModel);
}
}
}
public SchedulerRepository(OrderMgntEntities db)
{
this.db = db;
}
public ProductRepository(OrderMgntEntities db)
{
this.db = db;
}
private void DeleteEvent(string eventid, string calendar, int CalendarId)
{
if (!string.IsNullOrEmpty(eventid))
{
var objGoogleCal = new GoogleServiceMethodCalls();
objGoogleCal.DeleteEvent(eventid, calendar);
// Check if more than one rec is exist
// var AllEventByCalendarIdAndEventId = _scheduler.GetAllEventByCalendarIdAndEventId(eventid, CalendarId);
// if (AllEventByCalendarIdAndEventId.Count > 1)
// {
using (var OrderMangtDB = new OrderMgntEntities())
{
var Events =
(from oEvents in OrderMangtDB.Events
where oEvents.EventId == eventid && oEvents.CalendarId == CalendarId
select oEvents).ToList();
foreach (var Event in Events)
{
Event.Status = "cancelled";
}
OrderMangtDB.SaveChanges();
}
// }
//else
//{
// Event objevent1 = _scheduler.GetEventByCalendarIdAndEventId(eventid, CalendarId);
// _scheduler.DeleteEvent(objevent1);
//}
//using (var OrderMangtDB = new OrderMgntEntities())
//{
// Event objevent = OrderMangtDB.Events.Single(e => e.EventId == eventid && e.CalendarId == CalendarId);
// objevent.Status = "cancelled";
// OrderMangtDB.SaveChanges();
//}
}
}
public virtual JsonResult Event_Create([DataSourceRequest] DataSourceRequest request, CalEventViewModel eventViewModel, List<int> userIds)
{
try
{
if (ModelState.IsValid)
{
using (var OrderMangtDB = new OrderMgntEntities())
{
var entity = new Event
{
Title = eventViewModel.Title,
//StartDate = DateTime.SpecifyKind(eventViewModel.Start, DateTimeKind.Local),
//EndDate = DateTime.SpecifyKind(eventViewModel.End, DateTimeKind.Local),
StartDate = eventViewModel.Start,//StartDateParam,
EndDate = eventViewModel.End,
Description = eventViewModel.Description,
Recurrence = eventViewModel.RecurrenceRule,
RecurrenceID = eventViewModel.RecurrenceID,
Kind = "calendar#event",
IsAllDay = eventViewModel.IsAllDay,
CalendarId = eventViewModel.CalenderUser,
Organizer = eventViewModel.Organizer,
Creator = eventViewModel.Creator,
Updated = DateTime.Today,
Location = eventViewModel.Location,
ColorId = eventViewModel.ColorId
};
var objGoogleCal = new GoogleServiceMethodCalls();
string returnedEventid = string.Empty;
int fromCalId;
string calName = string.Empty;
int orgId;
string StagingCalendar = string.Empty;
if (eventViewModel.Row_Id != 0)
{
fromCalId = (int)OrderMangtDB.Events.First(x => x.Row_Id == eventViewModel.Row_Id).CalendarId;
calName = OrderMangtDB.Calendars.FirstOrDefault(c => c.Row_Id == fromCalId).Name;
orgId = (int)UserManager.Current().OrgId;
StagingCalendar = OrderMangtDB.Calendars.FirstOrDefault(x => (x.Org_Id != null && x.Org_Id == orgId) && (x.StagingCalendar != null && x.StagingCalendar == true)).Name;
}
if (eventViewModel.Isdrag && calName != StagingCalendar && eventViewModel.Row_Id != 0)
{
string creator = string.Empty;
string organizer = string.Empty;
string eventId = eventViewModel.GoogleEventid;
int eventRowId = eventViewModel.Row_Id;
string destinationCalendar = eventViewModel.CalenderUser.ToString();
var calendars = OrderMangtDB.Calendars.SingleOrDefault(m => m.Row_Id == eventViewModel.CalenderUser);
var fromCalendarId = OrderMangtDB.Events.First(m => m.Row_Id == eventRowId).CalendarId;
var fromCalendar = OrderMangtDB.Calendars.SingleOrDefault(m => m.Row_Id == fromCalendarId);
if (calendars != null)
{
if (entity.StartDate != null && entity.EndDate != null)
{
Logger("MoveEvent called within Create block Called" + " || " + entity.Title);
int OldEventRowId = Convert.ToInt32(_scheduler.GetEventRowId(eventId).FirstOrDefault().EventRow_id);
returnedEventid = objGoogleCal.MoveEvent(entity.StartDate.Value, entity.EndDate.Value, creator,
organizer,
entity.Location, entity.Title, eventId, calendars.Name, fromCalendar.Name, (int)entity.Sequence, entity.Description ?? string.Empty, entity.Recurrence ?? string.Empty, entity.IsAllDay ?? false, entity.ColorId ?? string.Empty);
eventViewModel.EventId = returnedEventid;
int LoggedInUserId = (int)UserManager.Current().Row_Id;
DBLogger(returnedEventid, entity.Title, "MoveEvent", LoggedInUserId, fromCalendar.Name, calendars.Name);
_scheduler.UpdateJobEvents(returnedEventid, calendars.Name, fromCalendar.Name, OldEventRowId);///UpdateJobEvents
Logger("UpdateJobEvents Called - " + "eventId: " + returnedEventid + " Source calendar Name : " + fromCalendar.Name + " Destination calendar Name : " + calendars.Name); ///
LoggedInUserId= (int)UserManager.Current().Row_Id;
DBLogger(returnedEventid, entity.Title, "MoveEvent", LoggedInUserId, fromCalendar.Name, calendars.Name);
ThrowCustomExc(returnedEventid);
Logger("MoveEvent end within Create block Called");
}
// objGoogleCal.UpdateEvent(entity.StartDate.Value, entity.EndDate.Value, creator, organizer, entity.Location, entity.Title, eventId, calendars.Name);
}
}
else if (!string.IsNullOrEmpty(eventViewModel.RecurrenceID))
{
var evnt = OrderMangtDB.Events.First(x => x.EventId == eventViewModel.RecurrenceID && x.Status != "Cancelled");
var cal = OrderMangtDB.Calendars.First(x => x.Row_Id == evnt.CalendarId).Name;
string colorid = string.Empty;
if (eventViewModel.EventColorid.HasValue)
{
if (eventViewModel.EventColorid.Value <= 11)
colorid = eventViewModel.EventColorid.ToString();
}
else
{
if (eventViewModel.CalenderUser != null)
{
// colorid = GetUsercalenderColor(eventViewModel.CalenderUser.Value);
colorid = string.Empty;
}
}
entity.EventId = eventViewModel.RecurrenceID;
// entity.Sequence = 0;
int Sequenceid = (int)OrderMangtDB.Events.First(x => x.EventId == eventViewModel.RecurrenceID).Sequence;
Sequenceid++;
entity.Sequence = Sequenceid; // != 0 ? Sequenceid: Sequenceid + 1;
Logger("UpdateEventInstance called within Create block Called" + " || " + entity.Title);
//var startDate = (DateTime)entity.StartDate;
// if (startDate.TimeOfDay.Minutes < 15 && startDate.TimeOfDay.Minutes > 0)
// {
// startDate = new DateTime(startDate.Year, startDate.Month, startDate.Day, startDate.Hour, 00, 00);
// }
var returnedEventId = objGoogleCal.UpdateEventInstance((DateTime)entity.StartDate, (DateTime)entity.EndDate, string.Empty, entity.Organizer, entity.Location, entity.Title, entity.EventId, cal, (int)entity.Sequence, entity.Description ?? string.Empty, entity.Recurrence ?? string.Empty, entity.IsAllDay ?? false, colorid ?? entity.ColorId);
int LoggedInUserId = (int)UserManager.Current().Row_Id;
DBLogger(returnedEventId, entity.Title, "Update Event", LoggedInUserId, cal, cal);
// string retUpdateEventId = returnedEventId;
ThrowCustomExc(returnedEventId);
Logger("UpdateEventInstance end within Create block Called");
}
else
{
string colorid = string.Empty;
if (eventViewModel.EventColorid.HasValue)
{
if (eventViewModel.EventColorid.Value < 12) // we only need to pass top 11 clolor while create update
{
colorid = eventViewModel.EventColorid.ToString();
}
}
else
{
if (!string.IsNullOrEmpty(eventViewModel.Color))
{
// colorid = eventViewModel.ColorId,
colorid = OrderMangtDB.ColorMasters.First(x => x.Color == eventViewModel.Color).Row_Id.ToString();
}
else
{
colorid = string.Empty;
}
//if (eventViewModel.CalenderUser != null)
//{
// colorid = GetUsercalenderColor(eventViewModel.CalenderUser.Value);
//}
//colorid = string.Empty;
}
var calendars = OrderMangtDB.Calendars.SingleOrDefault(m => m.Row_Id == eventViewModel.CalenderUser);
Logger("UpdateEventInstance end within Create block Called" + " || " + entity.Title);
returnedEventid = objGoogleCal.CreateEvent(entity.Title, entity.Location, string.Empty,
entity.StartDate.Value, entity.EndDate.Value, string.Empty, entity.Description,
string.Empty, string.Empty, colorid, calendars.Name, entity.Description ?? string.Empty, entity.Recurrence ?? string.Empty, entity.IsAllDay ?? false);
string strreturnedEventid = returnedEventid;
string[] parts = strreturnedEventid.Split(',');
string EventidfrmGoogle = string.Empty; string seqId = string.Empty;
if ((parts[0] != null && parts[0].Length > 0))
{
EventidfrmGoogle = (parts[0].ToString());
seqId = (parts[1].ToString());
}
int LoggedInUserId = (int)UserManager.Current().Row_Id;
DBLogger(EventidfrmGoogle, entity.Title, "Create Event", LoggedInUserId, calendars.Name, calendars.Name);
Logger("CreateEvent end within Create block Called");
if (returnedEventid != string.Empty)
{
var retValues = returnedEventid.Split(',');
eventViewModel.EventId = retValues[0];
eventViewModel.Sequence = Convert.ToInt32(retValues[1]);
ThrowCustomExc(retValues[0]);
}
}
}
}
}
catch (Exception ex)
{
#region For Error
string Error = ErrorMsg;
if (!string.IsNullOrEmpty(ErrorMsg))
{
switch (Error)
{
case "CustomError400":
return Json(new DataSourceResult
{
// Errors = "You cannot change the organizer of an instance."
Errors = "CustomError400"
});
case "CustomError401":
return Json(new DataSourceResult
{
//Errors = "You cannot turn an instance of a recurring event into a recurring event itself."
Errors = "CustomError401"
});
case "Null_Event":
return Json(new DataSourceResult
{
Errors = "Null_Event"
});
//default:
// Logger(ex.InnerException.Message);
// return Json(new DataSourceResult
// {
// Errors = string.Empty
// });
}
}
else
{
return Json(new DataSourceResult
{
Errors = ""
});
}
#endregion
}
// Return the inserted task. The scheduler needs the generated TaskID. Also return any validation errors.
//List<int> userid = new List<int> { };
//Event_Read(request, "", DateTime.Now, DateTime.Now);
return Json(new[] { eventViewModel }.ToDataSourceResult(request, ModelState));
}
public ActionResult Jobs_Destroy([DataSourceRequest] DataSourceRequest request, CalEventViewModel eventViewModel)
{
int fromCalendarId = 0;
string fromCalendar = string.Empty;
int eventRowId = eventViewModel.Row_Id;
using (var OrderMangtDB = new OrderMgntEntities())
{
fromCalendarId = (int)OrderMangtDB.Events.First(m => m.Row_Id == eventRowId).CalendarId;
fromCalendar = OrderMangtDB.Calendars.SingleOrDefault(m => m.Row_Id == fromCalendarId).Name;
}
try
{
if (!string.IsNullOrEmpty(eventViewModel.EventId))
{
DeleteEvent(eventViewModel.EventId, fromCalendar, fromCalendarId);
}
else if (!string.IsNullOrEmpty(eventViewModel.GoogleEventid))
{
DeleteEvent(eventViewModel.GoogleEventid, fromCalendar, fromCalendarId);
}
}
catch (Exception ex)
{
string msg = ex.Message;
}
//}
return Json(new[] { eventViewModel }.ToDataSourceResult(request, ModelState));
}
public JsonResult GetUserList([DataSourceRequest] DataSourceRequest request)
{
List<ScheduleResources> lstresources = new List<ScheduleResources>();
using (var OrderMangtDB = new OrderMgntEntities())
{
var calenderUsers = OrderMangtDB.CalendarUsers.ToList();
Controllers.SchedulerController scheduleCntrl = new Controllers.SchedulerController();
foreach (var item in calenderUsers)
{
ScheduleResources scheduleResources = new ScheduleResources();
scheduleResources.Text = scheduleCntrl.GetUserNameById((int)item.UserId);
scheduleResources.Value = item.CalendarId.ToString();
scheduleResources.Color = item.Color;
lstresources.Add(scheduleResources);
}
;
}
JsonResult jsonResult = Json(lstresources.ToDataSourceResult(request));
jsonResult.MaxJsonLength = Int32.MaxValue;
return jsonResult;
}
public ActionResult DeleteRecurrence(string eventid, int calendarId, string calenderUser, DateTime end, DateTime start)
{
string calenderName = string.Empty;
string rtneventid = string.Empty;
string exceptionfrmDB = string.Empty;
string strNewDate = string.Empty;
var objGoogleCal = new GoogleServiceMethodCalls();
using (var OrderMangtDB = new OrderMgntEntities())
{
calenderName = OrderMangtDB.Calendars.FirstOrDefault(m => m.Row_Id == calendarId).Name;
if (!string.IsNullOrEmpty(calenderName))
{
rtneventid = objGoogleCal.DeleteEventInstance(eventid, calenderName, start);
if (!rtneventid.Equals("Instance not available"))
{
string Currexception = rtneventid.Split('_').Last();
//var datepart = Currexception.Split('T').First();
//var newDate = DateTime.ParseExact(datepart, "yyyyMMdd", CultureInfo.InvariantCulture).AddDays(1);
//strNewDate = newDate.Year.ToString() + newDate.Month.ToString() + newDate.Day.ToString();
//Currexception = Currexception.Replace(datepart, strNewDate);
string streventid = eventid;
var exceptionEntry = OrderMangtDB.EventExceptions.FirstOrDefault(c => c.EventId == streventid);
if (exceptionEntry != null)
{
exceptionfrmDB = exceptionEntry.Exception;
}
if (exceptionfrmDB == string.Empty)
{
if (!exceptionfrmDB.Contains(Currexception))
exceptionfrmDB = Currexception;
}
else
{
exceptionfrmDB = exceptionfrmDB + ";" + Currexception;
}
if (exceptionEntry == null)
{
var EventException = new EventException { EventId = eventid, Exception = exceptionfrmDB };
OrderMangtDB.EventExceptions.Add(EventException);
}
else
{
exceptionEntry.Exception = exceptionfrmDB;
}
OrderMangtDB.SaveChanges();
}
else
{
using (var OrderMangtDB2 = new OrderMgntEntities())
{
var Events =
(from oEvents in OrderMangtDB2.Events
where oEvents.EventId == eventid && oEvents.CalendarId == calendarId
select oEvents).ToList();
foreach (var Event in Events)
{
Event.Status = "cancelled";
}
OrderMangtDB2.SaveChanges();
}
}
}
}
return Content(rtneventid);
}
public UserRepository(OrderMgntEntities db)
{
this.db = db;
}
private CachedAccountRepository()
{
this.db = new OrderMgntEntities();
}
public ProductRepository()
{
this.db = new OrderMgntEntities();
}
public virtual JsonResult Event_Destroy([DataSourceRequest] DataSourceRequest request, CalEventViewModel eventViewModel)
{
if (ModelState.IsValid)
{
//int fromCalendarId = 0;
string fromCalendar = string.Empty;
int fromCalendarId = (int)eventViewModel.CalenderUser;
using (var OrderMangtDB = new OrderMgntEntities())
{
//fromCalendarId = (int)OrderMangtDB.Events.First(m => m.Row_Id == eventRowId).CalendarId;
fromCalendar = OrderMangtDB.Calendars.SingleOrDefault(m => m.Row_Id == fromCalendarId).Name;
}
try
{
if (!string.IsNullOrEmpty(eventViewModel.EventId))
{
string eventid = eventViewModel.EventId;
var objGoogleCal = new GoogleServiceMethodCalls();
objGoogleCal.DeleteEvent(eventid, fromCalendar);
using (var OrderMangtDB = new OrderMgntEntities())
{
var Events =
(from oEvents in OrderMangtDB.Events
where oEvents.EventId == eventid && oEvents.CalendarId == fromCalendarId
select oEvents).ToList();
foreach (var Event in Events)
{
Event.Status = "cancelled";
}
OrderMangtDB.SaveChanges();
int LoggedInUserId = (int)UserManager.Current().Row_Id;
DBLogger(eventViewModel.EventId, eventViewModel.Title, "Cancelled Event", LoggedInUserId, fromCalendar, fromCalendar);
}
// Check if more than one rec is exist
// var AllEventByCalendarIdAndEventId = _scheduler.GetAllEventByCalendarIdAndEventId(eventid, CalendarId);
// DeleteEvent(eventViewModel.EventId, fromCalendar, fromCalendarId);
}
else if (!string.IsNullOrEmpty(eventViewModel.GoogleEventid))
{
DeleteEvent(eventViewModel.GoogleEventid, fromCalendar, fromCalendarId);
int LoggedInUserId = (int)UserManager.Current().Row_Id;
DBLogger(eventViewModel.GoogleEventid, eventViewModel.Title, "Cancelled Event", LoggedInUserId, fromCalendar, fromCalendar);
}
}
catch (Exception ex)
{
string msg = ex.Message;
Logger(msg);
}
}
return Json(new[] { eventViewModel }.ToDataSourceResult(request, ModelState));
}
public SchedulerRepository()
{
this.db = new OrderMgntEntities();
}
public VideoRepository()
{
this.db = new OrderMgntEntities();
}
public string getCompanyNameByPropertyId(int propertyId)
{
using (var OrderMangtDB = new OrderMgntEntities())
{
int compnayId;
var company = OrderMangtDB.Properties.ToList().Where(x => x.Row_Id.Equals(propertyId)).FirstOrDefault();
if (company != null)
{
compnayId = Convert.ToInt32(company.Company_Id.ToString());
}
else
{
compnayId = 0;
}
var t = OrderMangtDB.Companies.Where(x => x.Row_Id.Equals(compnayId)).FirstOrDefault();
if (t != null)
{
return t.XeroName.ToString();
}
else
{
return string.Empty;
}
}
}
public VideoRepository(OrderMgntEntities db)
{
this.db = db;
}
private string getPropertyNameById(int propertyId)
{
using (var OrderMangtDB = new OrderMgntEntities())
{
var t = OrderMangtDB.Properties.ToList().Where(x => x.Row_Id.Equals(propertyId)).FirstOrDefault();
if (t != null)
{
return t.Name.ToString();
}
else
{
return string.Empty;
}
}
}
private string GetUserNameById(int userId)
{
using (var OrderMangtDB = new OrderMgntEntities())
{
var temp = OrderMangtDB.Users.ToList().Where(m => m.Row_Id == userId).FirstOrDefault();
if (temp != null)
{
return temp.FirstName;
}
else
{
return string.Empty;
}
}
}
/// <summary>
/// Function for saving data in orderitems and OrderSubItems table
/// </summary>
/// <param name="OrderMgntEntities"></param>
/// <param name="Order_Id"></param>
/// <param name="SelectedItemList"></param>
/// <param name="ProductSubGroupId"></param>
/// <returns></returns>
private int SaveDatainOrderSubItem(OrderMgntEntities OrderMangtDB, int Order_Id, string SelectedItemList, int ProductSubGroupId)
{
int OrderItemRowID, OrderSubItemRowID;
var EntityOrderItems = new OrderItem
{
Order_Id = Order_Id,
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
OrderItemRowID = EntityOrderItems.Row_Id;
var EntityOrdersubItems = new OrderSubItem
{
OrderItemId = OrderItemRowID,
ProductSubGroupId = ProductSubGroupId, // get "Rental Photography" value form the ProductSubGroups table
OptionSelected = SelectedItemList.ToString(),
Created = DateTime.Now,
};
// Add the OrderItems entity
OrderMangtDB.OrderSubItems.Add(EntityOrdersubItems);
// Update the entity in the database
OrderMangtDB.SaveChanges();
// Get the Row_Id generated by the database
return OrderSubItemRowID = EntityOrderItems.Row_Id;
}
public ActionResult ResetPassword(string OMS)
{
using (var OrderMangtDB = new OrderMgntEntities())
{
var userDetails = OrderMangtDB.ForgotPwds.ToList().Where(x => x.ResetURL.Equals(OMS)).FirstOrDefault();
ForgotPassword objForgotPassword = new Models.ForgotPassword();
if (userDetails.Isused.HasValue)
{
if ((bool)userDetails.Isused)
{
objForgotPassword.Msgtype = 1;
objForgotPassword.ErrorMsg = "This link has been already used. Return to 'log in' page and click forgot password to generate another link.";
}
else
{
objForgotPassword.Msgtype = 2;
objForgotPassword.UserID = userDetails.UserID.ToString();
return PartialView("_EmailConfirmation", objForgotPassword);
}
}
return PartialView("_EmailConfirmation", objForgotPassword);
}
}
private CachedJobTrackingRepository()
{
this.db = new OrderMgntEntities();
}
public ActionResult UpdatePassword(ForgotPassword objForgotPassword)
{
if (ModelState.ContainsKey("EmailAddress"))
ModelState["EmailAddress"].Errors.Clear();
objForgotPassword.Msgtype = 2;
if (ModelState.IsValid)
{
using (var OrderMangtDB = new OrderMgntEntities())
{
var userDetails = OrderMangtDB.Users.ToList().Where(x => x.EmailAddress.Equals(objForgotPassword.UserID)).FirstOrDefault();
var ForgotPwds = OrderMangtDB.ForgotPwds.ToList().Where(x => x.UserID.Equals(objForgotPassword.UserID)).FirstOrDefault();
if (userDetails != null)
{
userDetails.Password = Cryptography.Encrypt(objForgotPassword.NewPassword);
ForgotPwds.Isused = true;
OrderMangtDB.SaveChanges();
// Update the entity in the database
objForgotPassword.Msgtype = 3;
}
}
}
return PartialView("_EmailConfirmation", objForgotPassword);
}
