public int Insert(ReportClass1 report, List <Output> outputsList)
{
int reportId = -1;
try
{
command.CommandText = "INSERT INTO Report1 ([partner],[title],[period],[pyear],[plocation],[apopulation],[tpopulation],[budget],[description],[goal],[objective],[strategies],[tgroups],[participation],[coordination],[challenges],[stories],[engagement],[issues],[sustainability],[risks],[accountability],[minitoring],[uid],[localtimestamp],[remoteid],[remotetimestamp],[mac],[sync_status],[submit_status],[submissiondate]) VALUES(@partner,@title,@period,@pyear,@plocation,@apopulation,@tpopulation,@budget,@description,@goal,@objective,@strategies,@tgroups,@participation,@coordination,@challenges,@stories,@engagement,@issues,@sustainability,@risks,@accountability,@minitoring,@uid,'" + report.Localtimestamp + "',@remoteid,'" + report.Remotetimestamp + "',@mac,0,0,'" + report.Submissiondate + "');";
command.Parameters.AddWithValue("@Partner", report.Partner);
command.Parameters.AddWithValue("@title", report.Title);
command.Parameters.AddWithValue("@period", report.Period);
command.Parameters.AddWithValue("@pyear", report.Pyear);
command.Parameters.AddWithValue("@plocation", report.Plocation);
command.Parameters.AddWithValue("@apopulation", report.Apopulation);
command.Parameters.AddWithValue("@tpopulation", report.Tpopulation);
command.Parameters.AddWithValue("@budget", report.Budget);
command.Parameters.AddWithValue("@description", report.Description);
command.Parameters.AddWithValue("@goal", report.Goal);
command.Parameters.AddWithValue("@objective", report.Objective);
command.Parameters.AddWithValue("@strategies", report.Strategies);
command.Parameters.AddWithValue("@tgroups", report.Tgroups);
command.Parameters.AddWithValue("@participation", report.Participation);
command.Parameters.AddWithValue("@coordination", report.Coordination);
command.Parameters.AddWithValue("@challenges", report.Challenges);
command.Parameters.AddWithValue("@stories", report.Stories);
command.Parameters.AddWithValue("@engagement", report.Engagement);
command.Parameters.AddWithValue("@issues", report.Issues);
command.Parameters.AddWithValue("@sustainability", report.Sustainability);
command.Parameters.AddWithValue("@risks", report.Risks);
command.Parameters.AddWithValue("@accountability", report.Accountability);
command.Parameters.AddWithValue("@minitoring", report.Monitoring);
command.Parameters.AddWithValue("@uid", report.Uid);
//command.Parameters.AddWithValue("@localtimestamp",report.Localtimestamp);
command.Parameters.AddWithValue("@remoteid", report.Remoteid);
//command.Parameters.AddWithValue("@remotetimestamp",report.Remotetimestamp);
command.Parameters.AddWithValue("@mac", report.Mac);
//command.Parameters.AddWithValue("@sync_status",report.Syncstatus);
//command.Parameters.AddWithValue("@submit_status",report.Submitstatus);
//command.Parameters.AddWithValue("@submissiondate", report.Submissiondate);
connection.Open();
//ID=Convert.ToInt32(command.ExecuteScalar());
command.ExecuteNonQuery();
command.CommandText = "SELECT @@IDENTITY";
OleDbDataReader dr = command.ExecuteReader();
while (dr.Read())
{
reportId = Convert.ToInt32(dr[0].ToString());
}
dr.Close();
//command.CommandType = CommandType.Text;
//int ID = command.ExecuteNonQuery();
if (reportId != -1)
{
for (int i = 0; i < outputsList.Count; i++)
{
Output output = (Output)outputsList[i];
OleDbCommand command2 = connection.CreateCommand();
command2.CommandText = "INSERT INTO [Output] ([title],[type],[activityid],[reportid],[plannedm],[plannedf],[actualm],[actualf],[results],[deviation]) VALUES(@title,@type,@activityid,@reportid,@plannedm,@plannedf,@actualm,@actualf,@results,@deviation);";
command2.Parameters.AddWithValue("@title", output.Title);
command2.Parameters.AddWithValue("@type", output.Type);
command2.Parameters.AddWithValue("@activityid", output.Activityid);
command2.Parameters.AddWithValue("@reportid", reportId);
command2.Parameters.AddWithValue("@plannedm", output.Plannedm);
command2.Parameters.AddWithValue("@plannedf", output.Plannedf);
command2.Parameters.AddWithValue("@actualm", output.Actualm);
command2.Parameters.AddWithValue("@actualf", output.Actualf);
command2.Parameters.AddWithValue("@results", output.Results);
command2.Parameters.AddWithValue("@deviation", output.Deviation);
command2.ExecuteNonQuery();
}
}
}
catch (Exception)
{
throw;
}
finally
{
if (connection != null)
{
connection.Close();
}
}
return(reportId);
}
private void button26_Click(object sender, EventArgs e)
{
string partner = (comboBox1.Text).Trim();
string pyear = (comboBox2.Text).Trim();
string title = (textBox1.Text).Trim();
string period = (textBox2.Text).Trim();
string tpopulation = (textBox3.Text).Trim();
string apopulation = (textBox4.Text).Trim();
string plocation = (textBox5.Text).Trim();
string budget = (textBox6.Text).Trim();
string objective = (textBox7.Text).Trim();
string goal = (textBox8.Text).Trim();
string strategies = (textBox9.Text).Trim();
string tgroups = (textBox10.Text).Trim();
string description = (textBox12.Text).Trim();
string participation = (textBox16.Text).Trim();
string coordination = (textBox11.Text).Trim();
string challenges = (textBox13.Text).Trim();
string stories = (textBox14.Text).Trim();
string engagement = (textBox15.Text).Trim();
string issues = (textBox17.Text).Trim();
string sustainability = (textBox18.Text).Trim();
string risks = (textBox19.Text).Trim();
string accountability = (textBox20.Text).Trim();
string monitoring = (textBox21.Text).Trim();
if (ValidateFields())
{
//save report data
report = new ReportClass1();
report.Partner = partner;
report.Pyear = Convert.ToInt32(pyear);
report.Title = title;
report.Period = period;
report.Tpopulation = Convert.ToInt32(tpopulation);
report.Apopulation = Convert.ToInt32(apopulation);
report.Plocation = plocation;
report.Budget = budget;
report.Objective = objective;
report.Goal = goal;
report.Strategies = strategies;
report.Tgroups = tgroups;
report.Description = description;
report.Participation = participation;
report.Coordination = coordination;
report.Challenges = challenges;
report.Stories = stories;
report.Engagement = engagement;
report.Issues = issues;
report.Sustainability = sustainability;
report.Risks = risks;
report.Accountability = accountability;
report.Monitoring = monitoring;
report.Uid = Properties.Settings.Default.UID;
report.Localtimestamp = DateTime.Now;
report.Mac = GetMacAddress();
outputsList = new List <Output>();
ExtractDataGridViewData(output1, outputsList, 1);
ExtractDataGridViewData(output2, outputsList, 2);
ExtractDataGridViewData(output3, outputsList, 3);
panel28.Visible = true;
scrollabalePanel.Enabled = false;
reportInsertBackgroundWorker.RunWorkerAsync();
}
}