public void MODIFY(INTERNATIONAL item) { StringBuilder sb = new StringBuilder(); sb.Append("update INTERNATIONAL set"); sb.AppendFormat(" areacode={0}, nation_num='{1}', nation_local_num='{2}', natione='{3}', nationk='{4}', lm='{5}' where idx={6}", item.areacode, item.nation_num, item.nation_local_num, item.natione, item.nationk, item.lm, item.idx); using (FirebirdDBHelper db = new FirebirdDBHelper(sb.ToString(), util.strDBConn)) { try { db.BeginTran(); int count = db.GetEffectedCount(); db.Commit(); } catch (FirebirdSql.Data.FirebirdClient.FbException fex) { db.Rollback(); util.WriteLog(string.Format("{0} MODIFY ERR : {1}", this.GetType(), fex.Message)); return; } } INIT(); }
public void REMOVE(DOMESTICRATE item) { StringBuilder sb = new StringBuilder(); sb.AppendFormat("delete from DOMESTIC_RATE where prefix={0}", item.prefix); using (FirebirdDBHelper db = new FirebirdDBHelper(sb.ToString(), util.strDBConn)) { try { db.BeginTran(); int count = db.GetEffectedCount(); db.Commit(); } catch (FirebirdSql.Data.FirebirdClient.FbException fex) { db.Rollback(); util.WriteLog(string.Format("{0} REMOVE ERR : {1}", this.GetType(), fex.Message)); return; } } _list.Remove(item); //INIT(); }
public void ADD(INTERNATIONAL item) { StringBuilder sb = new StringBuilder(); sb.Append("insert into INTERNATIONAL"); sb.Append("( areacode, nation_num, nation_local_num, natione, nationk, lm )"); sb.Append(" values "); sb.AppendFormat("( {0}, '{1}', '{2}', '{3}', '{4}', '{5}' )", item.areacode, item.nation_num, item.nation_local_num, item.natione, item.nationk, item.lm); using (FirebirdDBHelper db = new FirebirdDBHelper(sb.ToString(), util.strDBConn)) { try { db.BeginTran(); int count = db.GetEffectedCount(); db.Commit(); } catch (FirebirdSql.Data.FirebirdClient.FbException fex) { db.Rollback(); util.WriteLog(string.Format("{0} ADD ERR : {1}", this.GetType(), fex.Message)); return; } } INIT(); }
public void ADD(DOMESTICRATE item) { StringBuilder sb = new StringBuilder(); sb.Append("insert into DOMESTIC_RATE"); sb.Append(" ( prefix, type, rate, sec )"); sb.Append(" values "); sb.AppendFormat("( '{0}', '{1}', {2}, {3} )", item.prefix, item.type, item.rate, item.sec); using (FirebirdDBHelper db = new FirebirdDBHelper(sb.ToString(), util.strDBConn)) { try { db.BeginTran(); int count = db.GetEffectedCount(); db.Commit(); } catch (FirebirdSql.Data.FirebirdClient.FbException fex) { db.Rollback(); util.WriteLog(string.Format("{0} ADD ERR : {1}", this.GetType(), fex.Message)); return; } } //INIT(); _list.Add(item); }
public void MODIFY(DOMESTICRATE item) { StringBuilder sb = new StringBuilder(); sb.Append("update DOMESTIC_RATE set"); sb.AppendFormat(" type='{0}', rate={1}, sec={2} where prefix='{3}'", item.type, item.rate, item.sec, item.prefix); using (FirebirdDBHelper db = new FirebirdDBHelper(sb.ToString(), util.strDBConn)) { try { db.BeginTran(); int count = db.GetEffectedCount(); db.Commit(); } catch (FirebirdSql.Data.FirebirdClient.FbException fex) { db.Rollback(); util.WriteLog(string.Format("{0} MODIFY ERR : {1}", this.GetType(), fex.Message)); return; } } //INIT(); }
public void MODIFY(INTERNATIONALRATE item) { StringBuilder sb = new StringBuilder(); sb.Append("update INTERNATIONAL_RATE set"); sb.AppendFormat(" lrate={0}, lsec={1}, mrate={2}, msec={3} where areacode={4}", item.lrate, item.lsec, item.mrate, item.msec, item.areacode); using (FirebirdDBHelper db = new FirebirdDBHelper(sb.ToString(), util.strDBConn)) { try { int count = db.GetEffectedCount(); } catch (FirebirdSql.Data.FirebirdClient.FbException fex) { db.Rollback(); util.WriteLog(string.Format("{0} MODIFY ERR : {1}", this.GetType(), fex.Message)); return; } } INTERNATIONALRATE _tmpobj = (INTERNATIONALRATE)_list.Where(x => x.areacode == item.areacode); _tmpobj.lrate = item.lrate; _tmpobj.lsec = item.lsec; _tmpobj.mrate = item.mrate; _tmpobj.msec = item.msec; //INIT(); }
public void ADD(INTERNATIONALRATE item) { StringBuilder sb = new StringBuilder(); sb.Append("insert into INTERNATIONAL_RATE"); sb.Append("( areacode, lrate, lsec, mrate, msec )"); sb.Append(" values "); sb.AppendFormat("( {0}, {1}, {2}, {3}, {4} )", item.areacode, item.lrate, item.lsec, item.mrate, item.msec); using (FirebirdDBHelper db = new FirebirdDBHelper(sb.ToString(), util.strDBConn)) { try { int count = db.GetEffectedCount(); } catch (FirebirdSql.Data.FirebirdClient.FbException fex) { db.Rollback(); util.WriteLog(string.Format("{0} ADD ERR : {1}", this.GetType(), fex.Message)); return; } } _list.Add(item); //INIT(); }
public void ADD(Firm item) { StringBuilder sb = new StringBuilder(); sb.Append("insert into FIRMS"); sb.Append("( title )"); sb.Append(" values "); sb.AppendFormat("( {0} )", item.title); using (FirebirdDBHelper db = new FirebirdDBHelper(sb.ToString(), util.strDBConn)) { try { int count = db.GetEffectedCount(); } catch (FirebirdSql.Data.FirebirdClient.FbException fex) { db.Rollback(); util.WriteLog(string.Format("{0} ADD ERR : {1}", this.GetType(), fex.Message)); return; } } INIT(); }
public void MODIFY(Firm item) { StringBuilder sb = new StringBuilder(); sb.AppendFormat("update FIRMS set title={0} where idx={1}", item.title, item.idx); using (FirebirdDBHelper db = new FirebirdDBHelper(sb.ToString(), util.strDBConn)) { try { int count = db.GetEffectedCount(); } catch (FirebirdSql.Data.FirebirdClient.FbException fex) { db.Rollback(); util.WriteLog(string.Format("{0} MODIFY ERR : {1}", this.GetType(), fex.Message)); return; } } INIT(); }
public void REMOVE(BILLException item) { StringBuilder sb = new StringBuilder(); sb.AppendFormat("delete from EXCEPTIONS where innertel={0}", item.innertel); using (FirebirdDBHelper db = new FirebirdDBHelper(sb.ToString(), util.strDBConn)) { try { int count = db.GetEffectedCount(); } catch (FirebirdSql.Data.FirebirdClient.FbException fex) { db.Rollback(); util.WriteLog(string.Format("{0} REMOVE ERR : {1}", this.GetType(), fex.Message)); return; } } INIT(); }
public void REMOVE(INTERNATIONAL item) { StringBuilder sb = new StringBuilder(); sb.AppendFormat("delete from INTERNATIONAL where idx={0}", item.idx); using (FirebirdDBHelper db = new FirebirdDBHelper(sb.ToString(), util.strDBConn)) { try { db.BeginTran(); int count = db.GetEffectedCount(); db.Commit(); } catch (FirebirdSql.Data.FirebirdClient.FbException fex) { db.Rollback(); util.WriteLog(string.Format("{0} REMOVE ERR : {1}", this.GetType(), fex.Message)); return; } } INIT(); }
public void REMOVE(INTERNATIONALRATE item) { StringBuilder sb = new StringBuilder(); sb.AppendFormat("delete from INTERNATIONAL_RATE where areacode={0}", item.areacode); using (FirebirdDBHelper db = new FirebirdDBHelper(sb.ToString(), util.strDBConn)) { try { int count = db.GetEffectedCount(); } catch (FirebirdSql.Data.FirebirdClient.FbException fex) { db.Rollback(); util.WriteLog(string.Format("{0} REMOVE ERR : {1}", this.GetType(), fex.Message)); return; } } _list.Remove(item); //INIT(); }
private void CdrToDB(CdrRequest_t _cdr, CdrList _cdrdata) { CDRData _cdrd = new CDRData() { OFFICE_NAME = _cdrdata.office_name , STARTDATE = new DateTime(_cdrdata.start_yyyy, _cdrdata.start_month, _cdrdata.start_day, _cdrdata.start_hour, _cdrdata.start_min, _cdrdata.start_sec) , ENDDATE = new DateTime(_cdrdata.end_yyyy, _cdrdata.end_month, _cdrdata.end_day, _cdrdata.end_hour, _cdrdata.end_min, _cdrdata.end_sec) , CALLER = _cdrdata.caller , CALLER_TYPE = _cdrdata.caller_type , CALLER_IPN_NUMBER = _cdrdata.caller_ipn_number , CALLER_GROUP_CODE = _cdrdata.caller_group_code , CALLER_GROUP_NAME = _cdrdata.caller_group_name , CALLER_HUMAN_NAME = _cdrdata.caller_human_name , CALLEE = _cdrdata.callee , CALLEE_TYPE = _cdrdata.callee_type , CALLEE_IPN_NUMBER = _cdrdata.callee_ipn_number , CALLEE_GROUP_CODE = _cdrdata.callee_group_code , CALLEE_GROUP_NAME = _cdrdata.callee_group_name , CALLEE_HUMAN_NAME = _cdrdata.callee_human_name , RESULT = _cdrdata.result , SEQ = _cdrdata.seq }; StringBuilder __slqsb = new StringBuilder(); __slqsb.Append(" insert into CDRINFO "); __slqsb.Append(" ( "); __slqsb.Append(" OFFICE_NAME "); __slqsb.Append(" , STARTDATE "); __slqsb.Append(" , ENDDATE "); __slqsb.Append(" , CALLER "); __slqsb.Append(" , CALLER_TYPE "); __slqsb.Append(" , CALLER_IPN_NUMBER "); __slqsb.Append(" , CALLER_GROUP_CODE "); __slqsb.Append(" , CALLER_GROUP_NAME "); __slqsb.Append(" , CALLER_HUMAN_NAME "); __slqsb.Append(" , CALLEE "); __slqsb.Append(" , CALLEE_TYPE "); __slqsb.Append(" , CALLEE_IPN_NUMBER "); __slqsb.Append(" , CALLEE_GROUP_CODE "); __slqsb.Append(" , CALLEE_GROUP_NAME "); __slqsb.Append(" , CALLEE_HUMAN_NAME "); __slqsb.Append(" , RESULT "); __slqsb.Append(" , SEQ "); __slqsb.Append(" ) values ( "); __slqsb.AppendFormat(" '{0}' ", _cdrd.OFFICE_NAME); __slqsb.AppendFormat(" , '{0}' ", _cdrd.STARTDATE.ToString("yyyy-MM-dd HH:mm:ss")); __slqsb.AppendFormat(" , '{0}' ", _cdrd.ENDDATE.ToString("yyyy-MM-dd HH:mm:ss")); __slqsb.AppendFormat(" , '{0}' ", _cdrd.CALLER); __slqsb.AppendFormat(" , '{0}' ", _cdrd.CALLER_TYPE); __slqsb.AppendFormat(" , '{0}' ", _cdrd.CALLER_IPN_NUMBER); __slqsb.AppendFormat(" , '{0}' ", _cdrd.CALLER_GROUP_CODE); __slqsb.AppendFormat(" , '{0}' ", _cdrd.CALLER_GROUP_NAME); __slqsb.AppendFormat(" , '{0}' ", _cdrd.CALLER_HUMAN_NAME); __slqsb.AppendFormat(" , '{0}' ", _cdrd.CALLEE); __slqsb.AppendFormat(" , '{0}' ", _cdrd.CALLEE_TYPE); __slqsb.AppendFormat(" , '{0}' ", _cdrd.CALLEE_IPN_NUMBER); __slqsb.AppendFormat(" , '{0}' ", _cdrd.CALLEE_GROUP_CODE); __slqsb.AppendFormat(" , '{0}' ", _cdrd.CALLEE_GROUP_NAME); __slqsb.AppendFormat(" , '{0}' ", _cdrd.CALLEE_HUMAN_NAME); __slqsb.AppendFormat(" , '{0}' ", _cdrd.RESULT); __slqsb.AppendFormat(" , '{0}' ", _cdrd.SEQ); __slqsb.Append(" ); "); using (FirebirdDBHelper db = new FirebirdDBHelper(__slqsb.ToString(), util.strDBConn)) { try { db.BeginTran(); int __count = db.GetEffectedCount(); db.Commit(); CdrResponse_t __cdrRes = this.GetCdrRtnMsg(_cdr); byte[] __buffer = util.GetBytes(__cdrRes); try { _sockCdrSrv.SendTo(__buffer, SocketFlags.None, _remoteep); } catch (SocketException __se) { util.WriteLog(string.Format("Socket send message error : {0}", __se.Message)); } } catch (FirebirdSql.Data.FirebirdClient.FbException __fex) { db.Rollback(); util.WriteLog(string.Format("{0} : {1}\r\nMessage : {2}", "Rollback Exception Type", __fex.GetType(), __fex.Message)); } catch (SocketException __se) { util.WriteLog(string.Format("Socket send message error : {0}", __se.Message)); } } }