public bool DeleteContact(ContactObject contact)
{
try
{
Config.Conn.Execute("DELETE FROM dat_Contact WHERE ContactId = @ContactId", contact);
}
catch { return(false); }
return(true);
}
public static void Add(int mainId, string EmployeeId)
{
ContactObject co = new ContactObject();
co.MainId = mainId;
if (co.SetNames(EmployeeId))
{
co.Save();
}
}
public ContactData(ContactObject co)
{
FirstName = co.Name.FirstName();
MiddleName = co.Name.MiddelName();
LastName = co.Name.LastName();
Phone = co.Phone;
Location = co.Location;
EmployeeId = co.EmployeeId;
WorkOrg = co.WorkOrg;
OrcidId = co.OrcidId;
}
public ContactObject SaveContact(ContactObject contact)
{
if (contact.ContactId > 0) // Update
{
string sql = @"
UPDATE dat_Contact
SET [Name] = @Name,
Phone = @Phone,
Location = @Location,
EmployeeId = @EmployeeId,
WorkOrg = @WorkOrg,
OrcidId = @OrcidId
WHERE ContactId = @ContactId";
Config.Conn.Execute(sql, contact);
}
else
{
string sql = @"
INSERT INTO dat_Contact (
MainId,
[Name],
Phone,
Location,
EmployeeId,
WorkOrg,
OrcidId
)
VALUES (
@MainId,
@Name,
@Phone,
@Location,
@EmployeeId,
@WorkOrg,
@OrcidId
)
SELECT CAST(SCOPE_IDENTITY() AS INT)";
contact.ContactId = Config.Conn.Query <int>(sql, contact).Single();
}
return(contact);
}
