public List <AssignmentTableModel> GetDeletedRecordByPID(string PID) { AssignmentTableModel request = new AssignmentTableModel(); using (IDbConnection connection = new SqlConnection(GlobalConfig.ConnString(db))) { var p = new DynamicParameters(); p.Add("@PID", PID, DbType.String, ParameterDirection.Input); List <AssignmentTableModel> output = connection.Query <AssignmentTableModel>("dbo.spDeletedRequest_GetByPID", p, commandType: CommandType.StoredProcedure).ToList(); return(output); } }
public frmAssignment() { InitializeComponent(); pnlCompletion.Visible = false; GV.ASSIGNMENTFORM = this; dataLoading = true; switch (GV.MODE) { case Mode.New: assignment = new AssignmentTableModel(); break; case Mode.SearchFieldRequest: populateFEList(); List <FieldSearchModel> searchList = collectSearchTerms(); break; default: break; } }