public async Task <ActionResult <CategorieClient> > PostCategorieClient(CategorieClient categorieClient)
{
_context.CategorieClients.Add(categorieClient);
await _context.SaveChangesAsync();
return(CreatedAtAction("GetCategorieClient", new { id = categorieClient.Id }, categorieClient));
}
public static void TotalRemiseContenuDoc(Contenu c, CategorieClient ca)
{
if ((ca != null) ? c != null : false)
{
ArticleCom a = c.Article;
if (a != null)
{
//Gestion Remise Sur l'article par le plan tarifaire
Article a_ = a.Article;
if ((a_ != null) ? ((a_.Plans != null) ? a_.Plans.Count > 0 : false) : false)
{
PlanTarifaire p = a_.Plans[0];
c.Prix = p.Puv;
c.RemiseArt = MontantRemise(p.Remise_, c.Quantite, c.PrixTotal);
}
//Gestion Remise Sur l'article par le plan de remise
foreach (PlanRemise p in ca.Remises)
{
if (p.Article.Equals(a))
{
c.RemiseCat = MontantRemise(p.Remise, c.Quantite, c.PrixTotal);
break;
}
}
}
}
}
public static List <CategorieClient> getListCategorieClient(String query)
{
NpgsqlConnection con = Connexion.Connection();
try
{
List <CategorieClient> l = new List <CategorieClient>();
NpgsqlCommand Lcmd = new NpgsqlCommand(query, con);
NpgsqlDataReader lect = Lcmd.ExecuteReader();
if (lect.HasRows)
{
while (lect.Read())
{
CategorieClient a = new CategorieClient();
a.Id = Convert.ToInt64(lect["id"].ToString());
a.Code = lect["code"].ToString();
a.Designation = lect["libelle"].ToString();
a.Remises = BLL.PlanRemiseBll.Liste("select * from yvs_com_plan_remise where actif = true and categorie =" + a.Id + " and '" + DateTime.Now + "' between date_debut and date_fin ");
a.Update = true;
l.Add(a);
}
lect.Close();
}
return(l);
}
catch (NpgsqlException e)
{
Messages.Exception(e);
return(null);
}
finally
{
Connexion.Deconnection(con);
}
}
public async Task <IActionResult> Edit(int id, [Bind("CategorieId,Nom,Description")] CategorieClient categorieClient)
{
if (id != categorieClient.CategorieId)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
_context.Update(categorieClient);
_context.Entry(categorieClient).Property(x => x.CreatedAt).IsModified = false;
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!CategorieClientExists(categorieClient.CategorieId))
{
return(NotFound());
}
else
{
throw;
}
}
catch (DbUpdateException)
{
ModelState.AddModelError("Nom", "Cette catégorie existe déjà");
return(View(categorieClient));
}
return(RedirectToAction(nameof(Index)));
}
return(View(categorieClient));
}
public ActionResult Myorder()
{
CategorieClient _categorieClient = new CategorieClient();
ViewBag.listcategorie = _categorieClient.FindAll();
return(View(Session["cart"]));
}
public async Task <IActionResult> PutCategorieClient(int id, CategorieClient categorieClient)
{
if (id != categorieClient.Id)
{
return(BadRequest());
}
_context.Entry(categorieClient).State = EntityState.Modified;
try
{
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!CategorieClientExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(NoContent());
}
public ActionResult SearchByCatigory(int id = 0)
{
CategorieClient _categorieClient = new CategorieClient();
ViewBag.listcategorie = _categorieClient.FindAll();
ProductClient _productClient = new ProductClient();
ViewBag.listProduct = _productClient.FindCategory(id);
return(View("index"));
}
public ActionResult Index()
{
CategorieClient _categorieClient = new CategorieClient();
ViewBag.listcategorie = _categorieClient.FindAll();
ProductClient _productClient = new ProductClient();
ViewBag.listProduct = _productClient.FindAll();
return(View());
}
// GET: CategorieClients
public async Task <IActionResult> Index()
{
var catClient = _context.CategoriesClient;
if (catClient.Any())
{
var catClientOrderByUpdated = catClient.OrderBy(c => c.UpdatedAt);
CategorieClient lastCatClientUpdated = catClientOrderByUpdated.Last();
ViewData["lastCatClientCreateUpdate"] = "Derniere catégorie de client ajoutée/modifiée : " + lastCatClientUpdated.Nom;
}
return(View(await catClient.ToListAsync()));
}
public void ControleCategorieClient(CategorieClient categ, int action = 1)
{
InitializeConnexion();
using (IDbCommand cmd = ImplementeConnexion.Instance.Con.CreateCommand())
{
cmd.CommandText = "sp_merge_categorie_client";
cmd.CommandType = CommandType.StoredProcedure;
SetParameter(cmd, "@code", DbType.Int32, 4, categ.Code);
SetParameter(cmd, "@designation", DbType.String, 100, categ.Designation);
SetParameter(cmd, "@action", DbType.Int32, 4, action);
cmd.ExecuteNonQuery();
}
}
public async Task <IActionResult> Create([Bind("CategorieId,Nom,Description")] CategorieClient categorieClient)
{
if (ModelState.IsValid)
{
try
{
_context.Add(categorieClient);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
catch (DbUpdateException)
{
ModelState.AddModelError("Nom", "Cette catégorie existe déjà");
return(View(categorieClient));
}
}
return(View(categorieClient));
}
public static CategorieClient getAjoutCategorieClient(CategorieClient a)
{
NpgsqlConnection con = Connexion.Connection();
try
{
string insert = "";
NpgsqlCommand cmd = new NpgsqlCommand(insert, con);
cmd.ExecuteNonQuery();
a.Id = getCurrent();
return(a);
}
catch
{
return(null);
}
finally
{
Connexion.Deconnection(con);
}
}
public static bool getUpdateCategorieClient(CategorieClient a)
{
NpgsqlConnection con = Connexion.Connection();
try
{
string update = "";
NpgsqlCommand Ucmd = new NpgsqlCommand(update, con);
Ucmd.ExecuteNonQuery();
return(true);
}
catch (Exception e)
{
Messages.Exception(e);
return(false);
}
finally
{
Connexion.Deconnection(con);
}
}
private void ControleCategorieClient(bool save)
{
try
{
if (save)
{
if (IsNotEmpty(1))
{
categClient = new CategorieClient
{
Code = "0",
Designation = TxtDesignCategClient.Text.ToUpper().Trim()
};
Glossaire.Instance.ControleCategorieClient(categClient);
}
else
{
categClient = new CategorieClient
{
Code = TxtCodeCategClient.Text.Trim(),
Designation = TxtDesignCategClient.Text.ToUpper().Trim()
};
Glossaire.Instance.ControleCategorieClient(categClient, 2);
}
}
else
{
categClient = new CategorieClient
{
Code = TxtCodeCategClient.Text.Trim(),
Designation = TxtDesignCategClient.Text.ToUpper().Trim()
};
Glossaire.Instance.ControleCategorieClient(categClient, 3);
}
ClearFields(1);
LoadCombo();
LoadGridControle(1);
}
catch (InvalidOperationException ex)
{
MessageBox.Show("Une erreur est survenue pendant l'opération ! " + ex.Message, "Information", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
}
catch (System.Data.SqlClient.SqlException ex)
{
MessageBox.Show("Une erreur est survenue pendant l'opération ! " + ex.Message, "Information", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
}
catch (Exception ex)
{
MessageBox.Show("Une erreur est survenue pendant l'opération ! " + ex.Message, "Information", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
}
finally
{
if (ImplementeConnexion.Instance.Con != null)
{
if (ImplementeConnexion.Instance.Con.State == System.Data.ConnectionState.Open)
{
ImplementeConnexion.Instance.Con.Close();
}
}
}
}
public CategorieClientBll(CategorieClient unCategorieClient)
{
categorie = unCategorieClient;
}
