public bool update(Data data)
{
Profile_db profile = new Profile_db();
GoogleMap_gl google = new GoogleMap_gl();
data.add("latitude", google.GetLatitudeLongitude(data).Item1.ToString());
data.add("longitude", google.GetLatitudeLongitude(data).Item2.ToString());
return profile.update(data);
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
Data data = new Data();
Search_gl search = new Search_gl();
Paging_gl page = new Paging_gl();
Profile_gl profile = new Profile_gl();
Lucene_gl lucene = new Lucene_gl();
Data list = null;
data.add("search", search.searchUrlConversion(Param.getString("search")));
data.add("page", page.getCurrentSearchPage(Param.getString("page")));
data.add("range", Param.getString("range"));
data.add("rate", Param.getString("rate"));
if (data.getString("search") == "")
{
list = search.selectAll(data);
}
else
{
list = lucene.searchLucene(data);
}
int count = page.setPage(data);
for (int i = 1; i <= count; i++)
{
dropDownPage.Items.Add(new ListItem(i.ToString()));
}
dropDownPage.SelectedValue = Param.getString("page");
if (page.previousPage(Param.getString("page")) == true)
{
previous.Visible = false;
}
if (page.nextPage(Param.getString("page"), count) == true)
{
next.Visible = false;
}
// data.add all values in to same array, pass data array to advance search class in logical lib and split in to multiple search methods.
if (data.getString("range") != "" && data.getString("search") != "")
{
int range = Convert.ToInt32(data.getString("range"));
if (range > 0)
{
data.add("address", data.getString("search"));
list = search.searchRadius(data);
}
}
searchView.DataSource = list.Source;
searchView.DataBind();
}
}
public Data searchRadius(Data data)
{
Search_db search = new Search_db();
GoogleMap_gl google = new GoogleMap_gl();
double latitude = Convert.ToDouble(google.GetLatitudeLongitude(data).Item1);
double longitude = Convert.ToDouble(google.GetLatitudeLongitude(data).Item2);
int range = Convert.ToInt32(data.getString("range"));
data.add("northLongitude", google.northLongitude(range, longitude));
data.add("southLongitude", google.southLongitude(range, longitude));
data.add("eastLatitude", google.eastLatitude(range, latitude));
data.add("westLatitude", google.westLatitude(range, latitude));
return data;
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
User_lg user = new User_lg();
Account_lg account = new Account_lg();
Data data = new Data();
if (user.isLogin(Session) == true)
{
data.add("user_id", user.getUserSession(Session));
name.Text = user.getUser(data).getString("name");
Data accountList = account.select(data);
if (accountList.Count > 0)
{
hidden_account.Value = "1";
}
else
{
hidden_account.Value = "0";
}
balance.Text = account.select(data).getString("balance");
Data result = account.selectTransaction(data);
transaction.DataSource = result.Source;
transaction.DataBind();
}
else
{
go("../Transaction/Login.aspx");
}
}
}
public bool register(Data data)
{
User_db user = new User_db();
string password = Cryptopraphy.Encryption(data.getString("password"));
data.add("password", password);
return user.register_user(data);
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
Profile_gl profile = new Profile_gl();
User_gl user = new User_gl();
Data data = new Data();
if (user.isLogin(Session) == true)
{
data.add("username", user.getUsername(Session));
data.add("user_id", user.getUserID(data).getString("id"));
edit.Visible = true;
}
Data list = profile.select(Param);
nameLbl.Text = list.getString("name");
trading_hour.Text = Server.HtmlDecode(list.getString("trading_hour"));
phone.Text = Server.HtmlDecode(list.getString("phone"));
address.Text = list.getString("address");
email.Text = list.getString("email");
summary.Text = Server.HtmlDecode(list.getString("summary"));
profile_name.Value = list.getString("name");
profile_id.Value = list.getString("id");
data.add("profile_id", list.getString("id"));
//rating in percentage
Rating_gl rating = new Rating_gl();
data.add("totalRating", rating.getTotalRating(data).ToString());
rating1.Value = rating.getRatingOne(data).ToString();
rating2.Value = rating.getRatingTwo(data).ToString();
rating3.Value = rating.getRatingThree(data).ToString();
rating4.Value = rating.getRatingFour(data).ToString();
rating5.Value = rating.getRatingFive(data).ToString();
setPageTypeSession(Session, "profile");
//number of rated users
numRated1.Text = rating.numPerRate(data, "5").ToString();
numRated2.Text = rating.numPerRate(data, "4").ToString();
numRated3.Text = rating.numPerRate(data, "3").ToString();
numRated4.Text = rating.numPerRate(data, "2").ToString();
numRated5.Text = rating.numPerRate(data, "1").ToString();
double totalRating = rating.averageRating(data);
totalRatingLbl.Text = string.Format("{0:0.##}", totalRating);
rating_status.Value = rating.rateStatus(Session, data);
}
}
public Data login(Data data, HttpSessionState session)
{
User_db user = new User_db();
string password = Cryptopraphy.Encryption(data.getString("password_l"));
data.add("username", data.getString("username_l"));
string username = data.getString("username");
data.add("password", password);
Data result = user.login(data);
if (result.Count == 0)
{
data.add("loginError", "Invalid Input");
return null;
}
setSession(session, result);
return result;
}
protected void upload_Click(object sender, EventArgs e)
{
Data data = new Data();
ImageReformat format = new ImageReformat();
Stream imgStream = photo_upload.PostedFile.InputStream;
string name = photo_upload.FileName.ToString();
string path = "../image/client/" + name;
string _path = Server.MapPath("../image/client/" + name);
format.uploadImage(imgStream, _path);
Photo_gl photo = new Photo_gl();
data.add("caption", Param.getValue("caption"));
data.add("profile_id", Param.getValue("profileID"));
data.add("path", path);
data.add("name", name);
photo.insert(data);
go("../client/photo_upload.aspx?profile=" + Param.getString("profileName") + "&id=" + Param.getString("profileID"));
}
public void transfer(Data userAccount, Data targetAccount, Data data)
{
double enterAmount = Convert.ToDouble(data.getString("balance"));
Account_db account = new Account_db();
targetAccount.add("amount", enterAmount);
userAccount.add("amount", enterAmount);
account.transferTo(targetAccount);
account.transferFrom(userAccount);
}
public static String[] searchContent(string prefixText, int count)
{
Search_gl search = new Search_gl();
Data data = new Data();
data.add("search", prefixText);
Lucene_gl lucene = new Lucene_gl();
Data list = lucene.searchLucene(data);
return search.list(list);
}
protected void rateClick(object sender, EventArgs e)
{
Data data = new Data();
User_gl user = new User_gl();
Rating_gl rating = new Rating_gl();
data.add("username", user.getUsername(Session));
data.add("value", radioRate.SelectedValue);
data.add("profile_id", Param.getString("profile_id"));
data.add("user_id", user.getUserID(data).getString("id"));
if (Param.getString("rating_status") == "3")
{
rating.update(data);
}
else if(Param.getString("rating_status") == "1")
{
rating.insert(data);
}
go("../client/profile.aspx?profile=" + Param.getString("profile_name") +"&id=" + data.getString("profile_id"));
}
public bool insert(Data data)
{
Data db = new Data();
db.open();
int result_business = db.insert("INSERT INTO business (company, owner, phone, address, email) VALUES (@company, @owner, @phone, @address, @email)", data);
Object select_id = db.select("SELECT id AS business_id FROM business ORDER BY id DESC LIMIT 1", data).getValue("business_id");
data.add("business_id", select_id);
int result_profile = db.insert("INSERT INTO profile(business_id) VALUES (@business_id)", data);
db.close();
return true;
}
protected void createOnClick(object sender, EventArgs e)
{
Data data = new Data();
Account_lg account = new Account_lg();
Lucene_lg lucene = new Lucene_lg();
User_lg user = new User_lg();
data.add("user_id", user.getUserSession(Session));
account.insert(data);
lucene.addLucene(data);
go("../Transaction/Account.aspx");
}
protected void confirmOnClick(object sender, EventArgs e)
{
User_lg user = new User_lg();
Data data = new Data();
Account_lg account = new Account_lg();
Data targetUser = new Data();
targetUser.add("user_id", Param.getString("target_id"));
data.add("user_id", user.getUserSession(Session));
Data userAccount = account.select(data);
Data targetAccount = account.select(targetUser);
account.transfer(userAccount, targetAccount, Param);
Data tData = new Data();
tData.add("from_id", user.getUserSession(Session));
tData.add("to_id", Param.getString("target_id"));
tData.add("amount", Param.getString("balance"));
tData.add("from_name", user.getUser(data).getString("name"));
tData.add("to_name", user.getUser(targetUser).getString("name"));
account.transaction(tData);
go("../Transaction/Account.aspx");
}
protected void Page_Load(object sender, EventArgs e)
{
User_lg user = new User_lg();
if (user.isLogin(Session) == true)
{
Data data = new Data();
target_id.Value = Param.getString("user_id");
data.add("user_id", user.getUserSession(Session));
from.Text = user.getUser(data).getString("name");
to.Text = user.getUser(Param).getString("name");
}
else
{
go("../Transaction/Login.aspx");
}
}
protected void Page_Load(object sender, EventArgs e)
{
Data data = new Data();
Profile_gl profile = new Profile_gl();
User_gl user = new User_gl();
if (user.isLogin(Session) == true)
{
data.add("username", user.getUsername(Session));
profileID.Value = Param.getString("id");
profileName.Value = Param.getString("profile");
}
else
{
go("../client/profile.aspx?profile=" + Param.getString("profile") + "&id=" + Param.getString("id"));
}
//resize photo in album with top/left negative px value with fixed size image.
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
Data data = new Data();
Profile_gl profile = new Profile_gl();
User_gl user = new User_gl();
data.add("username", user.getUsername(Session));
Data list = profile.select(Param);
name.Text = list.getString("name");
trading_hour.Text = list.getString("trading_hour");
phone.Text = list.getString("phone");
address.Text = list.getString("address");
email.Text = list.getString("email");
summary.Text = list.getString("summary");
profileID.Value = list.getString("id");
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
Data data = new Data();
User_gl user = new User_gl();
if (user.isLogin(Session) == true)
{
data.add("username", user.getUsername(Session));
profileID.Value = Param.getString("id");
profileName.Value = Param.getString("profile");
}
else
{
go("../client/profile.aspx?profile=" + Param.getString("profile") + "&id=" + Param.getString("id"));
}
setPageTypeSession(Session, "new_profile");
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
Photo_gl photo = new Photo_gl();
User_gl user = new User_gl();
Data data = new Data();
Data list = photo.select(Param);
profileName.Value = Param.getString("profile");
profileID.Value = Param.getString("id");
photoView.DataSource = list.Source;
photoView.DataBind();
data.add("imageId", Param.getString("image"));
Data imageList = photo.selectImage(data);
imagePop.ImageUrl = imageList.getString("path");
checkImage.Value = imageList.getString("path");
caption.Text = imageList.getString("caption");
setPageTypeSession(Session, "photo");
//set a size for photo album, set overflowhidden, fixed small images and top/left with minus fixed pixels
}
}
public Data totalRating(Data data)
{
Data db = new Data();
db.open();
Data result = db.select("SELECT sum(value) FROM rating WHERE profile_id=@profile_id", data);
data.add("sum_rating", result.getString("sum(value)"));
Data total = db.select("SELECT value FROM rating WHERE profile_id=@profile_id", data);
db.close();
return total;
}
public Data select(String query, Data data)
{
cmd = null;
Data result = new Data();
cmd = new MySqlCommand(query, connect);
String key = null;
MySqlDbType types = MySqlDbType.VarChar;
int size = -1;
Object[] keys = data.getKeys();
Object value = null;
int now = 0;
if (keys != null)
{
int length = keys.Length;
for (int i = 0; i < length; i++)
{
key = "@" + keys[i].ToString();
value = data.getValue(keys[i]);
size = data.getSize(keys[i]);
types = data.getType(keys[i]);
if (size > 0)
{
cmd.Parameters.Add(key, types);
}
else
{
cmd.Parameters.Add(key, types, size);
}
cmd.Parameters[key].Value = value;
}
}
read = cmd.ExecuteReader();
try
{
while (read.Read())
{
int readCount = read.FieldCount;
for (int i = 0; i < readCount; i++)
{
result.add(now, read.GetName(i), read.GetValue(i));
}
++now;
}
}
catch (Exception e)
{
Console.WriteLine(e.Message);
errorMsg = e.Message;
}
finally
{
if (cmd != null)
{
cmd.Parameters.Clear();
}
if (read != null)
{
read.Close();
}
}
return result;
}
public static Data Param(HttpRequest request)
{
Data parameters = new Data();
int count = request.Params.Count;
int pCount = 0;
string key = null;
string[] value = null;
for (int i = 0; i < count; i++)
{
key = request.Params.GetKey(i);
if (key == null)
{
continue;
}
if (key.IndexOf("__") == 0)
{
continue;
}
int keyIndex = key.LastIndexOf("$") + 1;
if (keyIndex > 0)
{
key = key.Substring(keyIndex, key.Length - keyIndex);
}
if (key.IndexOf("Btn") != -1)
{
continue;
}
if (key.IndexOf("_ClientState") != -1)
{
continue;
}
if (key.Length < 1)
{
continue;
}
value = request.Params.GetValues(i);
pCount = value.Length;
if (value != null)
{
if (key.Equals("now"))
{
parameters.Now = int.Parse(value[0]);
}
else
{
for (int j = 0; j < pCount; j++)
{
if (key.Equals("date")) //add time to date
{
DateTime date = DateTime.Parse(value[j]);
value[j] = date.ToString();
}
parameters.add(j, key, value[j]);
}
}
}
}
return parameters;
}
public int numPerRate(Data data, String value)
{
Rating_db rating = new Rating_db();
data.add("value", value);
return rating.numPerRate(data).Count;
}
