public async Task <HttpResponseMessage> GetDeletedList(MT_Knowledger_Base KCMD) { Db = con.SurgeryCenterDb(KCMD.Slug); KnowledgeBaseResponse Response = new KnowledgeBaseResponse(); try { List <MT_Knowledger_Base> List = new List <MT_Knowledger_Base>(); Query docRef = Db.Collection("MT_Knowledger_Base").WhereEqualTo("KNB_Is_Deleted", true).OrderBy("KNB_Category"); QuerySnapshot ObjQuerySnap = await docRef.GetSnapshotAsync(); if (ObjQuerySnap != null) { foreach (DocumentSnapshot Docsnapshot in ObjQuerySnap.Documents) { List.Add(Docsnapshot.ConvertTo <MT_Knowledger_Base>()); } Response.DataList = List; } Response.Status = con.StatusSuccess; Response.Message = con.MessageSuccess; } catch (Exception ex) { Response.Status = con.StatusFailed; Response.Message = con.MessageFailed + ", Exception : " + ex.Message; } return(ConvertToJSON(Response)); }
public async Task <HttpResponseMessage> Select(MT_Knowledger_Base KCMD) { Db = con.SurgeryCenterDb(KCMD.Slug); KnowledgeBaseResponse Response = new KnowledgeBaseResponse(); try { Query Qty = Db.Collection("MT_Knowledger_Base").WhereEqualTo("KNB_Is_Deleted", false).WhereEqualTo("KNB_Is_Active", true).WhereEqualTo("KNB_Unique_ID", KCMD.KNB_Unique_ID); QuerySnapshot ObjQuerySnap = await Qty.GetSnapshotAsync(); if (ObjQuerySnap != null) { Response.Data = ObjQuerySnap.Documents[0].ConvertTo <MT_Knowledger_Base>(); Response.Message = con.MessageSuccess; Response.Status = con.StatusSuccess; } else { Response.Message = con.MessageDNE; Response.Status = con.StatusDNE; } } catch (Exception ex) { Response.Status = con.StatusFailed; Response.Message = con.MessageFailed + ", Exception : " + ex.Message; } return(ConvertToJSON(Response)); }
public HttpResponseMessage Upload() { KnowledgeBaseResponse Response = new KnowledgeBaseResponse(); string imageUrl = ""; try { var httpRequest = HttpContext.Current.Request; if (httpRequest.Files.Count > 0) { foreach (string file in httpRequest.Files) { var postedFile = httpRequest.Files[file]; int hasheddate = DateTime.Now.GetHashCode(); string changed_name = DateTime.Now.ToString("yyyyMMddHHmmss") + postedFile.FileName.Substring(postedFile.FileName.IndexOf('.'), (postedFile.FileName.Length - postedFile.FileName.IndexOf('.'))); // imageUrl = await _imageUploader.UploadImage(postedFile, 10); } } Response.Status = con.StatusSuccess; Response.Message = "Path : " + imageUrl; } catch (Exception ex) { Response.Status = con.StatusFailed; Response.Message = con.MessageFailed + ", Exception : " + ex.Message; } return(ConvertToJSON(Response)); }
public async Task <HttpResponseMessage> IsDeletedReference(MT_Knowledger_Base KCMD) { Db = con.SurgeryCenterDb(KCMD.Slug); KnowledgeBaseResponse Response = new KnowledgeBaseResponse(); try { MT_Knowledger_Base KBase = new MT_Knowledger_Base(); List <KBReference> RefList = new List <KBReference>(); Query Qty = Db.Collection("MT_Knowledger_Base").WhereEqualTo("KNB_Is_Deleted", false).WhereEqualTo("KNB_Is_Active", true).WhereEqualTo("KNB_Unique_ID", KCMD.KNB_Unique_ID); QuerySnapshot ObjQuerySnap = await Qty.GetSnapshotAsync(); if (ObjQuerySnap != null) { KBase = ObjQuerySnap.Documents[0].ConvertTo <MT_Knowledger_Base>(); if (KBase.KNB_References != null) { foreach (KBReference refe in KBase.KNB_References) { if (refe.KBR_Unique_ID != KCMD.KNB_References[0].KBR_Unique_ID) { RefList.Add(refe); } } } } KCMD.KNB_Modify_Date = con.ConvertTimeZone(KCMD.KNB_TimeZone, Convert.ToDateTime(KCMD.KNB_Modify_Date)); KCMD.KNB_References = RefList; Dictionary <string, object> initialData = new Dictionary <string, object> { { "KNB_Modify_Date", con.ConvertTimeZone(KCMD.KNB_TimeZone, Convert.ToDateTime(KCMD.KNB_Modify_Date)) }, { "KNB_References", KCMD.KNB_References }, }; DocumentReference docRef = Db.Collection("MT_Knowledger_Base").Document(KCMD.KNB_Unique_ID); WriteResult Result = await docRef.UpdateAsync(initialData); if (Result != null) { Response.Status = con.StatusSuccess; Response.Message = con.MessageSuccess; Response.Data = KCMD; } else { Response.Status = con.StatusNotInsert; Response.Message = con.MessageNotInsert; Response.Data = null; } } catch (Exception ex) { Response.Status = con.StatusFailed; Response.Message = con.MessageFailed + ", Exception : " + ex.Message; } return(ConvertToJSON(Response)); }
public async Task <HttpResponseMessage> Update(MT_Knowledger_Base KCMD) { Db = con.SurgeryCenterDb(KCMD.Slug); KnowledgeBaseResponse Response = new KnowledgeBaseResponse(); try { Dictionary <string, object> initialData = new Dictionary <string, object> { { "KNB_Name", KCMD.KNB_Name }, { "KNB_Category", KCMD.KNB_Category }, { "KNB_Sub_Category", KCMD.KNB_Sub_Category }, { "KNB_Short_Description", KCMD.KNB_Short_Description }, { "KNB_Long_Description", KCMD.KNB_Long_Description }, { "KNB_Modify_Date", con.ConvertTimeZone(KCMD.KNB_TimeZone, Convert.ToDateTime(KCMD.KNB_Modify_Date)) }, //{"KNB_Document", KCMD.KNB_Document}, //{"KNB_References", KCMD.KNB_References}, }; DocumentReference docRef = Db.Collection("MT_Knowledger_Base").Document(KCMD.KNB_Unique_ID); WriteResult Result = await docRef.UpdateAsync(initialData); if (Result != null) { Response.Status = con.StatusSuccess; Response.Message = con.MessageSuccess; Response.Data = KCMD; } else { Response.Status = con.StatusNotUpdate; Response.Message = con.MessageNotUpdate; Response.Data = null; } } catch (Exception ex) { Response.Status = con.StatusFailed; Response.Message = con.MessageFailed + ", Exception : " + ex.Message; } return(ConvertToJSON(Response)); }
public async Task <HttpResponseMessage> CreateAsync(MT_Knowledger_Base KCMD) { Db = con.SurgeryCenterDb(KCMD.Slug); KnowledgeBaseResponse Response = new KnowledgeBaseResponse(); try { List <string> List = new List <string>(); UniqueID = con.GetUniqueKey(); KCMD.KNB_Unique_ID = UniqueID; KCMD.KNB_Create_Date = con.ConvertTimeZone(KCMD.KNB_TimeZone, Convert.ToDateTime(KCMD.KNB_Create_Date)); KCMD.KNB_Modify_Date = con.ConvertTimeZone(KCMD.KNB_TimeZone, Convert.ToDateTime(KCMD.KNB_Modify_Date)); DocumentReference docRef = Db.Collection("MT_Knowledger_Base").Document(UniqueID); WriteResult Result = await docRef.SetAsync(KCMD); if (Result != null) { Response.Status = con.StatusSuccess; Response.Message = con.MessageSuccess; Response.Data = KCMD; } else { Response.Status = con.StatusNotInsert; Response.Message = con.MessageNotInsert; Response.Data = null; } } catch (Exception ex) { Response.Status = con.StatusFailed; Response.Message = con.MessageFailed + ", Exception : " + ex.Message; } return(ConvertToJSON(Response)); }
public async Task <HttpResponseMessage> AddAttachment() { MT_Knowledger_Base KCMD = GetImages(); Db = con.SurgeryCenterDb(KCMD.Slug); KnowledgeBaseResponse Response = new KnowledgeBaseResponse(); try { MT_Knowledger_Base KBase = new MT_Knowledger_Base(); List <KBAttachment> AttcList = new List <KBAttachment>(); Query Qty = Db.Collection("MT_Knowledger_Base").WhereEqualTo("KNB_Is_Deleted", false).WhereEqualTo("KNB_Is_Active", true).WhereEqualTo("KNB_Unique_ID", KCMD.KNB_Unique_ID); QuerySnapshot ObjQuerySnap = await Qty.GetSnapshotAsync(); if (ObjQuerySnap != null) { KBase = ObjQuerySnap.Documents[0].ConvertTo <MT_Knowledger_Base>(); if (KBase.KNB_Document != null) { foreach (KBAttachment kbatt in KBase.KNB_Document) { AttcList.Add(kbatt); } } } if (KCMD.KNB_Document != null) { foreach (KBAttachment kbatt in KCMD.KNB_Document) { kbatt.KBA_Unique_ID = con.GetUniqueKey(); kbatt.KBA_Create_Date = con.ConvertTimeZone(kbatt.KBA_TimeZone, Convert.ToDateTime(kbatt.KBA_Create_Date)); kbatt.KBA_Modify_Date = con.ConvertTimeZone(kbatt.KBA_TimeZone, Convert.ToDateTime(kbatt.KBA_Modify_Date)); AttcList.Add(kbatt); } } KCMD.KNB_Document = AttcList; Dictionary <string, object> initialData = new Dictionary <string, object> { { "KNB_Modify_Date", con.ConvertTimeZone(KCMD.KNB_TimeZone, Convert.ToDateTime(KCMD.KNB_Modify_Date)) }, { "KNB_Document", KCMD.KNB_Document }, }; DocumentReference docRef = Db.Collection("MT_Knowledger_Base").Document(KCMD.KNB_Unique_ID); WriteResult Result = await docRef.UpdateAsync(initialData); if (Result != null) { Response.Status = con.StatusSuccess; Response.Message = con.MessageSuccess; Response.Data = KCMD; } else { Response.Status = con.StatusNotInsert; Response.Message = con.MessageNotInsert; Response.Data = null; } } catch (Exception ex) { Response.Status = con.StatusFailed; Response.Message = con.MessageFailed + ", Exception : " + ex.Message; } return(ConvertToJSON(Response)); }
public async Task <HttpResponseMessage> AddSuggestion(MT_Knowledger_Base KCMD) { Db = con.SurgeryCenterDb(KCMD.Slug); Boolean IsExist = false; KnowledgeBaseResponse Response = new KnowledgeBaseResponse(); try { List <Suggestion> suggestion = new List <Suggestion>(); Query qry = Db.Collection("MT_Knowledger_Base").WhereEqualTo("KNB_Is_Deleted", false).WhereEqualTo("KNB_Is_Active", true).WhereEqualTo("KNB_Unique_ID", KCMD.KNB_Unique_ID); QuerySnapshot ObjQuerySnap = await qry.GetSnapshotAsync(); if (ObjQuerySnap != null) { MT_Knowledger_Base KB = ObjQuerySnap.Documents[0].ConvertTo <MT_Knowledger_Base>(); if (KB.KNB_Suggestions != null) { foreach (Suggestion sug in KB.KNB_Suggestions) { if (sug.SG_User_ID == KCMD.KNB_Suggestions[0].SG_User_ID) { sug.SG_Is_Useful = KCMD.KNB_Suggestions[0].SG_Is_Useful; sug.SG_User_ID = KCMD.KNB_Suggestions[0].SG_User_ID; suggestion.Add(sug); IsExist = true; } else { suggestion.Add(sug); } } } } if (KCMD.KNB_Suggestions != null && IsExist == false) { foreach (Suggestion sug in KCMD.KNB_Suggestions) { suggestion.Add(sug); } } Dictionary <string, object> initialData = new Dictionary <string, object> { { "KNB_Suggestions", suggestion }, { "KNB_Modify_Date", con.ConvertTimeZone(KCMD.KNB_TimeZone, Convert.ToDateTime(KCMD.KNB_Modify_Date)) }, { "KNB_TimeZone", KCMD.KNB_TimeZone } }; DocumentReference docRef = Db.Collection("MT_Knowledger_Base").Document(KCMD.KNB_Unique_ID); WriteResult Result = await docRef.UpdateAsync(initialData); if (Result != null) { Response.Status = con.StatusSuccess; Response.Message = con.MessageSuccess; Response.Data = KCMD; } else { Response.Status = con.StatusNotUpdate; Response.Message = con.MessageNotUpdate; Response.Data = null; } } catch (Exception ex) { Response.Status = con.StatusFailed; Response.Message = con.MessageFailed + ", Exception : " + ex.Message; } return(ConvertToJSON(Response)); }