private void btnSupprimer_Click(object sender, EventArgs e)
{
if (gridClient.SelectedRows.Count == 0)
{
MessageBox.Show("Selectionner la ligne entiere." + "\n" + "Cliquer sur le curseur à gauche du datagid", "Erreur de selection", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
if (MessageBox.Show("Voulez vous supprimer ce client?", "Confirmation de la suppression", MessageBoxButtons.YesNo, MessageBoxIcon.Question, MessageBoxDefaultButton.Button2) == DialogResult.Yes)
{
bl = new BALClient();
bc = new BALCommande();
bc.deleteCommande(gridClient.SelectedRows[0].Cells[0].Value.ToString());
bl.deleteClient(gridClient.SelectedRows[0].Cells[0].Value.ToString());
remplirDatagrdview();
}
}
public static DAL.ClientDetails ViewClient(String ClientID)
{
try
{
Icontext objinter = new BALClient();
DAL.ClientDetails Client = (DAL.ClientDetails)objinter.ViewRecord(Convert.ToInt64(ClientID));
return Client;
}
catch (Exception ex)
{
throw;
}
}
public static Boolean UpdateUserInClient(UserInClientClass map)
{
Boolean flag = false;
try
{
IMapping objtext = new BALClient();
flag = objtext.UpdateMapping(map);
}
catch (Exception ex)
{
throw;
}
return flag;
}
public static bool UpdateClient(Client client)
{
Boolean flag = false;
try
{
Icontext objinter = new BALClient();
flag = objinter.UpdateRecord(client);
}
catch (Exception ex)
{
throw;
}
return flag;
}
public static List<SelectListItem> SearchFieldDDList()
{
ISearchField sobj = new BALClient();
List<SelectListItem> lstsearchField = sobj.SearchField();
return lstsearchField;
}
public static UserInClientList EditUserInclient(String mapinID)
{
UserInClientList mapp = new UserInClientList();
try
{
IMapping objtext = new BALClient();
mapp = (UserInClientList)objtext.EditMapping(Convert.ToInt64(mapinID));
}
catch (Exception ex)
{
throw;
}
return mapp;
}
public static Client EditClient(String clientID)
{
try
{
Icontext objinter = new BALClient();
Client client = (Client)objinter.EditRecord(Convert.ToInt64(clientID));
return client;
}
catch (Exception ex)
{
throw;
}
}
public static Boolean CreateClient(Client client)
{
Boolean flag = false;
try
{
Icontext objtext = new BALClient();
flag = objtext.CreateRecord(client);
}
catch (Exception ex)
{
throw;
}
return flag;
}
public static IEnumerable<DAL.ClientList> ClientList(String Field, String value)
{
try
{
ISearchResult objtext = new BALClient();
IEnumerable<DAL.ClientList> listRecord = (IEnumerable<DAL.ClientList>)objtext.SearchResultList(Field, value);
return listRecord;
}
catch (Exception ex)
{
throw;
}
}
public static IEnumerable<DAL.ClientList> ClientList()
{
try
{
Icontext objtext = new BALClient();
IEnumerable<DAL.ClientList> listRecord = (IEnumerable<DAL.ClientList>)objtext.RecordList();
return listRecord;
}
catch (Exception ex)
{
throw;
}
}
public static String AddClient(Client client)
{
String user_id = String.Empty;
try
{
IRecordSave objtext = new BALClient();
user_id = objtext.AddRecord(client);
}
catch (Exception ex)
{
throw;
}
return user_id;
}
public static void rechercheCmd(DataGridView dgv, TextBox[] infos, DateTimePicker[] dates)
{
dgv.Rows.Clear();
OleDbConnection cn = new OleDbConnection();
cn = Global.seConnecter(Global.cs);
try
{
string sql = "numcmd like '%" + infos[0].Text + "%' and numclient = " + BALClient.getIDByNom(infos[1].Text);
//+ " and datecmd between '" + dates[0].Value.ToString() +"' and '" + dates[0].Value.ToString()+"'"
OleDbDataReader reader = Global.ExecuterOleDBSelect(@"select * from commande where " + sql, cn);
while (reader.Read())
{
dgv.Rows.Add(reader.GetValue(0), reader.GetValue(1), getClientById(reader.GetValue(2).ToString()), reader.GetValue(2));
}
reader.Close();
}
catch (Exception)
{
}
Global.seDeconnecter(cn);
}