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