private TrackingEntry readEntry(MySqlDataReader reader) { TrackingEntry currentEntry = new TrackingEntry(); currentEntry.entryID = reader.GetInt32(0); currentEntry.taggerID = reader.GetInt32(1); currentEntry.type = reader.GetChar(2); currentEntry.isTagged = reader.GetBoolean(3); currentEntry.taggerName = reader.GetString(4); currentEntry.entryDate = ((DateTime)reader.GetMySqlDateTime(5)).ToString("yyyy-MM-dd HH:mm:ss"); if (reader.IsDBNull(6)) currentEntry.tagNumber = -1; else currentEntry.tagNumber = reader.GetInt32(6); currentEntry.species = reader.GetString(7); if (reader.IsDBNull(8)) currentEntry.city = ""; else currentEntry.city = reader.GetString(8); if (reader.IsDBNull(9)) currentEntry.state = ""; else currentEntry.state = reader.GetString(9); if (reader.IsDBNull(10)) currentEntry.country = ""; else currentEntry.country = reader.GetString(10); if (reader.IsDBNull(11)) currentEntry.longitude = ""; else currentEntry.longitude = reader.GetString(11); if (reader.IsDBNull(12)) currentEntry.latitude = ""; else currentEntry.latitude = reader.GetString(12); if (reader.IsDBNull(13)) currentEntry.temperature = ""; else currentEntry.temperature = reader.GetString(13); if (reader.IsDBNull(14)) currentEntry.precipitation = ""; else currentEntry.precipitation = reader.GetString(14); if (reader.IsDBNull(15)) currentEntry.windSpeed = ""; else currentEntry.windSpeed = reader.GetString(15); if (reader.IsDBNull(16)) currentEntry.windDirection = ""; else currentEntry.windDirection = reader.GetString(16); return currentEntry; }
private Employee constructEmployee(MySqlDataReader staffReader) { Employee newEmployee = new Employee(); newEmployee.NINo = staffReader.GetString("National_Insurance_Number"); newEmployee.FirstName = staffReader.GetString("First_Name"); newEmployee.LastName = staffReader.GetString("Last_Name"); newEmployee.Position = staffReader.GetString("Position"); newEmployee.Gender = staffReader.GetChar("Gender"); newEmployee.DateStarted = staffReader.GetDateTime("Date_Started"); newEmployee.DateFinished = SafeGetDateTime(staffReader, "Date_Finished"); newEmployee.PVGDate = staffReader.GetDateTime("PVG_Date"); newEmployee.HolidaysEntitled = staffReader.GetInt16("Holidays_Entitled"); newEmployee.HolidaysTaken = staffReader.GetInt16("Holidays_Taken"); newEmployee.WeeksHours = staffReader.GetInt16("Hours"); newEmployee.Address = constructAddress(staffReader); newEmployee.DOB = staffReader.GetDateTime("DOB"); newEmployee.Salary = staffReader.GetDecimal("Salary"); newEmployee.HomePhone = staffReader.GetString("Home_Phone"); newEmployee.MobilePhone = staffReader.GetString("Mobile_Phone"); newEmployee.Email = staffReader.GetString("Email"); newEmployee.Training = SafeGetString(staffReader, "Training"); newEmployee.Medical = constructMedical(staffReader); //EC... return newEmployee; }
private Parent constructParent(MySqlDataReader parentReader) { Parent newParent = new Parent(); newParent.ParentID = parentReader.GetInt32("Parent_ID"); newParent.FirstName = parentReader.GetString("First_Name"); newParent.LastName = parentReader.GetString("Last_Name"); newParent.Title = parentReader.GetString("Title"); newParent.Gender = parentReader.GetChar("Gender"); newParent.HomePhone = parentReader.GetString("Home_Phone"); newParent.WorkPhone = parentReader.GetString("Work_Phone"); newParent.MobilePhone = parentReader.GetString("Mobile_Phone"); newParent.HomeAddress = constructMultipleAddress(parentReader, "home"); newParent.WorkAddress = constructMultipleAddress(parentReader, "work"); //newParent.Spouse = childReader.GetInt16(10); newParent.Email = SafeGetString(parentReader, "Email"); //Neglecting list of children? return newParent; }
private EmergencyContact constructEmergencyContact(MySqlDataReader ECReader) { EmergencyContact newEC = new EmergencyContact(); newEC.ContactID = ECReader.GetInt32("Contact_ID"); newEC.Title = ECReader.GetString("Title"); newEC.FirstName = ECReader.GetString("First_Name"); newEC.LastName = ECReader.GetString("Last_Name"); newEC.Relationship = ECReader.GetString("Relationship"); newEC.HomePhone = ECReader.GetString("Home_Phone"); newEC.WorkPhone = ECReader.GetString("Work_Phone"); newEC.MobilePhone = ECReader.GetString("Mobile_Phone"); newEC.HomeAddress = constructMultipleAddress(ECReader, "home"); newEC.WorkAddress = constructMultipleAddress(ECReader, "work"); newEC.Gender = ECReader.GetChar("Gender"); newEC.Email = ECReader.GetString("Email"); return newEC; }
private Child constructChild(MySqlDataReader childrenReader) { Child newChild = new Child(); newChild.ChildID = childrenReader.GetInt32("Child_Id"); newChild.FirstName = childrenReader.GetString("First_Name"); newChild.LastName = childrenReader.GetString("Last_Name"); newChild.Gender = childrenReader.GetChar("Gender"); newChild.DOB = childrenReader.GetDateTime("DOB"); newChild.FirstLanguage = childrenReader.GetString("First_Language"); newChild.RoomAttending = childrenReader.GetString("Room_Attending"); //newChild.Sibling = SafeGetInt(childrenReader, "Sibling"); newChild.DateApplied = childrenReader.GetDateTime("Date_Applied"); newChild.DateLeft = SafeGetDateTime(childrenReader, "Date_Left"); newChild.Attendance = constructAttendance(childrenReader); newChild.ExtraDays = childrenReader.GetInt16("Extra_Days"); newChild.Teas = childrenReader.GetInt16("Teas"); newChild.MedicalInfo = constructMedical(childrenReader); //newChild.ParentsIDs.Add(childrenReader.GetInt16(16)); //newChild.EmergencyContactsIDs.Add(childrenReader.GetInt16(16)); //Get parents //foreach (int parentID in selectChildsParentIDs(newChild.ChildID)) // newChild.Parents.Add(constructParent(childrenReader, 16)); ////Get Emergency Contacts //foreach (int contactID in selectChildsContactIDs(newChild.ChildID)) // newChild.EmergencyContacts.Add(selectEmergencyContact(contactID), 30); return newChild; }
private void LoadLine(MySqlDataReader rdr) { string temp = ""; if(!rdr.IsDBNull(0)) { line_no = rdr.GetInt32(0); ORDER_ARRAY[rowCount, CONST_LINE_NO] = line_no.ToString(); } if (!rdr.IsDBNull(1)) { part_id = rdr.GetString(1); ORDER_ARRAY[rowCount, CONST_PARTID] = part_id; } if (!rdr.IsDBNull(2)) { desc = rdr.GetString(2); ORDER_ARRAY[rowCount, CONST_DESC] = desc; } if (!rdr.IsDBNull(3)) { ordered_qty = rdr.GetInt32(3); ORDER_ARRAY[rowCount, CONST_ORDERED] = ordered_qty.ToString(); } if (!rdr.IsDBNull(4)) { unit_price = rdr.GetFloat(4); ORDER_ARRAY[rowCount, CONST_PRICE] = unit_price.ToString(); } if (!rdr.IsDBNull(5)) { mod = rdr.GetChar(5); ORDER_ARRAY[rowCount, CONST_MOD] = mod.ToString(); } if (!rdr.IsDBNull(6)) { gst = Math.Round(rdr.GetDouble(6), 2); ORDER_ARRAY[rowCount, CONST_GST] = gst.ToString(); } if (!rdr.IsDBNull(7)) { pst = Math.Round(rdr.GetDouble(7), 2); ORDER_ARRAY[rowCount, CONST_PST] = pst.ToString(); } if (!rdr.IsDBNull(8)) { notes = rdr.GetString(8); ORDER_ARRAY[rowCount, CONST_NOTES] = notes; } bool cust = false; if (mod == 'C') cust = true; DataGridViewCheckBoxColumn checkColumn = new DataGridViewCheckBoxColumn(); checkColumn.Name = "X"; checkColumn.HeaderText = "X"; checkColumn.Width = 50; checkColumn.ReadOnly = false; checkColumn.FillWeight = 10; //if the datagridview is resized (on form resize) the checkbox won't take up too much; value is relative to the other columns' fill values dgOrderForm.Rows.Add(line_no.ToString(), cust, part_id, "", desc, ordered_qty.ToString(), unit_price.ToString(), gst.ToString(), pst.ToString(), notes); MAX_LINE = Convert.ToInt32(line_no); }
private static List<Object> DescomponerPersona(MySqlDataReader personaBD) { List<Object> listaPersona = new List<Object>(); while (personaBD.Read()) { listaPersona.Add(personaBD.GetInt32(0)); listaPersona.Add(personaBD.GetString(1)); listaPersona.Add(personaBD.GetString(2)); listaPersona.Add(personaBD.GetString(3)); if (personaBD.IsDBNull(4)) { listaPersona.Add(null); } else { listaPersona.Add(personaBD.GetInt32(4)); } listaPersona.Add(personaBD.GetChar(5)); } return listaPersona; }
private static List<Object> DescomponerPersonas(MySqlDataReader personaBD) { List<Object> listaPersona = new List<Object>(); while (personaBD.Read()) { Persona persona = new Persona(); persona.IdPersona = personaBD.GetInt32(0); persona.NombreCompleto = personaBD.GetString(1); persona.ApellidoPaterno = personaBD.GetString(2); if (personaBD.IsDBNull(3)) { persona.ApellidoMaterno = ""; } else { persona.ApellidoMaterno = personaBD.GetString(3); } if (personaBD.IsDBNull(5)) { persona.Sexo = ' '; } else { persona.Sexo = personaBD.GetChar(5); } listaPersona.Add(persona); } return listaPersona; }