public void List_Option(ListOption pAction)
{
fAction = pAction;
switch (fAction)
{
case ListOption.notactive:
if (rdo_notactive.Checked == true)
{
LoadData(CStables_exten.NotActive(new SQLITE_DAL()));
}
else
{
LoadData(CStables_exten.Active(new SQLITE_DAL()));
}
break;
case ListOption.Search:
LoadData(CStables_exten.Searchby(txt_database.Text, txt_mtables.Text));
break;
default:
LoadData(CStables_exten.Active(new SQLITE_DAL()));
break;
}
}
public void SetAction(BtnEvent pAction, string pPkValue)
{
fAction = pAction;
switch (fAction)
{
case BtnEvent.Open:
btn_save.Text = "CLOSE";
obj = CStables_exten.PKId(pPkValue, new SQLITE_DAL());
itemstbl = CSFields_exten.FKId(pPkValue, new SQLITE_DAL());
itemssub = CSFieldsitems_exten.FKId(pPkValue, new SQLITE_DAL());
this.EnableControls(false);
break;
case BtnEvent.New:
btn_save.Text = "SAVE";
obj = CStables.GetNew;
itemstbl = CSFields.GetNew;
itemssub = CSFieldsitem.GetNew;
editgrid.RowCount = 0;
editgrid_2.RowCount = 0;
this.EnableControls(true);
break;
case BtnEvent.Edit:
btn_save.Text = "UPDATE";
obj = CStables_exten.PKId(pPkValue, new SQLITE_DAL());
itemstbl = CSFields_exten.FKId(pPkValue, new SQLITE_DAL());
itemssub = CSFieldsitems_exten.FKId(pPkValue, new SQLITE_DAL());
this.EnableControls(true);
break;
case BtnEvent.Delete:
btn_save.Text = "CONFIRM\r\nDELETE";
obj = CStables_exten.PKId(pPkValue, new SQLITE_DAL());
itemstbl = CSFields_exten.FKId(pPkValue, new SQLITE_DAL());
itemssub = CSFieldsitems_exten.FKId(pPkValue, new SQLITE_DAL());
this.EnableControls(false);
break;
case BtnEvent.Print:
btn_save.Text = "PRINT";
obj = CStables_exten.PKId(pPkValue, new SQLITE_DAL());
itemstbl = CSFields_exten.FKId(pPkValue, new SQLITE_DAL());
itemssub = CSFieldsitems_exten.FKId(pPkValue, new SQLITE_DAL());
this.EnableControls(false);
break;
}
this.LoadData(obj);
this.Loaditems(itemstbl);
this.Loaditems_2(itemssub);
}
private Spath CollectData()
{
Spath fobj = new Spath()
{
Spath_id = vId,
Stables_id = CStables_exten.GetId_Name(txt_stables_id.Text),
Root_folder = txt_root_folder.Text,
Contfolder = txt_contfolder.Text,
Classfolder = txt_classfolder.Text,
Formfolder = txt_formfolder.Text,
Listfolder = txt_listfolder.Text,
Setupfolder = txt_setupfolder.Text,
Testfolder = txt_testfolder.Text,
Active_id = Core.Stative,
};
return(fobj);
}
void txt_mpath_LookupUpdate(object sender, EventArgs e)
{
txt_stables_id.LookupList = CStables_exten.GetforLookup(new SQLITE_DAL());
}
private void Btn_generate_Click(object sender, EventArgs e)
{
STablesScript.SRun(Convert.ToInt32("" + CStables_exten.GetId_Name(txt_mtables.Text)));
MessageBox.Show("Sucess!");
}
void Txt_party_LookupUpdate(object sender, EventArgs e)
{
txt_mtables.LookupList = CStables_exten.GetforLookup(new SQLITE_DAL());
}
