/// <summary> /// Load db data into memory /// </summary> /// <param name="obj"></param> /// <param name="reader"></param> private static void LoadObject(ClientDocumentSet obj, MySqlDataReader reader) { obj.UID = Convert.ToInt32(reader[FieldName.UID]); obj.FKClientUID = Convert.ToInt32(reader[FieldName.FKClientUID]); try { obj.Description = reader[FieldName.Description].ToString(); } catch { obj.Description = ""; } obj.Folder = reader[FieldName.Folder].ToString(); obj.FolderOnly = reader[FieldName.FolderOnly].ToString(); obj.StartDate = Convert.ToDateTime(reader[FieldName.StartDate].ToString()); obj.EndDate = Convert.ToDateTime(reader[FieldName.EndDate].ToString()); obj.ClientSetID = Convert.ToInt32(reader[FieldName.ClientSetID].ToString()); obj.SourceFolder = reader[FieldName.SourceFolder].ToString(); obj.Status = reader[FieldName.Status].ToString(); obj.IsVoid = reader[FieldName.IsVoid].ToString(); // Derived field obj.CombinedIDName = obj.FKClientUID + ";" + obj.ClientSetID + "; " + obj.Description + "; " + obj.Status; try { obj.UpdateDateTime = Convert.ToDateTime(reader[FieldName.UpdateDateTime].ToString()); } catch { obj.UpdateDateTime = DateTime.Now; } try { obj.CreationDateTime = Convert.ToDateTime(reader[FieldName.CreationDateTime].ToString()); } catch { obj.CreationDateTime = DateTime.Now; } try { obj.IsVoid = reader[FieldName.IsVoid].ToString(); } catch { obj.IsVoid = "N"; } try { obj.UserIdCreatedBy = reader[FieldName.UserIdCreatedBy].ToString(); } catch { obj.UserIdCreatedBy = "N"; } try { obj.UserIdUpdatedBy = reader[FieldName.UserIdCreatedBy].ToString(); } catch { obj.UserIdCreatedBy = "N"; } }
/// <summary> /// Return a list of document sets for a given client. /// </summary> /// <param name="iClientUID"></param> /// <param name="sortOrder"></param> /// <returns></returns> public static List <ClientDocumentSet> List(int iClientUID, string sortOrder = "DESC") { List <ClientDocumentSet> documentSetList = new List <ClientDocumentSet>(); // cds.FKClientUID + ";" + cds.ClientSetID + "; " + cds.Description + "; " +cds.Status // using (var connection = new MySqlConnection(ConnString.ConnectionString)) { var commandString = string.Format( " SELECT " + ClientDocumentSetFieldString() + " FROM ClientDocumentSet " + " WHERE FKClientUID = '{0}' " + " ORDER BY ClientSetID " + sortOrder , iClientUID); using (var command = new MySqlCommand( commandString, connection)) { connection.Open(); using (MySqlDataReader reader = command.ExecuteReader()) { while (reader.Read()) { ClientDocumentSet _clientDocumentSet = new ClientDocumentSet(); LoadObject(_clientDocumentSet, reader); documentSetList.Add(_clientDocumentSet); } } } } return(documentSetList); }
public ClientDocument() { clientDocumentSet = new ClientDocumentSet(); }