private GuarantorRatingViewModel DbToGuarantorRatingModel(Guarantor_Rating data) { return(new GuarantorRatingViewModel() { Table_Name = "Guarantor_Rating", Guarantor_Rating_ID = data.Guarantor_Rating_ID.ToString(), Issuer = data.Issuer, S_And_P = data.S_And_P, Moodys = data.Moodys, Fitch = data.Fitch, Fitch_TW = data.Fitch_TW, TRC = data.TRC }); }
public MSGReturnModel saveGuarantorRating(string actionType, GuarantorRatingViewModel dataModel) { MSGReturnModel result = new MSGReturnModel(); using (IFRS9DBEntities db = new IFRS9DBEntities()) { try { if (actionType == "Add") { if (db.Guarantor_Rating.AsNoTracking() .Where(x => x.Issuer == dataModel.Issuer) .Count() > 0) { result.RETURN_FLAG = false; result.DESCRIPTION = string.Format("資料重複:{0} 已存在", dataModel.Issuer); return(result); } Guarantor_Rating addData = new Guarantor_Rating(); addData.Issuer = dataModel.Issuer; 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_Date = _UserInfo._date; addData.Create_Time = _UserInfo._time; db.Guarantor_Rating.Add(addData); } else if (actionType == "Modify") { Guarantor_Rating oldData = db.Guarantor_Rating .Where(x => x.Issuer == dataModel.Issuer) .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); }