public HttpResponseMessage AddPrayerImage(string GUID)
{
PenYourPrayerIdentity user = (PenYourPrayerIdentity)User.Identity;
string savepath = "";
string filename = GUID;
var httpRequest = HttpContext.Current.Request;
if (httpRequest.Files.Count > 0)
{
foreach (string file in httpRequest.Files)
{
var postedFile = httpRequest.Files[file];
string extension = postedFile.FileName.Substring(postedFile.FileName.LastIndexOf('.'));
filename = filename + extension;
String directoryTosave = QuickReference.PrayerAttachmentImageTemp + @"\" + user.ID.ToString();
if (!System.IO.Directory.Exists(directoryTosave))
{
System.IO.Directory.CreateDirectory(directoryTosave);
}
savepath = directoryTosave + @"\" + filename;
if (!System.IO.File.Exists(savepath))
{
postedFile.SaveAs(savepath);
}
}
}
return(Request.CreateResponse(HttpStatusCode.Accepted, new CustomResponseMessage()
{
StatusCode = (int)HttpStatusCode.Accepted, Description = filename
}));
}
public HttpResponseMessage AddNewPrayerAnswered(string QueueActionGUID, string PrayerID, PrayerAnswered p)
{
PenYourPrayerIdentity user = (PenYourPrayerIdentity)User.Identity;
using (DBDataContext db = new DBDataContext())
{
String res = "";
long? AnsweredID = -1;
db.usp_AddNewPrayerAnswered(QueueActionGUID, (long?)user.ID, long.Parse(p.OwnerPrayerID), p.Answered, p.CreatedWhen, p.TouchedWhen, ref res, ref AnsweredID);
if (res.ToUpper() == "OK")
{
return(Request.CreateResponse(HttpStatusCode.OK, new CustomResponseMessage()
{
StatusCode = (int)HttpStatusCode.OK, Description = "OK-" + AnsweredID.ToString()
}));
}
else
{
return(Request.CreateResponse(HttpStatusCode.OK, new CustomResponseMessage()
{
StatusCode = (int)HttpStatusCode.OK, Description = res
}));
}
}
}
public HttpResponseMessage UpdateTagFriends(string QueueActionGUID, string PrayerID, List <Friends> selectedFriends)
{
XElement t = new XElement("Friends");
if (selectedFriends != null)
{
foreach (Friends friend in selectedFriends)
{
XElement x = new XElement("Friend");
x.Add(new XElement("UserID", friend.UserID));
t.Add(x);
}
}
PenYourPrayerIdentity user = (PenYourPrayerIdentity)User.Identity;
using (DBDataContext db = new DBDataContext())
{
String res = "";
db.usp_UpdatePrayerTagFriends(QueueActionGUID, (long?)user.ID, long.Parse(PrayerID), t, ref res);
return(Request.CreateResponse(HttpStatusCode.OK, new CustomResponseMessage()
{
StatusCode = (int)HttpStatusCode.OK, Description = res
}));
}
}
public HttpResponseMessage AddNewPrayer(Prayer prayer)
{
long?prayerid = -1;
using (DBDataContext db = new DBDataContext())
{
PenYourPrayerIdentity user = (PenYourPrayerIdentity)User.Identity;
XElement selectedFriends = new XElement("Friends");
if (prayer.selectedFriends != null)
{
foreach (Friends friend in prayer.selectedFriends)
{
XElement t = new XElement("Friend");
t.Add(new XElement("UserID", friend.UserID));
selectedFriends.Add(t);
}
}
String res = "";
db.usp_AddNewPrayer((long?)user.ID, prayer.Content, prayer.CreatedWhen, prayer.TouchedWhen, prayer.publicView, selectedFriends, prayer.IfExecutedGUID, ref res, ref prayerid);
if (res.ToUpper() != "OK")
{
db.usp_GetCreatedPrayerFromQueueActionGUID((long?)user.ID, prayer.IfExecutedGUID, ref prayerid);
return(Request.CreateResponse(HttpStatusCode.OK, new CustomResponseMessage()
{
StatusCode = (int)HttpStatusCode.OK, Description = res
}));
}
if (prayer.attachments != null)
{
foreach (PrayerAttachment att in prayer.attachments)
{
long? attachmentID = -1;
string extension = att.FileName.Substring(att.FileName.LastIndexOf('.'));
string fileFrom = QuickReference.PrayerAttachmentImageTemp + @"\" + user.ID.ToString() + @"\" + att.GUID + extension;
string fileTo = QuickReference.PrayerAttachmentImage + @"\" + user.ID.ToString() + @"\" + att.GUID + extension;
if (!System.IO.Directory.Exists(QuickReference.PrayerAttachmentImage + @"\" + user.ID.ToString()))
{
System.IO.Directory.CreateDirectory(QuickReference.PrayerAttachmentImage + @"\" + user.ID.ToString());
}
if (System.IO.File.Exists(fileFrom))
{
System.IO.File.Move(fileFrom, fileTo);
db.usp_AddNewPrayerAttachment(prayerid, att.GUID + extension, att.OriginalFilePath, (long?)user.ID, ref attachmentID);
}
else
{
}
}
}
}
return(Request.CreateResponse(HttpStatusCode.Created, new CustomResponseMessage()
{
StatusCode = (int)HttpStatusCode.Created, Description = prayerid.ToString()
}));
}
public HttpResponseMessage UpdatePrayerAnswered(string QueueActionGUID, string PrayerID, PrayerAnswered p)
{
PenYourPrayerIdentity user = (PenYourPrayerIdentity)User.Identity;
using (DBDataContext db = new DBDataContext())
{
String res = "";
db.usp_UpdatePrayerAnswered(QueueActionGUID, (long?)user.ID, long.Parse(p.AnsweredID), p.Answered, p.TouchedWhen, ref res);
return(Request.CreateResponse(HttpStatusCode.OK, new CustomResponseMessage()
{
StatusCode = (int)HttpStatusCode.OK, Description = res
}));
}
}
public HttpResponseMessage UpdatePublicView(string QueueActionGUID, string PrayerID, bool PublicView)
{
PenYourPrayerIdentity user = (PenYourPrayerIdentity)User.Identity;
using (DBDataContext db = new DBDataContext())
{
String res = "";
db.usp_UpdatePrayerPublicView(QueueActionGUID, (long?)user.ID, long.Parse(PrayerID), PublicView, ref res);
return(Request.CreateResponse(HttpStatusCode.OK, new CustomResponseMessage()
{
StatusCode = (int)HttpStatusCode.OK, Description = res
}));
}
}
public HttpResponseMessage DeletePrayerAmen(string QueueActionGUID, string PrayerID)
{
PenYourPrayerIdentity user = (PenYourPrayerIdentity)User.Identity;
using (DBDataContext db = new DBDataContext())
{
long? AmenID = -1;
String res = "";
db.usp_DeletePrayerAmen(QueueActionGUID, (long?)user.ID, long.Parse(PrayerID));
return(Request.CreateResponse(HttpStatusCode.OK, new CustomResponseMessage()
{
StatusCode = (int)HttpStatusCode.OK, Description = "OK"
}));
}
}
public HttpResponseMessage AddNewPrayerRequest(string QueueActionGUID, PrayerRequest p)
{
PenYourPrayerIdentity user = (PenYourPrayerIdentity)User.Identity;
using (DBDataContext db = new DBDataContext())
{
String res = "";
long? PrayerRequestID = -1;
db.usp_AddNewPrayerRequest(QueueActionGUID, (long?)user.ID, p.Subject, p.Description, p.CreatedWhen, p.TouchedWhen, ref res, ref PrayerRequestID);
if (res.ToUpper() != "OK")
{
return(Request.CreateResponse(HttpStatusCode.OK, new CustomResponseMessage()
{
StatusCode = (int)HttpStatusCode.OK, Description = res
}));
}
if (p.attachments != null)
{
foreach (PrayerRequestAttachment att in p.attachments)
{
long? attachmentID = -1;
string extension = att.FileName.Substring(att.FileName.LastIndexOf('.'));
string fileFrom = QuickReference.PrayerAttachmentImageTemp + @"\" + user.ID.ToString() + @"\" + att.GUID + extension;
string fileTo = QuickReference.PrayerAttachmentImage + @"\" + user.ID.ToString() + @"\" + att.GUID + extension;
if (!System.IO.Directory.Exists(QuickReference.PrayerAttachmentImage + @"\" + user.ID.ToString()))
{
System.IO.Directory.CreateDirectory(QuickReference.PrayerAttachmentImage + @"\" + user.ID.ToString());
}
if (System.IO.File.Exists(fileFrom))
{
System.IO.File.Move(fileFrom, fileTo);
db.usp_AddNewPrayerRequestAttachment(PrayerRequestID, att.GUID + extension, att.OriginalFilePath, (long?)user.ID, ref attachmentID);
}
else
{
}
}
}
return(Request.CreateResponse(HttpStatusCode.OK, new CustomResponseMessage()
{
StatusCode = (int)HttpStatusCode.OK, Description = "OK-" + PrayerRequestID.ToString()
}));
}
}
public HttpResponseMessage UpdatePrayerRequest(string QueueActionGUID, PrayerRequest p)
{
PenYourPrayerIdentity user = (PenYourPrayerIdentity)User.Identity;
using (DBDataContext db = new DBDataContext())
{
String res = "";
long PrayerRequestID = -1;
if (!long.TryParse(p.PrayerRequestID, out PrayerRequestID))
{
return(Request.CreateResponse(HttpStatusCode.OK, new CustomResponseMessage()
{
StatusCode = (int)HttpStatusCode.OK, Description = "NOTEXISTS-" + p.PrayerRequestID
}));
}
if (p.Answered)
{
db.usp_UpdatePrayerRequest(QueueActionGUID, (long?)user.ID, PrayerRequestID, p.Subject, p.Description, p.Answered, p.AnswerComment, p.AnsweredWhen, p.TouchedWhen, ref res);
}
else
{
db.usp_UpdatePrayerRequest(QueueActionGUID, (long?)user.ID, PrayerRequestID, p.Subject, p.Description, p.Answered, p.AnswerComment, null, p.TouchedWhen, ref res);
}
if (res.ToUpper() != "OK")
{
return(Request.CreateResponse(HttpStatusCode.OK, new CustomResponseMessage()
{
StatusCode = (int)HttpStatusCode.OK, Description = res
}));
}
if (p.attachments != null)
{
}
return(Request.CreateResponse(HttpStatusCode.OK, new CustomResponseMessage()
{
StatusCode = (int)HttpStatusCode.OK, Description = "OK-" + PrayerRequestID.ToString()
}));
}
}
public HttpResponseMessage GetLatestPrayerRequest(string Useless, List <PrayerRequest> pr)
{
Int64 n;
String id = "";
foreach (PrayerRequest prayerRequest in pr)
{
bool isNumeric = Int64.TryParse(prayerRequest.PrayerRequestID, out n);
if (isNumeric)
{
id += prayerRequest.PrayerRequestID + ";";
}
}
PenYourPrayerIdentity user = (PenYourPrayerIdentity)User.Identity;
List <PrayerRequest> newPrayerRequest = new List <PrayerRequest>();
using (DBDataContext db = new DBDataContext())
{
List <usp_GetLatestPrayerRequestResult> res = db.usp_GetLatestPrayerRequest(user.ID, id).ToList();
foreach (usp_GetLatestPrayerRequestResult f in res)
{
PrayerRequest temp = (PrayerRequest)f;
if (f.Attachments != null)
{
XmlSerializer serializer = new XmlSerializer(typeof(AllPrayerRequestAttachment));
TextReader reader = new StringReader(f.Attachments.ToString());
temp.attachments = ((AllPrayerRequestAttachment)serializer.Deserialize(reader)).attachments;
reader.Close();
}
newPrayerRequest.Add(temp);
}
}
return(Request.CreateResponse(HttpStatusCode.OK, newPrayerRequest));
}
public HttpResponseMessage CheckImageUploaded(string GUID, string filename)
{
PenYourPrayerIdentity user = (PenYourPrayerIdentity)User.Identity;
string savepath1 = "";
string savepath2 = "";
filename = GUID + filename.Substring(filename.LastIndexOf('.'));
String directoryTosave1 = QuickReference.PrayerAttachmentImageTemp + @"\" + user.ID.ToString();
String directoryTosave2 = QuickReference.PrayerAttachmentImage + @"\" + user.ID.ToString();
if (!System.IO.Directory.Exists(directoryTosave1))
{
System.IO.Directory.CreateDirectory(directoryTosave1);
}
if (!System.IO.Directory.Exists(directoryTosave2))
{
System.IO.Directory.CreateDirectory(directoryTosave2);
}
savepath1 = directoryTosave1 + @"\" + filename;
savepath2 = directoryTosave2 + @"\" + filename;
if (!System.IO.File.Exists(savepath1) && !System.IO.File.Exists(savepath2))
{
return(Request.CreateResponse(HttpStatusCode.Accepted, new CustomResponseMessage()
{
StatusCode = (int)HttpStatusCode.Accepted, Description = "NOTEXISTS"
}));
}
else
{
return(Request.CreateResponse(HttpStatusCode.Accepted, new CustomResponseMessage()
{
StatusCode = (int)HttpStatusCode.Accepted, Description = "EXISTS-" + filename
}));
}
}
public HttpResponseMessage GetLatestFriends(List <Friends> friend)
{
String userid = "";
foreach (Friends f in friend)
{
userid += f.UserID.ToString() + ";";
}
PenYourPrayerIdentity user = (PenYourPrayerIdentity)User.Identity;
List <Friends> newfriend = new List <Friends>();
using (DBDataContext db = new DBDataContext())
{
List <usp_GetLatestFriendsResult> res = db.usp_GetLatestFriends(user.ID, userid).ToList();
foreach (usp_GetLatestFriendsResult f in res)
{
newfriend.Add((Friends)f);
}
}
return(Request.CreateResponse(HttpStatusCode.OK, newfriend));
}
public HttpResponseMessage DeletePrayerRequest(string QueueActionGUID, string PrayerRequestID)
{
PenYourPrayerIdentity user = (PenYourPrayerIdentity)User.Identity;
using (DBDataContext db = new DBDataContext())
{
try
{
String res = "";
db.usp_DeletePrayerRequest(QueueActionGUID, (long?)user.ID, long.Parse(PrayerRequestID), ref res);
return(Request.CreateResponse(HttpStatusCode.OK, new CustomResponseMessage()
{
StatusCode = (int)HttpStatusCode.OK, Description = res
}));
}
catch (Exception e)
{
return(Request.CreateResponse(HttpStatusCode.OK, new CustomResponseMessage()
{
StatusCode = (int)HttpStatusCode.OK, Description = "NOTEXISTS"
}));
}
}
}
public HttpResponseMessage GetPastOthersPrayers(long LastPrayerID)
{
PenYourPrayerIdentity user = (PenYourPrayerIdentity)User.Identity;
using (DBDataContext db = new DBDataContext())
{
String res = "";
List <Prayer> latestprayer = new List <Prayer>();
List <usp_GetPastOthersPrayersResult> p = db.usp_GetPastOthersPrayers((long?)user.ID, (long?)LastPrayerID).ToList();
foreach (usp_GetPastOthersPrayersResult t in p)
{
Prayer prayer = new Prayer();
prayer.PrayerID = t.PrayerID;
var offset = TimeZoneInfo.Local.GetUtcOffset(DateTime.UtcNow);
prayer.UserID = t.UserID;
prayer.TouchedWhen = t.TouchedWhen;
prayer.CreatedWhen = t.CreatedWhen;
prayer.Content = t.PrayerContent;
prayer.publicView = t.PublicView;
prayer.IfExecutedGUID = t.QueueActionGUID;
if (t.TagFriends != null)
{
XmlSerializer serializer = new XmlSerializer(typeof(AllFriends));
TextReader reader = new StringReader(t.TagFriends.ToString());
prayer.selectedFriends = ((AllFriends)serializer.Deserialize(reader)).friends;
reader.Close();
}
if (t.Attachments != null)
{
XmlSerializer serializer = new XmlSerializer(typeof(AllPrayerAttachment));
TextReader reader = new StringReader(t.Attachments.ToString());
prayer.attachments = ((AllPrayerAttachment)serializer.Deserialize(reader)).attachments;
reader.Close();
}
if (t.Comment != null)
{
XmlSerializer serializer = new XmlSerializer(typeof(AllPrayerComments));
TextReader reader = new StringReader(t.Comment.ToString());
prayer.comments = ((AllPrayerComments)serializer.Deserialize(reader)).comments;
reader.Close();
}
if (t.Answers != null)
{
XmlSerializer serializer = new XmlSerializer(typeof(AllPrayerAnswered));
TextReader reader = new StringReader(t.Answers.ToString());
prayer.answers = ((AllPrayerAnswered)serializer.Deserialize(reader)).answers;
reader.Close();
}
if (t.Amen != null)
{
XmlSerializer serializer = new XmlSerializer(typeof(AllPrayerAmen));
TextReader reader = new StringReader(t.Amen.ToString());
prayer.amen = ((AllPrayerAmen)serializer.Deserialize(reader)).amen;
reader.Close();
}
if (t.OwnerProfile != null)
{
XmlSerializer serializer = new XmlSerializer(typeof(PenYourPrayerUser));
TextReader reader = new StringReader(t.OwnerProfile.ToString());
prayer.OwnerProfile = (PenYourPrayerUser)serializer.Deserialize(reader);
}
latestprayer.Add(prayer);
}
return(Request.CreateResponse(HttpStatusCode.OK, latestprayer));
//return Request.CreateResponse(HttpStatusCode.OK, new CustomResponseMessage() { StatusCode = (int)HttpStatusCode.OK, Description = res });
}
}
