private void dgvPer_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
if (string.Compare(dgvPer.CurrentCell.OwningColumn.Name, "active") == 0)
{
bool checkBoxStatus = Convert.ToBoolean(dgvPer.CurrentCell.EditedFormattedValue);
if (checkBoxStatus)
{
int id = Convert.ToInt32(dgvPer.CurrentRow.Cells[3].Value);
var idr = cbbPer.SelectedValue.ToString();
int id1 = -1;
try
{
id1 = Convert.ToInt32(idr);
}
catch (Exception ex) { }
rfDAO.update(id1, id, 1);
GetSource.getTableSourceFromList <RoleFunc>(rfDAO.getAllByIDRole(id1), dgvPer);
}
else
{
int id = Convert.ToInt32(dgvPer.CurrentRow.Cells[3].Value);
var idr = cbbPer.SelectedValue.ToString();
int id1 = -1;
try
{
id1 = Convert.ToInt32(idr);
}
catch (Exception ex) { }
rfDAO.update(id1, id, 0);
GetSource.getTableSourceFromList <RoleFunc>(rfDAO.getAllByIDRole(id1), dgvPer);
}
}
}
private void txtSearch_TextChanged(object sender, EventArgs e)
{
String key = txtSearch.Text;
if (key.Equals(""))
{
GetSource.getTableSource(BillDAOL.READ_ALL, dgvBill);
}
else
{
List <Object> search = new List <Object>();
DataGridViewRowCollection rows = dgvBill.Rows;
foreach (DataGridViewRow row in rows)
{
if (row.Cells[1].Value.ToString().Contains(key))
{
search.Add(new
{
id = row.Cells[0].Value,
fullname = row.Cells[1].Value,
address = row.Cells[2].Value,
phone = row.Cells[3].Value,
cusid = row.Cells[4].Value,
name = row.Cells[5].Value,
startday = row.Cells[6].Value,
paid = row.Cells[7].Value
});
}
}
GetSource.getTableSourceFromList <Object>(search, dgvBill);
}
}
private void cbbPer_SelectedValueChanged(object sender, EventArgs e)
{
var id = cbbPer.SelectedValue.ToString();
int id1 = -1;
try
{
id1 = Convert.ToInt32(id);
}
catch (Exception ex) { }
if (id1 != -1)
{
GetSource.getTableSourceFromList <RoleFunc>(rfDAO.getAllByIDRole(id1), dgvPer);
}
}
