public async Task <HttpResponseMessage> GetInsurCompanyFilterWithName(MT_Insurance_Company ICMD)
{
Db = con.SurgeryCenterDb(ICMD.Slug);
InsurCompanyResponse Response = new InsurCompanyResponse();
try
{
List <MT_Insurance_Company> InsuranceList = new List <MT_Insurance_Company>();
Query docRef = Db.Collection("MT_Insurance_Company").WhereEqualTo("INC_Is_Deleted", false).OrderBy("INC_Company_Name").StartAt(ICMD.INC_Company_Name.ToUpper()).EndAt(ICMD.INC_Company_Name.ToUpper() + '\uf8ff');
QuerySnapshot ObjQuerySnap = await docRef.GetSnapshotAsync();
if (ObjQuerySnap != null)
{
foreach (DocumentSnapshot Docsnapshot in ObjQuerySnap.Documents)
{
InsuranceList.Add(Docsnapshot.ConvertTo <MT_Insurance_Company>());
}
Response.DataList = InsuranceList;
Response.Message = con.MessageSuccess;
Response.Status = con.StatusSuccess;
}
}
catch (Exception ex)
{
Response.Status = con.StatusFailed;
Response.Message = con.MessageFailed + ", Exception : " + ex.Message;
}
return(ConvertToJSON(Response));
}
public async Task <HttpResponseMessage> ListDD(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", false).WhereEqualTo("DOC_Is_Active", true).WhereEqualTo("DOC_Sub_Category", null).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));
}
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));
}
//[Authorize(Roles ="SAdmin")]
public async Task <HttpResponseMessage> GetPermission(MT_Role RMD)
{
Db = con.SurgeryCenterDb(RMD.Slug);
RoleResponse Response = new RoleResponse();
try
{
List <MT_Role> AnesList = new List <MT_Role>();
Query docRef = Db.Collection("MT_Role").WhereEqualTo("ROM_Is_Deleted", false).WhereEqualTo("ROM_Is_Active", true).WhereEqualTo("ROM_Surgery_Physician_Center_ID", RMD.ROM_Surgery_Physician_Center_ID).WhereEqualTo("ROM_Office_Type", RMD.ROM_Office_Type);
QuerySnapshot ObjQuerySnap = await docRef.GetSnapshotAsync();
if (ObjQuerySnap != null)
{
foreach (DocumentSnapshot Docsnapshot in ObjQuerySnap.Documents)
{
AnesList.Add(Docsnapshot.ConvertTo <MT_Role>());
}
Response.DataList = AnesList.OrderBy(o => o.ROM_Name).ToList();
}
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));
}
//[Authorize(Roles ="SAdmin")]
public async Task <HttpResponseMessage> GetFormFilterWithSurgeryPhysicianCenterID(MT_Forms FMD)
{
Db = con.SurgeryCenterDb(FMD.Slug);
FormsResponse Response = new FormsResponse();
try
{
List <MT_Forms> AnesList = new List <MT_Forms>();
Query docRef = Db.Collection("MT_Forms").WhereEqualTo("Form_Is_Deleted", false).WhereEqualTo("Form_Is_Active", true).WhereEqualTo("Form_Surgery_Physician_Id", FMD.Form_Surgery_Physician_Id);
QuerySnapshot ObjQuerySnap = await docRef.GetSnapshotAsync();
if (ObjQuerySnap != null)
{
foreach (DocumentSnapshot Docsnapshot in ObjQuerySnap.Documents)
{
AnesList.Add(Docsnapshot.ConvertTo <MT_Forms>());
}
Response.DataList = AnesList;
}
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));
}
//[Authorize(Roles ="SAdmin")]
public async Task <HttpResponseMessage> ListDD(MT_Specilities SCMD)
{
Db = con.SurgeryCenterDb(SCMD.Slug);
SpecilityResponse Response = new SpecilityResponse();
try
{
List <MT_Specilities> AnesList = new List <MT_Specilities>();
Query docRef = Db.Collection("MT_Specilities").WhereEqualTo("Spec_Is_Deleted", false).WhereEqualTo("Spec_Is_Active", true).OrderBy("Spec_Name");
QuerySnapshot ObjQuerySnap = await docRef.GetSnapshotAsync();
if (ObjQuerySnap != null)
{
foreach (DocumentSnapshot Docsnapshot in ObjQuerySnap.Documents)
{
AnesList.Add(Docsnapshot.ConvertTo <MT_Specilities>());
}
Response.DataList = AnesList.OrderBy(o => o.Spec_Name).ToList();
}
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> GetDeletedList(MT_Knowledger_Base KCMD)
{
Db = con.SurgeryCenterDb(KCMD.Slug);
KnowledgeBaseResponse Response = new KnowledgeBaseResponse();
try
{
List <MT_Knowledger_Base> List = new List <MT_Knowledger_Base>();
Query docRef = Db.Collection("MT_Knowledger_Base").WhereEqualTo("KNB_Is_Deleted", true).OrderBy("KNB_Category");
QuerySnapshot ObjQuerySnap = await docRef.GetSnapshotAsync();
if (ObjQuerySnap != null)
{
foreach (DocumentSnapshot Docsnapshot in ObjQuerySnap.Documents)
{
List.Add(Docsnapshot.ConvertTo <MT_Knowledger_Base>());
}
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));
}
//[Authorize(Roles ="SAdmin")]
public async Task <HttpResponseMessage> List()
{
//Db = con.SurgeryCenterDb(UMD.Project_ID);
UserResponse Response = new UserResponse();
try
{
List <MT_User> AnesList = new List <MT_User>();
CollectionReference docRef = con.Db().Collection("MT_User");
QuerySnapshot ObjQuerySnap = await docRef.GetSnapshotAsync();
if (ObjQuerySnap != null)
{
foreach (DocumentSnapshot Docsnapshot in ObjQuerySnap.Documents)
{
AnesList.Add(Docsnapshot.ConvertTo <MT_User>());
}
Response.DataList = AnesList.OrderBy(o => o.UM_User_Name).ToList();
}
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));
}
//[Authorize(Roles ="SAdmin")]
public async Task <HttpResponseMessage> GetProcedureFilterWithCategory(MT_Procedures PMD)
{
Db = con.SurgeryCenterDb(PMD.Slug);
ProcedureResponse Response = new ProcedureResponse();
try
{
List <MT_Procedures> AnesList = new List <MT_Procedures>();
Query docRef = Db.Collection("MT_Procedures").WhereEqualTo("Pro_Is_Deleted", false).WhereEqualTo("Pro_Is_Active", true).WhereEqualTo("Pro_Procedure_Code_Category", PMD.Pro_Procedure_Code_Category.ToUpper());
QuerySnapshot ObjQuerySnap = await docRef.GetSnapshotAsync();
if (ObjQuerySnap != null)
{
foreach (DocumentSnapshot Docsnapshot in ObjQuerySnap.Documents)
{
AnesList.Add(Docsnapshot.ConvertTo <MT_Procedures>());
}
Response.DataList = AnesList.OrderBy(o => o.Pro_Procedure_Code_Category).ThenBy(o => o.Pro_Name).ToList();
}
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));
}
//[Authorize(Roles ="SAdmin")]
public async Task <HttpResponseMessage> List(MT_ICD IMD)
{
Db = con.SurgeryCenterDb(IMD.Slug);
ICDResponse Response = new ICDResponse();
try
{
List <MT_ICD> AnesList = new List <MT_ICD>();
Query docRef = Db.Collection("MT_ICD").WhereEqualTo("ICD_Is_Deleted", false);
QuerySnapshot ObjQuerySnap = await docRef.GetSnapshotAsync();
if (ObjQuerySnap != null)
{
foreach (DocumentSnapshot Docsnapshot in ObjQuerySnap.Documents)
{
AnesList.Add(Docsnapshot.ConvertTo <MT_ICD>());
}
Response.DataList = AnesList.OrderBy(o => o.ICD_Procedure_Code_Category).ThenBy(o => o.ICD_ICD10_PCS_Code).ToList();
}
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));
}
//[Authorize(Roles ="SAdmin")]
public async Task <HttpResponseMessage> ListCreatedByAdmin(MT_Staff_Members SMD)
{
Db = con.SurgeryCenterDb(SMD.Slug);
StaffMResponse Response = new StaffMResponse();
try
{
List <MT_Staff_Members> AnesList = new List <MT_Staff_Members>();
MT_Staff_Members staff = new MT_Staff_Members();
Query docRef = Db.Collection("MT_Staff_Members").WhereEqualTo("Staff_Is_Deleted", false).WhereEqualTo("Staff_Is_Active", true).WhereEqualTo("Staff_Created_By", SMD.Staff_Created_By);
QuerySnapshot ObjQuerySnap = await docRef.GetSnapshotAsync();
if (ObjQuerySnap != null)
{
foreach (DocumentSnapshot Docsnapshot in ObjQuerySnap.Documents)
{
staff = Docsnapshot.ConvertTo <MT_Staff_Members>();
AnesList.Add(staff);
}
Response.DataList = AnesList.OrderBy(o => o.Staff_Name).ThenBy(o => o.Staff_Last_Name).ToList();
}
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));
}
//[Authorize(Roles ="SAdmin")]
public async Task <HttpResponseMessage> GetDeletedList(MT_Incident IMD)
{
Db = con.SurgeryCenterDb(IMD.Slug);
IncidentResponse Response = new IncidentResponse();
try
{
List <MT_Incident> AnesList = new List <MT_Incident>();
Query docRef = Db.Collection("MT_Incident").WhereEqualTo("Inci_Is_Deleted", true);
QuerySnapshot ObjQuerySnap = await docRef.GetSnapshotAsync();
if (ObjQuerySnap != null)
{
foreach (DocumentSnapshot Docsnapshot in ObjQuerySnap.Documents)
{
AnesList.Add(Docsnapshot.ConvertTo <MT_Incident>());
}
Response.DataList = AnesList.OrderBy(o => o.Inci_Name).ToList();
}
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));
}
//[Authorize(Roles ="SAdmin")]
public async Task <HttpResponseMessage> ListFilterWithAnesthesia(MT_Block BMD)
{
Db = con.SurgeryCenterDb(BMD.Slug);
BlockResponse Response = new BlockResponse();
try
{
List <MT_Block> AnesList = new List <MT_Block>();
Query docRef = Db.Collection("MT_Block").WhereEqualTo("Block_Anesthesia_Id", BMD.Block_Anesthesia_Id).WhereEqualTo("Block_Is_Deleted", false).OrderBy("Block_Name");
QuerySnapshot ObjQuerySnap = await docRef.GetSnapshotAsync();
if (ObjQuerySnap != null)
{
foreach (DocumentSnapshot Docsnapshot in ObjQuerySnap.Documents)
{
AnesList.Add(Docsnapshot.ConvertTo <MT_Block>());
}
Response.DataList = AnesList;
}
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));
}
//[Authorize(Roles ="SAdmin")]
public async Task <HttpResponseMessage> List(MT_Designation DMD)
{
Db = con.SurgeryCenterDb(DMD.Slug);
DesignationResponse Response = new DesignationResponse();
try
{
List <MT_Designation> AnesList = new List <MT_Designation>();
Query docRef = con.Db().Collection("MT_Designation").WhereEqualTo("Desi_Is_Deleted", false).WhereEqualTo("Desi_Created_By", DMD.Desi_Created_By);
QuerySnapshot ObjQuerySnap = await docRef.GetSnapshotAsync();
if (ObjQuerySnap != null)
{
foreach (DocumentSnapshot Docsnapshot in ObjQuerySnap.Documents)
{
AnesList.Add(Docsnapshot.ConvertTo <MT_Designation>());
}
Response.DataList = AnesList.OrderBy(o => o.Desi_Name).ToList();
}
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));
}
//[Authorize(Roles ="SAdmin")]
public async Task <HttpResponseMessage> GetListFilterWithGroup(string groupname)
{
RightResponse Response = new RightResponse();
try
{
MT_Right Equip = new MT_Right();
MT_User usr = new MT_User();
List <MT_Right> RightList = new List <MT_Right>();
Query docRef = Db.Collection("MT_Right").WhereEqualTo("RM_Is_Deleted", false).WhereEqualTo("RM_Category_Name", groupname);
QuerySnapshot ObjQuerySnap = await docRef.GetSnapshotAsync();
if (ObjQuerySnap != null)
{
foreach (DocumentSnapshot Docsnapshot in ObjQuerySnap.Documents)
{
RightList.Add(Docsnapshot.ConvertTo <MT_Right>());
}
Response.DataList = RightList.OrderBy(o => o.RM_Category_Name).ThenBy(o => o.RM_Page_Name).ToList();
}
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));
}
//[Authorize(Roles ="SAdmin")]
public async Task <HttpResponseMessage> GetGroupList()
{
RightResponse Response = new RightResponse();
try
{
List <string> grouplist = new List <string>();
Query docRef = Db.Collection("MT_Right").WhereEqualTo("RM_Is_Deleted", false);
QuerySnapshot ObjQuerySnap = await docRef.GetSnapshotAsync();
if (ObjQuerySnap != null)
{
foreach (DocumentSnapshot Docsnapshot in ObjQuerySnap.Documents)
{
if (!grouplist.Contains(Docsnapshot.ConvertTo <MT_Right>().RM_Category_Name))
{
grouplist.Add(Docsnapshot.ConvertTo <MT_Right>().RM_Category_Name);
}
}
}
var jObject = JsonConvert.SerializeObject(grouplist);
var response = Request.CreateResponse(HttpStatusCode.OK);
response.Content = new StringContent(jObject, Encoding.UTF8, "application/json");
return(response);
}
catch (Exception ex)
{
throw;
}
}
//[Authorize(Roles ="SAdmin")]
public async Task <HttpResponseMessage> GetCPTListFilterWithCode(MT_CPT CMD)
{
Db = con.SurgeryCenterDb(CMD.Slug);
CPTResponse Response = new CPTResponse();
try
{
List <MT_CPT> AnesList = new List <MT_CPT>();
Query docRef = Db.Collection("MT_CPT").WhereEqualTo("CPT_Is_Deleted", false).OrderBy("CPT_Code").StartAt(CMD.CPT_Code).EndAt(CMD.CPT_Code + '\uf8ff');
QuerySnapshot ObjQuerySnap = await docRef.GetSnapshotAsync();
if (ObjQuerySnap != null)
{
foreach (DocumentSnapshot Docsnapshot in ObjQuerySnap.Documents)
{
AnesList.Add(Docsnapshot.ConvertTo <MT_CPT>());
}
AnesList.OrderBy(o => o.CPT_Procedure_Code_Category).ToList();
Response.DataList = AnesList;
}
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));
}
//[Authorize(Roles ="SAdmin")]
public async Task <HttpResponseMessage> Select(MT_SurgicalProcedureInformationTemplates SPIT)
{
Db = con.SurgeryCenterDb(SPIT.Slug);
SPITemplateResponse Response = new SPITemplateResponse();
try
{
List <MT_SurgicalProcedureInformationTemplates> AnesList = new List <MT_SurgicalProcedureInformationTemplates>();
Query docRef = Db.Collection("MT_SurgicalProcedureInformationTemplates").WhereEqualTo("Temp_Is_Deleted", false).WhereEqualTo("Temp_Unique_ID", SPIT.Temp_Unique_ID);
QuerySnapshot ObjQuerySnap = await docRef.GetSnapshotAsync();
if (ObjQuerySnap != null)
{
foreach (DocumentSnapshot Docsnapshot in ObjQuerySnap.Documents)
{
AnesList.Add(Docsnapshot.ConvertTo <MT_SurgicalProcedureInformationTemplates>());
}
Response.DataList = AnesList;
}
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> 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));
}
//[Authorize(Roles ="SAdmin")]
public async Task <HttpResponseMessage> List(MT_Staff_Members SMD)
{
Db = con.SurgeryCenterDb(SMD.Slug);
StaffMResponse Response = new StaffMResponse();
try
{
List <MT_Staff_Members> AnesList = new List <MT_Staff_Members>();
MT_Staff_Members staff = new MT_Staff_Members();
Query docRef = Db.Collection("MT_Staff_Members").WhereEqualTo("Staff_Is_Deleted", false);
QuerySnapshot ObjQuerySnap = await docRef.GetSnapshotAsync();
if (ObjQuerySnap != null)
{
foreach (DocumentSnapshot Docsnapshot in ObjQuerySnap.Documents)
{
staff = Docsnapshot.ConvertTo <MT_Staff_Members>();
if (SMD.Staff_Surgery_Physician_Office_ID == "0")
{
if (staff.Staff_Created_By == "28bLAlDi21ab1a937541a6")
{
AnesList.Add(staff);
}
}
else if (staff.Staff_Surgery_Physician_Office_ID == SMD.Staff_Surgery_Physician_Office_ID)
{
if (staff.Staff_Created_By != "28bLAlDi21ab1a937541a6")
{
AnesList.Add(staff);
}
}
else
{
if (staff.Staff_Created_By != SMD.Staff_Surgery_Physician_Office_ID)
{
AnesList.Add(staff);
}
}
}
Response.DataList = AnesList.OrderBy(o => o.Staff_Name).ThenBy(o => o.Staff_Last_Name).ToList();
}
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));
}
//[Authorize(Roles ="SAdmin")]
public async Task <HttpResponseMessage> LoginAsync(MT_User Objuser)
{
//Db = con.SurgeryCenterDb(Objuser.Project_ID);
UserResponse Response = new UserResponse();
try
{
MT_User user = new MT_User();
Query colref = Db.Collection("MT_User").WhereEqualTo("UM_Is_Deleted", false).WhereEqualTo("UM_Is_Active", true);
QuerySnapshot ObjDocSnap = await colref.GetSnapshotAsync();
if (ObjDocSnap != null)
{
foreach (DocumentSnapshot Docsnapshot in ObjDocSnap.Documents)
{
user = Docsnapshot.ConvertTo <MT_User>();
if (user != null)
{
if ((user.UM_Email.ToLower() == Objuser.UM_Email.ToLower() || user.UM_PhoneNo == Objuser.UM_PhoneNo) && user.UM_Password == Objuser.UM_Password)
{
Response.Data = user;
Response.Status = con.StatusSuccess;
Response.Message = con.MessageSuccess;
}
}
else
{
Response.Data = null;
Response.Status = con.StatusSuccess;
Response.Message = con.MessageSuccess;
}
}
}
else
{
Response.Data = null;
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));
}
//[Authorize(Roles ="SAdmin")]
public async Task <HttpResponseMessage> TruncateUserMaster()
{
//Db = con.SurgeryCenterDb(UMD.Project_ID);
UserResponse Response = new UserResponse();
try
{
MT_User User = new MT_User();
CollectionReference docRef = Db.Collection("MT_User");
QuerySnapshot ObjQuerySnap = await docRef.GetSnapshotAsync();
if (ObjQuerySnap != null)
{
foreach (DocumentSnapshot Docsnapshot in ObjQuerySnap.Documents)
{
User = Docsnapshot.ConvertTo <MT_User>();
if (User.UM_Unique_ID != "28bLAlDi21ab1a937541a6")
{
DocumentReference DocRef = Db.Collection("MT_User").Document(User.UM_Unique_ID);
WriteResult Result = await DocRef.DeleteAsync();
if (Result != null)
{
Response.Status = con.StatusSuccess;
Response.Message = con.MessageSuccess;
Response.Data = null;
}
}
}
}
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));
}
//[Authorize(Roles ="SAdmin")]
public async Task <HttpResponseMessage> ListDD(MT_Pack Pck)
{
Db = con.SurgeryCenterDb(Pck.Slug);
PackResponse Response = new PackResponse();
try
{
List <MT_Pack> AnesList = new List <MT_Pack>();
Query docRef = Db.Collection("MT_Pack").WhereEqualTo("Pack_Is_Deleted", false).WhereEqualTo("Pack_Is_Active", true);
QuerySnapshot ObjQuerySnap = await docRef.GetSnapshotAsync();
if (ObjQuerySnap != null)
{
foreach (DocumentSnapshot Docsnapshot in ObjQuerySnap.Documents)
{
if (Pck.Pack_Surgery_Physician_Id != "28bLAlDi21ab1a937541a6")
{
if (Docsnapshot.ConvertTo <MT_Pack>().Pack_Surgery_Physician_Id == "28bLAlDi21ab1a937541a6" || Docsnapshot.ConvertTo <MT_Pack>().Pack_Surgery_Physician_Id == Pck.Pack_Surgery_Physician_Id || Docsnapshot.ConvertTo <MT_Pack>().Pack_Surgery_Physician_Id == Pck.Pack_SC_Id)
{
AnesList.Add(Docsnapshot.ConvertTo <MT_Pack>());
}
}
else
{
AnesList.Add(Docsnapshot.ConvertTo <MT_Pack>());
}
}
Response.DataList = AnesList.OrderBy(o => o.Pack_Name).ToList();
}
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));
}
//[Authorize(Roles ="SAdmin")]
public async Task <HttpResponseMessage> GetAlertListFilterWithSCPO(MT_Alert AMD)
{
Db = con.SurgeryCenterDb(AMD.Slug);
AlertResponse Response = new AlertResponse();
try
{
List <MT_Alert> AnesList = new List <MT_Alert>();
MT_Alert Alert = new MT_Alert();
Query docRef = Db.Collection("MT_Alert").WhereEqualTo("Alert_Is_Deleted", false).WhereEqualTo("Alert_Is_Active", true).OrderBy("Alert_Name");
QuerySnapshot ObjQuerySnap = await docRef.GetSnapshotAsync();
if (ObjQuerySnap != null)
{
foreach (DocumentSnapshot Docsnapshot in ObjQuerySnap.Documents)
{
Alert = Docsnapshot.ConvertTo <MT_Alert>();
if (AMD.Alert_Surgery_Physician_Id == Alert.Alert_Surgery_Physician_Id)
{
AnesList.Add(Alert);
}
else if (Alert.Alert_Surgery_Physician_Id == "0")
{
AnesList.Add(Alert);
}
}
Response.DataList = AnesList.OrderBy(o => o.Alert_Name).ToList();
}
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));
}