C#

Fezih5 wrote:

C#

PdfWriter pdfWriter = PdfWriter.GetInstance(document, new FileStream(path + originalFileName, FileMode.Append));

SELECT * FROM MyTable WHERE StreetAddress = 'Baker's Wood'

SELECT * FROM MyTable WHERE StreetAddress = 'x';DROP TABLE MyTable;--'

SELECT * FROM MyTable WHERE StreetAddress = 'x';

DROP TABLE MyTable;

--'

StringBuilder sb = new StringBuilder("INSERT INTO table VALUES (");
foreach (object value in ((IDictionary<string, object>)rec).Values)
{
    if (command.Parameters.Count != 0) sb.Append(", ");
    string name = "@V" + command.Parameters.Count;
    command.Parameters.AddWithValue(name, value);
    sb.Append(name);
}
sb.Append(");");

command.CommandText = sb.ToString();

StringBuilder columnsList = new StringBuilder();
StringBuilder valuesList = new StringBuilder();
foreach (KeyValuePair<string, object> item in (IDictionary<string, object>)rec)
{
    if (columnsList.Length != 0) columnsList.Append(", ");
    if (valuesList.Length != 0) valuesList.Append(", ");
    
    string name = "@" + item.Key;
    command.Parameters.AddWithValue(name, item.Value);
    columnsList.Append(item.Key);
    valuesList.Append(name);
}

command.CommandText = "INSERT INTO table (" + columnsList + ") VALUES (" + valuesList + ");";

if (NameVar.Length > 12);

for(;;)
{
if (CheckBitData(5, 965) == true)                                   //Checking Read Request from File to Mac
                {
                    string[] TypeofProcess = { "P", "V", "F", "C", "Q" };
                    int i = 0;
                    foreach (string p in TypeofProcess)
                    {
                        string FileToFetch1 = getFileName(p);
                        if (File.Exists(FileToFetch1))
                        {
                            using (StreamReader r = File.OpenText(FileToFetch1))
                            {
                                ReadAndDumpToCNC(r, 36000+i, 31000+i, 41000+i);
                            }
                        }
                        else
                        {
                            MessageBox.Show(p + "File Not Found...!!!!");
                        }
                        i = i + 1000;
                    }

                    MakeZeroPMC(5, 965);
                }

                if (CheckBitData(5, 967) == true)                                   // Data File Generation using History Data
                {
                    ManipulateArray(31000, 31999, 41000, 36000, 11075, 11076);      //(readStart,readEnd,wrStart1,wrStart2,MaxVar,MinVar)
                    MakeMasterData("Power", "Max", 41000, 41999);
                    MakeMasterData("Power", "Min", 36000, 36999);
                    ManipulateArray(32000, 32999, 42000, 37000, 11077, 11078);
                    MakeMasterData("Voltage", "Max", 42000, 42999);
                    MakeMasterData("Voltage", "Min", 37000, 37999);
                    ManipulateArray(33000, 33999, 43000, 38000, 11079, 11080);
                    MakeMasterData("Freq", "Max", 43000, 43999);
                    MakeMasterData("Freq", "Min", 38000, 38999);
                    ManipulateArray(34000, 34999, 44000, 39000, 11081, 11082);
                    MakeMasterData("Curr", "Max", 44000, 44999);
                    MakeMasterData("Curr", "Min", 39000, 39999);
                    ManipulateArray(35000, 35999, 45000, 40000, 11083, 11084);
                    MakeMasterData("Quench", "Max", 45000, 45999);
                    MakeMasterData("Quench", "Min", 40000, 40999);
                    MakeZeroPMC(5, 967);
                }

                if (CheckBitData(5, 968) == true)                                   
                {
                    DumpMasterDataG1V();
                    MakeZeroPMC(5, 968);
                }
                if (CheckBitData(5, 969) == true)                                   
                {
                    DumpMasterDataG1Q();
                    MakeZeroPMC(5, 969);
                }
                if (CheckBitData(5, 970) == true)                                   
                {
                    DumpMasterDataG2V();
                    MakeZeroPMC(5, 970);
                }
                if (CheckBitData(5, 971) == true)                                   
                {
                    DumpMasterDataG2Q();
                    MakeZeroPMC(5, 971);
                }
            
                System.Threading.Thread.Sleep(10);
            }

for(;;)

break