public HttpResponseMessage SubscriptionList() { SubscriptionListResponse result = new SubscriptionListResponse(); PicUploadResponse res = new PicUploadResponse(); try { result.Response.listofSubscription = _objFriendFitDBEntity.Database.SqlQuery <SubscriptionList>("select Id,SubcriptionType from SubscriptionTypeMaster").ToList(); if (result.Response.listofSubscription.Count > 0) { result.Response.StatusCode = Convert.ToInt32(HttpStatusCode.OK); res.Response.Message = "Success!!"; } else { result.Response.StatusCode = Convert.ToInt32(HttpStatusCode.NotFound); res.Response.Message = "Id is not Found"; } } catch (Exception ex) { res.Response.StatusCode = Convert.ToInt32(HttpStatusCode.InternalServerError); res.Response.Message = "Some error occured!!"; _response = Request.CreateResponse(HttpStatusCode.InternalServerError, res); } _response = Request.CreateResponse(HttpStatusCode.OK, result); return(_response); }
public HttpResponseMessage DeleteFriend(Int64 id) { PicUploadResponse res = new PicUploadResponse(); try { int rowEffected = _objFriendFitDBEntity.Database.ExecuteSqlCommand("Update FriendsInvitation set IsRowActive=0 where Id={0}", id); if (rowEffected > 0) { res.Response.StatusCode = Convert.ToInt32(HttpStatusCode.OK); res.Response.Message = "Friend Notification is deleted successfully!!"; } else { res.Response.StatusCode = Convert.ToInt32(HttpStatusCode.OK); res.Response.Message = "Id of given user is not there!"; } } catch (Exception ex) { res.Response.StatusCode = Convert.ToInt32(HttpStatusCode.InternalServerError); res.Response.Message = "Some error occured!!"; _response = Request.CreateResponse(HttpStatusCode.InternalServerError, res); } _response = Request.CreateResponse(HttpStatusCode.OK, res); return(_response); }
public HttpResponseMessage GetUserImage() { UpdateUserPicResponseModel result = new UpdateUserPicResponseModel(); PicUploadResponse res = new PicUploadResponse(); try { var headers = Request.Headers; string token = headers.Authorization.Parameter.ToString(); Int64 UserId = _objFriendFitDBEntity.Database.SqlQuery <Int64>("select UserId from UserToken where TokenCode={0}", token).FirstOrDefault(); if (UserId != 0) { string value = _objFriendFitDBEntity.Database.SqlQuery <string>("select ProfilePic from UserProfile where Id=@UserId", new SqlParameter("UserId", UserId)).FirstOrDefault(); if (value != null) { result.Response.ProfilePic = _ServerURL + value; result.Response.StatusCode = Convert.ToInt32(HttpStatusCode.OK); result.Response.Message = "Success!!"; } else { result.Response.ProfilePic = _ServerURL + "/Content/ProfileImages/default.png"; result.Response.StatusCode = Convert.ToInt32(HttpStatusCode.OK); result.Response.Message = "Success!!"; //res.Response.StatusCode = Convert.ToInt32(HttpStatusCode.NotFound); //res.Response.Message = "Image does not found!!"; //_response = Request.CreateResponse(HttpStatusCode.NotFound, res); } } else { res.Response.StatusCode = Convert.ToInt32(HttpStatusCode.NotFound); res.Response.Message = "User Id does not found!!"; _response = Request.CreateResponse(HttpStatusCode.NotFound, res); } } catch (Exception ex) { res.Response.StatusCode = Convert.ToInt32(HttpStatusCode.InternalServerError); res.Response.Message = "Some error occured!!"; _response = Request.CreateResponse(HttpStatusCode.InternalServerError, res); } _response = Request.CreateResponse(HttpStatusCode.OK, result); return(_response); }
public async Task <HttpResponseMessage> PostUserImage() { UploadUserPicRequestModel objUploadUserPicRequestModel = new UploadUserPicRequestModel(); PicUploadResponse res = new PicUploadResponse(); Dictionary <string, object> dict = new Dictionary <string, object>(); try { var headers = Request.Headers; string token = headers.Authorization.Parameter.ToString(); Int64 UserId = _objFriendFitDBEntity.Database.SqlQuery <Int64>("select UserId from UserToken where TokenCode={0}", token).FirstOrDefault(); var httpRequest = HttpContext.Current.Request; foreach (string file in httpRequest.Files) { HttpResponseMessage response = Request.CreateResponse(HttpStatusCode.Created); var postedFile = httpRequest.Files[file]; if (postedFile != null && postedFile.ContentLength > 0) { int MaxContentLength = 1024 * 1024 * 3; //Size = 3 MB IList <string> AllowedFileExtensions = new List <string> { ".jpg", ".gif", ".png" }; var ext = postedFile.FileName.Split('\\').LastOrDefault().Split('/').LastOrDefault().Substring(postedFile.FileName.Split('\\').LastOrDefault().Split('/').LastOrDefault().LastIndexOf('.')); var extension = ext.ToLower(); if (!AllowedFileExtensions.Contains(extension)) { res.Response.StatusCode = Convert.ToInt32(HttpStatusCode.NotAcceptable); res.Response.Message = string.Format("Please Upload image of type .jpg,.gif,.png"); _response = Request.CreateResponse(HttpStatusCode.NotAcceptable, res); } else if (postedFile.ContentLength > MaxContentLength) { res.Response.StatusCode = Convert.ToInt32(HttpStatusCode.NotAcceptable); res.Response.Message = string.Format("Please Upload a file upto 2 mb."); _response = Request.CreateResponse(HttpStatusCode.NotAcceptable, res); } else { var filePath = HttpContext.Current.Server.MapPath("~/Content/ProfileImages/" + postedFile.FileName.Split('\\').LastOrDefault().Split('/').LastOrDefault()); objUploadUserPicRequestModel.ProfilePic = _profileImagesPath + postedFile.FileName.Split('\\').LastOrDefault().Split('/').LastOrDefault(); postedFile.SaveAs(filePath); int value = _objFriendFitDBEntity.Database.ExecuteSqlCommand("Update UserProfile set ProfilePic=@ProfilePic where Id=@UserId", new SqlParameter("ProfilePic", objUploadUserPicRequestModel.ProfilePic), new SqlParameter("UserId", UserId) ); if (value > 0) { res.Response.StatusCode = Convert.ToInt32(HttpStatusCode.OK); res.Response.Message = "Profile Picture is updated successfully!!"; _response = Request.CreateResponse(HttpStatusCode.OK, res); } else { res.Response.StatusCode = Convert.ToInt32(HttpStatusCode.NotAcceptable); res.Response.Message = "Picture which you are trying to update is incorrect Format."; _response = Request.CreateResponse(HttpStatusCode.NotAcceptable, res); } } } } } catch (Exception ex) { res.Response.StatusCode = Convert.ToInt32(HttpStatusCode.InternalServerError); res.Response.Message = "Some error occured!!"; _response = Request.CreateResponse(HttpStatusCode.InternalServerError, res); } return(_response); }