internal void CreateMeasurement(Activity activity, string MeasurementResult, string insertedDateOfMeasurement)
{
DateTime dateOfMeasurement = Convert.ToDateTime(insertedDateOfMeasurement);
Double result = Double.Parse(MeasurementResult);
Measurement newMeasurement = new Measurement(activity.Id, result, dateOfMeasurement);
dataQualityAssurance.AddNewMeasurement(activity, newMeasurement);
}
internal void CreateActivity(string name, string location, string reason, string measurementMethod, Employee measurementEmployee, string insertedMeasurementDate,
string insertedMeasurementNumber, string frequencyMeasurementType, string expectedResultMin, string expectedResultMax, string failureAction, Employee failureActionEmployee, string productName)
{
int frequencyMeasurementNumber = Convert.ToInt32(insertedMeasurementNumber);
DateTime measurementDate = Convert.ToDateTime(insertedMeasurementDate);
//public Activity(string name, string location, string reason, string measurementMethod, Employee measurementEmployee, DateTime measurementDate, int frequencyMeasurementNumber,
//string frequencyMeasurementType, double expectedResultMin, double expectedResultMax, string failureAction, string failureActionEmployeeName, double measureMent, string productName)
Activity newActivity = new Activity(name, location, reason, measurementMethod, measurementEmployee, measurementDate,
frequencyMeasurementNumber, frequencyMeasurementType, expectedResultMin, expectedResultMax, failureAction, failureActionEmployee, productName);
dataQualityAssurance.AddNewActivity(newActivity);
}
public string AddNewMeasurement(Activity activity, Measurement newMeasurement)
{
try
{
SqlCommand sqlcmd = new SqlCommand("CreateNewMeasurement", conn);
sqlcmd.CommandType = CommandType.StoredProcedure;
sqlcmd.Parameters.Add(new SqlParameter("@fk_ActivityID", activity.Id));
sqlcmd.Parameters.Add(new SqlParameter("@Result", newMeasurement.Result));
sqlcmd.Parameters.Add(new SqlParameter("@DateOfMeasurement", newMeasurement.DateOfMeasurement));
conn.Open();
sqlcmd.ExecuteNonQuery();
conn.Close();
return "Activity created!";
}
catch (SqlException e)
{
return e.Message;
}
finally
{
conn.Close();
}
}
public string AddNewActivity(Activity activity)
{
try
{
if (conn.State != ConnectionState.Open)
conn.Open();
SqlCommand sqlcmd = new SqlCommand("createNewActivity", conn);
sqlcmd.CommandType = CommandType.StoredProcedure;
sqlcmd.Parameters.Add(new SqlParameter("@Name", activity.Name));
sqlcmd.Parameters.Add(new SqlParameter("@Location", activity.Location));
sqlcmd.Parameters.Add(new SqlParameter("@Reason", activity.Reason));
sqlcmd.Parameters.Add(new SqlParameter("@MeasurementMethod", activity.MeasurementMethod));
sqlcmd.Parameters.Add(new SqlParameter("@fk_MeasurementEmployeeID", activity.MeasurementEmployee.Id));
sqlcmd.Parameters.Add(new SqlParameter("@MeasurementDate", activity.MeasurementDate));
sqlcmd.Parameters.Add(new SqlParameter("@FrequencyMeasurementNumber", activity.FrequencyMeasurementNumber));
sqlcmd.Parameters.Add(new SqlParameter("@FrequencyMeasurementType", activity.FrequencyMeasurementType));
sqlcmd.Parameters.Add(new SqlParameter("@ExpectedMinResult", activity.ExpectedResultMin));
sqlcmd.Parameters.Add(new SqlParameter("@ExpectedMaxResult", activity.ExpectedResultMax));
sqlcmd.Parameters.Add(new SqlParameter("@FailureAction", activity.FailureAction));
sqlcmd.Parameters.Add(new SqlParameter("@fk_FailureActionEmployeeID", activity.FailureActionEmployee.Id));
sqlcmd.Parameters.Add(new SqlParameter("@ProductName", activity.ProductName));
sqlcmd.ExecuteNonQuery();
conn.Close();
return "Activity created!";
}
catch (SqlException e)
{
return e.Message;
}
finally
{
conn.Close();
}
}
public List<Activity> ReadScheduledActivities()
{
List<Activity> activityList = new List<Activity>();
try
{
if (conn.State != ConnectionState.Open)
conn.Open();
SqlCommand sqlcmd = new SqlCommand("GetScheduledActivities", conn);
sqlcmd.CommandType = CommandType.StoredProcedure;
DataTable table = new DataTable();
SqlDataAdapter adapter = new SqlDataAdapter(sqlcmd);
adapter.Fill(table);
SqlDataReader reader = sqlcmd.ExecuteReader();
reader.Read();
foreach (DataRow row in table.Rows)
{
Activity newActivity = new Activity(
row["Name"].ToString(),
row["Location"].ToString(),
row["Reason"].ToString(),
row["MeasurementMethod"].ToString(),
ReadEmployeeFromId(int.Parse(row["fk_MeasurementEmployeeID"].ToString()))[0],
DateTime.Parse(row["MeasurementDate"].ToString()),
int.Parse(row["FrequencyMeasurementNumber"].ToString()),
row["FrequencyMeasurementType"].ToString(),
row["ExpectedMinResult"].ToString(),
row["ExpectedMaxResult"].ToString(),
row["FailureAction"].ToString(),
ReadEmployeeFromId(int.Parse(row["fk_FailureActionEmployeeID"].ToString()))[0],
row["ProductName"].ToString());
newActivity.Id = int.Parse(row["pk_ActivityID"].ToString());
activityList.Add(newActivity);
}
conn.Close();
return activityList;
}
catch (SqlException e)
{
throw e;
}
finally
{
conn.Close();
}
}