public string insertConfigProject(ConfigProjectData dataInsert)
{
string response = "";
ConnectDB db = new ConnectDB();
SqlDataSource oracleObj = db.ConnectionOracle();
string sql = "Insert Into PROJECT_CONFIG(PROJECT_CODE,TAX_ID,SERVICE_CODE,BANK_CODE,BANK_CHARG) Values('" + dataInsert.Project_Code + "','" + dataInsert.Tax_ID + "','" + dataInsert.Service_Code + "','" + dataInsert.Bank_Code + "'," + dataInsert.Bank_Charg + ")";
oracleObj.InsertCommand = sql;
try
{
if (oracleObj.Insert() == 1)
{
response = "OK";
}
}
catch (Exception e)
{
response = e.Message.ToString();
}
return(response);
}
public string updateConfigProject(ConfigProjectData dataInsert)
{
string response = "";
ConnectDB db = new ConnectDB();
SqlDataSource oracleObj = db.ConnectionOracle();
string sql = "Update PROJECT_CONFIG Set TAX_ID='" + dataInsert.Tax_ID + "',SERVICE_CODE='" + dataInsert.Service_Code + "',BANK_CODE='" + dataInsert.Bank_Code + "',BANK_CHARG=" + dataInsert.Bank_Charg + " Where PROJECT_CODE='" + dataInsert.Project_Code + "'";
oracleObj.UpdateCommand = sql;
try
{
if (oracleObj.Update() == 1)
{
response = "OK";
}
}
catch (Exception e)
{
response = e.Message.ToString();
}
return(response);
}
public ConfigProjectData getConfigProjct(string project_code)
{
ConfigProjectData configProject_data = new ConfigProjectData();
ConnectDB db = new ConnectDB();
SqlDataSource oracleObj = db.ConnectionOracle();
oracleObj.SelectCommand = "Select * From PROJECT_CONFIG Where PROJECT_CODE='" + project_code + "'";
DataView allData = (DataView)oracleObj.Select(DataSourceSelectArguments.Empty);
foreach (DataRowView rowData in allData)
{
configProject_data.Project_Code = rowData["PROJECT_CODE"].ToString();
configProject_data.Tax_ID = rowData["TAX_ID"].ToString();
configProject_data.Service_Code = rowData["SERVICE_CODE"].ToString();
configProject_data.Bank_Code = rowData["BANK_CODE"].ToString();
configProject_data.Bank_Charg = Convert.ToInt32(rowData["BANK_CHARG"].ToString());
}
return(configProject_data);
}
