public async Task <HttpResponseMessage> GetDeletedList(MT_KBCategory KCMD) { Db = con.SurgeryCenterDb(KCMD.Slug); KBCategoryResponse Response = new KBCategoryResponse(); try { List <MT_KBCategory> List = new List <MT_KBCategory>(); Query docRef = Db.Collection("MT_KBCategory").WhereEqualTo("KBC_Is_Deleted", true).OrderBy("KBC_Category"); QuerySnapshot ObjQuerySnap = await docRef.GetSnapshotAsync(); if (ObjQuerySnap != null) { foreach (DocumentSnapshot Docsnapshot in ObjQuerySnap.Documents) { List.Add(Docsnapshot.ConvertTo <MT_KBCategory>()); } 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_KBCategory KCMD) { Db = con.SurgeryCenterDb(KCMD.Slug); KBCategoryResponse Response = new KBCategoryResponse(); try { List <string> List = new List <string>(); Dictionary <string, object> initialData = new Dictionary <string, object> { { "KBC_Sub_Category", KCMD.KBC_Sub_Category }, { "KBC_Category", KCMD.KBC_Category }, { "KBC_Description", KCMD.KBC_Description }, { "KBC_Modify_Date", con.ConvertTimeZone(KCMD.KBC_TimeZone, Convert.ToDateTime(KCMD.KBC_Modify_Date)) }, { "KBC_TimeZone", KCMD.KBC_TimeZone } }; DocumentReference docRef = Db.Collection("MT_KBCategory").Document(KCMD.KBC_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_KBCategory KCMD) { Db = con.SurgeryCenterDb(KCMD.Slug); KBCategoryResponse Response = new KBCategoryResponse(); try { List <string> List = new List <string>(); UniqueID = con.GetUniqueKey(); KCMD.KBC_Unique_ID = UniqueID; KCMD.KBC_Create_Date = con.ConvertTimeZone(KCMD.KBC_TimeZone, Convert.ToDateTime(KCMD.KBC_Create_Date)); KCMD.KBC_Modify_Date = con.ConvertTimeZone(KCMD.KBC_TimeZone, Convert.ToDateTime(KCMD.KBC_Modify_Date)); DocumentReference docRef = Db.Collection("MT_KBCategory").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)); }