public void SearchCustomer(BunifuCustomDataGrid dataGrid, string name)
{
if (name.Length > 0)
{
//if (name == "w" || name == "W")
//{
// MessageBox.Show("No Record Found For this Name", "Error Message", MessageBoxButtons.OK, MessageBoxIcon.Error);
//}
//else
//{
if (Checking(dataGrid, name))
{
}
else
{
if (!isError)
{
MessageBox.Show("No Record Found For this Name", "Error Message", MessageBoxButtons.OK, MessageBoxIcon.Error);
isError = true;
}
}
//}
}
else if (name.Length == 0)
{
GetData(dataGrid, "select * from Customer order by Name");
}
}
public void afficher_agent(BunifuCustomDataGrid dtg)
{
var cnx = new SqlConnection("Data Source=DESKTOP-PO0I2OH;Initial Catalog=db_medical_store;User ID=Lens;[email protected]?");
try
{
SqlHelper helper = new SqlHelper(prms.ToString());
if (helper.estConnecte)
{
cnx.Open();
var cmd = new SqlCommand("afficher_agent", cnx)
{
CommandType = CommandType.StoredProcedure
};
cmd.ExecuteNonQuery();
SqlDataAdapter da = new SqlDataAdapter(cmd);
var dt = new DataTable();
da.Fill(dt);
dtg.DataSource = dt;
}
}
catch (Exception e)
{
MessageBox.Show("Erreur de connexion: " + e.Message);
}
finally { cnx.Close(); cnx.Dispose(); }
}
public void GetData(BunifuCustomDataGrid dataGrid, string query)
{
try
{
using (SQLiteConnection sql = new SQLiteConnection(con))
{
sql.Open();
SQLiteCommand cmd = new SQLiteCommand(query, sql);
cmd.ExecuteNonQuery();
DataTable dt = new DataTable();
SQLiteDataAdapter da = new SQLiteDataAdapter(cmd);
da.Fill(dt);
if (dt.Rows.Count > 0)
{
string searchExpression = "Id = 1";
DataRow[] foundRows = dt.Select(searchExpression);
foreach (DataRow dr in foundRows)
{
dt.Rows.Remove(dr);
}
//dt.Rows[0].Delete();
//dt.AcceptChanges();
}
dataGrid.DataSource = dt;
sql.Close();
dataGrid.Columns["Id"].Visible = false;
dataGrid.Columns["Date"].Visible = false;
}
}
catch (Exception ex)
{
MessageBox.Show("Exception Occurs in datagridView Code.........." + ex.Message);
}
}
private void dt_Listar_DoubleClick(object sender, EventArgs e)
{
BunifuCustomDataGrid btn = sender as BunifuCustomDataGrid;
switch (this.numero)
{
case 1:
if (btn.SelectedRows.Count.Equals(1))
{
idPer = int.Parse(btn.CurrentRow.Cells[0].Value.ToString());
IniciarSubFormulario();
}
else
{
SystemSounds.Hand.Play();
}
break;
case 2:
if (btn.SelectedRows.Count.Equals(1))
{
idEva = int.Parse(btn.CurrentRow.Cells[0].Value.ToString());
IniciarSubFormulario();
}
else
{
SystemSounds.Hand.Play();
}
break;
}
}
public void rechercher_agent_par_matricule(string matricule_agent, BunifuCustomDataGrid dtg)
{
SqlConnection cnx = new SqlConnection(prms.ToString());
try
{
if (cnx.State == ConnectionState.Closed)
{
cnx.Open();
}
string requete = "recherche_agent_par_matricule";
SqlCommand cmd = new SqlCommand(requete, cnx);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("matricule_agent", SqlDbType.NVarChar)).Value = matricule_agent;
cmd.ExecuteNonQuery();
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
da.Fill(dt);
dtg.DataSource = dt;
}
catch (Exception e)
{
MessageBox.Show("Erreur de connexion: " + e.Message);
}
finally { cnx.Close(); cnx.Dispose(); }
}
private bool Checking(BunifuCustomDataGrid dataGrid, string name)
{
using (SQLiteConnection sql = new SQLiteConnection(con))
{
sql.Open();
SQLiteDataAdapter da = new SQLiteDataAdapter("select * from Expenses where Name like '" + name + "%'", sql);
DataTable dt = new DataTable();
if (da != null)
{
da.Fill(dt);
}
if (dt.Rows.Count > 0)
{
foreach (DataRow row in dt.Rows)
{
double sdate = Convert.ToDouble(row["Datetime"]);
var sfinal = DateTime.FromOADate(sdate);
row["Datetime"] = sfinal.ToString("dd-MM-yyyy");
}
dataGrid.DataSource = dt;
sql.Close();
return(true);
}
else
{
sql.Close();
return(false);
}
}
}
private bool Checking(BunifuCustomDataGrid dataGrid, string name)
{
using (SQLiteConnection sql = new SQLiteConnection(con))
{
sql.Open();
SQLiteDataAdapter da = new SQLiteDataAdapter("select * from Units where Name like '" + name + "%'", sql);
//da.SelectCommand.Parameters.AddWithValue("@Name", txt_search.Text);
DataTable dt = new DataTable();
if (da != null)
{
da.Fill(dt);
}
if (dt.Rows.Count > 0)
{
dataGrid.DataSource = dt;
sql.Close();
return(true);
}
else
{
sql.Close();
return(false);
}
}
}
private bool Checking(BunifuCustomDataGrid dataGrid, string name)
{
using (SQLiteConnection sql = new SQLiteConnection(con))
{
sql.Open();
SQLiteDataAdapter da = new SQLiteDataAdapter("select Products.Id,Products.Name,Products.Price,Products.ImageUrl,Categories.Id as CategoryID,Products.UnitID,Products.ShortCode,Categories.Name as Category from Products inner join Categories on Products.CategoryID = Categories.Id where Name like '" + name + "%'", sql);
//da.SelectCommand.Parameters.AddWithValue("@Name", txt_search.Text);
DataTable dt = new DataTable();
if (da != null)
{
da.Fill(dt);
}
if (dt.Rows.Count > 0)
{
dataGrid.DataSource = dt;
sql.Close();
return(true);
}
else
{
sql.Close();
return(false);
}
}
}
private bool Checking(BunifuCustomDataGrid dataGrid, string name)
{
using (SQLiteConnection sql = new SQLiteConnection(con))
{
sql.Open();
SQLiteDataAdapter da = new SQLiteDataAdapter("select Stock_Update.Id,Stock.Product_Id as Name,Stock_Update.Quantity,Stock_Update.Price,Stock_Update.Datetime,Stock_Update.Last_Available,Stock.Quantity as StockQuantity,Stock.Product_Id as ProductID from Stock inner join Stock_Update on Stock_Update.ProductID = Stock.Product_Id where Stock_Update.Datetime = @Datetime and Stock.Product_Id like '" + name + "%'", sql);
da.SelectCommand.Parameters.AddWithValue("@Datetime", "" + Convert.ToInt32(DateTime.Now.Date.ToOADate()));
DataTable dt = new DataTable();
if (da != null)
{
da.Fill(dt);
}
if (dt.Rows.Count > 0)
{
foreach (DataRow row in dt.Rows)
{
double sdate = Convert.ToDouble(row["Datetime"]);
var sfinal = DateTime.FromOADate(sdate);
row["Datetime"] = sfinal.ToString("dd-MM-yyyy");
}
dataGrid.DataSource = dt;
sql.Close();
return(true);
}
else
{
sql.Close();
return(false);
}
}
}
public bool DateWiseExpenses(BunifuCustomDataGrid dataGrid, int date)
{
using (SQLiteConnection sql = new SQLiteConnection(con))
{
sql.Open();
SQLiteDataAdapter da = new SQLiteDataAdapter("select * from Expenses where Datetime=@Datetime", sql);
da.SelectCommand.Parameters.AddWithValue("@Datetime", date);
DataTable dt = new DataTable();
if (da != null)
{
da.Fill(dt);
}
if (dt.Rows.Count > 0)
{
foreach (DataRow row in dt.Rows)
{
double sdate = Convert.ToDouble(row["Datetime"]);
var sfinal = DateTime.FromOADate(sdate);
row["Datetime"] = sfinal.ToString("dd-MM-yyyy");
}
dataGrid.DataSource = dt;
sql.Close();
return(true);
}
else
{
sql.Close();
return(false);
}
}
}
public void Preencher(BunifuCustomDataGrid tableOrcamento, string _marca, Label _lblSemDados)
{
try
{
DataTable dataTable = new DataTable();
using (SqlConnection conexao = OpenConnection())
{
string query = "select * from tb_orcamento where orc_aparelho = @marca";
SqlCommand cmd = new SqlCommand(query, conexao);
cmd.Parameters.AddWithValue("@marca", _marca);
SqlDataAdapter adapter = new SqlDataAdapter(cmd);
adapter.Fill(dataTable);
if (dataTable.Rows.Count <= 0)
{
_lblSemDados.Visible = true;
}
else
{
_lblSemDados.Visible = false;
}
tableOrcamento.DataSource = dataTable;
tableOrcamento.Sort(tableOrcamento.Columns["orc_id"], ListSortDirection.Descending);
}
}
catch (Exception ex)
{
MessageBox.Show("Erro ao preencher a tabela.\n\n\nErro: " + ex, "ERRO", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
public void GetData(BunifuCustomDataGrid dataGrid, string query)
{
try
{
using (SQLiteConnection sql = new SQLiteConnection(con))
{
sql.Open();
SQLiteCommand cmd = new SQLiteCommand(query, sql);
cmd.ExecuteNonQuery();
DataTable dt = new DataTable();
SQLiteDataAdapter da = new SQLiteDataAdapter(cmd);
da.Fill(dt);
if (dt.Rows.Count > 0)
{
foreach (DataRow row in dt.Rows)
{
double sdate = Convert.ToDouble(row["Datetime"]);
var sfinal = DateTime.FromOADate(sdate);
//row["Datetime"] = sfinal.ToString("dd-MM-yyyy");
row["Datetime"] = sfinal.ToString("dd-MM-yyyy");
}
}
dataGrid.DataSource = dt;
sql.Close();
dataGrid.Columns["Id"].Visible = false;
}
}
catch (Exception ex)
{
MessageBox.Show("Exception Occurs in datagridView Code.........." + ex.Message);
}
}
public bool AllStock(BunifuCustomDataGrid dataGrid)
{
using (SQLiteConnection sql = new SQLiteConnection(con))
{
sql.Open();
SQLiteDataAdapter da = new SQLiteDataAdapter("select Stock_Update.Id, Stock.Product_Id as Name, Stock_Update.Quantity, Stock_Update.Price, Stock_Update.Datetime, Stock_Update.Last_Available, Stock.Quantity as StockQuantity, Stock.Product_Id as ProductID from Stock inner join Stock_Update on Stock_Update.ProductID = Stock.Product_Id order by Stock_Update.Datetime", sql);
DataTable dt = new DataTable();
if (da != null)
{
da.Fill(dt);
}
if (dt.Rows.Count > 0)
{
foreach (DataRow row in dt.Rows)
{
double sdate = Convert.ToDouble(row["Datetime"]);
var sfinal = DateTime.FromOADate(sdate);
row["Datetime"] = sfinal.ToString("dd-MM-yyyy");
}
dataGrid.DataSource = dt;
sql.Close();
dataGrid.Columns["StockQuantity"].Visible = false;
dataGrid.Columns["ProductID"].Visible = false;
dataGrid.Columns["Id"].Visible = false;
return(true);
}
else
{
sql.Close();
return(false);
}
}
}
private void getValuesTable(BunifuCustomDataGrid table, int value)
{
id = int.Parse(table.CurrentRow.Cells[0].Value.ToString());
if (table.CurrentRow != null)
{
int until = table.Rows.Count;
if (value == 1)
{
for (int y = 0; y < until; y++)
{
kirim_grid.CurrentRow.Cells[y].Selected = true;
chiqim_grid.CurrentRow.Cells[y].Selected = false;
}
}
else
{
for (int y = 0; y < 4; y++)
{
chiqim_grid.CurrentRow.Cells[y].Selected = true;
kirim_grid.CurrentRow.Cells[y].Selected = false;
}
}
}
TableId = value;
coming_amount.Text = table.CurrentRow.Cells[2].Value.ToString();
приход_date.Value = DateTime.Parse(table.CurrentRow.Cells[3].Value.ToString());
}
private void searchTable(BunifuCustomDataGrid table)
{
BindingSource bs = new BindingSource();
bs.DataSource = table.DataSource;
//bs.Filter = "sana like '%" + tv_search.Text + "%'";
table.DataSource = bs;
}
private float[] RecuperarTamaño(BunifuCustomDataGrid dt)
{
float[] tamaño = new float[dt.ColumnCount];
for (int i = 0; i < dt.ColumnCount; i++)
{
tamaño[i] = (float)dt.Columns[i].Width;
}
return(tamaño);
}
public void View(BunifuCustomDataGrid dataGid)
{
using (QLNTEntities1 db = new QLNTEntities1())
{
var result = from c in db.NhaCungCap
select new { TenNCC = c.TenNCC, SoDienThoai = c.SoDienThoai, DiaChi = c.DiaChi, MaNCC = c.MaNCC };
dataGid.DataSource = result.ToList();
}
}
public void Search(BunifuCustomDataGrid dataGrid, string s)
{
using (QLNTEntities1 db = new QLNTEntities1())
{
var result = from c in db.PhanBons
where c.TenPB.Contains(s)
select new { TenPB = c.TenPB, Loai = c.Loai, KhoiLuong = c.KhoiLuong.ToString(), SoLuong = c.SoLuong, DonGia = c.DonGia, NgaySX = c.NgaySX.Day + "/" + c.NgaySX.Month + "/" + c.NgaySX.Year, HanSD = c.HanSD.Day + "/" + c.HanSD.Month + "/" + c.HanSD.Year, MaPB = c.MaPB };
dataGrid.DataSource = result.ToList();
}
}
public void Search(BunifuCustomDataGrid dataGrid, string s)
{
using (QLNTEntities1 db = new QLNTEntities1())
{
var result = from c in db.ThuocBaoVeTV
where c.TenThuoc.Contains(s)
select new { TenThuoc = c.TenThuoc, ThoiGianCachLy = c.ThoiGianCachLy, NoiSX = c.NoiSX, Dang = c.Dang, SoLuong = c.SoLuong, CongDung = c.CongDung, NgaySX = c.NgaySX, HanSD = c.HanSD, MaThuoc = c.MaThuoc, MaDoc = c.MaDoc };
dataGrid.DataSource = result.ToList();
}
}
public void View(BunifuCustomDataGrid dataGrid)
{
using (QLNTEntities1 db = new QLNTEntities1())
{
//var result = from c in db.PhanBons select new { TenPB=c.TenPB, Loai=c} ;
var result = from c in db.Cay
select new { TenCay = c.TenCay, SoLuong = c.SoLuong, MuaThuHoach = c.MuaThuHoach, NamTrongCay = c.NamTrongCay, MaLoaiCay = c.MaLoaiCay };
dataGrid.DataSource = result.ToList();
}
}
public void View(BunifuCustomDataGrid dataGid)
{
using (QLNTEntities1 db = new QLNTEntities1())
{
//var result = from c in db.PhanBons select new { TenPB=c.TenPB, Loai=c} ;
var result = from c in db.KhachHang
select new { TenKH = c.TenKH, DienThoai = c.DienThoai, DiaChi = c.DiaChi, MaKH = c.MaKH };
dataGid.DataSource = result.ToList();
}
}
public void View(BunifuCustomDataGrid dataGrid)
{
using (QLNTEntities1 db = new QLNTEntities1())
{
//var result = from c in db.NongSans select new { TenPB=c.TenPB, Loai=c} ;
var result = from c in db.NongSans
select new { ThoiGianBaoQuan = c.ThoiGianBaoQuan, SanLuongTonKho = c.SanLuongTonKho, DonGia = c.DonGia, BaoQuan = c.BaoQuan };
dataGrid.DataSource = result.ToList();
}
}
public void Search(BunifuCustomDataGrid dataGrid, string s)
{
using (QLNTEntities1 db = new QLNTEntities1())
{
var result = from c in db.Cay
where c.TenCay.Contains(s)
select new { TenCay = c.TenCay, SoLuong = c.SoLuong, MuaThuHoach = c.MuaThuHoach, NamTrongCay = c.NamTrongCay, MaLoaiCay = c.MaLoaiCay };
dataGrid.DataSource = result.ToList();
}
}
public void getCTKeHoach(string id, BunifuCustomDataGrid dataGrid)
{
QLNTEntities1 db = new QLNTEntities1();
int ma = Convert.ToInt32(id);
var result = from c in db.ChiTietKH
join d in db.LoaiKH on c.MaLoai equals d.MaLoai
where c.MaKH == ma
select new { CongViec = d.TenLoai, HoanThanh = c.HoanThanh, MaLoai = c.MaLoai };
dataGrid.DataSource = result.ToList();
}
public void View(BunifuCustomDataGrid dataGid)
{
using (QLNTEntities1 db = new QLNTEntities1())
{
var result = from c in db.NhanVien
join q in db.Quyen on c.MaQuyen equals q.MaQuyen
where q.MaQuyen != 1
select new { TenNV = c.TenNV, SoDienThoai = c.SoDienThoai, DiaChi = c.DiaChi, MatKhau = c.MatKhau, MaNV = c.MaNV, TenChucVu = q.TenChucVu, MaQuyen = q.MaQuyen };
dataGid.DataSource = result.ToList();
}
}
public void View(BunifuCustomDataGrid dataGrid)
{
using (QLNTEntities1 db = new QLNTEntities1())
{
//var result = from c in db.PhanBons select new { TenPB=c.TenPB, Loai=c} ;
var result = from c in db.ThuocBaoVeTV
select new { TenThuoc = c.TenThuoc, ThoiGianCachLy = c.ThoiGianCachLy, NoiSX = c.NoiSX, Dang = c.Dang, SoLuong = c.SoLuong, CongDung = c.CongDung, NgaySX = c.NgaySX, HanSD = c.HanSD, MaThuoc = c.MaThuoc, MaDoc = c.MaDoc };
dataGrid.DataSource = result.ToList();
}
}
// thêm chi tiết kế hoạch chưa có
public void ShowAddCtKH(int id, BunifuCustomDataGrid dataGrid)
{
using (QLNTEntities1 db = new QLNTEntities1())
{
var result = from l in db.LoaiKH
where !(from c in db.ChiTietKH
where c.MaKH == id
select c.MaLoai
).Contains(l.MaLoai)
select new { MaLoai = l.MaLoai, CongViec = l.TenLoai };
dataGrid.DataSource = result.ToList();
}
}
private void AddButton(BunifuCustomDataGrid dataGrid, string text)
{
_col = new DataGridViewButtonColumn
{
HeaderText = "",
Text = text,
UseColumnTextForButtonValue = true,
Width = 90,
DefaultCellStyle = { ForeColor = Color.DarkCyan, BackColor = Color.White },
FlatStyle = FlatStyle.Flat,
DisplayIndex = dataGrid.Columns.Count + 1
};
dataGrid.Columns.Add(_col);
}
public void PesquisarClienteNome(string _nomeCliente, BunifuCustomDataGrid tabelaClientes)
{
using (SqlConnection con = OpenConnection())
{
DataTable datatable = new DataTable();
string query = "select cl_id, cl_nome, cl_cpf, cl_telefone from tb_clientes where cl_nome like @nomeCliente";
SqlCommand cmd = new SqlCommand(query, con);
cmd.Parameters.AddWithValue("@nomeCliente", String.Format("%{0}%", _nomeCliente));
SqlDataAdapter adapter = new SqlDataAdapter(cmd);
adapter.SelectCommand.ExecuteNonQuery();
adapter.Fill(datatable);
tabelaClientes.DataSource = datatable;
}
}
public void Search(BunifuCustomDataGrid dataGid, string s)
{
using (QLNTEntities1 db = new QLNTEntities1())
{
var result = from c in db.KhachHang
where c.TenKH.Contains(s)
select new {
MaKH = c.MaKH,
TenKH = c.TenKH,
DienThoai = c.DienThoai,
DiaChi = c.DiaChi
};
dataGid.DataSource = result.ToList();
}
}
