public void refreshControls()
{
//dataFilterSalesleads = General.DBLink.executeTableQuarry("SELECT `SalesLeadsID`,`CustomerID`,`ProductID`,DATE_FORMAT(`IssueDate`,'%Y-%m-%d') AS `IssueDate`,`RevenueType`,`MonthlyRevenue`,`HadTest`,`ProjectRevenue`,`ProjectPaid`,DATE_FORMAT(`CustomerConfirmDate`,'%Y-%m-%d') AS `CustomerConfirmDate`,DATE_FORMAT(`AgreementSignDate`,'%Y-%m-%d') AS `AgreementSignDate`,DATE_FORMAT(`DSP`,'%Y-%m-%d') AS `DSP`,`FirstBillIssued`,DATE_FORMAT(`BillIssueDate`,'%Y-%m-%d') AS `BillIssueDate`,`SuccessfullClose`,DATE_FORMAT(`ClosedDate`,'%Y-%m-%d') AS `ClosedDate`,DATE_FORMAT(`DisconnectedDate`,'%Y-%m-%d') AS `DisconnectedDate`,`DisconnectReason`,`CoustomerFeedBack`,`Discount`,`Notes` FROM `customerproduct`");
dataFilterSalesleads = SalesleadsHandler.getAllSales();
dataFilterSalesleads.RowFilter = "ShortName LIKE '%" + txtSearch.Text + "%'";
dataGridViewSalesLeads.DataSource = dataFilterSalesleads;
}
private void btnUpdate_Click(object sender, EventArgs e)
{
if (dataGridViewSalesLeads.SelectedRows.Count != 0)
{
frmAddUpdateSalesLead updateSalesleadForm = new frmAddUpdateSalesLead();
updateSalesleadForm.IsAdd = false;
updateSalesleadForm.BaseSalesLeadForm = this;
updateSalesleadForm.SelectedSalesLeadID = (int)dataGridViewSalesLeads.SelectedRows[0].Cells[0].Value;
SalesleadsHandler updateSalesleadHandler = new SalesleadsHandler(updateSalesleadForm);
updateSalesleadForm.Show();
}
}