public async Task <HttpResponseMessage> Select(MT_Virtual_Consultant_Booking VCMD) { Db = con.SurgeryCenterDb(VCMD.Slug); VCBookingResponse Response = new VCBookingResponse(); try { MT_Virtual_Consultant_Booking vc = new MT_Virtual_Consultant_Booking(); Query ObjQuery = Db.Collection("MT_Virtual_Consultant_Booking").WhereEqualTo("VCB_Is_Deleted", false).WhereEqualTo("VCB_Unique_ID", VCMD.VCB_Unique_ID); QuerySnapshot ObjQuerySnap = await ObjQuery.GetSnapshotAsync(); if (ObjQuerySnap != null) { vc = ObjQuerySnap.Documents[0].ConvertTo <MT_Virtual_Consultant_Booking>(); Response.Data = vc; Response.Status = con.StatusSuccess; Response.Message = con.MessageSuccess; } else { Response.Status = con.StatusDNE; Response.Message = con.MessageDNE; } } catch (Exception ex) { Response.Status = con.StatusFailed; Response.Message = con.MessageFailed + ", Exception : " + ex.Message; } return(ConvertToJSON(Response)); }
public async Task <HttpResponseMessage> DeleteAssignedNotification(MT_Virtual_Consultant_Booking VCMD) { Db = con.SurgeryCenterDb(VCMD.Slug); VCBookingResponse Response = new VCBookingResponse(); try { MT_Notifications Notification = new MT_Notifications(); MT_Virtual_Consultant_Booking Booking = new MT_Virtual_Consultant_Booking(); List <MT_Notifications> NotiList = new List <MT_Notifications>(); Query Qry = Db.Collection("MT_Virtual_Consultant_Booking").WhereEqualTo("VCB_Unique_ID", VCMD.VCB_Unique_ID).WhereEqualTo("VCB_Is_Deleted", false).WhereEqualTo("VCB_Is_Active", true); QuerySnapshot ObjQuerySnap = await Qry.GetSnapshotAsync(); if (ObjQuerySnap != null) { Booking = ObjQuerySnap.Documents[0].ConvertTo <MT_Virtual_Consultant_Booking>(); if (VCMD.VCB_Notifications_Array != null && Booking.VCB_Notifications != null) { foreach (MT_Notifications noti in Booking.VCB_Notifications) { if (VCMD.VCB_Notifications_Array.Contains <string>(noti.NFT_Unique_ID) == false) { NotiList.Add(noti); } } } } Dictionary <string, object> initialData = new Dictionary <string, object> { { "VCB_Modify_Date", con.ConvertTimeZone(VCMD.VCB_TimeZone, Convert.ToDateTime(VCMD.VCB_Modify_Date)) }, { "VCB_TimeZone", VCMD.VCB_TimeZone }, { "VCB_Notifications", NotiList } }; //Main section DocumentReference docRef = Db.Collection("MT_Virtual_Consultant_Booking").Document(VCMD.VCB_Unique_ID); WriteResult Result = await docRef.UpdateAsync(initialData); if (Result != null) { Response.Status = con.StatusSuccess; Response.Message = con.MessageSuccess; Response.Data = VCMD; } 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> VCListForPO(MT_Virtual_Consultant_Booking VCMD) { Db = con.SurgeryCenterDb(VCMD.Slug); VCBookingResponse Response = new VCBookingResponse(); try { List <MT_Virtual_Consultant_Booking> patilist = new List <MT_Virtual_Consultant_Booking>(); Query ObjQuery; if (VCMD.VCB_Booking_Physician_Office_ID == "0") { ObjQuery = Db.Collection("MT_Virtual_Consultant_Booking").WhereEqualTo("VCB_Is_Deleted", false); } else { ObjQuery = Db.Collection("MT_Virtual_Consultant_Booking").WhereEqualTo("VCB_Is_Deleted", false).WhereEqualTo("VCB_Booking_Physician_Office_ID", VCMD.VCB_Booking_Physician_Office_ID); } QuerySnapshot ObjQuerySnap = await ObjQuery.GetSnapshotAsync(); if (ObjQuerySnap != null) { foreach (DocumentSnapshot Docsnapshot in ObjQuerySnap.Documents) { if (VCMD.VCB_Booking_Physician_Office_ID != null) { if (Docsnapshot.ConvertTo <MT_Virtual_Consultant_Booking>().VCB_Status != "Draft" && Docsnapshot.ConvertTo <MT_Virtual_Consultant_Booking>().VCB_Status != "Cancelled" && Docsnapshot.ConvertTo <MT_Virtual_Consultant_Booking>().VCB_Status != "Complete") { patilist.Add(Docsnapshot.ConvertTo <MT_Virtual_Consultant_Booking>()); } } else if (VCMD.VCB_Booking_Physician_Office_ID == "0") { patilist.Add(Docsnapshot.ConvertTo <MT_Virtual_Consultant_Booking>()); } } Response.DataList = patilist.OrderBy(o => o.VCB_Booking_Date).ToList(); Response.Status = con.StatusSuccess; Response.Message = con.MessageSuccess; } else { Response.Status = con.StatusDNE; Response.Message = con.MessageDNE; } } catch (Exception ex) { Response.Status = con.StatusFailed; Response.Message = con.MessageFailed + ", Exception : " + ex.Message; } return(ConvertToJSON(Response)); }
public async Task <HttpResponseMessage> EditVCBooking(MT_Virtual_Consultant_Booking VCMD) { Db = con.SurgeryCenterDb(VCMD.Slug); VCBookingResponse Response = new VCBookingResponse(); try { MT_Virtual_Consultant_Booking booking = new MT_Virtual_Consultant_Booking(); Query Qty = Db.Collection("MT_Virtual_Consultant_Booking").WhereEqualTo("VCB_Unique_ID", VCMD.VCB_Unique_ID); QuerySnapshot ObjBooking = await Qty.GetSnapshotAsync(); if (ObjBooking != null) { booking = ObjBooking.Documents[0].ConvertTo <MT_Virtual_Consultant_Booking>(); Dictionary <string, object> initialData = new Dictionary <string, object> { { "VCB_Patient_Name", VCMD.VCB_Patient_Name }, { "VCB_Patient_Last_Name", VCMD.VCB_Patient_Last_Name }, { "VCB_Booking_Date", con.ConvertTimeZone(VCMD.VCB_TimeZone, Convert.ToDateTime(VCMD.VCB_Booking_Date)) }, { "VCB_Booking_Time", VCMD.VCB_Booking_Time }, { "VCB_Doctor_ID", VCMD.VCB_Doctor_ID }, { "VCB_Doctor_Name", VCMD.VCB_Doctor_Name }, { "VCB_Status", VCMD.VCB_Status }, { "VCB_Modify_Date", con.ConvertTimeZone(VCMD.VCB_TimeZone, Convert.ToDateTime(VCMD.VCB_Modify_Date)) }, { "VCB_TimeZone", VCMD.VCB_TimeZone }, }; //Main section DocumentReference docRef = Db.Collection("MT_Virtual_Consultant_Booking").Document(VCMD.VCB_Unique_ID); WriteResult Result = await docRef.UpdateAsync(initialData); if (Result != null) { Response.Status = con.StatusSuccess; Response.Message = con.MessageSuccess; Response.Data = VCMD; } 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> CreateAsync(MT_Virtual_Consultant_Booking VCMD) { Db = con.SurgeryCenterDb(VCMD.Slug); VCBookingResponse Response = new VCBookingResponse(); try { UniqueID = con.GetUniqueKey(); VCMD.VCB_Unique_ID = UniqueID; Query ObjQuery = Db.Collection("MT_Virtual_Consultant_Booking");//.WhereEqualTo("VCB_Surgery_Physician_Center_ID", VCMD.VCB_Surgery_Physician_Center_ID).WhereEqualTo("VCB_Office_Type", VCMD.VCB_Office_Type); QuerySnapshot ObjQuerySnap = await ObjQuery.GetSnapshotAsync(); if (ObjQuerySnap != null) { VCMD.VCB_Booking_No = "VCBN000" + ObjQuerySnap.Documents.Count + 1.ToString(); } else { VCMD.VCB_Booking_No = "VCBN000" + "1"; } VCMD.VCB_Booking_Date = con.ConvertTimeZone(VCMD.VCB_TimeZone, Convert.ToDateTime(VCMD.VCB_Booking_Date), 1); VCMD.VCB_Create_Date = con.ConvertTimeZone(VCMD.VCB_TimeZone, Convert.ToDateTime(VCMD.VCB_Create_Date)); VCMD.VCB_Modify_Date = con.ConvertTimeZone(VCMD.VCB_TimeZone, Convert.ToDateTime(VCMD.VCB_Modify_Date)); DocumentReference docRef = Db.Collection("MT_Virtual_Consultant_Booking").Document(UniqueID); WriteResult Result = await docRef.SetAsync(VCMD); if (Result != null) { Response.Status = con.StatusSuccess; Response.Message = con.MessageSuccess; Response.Data = VCMD; } 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> UpdateStatus(MT_Virtual_Consultant_Booking VCMD) { Db = con.SurgeryCenterDb(VCMD.Slug); VCBookingResponse Response = new VCBookingResponse(); try { Incident_Details InciDetails = new Incident_Details(); MT_Virtual_Consultant_Booking BookingInfo = new MT_Virtual_Consultant_Booking(); List <Reason> ApprovedList = new List <Reason>(); List <Reason> DraftList = new List <Reason>(); List <Reason> CompleteList = new List <Reason>(); List <Reason> CancelledList = new List <Reason>(); Query ObjQuery = Db.Collection("MT_Virtual_Consultant_Booking").WhereEqualTo("VCB_Unique_ID", VCMD.VCB_Unique_ID).WhereEqualTo("VCB_Is_Deleted", false); QuerySnapshot ObjQuerySnap = await ObjQuery.GetSnapshotAsync(); if (ObjQuerySnap != null) { Dictionary <string, object> initialData; BookingInfo = ObjQuerySnap.Documents[0].ConvertTo <MT_Virtual_Consultant_Booking>(); if (BookingInfo.VCB_Approved != null) { foreach (Reason RR in BookingInfo.VCB_Approved) { ApprovedList.Add(RR); } } if (VCMD.VCB_Approved != null) { foreach (Reason RR in VCMD.VCB_Approved) { RR.RR_Create_Date = con.ConvertTimeZone(RR.RR_TimeZone, Convert.ToDateTime(RR.RR_Create_Date)); ApprovedList.Add(RR); } } if (BookingInfo.VCB_Draft != null) { foreach (Reason RR in BookingInfo.VCB_Draft) { DraftList.Add(RR); } } if (VCMD.VCB_Draft != null) { foreach (Reason RR in VCMD.VCB_Draft) { RR.RR_Create_Date = con.ConvertTimeZone(RR.RR_TimeZone, Convert.ToDateTime(RR.RR_Create_Date)); DraftList.Add(RR); } } if (BookingInfo.VCB_Complete != null) { foreach (Reason RR in BookingInfo.VCB_Complete) { CompleteList.Add(RR); } } if (VCMD.VCB_Complete != null) { foreach (Reason RR in VCMD.VCB_Complete) { RR.RR_Create_Date = con.ConvertTimeZone(RR.RR_TimeZone, Convert.ToDateTime(RR.RR_Create_Date)); CompleteList.Add(RR); } } if (BookingInfo.VCB_Cancelled != null) { foreach (Reason RR in BookingInfo.VCB_Cancelled) { CancelledList.Add(RR); } } if (VCMD.VCB_Cancelled != null) { foreach (Reason RR in VCMD.VCB_Cancelled) { RR.RR_Create_Date = con.ConvertTimeZone(RR.RR_TimeZone, Convert.ToDateTime(RR.RR_Create_Date)); CancelledList.Add(RR); } } initialData = new Dictionary <string, object> { { "VCB_Modify_Date", con.ConvertTimeZone(VCMD.VCB_TimeZone, Convert.ToDateTime(VCMD.VCB_Modify_Date)) }, { "VCB_Cancelled", CancelledList }, { "VCB_Approved", ApprovedList }, { "VCB_Draft", DraftList }, { "VCB_Complete", CompleteList }, { "VCB_Status", VCMD.VCB_Status }, { "VCB_TimeZone", VCMD.VCB_TimeZone } }; DocumentReference docRef = Db.Collection("MT_Virtual_Consultant_Booking").Document(BookingInfo.VCB_Unique_ID); WriteResult Result = await docRef.UpdateAsync(initialData); if (Result != null) { Response.Status = con.StatusSuccess; Response.Message = con.MessageSuccess; Response.Data = VCMD; } else { Response.Status = con.StatusNotInsert; Response.Message = con.MessageNotInsert; Response.Data = null; } } else { Response.Status = con.StatusDNE; Response.Message = con.MessageDNE; } } catch (Exception ex) { Response.Status = con.StatusFailed; Response.Message = con.MessageFailed + ", Exception : " + ex.Message; } return(ConvertToJSON(Response)); }
public async Task <HttpResponseMessage> UploadDocuments() { MT_Virtual_Consultant_Booking VCMD = GetImages(); Db = con.SurgeryCenterDb(VCMD.Slug); VCBookingResponse Response = new VCBookingResponse(); try { List <Doc_Uploaded> DocList = new List <Doc_Uploaded>(); MT_Virtual_Consultant_Booking Booking = new MT_Virtual_Consultant_Booking(); Query ObjQuery = Db.Collection("MT_Virtual_Consultant_Booking").WhereEqualTo("VCB_Unique_ID", VCMD.VCB_Unique_ID);//.WhereEqualTo("VCB_Is_Deleted", false); QuerySnapshot ObjQuerySnap = await ObjQuery.GetSnapshotAsync(); if (ObjQuerySnap != null) { Booking = ObjQuerySnap.Documents[0].ConvertTo <MT_Virtual_Consultant_Booking>(); if (Booking.VCB_Doc_Uploaded_List != null) { foreach (Doc_Uploaded DU in Booking.VCB_Doc_Uploaded_List) { DocList.Add(DU); } } } if (VCMD.VCB_Doc_Uploaded_List != null) { foreach (Doc_Uploaded DU in VCMD.VCB_Doc_Uploaded_List) { DocList.Add(DU); } } Dictionary <string, object> initialData = new Dictionary <string, object> { { "VCB_TimeZone", VCMD.VCB_TimeZone }, { "VCB_Doc_Uploaded_List", DocList }, { "VCB_Modify_Date", con.ConvertTimeZone(VCMD.VCB_TimeZone, Convert.ToDateTime(VCMD.VCB_Modify_Date)) } }; DocumentReference docRef = Db.Collection("MT_Virtual_Consultant_Booking").Document(VCMD.VCB_Unique_ID); WriteResult Result = await docRef.UpdateAsync(initialData); if (Result != null) { Response.Status = con.StatusSuccess; Response.Message = con.MessageSuccess; Response.Data = VCMD; } 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> AddVCBooking(MT_Virtual_Consultant_Booking VCMD) { Db = con.SurgeryCenterDb(VCMD.Slug); VCBookingResponse Response = new VCBookingResponse(); try { //Main section UniqueID = con.GetUniqueKey(); VCMD.VCB_Unique_ID = UniqueID; List <Alerts> AlrtList = new List <Alerts>(); Query ObjQuery = Db.Collection("MT_Virtual_Consultant_Booking"); QuerySnapshot ObjQuerySnap = await ObjQuery.GetSnapshotAsync(); if (ObjQuerySnap != null) { VCMD.VCB_Booking_No = "VCBN000" + ObjQuerySnap.Documents.Count + 1.ToString(); } else { VCMD.VCB_Booking_No = "VCBN000" + "1"; } VCMD.VCB_Booking_Date = con.ConvertTimeZone("", Convert.ToDateTime(VCMD.VCB_Booking_Date), 1); VCMD.VCB_Create_Date = con.ConvertTimeZone(VCMD.VCB_TimeZone, Convert.ToDateTime(VCMD.VCB_Create_Date)); VCMD.VCB_Modify_Date = con.ConvertTimeZone(VCMD.VCB_TimeZone, Convert.ToDateTime(VCMD.VCB_Modify_Date)); ////VCMD.VCB_Is_Deleted = false; //Main section Edit if (VCMD.VCB_Approved != null) { foreach (Reason rea in VCMD.VCB_Approved) { rea.RR_Create_Date = con.ConvertTimeZone(rea.RR_TimeZone, Convert.ToDateTime(rea.RR_Create_Date)); } } if (VCMD.VCB_Draft != null) { foreach (Reason rea in VCMD.VCB_Draft) { rea.RR_Create_Date = con.ConvertTimeZone(rea.RR_TimeZone, Convert.ToDateTime(rea.RR_Create_Date)); } } if (VCMD.VCB_Complete != null) { foreach (Reason rea in VCMD.VCB_Complete) { rea.RR_Create_Date = con.ConvertTimeZone(rea.RR_TimeZone, Convert.ToDateTime(rea.RR_Create_Date)); } } if (VCMD.VCB_Cancelled != null) { foreach (Reason rea in VCMD.VCB_Cancelled) { rea.RR_Create_Date = con.ConvertTimeZone(rea.RR_TimeZone, Convert.ToDateTime(rea.RR_Create_Date)); } } DocumentReference docRef = Db.Collection("MT_Virtual_Consultant_Booking").Document(UniqueID); WriteResult Result = await docRef.SetAsync(VCMD); if (Result != null) { Response.Status = con.StatusSuccess; Response.Message = con.MessageSuccess; Response.Data = VCMD; } 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)); }