private void INIT()
{
DataTable dt = null;
StringBuilder sb = new StringBuilder();
sb.Append("select idx, title from FIRMS order by title asc");
using (FirebirdDBHelper db = new FirebirdDBHelper(sb.ToString(), util.strDBConn))
{
try
{
dt = db.GetDataTable();
}
catch (FirebirdSql.Data.FirebirdClient.FbException fex)
{
util.WriteLog(string.Format("{0} INIT ERR : {1}", this.GetType(), fex.Message));
return;
}
}
_list = new List<Firm>(
(from _row in dt.AsEnumerable()
select new Firm()
{
idx = int.Parse(_row["idx"].ToString())
,
title = _row["title"].ToString()
}
).ToList<Firm>()
);
}
private void INIT()
{
DataTable dt = null;
StringBuilder sb = new StringBuilder();
sb.Append("select innertel, title from EXCEPTIONS order by innertel asc");
using (FirebirdDBHelper db = new FirebirdDBHelper(sb.ToString(), util.strDBConn))
{
try
{
dt = db.GetDataTable();
}
catch (FirebirdSql.Data.FirebirdClient.FbException fex)
{
util.WriteLog(string.Format("{0} INIT ERR : {1}", this.GetType(), fex.Message));
return;
}
}
_list = new ObservableCollection<BILLException>(
(from _row in dt.AsEnumerable()
select new BILLException()
{
innertel = _row[0].ToString()
, title = _row[1].ToString()
}
).ToList<BILLException>()
);
}
private async void ShowLoginDialog()
{
//this.MetroDialogOptions.ColorScheme = UseAccentForDialogsMenuItem.IsChecked ? MetroDialogColorScheme.Accented : MetroDialogColorScheme.Theme;
LoginDialogData result = await this.ShowLoginAsync("Authentication", "Enter your credentials", new LoginDialogSettings { ColorScheme = this.MetroDialogOptions.ColorScheme, InitialUsername = string.Empty });
if (result == null)
{
//User pressed cancel
this.Close();
}
else
{
//MessageDialogResult messageResult = await this.ShowMessageAsync("Authentication Information", String.Format("Username: {0}\nPassword: {1}", result.Username, result.Password));
DataTable dt = null;
StringBuilder query = new StringBuilder();
query.Append(" select idx, identity, pwd, firm_idx, role_idx from users ");
query.AppendFormat(" where identity='{0}' and pwd='{1}'", result.Username.Trim(), util.GetSHA1(result.Password));
using (FirebirdDBHelper db = new FirebirdDBHelper(query.ToString(), util.strDBConn))
{
try
{
dt = db.GetDataTable();
}
catch
{
dt = null;
}
}
if (dt == null || dt.Rows.Count == 0)
{
// do when login failed
MessageDialogResult messageResult = await this.ShowMessageAsync("Authentication", "Logon failed.\r\nPlease, identify your information one more time.");
ShowLoginDialog();
}
else
{
// succeed
}
}
}
private void INIT()
{
DataTable dt = null;
StringBuilder sb = new StringBuilder();
sb.Append("select idx, areacode, nation_num, nation_local_num, natione, nationk, lm from INTERNATIONAL order by nationk asc");
using (FirebirdDBHelper db = new FirebirdDBHelper(sb.ToString(), util.strDBConn))
{
try
{
dt = db.GetDataTable();
}
catch (FirebirdSql.Data.FirebirdClient.FbException fex)
{
util.WriteLog(string.Format("{0} INIT ERR : {1}", this.GetType(), fex.Message));
return;
}
}
_list = new ObservableCollection<INTERNATIONAL>(
(from _row in dt.AsEnumerable()
select new INTERNATIONAL()
{
idx = long.Parse(_row["idx"].ToString())
,
areacode = int.Parse(_row["areacode"].ToString())
,
nation_num = _row["nation_num"].ToString()
,
nation_local_num = _row["nation_local_num"].ToString()
,
natione = _row["natione"].ToString()
,
nationk = _row["nationk"].ToString()
,
lm = _row["lm"].ToString()
}
).ToList<INTERNATIONAL>()
);
}
private void INIT()
{
DataTable dt = null;
StringBuilder sb = new StringBuilder();
sb.Append("select prefix, type, rate, sec from DOMESTIC_RATE order by prefix asc");
using (FirebirdDBHelper db = new FirebirdDBHelper(sb.ToString(), util.strDBConn))
{
try
{
dt = db.GetDataTable();
}
catch (FirebirdSql.Data.FirebirdClient.FbException fex)
{
util.WriteLog(string.Format("{0} INIT ERR : {1}", this.GetType(), fex.Message));
return;
}
}
_list = new ObservableCollection<DOMESTICRATE>(
(from _row in dt.AsEnumerable()
select new DOMESTICRATE()
{
prefix = _row["prefix"].ToString()
,
type = _row["type"].ToString()
,
rate = float.Parse(_row["rate"].ToString())
,
sec = int.Parse(_row["sec"].ToString())
}
).ToList<DOMESTICRATE>()
);
}
private void INIT()
{
DataTable dt = null;
StringBuilder sb = new StringBuilder();
sb.Append("select areacode, lrate, lsec, mrate, msec from INTERNATIONAL_RATE order by areacode asc");
using (FirebirdDBHelper db = new FirebirdDBHelper(sb.ToString(), util.strDBConn))
{
try
{
dt = db.GetDataTable();
}
catch (FirebirdSql.Data.FirebirdClient.FbException fex)
{
util.WriteLog(string.Format("{0} INIT ERR : {1}", this.GetType(), fex.Message));
return;
}
}
_list = new ObservableCollection<INTERNATIONALRATE>(
(from _row in dt.AsEnumerable()
select new INTERNATIONALRATE()
{
areacode = int.Parse(_row["areacode"].ToString())
,
lrate = double.Parse(_row["lrate"].ToString())
,
lsec = int.Parse(_row["lsec"].ToString())
,
mrate = double.Parse(_row["mrate"].ToString())
,
msec = int.Parse(_row["msec"].ToString())
}
).ToList<INTERNATIONALRATE>()
);
}
private bool CDRInfoValidate(out DataTable dt)
{
dt = null;
bool result = false;
//DataTable dt = null;
var tmparr = _extnum.Split(',');
string tmpext = string.Empty;
if (!string.IsNullOrEmpty(_extnum))
{
for (int k = 0; k < tmparr.Length; k++)
{
if (string.IsNullOrEmpty(tmpext))
{
tmpext = "'" + tmparr[k] + "'";
}
else
{
tmpext += ",'" + tmparr[k] + "'";
}
}
}
StringBuilder sb = new StringBuilder();
sb.AppendFormat("select first 2 * from tbl_log where 1=1 and room in ({0}) and (chk=1 or chk=0) order by room asc, regdate desc", tmpext);
using (FirebirdDBHelper db = new FirebirdDBHelper(sb.ToString(), util.strDBConn))
{
try
{
dt = db.GetDataTable();
}
catch (FirebirdSql.Data.FirebirdClient.FbException fex)
{
util.WriteLog(string.Format("{0} INIT ERR : {1}", this.GetType(), fex.Message));
}
}
if (dt.Rows.Count <= 0)
{
result = false;
}
else
{
if (dt.Rows[0][3].ToString().Equals("0"))
{
result = true;
}
else
{
result = false;
}
}
return result;
}
private void GetCDRInfo2(out DataTable dt)
{
dt = null;
StringBuilder sb = new StringBuilder();
sb.Append("select seq, caller, callee, startdate, enddate, result, caller_type, callee_type from cdrinfo where 1=1");
if (!string.IsNullOrEmpty(_extnum))
{
var tmparr = _extnum.Split(',');
string tmpext = string.Empty;
for (int k = 0; k < tmparr.Length; k++)
{
if (string.IsNullOrEmpty(tmpext))
{
tmpext = "'" + tmparr[k] + "'";
}
else
{
tmpext += ",'" + tmparr[k] + "'";
}
}
sb.AppendFormat(" and caller in ({0})", tmpext);
}
sb.AppendFormat(" and startdate between cast('{0}' as timestamp) and cast('{1}' as timestamp)", ((DateTime)sdate.Value).ToShortDateString(), ((DateTime)edate.Value).ToShortDateString());
sb.Append(" and caller_type=0");
sb.Append(" and result=0");
sb.Append(" order by caller asc, startdate asc");
using (FirebirdDBHelper db = new FirebirdDBHelper(sb.ToString(), util.strDBConn))
{
try
{
dt = db.GetDataTable();
}
catch (FirebirdSql.Data.FirebirdClient.FbException fex)
{
util.WriteLog(string.Format("{0} INIT ERR : {1}", this.GetType(), fex.Message));
}
}
}
private bool GetCDRInfo(out DataTable dt)
{
StringBuilder sb = new StringBuilder();
dt = null;
//if (chkout.IsChecked == true ? true : false)
//{
bool valid = CDRInfoValidate(out dt);
if (!valid)
{
return false;
}
else
{
sb.Append("select seq, caller, callee, startdate, enddate, result, caller_type, callee_type from cdrinfo where 1=1");
if (!string.IsNullOrEmpty(_extnum))
{
var tmparr = _extnum.Split(',');
string tmpext = string.Empty;
for (int k = 0; k < tmparr.Length; k++)
{
if (string.IsNullOrEmpty(tmpext))
{
tmpext = "'" + tmparr[k] + "'";
}
else
{
tmpext += ",'" + tmparr[k] + "'";
}
}
sb.AppendFormat(" and caller in ({0})", tmpext);
}
sb.AppendFormat(" and startdate between cast('{0}' as timestamp) and cast('{1}' as timestamp)", DateTime.Parse(dt.Rows[1][4].ToString()).ToString("yyyy-MM-dd HH:mm:ss"), DateTime.Parse(dt.Rows[0][4].ToString()).ToString("yyyy-MM-dd HH:mm:ss"));
sb.Append(" and caller_type=0");
sb.Append(" and result=0");
sb.Append(" order by caller asc, startdate asc");
using (FirebirdDBHelper db = new FirebirdDBHelper(sb.ToString(), util.strDBConn))
{
try
{
dt = db.GetDataTable();
}
catch (FirebirdSql.Data.FirebirdClient.FbException fex)
{
util.WriteLog(string.Format("{0} INIT ERR : {1}", this.GetType(), fex.Message));
}
}
return true;
}
//}
/*
sb.Append("select seq, caller, callee, startdate, enddate, result, caller_type, callee_type from cdrinfo where 1=1");
if (!string.IsNullOrEmpty(_extnum))
{
var tmparr = _extnum.Split(',');
string tmpext = string.Empty;
for (int k = 0; k < tmparr.Length; k++)
{
if (string.IsNullOrEmpty(tmpext))
{
tmpext = "'" + tmparr[k] + "'";
}
else
{
tmpext += ",'" + tmparr[k] + "'";
}
}
sb.AppendFormat(" and caller in ({0})", tmpext);
}
sb.AppendFormat(" and cast(startdate as date) between cast('{0}' as date) and cast('{1}' as date)", ((DateTime)sdate.Value).ToShortDateString(), ((DateTime)edate.Value).ToShortDateString());
sb.Append(" and caller_type=0");
sb.Append(" and result=0");
sb.Append(" order by caller asc, startdate asc");
using (FirebirdDBHelper db = new FirebirdDBHelper(sb.ToString(), util.strDBConn))
{
try
{
dt = db.GetDataTable();
}
catch (FirebirdSql.Data.FirebirdClient.FbException fex)
{
util.WriteLog(string.Format("{0} INIT ERR : {1}", this.GetType(), fex.Message));
}
}
return true;
*/
}