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> 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> 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 MT_Virtual_Consultant_Booking GetImages()
{
MT_Virtual_Consultant_Booking Surcenter = new MT_Virtual_Consultant_Booking();
try
{
List <Doc_Uploaded> DocUplodList = new List <Doc_Uploaded>();
//string[] DBPath;
int i = 0;
var httpRequest = HttpContext.Current.Request;
var postedData = httpRequest.Form[1];
string str = postedData.Substring(1, postedData.Length - 2);
JObject jobject = JObject.Parse(str);
Surcenter = JsonConvert.DeserializeObject <MT_Virtual_Consultant_Booking>(jobject.ToString());
var Doclist = httpRequest.Form[0];
Dictionary <string, string> dict = JsonConvert.DeserializeObject <Dictionary <string, string> >(Doclist);
if (httpRequest.Files.Count > 0)
{
foreach (string file in httpRequest.Files)
{
var postedFile = httpRequest.Files[file];
int hasheddate = DateTime.Now.GetHashCode();
var myKey = dict.FirstOrDefault(x => x.Value == postedFile.FileName.ToString()).Key;
string changed_name = myKey + DateTime.Now.ToString("yyyyMMddHHmmss") + postedFile.FileName.Substring(postedFile.FileName.IndexOf('.'), (postedFile.FileName.Length - postedFile.FileName.IndexOf('.')));
var filePath = HttpContext.Current.Server.MapPath("~/Images/" + changed_name);
postedFile.SaveAs(filePath); // save the file to a folder "Images" in the root of your app
//changed_name = @"~\Images\" + changed_name; //store this complete path to database
Doc_Uploaded DocUpld = new Doc_Uploaded();
DocUpld.DU_Unique_ID = con.GetUniqueKey();
DocUpld.DU_Attachment_Type = myKey;
DocUpld.DU_Doc_Path = @"~\Images\" + changed_name;
DocUpld.DU_Doc_Name = changed_name.Substring(0, 10);
DocUpld.DU_Created_By = Surcenter.VCB_Created_By;
DocUpld.DU_User_Name = Surcenter.VCB_User_Name;
DocUpld.DU_Create_Date = con.ConvertTimeZone(Surcenter.VCB_TimeZone, Convert.ToDateTime(Surcenter.VCB_Modify_Date));
DocUpld.DU_Modify_Date = con.ConvertTimeZone(Surcenter.VCB_TimeZone, Convert.ToDateTime(Surcenter.VCB_Modify_Date));
DocUpld.DU_Is_Active = true;
DocUpld.DU_Is_Deleted = false;
DocUpld.DU_TimeZone = Surcenter.VCB_TimeZone;
DocUplodList.Add(DocUpld);
i++;
}
Surcenter.VCB_Doc_Uploaded_List = DocUplodList;
}
}
catch (Exception ex)
{
throw;
}
return(Surcenter);
}
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));
}