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