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