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(); }