public UserDTO GetProfileByUserId(string user_id, string lang, int userType)
{
UserQuery userQuery = new UserQuery(language);
System.Data.DataTable dataTable = new System.Data.DataTable();
if (userType == (int)Enums.UserType.person)
{
dataTable = conn_db.ReadTable(userQuery.GetProfileByUserIdForPerson(user_id));
}
else if (userType == (int)Enums.UserType.workshop)
{
dataTable = conn_db.ReadTable(userQuery.GetProfileByUserIdForSupplier(user_id, 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.rater_no = dataTable.Rows[0]["RATER_NO"] is DBNull ? 0 : Convert.ToInt32(dataTable.Rows[0]["RATER_NO"]);
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"]);
if (userType == (int)Enums.UserType.person)
{
profile.supplierType = "";
}
else if (userType == (int)Enums.UserType.workshop)
{
profile.supplierType = dataTable.Rows[0]["suppliertype_name"] is DBNull ? "" : dataTable.Rows[0]["suppliertype_name"].ToString();
}
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"]);
profile.isActive = dataTable.Rows[0]["isActive"] is DBNull ? 0 : Convert.ToInt32(dataTable.Rows[0]["isActive"]);
return(profile);
}
