/*****
* Purpose: Write one record of CardsExchanged data
*
*
* Parameter list:
* void
*
* Return value:
* int negative on error, 1 if okay
******/
public int WriteOneRecord()
{
int flag = 1;
string sqlCommand;
string date;
if (dateReceived.Length > 0)
{
date = dateReceived;
}
else
{
date = dateSent;
}
sqlCommand = "UPDATE Friends SET LastContact = '" + date + // Build UPDATE command
"' WHERE ID = " + id.ToString();
try
{
clsFriend myData = new clsFriend(connectStr);
flag = myData.ProcessCommand(sqlCommand);
}
catch
{
return(flag);
}
// Build INSERT command
sqlCommand = "INSERT INTO CardsExchanged" +
" (ID,TypeOfCard, Sent, Received) VALUES (";
// Now add the values
sqlCommand += id + "," + cardType + ",'" + dateSent + "','" + dateReceived + "')";
try
{
using (SqlConnection myConnection = new SqlConnection(connectStr))
{
myConnection.Open();
using (SqlCommand myCommand = new SqlCommand(sqlCommand, myConnection))
{
myCommand.ExecuteNonQuery();
}
myConnection.Close();
}
}
catch
{
return(-1); // Something's amiss...
}
return(1);
}
/*****
* Purpose: Save textbox info as a record in Friends table.
*
* Parameter list:
* object sender control that caused the event
* EventArgs e details about the sender
*
* Return value:
* void
******/
private void btnSave_Click(object sender, EventArgs e)
{
int status;
int flag;
string sqlCommand;
if (chkStatus.Checked == true)
{
status = 1;
}
else
{
status = 0;
}
myData = new clsFriend(connectStr);
// Build UPDATE command
sqlCommand = "UPDATE Friends SET " +
"FirstName = '" + txtFirstName.Text + "'," +
"LastName = '" + txtLastName.Text + "'," +
"Addr1 = '" + txtAddr1.Text + "'," +
"Addr2 = '" + txtAddr2.Text + "'," +
"City = '" + txtCity.Text + "'," +
"State = '" + txtState.Text.ToUpper() + "'," +
"Zip = '" + txtZip.Text + "'," +
"LastContact = '" + txtLastContact.Text + "'," +
"Status = " + status.ToString() +
" WHERE ID = " + txtFindRecordNumber.Text;
try
{
flag = myData.ProcessCommand(sqlCommand);
if (flag > 0)
{
MessageBox.Show("Record updated successfully.");
}
else
{
MessageBox.Show("Failed to update data.", "Process Error");
}
}
catch (Exception ex)
{
MessageBox.Show("Error: " + ex.Message);
}
}