private void btnAction_Click(object sender, EventArgs e)
{
UnBindFormData();
if (_ds == null)
{
_ds = new DataSet1();
AddNewOrder();
}
Button b = sender as Button;
switch (b.Name)
{
case "btnAddProduct":
AddNewProduct();
break;
case "btnSave":
SaveOrder();
BindFormData();
break;
case "btnFind":
LoadOrder();
BindFormData();
break;
case "btnNew":
NewOrder();
break;
default:
break;
}
}
public void actualizarTabla()
{
var adaptador = new productoTableAdapter();
DataSet1 datos = new DataSet1();
/* el metodo fillByProducto es un join creado en el data set
entre las tablas producto y categoria */
adaptador.FillByProducto(datos.producto);
dataGridView1.DataSource = datos.producto;
}
private void crystalReportViewer1_Load(object sender, EventArgs e)
{
if (con.State == ConnectionState.Open)
{
con.Close();
}
con.Open();
DataSet1 ds = new DataSet1();
SqlCommand cmd = con.CreateCommand();
cmd.CommandType = CommandType.Text;
cmd.CommandText = "select * from orderUser where id = " + j + "";
cmd.ExecuteNonQuery();
DataTable dt = new DataTable();
SqlDataAdapter da = new SqlDataAdapter(cmd);
da.Fill(ds.DataTable1);
SqlCommand cmd2 = con.CreateCommand();
cmd2.CommandType = CommandType.Text;
cmd2.CommandText = "select * from items where order_id = " + j + "";
cmd2.ExecuteNonQuery();
DataTable dt2 = new DataTable();
SqlDataAdapter da2 = new SqlDataAdapter(cmd2);
da2.Fill(ds.DataTable2);
da2.Fill(dt2);
tot = 0;
foreach (DataRow dr2 in dt2.Rows)
{
tot = tot + Convert.ToInt32(dr2["total"].ToString());
}
CrystalReport1 myreport = new CrystalReport1();
myreport.SetDataSource(ds);
myreport.SetParameterValue("total", tot.ToString());
crystalReportViewer1.ReportSource = myreport;
}
private void button1_Click(object sender, EventArgs e)
{
try
{
DataSet1 ds = new DataSet1();
SqlCommand cmd = con.CreateCommand();
cmd.CommandType = CommandType.Text;
cmd.CommandText = "select * from issue_books where books_return_date=''";
cmd.ExecuteNonQuery();
DataTable dt = new DataTable();
SqlDataAdapter da = new SqlDataAdapter(cmd);
da.Fill(ds.DataTable1);
CrystalReport1 myreport = new CrystalReport1();
myreport.SetDataSource(ds);
crystalReportViewer1.ReportSource = myreport;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void loadPrint()
{
if (salescommit == "1")
{
string q1 = "select itemCode,itemName,quantity,unitPrice,Amount,sReturn from Sales where salesNo='" + sl + "'";
string q2 = "select salesNo,sDate,total,salesType,creditCardPer,discountPer,vatAmount,grandTotal,receive,change from SalesSummary where salesNo='" + sl + "'";
try
{
aa.Open();
SqlDataAdapter da = new SqlDataAdapter();
da.SelectCommand = new SqlCommand(q1, aa);
DataSet1 mydataset = new DataSet1();
da.Fill(mydataset, "Sales");
da.Dispose();
SqlDataAdapter da2 = new SqlDataAdapter();
da2.SelectCommand = new SqlCommand(q2, aa);
da2.Fill(mydataset, "SalesSummary");
CrystalReport1 myreport = new CrystalReport1();
myreport.SetDataSource(mydataset);
PrintMemo pm = new PrintMemo();
pm.crystalReportViewer1.ReportSource = myreport;
pm.Show();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message.ToString(), "error!!!", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
finally
{
aa.Close();
}
}
else
{
MessageBox.Show("First commit sales by Clicking Save Button!", "error!!!", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
public void buscarProducto(int id, Producto p)
{
DataSet1 datos = new DataSet1();
adaProducto.Fill(datos.producto);
if (datos.producto.FindByid_producto(id) != null)
{
p.IdProducto = datos.producto.FindByid_producto(id).id_producto;
p.Nombre = datos.producto.FindByid_producto(id).nombre;
//MessageBox.Show("nombre de producto = " + p.Nombre);
p.Precio = datos.producto.FindByid_producto(id).precio;
p.Stock = datos.producto.FindByid_producto(id).stock;
p.IdCategoria = datos.producto.FindByid_producto(id).id_categoria;
}
else
{
p.IdProducto = 0;
p.Nombre = "";
p.Precio = 0;
p.Stock = 0;
p.IdCategoria = 0;
MessageBox.Show("NO EXISTE EL PRODUCTO CON ID = " + id);
}
}
private void button1_Click(object sender, EventArgs e)
{
string sPath, sFile;
string sText, sLineText, sTemp;
int iPos, iLen, iElement;
int iStartPos;
string sIDCode, exp;
bool bOut;
List <string> logLines = new List <string>();
List <string> shooterGroups = new List <string>();
//textBox1.Text = "c:\\dummy.txt";
sPath = tbLogFilePath.Text;
StreamReader streamReader = new StreamReader(sPath);
sText = streamReader.ReadToEnd();
streamReader.Close();
//string[] sIDCodes = new string[];
//string[] sIDCodes = new string[];
List <string> sIDCodes = new List <string>();
iElement = -1; //used for the array
DataSet1 ds = new DataSet1();
DataTable dt1 = ds.ID;
DataTable dt2 = ds.HIT;
DataTable dt3 = ds.TASKSTART;
DataTable dt4 = ds.TASKEND;
DataTable dt5 = ds.TARGET;
DataTable dt6 = ds.SPOTTER;
DataTable dt7 = ds.MALFUNCTION;
DataTable dt8 = ds.SCENARIOSTART;
DataTable dt9 = ds.TARGETEXPOSED;
DataTable dt10 = ds.TARGETCONCEALED;
DataTable dt11 = ds.GROUP;
//DataTable dt12 = ds.TABLE;
//DataTable dt13 = ds.TASK;
DataRow shooter_row;
DataRow hit_row;
DataRow task_start_row;
DataRow task_end_row;
DataRow target_row;
DataRow spotter_row;
DataRow malfunction_row;
DataRow scenario_start_row;
DataRow target_exposed_row;
DataRow target_concealed_row;
DataRow group_row;
//DataRow table_row;
//DataRow task_row;
DataRow[] foundRows;
// Initialize new rows
bOut = false;
while (bOut == false) //bOut is set to true when the log file parse is complete
{
iStartPos = sText.Length;
// Find the next line header
iStartPos = GetStartPos(sText, "SCENARIOSTART:", iStartPos);
iStartPos = GetStartPos(sText, "SHOOTER:", iStartPos);
iStartPos = GetStartPos(sText, "SPOTTER:", iStartPos);
iStartPos = GetStartPos(sText, "TASKSTART:", iStartPos);
iStartPos = GetStartPos(sText, "TASKEND:", iStartPos);
iStartPos = GetStartPos(sText, "HIT:", iStartPos);
iStartPos = GetStartPos(sText, "TARGET:", iStartPos);
iStartPos = GetStartPos(sText, "TARGETEXPOSED:", iStartPos);
iStartPos = GetStartPos(sText, "TARGETCONCEALED:", iStartPos);
iStartPos = GetStartPos(sText, "TASKABORT:", iStartPos);
iStartPos = GetStartPos(sText, "SCENARIOEND:", iStartPos);
iStartPos = GetStartPos(sText, "MALFUNCTION:", iStartPos);
iStartPos = GetStartPos(sText, "TABLE:", iStartPos);
iStartPos = GetStartPos(sText, "TASK:", iStartPos);
// Take off all characters before the header
iLen = sText.Length - iStartPos;
if (iLen > 0)
{
sText = Mid(sText, iStartPos, iLen);
}
// Find the end of the line (signified by ';')
iPos = sText.IndexOf(";", 0);
// At the end of the file so return a blank string
if (iPos < 0)
{
iPos = 0;
}
sLineText = sText.Substring(0, iPos);
iPos += 1;
iLen = sText.Length - iPos;
if (iLen > 0)
{
sText = Mid(sText, iPos, iLen);
}
else
{
bOut = true; // This means that we are at the end, so exit the while loop
}
//Get the header from the line (sLineText)
iPos = sLineText.IndexOf(":", 0);
if (iPos < 0)
{
bOut = true;
sTemp = "temp";
}
else
{
sTemp = sLineText.Substring(0, iPos);
sTemp = sTemp.ToUpper();
logLines.Add(sLineText);
}
}
//Pull out relevant lines of the log file to add to the database
// Add SCENARIOSTART
foreach (var line in logLines)
{
if (line.Contains("SCENARIOSTART:"))
{
scenario_start_row = dt8.NewRow();
String[] scenStartSplit = splitLine(line);
foreach (var item in scenStartSplit)
{
if (item.IndexOf("TIMESTAMP(", StringComparison.OrdinalIgnoreCase) >= 0)
{
scenario_start_row["TIMESTAMP"] = addTag(item);
}
else if (item.IndexOf("NAME(", StringComparison.OrdinalIgnoreCase) >= 0)
{
scenario_start_row["NAME"] = addTag(item);
}
}
dt8.Rows.Add(scenario_start_row);
}
}
// Add SHOOTER
foreach (var line in logLines)
{
if (line.Contains("SHOOTER:"))
{
shooter_row = dt1.NewRow();
spotter_row = dt6.NewRow();
String[] shooterSplit = splitLine(line);
String shooterType = "";
//If the shooterType is shooter add additional shooter attributes
if (line.IndexOf("TYPE(Shooter)", StringComparison.OrdinalIgnoreCase) >= 0)
{
shooterType = "shooter";
}
else if ((line.IndexOf("TYPE(Spotter)", StringComparison.OrdinalIgnoreCase) >= 0))
{
shooterType = "spotter";
}
foreach (var item in shooterSplit)
{
if (shooterType == "shooter" || shooterType == "")
{
// Look for indexes while ignoring case and add them to the data tables
if (item.IndexOf("FIRSTNAME(", StringComparison.OrdinalIgnoreCase) >= 0)
{
shooter_row["FIRSTNAME"] = addTag(item);
}
else if (item.IndexOf("LASTNAME(", StringComparison.OrdinalIgnoreCase) >= 0)
{
shooter_row["LASTNAME"] = addTag(item);
}
else if (item.IndexOf("GROUP(", StringComparison.OrdinalIgnoreCase) >= 0)
{
shooterGroups.Add(addTag(item));
shooter_row["GROUP"] = addTag(item);
}
else if (item.IndexOf("UNIT(", StringComparison.OrdinalIgnoreCase) >= 0)
{
shooter_row["UNIT"] = addTag(item);
}
else if (item.IndexOf("GROUP(", StringComparison.OrdinalIgnoreCase) >= 0)
{
shooter_row["GROUP"] = addTag(item);
}
else if (item.IndexOf("IDCODE(", StringComparison.OrdinalIgnoreCase) >= 0)
{
shooter_row["IDCode"] = addTag(item);
sIDCodes.Add(addTag(item)); // store this for opening multiple reports
}
else if (item.IndexOf("MIDDLE(", StringComparison.OrdinalIgnoreCase) >= 0)
{
shooter_row["MIDDLE"] = addTag(item);
}
else if (item.IndexOf("RANK(", StringComparison.OrdinalIgnoreCase) >= 0)
{
shooter_row["RANK"] = addTag(item);
}
else if (item.IndexOf("TIMESTAMP(", StringComparison.OrdinalIgnoreCase) >= 0)
{
shooter_row["DATE"] = addTag(item);
}
else if (item.IndexOf("SSN(", StringComparison.OrdinalIgnoreCase) >= 0)
{
shooter_row["SSN"] = addTag(item);
}
else if (item.IndexOf("ORDER(", StringComparison.OrdinalIgnoreCase) >= 0)
{
shooter_row["ORDER"] = addTag(item);
}
else if (item.IndexOf("LANE(", StringComparison.OrdinalIgnoreCase) >= 0)
{
shooter_row["LANE"] = addTag(item);
}
/*else if (item.IndexOf("EVID(", StringComparison.OrdinalIgnoreCase) >= 0)
* {
* shooter_row["EVID"] = addTag(item);
* }
* else if (item.IndexOf("GRADER(", StringComparison.OrdinalIgnoreCase) >= 0)
* {
* shooter_row["GRADER"] = addTag(item);
* }
* else if (item.IndexOf("EXERCISE(", StringComparison.OrdinalIgnoreCase) >= 0)
* {
* shooter_row["EXERCISE"] = addTag(item);
* }
* else if (item.IndexOf("RANGE_NAME(", StringComparison.OrdinalIgnoreCase) >= 0)
* {
* shooter_row["RANGE_NAME"] = addTag(item);
* }*/
// Need to add to database under the Shooter table
}
else if (shooterType == "spotter")
{
// Look for indexes while ignoring case and add them to the data tables
if (item.IndexOf("FIRSTNAME(", StringComparison.OrdinalIgnoreCase) >= 0)
{
spotter_row["FIRSTNAME"] = addTag(item);
}
else if (item.IndexOf("LASTNAME(", StringComparison.OrdinalIgnoreCase) >= 0)
{
spotter_row["LASTNAME"] = addTag(item);
}
else if (item.IndexOf("GROUP(", StringComparison.OrdinalIgnoreCase) >= 0)
{
spotter_row["GROUP"] = addTag(item);
}
}
}
// Add to the appropriate table if
if (shooterType == "spotter")
{
dt6.Rows.Add(spotter_row);
}
else if (shooterType == "shooter" || shooterType == "")
{
dt1.Rows.Add(shooter_row);
}
}
}
// Add TARGET
foreach (var line in logLines)
{
if (line.Contains("TARGET:"))
{
target_row = dt5.NewRow();
String[] targetSplit = splitLine(line);
String thisTargetName = "";
String[] groups = { "", "" };
String sGroup = "";
foreach (var item in targetSplit)
{
if (item.IndexOf("RANGE(", StringComparison.OrdinalIgnoreCase) >= 0)
{
target_row["RANGE"] = addTag(item);
}
else if (item.IndexOf("NAME(", StringComparison.OrdinalIgnoreCase) >= 0)
{
thisTargetName = addTag(item);
target_row["NAME"] = thisTargetName;
}
else if (item.IndexOf("GROUP(", StringComparison.OrdinalIgnoreCase) >= 0)
{
groups = addTag(item).Split(' ');
foreach (var piece in groups)
{
if (shooterGroups.Contains(piece))
{
sGroup = piece;
}
}
}
}
// Only add a new row if this target hasn't been added yet
if (!dt5.Rows.Contains(thisTargetName))
{
dt5.Rows.Add(target_row);
}
// add multiple groups
for (int i = 0; i < groups.Length; i++)
{
if (sGroup != groups[i])
{
group_row = dt11.NewRow();
group_row["TARGET_NAME"] = thisTargetName;
group_row["SHOOTER_GROUP"] = sGroup;
group_row["OTHER_GROUP"] = groups[i];
dt11.Rows.Add(group_row);
}
}
}
}
// Add TargetConcealed
foreach (var line in logLines)
{
if (line.Contains("TARGETCONCEALED:"))
{
target_concealed_row = dt10.NewRow();
String[] tarConSplit = splitLine(line);
foreach (var item in tarConSplit)
{
if (item.IndexOf("NAME(", StringComparison.OrdinalIgnoreCase) >= 0)
{
target_concealed_row["NAME"] = addTag(item);
}
if (item.IndexOf("TIMESTAMP(", StringComparison.OrdinalIgnoreCase) >= 0)
{
target_concealed_row["TIMESTAMP"] = addTag(item);
}
if (item.IndexOf("KILL(", StringComparison.OrdinalIgnoreCase) >= 0)
{
target_concealed_row["KILL"] = addTag(item);
}
}
dt10.Rows.Add(target_concealed_row);
}
}
// Add TASKSTART
for (int i = 0; i < logLines.Count; i++)
{
String hitLine = "";
if (logLines.ElementAt(i).Contains("TASKSTART:"))
{
task_start_row = dt3.NewRow();
//table_row = dt12.NewRow();
//task_row = dt13.NewRow();
String[] taskStartSplit = splitLine(logLines.ElementAt(i));
String sTable = "";
String sRow = "";
String sRound = "";
String sTask = "";
foreach (var item in taskStartSplit)
{
if (item.IndexOf("TABLE(", StringComparison.OrdinalIgnoreCase) >= 0)
{
sTable = addTag(item);
//table_row["TABLE_ID"] = sTable;
task_start_row["TABLE"] = sTable;
//task_row["TABLE_ID"] = sTable;
}
if (item.IndexOf("TASK(", StringComparison.OrdinalIgnoreCase) >= 0)
{
sTask = addTag(item);
task_start_row["TASK"] = sTask;
//task_row["TASK_ID"] = sTask;
}
if (item.IndexOf("ROW(", StringComparison.OrdinalIgnoreCase) >= 0) // Range needs to be changed to Row
{
sRow = addTag(item);
task_start_row["ROW"] = sRow;
//task_row["ROW"] = sRow;
}
if (item.IndexOf("ROUND(", StringComparison.OrdinalIgnoreCase) >= 0)
{
sRound = addTag(item);
task_start_row["ROUND"] = sRound;
//task_row["ROUND"] = sRound;
}
if (item.IndexOf("TIMESTAMP(", StringComparison.OrdinalIgnoreCase) >= 0)
{
task_start_row["TIMESTAMP"] = addTag(item);
//task_row["TIMESTAMP"] = addTag(item);
}
}
//Make sure that there are no duplicate rows already in the datatable
// If there are, then they must be deleted from the table.
exp = "TABLE = '" + sTable + "' AND TASK = '" + sTask + "' AND ROW = '" + sRow + "' AND ROUND = '" + sRound + "'";
foundRows = dt3.Select(exp);
//int i = foundRows[0].ToString;
if (foundRows.Length > 0)
{
foundRows[0].Delete();
}
dt3.Rows.Add(task_start_row);
//dt13.Rows.Add(task_row);
/*int j = 0;
* while (!logLines.ElementAt(i + j).Contains("TASKEND:"))
* {
* if (logLines.ElementAt(i + j).Contains("HIT:"))
* {
* hit_row = dt2.NewRow();
* hitLine = logLines.ElementAt(i + j);
* // add hit count here
* String[] hitTaskSplit = splitLine(hitLine);
* foreach (var item in hitTaskSplit)
* {
* if (item.IndexOf("NAME(", StringComparison.OrdinalIgnoreCase) >= 0)
* {
* hit_row["NAME"] = addTag(item);
* }
* else if (item.IndexOf("TIMESTAMP(", StringComparison.OrdinalIgnoreCase) >= 0)
* {
* hit_row["TIMESTAMP"] = addTag(item);
* }
* // Increase hit count of this table/task
*
* }
* hit_row["TASK_ID"] = sTask;
* hit_row["TABLE_ID"] = sTable;
* hit_row["ROW"] = sRow;
* // Increase hit counter of this table/task/row
* string expression = "TASK_ID = " + sTable + " and TABLE_ID = " + sTask;
* DataRow[] selectedRows = dt13.Select(expression);
* if (selectedRows.Count() > 0)
* {
* int counter = (int)selectedRows[0]["HIT_COUNT"];
* counter++;
* selectedRows[0]["HIT_COUNT"] = counter;
* }
* dt2.Rows.Add(hit_row);
* }
* j++;
* }*/
}
}
// Add TargetExposed
foreach (var line in logLines)
{
if (line.Contains("TARGETEXPOSED:"))
{
target_exposed_row = dt9.NewRow();
String[] tarExpSplit = splitLine(line);
foreach (var item in tarExpSplit)
{
if (item.IndexOf("NAME(", StringComparison.OrdinalIgnoreCase) >= 0)
{
target_exposed_row["NAME"] = addTag(item);
}
if (item.IndexOf("TIMESTAMP(", StringComparison.OrdinalIgnoreCase) >= 0)
{
target_exposed_row["TIMESTAMP"] = addTag(item);
}
if (item.IndexOf("ATTRITION(", StringComparison.OrdinalIgnoreCase) >= 0)
{
target_exposed_row["ATTRITION"] = addTag(item);
}
}
dt9.Rows.Add(target_exposed_row);
}
}
// Add TASKEND
/*for (int i = 0; i < logLines.Count; i++)
* {
* String hitLine = "";
* if (logLines.ElementAt(i).Contains("TASKEND:"))
* {
* task_end_row = dt4.NewRow();
* int j = 0;
* while (!logLines.ElementAt(i - j).Contains("TASKSTART:"))
* {
* if (logLines.ElementAt(i - j).Contains("HIT:"))
* {
* hitLine = logLines.ElementAt(i - j);
* // add hit count here
* String[] hitTaskSplit = splitLine(hitLine);
* foreach (var item in hitTaskSplit)
* {
* if (item.IndexOf("NAME(", StringComparison.OrdinalIgnoreCase) >= 0)
* {
* task_end_row["HIT_NAME"] = addTag(item);
* }
* }
* }
* j++;
* }
* String[] taskEndSplit = splitLine(logLines.ElementAt(i));
* String tTable = "";
* String tRange = "";
* String tRound = "";
* String tTask = "";
* foreach (var item in taskEndSplit)
* {
* if (item.IndexOf("TABLE(", StringComparison.OrdinalIgnoreCase) >= 0)
* {
* tTable = addTag(item);
* task_end_row["TABLE"] = tTable;
* }
* if (item.IndexOf("TASK(", StringComparison.OrdinalIgnoreCase) >= 0)
* {
* tTask = addTag(item);
* task_end_row["TASK"] = tTask;
* }
* if (item.IndexOf("ROW(", StringComparison.OrdinalIgnoreCase) >= 0)
* {
* tRange = addTag(item);
* task_end_row["ROW"] = tRange;
* }
* if (item.IndexOf("ROUND(", StringComparison.OrdinalIgnoreCase) >= 0)
* {
* tRound = addTag(item);
* task_end_row["ROUND"] = tRound;
* }
* if (item.IndexOf("TIMESTAMP(", StringComparison.OrdinalIgnoreCase) >= 0)
* {
* task_end_row["TIMESTAMP"] = addTag(item);
* }
* }
*
* //Make sure that there are no duplicate rows already in the datatable
* // If there are, then they must be deleted from the table.
* exp = "TABLE = '" + tTable + "' AND TASK = '" + tTask + "' AND ROW = '" + tRange + "' AND ROUND = '" + tRound + "'";
* foundRows = dt4.Select(exp);
* //int i = foundRows[0].ToString;
* if (foundRows.Length > 0)
* foundRows[0].Delete();
*
* dt4.Rows.Add(task_end_row);
* }
*
* }*/
foreach (var line in logLines)
{
if (line.Contains("TASKEND:"))
{
task_end_row = dt4.NewRow();
String[] taskEndSplit = splitLine(line);
String tTable = "";
String tRange = "";
String tRound = "";
String tTask = "";
foreach (var item in taskEndSplit)
{
if (item.IndexOf("TABLE(", StringComparison.OrdinalIgnoreCase) >= 0)
{
tTable = addTag(item);
task_end_row["TABLE"] = tTable;
}
if (item.IndexOf("TASK(", StringComparison.OrdinalIgnoreCase) >= 0)
{
tTask = addTag(item);
task_end_row["TASK"] = tTask;
}
if (item.IndexOf("ROW(", StringComparison.OrdinalIgnoreCase) >= 0)
{
tRange = addTag(item);
task_end_row["ROW"] = tRange;
}
if (item.IndexOf("ROUND(", StringComparison.OrdinalIgnoreCase) >= 0)
{
tRound = addTag(item);
task_end_row["ROUND"] = tRound;
}
if (item.IndexOf("TIMESTAMP(", StringComparison.OrdinalIgnoreCase) >= 0)
{
task_end_row["TIMESTAMP"] = addTag(item);
}
}
//Make sure that there are no duplicate rows already in the datatable
// If there are, then they must be deleted from the table.
exp = "TABLE = '" + tTable + "' AND TASK = '" + tTask + "' AND ROW = '" + tRange + "' AND ROUND = '" + tRound + "'";
foundRows = dt4.Select(exp);
//int i = foundRows[0].ToString;
if (foundRows.Length > 0)
{
foundRows[0].Delete();
}
dt4.Rows.Add(task_end_row);
}
}
// Add HIT
foreach (var line in logLines)
{
if (line.Contains("HIT:"))
{
hit_row = dt2.NewRow();
String[] hitSplit = splitLine(line);
foreach (var item in hitSplit)
{
if (item.IndexOf("NAME(", StringComparison.OrdinalIgnoreCase) >= 0)
{
hit_row["NAME"] = addTag(item);
}
if (item.IndexOf("TIMESTAMP(", StringComparison.OrdinalIgnoreCase) >= 0)
{
// Find table and task according to the timestamp.
DateTime hitTime = ConvertDateTime(addTag(item));
//string expression = "1=1";
//DataRow[] selectedRows = dt3.Select(expression); //dt3 - taskstart, dt4 - taskend
foreach (var row in dt3.Rows)
{
DateTime taskStartTime = ConvertDateTime(((WindowsFormsApplication1.DataSet1.TASKSTARTRow)(row)).TIMESTAMP);
String taskStartTable = ((WindowsFormsApplication1.DataSet1.TASKSTARTRow)(row)).TABLE;
String taskStartTask = ((WindowsFormsApplication1.DataSet1.TASKSTARTRow)(row)).TASK;
String taskExpression = "TABLE = '" + taskStartTable + "' AND TASK = '" + taskStartTask + "'";
DataRow[] taskEndRows = dt4.Select(taskExpression);
DateTime taskEndTime = ConvertDateTime(((WindowsFormsApplication1.DataSet1.TASKENDRow)(taskEndRows[0])).TIMESTAMP);
// Find the taskstart and taskend objects that the hit timestamp falls between
if (hitTime > taskStartTime && hitTime < taskEndTime)
{
hit_row["TABLE_ID"] = taskStartTable;
hit_row["TASK_ID"] = taskStartTask;
}
}
hit_row["TIMESTAMP"] = hitTime;
}
/*if (item.IndexOf("TABLE(", StringComparison.OrdinalIgnoreCase) >= 0)
* {
* hit_row["TABLE_ID"] = addTag(item);
* }
* if (item.IndexOf("TASK(", StringComparison.OrdinalIgnoreCase) >= 0)
* {
* hit_row["TASK_ID"] = addTag(item);
* }*/
}
dt2.Rows.Add(hit_row);
}
}
// Add MALFUNCTION
foreach (var line in logLines)
{
if (line.Contains("MALFUNCTION:"))
{
malfunction_row = dt7.NewRow();
String[] malSplit = splitLine(line);
foreach (var item in malSplit)
{
if (item.IndexOf("ADDRESS(", StringComparison.OrdinalIgnoreCase) >= 0)
{
malfunction_row["ADDRESS"] = addTag(item);
}
if (item.IndexOf("TIMESTAMP(", StringComparison.OrdinalIgnoreCase) >= 0)
{
malfunction_row["TIMESTAMP"] = addTag(item);
}
if (item.IndexOf("DEFINITION(", StringComparison.OrdinalIgnoreCase) >= 0)
{
malfunction_row["DEFINITION"] = addTag(item);
}
}
dt7.Rows.Add(malfunction_row);
}
}
//Test data
/*for (int i = 1; i < 6; i++)
* {
* table_row = dt12.NewRow();
* table_row["TABLE"] = 1;
* table_row["TASK"] = i.ToString();
* table_row["ROW"] = "Row" + i;
* if (i % 2 == 0)
* {
* table_row["HITS"] = "X";
* }
* table_row["ROUND"] = "None";
* dt12.Rows.Add(table_row);
* }
*
* for (int i = 1; i < 6; i++)
* {
* table_row = dt12.NewRow();
* table_row["TABLE"] = 2;
* table_row["TASK"] = i.ToString();
* table_row["ROW"] = "Row" + i;
* if (i % 3 == 0)
* {
* table_row["HITS"] = "X";
* }
* table_row["ROUND"] = "None";
* dt12.Rows.Add(table_row);
* }*/
AddTaskTimes(dt3, dt4); //dt3 = TASKSTART, dt4 = TASKEND
//AddHitInfo(dt3, dt2, dt11, dt1, dt5); //dt3 = TASKSTART, dt2 = HIT, dt11 = GROUP, dt1 = ID, dt5 = TARGET
ReportDocument cryRpt = new ReportDocument();
sFile = tbFileName.Text;
Console.WriteLine("sFile loaded here " + sFile);
cryRpt.Load(sFile);
crystalReportViewer1.ReportSource = cryRpt;
cryRpt.SetDataSource(ds);
/*ParameterFields paramFields = new ParameterFields();
* ParameterField paramField = new ParameterField();
* ParameterDiscreteValue discreteVal = new ParameterDiscreteValue();
*
* paramField.ParameterFieldName = "IDCode_param";
*
* // Run multiple reports
* for (int i = 0; i < sIDCodes.Count; i++)
* {
* sIDCode = sIDCodes.ElementAt(i);
* //sIDCode = sIDCodes[i];
* discreteVal.Value = sIDCode;
* paramField.CurrentValues.Add(discreteVal);
*
* crystalReportViewer1.ParameterFieldInfo.Clear();
* crystalReportViewer1.ParameterFieldInfo.Add(paramField);
*
* paramField.HasCurrentValue = true;*/
crystalReportViewer1.Refresh();
//}
//cryRpt.PrintToPrinter(1, false, 0, 0);
//MessageBox.Show("Pause", "Go");
//}
}
private void loadPrint()
{
if(commit == "1")
{
string q1 = "select itemCode,itemName,quantity,unitPrice,Amount,sReturn from Sales where salesNo='" + sl + "'";
string q2 = "select salesNo,sDate,total,salesType,creditCardPer,discountPer,vatAmount,grandTotal,receive,change from SalesSummary where salesNo='" + sl + "'";
try
{
aa.Open();
SqlDataAdapter da = new SqlDataAdapter();
da.SelectCommand = new SqlCommand(q1, aa);
DataSet1 mydataset = new DataSet1();
da.Fill(mydataset, "Sales");
da.Dispose();
SqlDataAdapter da2 = new SqlDataAdapter();
da2.SelectCommand = new SqlCommand(q2, aa);
da2.Fill(mydataset, "SalesSummary");
CrystalReport1 myreport = new CrystalReport1();
myreport.SetDataSource(mydataset);
PrintMemo pm = new PrintMemo();
pm.crystalReportViewer1.ReportSource = myreport;
pm.Show();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message.ToString(), "error!!!", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
finally
{
aa.Close();
}
}
else
{
MessageBox.Show("First commit sales by Clicking Save Button!", "error!!!", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void button1_Click_1(object sender, EventArgs e)
{
//dsRpt ds = new dsRpt();
//rpt cry = new rpt();
//SQLCON.openConn();
//SQLCON.sql = "Select * from tblcate";
//SQLCON.cmd = new MySqlCommand(SQLCON.sql, SQLCON.cnn);
//SQLCON.da = new MySqlDataAdapter(SQLCON.cmd);
////SQLCON.cmd.Parameters.AddWithValue(txtInvoiceNo.Text, "@invoiceNo");
//DataTable dt = new DataTable();
//SQLCON.da.Fill(ds.Tables[0]);
//dt = ds.Tables[0];
//cry.SetDataSource(ds.Tables[0]);
//crystalReportViewer1.ReportSource = cry;
//crystalReportViewer1.Refresh();
//this.reportViewer1.RefreshReport();
DataSet1 dsa = new DataSet1();
//SQLCON.openConn();
//SQLCON.sql = "Select * from tblcate";
// SQLCON.cmd = new MySqlCommand("Select * from tblcate", SQLCON.cnn);
SQLCON.da = new MySqlDataAdapter("Select * from tblcate", SQLCON.cnn);
DataTable dt = new DataTable();
SQLCON.da.Fill(dsa, "DataTable1");
//dataGridView1.DataSource = dt;
ReportDataSource rds = new ReportDataSource("DataSet1", dsa.Tables[0]);
// this.reportViewer2.ProcessingMode = ProcessingMode.Local;
this.reportViewer2.LocalReport.DataSources.Clear();
this.reportViewer2.LocalReport.DataSources.Add(rds);
this.reportViewer2.SetDisplayMode(DisplayMode.PrintLayout);
this.reportViewer2.RefreshReport();
///////////// crystal
//crystal cry = new crystal();
//cry.SetDataSource(dsa.Tables[0]);
//crystalReportViewer1.ReportSource = cry;
//this.crystalReportViewer1.RefreshReport();
// Try
// Dim DS As New DataSet_cate
// Dim cnn As New MySqlConnection("Server=192.168.0.8;Database=pos;Uid=root;Pwd=12345678;")
// cnn.Open()
// Dim da As New MySqlDataAdapter("Select * From tbl_cate", cnn)
// da.Fill(DS.Tables(0))
// ReportViewer1.ProcessingMode = Microsoft.Reporting.WinForms.ProcessingMode.Local
// 'ReportViewer1.LocalReport.ReportPath = System.Environment.CurrentDirectory & "\ReportName.rdp"
// ReportViewer1.LocalReport.ReportPath = "D:\My Document\Project\POS 03012017\POS\main\Form\_01_System\Report\rptCate.rdlc"
// ReportViewer1.LocalReport.DataSources.Clear()
// ReportViewer1.LocalReport.DataSources.Add(New Microsoft.Reporting.WinForms.ReportDataSource("DataSet_cate", DS.Tables(0)))
// ReportViewer1.DocumentMapCollapsed = True
// 'parameter
// Dim printBy As New ReportParameter("printBy", fMain.stUser.Text)
// ReportViewer1.LocalReport.SetParameters(printBy)
// ReportViewer1.SetDisplayMode(DisplayMode.PrintLayout)
// Me.ReportViewer1.RefreshReport()
//Catch ex As Exception
// cnn.Close()
// MsgBox(ex.Message)
//End Try
}
private void NewOrder()
{
_ds = null;
lblId.Text = string.Empty;
tbName.Text = string.Empty;
dataGridView1.DataSource = null;
}
private void LoadOrder()
{
//Todo: Remove. For testing purposes
int orderId = 0;
int.TryParse(tbFind.Text, out orderId);
_orderId = orderId;
_ds = new DataSet1();
_ds.Rewards.Merge(_dm.RewardsTableAdapter.GetDataById(orderId));
_ds.RewardRequirements.Merge(_dm.RewardRequirementsTableAdapter.GetDataByRewardId(orderId));
dataGridView1.DataSource = _ds.RewardRequirements;
}
