public async Task <HttpResponseMessage> List(MT_Patient_Form_Data PFMD)
{
Db = con.SurgeryCenterDb(PFMD.Slug);
PatientFormResponse Response = new PatientFormResponse();
try
{
List <MT_Patient_Form_Data> patilist = new List <MT_Patient_Form_Data>();
Query ObjQuery = Db.Collection("MT_Patient_Form_Data").WhereEqualTo("PFD_Booking_ID", PFMD.PFD_Booking_ID);
QuerySnapshot ObjQuerySnap = await ObjQuery.GetSnapshotAsync();
if (ObjQuerySnap != null)
{
foreach (DocumentSnapshot Docsnapshot in ObjQuerySnap.Documents)
{
patilist.Add(Docsnapshot.ConvertTo <MT_Patient_Form_Data>());
}
Response.DataList = patilist;
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> GetFormData(MT_Patient_Form_Data PFMD)
{
Db = con.SurgeryCenterDb(PFMD.Slug);
PatientFormResponse Response = new PatientFormResponse();
try
{
MT_Patient_Form_Data PatientFormData = new MT_Patient_Form_Data();
Query ObjQuery = Db.Collection("MT_Patient_Form_Data").WhereEqualTo("PFD_Booking_ID", PFMD.PFD_Booking_ID).WhereEqualTo("PFD_Form_ID", PFMD.PFD_Form_ID);
QuerySnapshot ObjQuerySnap = await ObjQuery.GetSnapshotAsync();
if (ObjQuerySnap != null)
{
PatientFormData = ObjQuerySnap.Documents[0].ConvertTo <MT_Patient_Form_Data>();
Response.Data = PatientFormData;
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> Update(MT_Patient_Form_Data PFMD)
{
Db = con.SurgeryCenterDb(PFMD.Slug);
PatientFormResponse Response = new PatientFormResponse();
try
{
Dictionary <string, object> initialData = new Dictionary <string, object>
{
//{"PFD_TimeZone" , PFMD.PFD_TimeZone},
{ "PFD_Elements", PFMD.PFD_Elements },
//{"PFD_Modify_Date" , con.ConvertTimeZone(PFMD.PFD_TimeZone,Convert.ToDateTime(PFMD.PFD_Modify_Date))}
};
DocumentReference docRef = Db.Collection("MT_Patient_Form_Data").Document(PFMD.PFD_Unique_ID);
WriteResult Result = await docRef.UpdateAsync(initialData);
if (Result != null)
{
Response.Status = con.StatusSuccess;
Response.Message = con.MessageSuccess;
Response.Data = PFMD;
}
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_Patient_Form_Data PFMD)
{
Db = con.SurgeryCenterDb(PFMD.Slug);
PatientFormResponse Response = new PatientFormResponse();
try
{
UniqueID = con.GetUniqueKey();
PFMD.PFD_Unique_ID = UniqueID;
DocumentReference docRef = Db.Collection("MT_Patient_Form_Data").Document(UniqueID);
WriteResult Result = await docRef.SetAsync(PFMD);
if (Result != null)
{
MT_Patient_Booking BookingInfo = new MT_Patient_Booking();
MT_Staff_Members staffinfo = new MT_Staff_Members();
MT_System_EmailTemplates sysemail = new MT_System_EmailTemplates();
Query ObjQuery = Db.Collection("MT_Patient_Booking").WhereEqualTo("PB_Is_Active", true).WhereEqualTo("PB_Is_Deleted", false).WhereEqualTo("PB_Unique_ID", PFMD.PFD_Booking_ID);
QuerySnapshot ObjQuerySnap = await ObjQuery.GetSnapshotAsync();
if (ObjQuerySnap != null)
{
BookingInfo = ObjQuerySnap.Documents[0].ConvertTo <MT_Patient_Booking>();
ObjQuery = Db.Collection("MT_Staff_Members").WhereEqualTo("Staff_Is_Active", true).WhereEqualTo("Staff_Is_Deleted", false).WhereEqualTo("Staff_Unique_ID", BookingInfo.PB_Surgical_Procedure_Information.SPI_Surgeon_ID);
ObjQuerySnap = await ObjQuery.GetSnapshotAsync();
if (ObjQuerySnap != null)
{
staffinfo = ObjQuerySnap.Documents[0].ConvertTo <MT_Staff_Members>();
ObjQuery = Db.Collection("MT_System_EmailTemplates").WhereEqualTo("SET_Is_Active", true).WhereEqualTo("SET_Is_Deleted", false).WhereEqualTo("SET_Name", "Appointment Cancellation");
ObjQuerySnap = await ObjQuery.GetSnapshotAsync();
if (ObjQuerySnap != null)
{
sysemail = ObjQuerySnap.Documents[0].ConvertTo <MT_System_EmailTemplates>();
Email email = new Email();
if (sysemail.SET_Bcc != null && sysemail.SET_Bcc.Length > 0)
{
email.Bcc_Email = sysemail.SET_Bcc.ToList();
}
if (sysemail.SET_CC != null && sysemail.SET_CC.Length > 0)
{
email.Cc_Email = sysemail.SET_CC.ToList();
}
List <string> PatiEmail = new List <string>();
List <string> PatiName = new List <string>();
PatiEmail.Add(staffinfo.Staff_Email);
PatiName.Add(staffinfo.Staff_Name);
email.To_Email = PatiEmail;
email.To_Name = PatiName;
email.From_Name = sysemail.SET_From_Name;
email.From_Email = sysemail.SET_From_Email;
email.HtmlContent = (sysemail.SET_Header == null ? "" : sysemail.SET_Header)
+ "<br/>"
+ "<br/>"
+ sysemail.SET_Message.ToString().Replace("[FirstName]", BookingInfo.PB_Patient_Name)
.Replace("[Dr Name]", BookingInfo.PB_Surgical_Procedure_Information == null ? "" : BookingInfo.PB_Surgical_Procedure_Information.SPI_Surgeon_Name)
.Replace("[mm/dd/yy]", BookingInfo.PB_Booking_Date.ToString("mm/dd/yy"))
.Replace("[hr:mn]", BookingInfo.PB_Booking_Time.ToString())
.Replace("[FacilityName]", BookingInfo.PB_Booking_Surgery_Center_Name)
+ "<br/>"
+ "<br/>"
+ sysemail.SET_Footer.ToString().Replace("[FacilityName]", BookingInfo.PB_Booking_Surgery_Center_Name)
.Replace("[Email]", (BookingInfo.PB_Patient_Email == null ? "" : BookingInfo.PB_Patient_Email));
email.Subject = "[FirstName], your appointment has been cancelled".Replace("[FirstName]", BookingInfo.PB_Patient_Name);
//var message = await ObjEmailer.Send(email);
Response.Status = con.StatusSuccess;
Response.Message = con.MessageSuccess + " Email Status : " + "";
}
else
{
Response.Status = con.StatusSuccess;
Response.Message = con.MessageSuccess;
Response.Data = PFMD;
}
}
else
{
Response.Status = con.StatusSuccess;
Response.Message = con.MessageSuccess;
Response.Data = PFMD;
}
}
else
{
Response.Status = con.StatusSuccess;
Response.Message = con.MessageSuccess;
Response.Data = PFMD;
}
}
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));
}
