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