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