public void createTaxRec(int orgid, string codename, string codedesc, string itmTyp, bool isEnbld, int taxAcntID , int expnsAcntID, int rvnuAcntID, string sqlFormular, bool isTxRcvrbl, int txExpAccID, int prchDscAccID, int chrgExpAccID, bool isWthHldng) { string dateStr = cmnCde.getDB_Date_time(); string insSQL = "INSERT INTO scm.scm_tax_codes(" + "code_name, code_desc, created_by, creation_date, last_update_by, " + "last_update_date, itm_type, is_enabled, taxes_payables_accnt_id, " + "dscount_expns_accnt_id, " + "chrge_revnu_accnt_id, " + @"org_id, sql_formular, is_recovrbl_tax, tax_expense_accnt_id, prchs_dscnt_accnt_id, chrge_expns_accnt_id, is_withldng_tax) " + "VALUES ('" + codename.Replace("'", "''") + "', '" + codedesc.Replace("'", "''") + "', " + cmnCde.User_id + ", '" + dateStr + "', " + cmnCde.User_id + ", '" + dateStr + "', '" + itmTyp.Replace("'", "''") + "', '" + cmnCde.cnvrtBoolToBitStr(isEnbld) + "', " + taxAcntID + ", " + expnsAcntID + ", " + rvnuAcntID + ", " + orgid + ", '" + sqlFormular.Replace("'", "''") + "', '" + cmnCde.cnvrtBoolToBitStr(isTxRcvrbl) + "', " + txExpAccID + ", " + prchDscAccID + ", " + chrgExpAccID + ", '" + cmnCde.cnvrtBoolToBitStr(isWthHldng) + "')"; cmnCde.insertDataNoParams(insSQL); }
public void createPssblValsForLov(int lovID, string pssblVal, string pssblValDesc, bool isEnbld, string allwd) { string dateStr = cmnCde.getDB_Date_time(); string sqlStr = "INSERT INTO gst.gen_stp_lov_values(" + "value_list_id, pssbl_value, pssbl_value_desc, " + "created_by, creation_date, last_update_by, last_update_date, is_enabled, allowed_org_ids) " + "VALUES (" + lovID + ", '" + pssblVal.Replace("'", "''") + "', '" + pssblValDesc.Replace("'", "''") + "', " + cmnCde.User_id + ", '" + dateStr + "', " + cmnCde.User_id + ", '" + dateStr + "', '" + cmnCde.cnvrtBoolToBitStr(isEnbld) + "', '" + allwd.Replace("'", "''") + "')"; cmnCde.insertDataNoParams(sqlStr); }