private BondRatingViewModel DbToBondRatingModel(Bond_Rating data)
{
return(new BondRatingViewModel()
{
Table_Name = "Bond_Rating",
Bond_Rating_ID = data.Bond_Rating_ID.ToString(),
Bond_Number = data.Bond_Number,
S_And_P = data.S_And_P,
Moodys = data.Moodys,
Fitch = data.Fitch,
Fitch_TW = data.Fitch_TW,
TRC = data.TRC
});
}
public MSGReturnModel saveBondRating(string actionType, BondRatingViewModel dataModel)
{
MSGReturnModel result = new MSGReturnModel();
using (IFRS9DBEntities db = new IFRS9DBEntities())
{
try
{
if (actionType == "Add")
{
if (db.Bond_Rating.AsNoTracking()
.Where(x => x.Bond_Number == dataModel.Bond_Number)
.Count() > 0)
{
result.RETURN_FLAG = false;
result.DESCRIPTION = string.Format("資料重複：{0} 已存在", dataModel.Bond_Number);
return(result);
}
Bond_Rating addData = new Bond_Rating();
addData.Bond_Number = dataModel.Bond_Number;
addData.S_And_P = dataModel.S_And_P;
addData.Moodys = dataModel.Moodys;
addData.Fitch = dataModel.Fitch;
addData.Fitch_TW = dataModel.Fitch_TW;
addData.TRC = dataModel.TRC;
addData.Create_User = _UserInfo._user;
addData.Create_Time = _UserInfo._time;
addData.Create_Date = _UserInfo._date;
db.Bond_Rating.Add(addData);
}
else if (actionType == "Modify")
{
Bond_Rating oldData = db.Bond_Rating
.Where(x => x.Bond_Number == dataModel.Bond_Number)
.FirstOrDefault();
oldData.S_And_P = dataModel.S_And_P;
oldData.Moodys = dataModel.Moodys;
oldData.Fitch = dataModel.Fitch;
oldData.Fitch_TW = dataModel.Fitch_TW;
oldData.TRC = dataModel.TRC;
oldData.LastUpdate_User = _UserInfo._user;
oldData.LastUpdate_Date = _UserInfo._date;
oldData.LastUpdate_Time = _UserInfo._time;
}
db.SaveChanges();
result.RETURN_FLAG = true;
}
catch (DbUpdateException ex)
{
result.RETURN_FLAG = false;
result.DESCRIPTION = ex.Message;
}
}
return(result);
}
