private static List <MasterTables> EntityList(string q) { List <MasterTables> list = new List <MasterTables>(); using (IDataReader redr = new SQLITE_DAL().Listreader(q)) { while (redr.Read() == true) { MasterTables obj = new MasterTables() { Mastertables_id = redr[MASTERTABLES.MASTERTABLES_ID].ToString(), Databases_id = redr[DATABASES.DATABASES_NAME].ToString(), Mastertables_name = redr[MASTERTABLES.MASTERTABLES_NAME].ToString(), Alias = redr[MASTERTABLES.ALIAS].ToString(), Namespaces_id = redr[NAMESPACES.NAMESPACES_NAME].ToString(), Active_id = redr[MASTERTABLES.ACTIVE_ID].ToString(), }; list.Add(obj); } redr.Close(); } return(list); }
private static MasterTables GetTables(int table_id) { string q = "SELECT " + MASTERTABLES.MASTERTABLES_TBL + ".* \r\n"; q += ", " + NAMESPACES.NAMESPACES_TBL + "." + NAMESPACES.NAMESPACES_NAME + " \r\n"; q += ", " + DATABASES.DATABASES_TBL + "." + DATABASES.DATABASES_NAME + " \r\n"; q += " FROM " + MASTERTABLES.MASTERTABLES_TBL + " \r\n"; q += " INNER JOIN " + NAMESPACES.NAMESPACES_TBL + "\r\n"; q += " ON(" + NAMESPACES.NAMESPACES_TBL + "." + NAMESPACES.NAMESPACES_ID + " = " + MASTERTABLES.MASTERTABLES_TBL + "." + MASTERTABLES.NAMESPACES_ID + " )\r\n"; q += " INNER JOIN " + DATABASES.DATABASES_TBL + "\r\n"; q += " ON(" + DATABASES.DATABASES_TBL + "." + DATABASES.DATABASES_ID + " = " + MASTERTABLES.MASTERTABLES_TBL + "." + MASTERTABLES.DATABASES_ID + " )\r\n"; q += " WHERE " + MASTERTABLES.MASTERTABLES_ID + " =" + table_id; using (IDataReader redr = new SQLITE_DAL().Listreader(q)) { while (redr.Read() == true) { MasterTables obj = new MasterTables() { Mastertables_id = redr[MASTERTABLES.MASTERTABLES_ID].ToString(), Mastertables_name = redr[MASTERTABLES.MASTERTABLES_NAME].ToString(), Alias = redr[MASTERTABLES.ALIAS].ToString(), Namespaces_id = redr[NAMESPACES.NAMESPACES_NAME].ToString(), Databases_id = redr[DATABASES.DATABASES_NAME].ToString() }; return(obj); } return(new MasterTables()); } }
private static string AttachParams(string q, MasterTables v) { q = q.Replace("@" + MASTERTABLES.MASTERTABLES_ID + "@", "" + ConvertTO.SqlString(v.Mastertables_id) + ""); q = q.Replace("@" + MASTERTABLES.DATABASES_ID + "@", "" + ConvertTO.SqlString(v.Databases_id) + ""); q = q.Replace("@" + MASTERTABLES.MASTERTABLES_NAME + "@", "" + ConvertTO.SqlString(v.Mastertables_name) + ""); q = q.Replace("@" + MASTERTABLES.ALIAS + "@", "" + ConvertTO.SqlString(v.Alias) + ""); q = q.Replace("@" + MASTERTABLES.NAMESPACES_ID + "@", "" + ConvertTO.SqlString(v.Namespaces_id) + ""); q = q.Replace("@" + MASTERTABLES.ACTIVE_ID + "@", "" + ConvertTO.SqlString(v.Active_id) + ""); return(q); }
private void LoadData(MasterTables obj) { vId = obj.Mastertables_id; txt_databases_id.Text = obj.Databases_id; txt_tables_name.Text = obj.Mastertables_name; txt_tables_alias.Text = obj.Alias; txt_namespaces_id.Text = obj.Namespaces_id; Core.Stative = obj.Active_id; Setactives(); }
public static string GetId_Name(string _pName) { MasterTables obj = SearchName(_pName); if (obj != null) { return(obj.Mastertables_id); } return(""); }
public static string GetName_Id(string _pId) { MasterTables obj = PKId(_pId); if (obj != null) { return(obj.Mastertables_name); } return(""); }
public static void Update(MasterTables v, SQLITE_DAL dalsession) { string q = "UPDATE " + MASTERTABLES.MASTERTABLES_TBL + " SET"; q += " " + MASTERTABLES.DATABASES_ID + " = @" + MASTERTABLES.DATABASES_ID + "@ \r\n "; q += "," + MASTERTABLES.MASTERTABLES_NAME + " = @" + MASTERTABLES.MASTERTABLES_NAME + "@ \r\n "; q += "," + MASTERTABLES.ALIAS + " = @" + MASTERTABLES.ALIAS + "@ \r\n "; q += "," + MASTERTABLES.NAMESPACES_ID + " = @" + MASTERTABLES.NAMESPACES_ID + "@ \r\n "; q += "," + MASTERTABLES.ACTIVE_ID + " = @" + MASTERTABLES.ACTIVE_ID + "@ \r\n "; q += " WHERE " + MASTERTABLES.MASTERTABLES_ID + " = @" + MASTERTABLES.MASTERTABLES_ID + "@ "; q = AttachParams(q, v); dalsession.Execute(q); }
private MasterTables CollectData() { MasterTables fobj = new MasterTables() { Mastertables_id = vId, Databases_id = CDatabases_exten.GetId_Name(txt_databases_id.Text.Trim()), Mastertables_name = txt_tables_name.Text.ToUpper().Trim(), Alias = txt_tables_alias.Text.ToUpper().Trim(), Namespaces_id = CNamespaces_exten.GetId_Name(txt_namespaces_id.Text.Trim()), Active_id = Core.Stative, }; return(fobj); }
public void SetAction(BtnEvent pAction, string pPkValue) { fAction = pAction; switch (fAction) { case BtnEvent.Open: btn_save.Text = "CLOSE"; obj = CMtables_exten.PKId(pPkValue); itemstbl = CMtablesitems_exten.FKId(pPkValue); this.EnableControls(false); break; case BtnEvent.New: btn_save.Text = "SAVE"; obj = CMtables.GetNew; itemstbl = CMtablesitems.GetNew; editgrid.RowCount = 0; this.EnableControls(true); break; case BtnEvent.Edit: btn_save.Text = "UPDATE"; obj = CMtables_exten.PKId(pPkValue); itemstbl = CMtablesitems_exten.FKId(pPkValue); this.EnableControls(true); break; case BtnEvent.Delete: btn_save.Text = "CONFIRM\r\nDELETE"; obj = CMtables_exten.PKId(pPkValue); itemstbl = CMtablesitems_exten.FKId(pPkValue); this.EnableControls(false); break; case BtnEvent.Print: btn_save.Text = "PRINT"; obj = CMtables_exten.PKId(pPkValue); itemstbl = CMtablesitems_exten.FKId(pPkValue); this.EnableControls(false); break; } this.LoadData(obj); this.Loaditems(itemstbl); }
public static void Insert(MasterTables v, SQLITE_DAL dalsession) { string q = " INSERT INTO " + MASTERTABLES.MASTERTABLES_TBL + " ( "; q += " " + MASTERTABLES.DATABASES_ID + " \r\n"; q += "," + MASTERTABLES.MASTERTABLES_NAME + " \r\n"; q += "," + MASTERTABLES.ALIAS + " \r\n"; q += "," + MASTERTABLES.NAMESPACES_ID + " \r\n"; q += "," + MASTERTABLES.ACTIVE_ID + " \r\n"; q += " ) VALUES ( "; q += " @" + MASTERTABLES.DATABASES_ID + "@ \r\n"; q += ", @" + MASTERTABLES.MASTERTABLES_NAME + "@ \r\n"; q += ", @" + MASTERTABLES.ALIAS + "@ \r\n"; q += ", @" + MASTERTABLES.NAMESPACES_ID + "@ \r\n"; q += ", @" + MASTERTABLES.ACTIVE_ID + "@ \r\n"; q += " ) \r\n "; q = AttachParams(q, v); dalsession.Execute(q); }