public static string GetId_Name(string _pName)
{
Databases obj = CDatabases.PropertiesData(SearchName(_pName));
if (obj != null)
{
return(obj.Databases_id);
}
return("");
}
public static string GetName_Id(string _pId)
{
Databases obj = CDatabases.PropertiesData(PKId(_pId));
if (obj != null)
{
return(obj.Databases_name);
}
return("");
}
public void List_Option(ListOption pAction)
{
fAction = pAction;
switch (fAction)
{
case ListOption.active:
if (chk_notactive.Checked == true)
{
LoadData(CDatabases.TblData(CDatabases_exten.NotActive()));
}
else
{
LoadData(CDatabases.TblData(CDatabases_exten.Active()));
}
break;
case ListOption.notactive:
if (chk_notactive.Checked == true)
{
LoadData(CDatabases.TblData(CDatabases_exten.NotActive()));
}
else
{
LoadData(CDatabases.TblData(CDatabases_exten.Active()));
}
break;
case ListOption.Search:
if (txt_databases_name.Text != "")
{
LoadData(CDatabases.TblData(CDatabases_exten.SearchName(txt_databases_name.Text)));
}
else
{
LoadData(CDatabases.TblData(CDatabases_exten.Active()));
}
break;
default:
LoadData(CDatabases.TblData(CDatabases_exten.Active()));
break;
}
}
public void SetAction(BtnEvent pAction, string pPkValue)
{
fAction = pAction;
switch (fAction)
{
case BtnEvent.Open:
btn_save.Text = "CLOSE";
obj = CDatabases.PropertiesData(CDatabases_exten.PKId(pPkValue));
this.EnableControls(false);
break;
case BtnEvent.New:
btn_save.Text = "SAVE";
obj = new Databases();
this.EnableControls(true);
break;
case BtnEvent.Edit:
btn_save.Text = "UPDATE";
obj = CDatabases.PropertiesData(CDatabases_exten.PKId(pPkValue));
this.EnableControls(true);
break;
case BtnEvent.Delete:
btn_save.Text = "CONFIRM\r\nDELETE";
obj = CDatabases.PropertiesData(CDatabases_exten.PKId(pPkValue));
this.EnableControls(false);
break;
case BtnEvent.Print:
btn_save.Text = "PRINT";
obj = CDatabases.PropertiesData(CDatabases_exten.PKId(pPkValue));
this.EnableControls(false);
break;
}
this.LoadData();
}
private void Save_Event()
{
if (Validation() != false)
{
switch (fAction)
{
case BtnEvent.Open:
this.Hide();
Form_NeedToRefresh();
break;
case BtnEvent.New:
try
{
var vData = FetchData();
dalsession = new SQLITE_DAL();
dalsession.BeginTransaction();
CDatabases.Insert(vData, dalsession);
dalsession.Commit();
MessageBox.Show(this.FindForm(), "Record Saved Successfully.", "Save...", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
this.Hide();
Form_NeedToRefresh();
}
catch (Exception ex)
{
if (dalsession != null)
{
dalsession.Rollback();
}
MessageBox.Show(this.FindForm(), "Something Goes Wrong \r\n" + ex.Message, "Could Not Save...", MessageBoxButtons.OK, MessageBoxIcon.Error);
SetFocus();
return;
}
break;
case BtnEvent.Edit:
try
{
var vData = FetchData();
dalsession = new SQLITE_DAL();
dalsession.BeginTransaction();
CDatabases.Update(vData, dalsession);
dalsession.Commit();
MessageBox.Show(this.FindForm(), "Record Updated Successfully.", "Update...", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
this.Hide();
Form_NeedToRefresh();
}
catch (Exception ex)
{
if (dalsession != null)
{
dalsession.Rollback();
}
MessageBox.Show(this.FindForm(), "Something Goes Wrong \r\n" + ex.Message, "Could Not Update...", MessageBoxButtons.OK, MessageBoxIcon.Error);
SetFocus();
return;
}
break;
case BtnEvent.Delete:
try
{
dalsession = new SQLITE_DAL();
dalsession.BeginTransaction();
CDatabases.Delete(vId, dalsession);
dalsession.Commit();
MessageBox.Show(this.FindForm(), "Record Deleted Successfully.", "Delete...", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
this.Hide();
Form_NeedToRefresh();
}
catch (Exception ex)
{
if (dalsession != null)
{
dalsession.Rollback();
}
MessageBox.Show(this.FindForm(), "Something Goes Wrong \r\n" + ex.Message, "Could Not Update...", MessageBoxButtons.OK, MessageBoxIcon.Error);
SetFocus();
return;
}
break;
case BtnEvent.Print:
this.Hide();
Form_NeedToRefresh();
break;
}
}
}