public JsonResult DeleteB06(B06ViewModel dataModel) { MSGReturnModel result = new MSGReturnModel(); result.RETURN_FLAG = false; result.DESCRIPTION = Message_Type.parameter_Error.GetDescription(); try { MSGReturnModel resultDelete = B0Repository.deleteB06(dataModel); result.RETURN_FLAG = resultDelete.RETURN_FLAG; result.DESCRIPTION = Message_Type.delete_Success.GetDescription(); if (!result.RETURN_FLAG) { result.DESCRIPTION = resultDelete.DESCRIPTION; } } catch (Exception ex) { result.RETURN_FLAG = false; result.DESCRIPTION = ex.Message; } return(Json(result)); }
public JsonResult GetB06Data(B06ViewModel dataModel) { MSGReturnModel result = new MSGReturnModel(); result.RETURN_FLAG = false; result.DESCRIPTION = Message_Type.not_Find_Any.GetDescription(); try { var queryResult = B0Repository.getB06(dataModel); result.RETURN_FLAG = queryResult.Item1; Cache.Invalidate(CacheList.B06DbfileData); //清除 Cache.Set(CacheList.B06DbfileData, queryResult.Item2); //把資料存到 Cache if (!result.RETURN_FLAG) { result.DESCRIPTION = Message_Type.not_Find_Any.GetDescription(); } } catch (Exception ex) { result.RETURN_FLAG = false; result.DESCRIPTION = ex.Message; } return(Json(result)); }
public MSGReturnModel deleteB06(B06ViewModel dataModel) { MSGReturnModel result = new MSGReturnModel(); using (IFRS9DBEntities db = new IFRS9DBEntities()) { try { DateTime processingDate = DateTime.Parse(dataModel.Processing_Date); var query = db.IFRS9_Foward_Looking_Parm .Where(x => x.Processing_Date == processingDate && x.Product_Code == dataModel.Product_Code && x.PRJID == dataModel.PRJID && x.FLOWID == dataModel.FLOWID && x.CompID == dataModel.CompID); db.IFRS9_Foward_Looking_Parm.RemoveRange(query); db.SaveChanges(); result.RETURN_FLAG = true; } catch (Exception ex) { result.RETURN_FLAG = false; result.DESCRIPTION = ex.Message; } } return(result); }
public MSGReturnModel saveB06(string actionType, B06ViewModel dataModel) { MSGReturnModel result = new MSGReturnModel(); using (IFRS9DBEntities db = new IFRS9DBEntities()) { try { IFRS9_Foward_Looking_Parm editData = new IFRS9_Foward_Looking_Parm(); if (actionType == "Add") { dataModel.Processing_Date = DateTime.Now.ToString("yyyy/MM/dd"); DateTime processingDate = DateTime.Parse(dataModel.Processing_Date); List <IFRS9_Foward_Looking_Parm> Datas = db.IFRS9_Foward_Looking_Parm.AsNoTracking().ToList(); if (Datas .Where(x => x.Processing_Date == processingDate && x.Product_Code == dataModel.Product_Code && x.PRJID == "無" && x.FLOWID == "無" && x.CompID == "無") .Any() == true) { result.RETURN_FLAG = false; result.DESCRIPTION = $"資料重複:資料處理日期={dataModel.Processing_Date} 的資料 已存在"; return(result); } editData.CPD_Segment_Code = ""; editData.Delta_Q = double.Parse(dataModel.Delta_Q); editData.Processing_Date = processingDate; editData.Product_Code = dataModel.Product_Code; editData.PRJID = "無"; editData.FLOWID = "無"; editData.CompID = "無"; } else if (actionType == "Modify") { } if (actionType == "Add") { db.IFRS9_Foward_Looking_Parm.Add(editData); } db.SaveChanges(); result.RETURN_FLAG = true; } catch (Exception ex) { result.RETURN_FLAG = false; result.DESCRIPTION = ex.Message; } } return(result); }
public Tuple <bool, List <B06ViewModel> > getB06(B06ViewModel dataModel) { using (IFRS9DBEntities db = new IFRS9DBEntities()) { if (db.IFRS9_Foward_Looking_Parm.Any()) { var query = from q in db.IFRS9_Foward_Looking_Parm.AsNoTracking() select q; if (dataModel.Processing_Date.IsNullOrWhiteSpace() == false) { DateTime processingDate = DateTime.Parse(dataModel.Processing_Date); query = query.Where(x => x.Processing_Date >= processingDate); } if (!dataModel.to.IsNullOrWhiteSpace()) { DateTime to = DateTime.Parse(dataModel.to); query = query.Where(x => x.Processing_Date <= to); } query = query.Where(x => x.Product_Code == dataModel.Product_Code, dataModel.Product_Code.IsNullOrWhiteSpace() == false); query = query.Where(x => x.PRJID == dataModel.PRJID, dataModel.PRJID.IsNullOrWhiteSpace() == false); query = query.Where(x => x.FLOWID == dataModel.FLOWID, dataModel.FLOWID.IsNullOrWhiteSpace() == false); query = query.Where(x => x.CompID == dataModel.CompID, dataModel.CompID.IsNullOrWhiteSpace() == false); return(new Tuple <bool, List <B06ViewModel> >(query.Any(), query.AsEnumerable() .Select(x => { return DbToB06Model(x); }).ToList())); } } return(new Tuple <bool, List <B06ViewModel> >(false, new List <B06ViewModel>())); }
public Tuple <bool, List <B06ViewModel> > getB06All(B06ViewModel dataModel) { using (IFRS9DBEntities db = new IFRS9DBEntities()) { if (db.IFRS9_Foward_Looking_Parm.Any()) { return(new Tuple <bool, List <B06ViewModel> > ( true, ( from q in db.IFRS9_Foward_Looking_Parm.AsNoTracking().Where(x => x.Product_Code == dataModel.Product_Code) .AsEnumerable() select DbToB06Model(q) ).ToList() )); } } return(new Tuple <bool, List <B06ViewModel> >(true, new List <B06ViewModel>())); }