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> Count(MT_Insurance_Company ICMD)
{
Db = con.SurgeryCenterDb(ICMD.Slug);
InsurCompanyResponse Response = new InsurCompanyResponse();
try
{
UniqueID = con.GetUniqueKey();
Query docRef = Db.Collection("MT_Insurance_Company").WhereEqualTo("INC_Is_Deleted", false);
QuerySnapshot ObjQuerySnap = await docRef.GetSnapshotAsync();
if (ObjQuerySnap != null)
{
Response.Status = con.StatusSuccess;
Response.Message = con.MessageSuccess;
Response.Count = ObjQuerySnap.Documents.Count;
}
}
catch (Exception ex)
{
Response.Status = con.StatusFailed;
Response.Message = con.MessageFailed + ", Exception : " + ex.Message;
}
return(ConvertToJSON(Response));
}
public async Task <HttpResponseMessage> CreateAsync(MT_Insurance_Company ICMD)
{
Db = con.SurgeryCenterDb(ICMD.Slug);
InsurCompanyResponse Response = new InsurCompanyResponse();
try
{
List <MT_Insurance_Company> SpelitiesList = new List <MT_Insurance_Company>();
UniqueID = con.GetUniqueKey();
ICMD.INC_Unique_ID = UniqueID;
ICMD.INC_Create_Date = con.ConvertTimeZone(ICMD.INC_TimeZone, Convert.ToDateTime(ICMD.INC_Create_Date));
ICMD.INC_Modify_Date = con.ConvertTimeZone(ICMD.INC_TimeZone, Convert.ToDateTime(ICMD.INC_Modify_Date));
DocumentReference docRef = Db.Collection("MT_Insurance_Company").Document(UniqueID);
WriteResult Result = await docRef.SetAsync(ICMD);
if (Result != null)
{
Response.Status = con.StatusSuccess;
Response.Message = con.MessageSuccess;
Response.Data = ICMD;
}
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));
}
