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); }