internal bool SaveShopDepartment(ShopDepartment department) { using (DataContext) { try { if (!DataContext.ShopDepartments.Contains(department)) { department.CreatedDate = DateTime.Now; department.SortOrder = DataContext.ShopDepartments.Max(d => d.SortOrder) + 1; DataContext.ShopDepartments.Add(department); //DataContext.ShopDepartments.InsertOnSubmit(department); } else { string departmentName = department.ShopDepartmentName; department = DataContext.ShopDepartments.Single(d => d.ShopDepartmentId == department.ShopDepartmentId); department.ShopDepartmentName = departmentName; } department.ModifiedDate = DateTime.Now; DataContext.SaveChanges(); //DataContext.SubmitChanges(); return(true); } catch { return(false); } } }
protected void btnDelete_Click(object sender, EventArgs e) { LinkButton btn = sender as LinkButton; if (!string.IsNullOrEmpty(btn.Attributes["depId"])) { int departmentId = int.Parse(btn.Attributes["depId"]); ShopDepartment sd = BusinessFacade.Instance.GetShopDepartment(departmentId); string name = string.Empty; if (sd != null) { name = sd.ShopDepartmentName; } if (BusinessFacade.Instance.DeleteShopDepartment(departmentId)) { FoodCategory f = BusinessFacade.Instance.GetFoodCategoryByName(name); if (f != null) { BusinessFacade.Instance.DeleteFoodCategory(f.FoodCategoryId); } this.Rebind(); } } }
internal bool DeleteShopDepartment(int shopDepartmentId) { using (DataContext) { DataLoadOptions dlo = new DataLoadOptions(); dlo.LoadWith <ShopDepartment>(sd => sd.FoodCategories); //DataContext.LoadOptions = dlo; try { ShopDepartment department = DataContext.ShopDepartments.Single(sd => sd.ShopDepartmentId == shopDepartmentId); FoodCategory[] depFoodCat = department.FoodCategories.ToArray <FoodCategory>(); foreach (FoodCategory curr in depFoodCat) { this.DeleteFoodCategory(curr.FoodCategoryId); } DataContext.ShopDepartments.Remove(department); DataContext.SaveChanges(); //DataContext.ShopDepartments.DeleteOnSubmit(department); //DataContext.SubmitChanges(); return(true); } catch { return(false); } } }
protected void rolShopDepartments_ItemDataBound(object sender, ReorderListItemEventArgs e) { ReorderListItem rolItem = e.Item as ReorderListItem; LinkButton btn = rolItem.FindControl("btnUpdate") as LinkButton; ShopDepartment dep = e.Item.DataItem as ShopDepartment; if (dep != null) { btn.PostBackUrl = string.Format("~/Admin/ShopDepartment.aspx?depId={0}", dep.ShopDepartmentId); } btn = rolItem.FindControl("btnDelete") as LinkButton; btn.Visible = dep.AllowDelete; }
internal ShopDepartment GetShopDepartment(int departmentId) { using (DataContext) { try { ShopDepartment dep = DataContext.ShopDepartments.Single(sd => sd.ShopDepartmentId == departmentId); return(dep); } catch { return(null); } } }
protected void btnOK_Click(object sender, EventArgs e) { this.Validate(); if (!this.IsValid) { return; } ShopDepartment dep = new ShopDepartment(); dep.ShopDepartmentId = this.DepartmentId == null ? -1 : this.DepartmentId.Value; dep.ShopDepartmentName = this.txtDepName.Text; FoodCategory f = null; if (dep.ShopDepartmentId == -1) { f = new FoodCategory(); f.FoodCategoryId = -1; } else { ShopDepartment department = BusinessFacade.Instance.GetShopDepartment(this.DepartmentId.Value); f = BusinessFacade.Instance.GetFoodCategoryByName(department.ShopDepartmentName); } if (BusinessFacade.Instance.SaveShopDepartment(dep)) { f.FoodCategoryName = dep.ShopDepartmentName; f.ShopDepartmentId = dep.ShopDepartmentId; if (BusinessFacade.Instance.SaveFoodCategory(f)) { this.Response.Redirect("~/Admin/ShopDepartmentsList.aspx"); } else { BusinessFacade.Instance.DeleteShopDepartment(dep.ShopDepartmentId); } } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { if (((BasePage)Page).UserType != AppEnv.USER_ADMIN) { AppEnv.MoveToDefaultPage(); } else { if (!string.IsNullOrEmpty(this.Request["depId"])) { this.DepartmentId = int.Parse(this.Request["depId"]); ShopDepartment department = BusinessFacade.Instance.GetShopDepartment(this.DepartmentId.Value); if (department != null) { this.txtDepName.Text = department.ShopDepartmentName; } } } } }
internal bool ReorderShopDepartments(ShopDepartment[] arr) { using (DataContext) { try { foreach (ShopDepartment item in arr) { ShopDepartment dep = DataContext.ShopDepartments.Single(sd => sd.ShopDepartmentId == item.ShopDepartmentId); dep.SortOrder = item.SortOrder; dep.ModifiedDate = DateTime.Now; DataContext.SubmitChanges(); } return(true); } catch { return(false); } } }
public bool SaveShopDepartment(ShopDepartment department) { return(new AdminDA().SaveShopDepartment(department)); }
internal bool SaveShopDepartment(ShopDepartment department) { return(DataFacade.Instance.SaveShopDepartment(department)); }