public void AddOrderWithDetails(string email, int totalPrice, List <int> dishesCodes, List <int> dishesQuantities)
{
ClientOrder clOrder = new ClientOrder();
clOrder.OrderState = "on_Time";
clOrder.TotalPrice = totalPrice;
clOrder.DateHourIn = DateTime.Now;
clOrder.ClientEmail = email;
DAOClient daoClient = new DAOClient();
DAODish daoDish = new DAODish();
int orderCode = daoClient.AddOrder(clOrder);
for (int i = 0; i < dishesCodes.Count; i++)
{
Dish dish = daoDish.ChargeDish(dishesCodes[i]);
int quantity = dishesQuantities[i];
OrderDetail orderDetail = new OrderDetail();
orderDetail.OrderCode = orderCode;
orderDetail.DishCode = dish.DishCode;
orderDetail.DishPrice = dish.DishPrice;
orderDetail.DishQuantity = quantity;
orderDetail.SubTotal = dish.DishPrice * quantity;
daoClient.AddOrderDetail(orderDetail);
}
}
public string disableStateDish(string email, bool state)
{
string transaction = "The client is already disable";
DAOClient dc = new DAOClient();
Client cl = new Client();
cl.ClientEmail = email;
cl.ClientAvailable = state;
dc.updateStateClient(cl);
return(transaction);
}
public Boolean registerClient(Client client)
{
DAOClient daoclient = new DAOClient();
if (searchCpf(client.CPF) == null)
{
daoclient.save(client);
return(true);
}
return(false);
}
/// <summary>
/// Recherche la liste des client dont le nom contient les lettres passé en paramètre
/// </summary>
/// <param name="search"></param>
/// <returns></returns>
public List <Client> Rechercher(string search)
{
cdao = new DAOClient();
try
{
return(cdao.GetClientsByName(search));
}
catch (Exception ex)
{
throw new BLLExceptionsClient("[BLL] Rechercher : \n" + ex.Message, ex);
}
}
public static bool DeleteAll(string userName)
{
List <DTOClient> listClient = DAOClient.getListClient();
foreach (DTOClient client in listClient)
{
if (client.UserName == userName)
{
return(DAOData.DeleteAll(client.IDClient));
}
}
return(false);
}
/// <summary>
/// Mise à jour du client
/// </summary>
/// <param name="c"></param>
/// <returns></returns>
public int UpdateCLient(Client c)
{
cdao = new DAOClient();
try
{
return(cdao.UpdateClient(c));
}
catch (Exception ex)
{
throw new BLLExceptionsClient("[BLL] UpdateClient : \n" + ex.Message, ex);
}
}
public void ClientLists()
{
DAOClient doc = new DAOClient();
List <Client> ClientList = new List <Client>();
ClientList = doc.ClientList();
foreach (Client client in ClientList)
{
BLClient bldCt = new BLClient(client.ClientEmail, client.ClientName, client.ClientPassword, client.ClientAvailable);
ClientListBL.Add(bldCt);
}
}
public static Client getClient(long idClient)
{
Client client = null;
IDataReader reader = DAOClient.get(idClient);
if (reader.Read())
{
client = new Client();
if (!reader.IsDBNull(0))
{
client.IdClient = (int)reader.GetValue(0);
}
if (!reader.IsDBNull(1))
{
client.Nom = (string)reader.GetValue(1);
}
if (!reader.IsDBNull(2))
{
client.Prenom = (string)reader.GetValue(2);
}
if (!reader.IsDBNull(3))
{
client.DateNaissance = (DateTime)reader.GetValue(3);
}
if (!reader.IsDBNull(4))
{
client.Email = (string)reader.GetValue(4);
}
if (!reader.IsDBNull(5))
{
client.AdressePrincipale = (string)reader.GetValue(5);
}
if (!reader.IsDBNull(6))
{
client.AdresseTemporaire = (string)reader.GetValue(6);
}
if (!reader.IsDBNull(7))
{
client.TelFixe = (string)reader.GetValue(7);
}
if (!reader.IsDBNull(8))
{
client.TelPortable = (string)reader.GetValue(8);
}
}
reader.Close();
return(client);
}
public List <BLClient> ChargeClientLists()
{
DAOClient doc = new DAOClient();
List <Client> ClientList = new List <Client>();
List <BLClient> ListC = new List <BLClient>();
ClientList = doc.ClientList();
foreach (Client client in ClientList)
{
BLClient bldCt = new BLClient(client.ClientEmail, client.ClientName, client.ClientPassword, client.ClientAvailable);
ListC.Add(bldCt);
}
return(ListC);
}
public void AddNewClient()
{
DAOClient dc = new DAOClient();
Client cl = new Client();
cl.ClientEmail = ClientEmail;
cl.ClientName = ClientName;
cl.ClientPassword = ClientPassword;
cl.ClientAvailable = ClientAvailable;
Address ad = new Address();
ad.ClientEmail = ClientEmail;
ad.PhysicalAddress = ClientAddress;
dc.addClient(cl, ad);
}
protected void ButtonActualizar_Click(object sender, EventArgs e)
{
try
{
DAOClient update = new DAOClient();
Cliente cliente = (Cliente)Session["cliente"];
Cliente cli = new Cliente();
cli.Id = cliente.Id;
cli.Apellido_M = Request.Form["textApellidoMat"].ToString();
cli.Apellido_P = Request.Form["textApellidoPat"].ToString();
cli.Nombre = Request.Form["textNombre"].ToString();
cli.Correo = Request.Form["textemail"].ToString();
cli.Telefono = Request.Form["Telefono"].ToString();
//if (!string.IsNullOrEmpty(textcontrasena.Value))
// cli.Pass = textcontrasena.Value;
cli.Fecha_Nacimiento = cliente.Fecha_Nacimiento;
if (!string.IsNullOrEmpty(Request.Form["Tarjeta"].ToString()))
{
cli.TarjetaChalan = Request.Form["Tarjeta"].ToString();
}
bool cambio = update.UpdateCliente(cli);
if (cambio)
{
cliente.Nombre = cli.Nombre;
cliente.Apellido_M = cli.Apellido_M;
cliente.Apellido_P = cli.Apellido_P;
cliente.Telefono = cli.Telefono;
cliente.Correo = cli.Correo;
cliente.Fecha_Nacimiento = cli.Fecha_Nacimiento;
cliente.TarjetaChalan = cli.TarjetaChalan;
Session["cliente"] = cliente;
Response.Redirect("Cuenta.aspx#cuenta");
}
else
{
Response.Redirect("Cuenta.aspx#notupdate");
}
}
catch (Exception ex) { string error = ex.Message; }
}
public string UpdateClient(BLClient client)
{
string update = "No se pudo realizar la actualización";
ClientLists();
DAOClient dc = new DAOClient();
foreach (BLClient blc in ClientListBL)
{
if (blc.ClientEmail == client.ClientEmail)
{
Client cl = new Client();
cl.ClientName = client.ClientName;
cl.ClientPassword = client.ClientPassword;
cl.ClientAvailable = client.ClientAvailable;
dc.updateClient(cl);
update = "Actualización exitosa de cliente";
return(update);
}
}
return(update);
}
private void btn_Transferer_Click(object sender, EventArgs e)
{
if (txt_Mdp.Text != "" && txt_NomBase.Text != "" && txt_AdresseServeur.Text != "" && txt_Utilisateur.Text != "")
{
lbl_erreur.Text = "";
try
{
try
{
DAOClient newConnexion = new DAOClient(txt_AdresseServeur.Text, txt_Port.Text, txt_Utilisateur.Text, txt_Mdp.Text, txt_NomBase.Text);
this.cm = new ClientManager(txt_parcourir.Text, newConnexion);
this.cm.PushToDataBase();
txt_rapport.Text = this.cm.GetRapport();
txt_Mdp.Enabled = false;
txt_NomBase.Enabled = false;
txt_Port.Enabled = false;
txt_AdresseServeur.Enabled = false;
txt_MailRapport.Enabled = true;
txt_Utilisateur.Enabled = false;
btn_Ajouter.Enabled = true;
btn_Transferer.Enabled = false;
btn_Supprimer.Enabled = false;
btn_DemRapport.Enabled = true;
}
catch (NpgsqlException ex) {
MessageBox.Show("Identifiants de la BDD incorrect", "ERREUR", MessageBoxButtons.OK);
}
}
catch (Exception ex)
{
erreurIcone.SetError(txt_parcourir, "Aucun fichier n'a été selectionné !");
}
}
else
{
lbl_erreur.Text = "Certains champs n'ont pas été renseigné !";
}
}
public BLClient GetUserLoginValidation(string email, string password)
{
DAOClient da = new DAOClient();
BLClient clBL = new BLClient();
Client cl = new Client();
cl.ClientEmail = email;
cl.ClientPassword = password;
Client clFound = da.UserLoginValidation(cl);
if (clFound == null)
{
return(null);
}
else
{
clBL.ClientEmail = clFound.ClientEmail;
clBL.ClientPassword = clFound.ClientPassword;
return(clBL);
}
}
public static bool Test(string userName)
{
return(DAOClient.Test(userName));
}
public static bool Delete(string userName)
{
return(DAOClient.Delete(userName));
}
public static bool Update(DTOClient client)
{
return(DAOClient.Update(client));
}
public static bool Insert(DTOClient client)
{
return(DAOClient.Insert(client));
}
public static List <DTOClient> getListClient()
{
return(DAOClient.getListClient());
}
public static DataTable RechercherClients(CritereRechercheClient criteres)
{
return(DAOClient.getDataTable(criteres));
}
public string getNameClient(string email)
{
DAOClient client = new DAOClient();
return(client.ChargeClient(email).ClientName.ToString());
}
public ClientManager(string path, DAOClient uneConnexion)
{
this.rapport = new Rapport(path);
this.lesClients = new List <Client>();
this.pusher = uneConnexion;
}
public Client searchCpf(String cpf)
{
DAOClient daoclient = new DAOClient();
return(daoclient.rescueCPF(cpf));
}
public static bool TestLogin(string userName, string passWord)
{
return(DAOClient.TestLogin(userName, passWord));
}
public static DTOClient Search(int idClient)
{
return(DAOClient.Search(idClient));
}
//this constructor is only to use in the test fase
public ClientService()
{
DAOClient client = new DAOClient();
client.deleteAll();
}