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