private static void UpdateCurrentLocation(CurrentLocation currentLocation, IDataLayer dataLayer) { dataLayer.ConnectionString = ConfigurationManager.AppSettings["ConnectionString"].ToString(); dataLayer.Sql = "update CurrentLocation set lat = @lat, long = @long where deviceid = @deviceid"; dataLayer.AddParameter("@deviceId", currentLocation.DeviceID); dataLayer.AddParameter("@lat", currentLocation.Lat); dataLayer.AddParameter("@long", currentLocation.Long); dataLayer.ExecuteNonQuery(); }
private static void InsertCurrentLocation(CurrentLocation currentLocation, IDataLayer dataLayer) { dataLayer.ConnectionString = ConfigurationManager.AppSettings["ConnectionString"].ToString(); dataLayer.Sql = "insert into CurrentLocation values(@deviceId, @lat, @long)"; dataLayer.AddParameter("@deviceId", currentLocation.DeviceID); dataLayer.AddParameter("@lat", currentLocation.Lat); dataLayer.AddParameter("@long", currentLocation.Long); dataLayer.ExecuteNonQuery(); }
private static void UpdateUpdateActivity(Activity activity, IDataLayer dataLayer) { dataLayer.ConnectionString = ConfigurationManager.AppSettings["ConnectionString"].ToString(); dataLayer.Sql = "update Activity set what = @what, [when] = @when, lat = @lat, long = @long where deviceid = @deviceid"; dataLayer.AddParameter("@deviceId", activity.DeviceID); dataLayer.AddParameter("@What", activity.What); dataLayer.AddParameter("@when", activity.When); dataLayer.AddParameter("@lat", activity.Lat); dataLayer.AddParameter("@long", activity.Long); dataLayer.ExecuteNonQuery(); }
private static bool IsProfileFound(string deviceId, IDataLayer dataLayer) { dataLayer.ConnectionString = ConfigurationManager.AppSettings["ConnectionString"].ToString(); dataLayer.Sql = "select count(*) from Profile where deviceid = @deviceid"; dataLayer.AddParameter("@deviceid", deviceId); return((int)dataLayer.ExecuteScalar() > 0); }
private static void SavePicture(string deviceId, string filePath, IDataLayer dataLayer) { dataLayer.ConnectionString = ConfigurationManager.AppSettings["ConnectionString"].ToString(); dataLayer.Sql = string.Format("update activity set image = (select * from openrowset(BULK N'{0}', SINGLE_BLOB) AS CategoryImage) where deviceid = @deviceid", filePath); dataLayer.AddParameter("@deviceid", deviceId); dataLayer.ExecuteNonQuery(); }
private static Profile GetProfile(string deviceId, IDataLayer dataLayer) { Profile profile = null; try { dataLayer.ConnectionString = ConfigurationManager.AppSettings["ConnectionString"].ToString(); dataLayer.Sql = "select * from profile where deviceid = @deviceid"; dataLayer.AddParameter("@deviceid", deviceId); DataTable dataTable = dataLayer.ExecuteDataTable(); if (dataTable != null && dataTable.Rows != null && dataTable.Rows.Count == 1) { profile = new Profile() { DeviceID = (string)dataTable.Rows[0]["deviceid"], UserName = (string)dataTable.Rows[0]["username"], ProfileName = (string)dataTable.Rows[0]["profilename"], Hobies = (string)dataTable.Rows[0]["hobies"], About = (string)dataTable.Rows[0]["about"], //Rating = (byte)dataTable.Rows[0]["rating"], //Reviews = (long)dataTable.Rows[0]["reviews"], //views = (long)dataTable.Rows[0]["views"] }; } else if (dataTable.Rows.Count > 1) { //return new HttpError("More than one profile found"); } }catch (Exception ex) { //throw ex; } return(profile); }
private static bool IsDeviceFound(CurrentLocation currentLocation, IDataLayer dataLayer) { dataLayer.ConnectionString = ConfigurationManager.AppSettings["ConnectionString"].ToString(); dataLayer.Sql = "select count(*) from CurrentLocation where deviceid = @deviceid"; dataLayer.AddParameter("@deviceid", currentLocation.DeviceID); return((int)dataLayer.ExecuteScalar() > 0); }
private static void InsertActivity(Activity activity, IDataLayer dataLayer) { dataLayer.ConnectionString = ConfigurationManager.AppSettings["ConnectionString"].ToString(); dataLayer.Sql = "insert into Activity values(@deviceId, @what, @when, @lat, @long, null, @description, @id)"; dataLayer.AddParameter("@deviceId", activity.DeviceID); dataLayer.AddParameter("@What", activity.What); dataLayer.AddParameter("@when", activity.When); dataLayer.AddParameter("@lat", activity.Lat); dataLayer.AddParameter("@long", activity.Long); dataLayer.AddParameter("@description", activity.description); dataLayer.AddParameter("@id", Guid.NewGuid()); dataLayer.ExecuteNonQuery(); }
private static void UpdateProfile(Profile profile, IDataLayer dataLayer) { try { dataLayer.ConnectionString = ConfigurationManager.AppSettings["ConnectionString"].ToString(); dataLayer.Sql = "update Profile set username = @username, profilename = @profilename, hobies = @hobies, about = @about, rating = @rating, reviews = @reviews, views = @reviews where deviceid = @deviceid"; dataLayer.AddParameter("@deviceid", profile.DeviceID); dataLayer.AddParameter("@username", profile.UserName); dataLayer.AddParameter("@profilename", profile.ProfileName); dataLayer.AddParameter("@hobies", profile.Hobies); dataLayer.AddParameter("@about", profile.About); dataLayer.AddParameter("@rating", profile.Rating); dataLayer.AddParameter("@reviews", profile.Reviews); dataLayer.AddParameter("@views", profile.views); dataLayer.ExecuteNonQuery(); } catch (Exception ex) { throw ex; } }
private static void InsertProfile(Profile profile, IDataLayer dataLayer) { try { dataLayer.ConnectionString = ConfigurationManager.AppSettings["ConnectionString"].ToString(); dataLayer.Sql = "insert into Profile (deviceid, username, profilename, hobies, about, rating, reviews, views) values(@deviceId, @username, @profilename, @hobies, @about, @rating, @reviews, @views)"; dataLayer.AddParameter("@deviceId", profile.DeviceID); dataLayer.AddParameter("@username", profile.UserName); //dataLayer.AddParameter("@profilephoto", profile.ProfilePhoto); dataLayer.AddParameter("@profilename", profile.ProfileName); dataLayer.AddParameter("@hobies", profile.Hobies); dataLayer.AddParameter("@about", profile.About); dataLayer.AddParameter("@rating", profile.Rating); dataLayer.AddParameter("@reviews", profile.Reviews); dataLayer.AddParameter("@views", profile.views); dataLayer.ExecuteNonQuery(); } catch (Exception ex) { throw ex; } }