public static MyProduct myProducts(UserLogin userLogin)
{
MyProduct myProducts = null;
try
{
if (!string.IsNullOrEmpty(userLogin.sessid))
{
myProducts = Classes.WebService.myProducts(userLogin);
db.insertMyProduct(myProducts);
}
myProducts = db.getMyProduct();
}
catch (Exception)
{
myProducts = db.getMyProduct();
isOffLine = true;
}
return(myProducts);
}
public bool insertMyProduct(MyProduct myProducts)
{
try
{
deleteMyProduct();
int index = 1;
foreach (var product in myProducts.product)
{
string local_picture = null;
if (!string.IsNullOrEmpty(product.picture))
{
local_picture = Helper.saveImage(product.picture);
}
var sql = "INSERT INTO Product (id,nid, title,author,picture,local_picture,order_time,price,type) " +
"values ('" + index + "','" + product.nid + "','" + product.title + "','" + product.author + "','" + product.picture + "','" + local_picture + "','" + product.order_time + "'," + product.price + ",'product')";
SQLiteCommand commandp = new SQLiteCommand(sql, m_dbConnection);
commandp.ExecuteNonQuery();
commandp.Dispose();
var pid = index;
sql = string.Empty;
foreach (var file in product.files)
{
var key = Helper.RandomString();
var password = Helper.Encrypt(file.password, key);
sql += "INSERT INTO File (pid, url,filesize,title,name,new_name,password,password_key) " +
"values ('" + pid + "','" + file.url + "','" + file.filesize + "','" + file.title + "','" + file.name + "','" + file.new_name + ".bin','" + password + "','" + key + "');";
}
SQLiteCommand command = new SQLiteCommand(sql, m_dbConnection);
command.ExecuteNonQuery();
command.Dispose();
index++;
}
foreach (var product in myProducts.college)
{
string local_picture = null;
if (!string.IsNullOrEmpty(product.picture))
{
local_picture = Helper.saveImage(product.picture);
}
var sql = "INSERT INTO Product (id,nid, title,author,picture,local_picture,order_time,price,type) " +
"values ('" + index + "','" + product.nid + "','" + product.title + "','" + product.author + "','" + product.picture + "','" + local_picture + "','" + product.order_time + "'," + product.price + ",'college')";
SQLiteCommand commandp = new SQLiteCommand(sql, m_dbConnection);
commandp.Dispose();
var pid = index;
sql = string.Empty;
foreach (var file in product.files)
{
var key = Helper.RandomString();
var password = Helper.Encrypt(file.password, key);
sql += "INSERT INTO File (pid, url,filesize,title,name,new_name,password,password_key) " +
"values ('" + pid + "','" + file.url + "','" + file.filesize + "','" + file.title + "','" + file.name + "','" + file.new_name + ".bin','" + password + "','" + key + "');";
}
SQLiteCommand command = new SQLiteCommand(sql, m_dbConnection);
command.ExecuteNonQuery();
command.Dispose();
index++;
}
foreach (var product in myProducts.product_kit)
{
string local_picture = null;
if (!string.IsNullOrEmpty(product.picture))
{
local_picture = Helper.saveImage(product.picture);
}
var sql = "INSERT INTO Product (id,nid, title,author,picture,local_picture,order_time,price,type) " +
"values ('" + index + "','" + product.nid + "','" + product.title + "','" + product.author + "','" + product.picture + "','" + local_picture + "','" + product.order_time + "'," + product.price + ",'product_kit')";
SQLiteCommand commandp = new SQLiteCommand(sql, m_dbConnection);
commandp.Dispose();
var pid = index;
sql = string.Empty;
foreach (var file in product.files)
{
var key = Helper.RandomString();
var password = Helper.Encrypt(file.password, key);
sql += "INSERT INTO File (pid, url,filesize,title,name,new_name,password,password_key) " +
"values ('" + pid + "','" + file.url + "','" + file.filesize + "','" + file.title + "','" + file.name + "','" + file.new_name + ".bin','" + password + "','" + key + "');";
}
SQLiteCommand command = new SQLiteCommand(sql, m_dbConnection);
command.ExecuteNonQuery();
command.Dispose();
index++;
}
return(true);
}
catch (Exception e)
{
return(false);
}
}
public MyProduct getMyProduct()
{
MyProduct myProductObj = null;
try
{
DataTable myProduct = new DataTable();
var sql = "SELECT * FROM Product";
SQLiteCommand command = new SQLiteCommand(sql, m_dbConnection);
myProduct.Load(command.ExecuteReader());
command.Dispose();
myProductObj = new MyProduct();
for (int i = 0; i < myProduct.Rows.Count; i++)
{
var productObj = new Product();
var type = myProduct.Rows[i]["type"].ToString();
#region load Files
DataTable files = new DataTable();
var id = myProduct.Rows[i]["id"].ToString();
sql = "SELECT * FROM File WHERE pid = " + id;
command = new SQLiteCommand(sql, m_dbConnection);
files.Load(command.ExecuteReader());
#endregion
productObj.author = myProduct.Rows[i]["author"].ToString();
productObj.nid = int.Parse(myProduct.Rows[i]["nid"].ToString());
productObj.order_time = int.Parse(myProduct.Rows[i]["order_time"].ToString());
productObj.picture = myProduct.Rows[i]["picture"].ToString();
productObj.local_picture = myProduct.Rows[i]["local_picture"].ToString();
productObj.price = int.Parse(myProduct.Rows[i]["price"].ToString());
productObj.title = myProduct.Rows[i]["title"].ToString();
productObj.files = new List <File>();
for (int j = 0; j < files.Rows.Count; j++)
{
var fileObj = new File();
fileObj.title = files.Rows[j]["title"].ToString();
fileObj.url = files.Rows[j]["url"].ToString();
fileObj.filesize = int.Parse(files.Rows[j]["filesize"].ToString());
fileObj.name = files.Rows[j]["name"].ToString();
fileObj.new_name = files.Rows[j]["new_name"].ToString();
var key = files.Rows[j]["password_key"].ToString();
var password = files.Rows[j]["password"].ToString();
fileObj.password = Helper.Decrypt(password, key);
productObj.files.Add(fileObj);
}
if (type == "product_kit")
{
if (myProductObj.product_kit == null)
{
myProductObj.product_kit = new List <Product>();
}
myProductObj.product_kit.Add(productObj);
}
else if (type == "product")
{
if (myProductObj.product == null)
{
myProductObj.product = new List <Product>();
}
myProductObj.product.Add(productObj);
}
else
{
if (myProductObj.college == null)
{
myProductObj.college = new List <Product>();
}
myProductObj.college.Add(productObj);
}
}
return(myProductObj);
}
catch (Exception e)
{
return(myProductObj);
}
}