public List <NewTran> LoadData(string productId, string recordType, string lang)
{
DB.CreateDataBase(G.db.tran);
string sql = string.Format(@"SELECT id, productId, tran, recordType, lang FROM tran {0}"
, string.IsNullOrEmpty(productId) ? string.Format("WHERE recordType = '{0}' AND lang = '{1}'", recordType, lang) : string.Format("WHERE productId = '{0}' AND recordType = '{1}' AND lang = '{2}'", productId, recordType, lang));
List <NewTran> xx = new List <NewTran>();
using (var connection = new SQLiteConnection("Data Source=" + DB.GetDataBasePath(G.dataBase))) {
connection.Open();
using (var command = new SQLiteCommand(sql, connection)) {
using (var reader = command.ExecuteReader()) {
xx = new List <NewTran>();
while (reader.Read())
{
NewTran x = new NewTran();
x.id = G.ReadS(reader, 0);
x.productId = G.ReadS(reader, 1);
x.tran = G.ReadS(reader, 2);
x.recordType = G.ReadS(reader, 3);
x.lang = G.ReadS(reader, 4);
xx.Add(x);
}
}
}
connection.Close();
}
return(xx);
}
public string Save(NewTran x)
{
try {
DB.CreateDataBase(G.db.tran);
string sql = null;
if (string.IsNullOrEmpty(x.id))
{
x.id = Guid.NewGuid().ToString();
sql = string.Format(@"INSERT INTO tran VALUES('{0}', '{1}', '{2}', '{3}', '{4}')"
, x.id, x.productId, x.tran, x.recordType, x.lang);
}
else
{
sql = string.Format(@"UPDATE tran SET productId = '{1}', tran = '{2}', recordType = '{3}', lang = '{4}' WHERE id = '{0}'"
, x.id, x.productId, x.tran, x.recordType, x.lang);
}
using (var connection = new SQLiteConnection("Data Source=" + DB.GetDataBasePath(G.dataBase))) {
connection.Open();
using (var command = new SQLiteCommand(sql, connection)) {
command.ExecuteNonQuery();
}
connection.Close();
}
return(JsonConvert.SerializeObject(LoadData(x.productId, x.recordType, x.lang), Formatting.None));
} catch (Exception e) {
return(JsonConvert.SerializeObject(e.Message, Formatting.None));
}
}
public string Init()
{
try {
NewTran x = new NewTran();
x.id = null;
x.productId = null;
x.tran = null;
x.recordType = null;
x.lang = null;
return(JsonConvert.SerializeObject(x, Formatting.None));
} catch (Exception e) {
return(JsonConvert.SerializeObject(e.Message, Formatting.None));
}
}
