public ArrayList GetList(string Condition) { ArrayList arrChangePrimaryBusList = new ArrayList(); ChangePrimaryBus ChangePrimaryBusObj; try { DataTable dtChangePrimaryBus = DH.ExecuteDataTable("select " + strFieldsToSelect + " from " + strTableName + " Where " + Condition); foreach (DataRow dr in dtChangePrimaryBus.Rows) { ChangePrimaryBusObj = new ChangePrimaryBus(); if (dr["ID"] != DBNull.Value) { ChangePrimaryBusObj.ID = int.Parse(dr["ID"].ToString()); } if (dr["MSISDN"] != DBNull.Value) { ChangePrimaryBusObj.MSISDN = dr["MSISDN"].ToString(); } if (dr["receive_date"] != DBNull.Value) { ChangePrimaryBusObj.receive_date = dr["receive_date"].ToString(); } if (dr["SMS_content"] != DBNull.Value) { ChangePrimaryBusObj.SMS_content = dr["SMS_content"].ToString(); } if (dr["SMS_Options"] != DBNull.Value) { ChangePrimaryBusObj.SMS_Options = dr["SMS_Options"].ToString(); } if (dr["Reply_Option"] != DBNull.Value) { ChangePrimaryBusObj.Reply_Option = dr["Reply_Option"].ToString(); } if (dr["status"] != DBNull.Value) { ChangePrimaryBusObj.status = int.Parse(dr["status"].ToString()); } if (dr["error_desc"] != DBNull.Value) { ChangePrimaryBusObj.error_desc = dr["error_desc"].ToString(); } if (dr["request_type"] != DBNull.Value) { ChangePrimaryBusObj.request_type = int.Parse(dr["request_type"].ToString()); } arrChangePrimaryBusList.Add(ChangePrimaryBusObj); } } catch (Exception ex) { throw ex; } return(arrChangePrimaryBusList); }
public ArrayList GetList(string Condition) { ArrayList arrVAT_SHOP_ECAREList = new ArrayList(); VAT_SHOP_ECARE VAT_SHOP_ECAREObj; try { DataTable dtVAT_SHOP_ECARE = DH.ExecuteDataTable("select " + strFieldsToSelect + " from " + strTableName + " Where " + Condition); foreach (DataRow dr in dtVAT_SHOP_ECARE.Rows) { VAT_SHOP_ECAREObj = new VAT_SHOP_ECARE(); if (dr["REQ_XML"] != DBNull.Value) { VAT_SHOP_ECAREObj.REQ_XML = dr["REQ_XML"].ToString(); } if (dr["SEQ_ID"] != DBNull.Value) { VAT_SHOP_ECAREObj.SEQ_ID = dr["SEQ_ID"].ToString(); } if (dr["OFFER_NAME"] != DBNull.Value) { VAT_SHOP_ECAREObj.OFFER_NAME = dr["OFFER_NAME"].ToString(); } if (dr["STATUS"] != DBNull.Value) { VAT_SHOP_ECAREObj.STATUS = int.Parse(dr["STATUS"].ToString()); } if (dr["CHANNEL"] != DBNull.Value) { VAT_SHOP_ECAREObj.CHANNEL = dr["CHANNEL"].ToString(); } if (dr["VAT_AMOUNT"] != DBNull.Value) { VAT_SHOP_ECAREObj.VAT_AMOUNT = decimal.Parse(dr["VAT_AMOUNT"].ToString()); } if (dr["RECHARGE_AMOUNT"] != DBNull.Value) { VAT_SHOP_ECAREObj.RECHARGE_AMOUNT = int.Parse(dr["RECHARGE_AMOUNT"].ToString()); } if (dr["MSISDN"] != DBNull.Value) { VAT_SHOP_ECAREObj.MSISDN = dr["MSISDN"].ToString(); } if (dr["TRANSDATE"] != DBNull.Value) { VAT_SHOP_ECAREObj.TRANSDATE = dr["TRANSDATE"].ToString(); } if (dr["ResultDesc"] != DBNull.Value) { VAT_SHOP_ECAREObj.ResultDesc = dr["ResultDesc"].ToString(); } if (dr["TRACK_ID"] != DBNull.Value) { VAT_SHOP_ECAREObj.TRACK_ID = dr["TRACK_ID"].ToString(); } arrVAT_SHOP_ECAREList.Add(VAT_SHOP_ECAREObj); } } catch (Exception ex) { throw ex; } return(arrVAT_SHOP_ECAREList); }