Esempio n. 1
0
        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));
        }
Esempio n. 2
0
        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));
        }
Esempio n. 3
0
        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));
        }