private void loadVendor() { string sql = "SELECT VENDOR_CODE, VENDOR_NAME " + "FROM VENDOR " + "WHERE VENDOR_CODE = :vc"; OracleCommand cmd = new OracleCommand(sql); cmd.Parameters.AddWithValue("vc", this.vendor_code); List <System.Object[]> raw = OracleHandler.execRetrieveReadQuery(cmd); //OracleDataReader odr; //odr = OracleHandler.execReadQuery(cmd); //if (odr == null || !odr.HasRows) if (raw.Count == 0) { this.vendor_code = "0"; this.vendor_name = "VENDOR NOT FOUND"; return; } //while (odr.Read()) foreach (System.Object[] a_row in raw) { this.vendor_name = a_row[1].ToString(); } }
public void loadSettings_static() { string sql = "SELECT POS_STORE_NAME,POS_ADDRESS_LINE_1,POS_ADDRESS_LINE_2 " + "FROM POS_STORE_SETTINGS " + "WHERE POS_LOKASI = :loc"; OracleCommand cmd = new OracleCommand(); cmd.CommandType = CommandType.Text; cmd.CommandText = sql; cmd.Parameters.AddWithValue("loc", this.store_location); List <System.Object[]> raw = OracleHandler.execRetrieveReadQuery(cmd); //OracleDataReader odr; //odr = OracleHandler.execReadQuery(cmd); //if (odr==null) // return; //while (odr.Read()) foreach (System.Object[] a_row in raw) { this.store_name = a_row[0].ToString(); this.store_address1 = a_row[1].ToString(); this.store_address2 = a_row[2].ToString(); } //odr.Dispose(); }
private bool getVendorCategoryItems() { bool rc = true; string sql = "SELECT ERP.ITEM.ITEM_CODE, ERP.ITEM.ITEM_TYPE, ERP.ITEM.ITEM_NAME, ERP.ITEM.VENDOR_CODE, ERP.CODES.DESCRIPTION, ERP.CODES.CODE, ERP.VENDOR.VENDOR_CODE AS EXPR1, " + "ERP.VENDOR.VENDOR_NAME, ERP.CODES.KIND " + "FROM ERP.ITEM INNER JOIN " + "ERP.VENDOR ON ERP.ITEM.VENDOR_CODE = ERP.VENDOR.VENDOR_CODE INNER JOIN " + "ERP.CODES ON ERP.ITEM.CATEGORY = ERP.CODES.CODE " + "WHERE (ERP.VENDOR.VENDOR_CODE = :vc) AND (ERP.CODES.KIND = 'ITEM_CATEGORY') " + "ORDER BY ERP.CODES.CODE, ERP.ITEM.ITEM_CODE"; OracleCommand cmd = new OracleCommand(sql); cmd.Parameters.AddWithValue("vc", this.vendor_code); //OracleDataReader odr; //odr = OracleHandler.execReadQuery(cmd); //if (odr == null) // rc=false; List <System.Object[]> raw = OracleHandler.execRetrieveReadQuery(cmd); if (raw.Count == 0) { return(false); } //bool first = true; string last_cat = ""; vendor_categories vc_read = new vendor_categories(); vc_read.items = new List <category_items>(); //while (odr.Read()) //{ //Get the first row and preload last_cat System.Object[] first_row = raw[0]; last_cat = first_row[5].ToString(); vendor_name = first_row[7].ToString(); vc_read.category_code = first_row[5].ToString(); vc_read.category_description = first_row[4].ToString(); /*if (first) * { * this.vendor_name = odr.GetString(7); * //last_cat = odr.GetString[] * first = false; * }*/ foreach (System.Object[] a_row in raw) { string tmp_cat = a_row[5].ToString(); if (!(tmp_cat == last_cat)) //cat changed do add to cat list { this.vendor_item_list.Add(vc_read); vc_read = new vendor_categories(); //reset the input list vc_read.items = new List <category_items>(); last_cat = tmp_cat; vc_read.category_code = tmp_cat; vc_read.category_description = a_row[4].ToString(); } //Add in the items category_items ci = new category_items(); ci.item_code = a_row[0].ToString(); ci.item_name = a_row[2].ToString(); vc_read.items.Add(ci); } if (vc_read.items.Count > 0) { this.vendor_item_list.Add(vc_read); } /* * //position 5 is the category code, see if we need a new object * //string tmp_cat = odr.GetString(5); * if (!(tmp_cat == last_cat)) //category changed * { * if (last_cat != "")//Not the first time so write the category * { * this.vendor_item_list.Add(vc_read); * vc_read = new vendor_categories(); //reset the input list * vc_read.items = new List<category_items>(); * } * last_cat = tmp_cat; * vc_read.category_code = tmp_cat; * vc_read.category_description = odr.GetString(4); * } * category_items ci = new category_items(); * ci.item_code = odr.GetString(0); * ci.item_name = odr.GetString(2); * vc_read.items.Add(ci); * //Now fill in the item information * //}*/ return(rc); }