public static EMS.Entities.MyProfileMDL GetProfileDetails(int UserId, int BusinessId) { EMS.Entities.MyProfileMDL user = new EMS.Entities.MyProfileMDL(); using (DBSqlCommand cmd = new DBSqlCommand()) { try { cmd.AddParameters(UserId, CommonConstants.UserId, System.Data.SqlDbType.Int); cmd.AddParameters(BusinessId, CommonConstants.BusinessID, System.Data.SqlDbType.Int); System.Data.IDataReader ireader = cmd.ExecuteDataReader(SqlProcedures.Get_MyAccountDetails); while (ireader.Read()) { var userDet = new EMS.Entities.MyProfileMDL { UserFirstName = ireader.GetString(CommonColumns.FirstName), UserLastName = ireader.GetString(CommonColumns.LastName), Email = ireader.GetString(CommonColumns.UserEmail), Fax = ireader.GetString(CommonColumns.BusinessFax), AddressLine1 = ireader.GetString(CommonColumns.UserAddressLine1), City = ireader.GetString(CommonColumns.City), State = ireader.GetString(CommonColumns.State), Country = ireader.GetString(CommonColumns.Country), //RenewalDate = ireader.GetDateTime(CommonColumns.UserAccountExpiryDate), Licences = ireader.GetInt16(CommonColumns.Licences), BusinessName = ireader.GetString(CommonColumns.BusinessName), LogMeOutId = ireader.GetInt32(CommonColumns.LogMeOutId), EndDate = ireader.GetNullLocalDateTime(CommonColumns.UserAccountExpiryDate), CityId = ireader.GetInt32(CommonColumns.CityId), StateId = ireader.GetInt32(CommonColumns.StateId), CountryId = ireader.GetInt16(CommonColumns.CountryId), ImagePath = ireader.GetString(CommonColumns.ImagePath) }; user = userDet; } return(user); } catch (Exception ex) { return(null); } } }