protected override void Page_Load_Extended(object sender, EventArgs e) { estateAgentDB = new SimplicityWebEstateAgentEntities(); if (!IsPostBack) { Simplicity.Data.SimplicityEntities simplicityDB = new Simplicity.Data.SimplicityEntities(); int prodId = int.Parse(AppSettings["EAProductIDInSimplicity"]); IEnumerable<Simplicity.Data.Company> companies = (from comp in simplicityDB.CompanyProducts where comp.ProductID == prodId select comp.Company); ddlCompanies.DataSource = companies; ddlCompanies.DataBind(); if (loggedInUserRole != WebConstants.Roles.Admin) { hfCoId.Value = loggedInUserCoId.ToString(); ddlCompanies.Visible = false; lblCompany.Visible = false; } else { ddlCompanies.Visible = true; lblCompany.Visible = true; hfCoId.Value = ddlCompanies.SelectedValue; } int compId = int.Parse(hfCoId.Value); IEnumerable<EstateAgentEntityModel.RefDepartment> departments = (from dept in estateAgentDB.RefDepartments where dept.CompanySequence == compId && dept.FlgDeleted != true select dept); GridView1.DataSource = departments; GridView1.DataBind(); } }
protected override void Page_Load_Extended(object sender, EventArgs e) { SimplicityWebEstateAgentEntities estateAgentDB = new SimplicityWebEstateAgentEntities(); IEnumerable<EstateAgentEntityModel.RefDepartment> departments = (from dept in estateAgentDB.RefDepartments where dept.CompanySequence == loggedInUserCoId && dept.FlgDeleted != true select dept); if (departments.Count() > 0) { IEnumerable<EstateAgentEntityModel.RefCategory> categories = (from categ in estateAgentDB.RefCategories where categ.CompanySequence == loggedInUserCoId && categ.FlgDeleted != true select categ); if (categories.Count() <= 0) { Response.Redirect("~/Maintenance/AddCategories.aspx?" + WebConstants.Request.NO_CATEGORY + "=true"); } foreach (var department in departments) { if (department != null) { firstDepartmentId = department.Sequence; Department_Page_Handling(sender, e); } else { Response.Redirect("~/Maintenance/AddDepartment.aspx?" + WebConstants.Request.NO_DEPT + "=true"); } break; } } else { Response.Redirect("~/Maintenance/AddDepartment.aspx?" + WebConstants.Request.NO_DEPT + "=true"); } }
protected void btnSave_Click(object sender, EventArgs e) { try { SimplicityWebEstateAgentEntities estateAgentDB = new SimplicityWebEstateAgentEntities(); EstateAgentEntityModel.RefCategory category = new RefCategory(); category.CompanySequence = loggedInUserCoId; category.CreatedBy = loggedInUserId; category.DateCreated = System.DateTime.Now; category.LastAmendedBy = loggedInUserId; category.DateLastAmended = System.DateTime.Now; category.CategoryDesc = txtCategoryDescription.Text; category.FlgDeleted = false; IEnumerable<EstateAgentEntityModel.RefCategory> categories = (from categ in estateAgentDB.RefCategories where categ.CompanySequence == loggedInUserCoId select categ); category.RowIndex = (categories.Count() + 1); estateAgentDB.RefCategories.AddObject(category); estateAgentDB.SaveChanges(); Response.Redirect("CategoriesList.aspx"); } catch (Exception exc) { SetErrorMessage(WebConstants.Messages.Error.CONNECTION_ERROR); } }
protected void InitializeComponent() { if (Request[WebConstants.Request.PROPERTY_ORDER_ID] != null && Request[WebConstants.Request.PROPERTY_ORDER_ID].CompareTo("") != 0) { int propertyId = int.Parse(Request[WebConstants.Request.PROPERTY_ORDER_ID]); menuItems.Add("Main", "AddOrder.aspx?" + WebConstants.Request.PROPERTY_ORDER_ID + "=" + propertyId); menuItems.Add("Room Details", "AddOrderPeople.aspx?" + WebConstants.Request.PROPERTY_ORDER_ID + "=" + propertyId); hlAddRoomPannel.Visible = true; linkAddRoom.NavigateUrl = "~/Orders/AddRoom.aspx?" + WebConstants.Request.PROPERTY_ORDER_ID + "=" + propertyId; SimplicityWebEstateAgentEntities estateAgentDB = new SimplicityWebEstateAgentEntities(); IEnumerable<EstateAgentEntityModel.PropertyRoom> propertyRooms = (from propRooms in estateAgentDB.PropertyRooms where propRooms.PropertySequence == propertyId select propRooms); foreach (EstateAgentEntityModel.PropertyRoom room in propertyRooms) { menuItems.Add(room.RoomHeading + WebConstants.ToSplit.ROOM_TAB_SPLIT + room.Sequence, "AddRoom.aspx?" + WebConstants.Request.PROPERTY_ORDER_ID + "=" + propertyId + "&" + WebConstants.Request.Room_ID + "=" + room.Sequence); } } else { menuItems.Add("Main", "AddOrder.aspx"); } StringBuilder lis = new StringBuilder(); lis.Append("<div style='width:100%'>"); foreach (KeyValuePair<string, string> kvPair in menuItems) { if (kvPair.Key.Equals(Selected)) { lis.Append("<div class='floatLeft'><img src=" + ResolveClientUrl("~/images/btn_y_left.jpg") + " width='8' height='33' /></div>"); lis.Append("<div class='mid_yellow'><a class='txt_yellow' href='").Append(kvPair.Value); } else { lis.Append("<div class='floatLeft'><img src=" + ResolveClientUrl("~/images/btn_b_left.jpg") + " width='8' height='33' /></div>"); lis.Append("<div class='mid_blue'><a class='txt_blue' href='").Append(kvPair.Value); } if(Request[WebConstants.Request.DEPT_ORDER_ID] != null) { lis.Append("?").Append(WebConstants.Request.DEPT_ORDER_ID).Append("=").Append(Request[WebConstants.Request.DEPT_ORDER_ID]); } String keyToPrint = kvPair.Key.Split(new String[] { WebConstants.ToSplit.ROOM_TAB_SPLIT }, StringSplitOptions.None)[0]; lis.Append("'>").Append(keyToPrint).Append("</a></div>"); if (kvPair.Key.Equals(Selected)) { lis.Append("<div class='floatLeft'><img style='margin-right:4px' src=" + ResolveClientUrl("~/images/btn_y_right.jpg") + " width='8' height='33' /></div>"); } else { lis.Append("<div class='floatLeft'><img style='margin-right:4px' src=" + ResolveClientUrl("~/images/btn_b_right.jpg") + " width='8' height='33' /></div>"); } } lis.Append("</div>"); LiList = lis.ToString(); }
protected void btnUpdate_Click(object sender, EventArgs e) { try { SimplicityWebEstateAgentEntities estateAgentDB = new SimplicityWebEstateAgentEntities(); int categoryId = int.Parse(Request[WebConstants.Request.CATEGORY_ID]); EstateAgentEntityModel.RefCategory category = estateAgentDB.RefCategories.SingleOrDefault(categ => categ.Sequence == categoryId); category.DateLastAmended = System.DateTime.Now; category.LastAmendedBy = loggedInUserId; category.CategoryDesc = txtCategoryDescription.Text; estateAgentDB.SaveChanges(); Response.Redirect("CategoriesList.aspx"); } catch { SetErrorMessage(WebConstants.Messages.Error.CONNECTION_ERROR); } }
protected override void Page_Load_Extended(object sender, EventArgs e) { Simplicity.Data.SimplicityEntities simplicityDB = new Simplicity.Data.SimplicityEntities(); int prodId = int.Parse(AppSettings["EAProductIDInSimplicity"]); IEnumerable<Simplicity.Data.Company> companies = (from comp in simplicityDB.CompanyProducts where comp.ProductID == prodId select comp.Company); ddlCompany.DataSource = companies; ddlCompany.DataBind(); if (loggedInUserRole != WebConstants.Roles.Admin) { ddlCompany.SelectedValue = loggedInUserCoId.ToString(); lblCompany.Visible = false; ddlCompany.Visible = false; } if (Request[WebConstants.Request.NO_CATEGORY] != null)//to do { SetErrorMessage(WebConstants.Messages.Error.NO_CATEGORY_DEFINED); } if (Request[WebConstants.Request.CATEGORY_ID] != null) { if (IsPostBack == false) { SimplicityWebEstateAgentEntities estateAgentDB = new SimplicityWebEstateAgentEntities(); int categId = int.Parse(Request[WebConstants.Request.CATEGORY_ID]); EstateAgentEntityModel.RefCategory category = estateAgentDB.RefCategories.SingleOrDefault(categ => categ.Sequence == categId); if (category != null) { ddlCompany.SelectedValue = category.CompanySequence.ToString(); ddlCompany.Enabled = false; txtCategoryDescription.Text = category.CategoryDesc; btnUpdate.Visible = true; btnSave.Visible = false; } else { SetErrorMessage(WebConstants.Messages.Error.INVALID_ID); } } } else { btnUpdate.Visible = false; btnSave.Visible = true; } }
protected override void Department_Page_Handling(object sender, EventArgs e) { estateAgentDB = new SimplicityWebEstateAgentEntities(); IEnumerable<EstateAgentEntityModel.RefDepartment> departments = (from dept in estateAgentDB.RefDepartments where dept.CompanySequence == loggedInUserCoId && dept.FlgDeleted != true select dept); ddlDepartments.DataSource = departments; ddlDepartments.DataBind(); IEnumerable<EstateAgentEntityModel.RefCategory> categories = (from categ in estateAgentDB.RefCategories where categ.CompanySequence == loggedInUserCoId && categ.FlgDeleted != true select categ); ddlCategory.DataSource = categories; ddlCategory.DataBind(); }