public int DeleteHobby(DeleteHobby deleteHobby)
{
ObjectParameter result = new ObjectParameter("Result", typeof(int));
using (TestingSample1Entities dataContext = new TestingSample1Entities())
{
dataContext.HobbyDelete(deleteHobby.HobbyId, result);
}
return(Convert.ToInt32(result.Value));
}
public int AddHobby(AddHobby addHobby)
{
ObjectParameter result = new ObjectParameter("Result", typeof(int));
using (TestingSample1Entities dataContext = new TestingSample1Entities())
{
dataContext.HobbyAdd(addHobby.HobbyName, result);
}
return(Convert.ToInt32(result.Value));
}
public int DeleteCountry(DeleteCountry deleteCountry)
{
int result = 0;
using (TestingSample1Entities testingSample1Entities = new TestingSample1Entities())
{
ObjectParameter opResult = new ObjectParameter("Result", typeof(int));
testingSample1Entities.CountryDelete(deleteCountry.CountryId, deleteCountry.ModifiedBy, opResult);
result = Convert.ToInt32(opResult.Value);
}
return(result);
}
public int AddCountry(AddCountry addCountry)
{
int result = 0;
using (TestingSample1Entities testingSample1Entities = new TestingSample1Entities())
{
ObjectParameter opResult = new ObjectParameter("Result", typeof(int));
testingSample1Entities.CountryAdd(addCountry.CountryName, addCountry.CreatedBy, opResult);
result = Convert.ToInt32(opResult.Value);
}
return(result);
}
public int DeleteState(DeleteState deleteState)
{
int result = 0;
using (TestingSample1Entities testingSample1Entities = new TestingSample1Entities())
{
ObjectParameter opResult = new ObjectParameter("Result", typeof(int));
testingSample1Entities.StateDelete(deleteState.StateId, opResult);
result = Convert.ToInt32(opResult.Value);
}
return(result);
}
public int UpdateState(UpdateState updateState)
{
int result = 0;
using (TestingSample1Entities testingSample1Entities = new TestingSample1Entities())
{
ObjectParameter opResult = new ObjectParameter("Result", typeof(int));
testingSample1Entities.StateUpdate(updateState.StateId, updateState.StateName, updateState.CountryId, opResult);
result = Convert.ToInt32(opResult.Value);
}
return(result);
}
public int AddUserProfile(AddUserProfile addUserProfile)
{
int result = 0;
using (TestingSample1Entities testingSample1Entities = new TestingSample1Entities())
{
ObjectParameter opResult = new ObjectParameter("Result", typeof(int));
testingSample1Entities.UserProfileAdd(addUserProfile.Username, addUserProfile.Password, addUserProfile.FirstName, addUserProfile.LastName, addUserProfile.Phone, addUserProfile.CountryId, opResult);
result = Convert.ToInt32(opResult.Value);
}
return(result);
}
public User UserLogin(UserLogin userLogin)
{
User user = new User();
using (TestingSample1Entities testingSample1Entities = new TestingSample1Entities())
{
var userDetail = testingSample1Entities.UserLogin(userLogin.Username, userLogin.Password).FirstOrDefault();
if (userDetail != null)
{
user.UserId = userDetail.UserId;
user.Username = userDetail.Username;
user.RoleId = userDetail.RoleId;
}
}
return(user);
}
public IEnumerable <Country> GetCountry(Country country)
{
List <Country> countryList = new List <Country>();
using (TestingSample1Entities testingSample1Entities = new TestingSample1Entities())
{
var countries = testingSample1Entities.CountryGet(country.CountryId).ToList();
foreach (var countryItem in countries)
{
countryList.Add(new Country()
{
CountryId = countryItem.CountryId,
CountryName = countryItem.CountryName
});
}
}
return(countryList);
}
public IEnumerable <Hobby> GetHobby(Hobby hobby)
{
List <Hobby> hobbyList = new List <Hobby>();
using (TestingSample1Entities dataContext = new TestingSample1Entities())
{
var hobbies = dataContext.HobbyGet(hobby.HobbyId).ToList();
foreach (var hobbyItem in hobbies)
{
hobbyList.Add(new Hobby()
{
HobbyId = hobbyItem.HobbyId,
HobbyName = hobbyItem.HobbyName
});
}
}
return(hobbyList);
}
public IEnumerable <State> GetState(State state)
{
List <State> stateList = new List <State>();
using (TestingSample1Entities testingSample1Entities = new TestingSample1Entities())
{
var states = testingSample1Entities.StateGet(state.StateId, state.CountryId).ToList();
foreach (var stateItem in states)
{
stateList.Add(new State()
{
StateId = stateItem.StateId,
StateName = stateItem.StateName,
CountryId = stateItem.CountryId,
CountryName = stateItem.CountryName
});
}
}
return(stateList);
}
public IEnumerable <UserProfile> GetUserProfile(UserProfile userProfile)
{
List <UserProfile> userProfileList = new List <UserProfile>();
using (TestingSample1Entities testingSample1Entities = new TestingSample1Entities())
{
var userProfiles = testingSample1Entities.UserProfileGet(userProfile.UserId).ToList();
foreach (var userProfileItem in userProfiles)
{
userProfileList.Add(new UserProfile()
{
UserId = userProfileItem.UserId,
Username = userProfileItem.Username,
FirstName = userProfileItem.FirstName,
LastName = userProfileItem.LastName,
Phone = userProfileItem.Phone,
CountryId = userProfileItem.CountryId
});
}
}
return(userProfileList);
}
