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);
}
}
}
