public static MS_UDW_CUSTOMERS get_customer(string code) { var db = new SibaModel(); return((from customer in db.MS_UDW_CUSTOMERS where customer.CUS_CODE == code select customer).ToList().Select(c => new MS_UDW_CUSTOMERS { CUS_CODE = c.CUS_CODE, CUS_TYPE_CODE = c.CUS_TYPE_CODE, CUS_TITLE = c.CUS_TITLE, CUS_FIRST_NAME = c.CUS_FIRST_NAME, CUS_LAST_NAME = c.CUS_LAST_NAME, CUS_OTHER_NAME = c.CUS_OTHER_NAME, CUS_OFFICIAL_NAME = c.CUS_OFFICIAL_NAME, CUS_ADDRS1 = c.CUS_ADDRS1, CUS_ADDRS2 = c.CUS_ADDRS2, CUS_BANK_NAME = c.CUS_BANK_NAME, CUS_ACC_NUM = c.CUS_ACC_NUM, CUS_GENDER = c.CUS_GENDER, CUS_DOB = c.CUS_DOB, CUS_EMAIL = c.CUS_EMAIL, CUS_PROFESSION = c.CUS_PROFESSION, CUS_PHONE1 = c.CUS_PHONE1, CUS_MOBILE = c.CUS_MOBILE, CUS_PIN_NO = c.CUS_PIN_NO, CUS_BANK_BRANCH = c.CUS_BANK_BRANCH, CUS_CRTE_BY = c.CUS_CRTE_BY, CUS_CRTE_DATE = c.CUS_CRTE_DATE, CUS_MOD_BY = c.CUS_MOD_BY, CUS_MOD_DATE = c.CUS_MOD_DATE, CUS_STATUS = c.CUS_STATUS, MS_SYS_CUST_TYPES = CustomerTypesMdl.get_customertype(c.CUS_TYPE_CODE) }).Single()); }
public static MS_SYS_INTERMEDIARY get_intermediary(string code) { var db = new SibaModel(); try { return((from interm in db.MS_SYS_INTERMEDIARY where interm.INT_CODE == code select interm).ToList().Select(i => new MS_SYS_INTERMEDIARY { INT_CODE = i.INT_CODE, INT_CMP_CODE = i.INT_CMP_CODE, INT_OFF_CODE = i.INT_OFF_CODE, INT_OFFICIAL_NAME = i.INT_OFFICIAL_NAME, INT_POSTAL_ADDRS = i.INT_POSTAL_ADDRS, INT_HOME_ADDRS = i.INT_HOME_ADDRS, INT_PHONE = i.INT_PHONE, INT_CTP_CODE = i.INT_CTP_CODE, INT_PHONE1 = i.INT_PHONE1, INT_MOBILE = i.INT_MOBILE, INT_AREA_NAME = i.INT_AREA_NAME, INT_CONTACT_PERS = i.INT_CONTACT_PERS, INT_EMAIL = i.INT_EMAIL, INT_FAX = i.INT_FAX, INT_BANK_NUMBER = i.INT_BANK_NUMBER, INT_BANK_NAME = i.INT_BANK_NAME, INT_BANK_BRANCH = i.INT_BANK_BRANCH, INT_CITY_NAME = i.INT_CITY_NAME, INT_GENDER = i.INT_GENDER, INT_ID1_NO = i.INT_ID1_NO, INT_ID1_TYPE = i.INT_ID1_TYPE, INT_ID2_NO = i.INT_ID2_NO, INT_ID2_TYPE = i.INT_ID2_TYPE, INT_TIN_NO = i.INT_TIN_NO, INT_REG_NO = i.INT_REG_NO, INT_CRTE_BY = i.INT_CRTE_BY, INT_CRTE_DATE = i.INT_CRTE_DATE, INT_MOD_BY = i.INT_MOD_BY, INT_MOD_DATE = i.INT_MOD_DATE, INT_STATUS = i.INT_STATUS, MS_SYS_CUST_TYPES = CustomerTypesMdl.get_customertype(i.INT_CTP_CODE) }).Single()); } catch (Exception e) { var exc = e; return(null); } }