コード例 #1
0
        public void Fill(SqlDataReader reader)
        {
            if (CommonUtility.IsColumnExistsAndNotNull(reader, "SpouseWillingness"))
            {
                this.spouseWillingness = Convert.ToBoolean(reader["SpouseWillingness"]);
            }

            if (CommonUtility.IsColumnExistsAndNotNull(reader, "ID"))
            {
                this.id = Convert.ToInt32(reader["ID"]);
            }

            if (CommonUtility.IsColumnExistsAndNotNull(reader, "UniqueSubjectID"))
            {
                this.uniqueSubjectId = Convert.ToString(reader["UniqueSubjectID"]);
            }

            if (CommonUtility.IsColumnExistsAndNotNull(reader, "DistrictID"))
            {
                this.districtId = Convert.ToInt32(reader["DistrictID"]);
            }

            if (CommonUtility.IsColumnExistsAndNotNull(reader, "CHCID"))
            {
                this.chcId = Convert.ToInt32(reader["CHCID"]);
            }

            if (CommonUtility.IsColumnExistsAndNotNull(reader, "PHCID"))
            {
                this.phcId = Convert.ToInt32(reader["PHCID"]);
            }

            if (CommonUtility.IsColumnExistsAndNotNull(reader, "SCID"))
            {
                this.scId = Convert.ToInt32(reader["SCID"]);
            }

            if (CommonUtility.IsColumnExistsAndNotNull(reader, "RIID"))
            {
                this.riId = Convert.ToInt32(reader["RIID"]);
            }

            if (CommonUtility.IsColumnExistsAndNotNull(reader, "FirstName"))
            {
                this.firstName = Convert.ToString(reader["FirstName"]);
            }

            if (CommonUtility.IsColumnExistsAndNotNull(reader, "MiddleName"))
            {
                this.middleName = Convert.ToString(reader["MiddleName"]);
            }

            if (CommonUtility.IsColumnExistsAndNotNull(reader, "LastName"))
            {
                this.lastName = Convert.ToString(reader["LastName"]);
            }

            if (CommonUtility.IsColumnExistsAndNotNull(reader, "MobileNo"))
            {
                this.contactNo = Convert.ToString(reader["MobileNo"]);
            }

            if (CommonUtility.IsColumnExistsAndNotNull(reader, "Spouse_FirstName"))
            {
                this.spouseFirstName = Convert.ToString(reader["Spouse_FirstName"]);
            }

            if (CommonUtility.IsColumnExistsAndNotNull(reader, "Spouse_MiddleName"))
            {
                this.spouseMiddleName = Convert.ToString(reader["Spouse_MiddleName"]);
            }

            if (CommonUtility.IsColumnExistsAndNotNull(reader, "Spouse_LastName"))
            {
                this.spouseLastName = Convert.ToString(reader["Spouse_LastName"]);
            }

            if (CommonUtility.IsColumnExistsAndNotNull(reader, "Spouse_ContactNo"))
            {
                this.spouseContactNo = Convert.ToString(reader["Spouse_ContactNo"]);
            }

            if (CommonUtility.IsColumnExistsAndNotNull(reader, "Religion_Id"))
            {
                this.religionId = Convert.ToInt32(reader["Religion_Id"]);
            }

            if (CommonUtility.IsColumnExistsAndNotNull(reader, "Caste_Id"))
            {
                this.casteId = Convert.ToInt32(reader["Caste_Id"]);
            }

            if (CommonUtility.IsColumnExistsAndNotNull(reader, "Community_Id"))
            {
                this.communityId = Convert.ToInt32(reader["Community_Id"]);
            }

            if (CommonUtility.IsColumnExistsAndNotNull(reader, "Address1"))
            {
                this.address1 = Convert.ToString(reader["Address1"]);
            }

            if (CommonUtility.IsColumnExistsAndNotNull(reader, "Address2"))
            {
                this.address2 = Convert.ToString(reader["Address2"]);
            }

            if (CommonUtility.IsColumnExistsAndNotNull(reader, "Address3"))
            {
                this.address3 = Convert.ToString(reader["Address3"]);
            }

            if (CommonUtility.IsColumnExistsAndNotNull(reader, "Pincode"))
            {
                this.pincode = Convert.ToString(reader["Pincode"]);
            }

            if (CommonUtility.IsColumnExistsAndNotNull(reader, "StateName"))
            {
                this.stateName = Convert.ToString(reader["StateName"]);
            }

            if (CommonUtility.IsColumnExistsAndNotNull(reader, "RCHID"))
            {
                this.rchId = Convert.ToString(reader["RCHID"]);
            }

            if (CommonUtility.IsColumnExistsAndNotNull(reader, "ECNumber"))
            {
                this.ecNumber = Convert.ToString(reader["ECNumber"]);
            }
        }
