public UserDTO GetProfileByPhone(string phoneNumber, string lang, int userType)
{
UserQuery userQuery = new UserQuery(language);
System.Data.DataTable dataTable;
if (userType == 1)
{
dataTable = conn_db.ReadTable(userQuery.GetProfileByPhoneForPerson(phoneNumber));
}
else
{
dataTable = conn_db.ReadTable(userQuery.GetProfileByPhoneForWorkshop(phoneNumber, lang));
}
if (dataTable.Rows.Count == 0)
{
throw new EmptyViewException(language);
}
UserDTO profile = new UserDTO();
profile.user_id = dataTable.Rows[0]["USER_ID"] is DBNull ? 0 : Convert.ToInt32(dataTable.Rows[0]["USER_ID"]);
profile.accessToken = dataTable.Rows[0]["ACCESSTOKEN"].ToString();
profile.countryCode = dataTable.Rows[0]["COUNTRYCODE"] is DBNull ? 0 : Convert.ToInt32(dataTable.Rows[0]["COUNTRYCODE"]);
profile.phoneNumber = dataTable.Rows[0]["PHONENUMBER"].ToString();
profile.userType = dataTable.Rows[0]["USERTYPE"] is DBNull ? 0 : Convert.ToInt32(dataTable.Rows[0]["USERTYPE"]);
profile.userImage = dataTable.Rows[0]["USERIMAGE"].ToString();
profile.rating = dataTable.Rows[0]["RATING"] is DBNull ? 0 : Convert.ToDouble(dataTable.Rows[0]["RATING"]);
profile.firstName = dataTable.Rows[0]["FIRSTNAME"].ToString();
profile.lastName = dataTable.Rows[0]["LASTNAME"].ToString();
profile.shopNumber = dataTable.Rows[0]["STORE_NUMBER"] is DBNull ? 0 : Convert.ToInt32(dataTable.Rows[0]["STORE_NUMBER"]);
profile.shopName = dataTable.Rows[0]["STORE_NAME"].ToString();
profile.cityId = dataTable.Rows[0]["CITYID"] is DBNull ? 0 : Convert.ToInt32(dataTable.Rows[0]["CITYID"]);
profile.cityName = dataTable.Rows[0]["CITY_NAME"].ToString();
profile.address = dataTable.Rows[0]["ADDRESS"].ToString();
profile.Lat = dataTable.Rows[0]["LAT"] is DBNull ? 0 : Convert.ToDouble(dataTable.Rows[0]["LAT"]);
profile.Lng = dataTable.Rows[0]["LNG"] is DBNull ? 0 : Convert.ToDouble(dataTable.Rows[0]["LNG"]);
return(profile);
}