//ShootingTableTableAdapter taShootingTable = new ShootingTableTableAdapter(); //List<ShootingInfo.ShootingTableRow> lstShootingTable = new List<ShootingInfo.ShootingTableRow>(); public bool insert(ShootingData data) { int insertSuccess = 0; try { connectionObj.Open(); string query = String.Format("INSERT INTO ShootRecord VALUES('" + data.TraineeId + "','" + data.BaNo + "','" + data.ShooterName + "','" + data.Now + "','" + data.Shots + "','" + data.Hits + "','" + data.AvgAccuracy + "','" + data.AvgGrouping + "','" + data.Refex + "','" + data.Summary + "','" + data.FileName + "')"); commandObj = new SqlCommand(query, connectionObj); insertSuccess = commandObj.ExecuteNonQuery(); connectionObj.Close(); if (insertSuccess > 0) { return(true); } else { return(false); } } catch (Exception e) { throw new Exception("Error occured! data connection is not ready", e); } finally { connectionObj.Close(); } }
public void SaveData(ShootingData data) { DatabaseIDU db = new DatabaseIDU(); doneSave = db.insert(data); saveData = false; }
public List <ShootingData> GetShootingDataTrainee(string traineeId) { List <ShootingData> allData = new List <ShootingData>(); try { connectionObj.Open(); string query = String.Format("SELECT * FROM ShootRecord WHERE TraineeId = '" + traineeId + "'"); commandObj = new SqlCommand(query, connectionObj); SqlDataReader readerObj = commandObj.ExecuteReader(); while (readerObj.Read()) { ShootingData data = new ShootingData(); data.Id = readerObj["id"].ToString(); data.TraineeId = readerObj["TraineeId"].ToString(); data.BaNo = readerObj["BaNo"].ToString(); data.ShooterName = readerObj["ShooterName"].ToString(); data.Now = readerObj["DateTime"].ToString(); data.Shots = readerObj["Shots"].ToString(); data.Hits = readerObj["Hits"].ToString(); data.AvgAccuracy = readerObj["AvgAccuracy"].ToString(); data.AvgGrouping = readerObj["AvgGrouping"].ToString(); data.Refex = readerObj["Refex"].ToString(); data.Summary = readerObj["Summary"].ToString(); data.FileName = readerObj["FileName"].ToString(); allData.Add(data); } readerObj.Close(); connectionObj.Close(); } catch (Exception e) { throw new Exception("Error occured data connection is not ready", e); } finally { connectionObj.Close(); } return(allData); }
public void calculateAverage() { hitsLabel.Text = ShootPointController.getController().shotAffected.ToString(); shotsLabel.Text = ShootPointController.getController().shotTaken.ToString(); int tempPoint = 0; for (int i = 0; i < shotPoint.Count; i++) { tempPoint = tempPoint + (int)shotPoint[i]; } //MessageBox.Show("IN One " + ShootPointController.getController().shotPoint.Count.ToString()); if (shotPoint.Count != 0) { tempPoint /= shotPoint.Count; distLabel.Text = tempPoint.ToString(); //MessageBox.Show("IN side"); } //------------------------------------------ groupLabel.Text = groupMaxDistance.ToString(); //------------------------------------------ float maxTime = 0; float minTime = 0; minTime = GAYABE_NUMBER * ShootPointController.getController().shotTaken; maxTime = 24 * ShootPointController.getController().shotTaken; float difference = maxTime - minTime; float avgTime = 0; if (difference != 0) { float tempGayabe = (((float)totalTime) - (GAYABE_NUMBER * ShootPointController.getController().shotTaken)); avgTime = tempGayabe * (ShootPointController.getController().shotTaken / difference); } int result = arannya(avgTime); totalTimeLabel.Text = result.ToString(); //----------------------- // Final Average Value //----------------------- float finalAverage = ((float)(tempPoint + groupMaxDistance + result)) / 2.50F; summury = (short)finalAverage; setImageInGraph(tempPoint, false, accImg); setImageInGraph(groupMaxDistance, false, grpImg); setImageInGraph(result, true, refImg); avgLabel.Text = finalAverage.ToString(); setAverageImage(finalAverage); if (saveData) { if (File.Exists(Login.fileName + VideoProcess.fileNameEnd + "Log.txt")) { File.Delete(Login.fileName + VideoProcess.fileNameEnd + "Log.txt"); } using (System.IO.StreamWriter file = new System.IO.StreamWriter(Login.fileName + VideoProcess.fileNameEnd + "Log.txt", true)) { file.WriteLine("Shooter name :" + Login.ShooterName); file.WriteLine("Shots taken :" + ShootPointController.getController().shotTaken.ToString()); //file.WriteLine("Shots taken :"+shotsTaken.ToString()); file.WriteLine("Hits :" + hitsTergeted.ToString()); file.WriteLine("Average accuracy :" + avgAccuracy.ToString()); file.WriteLine("Average grouping :" + avgGrouping.ToString()); file.WriteLine("Reflex :" + reflex.ToString()); file.WriteLine("Summary :" + summury.ToString()); } ShootingData data = new ShootingData(); data.BaNo = Login.BaNo; data.ShooterName = Login.ShooterName; data.TraineeId = Login.TraineeId; data.Now = DateTime.Now.ToString(); //data.Shots = shotsTaken.ToString(); data.Shots = ShootPointController.getController().shotTaken.ToString(); data.Hits = hitsTergeted.ToString(); data.AvgAccuracy = avgAccuracy.ToString(); data.AvgGrouping = avgGrouping.ToString(); data.Refex = reflex.ToString(); data.Summary = summury.ToString(); data.FileName = VideoProcess.fileNameEnd; VideoProcess.count = 1; SaveData(data); } //DatabaseIDU didu = new DatabaseIDU(); //int inserted = didu.insert(bano, name, datetime, shotsTaken, hitsTergeted, avgAccuracy, avgGrouping, reflex, summury); //if (inserted > 0) //{ // MessageBox.Show("Data has been saved successfully."); //} //else //{ // MessageBox.Show("Data cannot be saved right now,Please try again later."); //} }