public static DataSet DL_ExecuteQuerylocal(string strQuery, string[] arr_values) { try { ____logconfig.Log_Write(____logconfig.LogLevel.INFO, 30, "DL:DL_ExecuteQuery1::function starts here."); ____logconfig.Log_Write(____logconfig.LogLevel.DB, 31, "DL:DL_ExecuteQuery1::Query received:" + strQuery); string[] arr_params = getQueryParameters(strQuery); MSParams msparam; MySqlParameter[] mysqlparams; mysqlparams = new MySqlParameter[arr_params.Length]; for (int i = 0; i < arr_params.Length; i++) { msparam = MSParams.getMSParams(arr_params[i]); mysqlparams[i] = new MySqlParameter(arr_params[i], msparam.DbType, msparam.ParamSize); mysqlparams[i].Value = arr_values[i]; } //return MySqlHelper.ExecuteDataset(MSCon.ConnectionString, strQuery, mysqlparams); return(MySqlHelper.ExecuteDataset(MSCon.ConnectionStringlocalhost, strQuery, mysqlparams)); } catch (Exception exc) { // logWrt.WriteError_File("----------- " + DateTime.Now.GetDateTimeFormats()[39] + " -----------\n" + strQuery + "\n" + exc.ToString() + "\n -------------------END-------------- \n\n"); ____logconfig.Error_Write(____logconfig.LogLevel.EXC, 48, exc.Message.ToString(), "DL"); return(null); } }
public static int DL_ExecuteNonQuery(string strQuery, string[] arr_values, string MSConParam) { try { ____logconfig.Log_Write(____logconfig.LogLevel.INFO, 166, "DL:DL_ExecuteNonQuery::function starts here."); ____logconfig.Log_Write(____logconfig.LogLevel.DB, 167, "DL:DL_ExecuteNonQuery::Query received:" + strQuery); string[] arr_params = getQueryParameters(strQuery); MSParams msparam; MySqlParameter[] mysqlparams = new MySqlParameter[arr_params.Length]; for (int i = 0; i < arr_params.Length; i++) { msparam = MSParams.getMSParams(arr_params[i]); mysqlparams[i] = new MySqlParameter(arr_params[i], msparam.DbType, msparam.ParamSize); mysqlparams[i].Value = arr_values[i]; } return(MySqlHelper.ExecuteNonQuery(MSConParam, strQuery, mysqlparams)); } catch (Exception exc) { //logWrt.WriteError_File("----------- " + DateTime.Now.GetDateTimeFormats()[39] + " -----------\n" + strQuery + "\n" + exc.ToString() + "\n -------------------END-------------- \n\n"); ____logconfig.Error_Write(____logconfig.LogLevel.EXC, 182, exc.Message.ToString(), "DL"); return(0); } }