public JsonResult SaveGuarantorRating(string actionType, GuarantorRatingViewModel dataModel)
{
MSGReturnModel result = new MSGReturnModel();
result.RETURN_FLAG = false;
result.DESCRIPTION = Message_Type.parameter_Error.GetDescription();
try
{
MSGReturnModel resultSave = TickerRatingRepository.saveGuarantorRating(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 JsonResult GetGuarantorRatingData(string queryType, GuarantorRatingViewModel dataModel)
{
MSGReturnModel result = new MSGReturnModel();
result.RETURN_FLAG = false;
result.DESCRIPTION = Message_Type.not_Find_Any.GetDescription();
try
{
var queryData = TickerRatingRepository.getGuarantorRating(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 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);
}
public Tuple <bool, List <GuarantorRatingViewModel> > getGuarantorRating(string queryType, GuarantorRatingViewModel dataModel)
{
using (IFRS9DBEntities db = new IFRS9DBEntities())
{
var query = from q in db.Guarantor_Rating.AsNoTracking()
select q;
if (dataModel.Guarantor_Rating_ID.IsNullOrWhiteSpace() == false)
{
query = query.Where(x => x.Guarantor_Rating_ID.ToString() == dataModel.Guarantor_Rating_ID);
}
if (dataModel.Issuer.IsNullOrWhiteSpace() == false)
{
query = query.Where(x => x.Issuer == dataModel.Issuer);
}
if (dataModel.S_And_P.IsNullOrWhiteSpace() == false)
{
query = query.Where(x => x.S_And_P == dataModel.S_And_P);
}
if (dataModel.Moodys.IsNullOrWhiteSpace() == false)
{
query = query.Where(x => x.Moodys == dataModel.Moodys);
}
if (dataModel.Fitch.IsNullOrWhiteSpace() == false)
{
query = query.Where(x => x.Fitch == dataModel.Fitch);
}
if (dataModel.Fitch_TW.IsNullOrWhiteSpace() == false)
{
query = query.Where(x => x.Fitch_TW == dataModel.Fitch_TW);
}
if (dataModel.TRC.IsNullOrWhiteSpace() == false)
{
query = query.Where(x => x.TRC == dataModel.TRC);
}
bool item1 = true;
if (queryType != "ALL")
{
item1 = query.Any();
}
return(new Tuple <bool,
List <GuarantorRatingViewModel> >(
item1, query.AsEnumerable()
.Select(x => { return DbToGuarantorRatingModel(x); }).ToList()));
}
}
