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; }