public ActionResult <string> Delete(string ORDER_NO)
{
Boolean isSuccess = true;
string data = "Delete success";
if (!String.IsNullOrEmpty(ORDER_NO))
{
String[] ORDER_NO_LIST = ORDER_NO.Replace("|SLASH|", "/").Split(",");
foreach (string ORDER_ITEM in ORDER_NO_LIST)
{
ORDER_LIST_MST delMstEntity = new ORDER_LIST_MST()
{
ORDER_NO = ORDER_ITEM
};
if (delMstEntity.Equals(null))
{
isSuccess = false;
data = "No such data.";
break;
}
else
{
// FIND ORDER DETAIL
/*
* int deteilNum = myContext.ORDER_LIST_DETAIL.Count(d => d.ORDER_NO == ORDER_ITEM);
* if (deteilNum > 0)
* {
* isSuccess = false;
* data = ORDER_ITEM + " has detail info.";
* break;
* }
*/
// FIND DB ITEM
myContext.ORDER_LIST_MST.Attach(delMstEntity);
// DELETE DB ITEM
myContext.ORDER_LIST_MST.Remove(delMstEntity);
// DELETE DETAIL ITEM
int deteilNum = myContext.ORDER_LIST_DETAIL.Count(d => d.ORDER_NO == ORDER_ITEM);
if (deteilNum > 0)
{
foreach (ORDER_LIST_DETAIL DetailEntity in myContext.ORDER_LIST_DETAIL.Where(d => d.ORDER_NO == ORDER_ITEM).ToList())
{
myContext.ORDER_LIST_DETAIL.Remove(DetailEntity);
}
}
// NEED TO CHECK DELETE RESULT HERE
if (true)
{
// SAVE CHANGES AND DO NOT RETURN
myContext.SaveChanges();
}
else
{
isSuccess = false;
data = "No such data.";
break;
}
}
}
}
else
{
isSuccess = false;
data = "No such data.";
}
JsonRes res = new JsonRes();
res.isSuccess = isSuccess;
res.data = data;
return(JsonConvert.SerializeObject(res));
}
