private IssuerTickerViewModel DbToIssuerTickerModel(Issuer_Ticker data) { return(new IssuerTickerViewModel() { Table_Name = "Issuer_Ticker", Issuer_Ticker_ID = data.Issuer_Ticker_ID.ToString(), Issuer = data.Issuer, ISSUER_EQUITY_TICKER = data.ISSUER_EQUITY_TICKER }); }
public MSGReturnModel saveIssuerTicker(string actionType, IssuerTickerViewModel dataModel) { MSGReturnModel result = new MSGReturnModel(); using (IFRS9DBEntities db = new IFRS9DBEntities()) { try { if (actionType == "Add") { if (db.Issuer_Ticker.AsNoTracking() .Where(x => x.Issuer == dataModel.Issuer) .Count() > 0) { result.RETURN_FLAG = false; result.DESCRIPTION = string.Format("資料重複:{0} 已存在", dataModel.Issuer); return(result); } Issuer_Ticker addData = new Issuer_Ticker(); addData.Issuer = dataModel.Issuer; addData.ISSUER_EQUITY_TICKER = dataModel.ISSUER_EQUITY_TICKER; addData.Create_User = _UserInfo._user; addData.Create_Time = _UserInfo._time; addData.Create_Date = _UserInfo._date; db.Issuer_Ticker.Add(addData); } else if (actionType == "Modify") { Issuer_Ticker oldData = db.Issuer_Ticker .Where(x => x.Issuer == dataModel.Issuer) .FirstOrDefault(); oldData.ISSUER_EQUITY_TICKER = dataModel.ISSUER_EQUITY_TICKER; 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); }