public ReturnValueInfo DeleteRecord(ProjectStopReason_pjsr_Info reasonInfo) { ReturnValueInfo returnInfo = new ReturnValueInfo(false); if (reasonInfo != null) { try { using (MainDBDataContext db = new MainDBDataContext()) { ProjectStopReason_pjsr deleteData = db.ProjectStopReason_pjsr.FirstOrDefault(t => t.pjsr_RecordID == reasonInfo.pjsr_RecordID); if (deleteData != null) { db.ProjectStopReason_pjsr.DeleteOnSubmit(deleteData); db.SubmitChanges(); returnInfo.boolValue = true; } } } catch (Exception Ex) { returnInfo.messageText = Ex.Message; } } return returnInfo; }
public Model.General.ReturnValueInfo DeleteRecord(ProjectStopReason_pjsr_Info reasonInfo) { throw new NotImplementedException(); }
public ReturnValueInfo UpdateRecord_Sqlite(ProjectStopReason_pjsr_Info reasonInfo) { throw new NotImplementedException(); //try //{ // return this._IProjectStopReasonDA_Sqlite.Update(reasonInfo); //} //catch (Exception ex) //{ // throw ex; //} }
public List<ProjectStopReason_pjsr_Info> SearchRecord_Sqlite(ProjectStopReason_pjsr_Info searchInfo) { throw new NotImplementedException(); //try //{ // Dictionary<string, object> param = new Dictionary<string, object>(); // if (searchInfo.pjsr_RecordID != Guid.Empty) // { // param.Add("pjsr_RecordID", searchInfo.pjsr_RecordID); // } // if (searchInfo.pjsr_PSRDID != Guid.Empty) // { // param.Add("pjsr_PSRDID", searchInfo.pjsr_PSRDID); // } // if (searchInfo.pjsr_iSRMID != Common.DefineConstantValue.Int32DefaultValue) // { // param.Add("pjsr_iSRMID", searchInfo.pjsr_iSRMID); // } // if (searchInfo.pjsr_lSync) // { // param.Add("pjsr_lSync", searchInfo.pjsr_lSync); // } // IList<ProjectStopReason_pjsr_Info> listResonRecords = this._IProjectStopReasonDA_Sqlite.GetEntities<ProjectStopReason_pjsr_Info>(param); // return listResonRecords.ToList(); //} //catch (Exception ex) //{ // throw ex; //} }
public ProjectStopReason_pjsr_Info SearchRecord_Sqlite(Guid iRecordID) { try { ProjectStopReason_pjsr_Info searchInfo = new ProjectStopReason_pjsr_Info(); searchInfo.pjsr_RecordID = iRecordID; IList<ProjectStopReason_pjsr_Info> IPjsrList = SearchRecord_Sqlite(searchInfo); ProjectStopReason_pjsr_Info pjsrInfo = new ProjectStopReason_pjsr_Info(); if (IPjsrList != null) { pjsrInfo = IPjsrList.FirstOrDefault(); } else { pjsrInfo = null; } return pjsrInfo; } catch (Exception ex) { throw ex; } }
public ReturnValueInfo InsertRecord(ProjectStopReason_pjsr_Info reasonInfo) { ReturnValueInfo returnInfo = new ReturnValueInfo(false); if (reasonInfo != null) { try { using (MainDBDataContext db = new MainDBDataContext()) { ProjectStopReason_pjsr insertData = Common.General.CopyObjectValue<ProjectStopReason_pjsr_Info, ProjectStopReason_pjsr>(reasonInfo); db.ProjectStopReason_pjsr.InsertOnSubmit(insertData); db.SubmitChanges(); reasonInfo.pjsr_RecordID = insertData.pjsr_RecordID; returnInfo.boolValue = true; } } catch (Exception Ex) { returnInfo.messageText = Ex.Message; } } return returnInfo; }
public ReturnValueInfo UpdateRecord(ProjectStopReason_pjsr_Info reasonInfo) { ReturnValueInfo returnInfo = new ReturnValueInfo(false); if (reasonInfo != null) { try { using (MainDBDataContext db = new MainDBDataContext()) { ProjectStopReason_pjsr updateData = db.ProjectStopReason_pjsr.FirstOrDefault(t => t.pjsr_RecordID == reasonInfo.pjsr_RecordID); if (updateData != null) { updateData.pjsr_PSRDID = reasonInfo.pjsr_PSRDID; updateData.pjsr_iSRMID = reasonInfo.pjsr_iSRMID; updateData.pjsr_dLastDate = reasonInfo.pjsr_dLastDate; db.SubmitChanges(); returnInfo.boolValue = true; } } } catch (Exception Ex) { returnInfo.messageText = Ex.Message; } } return returnInfo; }
public List<ProjectStopReason_pjsr_Info> SearchRecords(ProjectStopReason_pjsr_Info searchCondition) { throw new NotImplementedException(); }