public JsonResult SaveGuarantorTicker(string actionType, GuarantorTickerViewModel dataModel) { MSGReturnModel result = new MSGReturnModel(); result.RETURN_FLAG = false; result.DESCRIPTION = Message_Type.parameter_Error.GetDescription(); try { MSGReturnModel resultSave = TickerRatingRepository.saveGuarantorTicker(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 MSGReturnModel saveGuarantorTicker(string actionType, GuarantorTickerViewModel dataModel) { MSGReturnModel result = new MSGReturnModel(); using (IFRS9DBEntities db = new IFRS9DBEntities()) { try { if (actionType == "Add") { if (db.Guarantor_Ticker.AsNoTracking() .Where(x => x.Issuer == dataModel.Issuer) .Count() > 0) { result.RETURN_FLAG = false; result.DESCRIPTION = string.Format("資料重複:{0} 已存在", dataModel.Issuer); return(result); } Guarantor_Ticker addData = new Guarantor_Ticker(); addData.Issuer = dataModel.Issuer; addData.GUARANTOR_NAME = dataModel.GUARANTOR_NAME; addData.GUARANTOR_EQY_TICKER = dataModel.GUARANTOR_EQY_TICKER; addData.Create_User = _UserInfo._user; addData.Create_Date = _UserInfo._date; addData.Create_Time = _UserInfo._time; db.Guarantor_Ticker.Add(addData); } else if (actionType == "Modify") { Guarantor_Ticker oldData = db.Guarantor_Ticker .Where(x => x.Issuer == dataModel.Issuer) .FirstOrDefault(); oldData.GUARANTOR_NAME = dataModel.GUARANTOR_NAME; oldData.GUARANTOR_EQY_TICKER = dataModel.GUARANTOR_EQY_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); }
public JsonResult GetGuarantorTickerData(string queryType, GuarantorTickerViewModel dataModel) { MSGReturnModel result = new MSGReturnModel(); result.RETURN_FLAG = false; result.DESCRIPTION = Message_Type.not_Find_Any.GetDescription(); try { var queryData = TickerRatingRepository.getGuarantorTicker(queryType, dataModel); result.RETURN_FLAG = queryData.Item1; result.Datas = Json(queryData.Item2); } catch (Exception ex) { result.RETURN_FLAG = false; result.DESCRIPTION = ex.Message; } return(Json(result)); }
public Tuple <bool, List <GuarantorTickerViewModel> > getGuarantorTicker(string queryType, GuarantorTickerViewModel dataModel) { using (IFRS9DBEntities db = new IFRS9DBEntities()) { var query = from q in db.Guarantor_Ticker.AsNoTracking() select q; if (dataModel.Guarantor_Ticker_ID.IsNullOrWhiteSpace() == false) { query = query.Where(x => x.Guarantor_Ticker_ID.ToString() == dataModel.Guarantor_Ticker_ID); } if (dataModel.Issuer.IsNullOrWhiteSpace() == false) { query = query.Where(x => x.Issuer == dataModel.Issuer); } if (dataModel.GUARANTOR_NAME.IsNullOrWhiteSpace() == false) { query = query.Where(x => x.GUARANTOR_NAME == dataModel.GUARANTOR_NAME); } if (dataModel.GUARANTOR_EQY_TICKER.IsNullOrWhiteSpace() == false) { query = query.Where(x => x.GUARANTOR_EQY_TICKER == dataModel.GUARANTOR_EQY_TICKER); } bool item1 = true; if (queryType != "ALL") { item1 = query.Any(); } return(new Tuple <bool, List <GuarantorTickerViewModel> >( item1, query.AsEnumerable() .Select(x => { return DbToGuarantorTickerModel(x); }).ToList())); } }