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(); } }