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