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));
}
public async Task <HttpResponseMessage> Select(MT_Knowledger_Base KCMD)
{
Db = con.SurgeryCenterDb(KCMD.Slug);
KnowledgeBaseResponse Response = new KnowledgeBaseResponse();
try
{
Query Qty = Db.Collection("MT_Knowledger_Base").WhereEqualTo("KNB_Is_Deleted", false).WhereEqualTo("KNB_Is_Active", true).WhereEqualTo("KNB_Unique_ID", KCMD.KNB_Unique_ID);
QuerySnapshot ObjQuerySnap = await Qty.GetSnapshotAsync();
if (ObjQuerySnap != null)
{
Response.Data = ObjQuerySnap.Documents[0].ConvertTo <MT_Knowledger_Base>();
Response.Message = con.MessageSuccess;
Response.Status = con.StatusSuccess;
}
else
{
Response.Message = con.MessageDNE;
Response.Status = con.StatusDNE;
}
}
catch (Exception ex)
{
Response.Status = con.StatusFailed;
Response.Message = con.MessageFailed + ", Exception : " + ex.Message;
}
return(ConvertToJSON(Response));
}
public HttpResponseMessage Upload()
{
KnowledgeBaseResponse Response = new KnowledgeBaseResponse();
string imageUrl = "";
try
{
var httpRequest = HttpContext.Current.Request;
if (httpRequest.Files.Count > 0)
{
foreach (string file in httpRequest.Files)
{
var postedFile = httpRequest.Files[file];
int hasheddate = DateTime.Now.GetHashCode();
string changed_name = DateTime.Now.ToString("yyyyMMddHHmmss") + postedFile.FileName.Substring(postedFile.FileName.IndexOf('.'), (postedFile.FileName.Length - postedFile.FileName.IndexOf('.')));
// imageUrl = await _imageUploader.UploadImage(postedFile, 10);
}
}
Response.Status = con.StatusSuccess;
Response.Message = "Path : " + imageUrl;
}
catch (Exception ex)
{
Response.Status = con.StatusFailed;
Response.Message = con.MessageFailed + ", Exception : " + ex.Message;
}
return(ConvertToJSON(Response));
}
public async Task <HttpResponseMessage> IsDeletedReference(MT_Knowledger_Base KCMD)
{
Db = con.SurgeryCenterDb(KCMD.Slug);
KnowledgeBaseResponse Response = new KnowledgeBaseResponse();
try
{
MT_Knowledger_Base KBase = new MT_Knowledger_Base();
List <KBReference> RefList = new List <KBReference>();
Query Qty = Db.Collection("MT_Knowledger_Base").WhereEqualTo("KNB_Is_Deleted", false).WhereEqualTo("KNB_Is_Active", true).WhereEqualTo("KNB_Unique_ID", KCMD.KNB_Unique_ID);
QuerySnapshot ObjQuerySnap = await Qty.GetSnapshotAsync();
if (ObjQuerySnap != null)
{
KBase = ObjQuerySnap.Documents[0].ConvertTo <MT_Knowledger_Base>();
if (KBase.KNB_References != null)
{
foreach (KBReference refe in KBase.KNB_References)
{
if (refe.KBR_Unique_ID != KCMD.KNB_References[0].KBR_Unique_ID)
{
RefList.Add(refe);
}
}
}
}
KCMD.KNB_Modify_Date = con.ConvertTimeZone(KCMD.KNB_TimeZone, Convert.ToDateTime(KCMD.KNB_Modify_Date));
KCMD.KNB_References = RefList;
Dictionary <string, object> initialData = new Dictionary <string, object>
{
{ "KNB_Modify_Date", con.ConvertTimeZone(KCMD.KNB_TimeZone, Convert.ToDateTime(KCMD.KNB_Modify_Date)) },
{ "KNB_References", KCMD.KNB_References },
};
DocumentReference docRef = Db.Collection("MT_Knowledger_Base").Document(KCMD.KNB_Unique_ID);
WriteResult Result = await docRef.UpdateAsync(initialData);
if (Result != null)
{
Response.Status = con.StatusSuccess;
Response.Message = con.MessageSuccess;
Response.Data = KCMD;
}
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> Update(MT_Knowledger_Base KCMD)
{
Db = con.SurgeryCenterDb(KCMD.Slug);
KnowledgeBaseResponse Response = new KnowledgeBaseResponse();
try
{
Dictionary <string, object> initialData = new Dictionary <string, object>
{
{ "KNB_Name", KCMD.KNB_Name },
{ "KNB_Category", KCMD.KNB_Category },
{ "KNB_Sub_Category", KCMD.KNB_Sub_Category },
{ "KNB_Short_Description", KCMD.KNB_Short_Description },
{ "KNB_Long_Description", KCMD.KNB_Long_Description },
{ "KNB_Modify_Date", con.ConvertTimeZone(KCMD.KNB_TimeZone, Convert.ToDateTime(KCMD.KNB_Modify_Date)) },
//{"KNB_Document", KCMD.KNB_Document},
//{"KNB_References", KCMD.KNB_References},
};
DocumentReference docRef = Db.Collection("MT_Knowledger_Base").Document(KCMD.KNB_Unique_ID);
WriteResult Result = await docRef.UpdateAsync(initialData);
if (Result != null)
{
Response.Status = con.StatusSuccess;
Response.Message = con.MessageSuccess;
Response.Data = KCMD;
}
else
{
Response.Status = con.StatusNotUpdate;
Response.Message = con.MessageNotUpdate;
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_Knowledger_Base KCMD)
{
Db = con.SurgeryCenterDb(KCMD.Slug);
KnowledgeBaseResponse Response = new KnowledgeBaseResponse();
try
{
List <string> List = new List <string>();
UniqueID = con.GetUniqueKey();
KCMD.KNB_Unique_ID = UniqueID;
KCMD.KNB_Create_Date = con.ConvertTimeZone(KCMD.KNB_TimeZone, Convert.ToDateTime(KCMD.KNB_Create_Date));
KCMD.KNB_Modify_Date = con.ConvertTimeZone(KCMD.KNB_TimeZone, Convert.ToDateTime(KCMD.KNB_Modify_Date));
DocumentReference docRef = Db.Collection("MT_Knowledger_Base").Document(UniqueID);
WriteResult Result = await docRef.SetAsync(KCMD);
if (Result != null)
{
Response.Status = con.StatusSuccess;
Response.Message = con.MessageSuccess;
Response.Data = KCMD;
}
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> AddAttachment()
{
MT_Knowledger_Base KCMD = GetImages();
Db = con.SurgeryCenterDb(KCMD.Slug);
KnowledgeBaseResponse Response = new KnowledgeBaseResponse();
try
{
MT_Knowledger_Base KBase = new MT_Knowledger_Base();
List <KBAttachment> AttcList = new List <KBAttachment>();
Query Qty = Db.Collection("MT_Knowledger_Base").WhereEqualTo("KNB_Is_Deleted", false).WhereEqualTo("KNB_Is_Active", true).WhereEqualTo("KNB_Unique_ID", KCMD.KNB_Unique_ID);
QuerySnapshot ObjQuerySnap = await Qty.GetSnapshotAsync();
if (ObjQuerySnap != null)
{
KBase = ObjQuerySnap.Documents[0].ConvertTo <MT_Knowledger_Base>();
if (KBase.KNB_Document != null)
{
foreach (KBAttachment kbatt in KBase.KNB_Document)
{
AttcList.Add(kbatt);
}
}
}
if (KCMD.KNB_Document != null)
{
foreach (KBAttachment kbatt in KCMD.KNB_Document)
{
kbatt.KBA_Unique_ID = con.GetUniqueKey();
kbatt.KBA_Create_Date = con.ConvertTimeZone(kbatt.KBA_TimeZone, Convert.ToDateTime(kbatt.KBA_Create_Date));
kbatt.KBA_Modify_Date = con.ConvertTimeZone(kbatt.KBA_TimeZone, Convert.ToDateTime(kbatt.KBA_Modify_Date));
AttcList.Add(kbatt);
}
}
KCMD.KNB_Document = AttcList;
Dictionary <string, object> initialData = new Dictionary <string, object>
{
{ "KNB_Modify_Date", con.ConvertTimeZone(KCMD.KNB_TimeZone, Convert.ToDateTime(KCMD.KNB_Modify_Date)) },
{ "KNB_Document", KCMD.KNB_Document },
};
DocumentReference docRef = Db.Collection("MT_Knowledger_Base").Document(KCMD.KNB_Unique_ID);
WriteResult Result = await docRef.UpdateAsync(initialData);
if (Result != null)
{
Response.Status = con.StatusSuccess;
Response.Message = con.MessageSuccess;
Response.Data = KCMD;
}
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> AddSuggestion(MT_Knowledger_Base KCMD)
{
Db = con.SurgeryCenterDb(KCMD.Slug);
Boolean IsExist = false;
KnowledgeBaseResponse Response = new KnowledgeBaseResponse();
try
{
List <Suggestion> suggestion = new List <Suggestion>();
Query qry = Db.Collection("MT_Knowledger_Base").WhereEqualTo("KNB_Is_Deleted", false).WhereEqualTo("KNB_Is_Active", true).WhereEqualTo("KNB_Unique_ID", KCMD.KNB_Unique_ID);
QuerySnapshot ObjQuerySnap = await qry.GetSnapshotAsync();
if (ObjQuerySnap != null)
{
MT_Knowledger_Base KB = ObjQuerySnap.Documents[0].ConvertTo <MT_Knowledger_Base>();
if (KB.KNB_Suggestions != null)
{
foreach (Suggestion sug in KB.KNB_Suggestions)
{
if (sug.SG_User_ID == KCMD.KNB_Suggestions[0].SG_User_ID)
{
sug.SG_Is_Useful = KCMD.KNB_Suggestions[0].SG_Is_Useful;
sug.SG_User_ID = KCMD.KNB_Suggestions[0].SG_User_ID;
suggestion.Add(sug);
IsExist = true;
}
else
{
suggestion.Add(sug);
}
}
}
}
if (KCMD.KNB_Suggestions != null && IsExist == false)
{
foreach (Suggestion sug in KCMD.KNB_Suggestions)
{
suggestion.Add(sug);
}
}
Dictionary <string, object> initialData = new Dictionary <string, object>
{
{ "KNB_Suggestions", suggestion },
{ "KNB_Modify_Date", con.ConvertTimeZone(KCMD.KNB_TimeZone, Convert.ToDateTime(KCMD.KNB_Modify_Date)) },
{ "KNB_TimeZone", KCMD.KNB_TimeZone }
};
DocumentReference docRef = Db.Collection("MT_Knowledger_Base").Document(KCMD.KNB_Unique_ID);
WriteResult Result = await docRef.UpdateAsync(initialData);
if (Result != null)
{
Response.Status = con.StatusSuccess;
Response.Message = con.MessageSuccess;
Response.Data = KCMD;
}
else
{
Response.Status = con.StatusNotUpdate;
Response.Message = con.MessageNotUpdate;
Response.Data = null;
}
}
catch (Exception ex)
{
Response.Status = con.StatusFailed;
Response.Message = con.MessageFailed + ", Exception : " + ex.Message;
}
return(ConvertToJSON(Response));
}
