public int DeleteCredentials(EntCredential cred)
{
try
{
using (DbTransaction transaction = Connection.BeginTransaction())
{
using (SqlCeCommand command = Connection.CreateCommand())
{
command.CommandText = @"
DELETE FROM [Credential] where CredentialID = ?";
command.Parameters.Add(new SqlCeParameter("CredentialID",
SqlDbType.Int, 255)).Value = cred.CredentialID;
command.ExecuteNonQuery();
}
transaction.Commit();
}
}
catch (Exception) { }
return 0;
}
private EntCredential DataReaderToObject(SqlCeDataReader reader)
{
EntCredential credential = new EntCredential();
credential.CredentialID = reader.GetInt32(reader.GetOrdinal("CredentialID"));
credential.Username = reader.GetString(reader.GetOrdinal("Username"));
credential.Password = reader.GetString(reader.GetOrdinal("Password"));
credential.CredentialName = reader.GetString(reader.GetOrdinal("CredentialName"));
return credential;
}
public int InsertCredential(EntCredential credential)
{
try
{
using (DbTransaction transaction = Connection.BeginTransaction())
{
using (SqlCeCommand command = Connection.CreateCommand())
{
command.CommandText = @"
INSERT INTO Credential
(Username, Password, CredentialName)
VALUES (?, ?, ?)";
command.Parameters.Add(new SqlCeParameter("Username",
SqlDbType.NVarChar, 255)).Value = credential.Username;
command.Parameters.Add(new SqlCeParameter("Password",
SqlDbType.NVarChar, 255)).Value = credential.Password;
command.Parameters.Add(new SqlCeParameter("CredentialName",
SqlDbType.NVarChar, 255)).Value = credential.CredentialName;
command.ExecuteNonQuery();
}
transaction.Commit();
}
}
catch (Exception){}
return 0;
}
public DBCode UpdateCredential(EntCredential cred)
{
DBCode retCode = DBCode.Ok;
try
{
using (DbTransaction transaction = Connection.BeginTransaction())
{
using (SqlCeCommand command = Connection.CreateCommand())
{
command.CommandText = @"
UPDATE [Credential] SET Username = ?, Password = ?, CredentialName = ? WHERE CredentialID = ?";
command.Parameters.Add(new SqlCeParameter("Username",
SqlDbType.NVarChar, 255)).Value = cred.Username;
command.Parameters.Add(new SqlCeParameter("Password",
SqlDbType.NVarChar, 255)).Value = cred.Password;
command.Parameters.Add(new SqlCeParameter("CredentialName",
SqlDbType.NVarChar, 255)).Value = cred.CredentialName;
command.Parameters.Add(new SqlCeParameter("CredentialID",
SqlDbType.Int, 4)).Value = cred.CredentialID;
command.ExecuteNonQuery();
}
transaction.Commit();
retCode = DBCode.Ok;
}
}
catch (Exception)
{
retCode = DBCode.Error;
}
return retCode;
}
private void btnSave_Click(object sender, EventArgs e)
{
bool bUpdate = false;
EntCredential found = null;
if ( txtCredName.Text == "" || txtCredUsername.Text == "")
{
MessageBox.Show(NAMString.ResourceFormatter.CREDENTIAL_DIALOG_MSGBOX_SAVEERR(),
NAMString.ResourceFormatter.NAM_INF_MESSAGEBOX_HEADER_ERROR(),MessageBoxButtons.OK,
MessageBoxIcon.Error);
return;
}
foreach (ListViewItem item in lstCredential.Items)
{
found = (EntCredential)item.Tag;
if ( found.CredentialName == txtCredName.Text)
{
bUpdate = true;
break;
}
}
if (bUpdate == true && found != null)
{
found.Username = txtCredUsername.Text;
found.Password = txtCredPassword.Text;
found.Operation = DBOperations.Update;
_lstData.Add(found);
selItem = lstCredential.SelectedIndices[0];
}
else
{
EntCredential newCred = new EntCredential();
newCred.CredentialName = txtCredName.Text;
newCred.Username = txtCredUsername.Text;
newCred.Password = txtCredPassword.Text;
newCred.Operation = DBOperations.Insert;
_lstData.Add(newCred);
ListViewItem temp = new ListViewItem();
temp.Text = txtCredName.Text;
temp.Tag = newCred;
lstCredential.Items.Add(temp);
temp = null;
selItem = lstCredential.Items.Count-1;
}
lstCredential.Items[selItem].Selected = true;
//ClearFields();
}
