internal List <ObservablePhoneBill> GetPhoneBillList()
{
List <ObservablePhoneBill> billList = new List <ObservablePhoneBill>();
using (SQLiteConnection dbConn = new SQLiteConnection(dbPath))
{
string sql = @"select * from BillMetaData order by EpochBillDate desc;";
using (var statement = dbConn.Prepare(sql))
{
while (statement.Step() == SQLiteResult.ROW)
{
PhoneBill phone_bill = new PhoneBill();
phone_bill._billNo = statement[0].ToString();
phone_bill.BillType = statement[1].ToString();
phone_bill._phoneNo = statement[2].ToString();
phone_bill.BillDate = statement[3].ToString();
try { phone_bill.FromDate = statement[4].ToString(); }
catch (Exception ex) { }
try { phone_bill.ToDate = statement[5].ToString(); }
catch (Exception ex) { }
try { phone_bill.DueDate = statement[6].ToString(); }
catch (Exception ex) { }
ObservablePhoneBill bill = new ObservablePhoneBill(phone_bill);
billList.Add(bill);
}
}
}
return(billList);
}
public bool DeletePhoneBill(string billNo)
{
ObservablePhoneBill old_bill = GetObservablePhoneBill(billNo);
List <DBQuery> queryList = new List <DBQuery>();
String sql; // The query itself
DBQuery query; // Query Object
sql = @"DELETE FROM BillMetaData WHERE BillNo = ?";
query = new DBQuery();
query.Query = sql;
query.addQueryData(billNo);
queryList.Add(query);
sql = @"DELETE FROM BillCallDetails WHERE BillNo = ?";
query = new DBQuery();
query.Query = sql;
query.addQueryData(billNo);
queryList.Add(query);
bool success = dbHelper.executeQueries(queryList);
if (old_bill != null)
{
_phoneBillList.Remove(old_bill);
_phoneBillDictionary.Remove(billNo);
}
return(success);
}
public void AddBillToList(PhoneBill pb)
{
ObservablePhoneBill opb = new ObservablePhoneBill(pb);
ObservablePhoneBill old_bill = GetObservablePhoneBill(pb._billNo);
if (old_bill != null)
{
_phoneBillList.Remove(old_bill);
_phoneBillDictionary.Remove(pb._billNo);
}
_phoneBillList.Add(opb);
_phoneBillDictionary.Add(pb._billNo, opb);
}
