public ReturnValueInfo InsertRecord_Sqlite(ProjectMaterialReg_pmr_Info reasonInfo) { using (DBContext uow = DBContext.Begin()) { try { ReturnValueInfo rvInfo = new ReturnValueInfo(); object objRecord = uow.CurrentSession.Save(reasonInfo); rvInfo.boolValue = true; return rvInfo; } catch (Exception ex) { throw ex; } } }
public ProjectMaterialReg_pmr_Info SearchRecord_Sqlite(Guid iRecordID) { try { ProjectMaterialReg_pmr_Info searchInfo = new ProjectMaterialReg_pmr_Info(); searchInfo.pmr_RecordID = iRecordID; List<ProjectMaterialReg_pmr_Info> listRecord = SearchRecord_Sqlite(searchInfo); ProjectMaterialReg_pmr_Info psrdInfo = new ProjectMaterialReg_pmr_Info(); if (listRecord != null) { psrdInfo = listRecord.FirstOrDefault(); } else { psrdInfo = null; } return psrdInfo; } catch (Exception ex) { throw ex; } }
public List<ProjectMaterialReg_pmr_Info> SearchRecord_Sqlite(ProjectMaterialReg_pmr_Info searchInfo) { throw new NotImplementedException(); //try //{ // Dictionary<string, object> param = new Dictionary<string, object>(); // if (searchInfo != null) // { // if (searchInfo.pmr_RecordID != Guid.Empty) // { // param.Add("pmr_RecordID", searchInfo.pmr_RecordID); // } // if (searchInfo.pmr_SPLID != Guid.Empty) // { // param.Add("pmr_SPLID", searchInfo.pmr_SPLID); // } // } // IList<ProjectMaterialReg_pmr_Info> listRecord = this._projectMaterielDA_Sqlite.GetEntities<ProjectMaterialReg_pmr_Info>(param); // return listRecord.ToList(); //} //catch (Exception ex) //{ // throw ex; //} }