public ActionResult <List <Brand> > Index() { BrandDAO dao = new BrandDAO(_db); List <Brand> allBrands = dao.GetAll(); return(allBrands); }
/// <summary> /// 获取品牌信息列表 /// </summary> /// <param name="entity">参数:Brand实体</param> /// <param name="pageIndex">参数:当前页</param> /// <param name="pageSize">参数:分页个数</param> /// <param name="rowCount">参数:数据集的总数</param> /// <returns>返回Brand实体信息</returns> public BrandViewEntity[] GetList(BrandViewEntity entity, int pageIndex, int pageSize, out int rowCount) { List <IWhereCondition> wheres = new List <IWhereCondition>(); if (entity != null && entity.BrandLevel != null && Convert.ToInt32(entity.BrandLevel) > 0) { wheres.Add(new EqualsCondition() { FieldName = "b.BrandLevel", Value = entity.BrandLevel }); } if (entity != null && !string.IsNullOrEmpty(entity.BrandName)) { wheres.Add(new LikeCondition() { FieldName = "b.BrandName", HasLeftFuzzMatching = true, HasRightFuzzMathing = true, Value = entity.BrandName }); } List <OrderBy> orderbys = new List <OrderBy>(); orderbys.Add(new OrderBy() { FieldName = "CreateTime", Direction = OrderByDirections.Desc }); PagedQueryResult <BrandViewEntity> pEntity = new BrandDAO(this.CurrentUserInfo).GetList(wheres.ToArray(), orderbys.ToArray(), pageIndex, pageSize); rowCount = pEntity.RowCount; return(pEntity.Entities); }
/// <summary> /// Créer la marque lorsque l'on clique sur le bouton valider /// </summary> /// <param name="Sender"></param> /// <param name="Event"></param> private void OkButton_Click(object Sender, EventArgs Event) { int IntRef; if (int.TryParse(RefTextBox.Text, out IntRef)) { if (NameTextBox.Text != "") { if (BrandDAO.GetBrandById(IntRef) == null) { Brand NewBrand = new Brand(IntRef, NameTextBox.Text); BrandDAO.AddBrand(NewBrand); this.Close(); } else { MessageBox.Show("Ref existe déjà", "Erreur", MessageBoxButtons.OK, MessageBoxIcon.Error); } } else { MessageBox.Show("Les champs doivent etre remplient", "Erreur", MessageBoxButtons.OK, MessageBoxIcon.Error); } } else { MessageBox.Show("Référence doit etre un chiffre", "Erreur", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
protected void lv_ThongTinSP_ItemInserting(object sender, ListViewInsertEventArgs e) { if (this.objCheckPermision.Permission(this.objCheckPermision.LayQuyen("strThuongHieu_Them"))) { var t0 = new Brand(); var txt = (e.Item.FindControl("txtName")) as TextBox; if (txt != null) { t0.Name = txt.Text; } txt = (e.Item.FindControl("txtNote")) as TextBox; if (txt != null) { t0.Name = txt.Text; } BrandDAO.Insert(t0); this.lv_ThongTinSP.EditIndex = -1; this.BinList(); } else { this.iRightAccess.Visible = false; this.objControl.LoadMyControl(this.idNotPermissionAccess, NotPermissControl); } }
/// <summary> /// Supprime l'élement sélectionné du bon tableau /// </summary> /// <param name="NodeName"></param> /// <param name="SelectedItem"></param> private void DeleteItemListView(String NodeName, ListViewItem SelectedItem) { switch (NodeName) { case "Articles": ArticleDAO.DeleteArticle(SelectedItem.SubItems[2].Text); UpdateListView("Articles"); break; case "Marques": BrandDAO.DeleteBrand(int.Parse(SelectedItem.SubItems[1].Text)); UpdateListView("Marques"); break; case "Familles": FamilyDAO.DeleteFamily(int.Parse(SelectedItem.SubItems[1].Text)); UpdateListView("Familles"); break; case "Sous familles": SubFamilyDAO.DeleteSubFamily(int.Parse(SelectedItem.SubItems[1].Text)); UpdateListView("Sous familles"); break; default: break; } }
public ActionResult <List <Brand> > Index() { BrandDAO dao = new BrandDAO(_db); List <Brand> allBrands = dao.GetAll(); Console.WriteLine("in here"); Console.WriteLine(allBrands.Count); return(allBrands); }
public async Task <bool> Delete(Brand Brand) { BrandDAO BrandDAO = await DataContext.Brand.Where(x => x.Id == Brand.Id).FirstOrDefaultAsync(); DataContext.Brand.Remove(BrandDAO); await DataContext.SaveChangesAsync(); return(true); }
public async Task <bool> Update(Brand Brand) { BrandDAO BrandDAO = DataContext.Brand.Where(x => x.Id == Brand.Id).FirstOrDefault(); BrandDAO.Id = Brand.Id; BrandDAO.Name = Brand.Name; BrandDAO.CategoryId = Brand.CategoryId; await DataContext.SaveChangesAsync(); return(true); }
public static async Task Execute(Brand brand) { try { await BrandDAO.RegisterBrand(brand); } catch (Exception e) { throw e; } }
/// <summary> /// Si les modifications sont valides change la marque concernée à l'appuie sur le bouton valider /// </summary> /// <param name="Sender"></param> /// <param name="Event"></param> private void OkButton_Click(object Sender, EventArgs Event) { if (NameTextBox.Text != "") { BrandDAO.EditBrand(int.Parse(BrandNameLabel.Text), NameTextBox.Text); this.Close(); } else { MessageBox.Show("Les champs doivent etre remplient", "Erreur", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
public ActionResult FormDeleteBrand() { BrandDAO dao = new BrandDAO(); var model = dao.getAllBrands(); if (model == null) { return(RedirectToAction("Index", "Home", new { area = "" })); } return(View(model)); }
public async Task <bool> Create(Brand Brand) { BrandDAO BrandDAO = new BrandDAO(); BrandDAO.Id = Brand.Id; BrandDAO.Name = Brand.Name; BrandDAO.CategoryId = Brand.CategoryId; await DataContext.Brand.AddAsync(BrandDAO); await DataContext.SaveChangesAsync(); Brand.Id = BrandDAO.Id; return(true); }
public static async Task ValidateNew(string cnpj) { try { Validate(cnpj); var exists = await BrandDAO.CheckBrandCnpjExist(cnpj); if (exists) { throw new ValidationException("CNPJ", "Esse CNPJ de marca já está cadastrado"); } } catch (Exception e) { throw e; } }
/// <summary> /// Créé une nouvelle marque à partir de son nom /// </summary> /// <param name="NameBrandToSet"></param> public Brand(String NameBrandToSet) { NameBrand = NameBrandToSet; RefBrand = -1; int TestRef = -1; // Recherche d'un id inutilisé while (RefBrand == -1) { TestRef++; if (BrandDAO.GetBrandById(TestRef) == null) { RefBrand = TestRef; } } }
protected void lv_ThongTinSP_ItemDeleting(object sender, ListViewDeleteEventArgs e) { if (this.objCheckPermision.Permission(this.objCheckPermision.LayQuyen("strThuongHieu_Xoa"))) { var hdf = (this.lv_ThongTinSP.Items[e.ItemIndex].FindControl("hfID")) as HiddenField; if (hdf != null) { BrandDAO.Delete(Int32.Parse(hdf.Value)); this.lv_ThongTinSP.EditIndex = -1; this.BinList(); } } else { this.iRightAccess.Visible = false; this.objControl.LoadMyControl(this.idNotPermissionAccess, NotPermissControl); } }
/// <summary> /// Constructeur de la fenetre /// </summary> public AddArticleForm() { InitializeComponent(); // rempli la combo box marque avec la liste des marques existante Brand[] AllBrand = BrandDAO.GetAllBrands(); foreach (Brand B in AllBrand) { BrandComboBox.Items.Add(B); } // rempli la combo box famille avec la liste des familles existante Family[] AllFamily = FamilyDAO.GetAllFamilies(); foreach (Family F in AllFamily) { FamilyComboBox.Items.Add(F); } //attend qu'une famille soit sélectionnée SubFamilyComboBox.Items.Add("Selectionnez d'abord une famille"); }
public ActionResult DeleteBrand(string brand) { string rs = ""; BrandDAO dao = new BrandDAO(); User user = Session["User"] as User; if (user == null || user.LEVEL.Equals("10") == false) { rs = "user"; } else if (brand == null) { rs = "null"; } else if (ToolsOfAdmin.checkNull(brand) == false) { rs = "null"; } else if (ToolsOfAdmin.oneWord(brand) == false) { rs = "word"; } else if (dao.checkExit(brand) == false) { rs = "exit"; } else { var check = dao.delBrand(brand); if (check == false) { rs = "fail"; } else { rs = "success"; } } return(Json(new { result = rs }, JsonRequestBehavior.AllowGet)); }
protected void lbtnUpdate_Click(object sender, EventArgs e) { if (this.objCheckPermision.Permission(this.objCheckPermision.LayQuyen("strThuongHieu_Sua"))) { try { foreach (ListViewDataItem lvit in this.lv_ThongTinSP.Items) { string BranchID; if (((HiddenField)lvit.FindControl("hfID")).Value != "") { BranchID = ((HiddenField)lvit.FindControl("hfID")).Value; } else { this.ltr_Notice.Text = this.objComm.ShowNotice( false, "Cập nhật thông tin thất bại.\nLỗi trong quá trình nhận dạng chi nhánh"); return; } Brand t0 = BrandDAO.Get(Int32.Parse(BranchID)); t0.Name = ((TextBox)lvit.FindControl("txtName")).Text; t0.Note = ((TextBox)lvit.FindControl("txtNote")).Text; ProductDAO.Update(); } this.ltr_Notice.Text = this.objComm.ShowNotice(true, "Cập nhật thông tin thành công!"); } catch (Exception ex) { this.ltr_Notice.Text = this.objComm.ShowNotice( false, "Cập nhật thông tin thất bại. Chi tiết lỗi: " + ex.Message); } } else { this.objComm.wr( "<script language='javascript'>alert('Bạn không có quyền thực hiện chức năng này.');location.href='thong-tin-san-pham';</script>"); } }
/// <summary> /// Constructeur de la fenetre qui initialise tout les champs à partir des données de l'article modifié /// </summary> /// <param name="SelectedItem"></param> public ModifyArticleForm(ListViewItem SelectedItem) { InitializeComponent(); // rempli la combo box marque avec la liste des marques existante int Index = 0; int IndexBrand = 0; Brand[] AllBrand = BrandDAO.GetAllBrands(); foreach (Brand B in AllBrand) { BrandComboBox.Items.Add(B); if (B.ToString() == SelectedItem.SubItems[3].Text) { IndexBrand = Index; } Index++; } BrandComboBox.SelectedIndex = IndexBrand; // rempli la combo box famille avec la liste des familles existante Index = 0; int IndexFamily = 0; Family[] AllFamily = FamilyDAO.GetAllFamilies(); foreach (Family F in AllFamily) { FamilyComboBox.Items.Add(F); if (F.ToString() == SelectedItem.SubItems[4].Text) { IndexFamily = Index; } Index++; } FamilyComboBox.SelectedIndex = IndexFamily; // rempli la combo box sous famille avec la liste des sous familles appartenant à la famille selectionnée Index = 0; int IndexSubFamily = 0; SubFamilyComboBox.Items.Clear(); SubFamily[] AllLinkedSubFamilies = FamilyDAO.GetAllSubFamilies((Family)FamilyComboBox.SelectedItem); foreach (SubFamily SF in AllLinkedSubFamilies) { SubFamilyComboBox.Items.Add(SF); if (SF.ToString() == SelectedItem.SubItems[4].Text) { IndexSubFamily = Index; } Index++; } SubFamilyComboBox.SelectedIndex = IndexSubFamily; // initialise les champs avec les données de l'article modifié ArticleNameLabel.Text = SelectedItem.SubItems[2].Text; DescriptionTextBox.Text = SelectedItem.SubItems[1].Text; PriceHTTextBox.Text = SelectedItem.SubItems[6].Text; QuantityTextBox.Text = SelectedItem.SubItems[0].Text; }
private void BinList() { this.lv_ThongTinSP.DataSource = BrandDAO.Get(); this.lv_ThongTinSP.DataBind(); }
/// <summary> /// 构造函数 /// </summary> public BrandBLL(LoggingSessionInfo pUserInfo) { this.CurrentUserInfo = pUserInfo; this._currentDAO = new BrandDAO(pUserInfo); }
public Brand GetBrandById(int Id) { BrandDAO brandDAO = new BrandDAO(); return(brandDAO.GetBrandById(Id)); }
public int CreateBrandGet(Brand brand) { BrandDAO brandDAO = new BrandDAO(); return(brandDAO.CreateBrandGet(brand)); }
public void UpdateBrand(Brand brand) { BrandDAO brandDAO = new BrandDAO(); brandDAO.UpdateBrand(brand); }
private static IEnumerable <Brand> GetBrands() { return(BrandDAO.GetBrands()); }
public Brand() { lBrandDAO = new BrandDAO(); }
public void DeleteBrand(int Id) { BrandDAO brandDAO = new BrandDAO(); brandDAO.DeleteBrand(Id); }
/// <summary> /// Recréer les tableaux en fonctions des données de la bdd pour le mettre à jour /// </summary> /// <param name="NodeName"></param> private void UpdateListView(String NodeName) { int ColumnsWidth = 0; // reinitialise le trie MainListView.ListViewItemSorter = null; // choisi quel tableau mettre à jour ou créer switch (NodeName) { case "Articles": Article[] Articles = ArticleDAO.GetAllArticles(); MainListView.Columns.Clear(); MainListView.Items.Clear(); MainListView.Groups.Clear(); ColumnsWidth = MainListView.Width / 7; MainListView.Columns.Add("Quantité", ColumnsWidth); MainListView.Columns.Add("Description", ColumnsWidth); MainListView.Columns.Add("Référence", ColumnsWidth); MainListView.Columns.Add("Marque", ColumnsWidth); MainListView.Columns.Add("Famille", ColumnsWidth); MainListView.Columns.Add("Sous-Famille", ColumnsWidth); MainListView.Columns.Add("Prix H.T.", ColumnsWidth); foreach (Article A in Articles) { string[] ArticleToAdd = new string[7]; ListViewItem ArticleItem; // ajoute les items a la ListView ArticleToAdd[0] = A.Quantity.ToString(); ArticleToAdd[1] = A.Description; ArticleToAdd[2] = A.RefArticle; ArticleToAdd[3] = A.RefBrand.ToString(); ArticleToAdd[4] = A.RefSubFamily.RefFamily.ToString(); ArticleToAdd[5] = A.RefSubFamily.ToString(); ArticleToAdd[6] = A.PriceHT.ToString(); ArticleItem = new ListViewItem(ArticleToAdd); MainListView.Items.Add(ArticleItem); } break; case "Marques": Brand[] Brands = BrandDAO.GetAllBrands(); MainListView.Columns.Clear(); MainListView.Items.Clear(); MainListView.Groups.Clear(); ColumnsWidth = MainListView.Width / 2; MainListView.Columns.Add("Nom", ColumnsWidth); MainListView.Columns.Add("Référence", ColumnsWidth); foreach (Brand B in Brands) { string[] BrandToAdd = new string[2]; ListViewItem BrandItem; // ajoute les items a la ListView BrandToAdd[0] = B.NameBrand; BrandToAdd[1] = B.RefBrand.ToString(); BrandItem = new ListViewItem(BrandToAdd); MainListView.Items.Add(BrandItem); } break; case "Familles": Family[] Families = FamilyDAO.GetAllFamilies(); MainListView.Columns.Clear(); MainListView.Items.Clear(); MainListView.Groups.Clear(); ColumnsWidth = MainListView.Width / 2; MainListView.Columns.Add("Nom", ColumnsWidth); MainListView.Columns.Add("Référence", ColumnsWidth); foreach (Family F in Families) { string[] FamilyToAdd = new string[2]; ListViewItem FamilyItem; // ajoute les items a la ListView FamilyToAdd[0] = F.NameFamily; FamilyToAdd[1] = F.RefFamily.ToString(); FamilyItem = new ListViewItem(FamilyToAdd); MainListView.Items.Add(FamilyItem); } break; case "Sous familles": SubFamily[] SubFamilies = SubFamilyDAO.GetAllSubFamilies(); MainListView.Columns.Clear(); MainListView.Items.Clear(); MainListView.Groups.Clear(); ColumnsWidth = MainListView.Width / 3; MainListView.Columns.Add("Nom", ColumnsWidth); MainListView.Columns.Add("Référence", ColumnsWidth); MainListView.Columns.Add("Familles", ColumnsWidth); foreach (SubFamily SF in SubFamilies) { string[] SubFamilyToAdd = new string[3]; ListViewItem SubFamilyItem; // ajoute les items a la ListView SubFamilyToAdd[0] = SF.NameSubFamily; SubFamilyToAdd[1] = SF.RefSubFamily.ToString(); SubFamilyToAdd[2] = SF.RefFamily.ToString(); SubFamilyItem = new ListViewItem(SubFamilyToAdd); MainListView.Items.Add(SubFamilyItem); } break; default: break; } }
public void CreateBrand(Brand brand) { BrandDAO brandDAO = new BrandDAO(); brandDAO.CreateBrand(brand); }
public DataTable GetBrandAll(string lang) { BrandDAO brandDAO = new BrandDAO(); return(brandDAO.GetBrandAll(lang)); }