public JsonResult SaveA94(string actionType, A94ViewModel dataModel)
{
MSGReturnModel result = new MSGReturnModel();
result.RETURN_FLAG = false;
result.DESCRIPTION = Message_Type.parameter_Error.GetDescription();
try
{
MSGReturnModel resultSave = A9Repository.saveA94(actionType, dataModel);
result.RETURN_FLAG = resultSave.RETURN_FLAG;
result.DESCRIPTION = Message_Type.save_Success.GetDescription();
if (!result.RETURN_FLAG)
{
result.DESCRIPTION = Message_Type.save_Fail.GetDescription() + " " + resultSave.DESCRIPTION;
}
}
catch (Exception ex)
{
result.RETURN_FLAG = false;
result.DESCRIPTION = ex.Message;
}
return(Json(result));
}
public JsonResult GetA94Data(A94ViewModel dataModel)
{
MSGReturnModel result = new MSGReturnModel();
result.RETURN_FLAG = false;
result.DESCRIPTION = Message_Type.not_Find_Any.GetDescription();
try
{
var queryResult = A9Repository.getA94(dataModel);
result.RETURN_FLAG = queryResult.Item1;
Cache.Invalidate(CacheList.A94DbfileData); //清除
Cache.Set(CacheList.A94DbfileData, queryResult.Item2); //把資料存到 Cache
if (!result.RETURN_FLAG)
{
result.DESCRIPTION = Message_Type.not_Find_Any.GetDescription();
}
}
catch (Exception ex)
{
result.RETURN_FLAG = false;
result.DESCRIPTION = ex.Message;
}
return(Json(result));
}
public MSGReturnModel saveA94(string actionType, A94ViewModel dataModel)
{
MSGReturnModel result = new MSGReturnModel();
using (IFRS9DBEntities db = new IFRS9DBEntities())
{
try
{
Gov_Info_Ticker editData = new Gov_Info_Ticker();
if (actionType == "Add")
{
if (db.Gov_Info_Ticker.AsNoTracking()
.Where(x => x.Country == dataModel.Country)
.FirstOrDefault() != null)
{
result.RETURN_FLAG = false;
result.DESCRIPTION = "資料重複：您輸入的 國家 已存在";
return(result);
}
editData.Country = dataModel.Country;
}
else if (actionType == "Modify")
{
editData = db.Gov_Info_Ticker
.Where(x => x.Country == dataModel.Country)
.FirstOrDefault();
}
editData.IGS_Index_Map = dataModel.IGS_Index_Map;
editData.Short_term_Debt_Map = dataModel.Short_term_Debt_Map;
editData.Foreign_Exchange_Map = dataModel.Foreign_Exchange_Map;
editData.GDP_Yearly_Map = dataModel.GDP_Yearly_Map;
if (actionType == "Add")
{
db.Gov_Info_Ticker.Add(editData);
}
db.SaveChanges(); //Save
result.RETURN_FLAG = true;
}
catch (Exception ex)
{
result.RETURN_FLAG = false;
result.DESCRIPTION = ex.Message;
}
}
return(result);
}
public Tuple <bool, List <A94ViewModel> > getA94(A94ViewModel dataModel)
{
using (IFRS9DBEntities db = new IFRS9DBEntities())
{
if (db.Gov_Info_Ticker.Any())
{
var query = db.Gov_Info_Ticker.AsNoTracking()
.Where(x => x.Country == dataModel.Country, dataModel.Country.IsNullOrWhiteSpace() == false);
return(new Tuple <bool, List <A94ViewModel> >(query.Any(),
query.AsEnumerable().Select(x => { return DbToA94Model(x); }).ToList()));
}
}
return(new Tuple <bool, List <A94ViewModel> >(false, new List <A94ViewModel>()));
}
