public ContactDO GetDataObject() { ContactDO data = new ContactDO() { ContactID = this.ContactID, ContactTypeID = this.ContactTypeID, PermitKey = this.PermitKey, ContactClassID = this.ContactClassID, SalutationID = this.SalutationID, FirstName = this.FirstName, LastName = this.LastName, CompanyName = this.CompanyName, OwnershipStatusID = this.OwnershipStatusID, OwnershipTypeID = this.OwnershipTypeID, Phone = this.Phone, PhoneExtension = this.PhoneExtension, Fax = this.Fax, Email = this.Email }; return data; }
public ContactDO WriteContactDataToTable() { ContactDO data = new ContactDO() { ContactID = this.ContactID, ContactTypeID = this.ContactTypeID, PermitKey = this.PermitKey, TaxID = this.TaxID, Title = this.Title, ContactClassID = this.ContactClassID, SalutationID = this.SalutationID, FirstName = this.FirstName, LastName = this.LastName, CompanyName = this.CompanyName, Phone = this.Phone, PhoneExtension = this.PhoneExtension, Fax = this.Fax, Email = this.Email, LegalEntityID = this.LegalEntityID, LegalStructureDescription = this.LegalStructureDescription, DateOfIncorporation = this.DateOfIncorporation, StateOfIncorporationID = this.StateOfIncorporationID, ResponsiblePartyForAbandonedMineReclamationFee = this.ResponsibleParty }; return data; }
/// <summary> /// Selects Contact records by PK /// </summary> public static ContactDO[] GetByPK(Int32 ContactID) { SqlParameter _ContactID = new SqlParameter("ContactID", SqlDbType.Int); _ContactID.Value = ContactID; SqlParameter[] _params = new SqlParameter[] { _ContactID }; string pid = ConfigurationManager.AppSettings["ePermitDAL"]; SafeReader sr = DataCommon.ExecuteSafeReader("[dbo].[Contact_GetByPK]", _params, pid); List<ContactDO> objs = new List<ContactDO>(); while(sr.Read()) { ContactDO obj = new ContactDO(); obj.ContactID = sr.GetInt32(sr.GetOrdinal("ContactID")); obj.ContactTypeID = sr.GetString(sr.GetOrdinal("ContactTypeID")); obj.PermitKey = sr.GetInt32(sr.GetOrdinal("PermitKey")); if (sr.IsDBNull(sr.GetOrdinal("SalutationID"))) { obj.SalutationID = null; } else { obj.SalutationID = sr.GetString(sr.GetOrdinal("SalutationID")); } if (sr.IsDBNull(sr.GetOrdinal("FirstName"))) { obj.FirstName = null; } else { obj.FirstName = sr.GetString(sr.GetOrdinal("FirstName")); } if (sr.IsDBNull(sr.GetOrdinal("LastName"))) { obj.LastName = null; } else { obj.LastName = sr.GetString(sr.GetOrdinal("LastName")); } if (sr.IsDBNull(sr.GetOrdinal("Title"))) { obj.Title = null; } else { obj.Title = sr.GetString(sr.GetOrdinal("Title")); } if (sr.IsDBNull(sr.GetOrdinal("CompanyName"))) { obj.CompanyName = null; } else { obj.CompanyName = sr.GetString(sr.GetOrdinal("CompanyName")); } if (sr.IsDBNull(sr.GetOrdinal("TaxID"))) { obj.TaxID = null; } else { obj.TaxID = sr.GetString(sr.GetOrdinal("TaxID")); } if (sr.IsDBNull(sr.GetOrdinal("Phone"))) { obj.Phone = null; } else { obj.Phone = sr.GetString(sr.GetOrdinal("Phone")); } if (sr.IsDBNull(sr.GetOrdinal("PhoneExtension"))) { obj.PhoneExtension = null; } else { obj.PhoneExtension = sr.GetString(sr.GetOrdinal("PhoneExtension")); } if (sr.IsDBNull(sr.GetOrdinal("CountryCode"))) { obj.CountryCode = null; } else { obj.CountryCode = sr.GetString(sr.GetOrdinal("CountryCode")); } if (sr.IsDBNull(sr.GetOrdinal("Fax"))) { obj.Fax = null; } else { obj.Fax = sr.GetString(sr.GetOrdinal("Fax")); } if (sr.IsDBNull(sr.GetOrdinal("Email"))) { obj.Email = null; } else { obj.Email = sr.GetString(sr.GetOrdinal("Email")); } if (sr.IsDBNull(sr.GetOrdinal("LegalEntityID"))) { obj.LegalEntityID = null; } else { obj.LegalEntityID = sr.GetString(sr.GetOrdinal("LegalEntityID")); } if (sr.IsDBNull(sr.GetOrdinal("OtherLegalEntityDescription"))) { obj.OtherLegalEntityDescription = null; } else { obj.OtherLegalEntityDescription = sr.GetString(sr.GetOrdinal("OtherLegalEntityDescription")); } if (sr.IsDBNull(sr.GetOrdinal("LegalStructureDescription"))) { obj.LegalStructureDescription = null; } else { obj.LegalStructureDescription = sr.GetString(sr.GetOrdinal("LegalStructureDescription")); } if (sr.IsDBNull(sr.GetOrdinal("DateOfIncorporation"))) { obj.DateOfIncorporation = null; } else { obj.DateOfIncorporation = sr.GetDateTime(sr.GetOrdinal("DateOfIncorporation")); } if (sr.IsDBNull(sr.GetOrdinal("StateOfIncorporationID"))) { obj.StateOfIncorporationID = null; } else { obj.StateOfIncorporationID = sr.GetString(sr.GetOrdinal("StateOfIncorporationID")); } if (sr.IsDBNull(sr.GetOrdinal("ResponsiblePartyForAbandonedMineReclamationFee"))) { obj.ResponsiblePartyForAbandonedMineReclamationFee = null; } else { obj.ResponsiblePartyForAbandonedMineReclamationFee = sr.GetString(sr.GetOrdinal("ResponsiblePartyForAbandonedMineReclamationFee")); } if (sr.IsDBNull(sr.GetOrdinal("OwnershipTypeID"))) { obj.OwnershipTypeID = null; } else { obj.OwnershipTypeID = sr.GetString(sr.GetOrdinal("OwnershipTypeID")); } if (sr.IsDBNull(sr.GetOrdinal("OwnershipStatusID"))) { obj.OwnershipStatusID = null; } else { obj.OwnershipStatusID = sr.GetString(sr.GetOrdinal("OwnershipStatusID")); } if (sr.IsDBNull(sr.GetOrdinal("DatePositionAssumed"))) { obj.DatePositionAssumed = null; } else { obj.DatePositionAssumed = sr.GetDateTime(sr.GetOrdinal("DatePositionAssumed")); } if (sr.IsDBNull(sr.GetOrdinal("DateOfDeparture"))) { obj.DateOfDeparture = null; } else { obj.DateOfDeparture = sr.GetDateTime(sr.GetOrdinal("DateOfDeparture")); } if (sr.IsDBNull(sr.GetOrdinal("PercentageOfOwnership"))) { obj.PercentageOfOwnership = null; } else { obj.PercentageOfOwnership = sr.GetDecimal(sr.GetOrdinal("PercentageOfOwnership")); } if (sr.IsDBNull(sr.GetOrdinal("RelationshipToApplicant"))) { obj.RelationshipToApplicant = null; } else { obj.RelationshipToApplicant = sr.GetString(sr.GetOrdinal("RelationshipToApplicant")); } if (sr.IsDBNull(sr.GetOrdinal("OtherPermitTypeID"))) { obj.OtherPermitTypeID = null; } else { obj.OtherPermitTypeID = sr.GetString(sr.GetOrdinal("OtherPermitTypeID")); } if (sr.IsDBNull(sr.GetOrdinal("OtherPermitStatusID"))) { obj.OtherPermitStatusID = null; } else { obj.OtherPermitStatusID = sr.GetString(sr.GetOrdinal("OtherPermitStatusID")); } if (sr.IsDBNull(sr.GetOrdinal("OtherPermitApplicationOrId"))) { obj.OtherPermitApplicationOrId = null; } else { obj.OtherPermitApplicationOrId = sr.GetString(sr.GetOrdinal("OtherPermitApplicationOrId")); } if (sr.IsDBNull(sr.GetOrdinal("Description"))) { obj.Description = null; } else { obj.Description = sr.GetString(sr.GetOrdinal("Description")); } if (sr.IsDBNull(sr.GetOrdinal("NameOfIssuingAuthority"))) { obj.NameOfIssuingAuthority = null; } else { obj.NameOfIssuingAuthority = sr.GetString(sr.GetOrdinal("NameOfIssuingAuthority")); } if (sr.IsDBNull(sr.GetOrdinal("DateOfApproval"))) { obj.DateOfApproval = null; } else { obj.DateOfApproval = sr.GetDateTime(sr.GetOrdinal("DateOfApproval")); } if (sr.IsDBNull(sr.GetOrdinal("DateOfDenial"))) { obj.DateOfDenial = null; } else { obj.DateOfDenial = sr.GetDateTime(sr.GetOrdinal("DateOfDenial")); } if (sr.IsDBNull(sr.GetOrdinal("MSHAID"))) { obj.MSHAID = null; } else { obj.MSHAID = sr.GetString(sr.GetOrdinal("MSHAID")); } if (sr.IsDBNull(sr.GetOrdinal("NameOfPublicOffice"))) { obj.NameOfPublicOffice = null; } else { obj.NameOfPublicOffice = sr.GetString(sr.GetOrdinal("NameOfPublicOffice")); } if (sr.IsDBNull(sr.GetOrdinal("ContactClassID"))) { obj.ContactClassID = null; } else { obj.ContactClassID = sr.GetString(sr.GetOrdinal("ContactClassID")); } objs.Add(obj); } return objs.ToArray(); }
/// <summary> /// Deletes a Contact record /// </summary> public static async Task<int> DeleteAsync(ContactDO DO) { SqlParameter _ContactID = new SqlParameter("ContactID", SqlDbType.Int); _ContactID.Value = DO.ContactID; SqlParameter[] _params = new SqlParameter[] { _ContactID }; string pid = ConfigurationManager.AppSettings["ePermitDAL"]; return await DataCommon.ExecuteScalarAsync("[dbo].[Contact_Delete]", _params, pid); }
/// <summary> /// Updates a Contact record and returns the number of records affected /// </summary> public static async Task<int> UpdateAsync(ContactDO DO) { SqlParameter _ContactID = new SqlParameter("ContactID", SqlDbType.Int); SqlParameter _ContactTypeID = new SqlParameter("ContactTypeID", SqlDbType.VarChar); SqlParameter _PermitKey = new SqlParameter("PermitKey", SqlDbType.Int); SqlParameter _SalutationID = new SqlParameter("SalutationID", SqlDbType.VarChar); SqlParameter _FirstName = new SqlParameter("FirstName", SqlDbType.VarChar); SqlParameter _LastName = new SqlParameter("LastName", SqlDbType.VarChar); SqlParameter _Title = new SqlParameter("Title", SqlDbType.VarChar); SqlParameter _CompanyName = new SqlParameter("CompanyName", SqlDbType.VarChar); SqlParameter _TaxID = new SqlParameter("TaxID", SqlDbType.VarChar); SqlParameter _Phone = new SqlParameter("Phone", SqlDbType.VarChar); SqlParameter _PhoneExtension = new SqlParameter("PhoneExtension", SqlDbType.VarChar); SqlParameter _CountryCode = new SqlParameter("CountryCode", SqlDbType.VarChar); SqlParameter _Fax = new SqlParameter("Fax", SqlDbType.VarChar); SqlParameter _Email = new SqlParameter("Email", SqlDbType.VarChar); SqlParameter _LegalEntityID = new SqlParameter("LegalEntityID", SqlDbType.VarChar); SqlParameter _OtherLegalEntityDescription = new SqlParameter("OtherLegalEntityDescription", SqlDbType.VarChar); SqlParameter _LegalStructureDescription = new SqlParameter("LegalStructureDescription", SqlDbType.VarChar); SqlParameter _DateOfIncorporation = new SqlParameter("DateOfIncorporation", SqlDbType.DateTime); SqlParameter _StateOfIncorporationID = new SqlParameter("StateOfIncorporationID", SqlDbType.VarChar); SqlParameter _ResponsiblePartyForAbandonedMineReclamationFee = new SqlParameter("ResponsiblePartyForAbandonedMineReclamationFee", SqlDbType.VarChar); SqlParameter _OwnershipTypeID = new SqlParameter("OwnershipTypeID", SqlDbType.VarChar); SqlParameter _OwnershipStatusID = new SqlParameter("OwnershipStatusID", SqlDbType.VarChar); SqlParameter _DatePositionAssumed = new SqlParameter("DatePositionAssumed", SqlDbType.DateTime); SqlParameter _DateOfDeparture = new SqlParameter("DateOfDeparture", SqlDbType.DateTime); SqlParameter _PercentageOfOwnership = new SqlParameter("PercentageOfOwnership", SqlDbType.Decimal); SqlParameter _RelationshipToApplicant = new SqlParameter("RelationshipToApplicant", SqlDbType.VarChar); SqlParameter _OtherPermitTypeID = new SqlParameter("OtherPermitTypeID", SqlDbType.VarChar); SqlParameter _OtherPermitStatusID = new SqlParameter("OtherPermitStatusID", SqlDbType.VarChar); SqlParameter _OtherPermitApplicationOrId = new SqlParameter("OtherPermitApplicationOrId", SqlDbType.VarChar); SqlParameter _Description = new SqlParameter("Description", SqlDbType.VarChar); SqlParameter _NameOfIssuingAuthority = new SqlParameter("NameOfIssuingAuthority", SqlDbType.VarChar); SqlParameter _DateOfApproval = new SqlParameter("DateOfApproval", SqlDbType.DateTime); SqlParameter _DateOfDenial = new SqlParameter("DateOfDenial", SqlDbType.DateTime); SqlParameter _MSHAID = new SqlParameter("MSHAID", SqlDbType.VarChar); SqlParameter _NameOfPublicOffice = new SqlParameter("NameOfPublicOffice", SqlDbType.VarChar); SqlParameter _ContactClassID = new SqlParameter("ContactClassID", SqlDbType.VarChar); _ContactID.Value = DO.ContactID; _ContactTypeID.Value = DO.ContactTypeID; _PermitKey.Value = DO.PermitKey; _SalutationID.Value = DO.SalutationID; _FirstName.Value = DO.FirstName; _LastName.Value = DO.LastName; _Title.Value = DO.Title; _CompanyName.Value = DO.CompanyName; _TaxID.Value = DO.TaxID; _Phone.Value = DO.Phone; _PhoneExtension.Value = DO.PhoneExtension; _CountryCode.Value = DO.CountryCode; _Fax.Value = DO.Fax; _Email.Value = DO.Email; _LegalEntityID.Value = DO.LegalEntityID; _OtherLegalEntityDescription.Value = DO.OtherLegalEntityDescription; _LegalStructureDescription.Value = DO.LegalStructureDescription; _DateOfIncorporation.Value = DO.DateOfIncorporation; _StateOfIncorporationID.Value = DO.StateOfIncorporationID; _ResponsiblePartyForAbandonedMineReclamationFee.Value = DO.ResponsiblePartyForAbandonedMineReclamationFee; _OwnershipTypeID.Value = DO.OwnershipTypeID; _OwnershipStatusID.Value = DO.OwnershipStatusID; _DatePositionAssumed.Value = DO.DatePositionAssumed; _DateOfDeparture.Value = DO.DateOfDeparture; _PercentageOfOwnership.Value = DO.PercentageOfOwnership; _RelationshipToApplicant.Value = DO.RelationshipToApplicant; _OtherPermitTypeID.Value = DO.OtherPermitTypeID; _OtherPermitStatusID.Value = DO.OtherPermitStatusID; _OtherPermitApplicationOrId.Value = DO.OtherPermitApplicationOrId; _Description.Value = DO.Description; _NameOfIssuingAuthority.Value = DO.NameOfIssuingAuthority; _DateOfApproval.Value = DO.DateOfApproval; _DateOfDenial.Value = DO.DateOfDenial; _MSHAID.Value = DO.MSHAID; _NameOfPublicOffice.Value = DO.NameOfPublicOffice; _ContactClassID.Value = DO.ContactClassID; SqlParameter[] _params = new SqlParameter[] { _ContactID, _ContactTypeID, _PermitKey, _SalutationID, _FirstName, _LastName, _Title, _CompanyName, _TaxID, _Phone, _PhoneExtension, _CountryCode, _Fax, _Email, _LegalEntityID, _OtherLegalEntityDescription, _LegalStructureDescription, _DateOfIncorporation, _StateOfIncorporationID, _ResponsiblePartyForAbandonedMineReclamationFee, _OwnershipTypeID, _OwnershipStatusID, _DatePositionAssumed, _DateOfDeparture, _PercentageOfOwnership, _RelationshipToApplicant, _OtherPermitTypeID, _OtherPermitStatusID, _OtherPermitApplicationOrId, _Description, _NameOfIssuingAuthority, _DateOfApproval, _DateOfDenial, _MSHAID, _NameOfPublicOffice, _ContactClassID }; string pid = ConfigurationManager.AppSettings["ePermitDAL"]; return await DataCommon.ExecuteScalarAsync("[dbo].[Contact_Update]", _params, pid); }
public ContactDO GetContactDataObject() { ContactDO data = new ContactDO() { ContactID = this.ContactID, ContactTypeID = this.ContactTypeID, PermitKey = this.PermitKey, NameOfPublicOffice=this.NameOfPublicOffice }; return data; }
public ContactDO GetDataObject() { ContactDO data = new ContactDO() { ContactID = this.ContactID, ContactTypeID = this.ContactTypeID, PermitKey = this.PermitKey, ContactClassID = this.ContactClassID, OtherPermitTypeID = this.OtherPermitTypeID, OtherPermitStatusID = this.OtherPermitStatusID, OtherPermitApplicationOrId = this.OtherPermitApplicationOrId, Description = this.Description, CompanyName = this.CompanyName, NameOfIssuingAuthority = this.NameOfIssuingAuthority, DateOfApproval = this.DateOfApproval, DateOfDenial = this.DateOfDenial, MSHAID = this.MSHAID, TaxID = this.TaxID }; return data; }