public UCReportEmployeeClem(FRMMain mFRM)
{
InitializeComponent();
fRMMain = mFRM;
conDB = new ConMySql();
convertDT = new ConvertDateTime();
}
public UCAddCompany(FRMMain mFRM)
{
InitializeComponent();
fRMMain = mFRM;
conDB = new ConMySql();
convertDT = new ConvertDateTime();
}
public void CarregarGrid()
{
ConMySql conexao = new ConMySql();
conexao.ligar();
DataTable dtIncidente = new DataTable();
try
{
string comando = @"select * from incidente order by data_abertura";
MySqlDataAdapter Adapter = new MySqlDataAdapter(comando, conexao.con());
Adapter.Fill(dtIncidente);
dgvIncidente.DataSource = dtIncidente;
for (int count = 0; count < dtIncidente.Rows.Count; count++)
{
dgvIncidente.Rows[count].Cells[0].Value = dtIncidente.Rows[count]["titulo"];
dgvIncidente.Rows[count].Cells[1].Value = dtIncidente.Rows[count]["cliente"].ToString();
dgvIncidente.Rows[count].Cells[2].Value = dtIncidente.Rows[count]["Solicitante"].ToString();
dgvIncidente.Rows[count].Cells[3].Value = dtIncidente.Rows[count]["tipo"].ToString();
dgvIncidente.Rows[count].Cells[4].Value = dtIncidente.Rows[count]["usuario_atendente"].ToString();
}
dgvIncidente.ClearSelection();
}
catch (Exception EX)
{
MessageBox.Show("ERRO AO BUSCAR CLIENTES" + "\n" + EX.Message);
}
}
public UCReportEmployeeClem(FRMMain mFRM)
{
InitializeComponent();
fRMMain = mFRM;
conDB = new ConMySql();
convertDT = new ConvertDateTime();
}
private void BtnPesquisar_Click(object sender, EventArgs e)
{
ConMySql conexao = new ConMySql();
conexao.ligar();
DataTable dtCliente = new DataTable();
try
{
string comando = $@"SELECT * FROM cliente where nome like '%{txtPesquisar.Text}%'";
//WHERE(SP.PES_NUMERO = {txtPesquisar.Text}) ";
MySqlDataAdapter Adapter = new MySqlDataAdapter(comando, conexao.con());
Adapter.Fill(dtCliente);
dgvCliente.DataSource = dtCliente;
for (int count = 0; count < dtCliente.Rows.Count; count++)
{
dgvCliente.Rows[count].Cells[0].Value = dtCliente.Rows[count]["IMAGEM"];
dgvCliente.Rows[count].Cells[1].Value = dtCliente.Rows[count]["NOME"].ToString();
dgvCliente.Rows[count].Cells[2].Value = dtCliente.Rows[count]["TELEFONE"].ToString();
dgvCliente.Rows[count].Cells[3].Value = dtCliente.Rows[count]["ENDERECO"].ToString();
dgvCliente.Rows[count].Cells[4].Value = dtCliente.Rows[count]["EMAIL"].ToString();
}
}
catch (Exception EX)
{
MessageBox.Show("ERRO AO BUSCAR CLIENTES" + "\n" + EX.Message);
}
}
public UCAddCompany(FRMMain mFRM)
{
InitializeComponent();
fRMMain = mFRM;
conDB = new ConMySql();
convertDT = new ConvertDateTime();
}
public UCAddProductType(FRMMain fRMMain)
{
InitializeComponent();
// TODO: Complete member initialization
this.fRMMain = fRMMain;
conDB = new ConMySql();
convertDT = new ConvertDateTime();
}
public UCAddCustomer(FRMMain fRMMain)
{
// TODO: Complete member initialization
this.fRMMain = fRMMain;
InitializeComponent();
conDB = new ConMySql();
convertDT = new ConvertDateTime();
}
public UCListCompany(FRMMain fRMMain)
{
// TODO: Complete member initialization
this.fRMMain = fRMMain;
InitializeComponent();
conDB = new ConMySql();
//listCompany = conDB.getCompany();
}
public UCAddProductType(FRMMain fRMMain)
{
InitializeComponent();
// TODO: Complete member initialization
this.fRMMain = fRMMain;
conDB = new ConMySql();
convertDT = new ConvertDateTime();
}
public FRMMain()
{
InitializeComponent();
strPathSkin = pathFolderSave + "\\" + skinFileName;
loadSkin();
showWaitingForm("กำลังทำการเปิดโปรแกรม");
conDB = new ConMySql();
}
public UCAddCustomer(FRMMain fRMMain)
{
// TODO: Complete member initialization
this.fRMMain = fRMMain;
InitializeComponent();
conDB = new ConMySql();
convertDT = new ConvertDateTime();
}
private void testConDB()
{
ConMySql conDB = new ConMySql();
bool resultCheckConnect = conDB.CheckConnect();
conDB.CloseConnection();
setStatusConnect(resultCheckConnect);
}
public UCCustomerClem()
{
Thread.CurrentThread.CurrentCulture = new CultureInfo("en-US");
InitializeComponent();
DevExpress.LookAndFeel.UserLookAndFeel.Default.SetSkinStyle("");
panelControl5.Appearance.BackColor = Color.Red;
conDB = new ConMySql();
}
public UCCustomerClem()
{
Thread.CurrentThread.CurrentCulture = new CultureInfo("en-US");
InitializeComponent();
DevExpress.LookAndFeel.UserLookAndFeel.Default.SetSkinStyle("");
panelControl5.Appearance.BackColor = Color.Red;
conDB = new ConMySql();
}
public UCAddEmployee(FRMMain fRMMain)
{
InitializeComponent();
// TODO: Complete member initialization
this.fRMMain = fRMMain;
conDB = new ConMySql();
convertDT = new ConvertDateTime();
dtStart.Properties.DisplayFormat.FormatString = fRMMain.formatDate;
dtStart.Properties.Mask.EditMask = fRMMain.formatDate;
}
public UCAddEmployee(FRMMain fRMMain)
{
InitializeComponent();
// TODO: Complete member initialization
this.fRMMain = fRMMain;
conDB = new ConMySql();
convertDT = new ConvertDateTime();
dtStart.Properties.DisplayFormat.FormatString = fRMMain.formatDate;
dtStart.Properties.Mask.EditMask = fRMMain.formatDate;
}
public UCAddProduct(FRMMain fRMMain)
{
InitializeComponent();
// TODO: Complete member initialization
this.fRMMain = fRMMain;
conDB = new ConMySql();
convertDT = new ConvertDateTime();
price.Properties.Mask.MaskType = MaskType.Numeric;
price.Properties.Mask.EditMask = "n";
}
public UCAddProduct(FRMMain fRMMain)
{
InitializeComponent();
// TODO: Complete member initialization
this.fRMMain = fRMMain;
conDB = new ConMySql();
convertDT = new ConvertDateTime();
price.Properties.Mask.MaskType = MaskType.Numeric;
price.Properties.Mask.EditMask = "n";
}
public UCAddEmployeeClem(FRMMain fRMMain)
{
Thread.CurrentThread.CurrentCulture = new CultureInfo("en-US");
InitializeComponent();
// TODO: Complete member initialization
this.fRMMain = fRMMain;
conDB = new ConMySql();
convertDT = new ConvertDateTime();
//set รูปแบบวันที่
dtProductEndDate.Properties.DisplayFormat.FormatString = fRMMain.formatDate;
dtProductEndDate.Properties.Mask.EditMask = fRMMain.formatDate;
}
public UCAddEmployeeClem(FRMMain fRMMain)
{
Thread.CurrentThread.CurrentCulture = new CultureInfo("en-US");
InitializeComponent();
// TODO: Complete member initialization
this.fRMMain = fRMMain;
conDB = new ConMySql();
convertDT = new ConvertDateTime();
//set รูปแบบวันที่
dtProductEndDate.Properties.DisplayFormat.FormatString = fRMMain.formatDate;
dtProductEndDate.Properties.Mask.EditMask = fRMMain.formatDate;
}
public UCAddCustomerClem(FRMMain mFRM)
{
Thread.CurrentThread.CurrentCulture = new CultureInfo("en-US");
InitializeComponent();
fRMMain = mFRM;
conDB = new ConMySql();
convertDT = new ConvertDateTime();
//set รูปแบบวันที่
dtProductEndDate.Properties.DisplayFormat.FormatString = fRMMain.formatDate;
dtProductEndDate.Properties.Mask.EditMask = fRMMain.formatDate;
textEditChargebacks.Properties.Mask.MaskType = MaskType.Numeric;
textEditChargebacks.Properties.Mask.EditMask = "n";
}
public UCAddCustomerClem(FRMMain mFRM)
{
Thread.CurrentThread.CurrentCulture = new CultureInfo("en-US");
InitializeComponent();
fRMMain = mFRM;
conDB = new ConMySql();
convertDT = new ConvertDateTime();
//set รูปแบบวันที่
dtProductEndDate.Properties.DisplayFormat.FormatString = fRMMain.formatDate;
dtProductEndDate.Properties.Mask.EditMask = fRMMain.formatDate;
textEditChargebacks.Properties.Mask.MaskType = MaskType.Numeric;
textEditChargebacks.Properties.Mask.EditMask = "n";
}
private DataTable ListarPessoa(string pessoa)
{
ConMySql conexao = new ConMySql();
conexao.ligar();
DataTable dtPessoa = new DataTable();
try
{
string comando = $"SELECT * FROM {pessoa} order by nome";
MySqlDataAdapter Adapter = new MySqlDataAdapter(comando, conexao.con());
Adapter.Fill(dtPessoa);
}
catch (Exception EX)
{
MessageBox.Show("ERRO:" + "\n" + EX.Message);
}
return(dtPessoa);
}
