public JsonResult AttachFrom(int docID, int winID, int tableID, int recID)
{
if (Session["ctx"] != null)
{
Ctx ctx = Session["ctx"] as Ctx;
string sql = "Select count(VADMS_WindowDocLink_ID) from VADMS_WindowDocLink where AD_Table_ID=" + tableID + " AND record_ID=" + recID + " AND AD_Window_ID=" + winID + " AND VADMS_Document_ID=" + docID;
if (Convert.ToInt32(DB.ExecuteScalar(sql)) > 0)
{
return(Json(JsonConvert.SerializeObject("NotSaved"), JsonRequestBehavior.AllowGet));
}
VAdvantage.Model.X_VADMS_WindowDocLink wlink = new VAdvantage.Model.X_VADMS_WindowDocLink(ctx, 0, null);
wlink.SetAD_Client_ID(ctx.GetAD_Client_ID());
wlink.SetAD_Org_ID(ctx.GetAD_Org_ID());
wlink.SetAD_Table_ID(tableID);
wlink.SetAD_Window_ID(winID);
wlink.SetRecord_ID(recID);
wlink.SetVADMS_Document_ID(docID);
if (wlink.Save())
{
return(Json(JsonConvert.SerializeObject("OK"), JsonRequestBehavior.AllowGet));
}
else
{
return(Json(JsonConvert.SerializeObject("NotSaved"), JsonRequestBehavior.AllowGet));
}
}
else
{
return(Json(JsonConvert.SerializeObject("SessionExpired"), JsonRequestBehavior.AllowGet));
}
}
public JsonResult AttachFrom(string docID, int winID, int tableID, int recID)
{
bool isSuccessFullAttach = false;
bool isAlreadyAttach = false;
if (Session["ctx"] != null)
{
string[] strDocIds = docID.Split(',');
string[] strMetaId = null;
if (strDocIds.Count() > 0)
{
for (int j = 0; j < strDocIds.Count(); j++)
{
strMetaId = strDocIds[j].Split('-');
Ctx ctx = Session["ctx"] as Ctx;
string sql1 = "Select count(dlink.VADMS_WindowDocLink_ID) FROM VADMS_WindowDocLink dlink INNER JOIN vadms_attachmetadata amd ON amd.VADMS_WindowDocLink_ID = dlink.VADMS_WindowDocLink_ID where dlink.AD_Table_ID=" + tableID + " AND dlink.record_ID=" + recID + " AND dlink.AD_Window_ID=" + winID + " AND dlink.VADMS_Document_ID=" + strMetaId[0] + " AND amd.VADMS_MetaData_ID=" + strMetaId[1];
int count = Convert.ToInt32(DB.ExecuteScalar(sql1));
if (count > 0)
{
return(Json(JsonConvert.SerializeObject("NotSaved"), JsonRequestBehavior.AllowGet));
}
string sql = "Select VADMS_WindowDocLink_ID from VADMS_WindowDocLink where AD_Table_ID=" + tableID + " AND record_ID=" + recID + " AND AD_Window_ID=" + winID + " AND VADMS_Document_ID=" + strMetaId[0];
int ID = Convert.ToInt32(DB.ExecuteScalar(sql));
if (ID > 0)
{
//return Json(JsonConvert.SerializeObject("NotSaved"), JsonRequestBehavior.AllowGet);
isAlreadyAttach = true;
}
VAdvantage.Model.X_VADMS_WindowDocLink wlink = null;
if (!isAlreadyAttach)
{
wlink = new VAdvantage.Model.X_VADMS_WindowDocLink(ctx, 0, null);
}
else
{
wlink = new VAdvantage.Model.X_VADMS_WindowDocLink(ctx, ID, null);
}
wlink.SetAD_Client_ID(ctx.GetAD_Client_ID());
wlink.SetAD_Org_ID(ctx.GetAD_Org_ID());
wlink.SetAD_Table_ID(tableID);
wlink.SetAD_Window_ID(winID);
wlink.SetRecord_ID(recID);
if (strDocIds[j].Trim() != string.Empty)
{
wlink.SetVADMS_Document_ID(Convert.ToInt32(strMetaId[0]));
}
if (wlink.Save())
{
X_VADMS_AttachMetaData objAttachMetaData = new X_VADMS_AttachMetaData(ctx, 0, null);
objAttachMetaData.SetVADMS_WindowDocLink_ID(wlink.Get_ID());
objAttachMetaData.SetVADMS_Document_ID(wlink.GetVADMS_Document_ID());
objAttachMetaData.SetVADMS_MetaData_ID(Convert.ToInt32(strMetaId[1]));
//objAttachMetaData.SetRecord_ID(wlink.GetRecord_ID());
if (objAttachMetaData.Save())
{
isSuccessFullAttach = true;
}
else
{
return(Json(JsonConvert.SerializeObject("NotSaved"), JsonRequestBehavior.AllowGet));
}
}
else
{
return(Json(JsonConvert.SerializeObject("NotSaved"), JsonRequestBehavior.AllowGet));
}
}
}
if (!isSuccessFullAttach)
{
return(Json(JsonConvert.SerializeObject("DocumentNotAttach"), JsonRequestBehavior.AllowGet));
}
else
{
return(Json(JsonConvert.SerializeObject("OK"), JsonRequestBehavior.AllowGet));
}
}
else
{
return(Json(JsonConvert.SerializeObject("SessionExpired"), JsonRequestBehavior.AllowGet));
}
}
