public UserOrgObject SaveUserOrg(UserOrgObject userOrg)
{
if (userOrg.UserOrgId > 0) // Update
{
string sql = @"
UPDATE dat_UserOrg
SET EmployeeId = @EmployeeId,
Org = @Org
WHERE UserOrgId = @UserOrgId";
Config.Conn.Execute(sql, userOrg);
}
else
{
if (GetUserOrg(userOrg.EmployeeId, userOrg.Org) == null)
{
string sql = @"
INSERT INTO dat_UserOrg (
EmployeeId,
Org
)
VALUES (
@EmployeeId,
@Org
)
SELECT CAST(SCOPE_IDENTITY() AS INT)";
userOrg.UserOrgId = Config.Conn.Query <int>(sql, userOrg).Single();
}
}
return(userOrg);
}
public bool DeleteUserOrg(UserOrgObject userOrg)
{
try
{
Config.Conn.Execute("DELETE FROM dat_UserOrg WHERE UserOrgId = @UserOrgId", userOrg);
}
catch { return(false); }
return(true);
}