/// <summary> /// Ajouter un furnisseur dans la table 'Supplier' et dans la table 'SitesSupplier' /// </summary> /// <param name="sup"></param> public static void InsertSupplier(Supplier sup, SiteSupplier ss) { SupplierDal.Insert(sup); ss.sup_id = SupplierDal.LoadAll().Last <Supplier>().sup_id; InsertSupplierSite(ss); }
/// <summary> /// Ajouter la relation Supplier-Site dans table 'SitesSupplier' /// </summary> /// <param name="ss"></param> public static void InsertSupplierSite(SiteSupplier ss) { SiteSupplierDal.Insert(ss); }
public static UInt32 Insert(SiteSupplier ssu) { return(HelperDal <SiteSupplier> .Insert(ssu, "SELECT * FROM site_supplier WHERE sit_id=0 AND sup_id=0")); }
protected void GridViewSupplier_AddSup(object sender, EventArgs e) { Supplier sup = new Supplier(); sup.sup_name = ((TextBox)GridViewSupplier.FooterRow.FindControl("txt_sup_name")).Text; sup.sup_tel = ((TextBox)GridViewSupplier.FooterRow.FindControl("txt_sup_tel")).Text; sup.sup_adr_no = ((TextBox)GridViewSupplier.FooterRow.FindControl("txt_sup_adr_no")).Text; sup.sup_adr_street = ((TextBox)GridViewSupplier.FooterRow.FindControl("txt_sup_adr_street")).Text; sup.sup_adr_city = ((TextBox)GridViewSupplier.FooterRow.FindControl("txt_sup_adr_city")).Text; sup.sup_adr_prov = ((TextBox)GridViewSupplier.FooterRow.FindControl("txt_sup_adr_prov")).Text; sup.sup_adr_pcode = ((TextBox)GridViewSupplier.FooterRow.FindControl("txt_sup_adr_pcode")).Text; Boolean suppExist = false; if (String.IsNullOrEmpty(sup.sup_name) || String.IsNullOrWhiteSpace(sup.sup_name)) { return; } foreach (Supplier supp in SupplierBll.LoadAllSupplier()) { if (supp.sup_name.Equals(sup.sup_name)) { suppExist = true; sup.sup_id = supp.sup_id; } } Site site = (Site)Session["site"]; SiteSupplier ss = new SiteSupplier(); ss.sit_id = site.sit_id; ss.sup_id = sup.sup_id; if (suppExist) { foreach (SiteSupplier ssup in SupplierBll.LoadAllSiteSupplier()) { if (ssup.sit_id.Equals(ss.sit_id) && ssup.sup_id.Equals(ss.sup_id)) { return; } } } try { if (suppExist) { SupplierBll.InsertSupplierSite(ss); } else { SupplierBll.InsertSupplier(sup, ss); } GridViewSupplier.PageIndex = GridViewSupplier.PageCount; BindDataSupplier(); } catch (ManagedException ex) { Utils.DisplayMessage(UpdatePanelSupplier, String.Format("alert(\"{0}\");", ex.Message)); } }