/// <summary> /// /// </summary> /// <param name="providerId"></param> /// <returns></returns> public GetProfileEntity GetUserProfile(string providerId) { Guid providerGuid; Guid.TryParse(providerId, out providerGuid); object[] param = { providerGuid }; var dbCommand = _db.GetCommand("dbo.GET_PROVIDER", param); var providerDataReader = _db.ExecuteReader(dbCommand); if (providerDataReader == null) { throw new Exception(); } GetProfileEntity getProfile = null; while (providerDataReader.Read()) { getProfile = new GetProfileEntity { FirstName = providerDataReader["FirstName"].ToString(), LastName = providerDataReader["LastName"].ToString(), Email = providerDataReader["Mobile"].ToString() }; } return(getProfile); }
public HttpResponseMessage RegisterUser(GetProfileEntity getProfile) { try { var result = _userProfileApplication.RegisterUser(getProfile); return Request.CreateResponse(HttpStatusCode.OK, ServiceResponse<int>.Instance.BuildResponse(ResponseCodes.OK, result)); } catch (Exception ex) { LogManager.GetCurrentClassLogger().Error(ex, ex.Message); return Request.CreateResponse(HttpStatusCode.InternalServerError, ServiceResponse.Instance.BuildResponse(ResponseCodes.SERVERERROR)); } }
/// <summary> /// /// </summary> /// <param name="getProfile"></param> /// <returns></returns> public int RegisterUser(GetProfileEntity getProfile) { var providerGuid = Guid.NewGuid(); object[] param = { getProfile.FirstName, getProfile.LastName, getProfile.Email, providerGuid, getProfile.UserId }; var dbCommand = _db.GetStoredProcCommand("dbo.INSERT_INTO_PROVIDER"); _db.AddInParameter(dbCommand, "@firstname", System.Data.DbType.String, getProfile.FirstName); _db.AddInParameter(dbCommand, "@lastname", System.Data.DbType.String, getProfile.LastName); _db.AddInParameter(dbCommand, "@email", System.Data.DbType.String, getProfile.Email); _db.AddInParameter(dbCommand, "@providerguid", System.Data.DbType.Guid, providerGuid); _db.AddInParameter(dbCommand, "@userid", System.Data.DbType.String, getProfile.UserId); _db.AddInParameter(dbCommand, "@imageurl", System.Data.DbType.String, getProfile.ImageUrl); _db.AddOutParameter(dbCommand, "@providerid", System.Data.DbType.Int32, 0); var result = _db.ExecuteNonQuery(dbCommand); int providerId = Convert.ToInt32(_db.GetParameterValue(dbCommand, "@providerid")); return(providerId); }
/// <summary> /// /// </summary> /// <param name="getProfile"></param> /// <returns></returns> public int RegisterUser(GetProfileEntity getProfile) { var providerId = _userProfileDAL.RegisterUser(getProfile); return(providerId); }