public async Task <HttpResponseMessage> GetDeletedList(MT_Document_Category DCMD) { Db = con.SurgeryCenterDb(DCMD.Slug); DocuCategoryResponse Response = new DocuCategoryResponse(); try { List <MT_Document_Category> List = new List <MT_Document_Category>(); Query docRef = Db.Collection("MT_Document_Category").WhereEqualTo("DOC_Is_Deleted", true).OrderBy("DOC_Category"); QuerySnapshot ObjQuerySnap = await docRef.GetSnapshotAsync(); if (ObjQuerySnap != null) { foreach (DocumentSnapshot Docsnapshot in ObjQuerySnap.Documents) { List.Add(Docsnapshot.ConvertTo <MT_Document_Category>()); } 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> Update(MT_Document_Category DCMD) { Db = con.SurgeryCenterDb(DCMD.Slug); DocuCategoryResponse Response = new DocuCategoryResponse(); try { List <string> List = new List <string>(); Dictionary <string, object> initialData = new Dictionary <string, object> { { "DOC_Sub_Category", DCMD.DOC_Sub_Category }, { "DOC_Category", DCMD.DOC_Category }, { "DOC_Description", DCMD.DOC_Description }, { "DOC_Modify_Date", con.ConvertTimeZone(DCMD.DOC_TimeZone, Convert.ToDateTime(DCMD.DOC_Modify_Date)) }, { "DOC_TimeZone", DCMD.DOC_TimeZone } }; DocumentReference docRef = Db.Collection("MT_Document_Category").Document(DCMD.DOC_Unique_ID); WriteResult Result = await docRef.UpdateAsync(initialData); if (Result != null) { Response.Status = con.StatusSuccess; Response.Message = con.MessageSuccess; Response.Data = DCMD; } 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_Document_Category DCMD) { Db = con.SurgeryCenterDb(DCMD.Slug); DocuCategoryResponse Response = new DocuCategoryResponse(); try { List <string> List = new List <string>(); UniqueID = con.GetUniqueKey(); DCMD.DOC_Unique_ID = UniqueID; DCMD.DOC_Create_Date = con.ConvertTimeZone(DCMD.DOC_TimeZone, Convert.ToDateTime(DCMD.DOC_Create_Date)); DCMD.DOC_Modify_Date = con.ConvertTimeZone(DCMD.DOC_TimeZone, Convert.ToDateTime(DCMD.DOC_Modify_Date)); DocumentReference docRef = Db.Collection("MT_Document_Category").Document(UniqueID); WriteResult Result = await docRef.SetAsync(DCMD); if (Result != null) { Response.Status = con.StatusSuccess; Response.Message = con.MessageSuccess; Response.Data = DCMD; } 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)); }