public void LoadData(DataTable tbl)
{
listgrid.RowCount = 0;
listgrid.RowCount = tbl.Rows.Count;
for (int r = 0; r < tbl.Rows.Count; r++)
{
DataGridViewRow row = listgrid.Rows[r];
row.Cells[DATABASES.DATABASES_ID].Value = tbl.Rows[r][DATABASES.DATABASES_ID];
row.Cells[DATABASES.DATABASES_NAME].Value = tbl.Rows[r][DATABASES.DATABASES_NAME];
row.Cells[DATABASES.NOTES].Value = tbl.Rows[r][DATABASES.NOTES];
row.Cells[DATABASES.ACTIVE_ID].Value = tbl.Rows[r][DATABASES.ACTIVE_ID];
row.Cells[DATABASES.USER_ID].Value = CUser_exten.GetName_Id(tbl.Rows[r][DATABASES.USER_ID].ToString());
}
}
public void List_Option(ListOption pAction)
{
fAction = pAction;
switch (fAction)
{
case ListOption.active:
if (chk_notactive.Checked == true)
{
LoadData(CUser.TblData(CUser_exten.NotActive()));
}
else
{
LoadData(CUser.TblData(CUser_exten.Active()));
}
break;
case ListOption.notactive:
if (chk_notactive.Checked == true)
{
LoadData(CUser.TblData(CUser_exten.NotActive()));
}
else
{
LoadData(CUser.TblData(CUser_exten.Active()));
}
break;
case ListOption.Search:
if (txt_user_name.Text != "")
{
LoadData(CUser.TblData(CUser_exten.SearchName(txt_user_name.Text)));
}
else
{
LoadData(CUser.TblData(CUser_exten.Active()));
}
break;
default:
LoadData(CUser.TblData(CUser_exten.Active()));
break;
}
}
public void LoadData(DataTable tbl)
{
listgrid.RowCount = 0;
listgrid.RowCount = tbl.Rows.Count;
for (int r = 0; r < tbl.Rows.Count; r++)
{
DataGridViewRow row = listgrid.Rows[r];
row.Cells[SERVERS.SERVERS_ID].Value = tbl.Rows[r][SERVERS.SERVERS_ID];
row.Cells[SERVERS.SERVERS_NAME].Value = tbl.Rows[r][SERVERS.SERVERS_NAME];
row.Cells[SERVERS.SERVERS_VERSION].Value = tbl.Rows[r][SERVERS.SERVERS_VERSION];
row.Cells[SERVERS.SERVERS_PATH].Value = tbl.Rows[r][SERVERS.SERVERS_PATH];
row.Cells[SERVERS.SERVERS_BACKUP_PATH].Value = tbl.Rows[r][SERVERS.SERVERS_BACKUP_PATH];
row.Cells[SERVERS.NOTES].Value = tbl.Rows[r][SERVERS.NOTES];
row.Cells[SERVERS.ACTIVE_ID].Value = tbl.Rows[r][SERVERS.ACTIVE_ID];
row.Cells[SERVERS.USER_ID].Value = CUser_exten.GetName_Id(tbl.Rows[r][SERVERS.USER_ID].ToString());
}
}
public void LoadData(DataTable tbl)
{
listgrid.RowCount = 0;
listgrid.RowCount = tbl.Rows.Count;
for (int r = 0; r < tbl.Rows.Count; r++)
{
DataGridViewRow row = listgrid.Rows[r];
row.Cells[USER.USER_ID].Value = tbl.Rows[r][USER.USER_ID];
row.Cells[USER.USER_NAME].Value = tbl.Rows[r][USER.USER_NAME];
row.Cells[USER.USER_PASSWORD].Value = tbl.Rows[r][USER.USER_PASSWORD];
row.Cells[USER.CREATEON].Value = tbl.Rows[r][USER.CREATEON];
row.Cells[USER.ENTRYBY].Value = tbl.Rows[r][USER.ENTRYBY];
row.Cells[USER.NOTES].Value = tbl.Rows[r][USER.NOTES];
row.Cells[USER.ACTIVE_ID].Value = tbl.Rows[r][USER.ACTIVE_ID];
row.Cells[USER.USER_ID].Value = CUser_exten.GetName_Id(tbl.Rows[r][USER.USER_ID].ToString());
}
}
public void SetAction(BtnEvent pAction, string pPkValue)
{
fAction = pAction;
switch (fAction)
{
case BtnEvent.Open:
btn_save.Text = "CLOSE";
obj = CUser.PropertiesData(CUser_exten.PKId(pPkValue));
this.EnableControls(false);
break;
case BtnEvent.New:
btn_save.Text = "SAVE";
obj = new User();
this.EnableControls(true);
break;
case BtnEvent.Edit:
btn_save.Text = "UPDATE";
obj = CUser.PropertiesData(CUser_exten.PKId(pPkValue));
this.EnableControls(true);
break;
case BtnEvent.Delete:
btn_save.Text = "CONFIRM\r\nDELETE";
obj = CUser.PropertiesData(CUser_exten.PKId(pPkValue));
this.EnableControls(false);
break;
case BtnEvent.Print:
btn_save.Text = "PRINT";
obj = CUser.PropertiesData(CUser_exten.PKId(pPkValue));
this.EnableControls(false);
break;
}
this.LoadData();
}
void txt_user_LookupUpdate(object sender, EventArgs e)
{
txt_user_name.LookupList = CUser_exten.GetforLookup();
}
