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