public MSGReturnModel saveB06(string actionType, B06ViewModel dataModel)
{
MSGReturnModel result = new MSGReturnModel();
using (IFRS9DBEntities db = new IFRS9DBEntities())
{
try
{
IFRS9_Foward_Looking_Parm editData = new IFRS9_Foward_Looking_Parm();
if (actionType == "Add")
{
dataModel.Processing_Date = DateTime.Now.ToString("yyyy/MM/dd");
DateTime processingDate = DateTime.Parse(dataModel.Processing_Date);
List <IFRS9_Foward_Looking_Parm> Datas = db.IFRS9_Foward_Looking_Parm.AsNoTracking().ToList();
if (Datas
.Where(x => x.Processing_Date == processingDate &&
x.Product_Code == dataModel.Product_Code &&
x.PRJID == "無" &&
x.FLOWID == "無" &&
x.CompID == "無")
.Any() == true)
{
result.RETURN_FLAG = false;
result.DESCRIPTION = $"資料重複：資料處理日期={dataModel.Processing_Date} 的資料 已存在";
return(result);
}
editData.CPD_Segment_Code = "";
editData.Delta_Q = double.Parse(dataModel.Delta_Q);
editData.Processing_Date = processingDate;
editData.Product_Code = dataModel.Product_Code;
editData.PRJID = "無";
editData.FLOWID = "無";
editData.CompID = "無";
}
else if (actionType == "Modify")
{
}
if (actionType == "Add")
{
db.IFRS9_Foward_Looking_Parm.Add(editData);
}
db.SaveChanges();
result.RETURN_FLAG = true;
}
catch (Exception ex)
{
result.RETURN_FLAG = false;
result.DESCRIPTION = ex.Message;
}
}
return(result);
}
private B06ViewModel DbToB06Model(IFRS9_Foward_Looking_Parm data)
{
return(new B06ViewModel()
{
CPD_Segment_Code = data.CPD_Segment_Code,
Delta_Q = data.Delta_Q.ToString(),
Processing_Date = data.Processing_Date.ToString("yyyy/MM/dd"),
Product_Code = data.Product_Code,
PRJID = data.PRJID,
FLOWID = data.FLOWID,
CompID = data.CompID
});
}
