protected override EntityBase CreateAndBuildEntity(DataHelper.Framework.SafeDataReader dr) { VEHICLE_AT_OFFICE theEntity = new VEHICLE_AT_OFFICE(); theEntity.PK_ID = !dr.IsDBNull(0) ? dr.GetValue(0).ToString() : string.Empty; theEntity.VEHICLE_ID = !dr.IsDBNull(1) ? dr.GetValue(1).ToString() : string.Empty; theEntity.OFFICE_ID = !dr.IsDBNull(2) ? dr.GetValue(2).ToString() : string.Empty; theEntity.VAO_DATE = !dr.IsDBNull(3) ? dr.GetValue(3).ToString() : string.Empty; theEntity.VAO_DAY = !dr.IsDBNull(4) ? dr.GetValue(4).ToString() : string.Empty; theEntity.VAO_MONTH = !dr.IsDBNull(5) ? dr.GetValue(5).ToString() : string.Empty; theEntity.VAO_YEAR = !dr.IsDBNull(6) ? dr.GetValue(6).ToString() : string.Empty; theEntity.TRANSFER_PURCHASE_ID = !dr.IsDBNull(7) ? dr.GetValue(7).ToString() : string.Empty; theEntity.TRANSFER_PURCHASE = !dr.IsDBNull(8) ? dr.GetValue(8).ToString() : string.Empty; theEntity.STATUS = !dr.IsDBNull(9) ? dr.GetValue(9).ToString() : string.Empty; theEntity.PERSON_ID = !dr.IsDBNull(10) ? dr.GetValue(10).ToString() : string.Empty; return(theEntity); }
protected override EntityBase CreateAndBuildEntity(DataHelper.Framework.SafeDataReader dr) { OFFICE theEntity = new OFFICE(); theEntity.PK_ID = !dr.IsDBNull(0) ? dr.GetValue(0).ToString() : string.Empty; theEntity.OFFICECODE = !dr.IsDBNull(1) ? dr.GetValue(1).ToString() : string.Empty; theEntity.OFFICENAME = !dr.IsDBNull(2) ? dr.GetValue(2).ToString() : string.Empty; theEntity.WARDNO = !dr.IsDBNull(3) ? dr.GetValue(3).ToString() : string.Empty; theEntity.STREET = !dr.IsDBNull(4) ? dr.GetValue(4).ToString() : string.Empty; theEntity.VDCMUNICIPALITY = !dr.IsDBNull(5) ? dr.GetValue(5).ToString() : string.Empty; theEntity.OFFICETYPEID = !dr.IsDBNull(6) ? dr.GetValue(6).ToString() : string.Empty; theEntity.WORKSASDEPOT = !dr.IsDBNull(7) ? dr.GetValue(7).ToString() : string.Empty; theEntity.REGIONID = !dr.IsDBNull(8) ? dr.GetValue(8).ToString() : string.Empty; theEntity.CONTACT_PERSON = !dr.IsDBNull(9) ? dr.GetValue(9).ToString() : string.Empty; theEntity.PHONE_NO = !dr.IsDBNull(10) ? dr.GetValue(10).ToString() : string.Empty; theEntity.MOBILE_NO = !dr.IsDBNull(11) ? dr.GetValue(11).ToString() : string.Empty; theEntity.EMAIL = !dr.IsDBNull(12) ? dr.GetValue(12).ToString() : string.Empty; return(theEntity); }
protected override EntityBase CreateAndBuildEntity(DataHelper.Framework.SafeDataReader dr) { FIVE_DIMENSION_RETURN theEntity = new FIVE_DIMENSION_RETURN(); theEntity.PK_ID = !dr.IsDBNull(0) ? dr.GetValue(0).ToString() : string.Empty; theEntity.VEHICLE_ISSUE_ID = !dr.IsDBNull(1) ? dr.GetValue(1).ToString() : string.Empty; theEntity.DIMENSION = !dr.IsDBNull(2) ? dr.GetValue(2).ToString() : string.Empty; theEntity.SCRATCH = !dr.IsDBNull(3) ? dr.GetValue(3).ToString() : string.Empty; theEntity.MISSING = !dr.IsDBNull(4) ? dr.GetValue(4).ToString() : string.Empty; theEntity.BROKEN = !dr.IsDBNull(5) ? dr.GetValue(5).ToString() : string.Empty; theEntity.DENTED = !dr.IsDBNull(6) ? dr.GetValue(6).ToString() : string.Empty; theEntity.OTHERS = !dr.IsDBNull(7) ? dr.GetValue(7).ToString() : string.Empty; theEntity.OTHER_DESCRIPTION = !dr.IsDBNull(8) ? dr.GetValue(8).ToString() : string.Empty; theEntity.VEHICLE_ISSUE_RETURN_ID = !dr.IsDBNull(9) ? dr.GetValue(9).ToString() : string.Empty; return(theEntity); }
protected override EntityBase CreateAndBuildEntity(DataHelper.Framework.SafeDataReader dr) { VEHICLE_DAKHILA_DETAIL theEntity = new VEHICLE_DAKHILA_DETAIL(); theEntity.PK_ID = !dr.IsDBNull(0) ? dr.GetValue(0).ToString() : string.Empty; theEntity.VEHICLE_DAKHILA_ID = !dr.IsDBNull(1) ? dr.GetValue(1).ToString() : string.Empty; theEntity.SNO = !dr.IsDBNull(2) ? dr.GetValue(2).ToString() : string.Empty; theEntity.LFONO = !dr.IsDBNull(3) ? dr.GetValue(3).ToString() : string.Empty; theEntity.PRODUCT_ID = !dr.IsDBNull(4) ? dr.GetValue(4).ToString() : string.Empty; theEntity.QUANTITY = !dr.IsDBNull(5) ? dr.GetValue(5).ToString() : string.Empty; theEntity.RATE = !dr.IsDBNull(6) ? dr.GetValue(6).ToString() : string.Empty; theEntity.VAT = !dr.IsDBNull(7) ? dr.GetValue(7).ToString() : string.Empty; theEntity.OTHER_EXPENSE = !dr.IsDBNull(8) ? dr.GetValue(8).ToString() : string.Empty; theEntity.TOTAL = !dr.IsDBNull(9) ? dr.GetValue(9).ToString() : string.Empty; theEntity.BATCH = !dr.IsDBNull(10) ? dr.GetValue(10).ToString() : string.Empty; theEntity.LIFETIME = !dr.IsDBNull(11) ? dr.GetValue(11).ToString() : string.Empty; theEntity.REMARKS = !dr.IsDBNull(12) ? dr.GetValue(12).ToString() : string.Empty; return(theEntity); }
protected override EntityBase CreateAndBuildEntity(DataHelper.Framework.SafeDataReader dr) { OPENING_CLOSING theEntity = new OPENING_CLOSING(); theEntity.PK_ID = !dr.IsDBNull(0) ? dr.GetValue(0).ToString() : string.Empty; theEntity.FISCAL_YEAR = !dr.IsDBNull(1) ? dr.GetValue(1).ToString() : string.Empty; theEntity.PRODUCT_ID = !dr.IsDBNull(2) ? dr.GetValue(2).ToString() : string.Empty; theEntity.OPENING_QTY = !dr.IsDBNull(3) ? dr.GetValue(3).ToString() : string.Empty; theEntity.PURCHASE_QTY = !dr.IsDBNull(4) ? dr.GetValue(4).ToString() : string.Empty; theEntity.RETURN_QTY = !dr.IsDBNull(5) ? dr.GetValue(5).ToString() : string.Empty; theEntity.ADJUSTED_QTY = !dr.IsDBNull(6) ? dr.GetValue(6).ToString() : string.Empty; theEntity.ISSUE_QTY = !dr.IsDBNull(7) ? dr.GetValue(7).ToString() : string.Empty; theEntity.CLOSING_QTY = !dr.IsDBNull(8) ? dr.GetValue(8).ToString() : string.Empty; theEntity.UNIT = !dr.IsDBNull(9) ? dr.GetValue(9).ToString() : string.Empty; theEntity.BATCH = !dr.IsDBNull(10) ? dr.GetValue(10).ToString() : string.Empty; theEntity.EXPIRY_DATE = !dr.IsDBNull(11) ? dr.GetValue(11).ToString() : string.Empty; theEntity.RATE = !dr.IsDBNull(12) ? dr.GetValue(12).ToString() : string.Empty; return(theEntity); }
protected override EntityBase CreateAndBuildEntity(DataHelper.Framework.SafeDataReader dr) { NAME_COMPANY theEntity = new NAME_COMPANY(); theEntity.NAME = !dr.IsDBNull(0) ? dr.GetValue(0).ToString() : string.Empty; theEntity.ADDRESS = !dr.IsDBNull(1) ? dr.GetValue(1).ToString() : string.Empty; theEntity.MOBILE_NO = !dr.IsDBNull(2) ? dr.GetValue(2).ToString() : string.Empty; theEntity.PHONE_NO1 = !dr.IsDBNull(3) ? dr.GetValue(3).ToString() : string.Empty; theEntity.PHONE_NO2 = !dr.IsDBNull(4) ? dr.GetValue(4).ToString() : string.Empty; theEntity.PHONE_NO3 = !dr.IsDBNull(5) ? dr.GetValue(5).ToString() : string.Empty; theEntity.EMAIL = !dr.IsDBNull(6) ? dr.GetValue(6).ToString() : string.Empty; theEntity.WEBSITE = !dr.IsDBNull(7) ? dr.GetValue(7).ToString() : string.Empty; theEntity.FAX = !dr.IsDBNull(8) ? dr.GetValue(8).ToString() : string.Empty; theEntity.PAN_NO = !dr.IsDBNull(9) ? dr.GetValue(9).ToString() : string.Empty; theEntity.REG_NO = !dr.IsDBNull(10) ? dr.GetValue(10).ToString() : string.Empty; return(theEntity); }
protected override EntityBase CreateAndBuildEntity(DataHelper.Framework.SafeDataReader dr) { REPAIR_ORDER_MASTER theEntity = new REPAIR_ORDER_MASTER(); theEntity.PK_ID = !dr.IsDBNull(0) ? dr.GetValue(0).ToString() : string.Empty; theEntity.OFFICE_CODE = !dr.IsDBNull(1) ? dr.GetValue(1).ToString() : string.Empty; theEntity.REPAIR_ORDER_NUMBER = !dr.IsDBNull(2) ? dr.GetValue(2).ToString() : string.Empty; theEntity.REPAIR_ORDER_DAY = !dr.IsDBNull(3) ? dr.GetValue(3).ToString() : string.Empty; theEntity.REPAIR_ORDER_MONTH = !dr.IsDBNull(4) ? dr.GetValue(4).ToString() : string.Empty; theEntity.REPAIR_ORDER_YEAR = !dr.IsDBNull(5) ? dr.GetValue(5).ToString() : string.Empty; theEntity.REPAIR_ORDER_DATE = !dr.IsDBNull(6) ? dr.GetValue(6).ToString() : string.Empty; theEntity.REPAIR_ORDER_FY = !dr.IsDBNull(7) ? dr.GetValue(7).ToString() : string.Empty; theEntity.EXTERNAL_WORKSHOP_ID = !dr.IsDBNull(8) ? dr.GetValue(8).ToString() : string.Empty; theEntity.VEHICLE_REG_NO = !dr.IsDBNull(9) ? dr.GetValue(9).ToString() : string.Empty; theEntity.CHECK_BY_ID = !dr.IsDBNull(10) ? dr.GetValue(10).ToString() : string.Empty; theEntity.ACCOUNTANT_ID = !dr.IsDBNull(11) ? dr.GetValue(11).ToString() : string.Empty; theEntity.DEPARTMENTHEAD_ID = !dr.IsDBNull(12) ? dr.GetValue(12).ToString() : string.Empty; return(theEntity); }
protected override EntityBase CreateAndBuildEntity(DataHelper.Framework.SafeDataReader dr) { INSURANCE_CLAIM theEntity = new INSURANCE_CLAIM(); theEntity.PK_ID = !dr.IsDBNull(0) ? dr.GetValue(0).ToString() : string.Empty; theEntity.VEHICLE_ACCIDENT_ID = !dr.IsDBNull(1) ? dr.GetValue(1).ToString() : string.Empty; theEntity.REPORTING_DATE = !dr.IsDBNull(2) ? dr.GetValue(2).ToString() : string.Empty; theEntity.REPORTING_DAY = !dr.IsDBNull(3) ? dr.GetValue(3).ToString() : string.Empty; theEntity.REPORTING_MONTH = !dr.IsDBNull(4) ? dr.GetValue(4).ToString() : string.Empty; theEntity.REPORTING_YEAR = !dr.IsDBNull(5) ? dr.GetValue(5).ToString() : string.Empty; theEntity.INSURANCE_COMPANY_ID = !dr.IsDBNull(6) ? dr.GetValue(6).ToString() : string.Empty; theEntity.REPAIRED_SHOP = !dr.IsDBNull(7) ? dr.GetValue(7).ToString() : string.Empty; theEntity.REPAIRED_DETAIL = !dr.IsDBNull(8) ? dr.GetValue(8).ToString() : string.Empty; theEntity.CLAIMED_COST = !dr.IsDBNull(9) ? dr.GetValue(9).ToString() : string.Empty; theEntity.REIMBURSED_COST = !dr.IsDBNull(10) ? dr.GetValue(10).ToString() : string.Empty; theEntity.REIMBURSED_REFERENCE = !dr.IsDBNull(11) ? dr.GetValue(11).ToString() : string.Empty; return(theEntity); }
protected override EntityBase CreateAndBuildEntity(DataHelper.Framework.SafeDataReader dr) { UserProfileEntity theEntity = new UserProfileEntity(); theEntity.UserName = !dr.IsDBNull(0) ? dr.GetValue(0).ToString() : string.Empty; theEntity.FullDetails = !dr.IsDBNull(1) ? dr.GetValue(1).ToString() : string.Empty; theEntity.Password = !dr.IsDBNull(5) ? dr.GetValue(5).ToString() : string.Empty; theEntity.FiscalYear = !dr.IsDBNull(2) ? dr.GetValue(2).ToString() : string.Empty; theEntity.EmployeeName = !dr.IsDBNull(3) ? dr.GetValue(3).ToString() : string.Empty; theEntity.UserGroupID = !dr.IsDBNull(4) ? Int32.Parse(dr.GetValue(4).ToString()) : 0; theEntity.EmployeeID = !dr.IsDBNull(12) ? dr.GetValue(12).ToString() : string.Empty; if (!dr.IsDBNull(7)) { if (Int32.Parse(dr.GetValue(7).ToString()) == 1) { theEntity.Accessblocked = true; } else { theEntity.Accessblocked = false; } } else { theEntity.Accessblocked = false; } return(theEntity); }
protected override EntityBase CreateAndBuildEntity(DataHelper.Framework.SafeDataReader dr) { PRODUCT_ISSUE_DETAIL theEntity = new PRODUCT_ISSUE_DETAIL(); theEntity.PK_ID = !dr.IsDBNull(0) ? dr.GetValue(0).ToString() : string.Empty; theEntity.PRODUCT_ISSUE_ID = !dr.IsDBNull(1) ? dr.GetValue(1).ToString() : string.Empty; theEntity.SNO = !dr.IsDBNull(2) ? dr.GetValue(2).ToString() : string.Empty; theEntity.LFONO = !dr.IsDBNull(3) ? dr.GetValue(3).ToString() : string.Empty; theEntity.PRODUCT_ID = !dr.IsDBNull(4) ? dr.GetValue(4).ToString() : string.Empty; theEntity.QTY = !dr.IsDBNull(5) ? dr.GetValue(5).ToString() : string.Empty; theEntity.UNIT = !dr.IsDBNull(6) ? dr.GetValue(6).ToString() : string.Empty; theEntity.INITIAL_RECEIVED_DATE = !dr.IsDBNull(7) ? dr.GetValue(7).ToString() : string.Empty; theEntity.REMARKS = !dr.IsDBNull(8) ? dr.GetValue(8).ToString() : string.Empty; theEntity.BATCH_NO = !dr.IsDBNull(9) ? dr.GetValue(9).ToString() : string.Empty; theEntity.OFFICE_CODE = !dr.IsDBNull(10) ? dr.GetValue(10).ToString() : string.Empty; return(theEntity); }
protected override EntityBase CreateAndBuildEntity(DataHelper.Framework.SafeDataReader dr) { M_COMPLITION_DETAIL theEntity = new M_COMPLITION_DETAIL(); theEntity.PK_ID = !dr.IsDBNull(0) ? dr.GetValue(0).ToString() : string.Empty; theEntity.M_COMPLITION_ID = !dr.IsDBNull(1) ? dr.GetValue(1).ToString() : string.Empty; theEntity.SNO = !dr.IsDBNull(2) ? dr.GetValue(2).ToString() : string.Empty; theEntity.PARTS_LABOUR = !dr.IsDBNull(3) ? dr.GetValue(3).ToString() : string.Empty; theEntity.PARTS_LABOUR_ID = !dr.IsDBNull(4) ? dr.GetValue(4).ToString() : string.Empty; theEntity.QTY = !dr.IsDBNull(5) ? dr.GetValue(5).ToString() : string.Empty; theEntity.RATE_PER_UNIT = !dr.IsDBNull(6) ? dr.GetValue(6).ToString() : string.Empty; theEntity.TOTAL_COST = !dr.IsDBNull(7) ? dr.GetValue(7).ToString() : string.Empty; theEntity.SUPPLIER_ID = !dr.IsDBNull(8) ? dr.GetValue(8).ToString() : string.Empty; theEntity.SUPPLY_DATE = !dr.IsDBNull(9) ? dr.GetValue(9).ToString() : string.Empty; theEntity.INVOICE_NO = !dr.IsDBNull(10) ? dr.GetValue(10).ToString() : string.Empty; theEntity.REMARKS = !dr.IsDBNull(11) ? dr.GetValue(11).ToString() : string.Empty; return(theEntity); }
protected override EntityBase CreateAndBuildEntity(DataHelper.Framework.SafeDataReader dr) { REPAIR_ORDER_DETAIL theEntity = new REPAIR_ORDER_DETAIL(); theEntity.PK_ID = !dr.IsDBNull(0) ? dr.GetValue(0).ToString() : string.Empty; theEntity.REPAIR_ORDER_ID = !dr.IsDBNull(1) ? dr.GetValue(1).ToString() : string.Empty; theEntity.SNO = !dr.IsDBNull(2) ? dr.GetValue(2).ToString() : string.Empty; theEntity.PARTICULAR = !dr.IsDBNull(3) ? dr.GetValue(3).ToString() : string.Empty; theEntity.QTY = !dr.IsDBNull(4) ? dr.GetValue(4).ToString() : string.Empty; theEntity.UNIT = !dr.IsDBNull(5) ? dr.GetValue(5).ToString() : string.Empty; theEntity.RATE = !dr.IsDBNull(6) ? dr.GetValue(6).ToString() : string.Empty; theEntity.AMOUNT = !dr.IsDBNull(7) ? dr.GetValue(7).ToString() : string.Empty; theEntity.REMARKS = !dr.IsDBNull(8) ? dr.GetValue(8).ToString() : string.Empty; theEntity.PARTICULAR_TYPE = !dr.IsDBNull(9) ? dr.GetValue(9).ToString() : string.Empty; return(theEntity); }
protected override EntityBase CreateAndBuildEntity(DataHelper.Framework.SafeDataReader dr) { MOVEMENT_OF_VEHICLE theEntity = new MOVEMENT_OF_VEHICLE(); theEntity.PK_ID = !dr.IsDBNull(0) ? dr.GetValue(0).ToString() : string.Empty; theEntity.TRAVEL_NUMBER = !dr.IsDBNull(1) ? dr.GetValue(1).ToString() : string.Empty; theEntity.TRAVEL_DAY = !dr.IsDBNull(2) ? dr.GetValue(2).ToString() : string.Empty; theEntity.TRAVEL_MONTH = !dr.IsDBNull(3) ? dr.GetValue(3).ToString() : string.Empty; theEntity.TRAVEL_YEAR = !dr.IsDBNull(4) ? dr.GetValue(4).ToString() : string.Empty; theEntity.TRAVEL_DATE = !dr.IsDBNull(5) ? dr.GetValue(5).ToString() : string.Empty; theEntity.TRAVEL_FY = !dr.IsDBNull(6) ? dr.GetValue(6).ToString() : string.Empty; theEntity.VEHICLE_REG_NO = !dr.IsDBNull(7) ? dr.GetValue(7).ToString() : string.Empty; theEntity.DRIVER_ID = !dr.IsDBNull(8) ? dr.GetValue(8).ToString() : string.Empty; theEntity.TVL_MAIN_PERSON = !dr.IsDBNull(9) ? dr.GetValue(9).ToString() : string.Empty; theEntity.TVL_MAIN_CONTACTNO = !dr.IsDBNull(10) ? dr.GetValue(10).ToString() : string.Empty; theEntity.TV_MAIN_MOBILENO = !dr.IsDBNull(11) ? dr.GetValue(11).ToString() : string.Empty; theEntity.TVL_MAIN_CALLSIGN = !dr.IsDBNull(12) ? dr.GetValue(12).ToString() : string.Empty; theEntity.TVL_REASON = !dr.IsDBNull(13) ? dr.GetValue(13).ToString() : string.Empty; theEntity.TVL_TYPE = !dr.IsDBNull(14) ? dr.GetValue(14).ToString() : string.Empty; theEntity.TVL_REF_DEMAND_BY = !dr.IsDBNull(15) ? dr.GetValue(15).ToString() : string.Empty; theEntity.TVL_REF_DEMAND_OFFICE = !dr.IsDBNull(16) ? dr.GetValue(16).ToString() : string.Empty; theEntity.TVL_REF_DEMAND_DIS = !dr.IsDBNull(17) ? dr.GetValue(17).ToString() : string.Empty; theEntity.TVL_REF_APPROVE_BY = !dr.IsDBNull(18) ? dr.GetValue(18).ToString() : string.Empty; theEntity.TVL_REF_APPROVE_OFFICE = !dr.IsDBNull(19) ? dr.GetValue(19).ToString() : string.Empty; theEntity.TVL_REF_APPROVE_DIS = !dr.IsDBNull(20) ? dr.GetValue(20).ToString() : string.Empty; theEntity.TVL_APPROVE_BY = !dr.IsDBNull(21) ? dr.GetValue(21).ToString() : string.Empty; theEntity.TVL_APPROVE_OFFICE = !dr.IsDBNull(22) ? dr.GetValue(22).ToString() : string.Empty; theEntity.TVL_APPROVE_DIS = !dr.IsDBNull(23) ? dr.GetValue(23).ToString() : string.Empty; theEntity.TVL_COMPLITION_DETAIL = !dr.IsDBNull(24) ? dr.GetValue(24).ToString() : string.Empty; theEntity.FUEL_SOURCE = !dr.IsDBNull(25) ? dr.GetValue(25).ToString() : string.Empty; theEntity.FUEL_QUANTITY = !dr.IsDBNull(26) ? dr.GetValue(26).ToString() : string.Empty; return(theEntity); }
protected override EntityBase CreateAndBuildEntity(DataHelper.Framework.SafeDataReader dr) { VECHICLE_ACCIDENT theEntity = new VECHICLE_ACCIDENT(); theEntity.PK_ID = !dr.IsDBNull(0) ? dr.GetValue(0).ToString() : string.Empty; theEntity.VEHICLE_ID = !dr.IsDBNull(1) ? dr.GetValue(1).ToString() : string.Empty; theEntity.ACCIDENT_TYPE_ID = !dr.IsDBNull(2) ? dr.GetValue(2).ToString() : string.Empty; theEntity.ACCIDENT_DAY = !dr.IsDBNull(3) ? dr.GetValue(3).ToString() : string.Empty; theEntity.ACCIDENT_MONTH = !dr.IsDBNull(4) ? dr.GetValue(4).ToString() : string.Empty; theEntity.ACCIDENT_YEAR = !dr.IsDBNull(5) ? dr.GetValue(5).ToString() : string.Empty; theEntity.ACCIDENT_PLACE = !dr.IsDBNull(6) ? dr.GetValue(6).ToString() : string.Empty; theEntity.ACCIDENT_DETAIL = !dr.IsDBNull(7) ? dr.GetValue(7).ToString() : string.Empty; theEntity.DRIVER_ID = !dr.IsDBNull(8) ? dr.GetValue(8).ToString() : string.Empty; theEntity.OFFICE_CODE = !dr.IsDBNull(9) ? dr.GetValue(9).ToString() : string.Empty; theEntity.ACCIDENT_NO = !dr.IsDBNull(10) ? dr.GetValue(10).ToString() : string.Empty; theEntity.ACCIDENT_FISCAL_YEAR = !dr.IsDBNull(11) ? dr.GetValue(11).ToString() : string.Empty; return(theEntity); }
protected override EntityBase CreateAndBuildEntity(DataHelper.Framework.SafeDataReader dr) { PERSONDETAILS theEntity = new PERSONDETAILS(); theEntity.CODE = !dr.IsDBNull(0) ? dr.GetValue(0).ToString() : string.Empty; theEntity.NAME = !dr.IsDBNull(1) ? dr.GetValue(1).ToString() : string.Empty; theEntity.FATHER_NAME = !dr.IsDBNull(2) ? dr.GetValue(2).ToString() : string.Empty; theEntity.GRAND_FATHER_NAME = !dr.IsDBNull(3) ? dr.GetValue(3).ToString() : string.Empty; theEntity.RNK = !dr.IsDBNull(4) ? dr.GetValue(4).ToString() : string.Empty; theEntity.PIS = !dr.IsDBNull(5) ? dr.GetValue(5).ToString() : string.Empty; theEntity.POSITION = !dr.IsDBNull(6) ? dr.GetValue(6).ToString() : string.Empty; theEntity.ADDRESS = !dr.IsDBNull(7) ? dr.GetValue(7).ToString() : string.Empty; theEntity.MOJ = !dr.IsDBNull(8) ? dr.GetValue(8).ToString() : string.Empty; theEntity.MOR = !dr.IsDBNull(9) ? dr.GetValue(9).ToString() : string.Empty; theEntity.CURRENT_UNIT = !dr.IsDBNull(10) ? dr.GetValue(10).ToString() : string.Empty; theEntity.JOB_STATUS = !dr.IsDBNull(11) ? dr.GetValue(11).ToString() : string.Empty; return(theEntity); }
protected override EntityBase CreateAndBuildEntity(DataHelper.Framework.SafeDataReader dr) { Login theEntity = new Login(); theEntity.LOGINID = !dr.IsDBNull(0) ? dr.GetValue(0).ToString() : string.Empty; theEntity.FULLDETAILS = !dr.IsDBNull(1) ? dr.GetValue(1).ToString() : string.Empty; theEntity.EMPLOYEEID = !dr.IsDBNull(2) ? dr.GetValue(2).ToString() : string.Empty; theEntity.GROUPID = !dr.IsDBNull(3) ? dr.GetValue(3).ToString() : string.Empty; theEntity.LDOLOGIN = !dr.IsDBNull(4) ? dr.GetValue(4).ToString() : string.Empty; theEntity.PASSWORD = !dr.IsDBNull(5) ? dr.GetValue(5).ToString() : string.Empty; theEntity.EMAIL = !dr.IsDBNull(6) ? dr.GetValue(6).ToString() : string.Empty; theEntity.PASSWORDQUESTION = !dr.IsDBNull(7) ? dr.GetValue(7).ToString() : string.Empty; theEntity.PASSWORDANSWER = !dr.IsDBNull(8) ? dr.GetValue(8).ToString() : string.Empty; theEntity.ACCESSBLOCKED = !dr.IsDBNull(9) ? dr.GetValue(9).ToString() : string.Empty; theEntity.DEFAULTMODULEID = !dr.IsDBNull(10) ? dr.GetValue(10).ToString() : string.Empty; return(theEntity); }
protected override EntityBase CreateAndBuildEntity(DataHelper.Framework.SafeDataReader dr) { M_COMPLITION theEntity = new M_COMPLITION(); theEntity.PK_ID = !dr.IsDBNull(0) ? dr.GetValue(0).ToString() : string.Empty; theEntity.JOB_CARD_ID = !dr.IsDBNull(1) ? dr.GetValue(1).ToString() : string.Empty; theEntity.C_DATE = !dr.IsDBNull(2) ? dr.GetValue(2).ToString() : string.Empty; theEntity.C_DAY = !dr.IsDBNull(3) ? dr.GetValue(3).ToString() : string.Empty; theEntity.C_MONTH = !dr.IsDBNull(4) ? dr.GetValue(4).ToString() : string.Empty; theEntity.C_YEAR = !dr.IsDBNull(5) ? dr.GetValue(5).ToString() : string.Empty; theEntity.C_FY = !dr.IsDBNull(6) ? dr.GetValue(6).ToString() : string.Empty; theEntity.SUPERVISOR_ID = !dr.IsDBNull(7) ? dr.GetValue(7).ToString() : string.Empty; theEntity.DEPARTMENTHEAD_ID = !dr.IsDBNull(8) ? dr.GetValue(8).ToString() : string.Empty; theEntity.D_DATE = !dr.IsDBNull(9) ? dr.GetValue(9).ToString() : string.Empty; return(theEntity); }
protected override EntityBase CreateAndBuildEntity(DataHelper.Framework.SafeDataReader dr) { PRODUCT_DEMAND_DETAIL theEntity = new PRODUCT_DEMAND_DETAIL(); theEntity.PK_ID = !dr.IsDBNull(0) ? dr.GetValue(0).ToString() : string.Empty; theEntity.PRODUCT_DEMAND_ID = !dr.IsDBNull(1) ? dr.GetValue(1).ToString() : string.Empty; theEntity.SNO = !dr.IsDBNull(2) ? dr.GetValue(2).ToString() : string.Empty; theEntity.PRODUCT_ID = !dr.IsDBNull(3) ? dr.GetValue(3).ToString() : string.Empty; theEntity.REQUEST_QTY = !dr.IsDBNull(4) ? dr.GetValue(4).ToString() : string.Empty; theEntity.UNIT = !dr.IsDBNull(5) ? dr.GetValue(5).ToString() : string.Empty; theEntity.ISSUE_QTY = !dr.IsDBNull(6) ? dr.GetValue(6).ToString() : string.Empty; theEntity.LEDGER_PAGE_NO = !dr.IsDBNull(7) ? dr.GetValue(7).ToString() : string.Empty; theEntity.REMARKS = !dr.IsDBNull(8) ? dr.GetValue(8).ToString() : string.Empty; theEntity.APPROVE_QTY = !dr.IsDBNull(9) ? dr.GetValue(9).ToString() : string.Empty; return(theEntity); }
protected override EntityBase CreateAndBuildEntity(DataHelper.Framework.SafeDataReader dr) { VW_ORGH theEntity = new VW_ORGH(); theEntity.ORG_STRUCTURE_CODE = !dr.IsDBNull(0) ? dr.GetValue(0).ToString() : string.Empty; theEntity.ORG_STRUCTURE_NAME = !dr.IsDBNull(1) ? dr.GetValue(1).ToString() : string.Empty; theEntity.ORG_STRUCTURE_NAME_DEVNAGARI = !dr.IsDBNull(2) ? dr.GetValue(2).ToString() : string.Empty; theEntity.UPPER_ORG_STRUCTURE_CODE = !dr.IsDBNull(3) ? dr.GetValue(3).ToString() : string.Empty; theEntity.HIERARCHY_NAME = !dr.IsDBNull(4) ? dr.GetValue(4).ToString() : string.Empty; theEntity.ADDRESS = !dr.IsDBNull(5) ? dr.GetValue(5).ToString() : string.Empty; theEntity.LOCATION_CODE = !dr.IsDBNull(6) ? dr.GetValue(6).ToString() : string.Empty; theEntity.TELEPHONE_NO = !dr.IsDBNull(7) ? dr.GetValue(7).ToString() : string.Empty; theEntity.GRADE_CODE = !dr.IsDBNull(8) ? dr.GetValue(8).ToString() : string.Empty; theEntity.ORG_UNIT_TYPE = !dr.IsDBNull(9) ? dr.GetValue(9).ToString() : string.Empty; theEntity.EFFECTIVE_DATE_AD = !dr.IsDBNull(10) ? dr.GetValue(10).ToString() : string.Empty; theEntity.EFFECTIVE_DATE_BS = !dr.IsDBNull(11) ? dr.GetValue(11).ToString() : string.Empty; theEntity.COLLAPSE_DATE_AD = !dr.IsDBNull(12) ? dr.GetValue(12).ToString() : string.Empty; theEntity.COLLAPSE_DATE_BS = !dr.IsDBNull(13) ? dr.GetValue(13).ToString() : string.Empty; theEntity.DESCRIPTION = !dr.IsDBNull(14) ? dr.GetValue(14).ToString() : string.Empty; theEntity.ORDER_DATE_AD = !dr.IsDBNull(15) ? dr.GetValue(15).ToString() : string.Empty; theEntity.ORDER_DATE_BS = !dr.IsDBNull(16) ? dr.GetValue(16).ToString() : string.Empty; theEntity.ORDER_NO = !dr.IsDBNull(17) ? dr.GetValue(17).ToString() : string.Empty; theEntity.AUTHORISED_BY = !dr.IsDBNull(18) ? dr.GetValue(18).ToString() : string.Empty; theEntity.AUTHORISED_POSITION_CODE = !dr.IsDBNull(19) ? dr.GetValue(19).ToString() : string.Empty; theEntity.AUTHORISED_ORGANIZATION_CODE = !dr.IsDBNull(20) ? dr.GetValue(20).ToString() : string.Empty; theEntity.PREPARED_ON = !dr.IsDBNull(21) ? dr.GetValue(21).ToString() : string.Empty; theEntity.PREPARED_BY = !dr.IsDBNull(22) ? dr.GetValue(22).ToString() : string.Empty; theEntity.DARBANDI_DEFINED_AS = !dr.IsDBNull(23) ? dr.GetValue(23).ToString() : string.Empty; theEntity.ORG_TYPE_CODE = !dr.IsDBNull(24) ? dr.GetValue(24).ToString() : string.Empty; return(theEntity); }
protected override EntityBase CreateAndBuildEntity(DataHelper.Framework.SafeDataReader dr) { GetCalendar theEntity = new GetCalendar(); theEntity.DAYCOUNT = !dr.IsDBNull(0) ? dr.GetValue(0).ToString() : string.Empty; theEntity.FIRSTDAY = !dr.IsDBNull(1) ? dr.GetValue(1).ToString() : string.Empty; return(theEntity); }
protected override EntityBase CreateAndBuildEntity(DataHelper.Framework.SafeDataReader dr) { VEHICLE_USER theEntity = new VEHICLE_USER(); theEntity.PK_ID = !dr.IsDBNull(0) ? dr.GetValue(0).ToString() : string.Empty; theEntity.VEHICLEUSER = !dr.IsDBNull(1) ? dr.GetValue(1).ToString() : string.Empty; return(theEntity); }
protected override EntityBase CreateAndBuildEntity(DataHelper.Framework.SafeDataReader dr) { USERGROUP theEntity = new USERGROUP(); theEntity.USERGROUPID = !dr.IsDBNull(0) ? dr.GetValue(0).ToString() : string.Empty; theEntity.GROUPID = !dr.IsDBNull(1) ? dr.GetValue(1).ToString() : string.Empty; theEntity.USERID = !dr.IsDBNull(2) ? dr.GetValue(2).ToString() : string.Empty; return(theEntity); }
protected override EntityBase CreateAndBuildEntity(DataHelper.Framework.SafeDataReader dr) { ACCESSORIES_GROUP theEntity = new ACCESSORIES_GROUP(); theEntity.PK_ID = !dr.IsDBNull(0) ? dr.GetValue(0).ToString() : string.Empty; theEntity.ACCESSORIESGROUP = !dr.IsDBNull(1) ? dr.GetValue(1).ToString() : string.Empty; return(theEntity); }
protected override EntityBase CreateAndBuildEntity(DataHelper.Framework.SafeDataReader dr) { BASE_STATION theEntity = new BASE_STATION(); theEntity.PK_ID = !dr.IsDBNull(0) ? dr.GetValue(0).ToString() : string.Empty; theEntity.BASESTATION = !dr.IsDBNull(1) ? dr.GetValue(1).ToString() : string.Empty; return(theEntity); }
protected override EntityBase CreateAndBuildEntity(DataHelper.Framework.SafeDataReader dr) { login_fiscal_year theEntity = new login_fiscal_year(); theEntity.FISCAL_YEAR = !dr.IsDBNull(0) ? dr.GetValue(0).ToString() : string.Empty; return(theEntity); }
protected override EntityBase CreateAndBuildEntity(DataHelper.Framework.SafeDataReader dr) { DISTRICT theEntity = new DISTRICT(); theEntity.PK_ID = !dr.IsDBNull(0) ? dr.GetValue(0).ToString() : string.Empty; theEntity.DISTRICT_NAME = !dr.IsDBNull(1) ? dr.GetValue(1).ToString() : string.Empty; return(theEntity); }
private EntityBase GetUserId(UserProfileEntity userProfile) { IDbDataParameter[] param = CreateSelectParameters(userProfile); DataHelper.Framework.SafeDataReader reader = new DataHelper.Framework.SafeDataReader(DataAccessHelper.ExecuteReader(ValidateCommand, System.Data.CommandType.StoredProcedure, param)); if (reader.Read()) { return(CreateAndBuildEntity(reader)); } return(userProfile); }
protected override EntityBase CreateAndBuildEntity(DataHelper.Framework.SafeDataReader dr) { FUEL_TYPE theEntity = new FUEL_TYPE(); theEntity.PK_ID = !dr.IsDBNull(0) ? dr.GetValue(0).ToString() : string.Empty; theEntity.FUELTYPE = !dr.IsDBNull(1) ? dr.GetValue(1).ToString() : string.Empty; return(theEntity); }
protected override EntityBase CreateAndBuildEntity(DataHelper.Framework.SafeDataReader dr) { VEHICLE_DISPATCH theEntity = new VEHICLE_DISPATCH(); theEntity.PK_ID = !dr.IsDBNull(0) ? dr.GetValue(0).ToString() : string.Empty; theEntity.DISPATCH_NUMBER = !dr.IsDBNull(1) ? dr.GetValue(1).ToString() : string.Empty; theEntity.VEHICLE_ID = !dr.IsDBNull(2) ? dr.GetValue(2).ToString() : string.Empty; theEntity.DRIVERS_ID = !dr.IsDBNull(3) ? dr.GetValue(3).ToString() : string.Empty; theEntity.DISPATCH_DAY = !dr.IsDBNull(4) ? dr.GetValue(4).ToString() : string.Empty; theEntity.DISPATCH_MONTH = !dr.IsDBNull(5) ? dr.GetValue(5).ToString() : string.Empty; theEntity.DISPATCH_YEAR = !dr.IsDBNull(6) ? dr.GetValue(6).ToString() : string.Empty; theEntity.DISPATCH_DATE = !dr.IsDBNull(7) ? dr.GetValue(7).ToString() : string.Empty; theEntity.DISPATCH_TIME = !dr.IsDBNull(8) ? dr.GetValue(8).ToString() : string.Empty; theEntity.DISPATCH_ODOMETER = !dr.IsDBNull(9) ? dr.GetValue(9).ToString() : string.Empty; theEntity.RETURN_DAY = !dr.IsDBNull(10) ? dr.GetValue(10).ToString() : string.Empty; theEntity.RETURN_MONTH = !dr.IsDBNull(11) ? dr.GetValue(11).ToString() : string.Empty; theEntity.RETURN_YEAR = !dr.IsDBNull(12) ? dr.GetValue(12).ToString() : string.Empty; theEntity.RETURN_DATE = !dr.IsDBNull(13) ? dr.GetValue(13).ToString() : string.Empty; theEntity.RETURN_TIME = !dr.IsDBNull(14) ? dr.GetValue(14).ToString() : string.Empty; theEntity.DESTINATION = !dr.IsDBNull(15) ? dr.GetValue(15).ToString() : string.Empty; theEntity.PARKING_PLACE = !dr.IsDBNull(16) ? dr.GetValue(16).ToString() : string.Empty; theEntity.SCHEDULED_MAINTAIN_DATE = !dr.IsDBNull(17) ? dr.GetValue(17).ToString() : string.Empty; theEntity.SCHEDULED_MAINTAIN_MILAGE = !dr.IsDBNull(18) ? dr.GetValue(18).ToString() : string.Empty; theEntity.OUTSTANDING_REPAIR = !dr.IsDBNull(19) ? dr.GetValue(19).ToString() : string.Empty; theEntity.UNIT_PERSON_STATUS = !dr.IsDBNull(20) ? dr.GetValue(20).ToString() : string.Empty; theEntity.UNIT_PERSON = !dr.IsDBNull(21) ? dr.GetValue(21).ToString() : string.Empty; theEntity.TEMPORARY_PERMANENT = !dr.IsDBNull(22) ? dr.GetValue(22).ToString() : string.Empty; theEntity.OFFICE_CODE = !dr.IsDBNull(23) ? dr.GetValue(23).ToString() : string.Empty; return(theEntity); }
protected override EntityBase CreateAndBuildEntity(DataHelper.Framework.SafeDataReader dr) { VEHICLE_DAKHILA theEntity = new VEHICLE_DAKHILA(); theEntity.PK_ID = !dr.IsDBNull(0) ? dr.GetValue(0).ToString() : string.Empty; theEntity.DAKHILA_NO = !dr.IsDBNull(1) ? dr.GetValue(1).ToString() : string.Empty; theEntity.PURCHASE_ORDER_ID = !dr.IsDBNull(2) ? dr.GetValue(2).ToString() : string.Empty; theEntity.DAKHILA_DAY = !dr.IsDBNull(3) ? dr.GetValue(3).ToString() : string.Empty; theEntity.DAKHILA_MONTH = !dr.IsDBNull(4) ? dr.GetValue(4).ToString() : string.Empty; theEntity.DAKHILA_YEAR = !dr.IsDBNull(5) ? dr.GetValue(5).ToString() : string.Empty; theEntity.DAKHILA_DATE = !dr.IsDBNull(6) ? dr.GetValue(6).ToString() : string.Empty; theEntity.DAKHILA_FISCALYEAR = !dr.IsDBNull(7) ? dr.GetValue(7).ToString() : string.Empty; theEntity.BILL_NO = !dr.IsDBNull(8) ? dr.GetValue(8).ToString() : string.Empty; theEntity.BILL_DAY = !dr.IsDBNull(9) ? dr.GetValue(9).ToString() : string.Empty; theEntity.BILL_MONTH = !dr.IsDBNull(10) ? dr.GetValue(10).ToString() : string.Empty; theEntity.BILL_YEAR = !dr.IsDBNull(11) ? dr.GetValue(11).ToString() : string.Empty; theEntity.SUPPLIER_ID = !dr.IsDBNull(12) ? dr.GetValue(12).ToString() : string.Empty; theEntity.VAT_PERCENT = !dr.IsDBNull(13) ? dr.GetValue(13).ToString() : string.Empty; theEntity.VAT = !dr.IsDBNull(14) ? dr.GetValue(14).ToString() : string.Empty; theEntity.TOTAL = !dr.IsDBNull(15) ? dr.GetValue(15).ToString() : string.Empty; theEntity.GRAND_TOTAL = !dr.IsDBNull(16) ? dr.GetValue(16).ToString() : string.Empty; theEntity.PREPARE_BY = !dr.IsDBNull(17) ? dr.GetValue(17).ToString() : string.Empty; theEntity.CHECK_BY = !dr.IsDBNull(18) ? dr.GetValue(18).ToString() : string.Empty; theEntity.APPROVE_BY = !dr.IsDBNull(19) ? dr.GetValue(19).ToString() : string.Empty; theEntity.PREPARE_DATE = !dr.IsDBNull(20) ? dr.GetValue(20).ToString() : string.Empty; theEntity.CHECK_DATE = !dr.IsDBNull(21) ? dr.GetValue(21).ToString() : string.Empty; theEntity.APPROVE_DATE = !dr.IsDBNull(22) ? dr.GetValue(22).ToString() : string.Empty; theEntity.OFFICE_CODE = !dr.IsDBNull(23) ? dr.GetValue(23).ToString() : string.Empty; return(theEntity); }