コード例 #2
0
        //public string DigitalSignature { get; set; }
        public void Fill(SqlDataReader reader)
        {
            if (CommonUtility.IsColumnExistsAndNotNull(reader, "ID"))
            {
                this.id = Convert.ToInt32(reader["ID"]);
            }

            if (CommonUtility.IsColumnExistsAndNotNull(reader, "PNDTLocationId"))
            {
                this.pndtLocationId = Convert.ToInt32(reader["PNDTLocationId"]);
            }

            if (CommonUtility.IsColumnExistsAndNotNull(reader, "UserType_ID"))
            {
                this.userTypeId = Convert.ToInt32(reader["UserType_ID"]);
            }

            if (CommonUtility.IsColumnExistsAndNotNull(reader, "Usertype"))
            {
                this.userType = Convert.ToString(reader["Usertype"]);
            }

            if (CommonUtility.IsColumnExistsAndNotNull(reader, "UserRole_ID"))
            {
                this.userRoleId = Convert.ToInt32(reader["UserRole_ID"]);
            }

            if (CommonUtility.IsColumnExistsAndNotNull(reader, "Userrolename"))
            {
                this.userRole = Convert.ToString(reader["Userrolename"]);
            }

            if (CommonUtility.IsColumnExistsAndNotNull(reader, "UserRoleDescription"))
            {
                this.userRoleDescription = Convert.ToString(reader["UserRoleDescription"]);
            }

            if (CommonUtility.IsColumnExistsAndNotNull(reader, "AccessModules"))
            {
                this.userRoleAccessModule = Convert.ToString(reader["AccessModules"]);
            }

            if (CommonUtility.IsColumnExistsAndNotNull(reader, "User_gov_code"))
            {
                this.userGovCode = Convert.ToString(reader["User_gov_code"]);
            }

            if (CommonUtility.IsColumnExistsAndNotNull(reader, "Username"))
            {
                this.userName = Convert.ToString(reader["Username"]);
            }

            if (CommonUtility.IsColumnExistsAndNotNull(reader, "StateID"))
            {
                this.stateId = Convert.ToInt32(reader["StateID"]);
            }

            if (CommonUtility.IsColumnExistsAndNotNull(reader, "CentralLabId"))
            {
                this.centralLabId = Convert.ToInt32(reader["CentralLabId"]);
            }

            if (CommonUtility.IsColumnExistsAndNotNull(reader, "CentralLabName"))
            {
                this.centralLabName = Convert.ToString(reader["CentralLabName"]);
            }

            if (CommonUtility.IsColumnExistsAndNotNull(reader, "molecularLabId"))
            {
                this.molecularLabId = Convert.ToInt32(reader["molecularLabId"]);
            }

            if (CommonUtility.IsColumnExistsAndNotNull(reader, "MLabName"))
            {
                this.molecularLabName = Convert.ToString(reader["MLabName"]);
            }

            if (CommonUtility.IsColumnExistsAndNotNull(reader, "DistrictID"))
            {
                this.districtId = Convert.ToInt32(reader["DistrictID"]);
            }

            if (CommonUtility.IsColumnExistsAndNotNull(reader, "Districtname"))
            {
                this.districtName = Convert.ToString(reader["Districtname"]);
            }

            if (CommonUtility.IsColumnExistsAndNotNull(reader, "BlockID"))
            {
                this.blockId = Convert.ToInt32(reader["BlockID"]);
            }

            if (CommonUtility.IsColumnExistsAndNotNull(reader, "Blockname"))
            {
                this.blockName = Convert.ToString(reader["Blockname"]);
            }

            if (CommonUtility.IsColumnExistsAndNotNull(reader, "CHCID"))
            {
                this.chcId = Convert.ToInt32(reader["CHCID"]);
            }

            if (CommonUtility.IsColumnExistsAndNotNull(reader, "CHCname"))
            {
                this.chcName = Convert.ToString(reader["CHCname"]);
            }

            if (CommonUtility.IsColumnExistsAndNotNull(reader, "PHCID"))
            {
                this.phcId = Convert.ToInt32(reader["PHCID"]);
            }

            if (CommonUtility.IsColumnExistsAndNotNull(reader, "PHCname"))
            {
                this.phcName = Convert.ToString(reader["PHCname"]);
            }

            if (CommonUtility.IsColumnExistsAndNotNull(reader, "SCID"))
            {
                this.scId = Convert.ToInt32(reader["SCID"]);
            }

            if (CommonUtility.IsColumnExistsAndNotNull(reader, "SCname"))
            {
                this.scName = Convert.ToString(reader["SCname"]);
            }

            if (CommonUtility.IsColumnExistsAndNotNull(reader, "RIID"))
            {
                this.riId = Convert.ToString(reader["RIID"]);
            }

            if (CommonUtility.IsColumnExistsAndNotNull(reader, "Name"))
            {
                this.name = Convert.ToString(reader["Name"]);
            }

            if (CommonUtility.IsColumnExistsAndNotNull(reader, "FirstName"))
            {
                this.firstName = Convert.ToString(reader["FirstName"]);
            }

            if (CommonUtility.IsColumnExistsAndNotNull(reader, "MiddleName"))
            {
                this.middleName = Convert.ToString(reader["MiddleName"]);
            }

            if (CommonUtility.IsColumnExistsAndNotNull(reader, "LastName"))
            {
                this.lastName = Convert.ToString(reader["LastName"]);
            }

            if (CommonUtility.IsColumnExistsAndNotNull(reader, "Email"))
            {
                this.email = Convert.ToString(reader["Email"]);
            }

            if (CommonUtility.IsColumnExistsAndNotNull(reader, "ContactNo1"))
            {
                this.mobileNo = Convert.ToString(reader["ContactNo1"]);
            }

            if (CommonUtility.IsColumnExistsAndNotNull(reader, "RegisteredFrom"))
            {
                this.registeredFrom = Convert.ToInt32(reader["RegisteredFrom"]);
            }

            if (CommonUtility.IsColumnExistsAndNotNull(reader, "SampleCollectionFrom"))
            {
                this.sampleCollectionFrom = Convert.ToInt32(reader["SampleCollectionFrom"]);
            }

            if (CommonUtility.IsColumnExistsAndNotNull(reader, "ShipmentFrom"))
            {
                this.shipmentFrom = Convert.ToInt32(reader["ShipmentFrom"]);
            }

            if (CommonUtility.IsColumnExistsAndNotNull(reader, "PNDTLocationId"))
            {
                this.pndtLocationId = Convert.ToInt32(reader["PNDTLocationId"]);
            }
        }