public ParkingLocation GetUserParkingLocation(string userId)
        {
            ParkingLocation parkingLocation = null;

            try
            {
                using (SqlCommand cmd = new SqlCommand(StoredProcedures.SPR_GET_USER_PARKING_LOCATION, _connection))
                {
                    cmd.CommandType = CommandType.StoredProcedure;
                    cmd.Parameters.Add("@UserId", SqlDbType.VarChar).Value = userId;

                    SqlDataReader dr = cmd.ExecuteReader();

                    if (dr != null)
                    {
                        if (dr.HasRows)
                        {
                            if (dr.Read())
                            {
                                parkingLocation = new ParkingLocation();
                                parkingLocation.Latitude = dr["Latitude"].ToString();
                                parkingLocation.Longitude = dr["Longitude"].ToString();
                            }
                        }
                    }

                }
            }
            catch (Exception ex)
            {

            }

            return parkingLocation;
        }
        private void SaveParkingLocation()
        {
            ParkingLocation parkingLocation = new ParkingLocation();
            parkingLocation.Latitude = hiddLatitude.Value;
            parkingLocation.Longitude = hiddLongitude.Value;
            parkingLocation.UserId = _userObj.UserId;

            ParkingLocationBLL parkingLocationBLL = new ParkingLocationBLL();
            parkingLocationBLL.UpdateParkingLocation(parkingLocation);
        }
        public bool UpdateParkingLocation(ParkingLocation parkingLocation)
        {
            try
            {
                using (SqlCommand cmd = new SqlCommand(StoredProcedures.SPR_UPDATE_PARKING_LOCATION, _connection))
                {
                    cmd.CommandType = CommandType.StoredProcedure;
                    cmd.Parameters.Add("@UserId", SqlDbType.VarChar).Value = parkingLocation.UserId;
                    cmd.Parameters.Add("@Latitude", SqlDbType.VarChar).Value = parkingLocation.Latitude;
                    cmd.Parameters.Add("@Longitude", SqlDbType.VarChar).Value = parkingLocation.Longitude;

                    cmd.ExecuteNonQuery();

                    return true;
                }

            }
            catch (Exception ex)
            {
                return false;
            }
        }
示例#4
0
        public User ValidateUser(string userName, string password)
        {
            User validUser = null;

            try
            {
                using (SqlCommand cmd = new SqlCommand(StoredProcedures.SPR_VALIDATE_USER, _connection))
                {
                    cmd.CommandType = CommandType.StoredProcedure;
                    cmd.Parameters.Add("@UserName", SqlDbType.VarChar).Value = userName;
                    cmd.Parameters.Add("@Password", SqlDbType.VarChar).Value = password;

                    SqlDataReader dr = cmd.ExecuteReader();

                    if (dr != null)
                    {
                        if (dr.HasRows)
                        {
                            if (dr.Read())
                            {
                                validUser = new User();
                                validUser.UserName = dr["UserName"].ToString();
                                validUser.EmailAddress = dr["EmailAddress"].ToString();
                                validUser.UserId = dr["UserId"].ToString();

                                ParkingLocation parkingLocation = new ParkingLocation();
                                parkingLocation.UserId = dr["UserId"].ToString();
                                parkingLocation.LocationId = dr["LocationId"].ToString();
                                parkingLocation.Latitude = dr["Latitude"].ToString();
                                parkingLocation.Longitude = dr["Longitude"].ToString();

                                validUser.ParkingLocation = parkingLocation;

                                validUser.ModelId = Convert.ToInt32(dr["ModelId"]);
                                validUser.MakeId = Convert.ToInt32(dr["MakeId"]);
                                validUser.Year = Convert.ToInt32(dr["Year"]);

                                validUser.isAdmin = false;
                            }
                        }
                    }

                }
            }
            catch (Exception ex)
            {

            }

            return validUser;
        }
 public bool UpdateParkingLocation(ParkingLocation parkingLocation)
 {
     return new ParkingLocationDAL().UpdateParkingLocation(parkingLocation);
 }