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);
}
