public void LoadProfile(string Auser) { dbt = new DBtools(tdb.User.Uhelper, tdb.User.Udbcon); tdb.Season sai = new tdb.Season(); tdb.Language lang = new tdb.Language(); tdb.Customer pers = new tdb.Customer(); ProfileDS prof; string sql; // load profile from DB by user name prof = new ProfileDS(); sql = String.Format("Select * from tdbadmin.mp_profil where mpuser like '{0}'", Auser); dbt.FillDS(prof, sql, new string[] { "mp_profil" }); ProfileDS.mp_profilRow Rprof = prof.mp_profil[0]; // set now the user profile data // Console.WriteLine("Prof Id {0}", Rprof.MPID); Useclevel = Rprof.SECLEVEL; Ulangid = Rprof.S_ID; if (Ulangid > 0) Ulang = lang.GetBez(Ulangid); else Ulang = ""; Uofficeid = Rprof.BCHST; if (Uofficeid > 0) Uoffice = pers.GetBez(Uofficeid); else Ulang = ""; Udlatid = Rprof.DLAT_ID; Usaiid = Rprof.SAI_ID; if (Usaiid > 0) Usai = sai.GetBez(Usaiid); else Usai = ""; }
public void InsUpd(bool Ainsert, string Abez, string Acode, string Atext, int Aprgid, DateTime Adat) { int rowsaffected = 0, udat; string sql; // set Country to this new one bez = Abez; code = Acode; text = Atext; prg_id = Aprgid; tdb.Prg P = new tdb.Prg(); P.Get(prg_id, ref rowsaffected); tdb.Season S = new tdb.Season(); S.Get(P.ObjSaiid, ref rowsaffected); svon = S.ObjFrom; sbis = S.ObjTo; sai = S.ObjBez; if (Adat < svon || Adat > sbis) { id = -2; return; } sai_id = P.ObjSaiid; udat = datetime.ToUnix(Adat); // Begin Trx BeginTrx(); if (Ainsert) { // first get a new unique ID for bez and then sai id = NewID("arrangement", "ARR_ID"); rowsaffected = InsBez(); rowsaffected = InsText(); // insert sql = String.Format("insert into tdbadmin.arrangement values({0}, '{1}', {2}, {3}, {4}, {5}, {6})", id, code, bez_id, udat, prg_id, text_id, sai_id); rowsaffected = DBcmd(sql); } else { rowsaffected = UpdBez(); rowsaffected = UpdText(); // update sai sql = String.Format("update tdbadmin.arrangement set code = '{0}', textid = {1}, prg_id = {2}, a_dat = {3}, sai_id = {4} where arr_id = {5}", code, text_id, prg_id, udat, sai_id, id); rowsaffected = DBcmd(sql); } // commit Commit(); }
public void LoadProfile(string Auser) { dbt = new DBtools(tdb.User.Uhelper, tdb.User.Udbcon); tdb.Season sai = new tdb.Season(); tdb.Language lang = new tdb.Language(); tdb.Customer pers = new tdb.Customer(); ProfileDS prof; string sql; // load profile from DB by user name prof = new ProfileDS(); sql = String.Format("Select * from tdbadmin.mp_profil where mpuser like '{0}'", Auser); dbt.FillDS(prof, sql, new string[] { "mp_profil" }); ProfileDS.mp_profilRow Rprof = prof.mp_profil[0]; // set now the user profile data // Console.WriteLine("Prof Id {0}", Rprof.MPID); Useclevel = Rprof.SECLEVEL; Ulangid = Rprof.S_ID; if (Ulangid > 0) { Ulang = lang.GetBez(Ulangid); } else { Ulang = ""; } Uofficeid = Rprof.BCHST; if (Uofficeid > 0) { Uoffice = pers.GetBez(Uofficeid); } else { Ulang = ""; } Udlatid = Rprof.DLAT_ID; Usaiid = Rprof.SAI_ID; if (Usaiid > 0) { Usai = sai.GetBez(Usaiid); } else { Usai = ""; } }